login

//Database config//

//user.queryInstert("konta","login,pass,classid,groupid",test,""); //
        //user.queryUpdate("konta","login,pass,classid,groupid",test,"WHERE id = 1");
        //local result = user.querySelect("*","konta","");


class DataControl
{
    _host = "";
    _user = "";
    _pass = "";
    _data = "";
    _port = 0;

    constructor(h,u,p,d,pt)
    {
        _host = h;
        _user = u;
        _pass = p;
        _data = d;
        _port = pt;
    }

    function queryInstert(tables,columns,values,group)
    {
        group = group.toupper();
        local query = "INSERT INTO " + tables + "(" + columns + ") VALUES (";
        local wynik = "";
        foreach(val in values)
        {
            switch(typeof(val))
            {

                case "bool":
                    query = query + val + ",";
                    wynik = wynik + val + " ";
                    break;

                case "integer":
                    query = query + val + ",";
                    wynik = wynik + val + " ";
                    break;

                case "float":
                    query = query + val + ",";
                     wynik = wynik + val + " ";
                    break;

                case "string":
                    query = query + "'" + val + "'" + ",";
                    wynik = wynik + val + " ";
                    break;
            }
        }
        query = query.slice(0,query.len()-1) + ")";


        if(group.len() != 0)
        {
            query = query + " " + group;
        }

        if(mysql_connect(_host, _user, _pass, _data,_port))
        {
            if(mysql_query(mysql_connect(_host, _user, _pass, _data,_port),query))
            {
               print("done");

            }

            else
            {
                print(mysql_error(mysql_connect(_host, _user, _pass, _data,_port)));

            }

            print("Dodano do nowe rekordy do tabeli " + tables + " kolumny " + "(" + columns +")" + " wartosci = " + wynik);

        }

    }


    function queryUpdate(tables,columns,values,group)
    {
        local query = "UPDATE " + tables + " SET ";
        columns = split(columns, ",");
        foreach(i,row in columns)
        {
            //query = query + row + " = " + values[i] + " ";

            switch(typeof(values[i])){
                case "bool":
                    query = query + row + " = " + values[i] + ", ";
                    break;

                case "integer":
                    query = query + row + " = " + values[i] + ", ";
                    break;

                case "float":
                    query = query + row + " = " + values[i] + ", ";
                    break;

                case "string":
                    query = query + row + " = " + "'" + values[i] + "'" + ", ";
                    break;

            }
        }
        query = query.slice(0,query.len()-2) + " " + group;
        print(query);



        if(mysql_connect(_host, _user, _pass, _data,_port))
        {
            if(mysql_query(mysql_connect(_host, _user, _pass, _data,_port),query))
            {
               print("done");

            }

            else
            {
                print(mysql_error(mysql_connect(_host, _user, _pass, _data,_port)));

            }

            print("Zaktualizowano " + tables);

        }

    }

    function queryDelete()
    {

    }

    function querySelect(columns,tables,group)
    {
        local query = "";
        columns = strip(columns);
        if(columns == "*")
        {
            query = "SELECT * FROM " + tables + " " + group;
            if(mysql_connect(_host, _user, _pass, _data,_port))
            {
                if(mysql_query(mysql_connect(_host, _user, _pass, _data,_port),query))
                {
                    return mysql_query(mysql_connect(_host, _user, _pass, _data,_port),query);

                }
                else
                {
                    print("Nie pobrano danych");
                    mysql_error(mysql_connect(_host, _user, _pass, _data,_port));

                }
            }
            else
            {
                mysql_error(mysql_connect(_host, _user, _pass, _data,_port));


            }
        }

        else
        {
            query = "SELECT ";
            columns = split(columns,",");
            foreach(i,val in columns)
            {
                query = query + columns[i] + ", ";
            }
            query = query.slice(0,query.len()-2) + " FROM " + group;

            if(mysql_connect(_host, _user, _pass, _data,_port))
            {
                if(mysql_query(mysql_connect(_host, _user, _pass, _data,_port),query))
                {
                    return mysql_query(mysql_connect(_host, _user, _pass, _data,_port),query);

                }

            else
            {
                mysql_error(mysql_connect(_host, _user, _pass, _data,_port));

            }
            return mysql_query(mysql_connect(_host, _user, _pass, _data,_port),query);

            }
        }

    }
    function createHandle()
    {
        return mysql_connect(_host, _user, _pass, _data,_port);
    }

}