help

Code (Skript):

1. [21:45:10 WARN]: java.sql.SQLException: Access denied for user 'umbaska'@'localhost' (using password: YES)
2. [21:45:10 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
3. [21:45:10 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
4. [21:45:10 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
5. [21:45:10 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
6. [21:45:10 WARN]:        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
7. [21:45:10 WARN]:        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
8. [21:45:10 WARN]:        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
9. [21:45:10 WARN]:        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
10. [21:45:10 WARN]:        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
11. [21:45:10 WARN]:        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
12. [21:45:10 WARN]:        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
13. [21:45:10 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
14. [21:45:10 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
15. [21:45:10 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
16. [21:45:10 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
17. [21:45:10 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
18. [21:45:10 WARN]:        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
19. [21:45:10 WARN]:        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
20. [21:45:10 WARN]:        at java.sql.DriverManager.getConnection(Unknown Source)
21. [21:45:10 WARN]:        at java.sql.DriverManager.getConnection(Unknown Source)
22. [21:45:10 WARN]:        at com.w00tmast3r.skquery.db.ScriptCredentials.validate(ScriptCredentials.java:69)
23. [21:45:10 WARN]:        at com.w00tmast3r.skquery.db.ScriptCredentials.setPassword(ScriptCredentials.java:36)
24. [21:45:10 WARN]:        at com.w00tmast3r.skquery.elements.effects.EffOptionSQLPassword.register(EffOptionSQLPassword.java:20)
25. [21:45:10 WARN]:        at com.w00tmast3r.skquery.elements.effects.base.Pragma.init(Pragma.java:24)
26. [21:45:10 WARN]:        at com.w00tmast3r.skquery.elements.effects.base.OptionsPragma.init(OptionsPragma.java:18)
27. [21:45:10 WARN]:        at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:249)
28. [21:45:10 WARN]:        at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:176)
29. [21:45:10 WARN]:        at ch.njol.skript.lang.Statement.parse(Statement.java:61)
30. [21:45:10 WARN]:        at ch.njol.skript.ScriptLoader.loadItems(ScriptLoader.java:754)
31. [21:45:10 WARN]:        at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:513)
32. [21:45:10 WARN]:        at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:247)
33. [21:45:10 WARN]:        at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:201)
34. [21:45:10 WARN]:        at ch.njol.skript.Skript$2.run(Skript.java:406)
35. [21:45:10 WARN]:        at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)
36. [21:45:10 WARN]:        at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:350)
37. [21:45:10 WARN]:        at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:723)
38. [21:45:10 WARN]:        at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374)
39. [21:45:10 WARN]:        at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)
40. [21:45:10 WARN]:        at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)
41. [21:45:10 WARN]:        at java.lang.Thread.run(Unknown Source)
42. [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')
43. [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')"')
44. [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}%'"')
45. [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')
46. [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}%'"')
47. [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')
48. [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))"')
49. [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)"')
50. [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"')
51. [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')
52. [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')
53. [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')
54. [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')
55. [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')
56. [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%'"')
57. [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')
58. [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%'"')
59. [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'"')
60. [21:45:11 INFO]: > Tablist Prefix Enabled
61. [21:45:11 INFO]: > Teleport Enabled
62. [21:45:11 INFO]: [Skript] Loaded 16 scripts with a total of 54 triggers and 13 commands in 1.97 seconds
63. [21:45:11 INFO]: [Skript] Finished loading.
64. >

--- Double Post Merged, Feb 1, 2017, Original Post Date: Feb 1, 2017 ---

bump

 

Code (Skript):

1. [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 (Skript):

1.         # == MySQL configuration ==
2.         host: localhost# Where the database server is located at, e.g. 'example.com', 'localhost', or '192.168.1.100'
3.         port: 3306# 3306 is MySQL's default port, i.e. you likely won't need to change this value
4.         user: root
5.         password: pass
6.         database: skript# The database to use. Skript will automatically create a table 'variables21' in this database if it doesn't exist
7.         # (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.

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

 

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

 

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?

 

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 (Skript):

1. script options:
2.     $ db url jdbc:mysql://HOST:PORT/DATABASE
3.     $ db username USERNAME
4.     $ 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?

 

No.

 

HELP
http://pastebin.com/Mv6A9BWQ

 

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

 

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

 

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')

--- Double Post Merged, Feb 3, 2017, Original Post Date: Feb 3, 2017 ---

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