skUnity Parser

# #!                                   ________________________
# #!                              ___________________________________
#                                             Team System
#                                         © Made by HiiqhFive™
#                                               v2.1.000
# #!                              ___________________________________
# #!                                   ________________________

# ** _________________________________________________________________________________________________ **
# **                                            CONFIG                                                   **

options:
    server_name: Lobby                                                # // Server name will be displayed if staff member is online.
    server_name_offline: ---                                        # // Text which will be displayed if staff member is offline.
    table: team                                                        # // name of the table in database.

prefix: &8[&cTeam&8]                                            # // displays prefix.
    command: /hteam                                                    # // command for setting everything up.
    team_permission: hiiqhfive.team                                    # // permission to get identified as a staff member.
    permission: *                                                    # // permission to add/edit/remove staff member.

version: 2.1.000                                                # // version of the plugin. [DON'T CHANGE IT!]

prefix_owner: &3&l&oOwner                                        # // owner prefix displayed in UI.
    prefix_admin: &4&l&oAdministrator                                # // admin prefix displayed in UI.
    prefix_mod: &3&l&oModerator                                        # // moderator prefix displayed in UI.
    prefix_supp: &b&l&oSupporter                                    # // supporter prefix displayed in UI.

placeholder_owner: red stained glass pane                        # // placeholder for not occupied places (owner)
    placeholder_admin: orange stained glass pane                    # // placeholder for not occupied places (admin)
    placeholder_mod: light green stained glass pane                    # // placeholder for not occupied places (moderator)
    placeholder_supp: blue stained glass pane                        # // placeholder for not occupied places (supporter)

inventory_name: &cStaff

# // Automaticly sets up a table if not exists
on load:
    # CHANGE THE CREDENTIALS!
    set mysql host to "localhost"
    set mysql username to "hiiqhfive"
    set mysql password to "T5hpj7$3"
    set mysql database to "tests"
    wait a tick
    mysql update "CREATE TABLE IF NOT EXISTS `team` ( `id` INT(11) NOT NULL AUTO_INCREMENT , `name` VARCHAR(255) NOT NULL , `uuid` VARCHAR(255) NOT NULL , `rank` VARCHAR(255) NOT NULL , `online` VARCHAR(255) NOT NULL , `server_name` VARCHAR(255) NOT NULL , PRIMARY KEY (`id`), UNIQUE (`uuid`), UNIQUE (`name`))"

# ** _________________________________________________________________________________________________ **
# **                                            FUNCTIONS                                                  **
# start functions

# // Stores a staff member to the table. Edits automaticly already existing staff members
function sql_update(name:text, uuid:text, rank: text) :: text:
    set {_query} to mysql result of query "SELECT * FROM team WHERE name = '%{_name}%'"
    set {_results::*} to mysql string "name" in {_query}
    set {_result} to false
    loop {_results::*}:
        If loop-value is {_name}:
            set {_result} to true
    If {_result} is false:
        mysql update "INSERT INTO `team` (`name`,`uuid`,`rank`,`online`) VALUES ('%{_name}%', '%{_uuid}%', '%{_rank}%', 'OFFLINE')"
        return "{@prefix} &7Staff member &c%{_name}% &7as &b%{_rank}% &7registered."
    else:
        mysql update "UPDATE `team` SET `rank` = '%{_rank}%' WHERE `team`.`name` ='%{_name}%'"
        return "{@prefix} &7Staff member &c%{_name}% &7as &b%{_rank}% &7updated."

# // removes a staff member from staff list
function sql_remove(name: text) :: text:
    set {_query} to mysql result of query "SELECT * FROM team WHERE name = '%{_name}%'"
    set {_results::*} to mysql string "name" in {_query}
    set {_result} to false
    loop {_results::*}:
        If loop-value is {_name}:
            set {_result} to true
    If {_result} is true:
        mysql update "DELETE FROM team WHERE name = '%{_name}%'"
        return "{@prefix} &7Player &c%{_name}% &7successfully deleted."
    else:
        return "{@prefix} &7Player &c%{_name}% &7is not registered in staff list."

# // checks player if he's a staff member
function sql_read(name:text) :: text:
    set {_query} to mysql result of query "SELECT * FROM team WHERE name = '%{_name}%'"
    set {_results::*} to mysql string "rank" in {_query}
    delete {_result}
    loop {_results::*}:
        If loop-value is set:
            set {_result} to loop-value
    If {_result} is set:
        return "{@prefix} &7Player &c%{_name}% &7is registered as &b%{_result}%&7."
    else:
        return "{@prefix} &7Player &c%{_name}% &7isn't registered in staff list."

