[INC] MySQL Functions 0.1

#define SQL_CHECKER_SIZE 512

/*
Only With Stricked Kid Plugin
MySQLGet(type[],table[],getfrom[],paramwhatget[]);                                                  // Int, String, Float
MySQLAdd(type[],table[],addfrom[],paramwhatadd[],param,Float:param);                                // Integer & Float
MySQLSet(table[128],what[128],what2[128],what3[128],what4[128],type1,Float:type2,type3[]);          // Int, String, Or Integer
*/

stock MySQLGet(table[64],what[64],what2[64],what3[64])
{
    new query[SQL_CHECKER_SIZE],fetch[256];
    format(query,sizeof(query),"SELECT %s FROM `%s` WHERE `%s` = '%s'",what,table,what2,what3);
    mysql_query(query);
    mysql_store_result();
    mysql_fetch_field(what3,fetch);
    mysql_free_result();
    return fetch; // Note: when you return Float use floatstr(), when Integer - strval().
}



stock MySQLSet(table[64],what[64],what3[64],what4[64],type1,Float:type2,type3[256])
{
    new query[SQL_CHECKER_SIZE];
    if(type1 != -99999999999999)
    {
        format(query,sizeof(query),"UPDATE `%s` SET `%s` = '%d' WHERE (`%s` = '%s')",table,what,type1,what3,what4);
        mysql_query(query);
        mysql_free_result();
    }
    if(type2 != 0.12153626531631)
    {
        format(query,sizeof(query),"UPDATE `%s` SET `%s` = '%f' WHERE (`%s` = '%s')",table,what,type2,what3,what4);
        mysql_query(query);
        mysql_free_result();
    }
    if(strcmp(type3, "NULL", true) != 0)
    {
        format(query,sizeof(query),"UPDATE `%s` SET `%s` = '%s' WHERE (`%s` = '%s')",table,what,type3,what3,what4);
        mysql_query(query);
        mysql_free_result();
    }
    return 1;
}


stock MySQLAdd(table[64],what1[64],what2[64],what3[64],type1,Float:type2)
{
    new query[SQL_CHECKER_SIZE],fetch[256],w,Float:ww;
    if(type1 != -99999999999999)
    {
        format(query,sizeof(query),"SELECT %s FROM `%s` WHERE `%s` = '%s'",what1,table,what2,what3);
        mysql_query(query);
        mysql_store_result();
        mysql_fetch_field(what3,fetch);
        w = strval(fetch)+type1;
        format(query,sizeof(query),"UPDATE `%s` SET `%s` = '%d' WHERE (`%s` = '%s')",table,what1,w,what2,what3);
        mysql_query(query);
        mysql_free_result();
    }
    if(type2 != 0.12153626531631)
    {
        format(query,sizeof(query),"SELECT %s FROM `%s` WHERE `%s` = '%s'",what1,table,what2,what3);
        mysql_query(query);
        mysql_store_result();
        mysql_fetch_field(what3,fetch);
        ww = floatstr(fetch)+type2;
        format(query,sizeof(query),"UPDATE `%s` SET `%s` = '%f' WHERE (`%s` = '%s')",table,what1,ww,what2,what3);
        mysql_query(query);
        mysql_free_result();
    }
    return 1;
}