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.

Script STAFF LIST [MYSQL, Skript 2.2] 2.1.000

A MySQL supported staff list with User Interface!

  1. HiiqhFive

    Supporter

    Joined:
    Feb 1, 2017
    Messages:
    130
    Likes Received:
    28
    HiiqhFive submitted a new resource:

    STAFF LIST [MYSQL, Skript 2.2] - A MySQL supported staff list with User Interface!

    Read more about this resource...
     
    • Winner Winner x 1
  2. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
    help
    Code (Skript):
    1. "name" from result of query "SELECT * FROM {@Table} WHERE name = '%{_name}%'" and close')
    2. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 59: update "INSERT INTO `{@Table}` (`name`,`uuid`,`rank`,`online`) VALUES ('%{_name}%', '%{_uuid}%', '%{_rank}%', 'OFFLINE')"')
    3. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 62: update "UPDATE `{@Table}` SET `rank` = '%{_rank}%' WHERE `{@Table}`.`name` ='%{_name}%'"')
    4. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 67: set {_results::*} to objects in column "name" from result of query "SELECT * FROM {@Table} WHERE name = '%{_name}%'" and close')
    5. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 73: update "DELETE FROM {@Table} WHERE name = '%{_name}%'"')
    6. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 80: set {_results::*} to objects in column "rank" from result of query "SELECT * FROM {@Table} WHERE name = '%{_name}%'" and close')
    7. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 111: update "CREATE TABLE IF NOT EXISTS `{@Table}` (`name` varchar(255),`uuid` varchar(255),`rank` varchar(255),`online` varchar(255))"')
    8. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 112: update "ALTER TABLE {@Table} ADD UNIQUE (id, name)"')
    9. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 113: update "ALTER TABLE {@Table} ADD id int NOT NULL AUTO_INCREMENT primary key FIRST"')
    10. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 120: set {_results.owner::*} to objects in column "name" from result of query "SELECT * FROM {@Table} WHERE rank='Owner'" and close')
    11. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 122: set {_results.admin::*} to objects in column "name" from result of query "SELECT * FROM {@Table} WHERE rank='Administrator'" and close')
    12. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 124: set {_results.mod::*} to objects in column "name" from result of query "SELECT * FROM {@Table} WHERE rank='Moderator'" and close')
    13. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 126: set {_results.supp::*} to objects in column "name" from result of query "SELECT * FROM {@Table} WHERE rank='Supporter'" and close')
    14. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 204: set {_team::*} to objects in column "name" from result of query "SELECT * FROM {@Table}" and close')
    15. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 209: update "UPDATE `{@Table}` SET `online` = 'ONLINE' WHERE `{@Table}`.`name` ='%player%'"')
    16. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 217: set {_team::*} to objects in column "name" from result of query "SELECT * FROM {@Table}" and close')
    17. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 222: update "UPDATE `{@Table}` SET `online` = 'OFFLINE' WHERE `{@Table}`.`name` ='%player%'"')
    18. [21:45:11 ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (SQL-TEAM_2.0.230.sk, line 227: update "UPDATE `{@Table}` SET `online` = 'OFFLINE' WHERE `{@Table}`.`online` ='ONLINE'"')
    19. [21:45:11 INFO]: > Tablist Prefix Enabled
    20. [21:45:11 INFO]: > Teleport Enabled
    21. [21:45:11 INFO]: [Skript] Loaded 16 scripts with a total of 54 triggers and 13 commands in 1.97 seconds
    22. [21:45:11 INFO]: [Skript] Finished loading.
    23. >
    --- Double Post Merged, Feb 1, 2017, Original Post Date: Feb 1, 2017 ---
    bump
     
  3. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
    Code (Skript):
    1. [Skript] Database features are disabled until the script has SQL credentials associated with it.
    It already explains your error. You have to setup the database in this script.
    Just open the spoiler "how to setup a database connection" in the overview page or read the same text inside the script.
     
    • Agree Agree x 1
  4. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
    oh. alright. Thank you!
    BTW I seen that your skript needs Umbaska. But i am having some troubles setting it up. Could you please help me?
    Here is my latest.txt (log file) http://pastebin.com/QNp0K2P8

    EDIT: After i added Umbaska, a lot of my scripts gave me errors. When i removed Umbaska, they worked again

    EDIT 2: I didn't setup mysql in Skript config. Do i have to set it up there aswell? Also, if i do have to set it up there aswell, do i need to create a different database (so two databases, one called skript and the other called staff or smthing)

    Code (Skript):
    1.         # == MySQL configuration ==
    2.         host: localhost# Where the database server is located at, e.g. 'example.com', 'localhost', or '192.168.1.100'
    3.         port: 3306# 3306 is MySQL's default port, i.e. you likely won't need to change this value
    4.         user: root
    5.         password: pass
    6.         database: skript# The database to use. Skript will automatically create a table 'variables21' in this database if it doesn't exist
    7.         # (If the table exists but is defined differently that how Skript expects it to be you'll get errors and no variables will be saved and/or loaded)



    Please reply. I don't have a lot of time. Thanks!!
     
  5. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
    I can't help you according to your Umbaska problem, please post this in the Help section of skUnity.

    No, there is not a Configuration of the Skript config required.
    Open the script, search for "script options" and use your credentials of your MySQL Database (mostly documentated in the webinterface of your hoster).
     
  6. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
    ok also will you add more ranks to it like TRAINEE, BUILDER
     
  7. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
    In future updates maybe.
     
  8. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
    Ok do i need to setup Skript config mysql aswell?
    Also can you give me the link to that forum cus im new and its confusing
     
  9. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
    No you don't have to. You just have to setup the connection in the script, not in the Skript config in General!
     
  10. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
    Do i have to setup the mysql or the "pass and username" inside umbaska config?
     
  11. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
    You have to setup everything in the script located at plugins\Skript\scripts\<script>.sk
    Open the Script you've downloaded HERE on my resource page -> Go to Line 41

    Code (Skript):
    1. script options:
    2.     $ db url jdbc:mysql://HOST:PORT/DATABASE
    3.     $ db username USERNAME
    4.     $ db password PASSWORD
    HOST = IP-Address of your MySQL-Database
    PORT = 3306
    DATABASE = Name of database given from your hoster
    Username = Name of user which has access to your database
    Password = Self-explanatory
     
  12. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
    Yea ik but do i have to edit the umbaska config?
     
  13. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
  14. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
  15. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
  16. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
  17. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
  18. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
  19. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
    i updated your skript.
    [15:55:41 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'id'
    [15:55:41 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    [15:55:41 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    [15:55:41 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    [15:55:41 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
    [15:55:41 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    [15:55:41 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:382)
    [15:55:41 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    [15:55:41 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    [15:55:41 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    [15:55:41 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    [15:55:41 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    [15:55:41 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    [15:55:41 WARN]: at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
    [15:55:41 WARN]: at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
    [15:55:41 WARN]: at com.w00tmast3r.skquery.elements.effects.EffSQLUpdate.execute(EffSQLUpdate.java:32)
    [15:55:41 WARN]: at ch.njol.skript.lang.Effect.run(Effect.java:54)
    [15:55:41 WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:65)
    [15:55:41 WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:93)
    [15:55:41 WARN]: at ch.njol.skript.lang.Trigger.execute(Trigger.java:53)
    [15:55:41 WARN]: at ch.njol.skript.events.EvtScript.register(EvtScript.java:63)
    [15:55:41 WARN]: at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:519)
    [15:55:41 WARN]: at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:247)
    [15:55:41 WARN]: at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:201)
    [15:55:41 WARN]: at ch.njol.skript.Skript$2.run(Skript.java:406)
    [15:55:41 WARN]: at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)
    [15:55:41 WARN]: at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:350)
    [15:55:41 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:723)
    [15:55:41 WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374)
    [15:55:41 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)
    [15:55:41 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)
    [15:55:41 WARN]: at java.lang.Thread.run(Unknown Source)
    [15:55:41 WARN]: [Skript] Possible name conflict of variables {team::*} and {team::%player%} (there might be more conflicts). (Team.sk, line 227: set {_team::*} to objects in column "name" from result of query "SELECT * FROM {@table}" and close')
    --- Double Post Merged, Feb 3, 2017, Original Post Date: Feb 3, 2017 ---
    How does the "Server" thing work on your script?
    If i put script on my PvP server, And on my lobby. And im on PvP, the player on lobby will see "ONLINE: PvP" ?
     
  20. ShaneBee

    Supporter + Addon Developer

    Joined:
    Sep 7, 2017
    Messages:
    2,184
    Likes Received:
    230
    If you have the latest version, use the command /team delete_database. After that this script should work.

    If you have a network, upload the script to every single server and change the option "server_name" to the servers name, for example:
    - Lobbyserver >> option change to "Lobby"
    - Pvpserver >> option change to "Pvp
     

Share This Page

Loading...