function formatTeam(player: player):
    set {_slot} to -1
    loop 36 times:
        add 1 to {_slot}
        {_slot} is between 0 and 8:
            set slot {_slot} of {_player}'s current inventory to {@placeholder_owner} with name "&8Owner"
        {_slot} is between 9 and 17:
            set slot {_slot} of {_player}'s current inventory to {@placeholder_admin} with name "&8Administrator"
        {_slot} is between 18 and 26:
            set slot {_slot} of {_player}'s current inventory to {@placeholder_mod} with name "&8Moderator"
        {_slot} is between 27 and 35:
            set slot {_slot} of {_player}'s current inventory to {@placeholder_supp} with name "&8Supporter"

function wipeDatabase(x: int = 0) :: text:
    mysql update "DROP table team"
    return "{@prefix} &aDatabase cleared. Reloading script."

# end functions

# ** _________________________________________________________________________________________________ **
# **                                            SKRIPT                                                    **

command {@command} [<text>] [<text>] [<text>] [<text>]:
    trigger:
        arg 1 is not set:
            send "{@prefix} &cLoading staff list..."
            $ thread
            set {_query} to mysql result of query "SELECT * FROM team WHERE rank='Owner'"
            set {_results.owner::*} to mysql string "name" in {_query}
            $ thread
            set {_query} to mysql result of query "SELECT * FROM team WHERE rank='Administrator'"
            set {_results.admin::*} to mysql string "name" in {_query}
            $ thread
            set {_query} to mysql result of query "SELECT * FROM team WHERE rank='Moderator'"
            set {_results.mod::*} to mysql string "name" in {_query}
            $ thread
            set {_query} to mysql result of query "SELECT * FROM team WHERE rank='Supporter'"
            set {_results.supp::*} to mysql string "name" in {_query}
            open chest with 4 rows named "{@inventory_name}" to player
            wait 1 tick
            formatTeam(player)
            set {_slot} to -1
            loop {_results.owner::*}:
                add 1 to {_slot}
                set {_skull} to "%loop-value%" parsed as offline player
                {team::%loop-value%} is not set:
                    set {team::%loop-value%} to "&cOFFLINE"
                {team::server::%loop-value%} is not set:
                    set {team::server::%loop-value%} to "---"
                set slot {_slot} of player's current inventory to {_skull}'s skull named "{@prefix_owner} &7%loop-value%" with lore "%{team::%loop-value%}% &e(&c%{team::server::%loop-value%}%&e)"
            set {_slot} to 8
            loop {_results.admin::*}:
                add 1 to {_slot}
                set {_skull} to "%loop-value%" parsed as offline player
                {team::%loop-value%} is not set:
                    set {team::%loop-value%} to "&cOFFLINE"
                {team::server::%loop-value%} is not set:
                    set {team::server::%loop-value%} to "---"
                set slot {_slot} of player's current inventory to {_skull}'s skull named "{@prefix_admin} &7%loop-value%" with lore "%{team::%loop-value%}% &e(&c%{team::server::%loop-value%}%&e)"
            set {_slot} to 17
            loop {_results.mod::*}:
                add 1 to {_slot}
                set {_skull} to "%loop-value%" parsed as offline player
                {team::%loop-value%} is not set:
                    set {team::%loop-value%} to "&cOFFLINE"
                {team::server::%loop-value%} is not set:
                    set {team::server::%loop-value%} to "---"
                set slot {_slot} of player's current inventory to {_skull}'s skull named "{@prefix_mod} &7%loop-value%" with lore "%{team::%loop-value%}% &e(&c%{team::server::%loop-value%}%&e)"
            set {_slot} to 26
            loop {_results.supp::*}:
                add 1 to {_slot}
                set {_skull} to "%loop-value%" parsed as offline player
                {team::%loop-value%} is not set:
                    set {team::%loop-value%} to "&cOFFLINE"
                {team::server::%loop-value%} is not set:
                    set {team::server::%loop-value%} to "---"
                set slot {_slot} of player's current inventory to {_skull}'s skull named "{@prefix_supp} &7%loop-value%" with lore "%{team::%loop-value%}% &e(&c%{team::server::%loop-value%}%&e)"

else:
            player has permission "{@permission}":
                arg 1 is "help":
                    send "&7~~~~~~~~~~~~~~ &9TEAM-HELP &7~~~~~~~~~~~~~~"
                    send "                     &7Version: {@version} &8| &7© by HiiqhFive."
                    send "&6&m-----------------------------------------------------"
                    send "&4» /&fteam &8add &e<Player> &6<Rank> &8- &7Register a staff member."
                    send "&4» /&fteam &8remove &e<Player> &8- &7Remove a staff member."
                    send "&4» /&fteam &8check &e<Player> &8- &7Check player."
                    send "&4» /&fteam &4delete_database &8- &7Wipe database."

