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.
Resource Information
Author:
----------
Total Downloads:
2,638
First Release:
Feb 22, 2021
Last Update:
Apr 19, 2024
Category:
---------------
All-Time Rating:
18 ratings
Version
-----
Released:
--------------------
Downloads:
------
Version Rating:
----------------------
-- ratings