1. 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!

Dismiss Notice
This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Addon Skellett - The beast addon! 2.0.9

All your Skript needs in one addon!

  1. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234

    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
     
  2. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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.
     
  3. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    I tried using arguments in skript enchant syntax but it gives me error
     
  4. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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.  
     
  5. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    Try set {_my} to mysql result of query "SELECT * FROM myplayer WHERE name = 'xbxy'"
     
  6. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
  7. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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 ?
     
  8. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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?
     
  9. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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
     
  10. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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.
     
  11. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
  12. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    :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 (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.  
     
  13. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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
     
  14. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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:
     
  15. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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.
     
    pepper82 likes this.
  16. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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.
     
  17. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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...
     
  18. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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 (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.  
     
  19. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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
     
  20. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,183
    Likes Received:
    234
    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
     

Share This Page

Loading...