STAFF LIST [MYSQL, Skript 2.2]

Script STAFF LIST [MYSQL, Skript 2.2] 2.1.000

  • Welcome to skUnity!

    Welcome to skUnity! This is a forum where members of the Skript community can communicate and interact. Skript Resource Creators can post their Resources for all to see and use.

    If you haven't done so already, feel free to join our official Discord server to expand your level of interaction with the comminuty!

    Now, what are you waiting for? Join the community now!

HiiqhFive

Supporter
Feb 1, 2017
130
28
28
25
Germany
HiiqhFive submitted a new resource:

STAFF LIST [MYSQL, Skript 2.2] - A MySQL supported staff list with User Interface!

STAFF LIST WITH UI!
for Skript 2.2

By using this script you can list all your staff members in a clear user interface.
Using a MySQL-Database offers you to display every staff member on a website (not included yet)


law_trennlinie.png

DEPENDENCIES

• Skript (at least version 2.2)
• Umbaska
• A MySQL Database
...

Read more about this resource...
 
help
code_language.skript:
[21:45:10 WARN]: java.sql.SQLException: Access denied for user 'umbaska'@'localhost' (using password: YES)
[21:45:10 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
[21:45:10 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
[21:45:10 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
[21:45:10 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
[21:45:10 WARN]:        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
[21:45:10 WARN]:        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
[21:45:10 WARN]:        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
[21:45:10 WARN]:        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
[21:45:10 WARN]:        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
[21:45:10 WARN]:        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
[21:45:10 WARN]:        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[21:45:10 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[21:45:10 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[21:45:10 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[21:45:10 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[21:45:10 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[21:45:10 WARN]:        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
[21:45:10 WARN]:        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
[21:45:10 WARN]:        at java.sql.DriverManager.getConnection(Unknown Source)
[21:45:10 WARN]:        at java.sql.DriverManager.getConnection(Unknown Source)
[21:45:10 WARN]:        at com.w00tmast3r.skquery.db.ScriptCredentials.validate(ScriptCredentials.java:69)
[21:45:10 WARN]:        at com.w00tmast3r.skquery.db.ScriptCredentials.setPassword(ScriptCredentials.java:36)
[21:45:10 WARN]:        at com.w00tmast3r.skquery.elements.effects.EffOptionSQLPassword.register(EffOptionSQLPassword.java:20)
[21:45:10 WARN]:        at com.w00tmast3r.skquery.elements.effects.base.Pragma.init(Pragma.java:24)
[21:45:10 WARN]:        at com.w00tmast3r.skquery.elements.effects.base.OptionsPragma.init(OptionsPragma.java:18)
[21:45:10 WARN]:        at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:249)
[21:45:10 WARN]:        at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:176)
[21:45:10 WARN]:        at ch.njol.skript.lang.Statement.parse(Statement.java:61)
[21:45:10 WARN]:        at ch.njol.skript.ScriptLoader.loadItems(ScriptLoader.java:754)
[21:45:10 WARN]:        at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:513)
[21:45:10 WARN]:        at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:247)
[21:45:10 WARN]:        at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:201)
[21:45:10 WARN]:        at ch.njol.skript.Skript$2.run(Skript.java:406)
[21:45:10 WARN]:        at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)
[21:45:10 WARN]:        at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:350)
[21:45:10 WARN]:        at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:723)
[21:45:10 WARN]:        at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374)
[21:45:10 WARN]:        at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)
[21:45:10 WARN]:        at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)
[21:45:10 WARN]:        at java.lang.Thread.run(Unknown Source)
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 53: set {_results::*} to objects in column "name" from result of query "SELECT * FROM {@Table} WHERE name = '%{_name}%'" and close')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 59: update "INSERT INTO `{@Table}` (`name`,`uuid`,`rank`,`online`) VALUES ('%{_name}%', '%{_uuid}%', '%{_rank}%', 'OFFLINE')"')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 62: update "UPDATE `{@Table}` SET `rank` = '%{_rank}%' WHERE `{@Table}`.`name` ='%{_name}%'"')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 67: set {_results::*} to objects in column "name" from result of query "SELECT * FROM {@Table} WHERE name = '%{_name}%'" and close')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 73: update "DELETE FROM {@Table} WHERE name = '%{_name}%'"')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 80: set {_results::*} to objects in column "rank" from result of query "SELECT * FROM {@Table} WHERE name = '%{_name}%'" and close')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 111: update "CREATE TABLE IF NOT EXISTS `{@Table}` (`name` varchar(255),`uuid` varchar(255),`rank` varchar(255),`online` varchar(255))"')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 112: update "ALTER TABLE {@Table} ADD UNIQUE (id, name)"')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 113: update "ALTER TABLE {@Table} ADD id int NOT NULL AUTO_INCREMENT primary key FIRST"')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 120: set {_results.owner::*} to objects in column "name" from result of query "SELECT * FROM {@Table} WHERE rank='Owner'" and close')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 122: set {_results.admin::*} to objects in column "name" from result of query "SELECT * FROM {@Table} WHERE rank='Administrator'" and close')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 124: set {_results.mod::*} to objects in column "name" from result of query "SELECT * FROM {@Table} WHERE rank='Moderator'" and close')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 126: set {_results.supp::*} to objects in column "name" from result of query "SELECT * FROM {@Table} WHERE rank='Supporter'" and close')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 204: set {_team::*} to objects in column "name" from result of query "SELECT * FROM {@Table}" and close')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 209: update "UPDATE `{@Table}` SET `online` = 'ONLINE' WHERE `{@Table}`.`name` ='%player%'"')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 217: set {_team::*} to objects in column "name" from result of query "SELECT * FROM {@Table}" and close')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 222: update "UPDATE `{@Table}` SET `online` = 'OFFLINE' WHERE `{@Table}`.`name` ='%player%'"')
[21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 227: update "UPDATE `{@Table}` SET `online` = 'OFFLINE' WHERE `{@Table}`.`online` ='ONLINE'"')
[21:45:11 INFO]: > Tablist Prefix Enabled
[21:45:11 INFO]: > Teleport Enabled
[21:45:11 INFO]: [Skript] Loaded 16 scripts with a total of 54 triggers and 13 commands in 1.97 seconds
[21:45:11 INFO]: [Skript] Finished loading.
>
[doublepost=1485985954,1485985607][/doublepost]
HiiqhFive submitted a new resource:

STAFF LIST [MYSQL, Skript 2.2] - A MySQL supported staff list with User Interface!



Read more about this resource...
bump
 
code_language.skript:
[Skript] Database features are disabled until the script has SQL credentials associated with it.

It already explains your error. You have to setup the database in this script.
Just open the spoiler "how to setup a database connection" in the overview page or read the same text inside the script.
 
code_language.skript:
[Skript] Database features are disabled until the script has SQL credentials associated with it.

It already explains your error. You have to setup the database in this script.
Just open the spoiler "how to setup a database connection" in the overview page or read the same text inside the script.
oh. alright. Thank you!
BTW I seen that your skript needs Umbaska. But i am having some troubles setting it up. Could you please help me?
Here is my latest.txt (log file) http://pastebin.com/QNp0K2P8

EDIT: After i added Umbaska, a lot of my scripts gave me errors. When i removed Umbaska, they worked again

EDIT 2: I didn't setup mysql in Skript config. Do i have to set it up there aswell? Also, if i do have to set it up there aswell, do i need to create a different database (so two databases, one called skript and the other called staff or smthing)

code_language.skript:
        # == MySQL configuration ==
        host: localhost# Where the database server is located at, e.g. 'example.com', 'localhost', or '192.168.1.100'
        port: 3306# 3306 is MySQL's default port, i.e. you likely won't need to change this value
        user: root
        password: pass
        database: skript# The database to use. Skript will automatically create a table 'variables21' in this database if it doesn't exist
        # (If the table exists but is defined differently that how Skript expects it to be you'll get errors and no variables will be saved and/or loaded)



Please reply. I don't have a lot of time. Thanks!!
 
I can't help you according to your Umbaska problem, please post this in the Help section of skUnity.

EDIT 2: I didn't setup mysql in Skript config. Do i have to set it up there aswell? Also, if i do have to set it up there aswell, do i need to create a different database (so two databases, one called skript and the other called staff or smthing)

No, there is not a Configuration of the Skript config required.
Open the script, search for "script options" and use your credentials of your MySQL Database (mostly documentated in the webinterface of your hoster).
 
I can't help you according to your Umbaska problem, please post this in the Help section of skUnity.



No, there is not a Configuration of the Skript config required.
Open the script, search for "script options" and use your credentials of your MySQL Database (mostly documentated in the webinterface of your hoster).
ok also will you add more ranks to it like TRAINEE, BUILDER
 
You have to setup everything in the script located at plugins\Skript\scripts\<script>.sk
Open the Script you've downloaded HERE on my resource page -> Go to Line 41

code_language.skript:
script options:
    $ db url jdbc:mysql://HOST:PORT/DATABASE
    $ db username USERNAME
    $ db password PASSWORD

HOST = IP-Address of your MySQL-Database
PORT = 3306
DATABASE = Name of database given from your hoster
Username = Name of user which has access to your database
Password = Self-explanatory
 
You have to setup everything in the script located at plugins\Skript\scripts\<script>.sk
Open the Script you've downloaded HERE on my resource page -> Go to Line 41

code_language.skript:
script options:
    $ db url jdbc:mysql://HOST:PORT/DATABASE
    $ db username USERNAME
    $ db password PASSWORD

HOST = IP-Address of your MySQL-Database
PORT = 3306
DATABASE = Name of database given from your hoster
Username = Name of user which has access to your database
Password = Self-explanatory
Yea ik but do i have to edit the umbaska config?
 
i updated your skript.
[15:55:41 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'id'
[15:55:41 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[15:55:41 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[15:55:41 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[15:55:41 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[15:55:41 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[15:55:41 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:382)
[15:55:41 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
[15:55:41 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
[15:55:41 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
[15:55:41 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
[15:55:41 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
[15:55:41 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
[15:55:41 WARN]: at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
[15:55:41 WARN]: at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
[15:55:41 WARN]: at com.w00tmast3r.skquery.elements.effects.EffSQLUpdate.execute(EffSQLUpdate.java:32)
[15:55:41 WARN]: at ch.njol.skript.lang.Effect.run(Effect.java:54)
[15:55:41 WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:65)
[15:55:41 WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:93)
[15:55:41 WARN]: at ch.njol.skript.lang.Trigger.execute(Trigger.java:53)
[15:55:41 WARN]: at ch.njol.skript.events.EvtScript.register(EvtScript.java:63)
[15:55:41 WARN]: at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:519)
[15:55:41 WARN]: at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:247)
[15:55:41 WARN]: at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:201)
[15:55:41 WARN]: at ch.njol.skript.Skript$2.run(Skript.java:406)
[15:55:41 WARN]: at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)
[15:55:41 WARN]: at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:350)
[15:55:41 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:723)
[15:55:41 WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374)
[15:55:41 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)
[15:55:41 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)
[15:55:41 WARN]: at java.lang.Thread.run(Unknown Source)
[15:55:41 WARN]: [Skript] Possible name conflict of variables {team::*} and {team::%player%} (there might be more conflicts). (Team.sk, line 227: set {_team::*} to objects in column "name" from result of query "SELECT * FROM {@table}" and close')
[doublepost=1486137676,1486137401][/doublepost]
How does the "Server" thing work on your script?
If i put script on my PvP server, And on my lobby. And im on PvP, the player on lobby will see "ONLINE: PvP" ?
 
If you have the latest version, use the command /team delete_database. After that this script should work.

If you have a network, upload the script to every single server and change the option "server_name" to the servers name, for example:
- Lobbyserver >> option change to "Lobby"
- Pvpserver >> option change to "Pvp