Code (Text):
Awesome direct database access for Skript
- Automatic SQL injection protection
- Support for connections to multiple databases
- An amazingly intuitive list variable system for reading query outputs
Documentation/Source - Releases
Quickstart (MySQL example, but you can use SQLite, MariaDB, PostgreSQL too)
Code (Text):
on script load:
set {-sql} to the database "mysql://localhost:3306/mydatabase?user=admin&password=12345&useSSL=false"
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}%"
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}
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}
You can receive support by creating an issue at the git repository, alternatively you can receive live chat support in my Matrix chatroom.
Quick facts
- Edition: Minecraft Java
- File type: .jar
- Minecraft versions listed: 1.9, 1.10, 1.11
- How to install: Install the matching mod loader (Forge, Fabric or NeoForge) for your Minecraft version. → Download the .jar. → Put it in the .minecraft/mods folder and launch that loader profile.
- Where to get it: Opens on Spigot — not every file is mirrored on our own servers.
Install steps are the general flow for this file type — How to install Minecraft Java mods & modpacks walks through it step by step.
skript-db (Updated) is a free Minecraft Java mod. Compatible with Minecraft 1.9, 1.10, 1.11, 1.12 and newer. Downloaded 4,147 times (via Spigot). Download it and open it directly in the game.