Skellett - The beast addon!

Addon Skellett - The beast addon! 2.0.10

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



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]
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.
@LimeGlass
 
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
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.
 
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 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>
 
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>
Try set {_my} to mysql result of query "SELECT * FROM myplayer WHERE name = 'xbxy'"
 
[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.
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]
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.
You can proceed to the multiple queries ?
 
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
 
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?
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%"
 
You can set the flying state of a player to true
code_language.skript:
set flying state of player to true
This uses SkQuery

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:
 
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:
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
You can set the flying state of a player to true
code_language.skript:
set flying state of player to true
This uses SkQuery
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...

Read the rest of this update entry...
 
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
 
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
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