Script STAFF LIST [MYSQL, Skript 2.2] 2.1.000

HiiqhFive · Feb 1, 2017

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)

DEPENDENCIES

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

Read more about this resource...

Deleted member 5254 · Feb 1, 2017

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 said:
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

Deleted member 5254 · Feb 1, 2017

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.

Deleted member 5254 · Feb 1, 2017

HiiqhFive said:
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!!

Deleted member 5254 · Feb 1, 2017

I can't help you according to your Umbaska problem, please post this in the Help section of skUnity.

Adrihun said:
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).

Deleted member 5254 · Feb 1, 2017

HiiqhFive said:
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

Deleted member 5254 · Feb 1, 2017

In future updates maybe.

Deleted member 5254 · Feb 1, 2017

HiiqhFive said:
In future updates maybe.

Ok do i need to setup Skript config mysql aswell?
Also can you give me the link to that forum cus im new and its confusing

Deleted member 5254 · Feb 1, 2017

No you don't have to. You just have to setup the connection in the script, not in the Skript config in General!

Deleted member 5254 · Feb 1, 2017

HiiqhFive said:
No you don't have to. You just have to setup the connection in the script, not in the Skript config in General!

Do i have to setup the mysql or the "pass and username" inside umbaska config?

Deleted member 5254 · Feb 1, 2017

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

Deleted member 5254 · Feb 1, 2017

HiiqhFive said:
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?

Deleted member 5254 · Feb 1, 2017

Deleted member 5254 · Feb 2, 2017

HiiqhFive said:
HiiqhFive updated STAFF LIST [MYSQL, Skript 2.2] with a new update entry:

Update 2.0.230a

Read the rest of this update entry...

HELP
http://pastebin.com/Mv6A9BWQ

Deleted member 5254 · Feb 2, 2017

HiiqhFive updated STAFF LIST [MYSQL, Skript 2.2] with a new update entry:

Update 2.0.230a

several bugfixes

Read the rest of this update entry...

Deleted member 5254 · Feb 2, 2017

HiiqhFive said:
HiiqhFive updated STAFF LIST [MYSQL, Skript 2.2] with a new update entry:

Update 2.0.230a

Read the rest of this update entry...

can you add a feature so it says : ONLINE: ON SERVER LOBBY-1

Deleted member 5254 · Feb 3, 2017

Adrihun said:
HELP
http://pastebin.com/Mv6A9BWQ

Delete the current database and download the latest version of the script.

Deleted member 5254 · Feb 3, 2017

HiiqhFive updated STAFF LIST [MYSQL, Skript 2.2] with a new update entry:

Update 2.0.310

added "/team delete_database" for wiping complete table.

added 2 new options: "server_name" and "server_name_offline"

table expanded by "server_name".

fixxed non-existing ID-Bug.

New: Showing server name in UI.

Read the rest of this update entry...

Deleted member 5254 · Feb 3, 2017

HiiqhFive said:
HiiqhFive updated STAFF LIST [MYSQL, Skript 2.2] with a new update entry:

Update 2.0.310

Read the rest of this update entry...

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]

HiiqhFive said:
HiiqhFive updated STAFF LIST [MYSQL, Skript 2.2] with a new update entry:

Update 2.0.310

Read the rest of this update entry...

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" ?

Deleted member 5254 · Feb 3, 2017

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

Search

Search

Script STAFF LIST [MYSQL, Skript 2.2] 2.1.000

Welcome to skUnity!

HiiqhFive

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254

Deleted member 5254