arg 1 is "add":
                    arg 2 is set:
                        arg 3 is set:
                            arg 3 is "Owner", "Administrator", "Admin", "Moderator", "Mod" or "Supporter":
                                set {_name} to "%arg 2%" parsed as offline player
                                set {_uuid} to "%{_name}'s uuid%"
                                set {_message} to sql_update(arg 2, {_uuid}, arg 3)
                                send {_message}
                            else:
                                send "{@prefix} &7Ranks: &cOwner, Admin, Moderator, Supporter"
                        else:
                            send "&4» /&fteam &8add &e<Player> &6<Rank> &8- &7Register a staff member."
                    else:
                        send "&4» /&fteam &8add &e<Player> &6<Rank> &8- &7Register a staff member."

arg 1 is "remove":
                    arg 2 is set:
                        set {_message} to sql_remove(arg 2)
                        send {_message}
                    else:
                        send "&4» /&fteam &8remove &e<Player> &8- &7Remove a staff member."

arg 1 is "check":
                    arg 2 is set:
                        set {_message} to sql_read(arg 2)
                        send {_message}
                    else:
                        send "&4» /&fteam &8check &e<Player> &8- &7Check player."

arg 1 is "delete_database":
                    set {_message} to wipeDatabase()
                    send {_message}
                    wait a second
                    execute player command "/sk reload %script%"
            else:
                execute player command "{@command}"

on join:
    player has permission "{@team_permission}":
        set {team::%player%} to "&aONLINE"
        set {team::server::%player%} to "SERVER"
        $ thread
        set {_query} to mysql result of query "SELECT * FROM team"
        set {_team::*} to mysql string "name" in {_query}
        delete {_result}
        loop {_team::*}:
            "%loop-value%" is "%player%":
                $ thread
                mysql update "UPDATE `team` SET `online` = 'ONLINE', `server_name` = 'SERVER' WHERE `team`.`name` ='%player%'"
    else:
        delete {team::%player%}
        delete {team::server::%player%}

on quit:
    player has permission "{@team_permission}":
        set {team::%player%} to "&cOFFLINE"
        set {team::server::%player%} to "---"
        $ thread
        set {_query} to mysql result of query "SELECT * FROM team"
        set {_team::*} to mysql string "name" in {_query}
        delete {_result}
        loop {_team::*}:
            "%loop-value%" is "%player%":
                $ thread
                mysql update "UPDATE `team` SET `online` = 'OFFLINE', `server_name` = '---' WHERE `team`.`name` ='%player%'"
    else:
        delete {team::%player%}
        delete {team::server::%player%}

on unload:
    mysql update "UPDATE `team` SET `online` = 'OFFLINE', `server_name` = '---' WHERE `team`.`online` ='ONLINE'"
    wait a tick
    disconnect from mysql

on inventory click:
    inventory name of player's current inventory contains "{@inventory_name}":
        cancel the event

Paste Info

Paste ID: 109 / STAFF LIST [MYSQL, Skript 2.2]

Author: HiiqhFive

Privacy setting: anyone

Posted at: 01/02/2017 09:28:42pm

Indent Settings

Change how the Parser indents text. These settings are saved in your browser and will save when you change either option

Parse Results (0)

Write some code to get parse results

Commands (0)

No commands found

Functions (0)

No functions found

Detected Addons (0)

No addons detected

Variables (0)

No variables used yet

Skriptathon

Resource Search Spigot Resource Search

File Manager

Resource Search Spigot Resource Search

Resource Search

Search for Resources on the Forums and load them into the Parser

Enter a Resource ID or search for a Resource by its title

Spigot Resource Search

Search for Resources on Spigot and load them into the Parser

Search for a Resource by its title

Settings

Parser Experiments

Features currently in development for the Parser!

Features below can be tested before their full release. Please be aware that these features aren't fully tested, might be missing certain aspects such as frontend design or might not properly work. All feedback is gladly welcomed but negative comments for no reason won't be listened too. These features aren't intended to be released yet. Please note that when you enable or disable any Experiments, the page will refresh for the changes to take effect.

Manage Collections

Doing any changes to your Collections or creating a new Collection will refresh the page. Make sure you've saved any work beforehand.

Collection name

My Saves (1)

You don't have any pastes. Why not create one?

skUnity Connect

Shared with me (1)

There are no pastes shared with you.

Manage specific users

Intilising user management... please wait

Loading profile...

Public pastes skUnity Resources Forums profile

User Pastes

User skUnity Resources