Read mysql data when encountered problems

Code (Text):

1.  
2. command /a:
3.     trigger:
4.         set {_s1} to mysql result of query "SELECT list FROM bed WHERE name = '%player%'"
5.  

Code (Text):

1.  
2. [07:52:00 INFO]: [Skellett] MySQL connect error: The connection property 'autoReconnect' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'true?allowMultiQueries=true' is not in this set.
3. [07:52:00 ERROR]: #!#!
4. [07:52:00 ERROR]: #!#! [Skript] Severe Error:
5. [07:52:00 ERROR]: #!#!
6. [07:52:00 ERROR]: #!#! If you're developing an add-on for Skript this likely means that you have done something wrong.
7. [07:52:00 ERROR]: #!#! If you're a server admin however please go to https://github.com/bensku/Skript/issues/
8. [07:52:00 ERROR]: #!#! and check whether this error has already been reported.
9. [07:52:00 ERROR]: #!#! If not please create a new ticket with a meaningful title, copy & paste this whole error into it (or use paste service),
10. [07:52:00 ERROR]: #!#! and describe what you did before it happened and/or what you think caused the error.
11. [07:52:00 ERROR]: #!#! If you think that it's a trigger that's causing the error please post the trigger as well.
12. [07:52:00 ERROR]: #!#! By following this guide fixing the error should be easy and done fast.
13. [07:52:00 ERROR]: #!#!
14. [07:52:00 ERROR]: #!#! Stack trace:
15. [07:52:00 ERROR]: #!#! java.lang.NullPointerException
16. [07:52:00 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.MySQLManager.query(MySQLManager.java:102)
17. [07:52:00 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:39)
18. [07:52:00 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:1)
19. [07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:105)
20. [07:52:00 ERROR]: #!#!     at ch.njol.skript.effects.EffChange.execute(EffChange.java:270)
21. [07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.Effect.run(Effect.java:54)
22. [07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:65)
23. [07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:93)
24. [07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.Trigger.execute(Trigger.java:53)
25. [07:52:00 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute2(ScriptCommand.java:222)
26. [07:52:00 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute(ScriptCommand.java:184)
27. [07:52:00 ERROR]: #!#!     at ch.njol.skript.command.Commands.handleCommand(Commands.java:270)
28. [07:52:00 ERROR]: #!#!     at ch.njol.skript.command.Commands$1.onServerCommand(Commands.java:181)
29. [07:52:00 ERROR]: #!#!     at com.destroystokyo.paper.event.executor.MethodHandleEventExecutor.execute(MethodHandleEventExecutor.java:35)
30. [07:52:00 ERROR]: #!#!     at co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:78)
31. [07:52:00 ERROR]: #!#!     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
32. [07:52:00 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:517)
33. [07:52:00 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:502)
34. [07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.aM(DedicatedServer.java:436)
35. [07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.D(DedicatedServer.java:404)
36. [07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.C(MinecraftServer.java:749)
37. [07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:648)
38. [07:52:00 ERROR]: #!#!     at java.lang.Thread.run(Thread.java:745)
39. [07:52:00 ERROR]: #!#!
40. [07:52:00 ERROR]: #!#! Version Information:
41. [07:52:00 ERROR]: #!#!   Skript: 2.2-dev25
42. [07:52:00 ERROR]: #!#!   Bukkit: 1.11.2-R0.1-SNAPSHOT
43. [07:52:00 ERROR]: #!#!   Minecraft: 1.11.2
44. [07:52:00 ERROR]: #!#!   Java: 1.8.0_121 (OpenJDK 64-Bit Server VM 25.121-b13)
45. [07:52:00 ERROR]: #!#!   OS: Linux amd64 2.6.32-431.el6.x86_64
46. [07:52:00 ERROR]: #!#!
47. [07:52:00 ERROR]: #!#! Running CraftBukkit: false
48. [07:52:00 ERROR]: #!#!
49. [07:52:00 ERROR]: #!#! Current node: null
50. [07:52:00 ERROR]: #!#! Current item: set {_s1}(as java.lang.Object) to [skellett] mysql result of query %string%
51. [07:52:00 ERROR]: #!#!
52. [07:52:00 ERROR]: #!#! Thread: Server thread
53. [07:52:00 ERROR]: #!#!
54. [07:52:00 ERROR]: #!#! End of Error.
55. [07:52:00 ERROR]: #!#!
56. [07:52:00 INFO]: An internal error occurred while attempting to perform this command.
57.  

--- Double Post Merged, Mar 11, 2017, Original Post Date: Mar 11, 2017 ---

@LimeGlass

 

Delete your MySQL.yml and restart server. Let it regenerate. Then from there make sure those mysql tables exist and that your login details are correct.

 

I tried using arguments in skript enchant syntax but it gives me error

 

I try to use multiple queries, but an error...

Code (Text):

1.  
2.         set {_my} to mysql result of query "SELECT prefix FROM myplayer WHERE name = 'xbxy'"
3.         set {_my1::*} to mysql string "prefix" in {_my}
4.         set {_my2::*} to mysql string "color" in {_my}
5.         set {_my3::*} to mysql string "look" in {_my}
6.         set {_my4::*} to mysql string "if" in {_my}
7.         send "%{_my1::*}%"
8.         send "%{_my2::*}%"
9.         send "%{_my3::*}%"
10.         send "%{_my4::*}%"
11.  

Code (Text):

1.  
2. [04:23:57 INFO]: [Skellett] MySQL connect error: Communications link failure
3.  
4. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
5. [04:23:57 ERROR]: #!#!
6. [04:23:57 ERROR]: #!#! [Skript] Severe Error:
7. [04:23:57 ERROR]: #!#!
8. [04:23:57 ERROR]: #!#! If you're developing an add-on for Skript this likely means that you have done something wrong.
9. [04:23:57 ERROR]: #!#! If you're a server admin however please go to https://github.com/bensku/Skript/issues/
10. [04:23:57 ERROR]: #!#! and check whether this error has already been reported.
11. [04:23:57 ERROR]: #!#! If not please create a new ticket with a meaningful title, copy & paste this whole error into it (or use paste service),
12. [04:23:57 ERROR]: #!#! and describe what you did before it happened and/or what you think caused the error.
13. [04:23:57 ERROR]: #!#! If you think that it's a trigger that's causing the error please post the trigger as well.
14. [04:23:57 ERROR]: #!#! By following this guide fixing the error should be easy and done fast.
15. [04:23:57 ERROR]: #!#!
16. [04:23:57 ERROR]: #!#! Stack trace:
17. [04:23:57 ERROR]: #!#! java.lang.NullPointerException
18. [04:23:57 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.MySQLManager.query(MySQLManager.java:102)
19. [04:23:57 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:40)
20. [04:23:57 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:1)
21. [04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:105)
22. [04:23:57 ERROR]: #!#!     at ch.njol.skript.effects.EffChange.execute(EffChange.java:270)
23. [04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.Effect.run(Effect.java:54)
24. [04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:65)
25. [04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:93)
26. [04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.Trigger.execute(Trigger.java:53)
27. [04:23:57 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute2(ScriptCommand.java:222)
28. [04:23:57 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute(ScriptCommand.java:184)
29. [04:23:57 ERROR]: #!#!     at ch.njol.skript.command.Commands.handleCommand(Commands.java:270)
30. [04:23:57 ERROR]: #!#!     at ch.njol.skript.command.Commands$1.onServerCommand(Commands.java:181)
31. [04:23:57 ERROR]: #!#!     at com.destroystokyo.paper.event.executor.MethodHandleEventExecutor.execute(MethodHandleEventExecutor.java:35)
32. [04:23:57 ERROR]: #!#!     at co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:78)
33. [04:23:57 ERROR]: #!#!     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
34. [04:23:57 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:517)
35. [04:23:57 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:502)
36. [04:23:57 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.aM(DedicatedServer.java:436)
37. [04:23:57 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.D(DedicatedServer.java:404)
38. [04:23:57 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.C(MinecraftServer.java:749)
39. [04:23:57 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:648)
40. [04:23:57 ERROR]: #!#!     at java.lang.Thread.run(Thread.java:745)
41. [04:23:57 ERROR]: #!#!
42. [04:23:57 ERROR]: #!#! Version Information:
43. [04:23:57 ERROR]: #!#!   Skript: 2.2-dev25
44. [04:23:57 ERROR]: #!#!   Bukkit: 1.11.2-R0.1-SNAPSHOT
45. [04:23:57 ERROR]: #!#!   Minecraft: 1.11.2
46. [04:23:57 ERROR]: #!#!   Java: 1.8.0_121 (OpenJDK 64-Bit Server VM 25.121-b13)
47. [04:23:57 ERROR]: #!#!   OS: Linux amd64 2.6.32-431.el6.x86_64
48. [04:23:57 ERROR]: #!#!
49. [04:23:57 ERROR]: #!#! Running CraftBukkit: false
50. [04:23:57 ERROR]: #!#!
51. [04:23:57 ERROR]: #!#! Current node: null
52. [04:23:57 ERROR]: #!#! Current item: set {_my}(as java.lang.Object) to [skellett] mysql result of query %string%
53. [04:23:57 ERROR]: #!#!
54. [04:23:57 ERROR]: #!#! Thread: Server thread
55. [04:23:57 ERROR]: #!#!
56. [04:23:57 ERROR]: #!#! End of Error.
57. [04:23:57 ERROR]: #!#!
58. [04:23:57 INFO]: An internal error occurred while attempting to perform this command.
59.  

MySQL.yml
Its configuration content is as follows

Code (Text):

1.  
2. MySQL: true
3. AutoReconnect: false
4. SQLite: false
5. ClassPath: jdbc:mysql://game
6. allowMultiQueries: true
7. MySQLSetup:
8.   Host: localhost
9.   Port: 3306
10.   Username: root
11.   Password: ****
12.   Database: game
13.  

The following is my mysql database

Code (Text):

1.  
2. mysql> show databases;
3. +--------------------+
4. | Database           |
5. +--------------------+
6. | information_schema |
7. | bed                |
8. | denglu             |
9. | game               |
10. | mysql              |
11. | test               |
12. +--------------------+
13. 6 rows in set (0.00 sec)
14.  
15. mysql> use game
16. Reading table information for completion of table and column names
17. You can turn off this feature to get a quicker startup with -A
18.  
19. Database changed
20. mysql> show tables;
21. +----------------+
22. | Tables_in_game |
23. +----------------+
24. | bed            |
25. | myplayer       |
26. | myprefix       |
27. | nte_config     |
28. | nte_groups     |
29. | nte_players    |
30. +----------------+
31. 6 rows in set (0.00 sec)
32.  
33. mysql>
34.  

 

Try set {_my} to mysql result of query "SELECT * FROM myplayer WHERE name = 'xbxy'"

 

@LimeGlass can you create force fly (enable flying without double jump) like hypixel? It's work with umbaska 2.0 but it's very buggy. https://github.com/nfelly/Umbaska/b...c224/src/uk/co/umbaska/Misc/ExprForceFly.java

 

You look at # 122 floor

Delete your MySQL.yml and restart server. Let it regenerate. Then from there make sure those mysql tables exist and that your login details are correct.

--- Double Post Merged, Mar 11, 2017, Original Post Date: Mar 11, 2017 ---

You can proceed to the multiple queries ?

 

I'm having a problem on spigot version 1.7.10 where "on entity shoot" is not being recognized as a valid event. Any ideas why?

 

Code (Skript):

1. [15:54:02 INFO]: [Skellett] MySQL connect error: The connection property 'autoReconnect' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'true?allowMultiQueries=true' is not in this set.
2.  

On startup, with a clean mysql.yml file

 

The entity shoot event is only for 1.9 servers. Sorry about that. That's when Spigot added the event. You will have to use `on shoot` which is for players only.

@Martini002 Thank you finally a bug report I can understand. I will look into fixing it.

 

You can set the flying state of a player to true

Code (Skript):

1. set flying state of player to true

This uses SkQuery

 

Mysql multiple queries now do you have any questions, I change a way to store
Read once, can obtain dozens of data

Code (Text):

1.  
2.         set {_my} to mysql result of query "SELECT * FROM bed WHERE name = 'xbxy'"
3.         set {_myy::*} to mysql string "list" in {_my}
4.         set {_t::*} to {_myy::1} split at "="
5.         loop {_t::*}:
6.             send "%loop-index% %loop-value%"
7.  

 

You dont understand me. I still have to double jump to fly. I want to toggle player fly without double jump. Its was possible with umbaska 2.0

 

Nice updates! Especially the statistic stuff is cool.

But how would I get the statistic of how much oak log a player has broken? Can you give me this example?

And you did not add any new citizens stuff? Really need the "make citizen attack" effect

 

Code (Skript):

1. set {_this} to statistic "BREAK_ITEM" from player of material "WOOD"

And I know I didn't add any Citizen stuff. I had this SkellettProxy bug and bStats that worried me this update and forced me to stop everything and put this critical bug fix out first. No matter what I had done or not.

 

SkQuery uses the HumanEntity#setAllowFlight which only allow/disallow the player to fly but the Umbaska 2's expression uses the HumanEntity#setFlying which forces the player fly or fall if they're flying.

 

LimeGlass updated Skellett - The addon with a beast name with a new update entry:

SkellettProxy connection hot fix

Read the rest of this update entry...

 

Thank you for your update! Bungeecord can normal use now!

The mysql database multiple queries are still doesn't work, hope to be able to repair

# 129 floor also has a mistake

Looking forward to your repair

Code (Text):

1.  
2. command /1:
3.     trigger:
4.         set {_my} to mysql result of query "SELECT * FROM bed WHERE name = 'Amber'"
5.         set {_my1::*} to mysql string "win" in {_my}
6.         wait 20 ticks
7.         broadcast "&c%{_my}%  st1: %{_my1::*}%"
8.         set {_my2::*} to mysql string "list" in {_my}
9.         wait 20 ticks
10.         broadcast "&c%{_my}%  st2: %{_my2::*}%"
11.         stop
12.  
13. [04:52:06 INFO]: [email protected]  st1: 1
14. [04:52:07 INFO]: [email protected]  st2: <none>
15.  

MySQL.yml
Now the configuration of the content

Code (Text):

1.  
2. MySQL: true
3. AutoReconnect: false
4. SQLite: false
5. ClassPath: jdbc:mysql://
6. allowMultiQueries: true
7. MySQLSetup:
8.   Host: localhost
9.   Port: 3306
10.   Username: root
11.   Password: rootxbxy
12.   Database: game
13.  

 

Still not working, with a new MySQL.yml file at startup

Code (Skript):

1. [11:03:44 INFO]: [Skellett] MySQL connect error: The connection property 'autoReconnect' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'true?allowMultiQueries=true' is not in this set.
2.  

Code (Skript):

1. # Skellett the addon with the beast name!
2. # By LimeGlass
3. #
4. # If you want to use Skellett mysql syntax, enable it here
5. MySQL: true
6. AutoReconnect: true
7. SQLite: true
8. ClassPath: jdbc:mysql://
9. allowMultiQueries: true
10. MySQLSetup:
11.   Host: 127.0.0.1
12.   Port: 3306
13.   Username: root
14.   Password: secret
15.   Database: db1

 

He seems to have in the fix the problem, but I think the connection is not necessary to automatically
You can modify your server mysql setup,
Will automatically disconnect the timing of the larger