Skelett MySQL

[Adrihun]

Is there any way to make it so if skript can't connect to my MySQL database, it will
execute console command "stop"
I have been trying to solve this problem for months now, and I still can't figure out how to do it.

Please if you know MySQL & Skript, help me with this. Thanks!

 

[ShaneBee]

Not solved that good, but works as wished^^

script options:
    $ db url jdbc:mysql://HOST:3306/TABLE
    $ db username USER  
    $ db password PASS

function checkSQLConnection(~: int = 0) :: boolean:
    update "CREATE TABLE IF NOT EXISTS `isOnline` (`id` int(11), `uid` int(11))"
    update "INSERT INTO `isOnline` (`id`, `uid`) VALUES ('1', '31273')"
    set {_result::*} to objects in column "uid" from result of query "SELECT uid FROM isOnline WHERE id='1'" and close
    update "DROP TABLE `isOnline`"
    if "%{_result::*}%" is not "<none>":
        return true
    else:
        return false

on script load:
    $ thread
    set {_connected} to checkSQLConnection()
    {_connected} is false:
        send "&4ERROR: NO DATABASE CONNECTION!" to console
        execute console command "/stop"

 

[ShaneBee]

Thanks!!!