skript-db (Updated) 1.3.6

Sensible SQL support in Skript

  1. Govindas
    Native Minecraft Version:
    Legacy (< 1.13)
    Tested Minecraft Versions:
    • 1.9
    • 1.10
    • 1.11
    • 1.12
    • 1.13
    • 1.14
    • 1.15
    • 1.16
    • 1.17
    Source Code:
    https://git.limework.net/Limework/skript-db
    Code (Text):
    Awesome direct database access for Skript
    What makes skript-db different from other SQL addons?
    • Automatic SQL injection protection
    • Support for connections to multiple databases
    • An amazingly intuitive list variable system for reading query outputs
    This is a fork of btk5h's skript-db with some changes, refer to our git repository for changelog and more syntaxes.
    Documentation/Source - Releases

    Quickstart
    Code (Text):
    on script load:
      set {-sql} to the database "mysql://localhost:3306/mydatabase?user=admin&password=12345&useSSL=false"
    Code (Text):
    command /dbtest:
      trigger:
        execute "select * from table" in {-sql} and store the result in {_output::*}
        send "First entry in column: %{_output::columnname::1}%"
    Code (Text):
    command /insertmyprofile:
       trigger:
        execute "INSERT INTO `table` (`uuid`,`name`,`lastjoin`) VALUES (%uuid of player%,%name of player%,%rounded unix timestamp of now%) ON DUPLICATE KEY UPDATE `name`=VALUES(`name`),`lastjoin`=VALUES(`lastjoin`)" in {-sql}
    Support
    You can receive support by creating an issue at the git repository, alternatively you can receive live chat support in my Matrix chatroom.
    Abdelaziz189356 and ANDREI923 like this.

Recent Updates

  1. 1.3.4 & 1.3.5 & 1.3.6
  2. 1.3.4
  3. Fixed expressions in queries

Recent Reviews

  1. AroByte
    AroByte
    5/5,
    Version: 1.3.4
    Please add support to skript 2.6.1 with 1.18 version, because we need to use the db in 1.18 versions
    1. Govindas
      Author's Response
      I use Skript 2.6.1 and it works fine. I do not run a 1.18 server, could you test it on 1.18 and report back?

      Also reviews are not the place for feature requests, I am likely to notice them very late.
  2. Froosty1291
    Froosty1291
    5/5,
    Version: 1.3.3
    By far the best plugin for Skript databases. Even if you don't think you need a MySQL database, you do... such a good plugin!
    1. Govindas
      Author's Response
      Thank you, I am glad my fork was of good use to you.
  3. Slick_Torpedo_YT
    Slick_Torpedo_YT
    5/5,
    Version: 1.3.3
    For people that are having issues with not inserting, try this:

    execute "INSERT INTO yourTableHere (uuid, name, lastjoin) VALUES ('%uuid of player%', '%player%', '%rounded unix timestamp of now%');" in {-sql}

    Amazing plugin btw tysm <33333
    1. Govindas
      Author's Response
      Thank you for the wonderful review and help for other users.
  4. Andoz_Cz
    Andoz_Cz
    5/5,
    Version: 1.3.3
    Thanks for this resource! This is the only working addon for Skript that adds a feature to connect and communicate with the MySQL database! :D
    1. Govindas
      Author's Response
      Thank you for the review, I am glad it helped you.
  5. Nikd0
    Nikd0
    5/5,
    Version: 1.3.3
    Thanks for keeping this addon alive! I use it all the time, it's one of the easiest ways to connect to my database. Amazing work!
    1. Govindas
      Author's Response
      Thank you for the review and you're welcome.
  6. Crew_Lotzy
    Crew_Lotzy
    5/5,
    Version: 1.3.1
    cool update ДРУГ, but it's time to think about using requests with returned value in functions or custom syntax
    1. Govindas
      Author's Response
      thank you, but I cannot do anything about return values in functions due to Skript limitations, custom syntax return already works
  7. Ynohtna
    Ynohtna
    5/5,
    Version: 1.2.1
    Thanks for continuing this project as well as fixing bugs and adding features, that's finally what I was looking for!
    1. Govindas
      Author's Response
      thank you for the wonderful review, suggestions are welcome!
  8. Jaeger_Danger
    Jaeger_Danger
    5/5,
    Version: 1.2.1
    thank you very much ill be yoinking that, nice work finally a working DB addon :))
    1. Govindas
      Author's Response
      thank you for the wonderful review!