# Author ProXEQ Discord: ProXEQ#9276
# Subscribe for more www.youtube.com/channel/UCdcLf1A-cRopJzqGxnEANuA
# All rights reserved

import:
    de.jaxophon.mysql.sql.MySQL
effect mysql connect with host %text% user %text% password %text% database %text%:
    trigger:
        delete {mysql::%script%}
        set {mysql::%script%} to new MySQL("%expr-1%", "%expr-4%", "%expr-2%", "%expr-3%")
        {mysql::%script%}.Connect()
        if {mysql::%script%}.isConnected() == true:
            send "&a[MYSQL :: %script%] Successfully connected to database %expr-4%" to console
        else:
            send "&c[MYSQL :: %script%] Error with connect to the database %expr-4%" to console
expression mysql get string %text% for result %text%:
    get:
        if {mysql::%script%}.isConnected() == false:
            send "&c[MYSQL :: %script%] Error with get data from %expr-4%" to console
            stop
        set {_rs} to {mysql::%script%}.GetResult("%expr-2%")
        while {_rs}.next():
            add {_rs}.getString("%expr-1%") to {_x::*}
        return {_x::*}
effect mysql execute %text%:
    trigger:
        if {mysql::%script%}.isConnected() == false:
            send "&c[MYSQL :: %script%] Error with get data from %expr-4%" to console
            stop
        {mysql::%script%}.ExecuteCommand("%expr-1%")
effect mysql disconnect:
    trigger:
        {mysql::%script%}.Disconnect()
        send "&e[MYSQL] Database %{mysql::%script%}% is succesfully disconnected!" to console
        stop
condition mysql connect:
    check:
        if {mysql::%script%}.isConnected() == true:
            continue