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 skript-db (Updated) 1.2.1

Sensible SQL support for Skript

  1. Govindas
    btk5h (Bryan Terce), FranKusmiruk, Govindas
    Supported Minecraft Versions:
    • 1.9, 1.10, 1.11, 1.12, 1.13, 1.14, 1.15, 1.16
    Code (Text):
    1. 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 these changes:
    • Fixed local variables disappearance in newer Skript versions
    • Thread-pool size is now configurable
    • SQL driver class used is now configurable
    • Uses a newer version of HikariCP
    • Only meant to be used by newer Minecraft versions (1.8 is not supported, use original for 1.8, no bugs on 1.8)
    Documentation/Source - Releases

    Code (Text):
    1. on script load:
    2.   set {-sql} to the database "mysql://localhost:3306/mydatabase?user=admin&password=12345&useSSL=false"
    Code (Text):
    1. command /dbtest:
    2.   trigger:
    3.     execute "select * from table" in {-sql} and store the result in {_output::*}
    4.     send "First entry in column: %{_output::columnname::1}%"
    Code (Text):
    1. command /insertmyprofile:
    2.    trigger:
    3.     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}

Recent Updates

  1. 1.2.1 - more freedom