skript-db (Updated) 1.3.1

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
    Source Code:
    https://github.com/Limework/skript-db
    Contributors:
    btk5h, FranKusmiruk, Govindas
    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 github 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}
    ANDREI923 likes this.

Recent Updates

  1. 1.3.1 - some changes

Recent Reviews

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