Skellett - The beast addon!

Addon Skellett - The beast addon! 2.0.10

Go to download

  • 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!

Overview Updates (52) Reviews (27) History Discussion
LimeGlass said:
LimeGlass updated Skellett - The addon with a beast name with a new update entry:

Fixed alot of bugs and added a bunch of stuff



Read the rest of this update entry...
Click to expand...


Read mysql data when encountered problems
Code: 
command /a:
    trigger:
        set {_s1} to mysql result of query "SELECT list FROM bed WHERE name = '%player%'"

Code: 
[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.
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! [Skript] Severe Error:
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! If you're developing an add-on for Skript this likely means that you have done something wrong.
[07:52:00 ERROR]: #!#! If you're a server admin however please go to https://github.com/bensku/Skript/issues/
[07:52:00 ERROR]: #!#! and check whether this error has already been reported.
[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),
[07:52:00 ERROR]: #!#! and describe what you did before it happened and/or what you think caused the error.
[07:52:00 ERROR]: #!#! If you think that it's a trigger that's causing the error please post the trigger as well.
[07:52:00 ERROR]: #!#! By following this guide fixing the error should be easy and done fast.
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Stack trace:
[07:52:00 ERROR]: #!#! java.lang.NullPointerException
[07:52:00 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.MySQLManager.query(MySQLManager.java:102)
[07:52:00 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:39)
[07:52:00 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:1)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:105)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.effects.EffChange.execute(EffChange.java:270)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.Effect.run(Effect.java:54)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:65)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:93)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.Trigger.execute(Trigger.java:53)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute2(ScriptCommand.java:222)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute(ScriptCommand.java:184)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.command.Commands.handleCommand(Commands.java:270)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.command.Commands$1.onServerCommand(Commands.java:181)
[07:52:00 ERROR]: #!#!     at com.destroystokyo.paper.event.executor.MethodHandleEventExecutor.execute(MethodHandleEventExecutor.java:35)
[07:52:00 ERROR]: #!#!     at co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:78)
[07:52:00 ERROR]: #!#!     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
[07:52:00 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:517)
[07:52:00 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:502)
[07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.aM(DedicatedServer.java:436)
[07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.D(DedicatedServer.java:404)
[07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.C(MinecraftServer.java:749)
[07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:648)
[07:52:00 ERROR]: #!#!     at java.lang.Thread.run(Thread.java:745)
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Version Information:
[07:52:00 ERROR]: #!#!   Skript: 2.2-dev25
[07:52:00 ERROR]: #!#!   Bukkit: 1.11.2-R0.1-SNAPSHOT
[07:52:00 ERROR]: #!#!   Minecraft: 1.11.2
[07:52:00 ERROR]: #!#!   Java: 1.8.0_121 (OpenJDK 64-Bit Server VM 25.121-b13)
[07:52:00 ERROR]: #!#!   OS: Linux amd64 2.6.32-431.el6.x86_64
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Running CraftBukkit: false
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Current node: null
[07:52:00 ERROR]: #!#! Current item: set {_s1}(as java.lang.Object) to [skellett] mysql result of query %string%
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Thread: Server thread
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! End of Error.
[07:52:00 ERROR]: #!#!
[07:52:00 INFO]: An internal error occurred while attempting to perform this command.
[doublepost=1489230491,1489230314][/doublepost]
xbxy said:
Read mysql data when encountered problems
Code: 
command /a:
    trigger:
        set {_s1} to mysql result of query "SELECT list FROM bed WHERE name = '%player%'"

Code: 
[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.
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! [Skript] Severe Error:
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! If you're developing an add-on for Skript this likely means that you have done something wrong.
[07:52:00 ERROR]: #!#! If you're a server admin however please go to https://github.com/bensku/Skript/issues/
[07:52:00 ERROR]: #!#! and check whether this error has already been reported.
[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),
[07:52:00 ERROR]: #!#! and describe what you did before it happened and/or what you think caused the error.
[07:52:00 ERROR]: #!#! If you think that it's a trigger that's causing the error please post the trigger as well.
[07:52:00 ERROR]: #!#! By following this guide fixing the error should be easy and done fast.
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Stack trace:
[07:52:00 ERROR]: #!#! java.lang.NullPointerException
[07:52:00 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.MySQLManager.query(MySQLManager.java:102)
[07:52:00 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:39)
[07:52:00 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:1)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:105)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.effects.EffChange.execute(EffChange.java:270)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.Effect.run(Effect.java:54)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:65)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:93)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.Trigger.execute(Trigger.java:53)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute2(ScriptCommand.java:222)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute(ScriptCommand.java:184)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.command.Commands.handleCommand(Commands.java:270)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.command.Commands$1.onServerCommand(Commands.java:181)
[07:52:00 ERROR]: #!#!     at com.destroystokyo.paper.event.executor.MethodHandleEventExecutor.execute(MethodHandleEventExecutor.java:35)
[07:52:00 ERROR]: #!#!     at co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:78)
[07:52:00 ERROR]: #!#!     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
[07:52:00 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:517)
[07:52:00 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:502)
[07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.aM(DedicatedServer.java:436)
[07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.D(DedicatedServer.java:404)
[07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.C(MinecraftServer.java:749)
[07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:648)
[07:52:00 ERROR]: #!#!     at java.lang.Thread.run(Thread.java:745)
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Version Information:
[07:52:00 ERROR]: #!#!   Skript: 2.2-dev25
[07:52:00 ERROR]: #!#!   Bukkit: 1.11.2-R0.1-SNAPSHOT
[07:52:00 ERROR]: #!#!   Minecraft: 1.11.2
[07:52:00 ERROR]: #!#!   Java: 1.8.0_121 (OpenJDK 64-Bit Server VM 25.121-b13)
[07:52:00 ERROR]: #!#!   OS: Linux amd64 2.6.32-431.el6.x86_64
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Running CraftBukkit: false
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Current node: null
[07:52:00 ERROR]: #!#! Current item: set {_s1}(as java.lang.Object) to [skellett] mysql result of query %string%
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Thread: Server thread
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! End of Error.
[07:52:00 ERROR]: #!#!
[07:52:00 INFO]: An internal error occurred while attempting to perform this command.
Click to expand...
@LimeGlass
 
xbxy said:
Read mysql data when encountered problems
Code: 
command /a:
    trigger:
        set {_s1} to mysql result of query "SELECT list FROM bed WHERE name = '%player%'"

Code: 
[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.
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! [Skript] Severe Error:
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! If you're developing an add-on for Skript this likely means that you have done something wrong.
[07:52:00 ERROR]: #!#! If you're a server admin however please go to https://github.com/bensku/Skript/issues/
[07:52:00 ERROR]: #!#! and check whether this error has already been reported.
[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),
[07:52:00 ERROR]: #!#! and describe what you did before it happened and/or what you think caused the error.
[07:52:00 ERROR]: #!#! If you think that it's a trigger that's causing the error please post the trigger as well.
[07:52:00 ERROR]: #!#! By following this guide fixing the error should be easy and done fast.
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Stack trace:
[07:52:00 ERROR]: #!#! java.lang.NullPointerException
[07:52:00 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.MySQLManager.query(MySQLManager.java:102)
[07:52:00 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:39)
[07:52:00 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:1)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:105)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.effects.EffChange.execute(EffChange.java:270)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.Effect.run(Effect.java:54)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:65)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:93)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.lang.Trigger.execute(Trigger.java:53)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute2(ScriptCommand.java:222)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute(ScriptCommand.java:184)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.command.Commands.handleCommand(Commands.java:270)
[07:52:00 ERROR]: #!#!     at ch.njol.skript.command.Commands$1.onServerCommand(Commands.java:181)
[07:52:00 ERROR]: #!#!     at com.destroystokyo.paper.event.executor.MethodHandleEventExecutor.execute(MethodHandleEventExecutor.java:35)
[07:52:00 ERROR]: #!#!     at co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:78)
[07:52:00 ERROR]: #!#!     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
[07:52:00 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:517)
[07:52:00 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:502)
[07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.aM(DedicatedServer.java:436)
[07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.D(DedicatedServer.java:404)
[07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.C(MinecraftServer.java:749)
[07:52:00 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:648)
[07:52:00 ERROR]: #!#!     at java.lang.Thread.run(Thread.java:745)
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Version Information:
[07:52:00 ERROR]: #!#!   Skript: 2.2-dev25
[07:52:00 ERROR]: #!#!   Bukkit: 1.11.2-R0.1-SNAPSHOT
[07:52:00 ERROR]: #!#!   Minecraft: 1.11.2
[07:52:00 ERROR]: #!#!   Java: 1.8.0_121 (OpenJDK 64-Bit Server VM 25.121-b13)
[07:52:00 ERROR]: #!#!   OS: Linux amd64 2.6.32-431.el6.x86_64
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Running CraftBukkit: false
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Current node: null
[07:52:00 ERROR]: #!#! Current item: set {_s1}(as java.lang.Object) to [skellett] mysql result of query %string%
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! Thread: Server thread
[07:52:00 ERROR]: #!#!
[07:52:00 ERROR]: #!#! End of Error.
[07:52:00 ERROR]: #!#!
[07:52:00 INFO]: An internal error occurred while attempting to perform this command.
[doublepost=1489230491,1489230314][/doublepost]
@LimeGlass
Click to expand...
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.
 
LimeGlass said:
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.
Click to expand...

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


Code: 
        set {_my} to mysql result of query "SELECT prefix FROM myplayer WHERE name = 'xbxy'"
        set {_my1::*} to mysql string "prefix" in {_my}
        set {_my2::*} to mysql string "color" in {_my}
        set {_my3::*} to mysql string "look" in {_my}
        set {_my4::*} to mysql string "if" in {_my}
        send "%{_my1::*}%"
        send "%{_my2::*}%"
        send "%{_my3::*}%"
        send "%{_my4::*}%"

Code: 
[04:23:57 INFO]: [Skellett] MySQL connect error: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[04:23:57 ERROR]: #!#! 
[04:23:57 ERROR]: #!#! [Skript] Severe Error:
[04:23:57 ERROR]: #!#! 
[04:23:57 ERROR]: #!#! If you're developing an add-on for Skript this likely means that you have done something wrong.
[04:23:57 ERROR]: #!#! If you're a server admin however please go to https://github.com/bensku/Skript/issues/
[04:23:57 ERROR]: #!#! and check whether this error has already been reported.
[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),
[04:23:57 ERROR]: #!#! and describe what you did before it happened and/or what you think caused the error.
[04:23:57 ERROR]: #!#! If you think that it's a trigger that's causing the error please post the trigger as well.
[04:23:57 ERROR]: #!#! By following this guide fixing the error should be easy and done fast.
[04:23:57 ERROR]: #!#! 
[04:23:57 ERROR]: #!#! Stack trace:
[04:23:57 ERROR]: #!#! java.lang.NullPointerException
[04:23:57 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.MySQLManager.query(MySQLManager.java:102)
[04:23:57 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:40)
[04:23:57 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:1)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:105)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.effects.EffChange.execute(EffChange.java:270)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.Effect.run(Effect.java:54)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:65)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:93)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.Trigger.execute(Trigger.java:53)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute2(ScriptCommand.java:222)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute(ScriptCommand.java:184)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.command.Commands.handleCommand(Commands.java:270)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.command.Commands$1.onServerCommand(Commands.java:181)
[04:23:57 ERROR]: #!#!     at com.destroystokyo.paper.event.executor.MethodHandleEventExecutor.execute(MethodHandleEventExecutor.java:35)
[04:23:57 ERROR]: #!#!     at co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:78)
[04:23:57 ERROR]: #!#!     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
[04:23:57 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:517)
[04:23:57 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:502)
[04:23:57 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.aM(DedicatedServer.java:436)
[04:23:57 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.D(DedicatedServer.java:404)
[04:23:57 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.C(MinecraftServer.java:749)
[04:23:57 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:648)
[04:23:57 ERROR]: #!#!     at java.lang.Thread.run(Thread.java:745)
[04:23:57 ERROR]: #!#! 
[04:23:57 ERROR]: #!#! Version Information:
[04:23:57 ERROR]: #!#!   Skript: 2.2-dev25
[04:23:57 ERROR]: #!#!   Bukkit: 1.11.2-R0.1-SNAPSHOT
[04:23:57 ERROR]: #!#!   Minecraft: 1.11.2
[04:23:57 ERROR]: #!#!   Java: 1.8.0_121 (OpenJDK 64-Bit Server VM 25.121-b13)
[04:23:57 ERROR]: #!#!   OS: Linux amd64 2.6.32-431.el6.x86_64
[04:23:57 ERROR]: #!#! 
[04:23:57 ERROR]: #!#! Running CraftBukkit: false
[04:23:57 ERROR]: #!#! 
[04:23:57 ERROR]: #!#! Current node: null
[04:23:57 ERROR]: #!#! Current item: set {_my}(as java.lang.Object) to [skellett] mysql result of query %string%
[04:23:57 ERROR]: #!#! 
[04:23:57 ERROR]: #!#! Thread: Server thread
[04:23:57 ERROR]: #!#! 
[04:23:57 ERROR]: #!#! End of Error.
[04:23:57 ERROR]: #!#! 
[04:23:57 INFO]: An internal error occurred while attempting to perform this command.
MySQL.yml
Its configuration content is as follows
Code: 
MySQL: true
AutoReconnect: false
SQLite: false
ClassPath: jdbc:mysql://game
allowMultiQueries: true
MySQLSetup:
  Host: localhost
  Port: 3306
  Username: root
  Password: ****
  Database: game
The following is my mysql database
Code: 
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bed                |
| denglu             |
| game               |
| mysql              |
| test               |
+--------------------+
6 rows in set (0.00 sec)

mysql> use game
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+----------------+
| Tables_in_game |
+----------------+
| bed            |
| myplayer       |
| myprefix       |
| nte_config     |
| nte_groups     |
| nte_players    |
+----------------+
6 rows in set (0.00 sec)

mysql>
 
xbxy said:
I try to use multiple queries, but an error...


Code: 
        set {_my} to mysql result of query "SELECT prefix FROM myplayer WHERE name = 'xbxy'"
        set {_my1::*} to mysql string "prefix" in {_my}
        set {_my2::*} to mysql string "color" in {_my}
        set {_my3::*} to mysql string "look" in {_my}
        set {_my4::*} to mysql string "if" in {_my}
        send "%{_my1::*}%"
        send "%{_my2::*}%"
        send "%{_my3::*}%"
        send "%{_my4::*}%"

Code: 
[04:23:57 INFO]: [Skellett] MySQL connect error: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[04:23:57 ERROR]: #!#!
[04:23:57 ERROR]: #!#! [Skript] Severe Error:
[04:23:57 ERROR]: #!#!
[04:23:57 ERROR]: #!#! If you're developing an add-on for Skript this likely means that you have done something wrong.
[04:23:57 ERROR]: #!#! If you're a server admin however please go to https://github.com/bensku/Skript/issues/
[04:23:57 ERROR]: #!#! and check whether this error has already been reported.
[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),
[04:23:57 ERROR]: #!#! and describe what you did before it happened and/or what you think caused the error.
[04:23:57 ERROR]: #!#! If you think that it's a trigger that's causing the error please post the trigger as well.
[04:23:57 ERROR]: #!#! By following this guide fixing the error should be easy and done fast.
[04:23:57 ERROR]: #!#!
[04:23:57 ERROR]: #!#! Stack trace:
[04:23:57 ERROR]: #!#! java.lang.NullPointerException
[04:23:57 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.MySQLManager.query(MySQLManager.java:102)
[04:23:57 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:40)
[04:23:57 ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQuery.get(ExprMySQLQuery.java:1)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:105)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.effects.EffChange.execute(EffChange.java:270)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.Effect.run(Effect.java:54)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:65)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:93)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.lang.Trigger.execute(Trigger.java:53)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute2(ScriptCommand.java:222)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.command.ScriptCommand.execute(ScriptCommand.java:184)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.command.Commands.handleCommand(Commands.java:270)
[04:23:57 ERROR]: #!#!     at ch.njol.skript.command.Commands$1.onServerCommand(Commands.java:181)
[04:23:57 ERROR]: #!#!     at com.destroystokyo.paper.event.executor.MethodHandleEventExecutor.execute(MethodHandleEventExecutor.java:35)
[04:23:57 ERROR]: #!#!     at co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:78)
[04:23:57 ERROR]: #!#!     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
[04:23:57 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:517)
[04:23:57 ERROR]: #!#!     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:502)
[04:23:57 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.aM(DedicatedServer.java:436)
[04:23:57 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.D(DedicatedServer.java:404)
[04:23:57 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.C(MinecraftServer.java:749)
[04:23:57 ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:648)
[04:23:57 ERROR]: #!#!     at java.lang.Thread.run(Thread.java:745)
[04:23:57 ERROR]: #!#!
[04:23:57 ERROR]: #!#! Version Information:
[04:23:57 ERROR]: #!#!   Skript: 2.2-dev25
[04:23:57 ERROR]: #!#!   Bukkit: 1.11.2-R0.1-SNAPSHOT
[04:23:57 ERROR]: #!#!   Minecraft: 1.11.2
[04:23:57 ERROR]: #!#!   Java: 1.8.0_121 (OpenJDK 64-Bit Server VM 25.121-b13)
[04:23:57 ERROR]: #!#!   OS: Linux amd64 2.6.32-431.el6.x86_64
[04:23:57 ERROR]: #!#!
[04:23:57 ERROR]: #!#! Running CraftBukkit: false
[04:23:57 ERROR]: #!#!
[04:23:57 ERROR]: #!#! Current node: null
[04:23:57 ERROR]: #!#! Current item: set {_my}(as java.lang.Object) to [skellett] mysql result of query %string%
[04:23:57 ERROR]: #!#!
[04:23:57 ERROR]: #!#! Thread: Server thread
[04:23:57 ERROR]: #!#!
[04:23:57 ERROR]: #!#! End of Error.
[04:23:57 ERROR]: #!#!
[04:23:57 INFO]: An internal error occurred while attempting to perform this command.
MySQL.yml
Its configuration content is as follows
Code: 
MySQL: true
AutoReconnect: false
SQLite: false
ClassPath: jdbc:mysql://game
allowMultiQueries: true
MySQLSetup:
  Host: localhost
  Port: 3306
  Username: root
  Password: ****
  Database: game
The following is my mysql database
Code: 
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bed                |
| denglu             |
| game               |
| mysql              |
| test               |
+--------------------+
6 rows in set (0.00 sec)

mysql> use game
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+----------------+
| Tables_in_game |
+----------------+
| bed            |
| myplayer       |
| myprefix       |
| nte_config     |
| nte_groups     |
| nte_players    |
+----------------+
6 rows in set (0.00 sec)

mysql>
Click to expand...
Try set {_my} to mysql result of query "SELECT * FROM myplayer WHERE name = 'xbxy'"
 
feerko said:
[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.
Click to expand...
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.
[doublepost=1489236442,1489235894][/doublepost]
xbxy said:
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.
Click to expand...
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_language.skript: 
[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.

On startup, with a clean mysql.yml file
 
Fatboys said:
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?
Click to expand...
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.
 
:emoji_sweat_smile:
Mysql multiple queries now do you have any questions, I change a way to store
Read once, can obtain dozens of data
Code: 
        set {_my} to mysql result of query "SELECT * FROM bed WHERE name = 'xbxy'"
        set {_myy::*} to mysql string "list" in {_my}
        set {_t::*} to {_myy::1} split at "="
        loop {_t::*}:
            send "%loop-index% %loop-value%"
 
LimeGlass said:
You can set the flying state of a player to true
code_language.skript: 
set flying state of player to true
This uses SkQuery
Click to expand...

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 :emoji_slight_smile:
 
pepper82 said:
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 :emoji_slight_smile:
Click to expand...
code_language.skript: 
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.
 
  • Like
Reactions: pepper82
LimeGlass said:
You can set the flying state of a player to true
code_language.skript: 
set flying state of player to true
This uses SkQuery
Click to expand...
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

I have been getting litterally 20+ messages a day saying that Skellett and SkellettProxy aren't working. Sorry about that lol. I just didn't have any time to work on a fix. Now I have some time and here is a fix and tested.

Added:
- Citizens Attack (Requested by @pepper82)
- Server tick

Fixed a few other things.

Syntax:
code_language.skript: 
Expressions:

    #Info: This gets the server tick not tps. Tick is basically the interval of Minecraft.
    #It's like the System...
Click to expand...

Read the rest of this update entry...
 
LimeGlass said:
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...
Click to expand...
Thank you for your update! Bungeecord can normal use now! :emoji_blush:

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: 
command /1:
    trigger:
        set {_my} to mysql result of query "SELECT * FROM bed WHERE name = 'Amber'"
        set {_my1::*} to mysql string "win" in {_my}
        wait 20 ticks
        broadcast "&c%{_my}%  st1: %{_my1::*}%"
        set {_my2::*} to mysql string "list" in {_my}
        wait 20 ticks
        broadcast "&c%{_my}%  st2: %{_my2::*}%"
        stop

[04:52:06 INFO]: com.mysql.jdbc.JDBC42ResultSet@75bba62b  st1: 1
[04:52:07 INFO]: com.mysql.jdbc.JDBC42ResultSet@75bba62b  st2: <none>

MySQL.yml
Now the configuration of the content

Code: 
MySQL: true
AutoReconnect: false
SQLite: false
ClassPath: jdbc:mysql://
allowMultiQueries: true
MySQLSetup:
  Host: localhost
  Port: 3306
  Username: root
  Password: rootxbxy
  Database: game
 
Still not working, with a new MySQL.yml file at startup

code_language.skript: 
[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.

code_language.skript: 
# Skellett the addon with the beast name!
# By LimeGlass
#
# If you want to use Skellett mysql syntax, enable it here
MySQL: true
AutoReconnect: true
SQLite: true
ClassPath: jdbc:mysql://
allowMultiQueries: true
MySQLSetup:
  Host: 127.0.0.1
  Port: 3306
  Username: root
  Password: secret
  Database: db1
 
Martini002 said:
Still not working, with a new MySQL.yml file at startup

code_language.skript: 
[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.

code_language.skript: 
# Skellett the addon with the beast name!
# By LimeGlass
#
# If you want to use Skellett mysql syntax, enable it here
MySQL: true
AutoReconnect: true
SQLite: true
ClassPath: jdbc:mysql://
allowMultiQueries: true
MySQLSetup:
  Host: 127.0.0.1
  Port: 3306
  Username: root
  Password: secret
  Database: db1
Click to expand...
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
 
You must log in or register to reply here.
Top Bottom
Back