Code:
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
- Fixed local variables disappearance in newer Skript versions
- Thread-pool size is now configurable
- Uses a newer version of HikariCP
- Only meant to be used by newer Minecraft versions (1.8 is not supported)
Quickstart
Code:
on script load:
set {-sql} to the database "mysql://localhost:3306/mydatabase?user=admin&password=12345&useSSL=false"
Code:
command /dbtest:
trigger:
execute "select * from table" in {-sql} and store the result in {_output::*}
send "First entry in column: %{_output::columnname::1}%"