mysql

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

  1. Jason Paige

    Storage Efficacy

    Hey, recently I wanted to make custom item bags that are based on player heads. these items can then be crafted into something else for sale and transport, as well as being placeable and only holds 8 items that are exchanged via crafting recipe. simple enough I thought. Wrong, but I digress. I...
  2. C

    Problems with variables in sql query

    Hi! This is my testing code, where i'm trying to understand what is going on. command /test: trigger: #Database Variables set {_sqlConnection} to yaml value "mc250391" from file "plugins/Yaml/MySQL/database.yml" set {_sql} to the database "%{_sqlConnection}%"...
  3. B

    Skript Mysql related

    Among those who use skript mysql, can you tell me which method you prefer, the mysql usage method supported by skript config or the query statement supported by the db add-on?
  4. T

    Solved SkQuery 4.1.5 MySQL does not work

    Skript Version 2.6.2 Skript Author APickledWalrus Minecraft Version CraftBukkit version 3096a-Spigot-9fb885e-af1a232 (MC: 1.16.5) (Implementing API version 1.16.5-R0.1-SNAPSHOT) Full Code https://pastebin.com/xZbZMEcf Errors on Reload None Console Errors after Function is executed...
  5. K

    Take information from MySQL

    Hey, How can I take data from SQL table and use them as variables? I am already using SkQuery but I can switch addons if needed. For example: ----------------------------------------------------- Username | Code |...
  6. FlameikTV

    Solved MySQL connection?

    Hi, is there in Skript still feature to connect with Skript to the MySQL database? I tried everything that I found on Google but nothing of that works for me. :emoji_cry: Please, if you know how to do it - please reply here :emoji_pray::emoji_pray:
  7. K

    Config MySQL - MySQLWorkbench

    Hello. I am trying to setup a database between two servers for Skript, and I believe I have set it up correctly. However, now im testing it, it seems to not update an variable on the 2nd server, when changed on the 1st server. I got advised to go and check if the tables in the database were...
  8. K

    Config MySQL - MySQLWorkbench

    Hello. I am trying to setup a database between two servers for Skript, and I believe I have set it up correctly. However, now im testing it, it seems to not update an variable on the 2nd server, when changed on the 1st server. I got advised to go and check if the tables in the database were...
  9. P

    Error with mysql in SkQuery (1.12.2)

    Minecraft Server Version: 1.12.2 (Paper) Skript Version: 2.3.1 SkQuery Version: 4.1.4 Sorry for my bad english. I have already reinstalled SkQuery and MySql Client and Server, but the error is still there. Errors: Ingame: (Multiple) Database features are disabled until the script has SQL...
  10. Nikd0

    MySQL - CLOSE

    Skript version: 2.5.1 (MC version 1.13.2) Full code: script options: $ init com.mysql.jdbc.Driver $ db url jdbc:mysql://**** $ db username **** $ db password **** command /test <text>: trigger: set {_result::*} to objects in column "coins" from result of query...
  11. Hypenexy

    Is MySQL even possible on 1.12.2 spigot?

    I've been looking for 2 years, but, as the title says, I still can't find a way to use MySQL with SkQuery.
  12. G

    Help with skirpt mysql

    Hello everyone I have a problem I want to connect to my database and make an error in the console: https://i.imgur.com/Fel953Y.png Skript: https://i.imgur.com/gfc4nFS.png
  13. Hypenexy

    1.12.2 MySQL problem with SkQuery

    Yes, both Skript and SkQuery load up on 1.12.2 with no problem but however the Skript I use only works on spigot 1.7.2 and 1.8.8 and the old Skript and SkQuery. Here is the error message in the console: [22:04:19 ERROR]: #!#! [22:04:19 ERROR]: #!#! [Skript] Severe Error: [22:04:19 ERROR]: #!#...
  14. M

    Solved Saving data to mysql for certain variables

    Hello, i know you know alot about skripting, so here is my question. Note : Thanks for all the help already In the config it says this: # # MySQL example: # A MySQL database example, with options unrelated to MySQL removed. type: disabled# change to line below to enable this database # type...
  15. M

    Solved Connecting With MySQL (Skellett) [SOLVED]

    Hello, How i have a problem when using skellett mysql i use this code set mysql host to "<ip>:<port>" set mysql username to "<Username>" set mysql password to "<password" set mysql database to "<Database>" connect to mysql skellett mysql update "CREATE TABLE IF NOT EXISTS...
  16. Wolwer

    Solved MySQL DB connect

    Hi. I need help. I need to write data in my mysql database with bans data. For example: Database: 'skBans' -------|-------------|---------|------------- | ID | Name | time | Reason --------------------------------------------- So should I use this...
  17. G

    Skript MySQL with SkQuery

    English/Englisch: Hey, I want to connect my scripts to MySQL. I know how it works. But I have a problem. If I reload or stope and start with my server, all variables are deleted from the cloud system what is wanted, so that the map resets and all old data is loaded. So I would like to take...
  18. Z

    Loading a variable in SQL without repeating query

    Skript Version: 2.2-dev31c Skript Author: Me Minecraft Version: 1.11.2 --- Full Code: set {_woodinfo13} to mysql result of query "SELECT * FROM player_jobs WHERE player = ""%player%""" set {_arraysearch::*} to mysql string "talent1" in {_woodinfo} set {_talent1} to...
  19. bombrider130

    Skellett - See the MySQL currency with a command

    Hello, I've just been using skript, I'm learning how to use skellett. I want to create a money system. I managed to add some money to MySql thanks to a command, but I want to create a command where I can see how much money I have, then export the value from MySql and show it on minecraft...
  20. sOxTw

    [on chat:] with MySQL variables (Help me)

    Hello I need help, when trying to do a send "" loop-player using variables obtained from MySQL, it does not send to all the users that are in the list. Could you guide me in this? - if they ask, do not give any error in the console, simply the message is sent only to the first player that enters...