PermissionsEx by Jimmy_Washington

#include <a_samp>
#include <mysql>
#pragma dynamic 50000
stock mysql_get(tabelle[],wert[],vglwert1[],vglwert2[])
{
    new string[4300], get[4300], hour,minute,sek;
    format(string,2048,"SELECT `%s` FROM `%s` WHERE `%s`='%s'",wert,tabelle,vglwert1,vglwert2);
    mysql_query(string);
    mysql_store_result();
    mysql_fetch_row(get);
    if(mysql_errno())
    {
        gettime(hour,minute,sek);
        printf("MySQL-Error [%d:%d:%d]: %s",hour,minute,sek,mysql_errno());
        return get;
    }
    else
    {
        return get;
    }
}

stock mysql_insert(tabelle[],wert[],var[])
{
    new string[4300], hour,minute,sek;
    format(string,4300,"INSERT INTO `%s` (`%s`) VALUES ('%s')",tabelle,wert,var);
    mysql_query(string);
    if(mysql_errno())
    {
        gettime(hour,minute,sek);
        printf("MySQL-Error [%d:%d:%d]: %s",hour,minute,sek,mysql_errno());
        return 0;
    }
    else
    {
        return 1;
    }
}

stock mysql_update(tabelle[],setwert[],wert[],vglwert1[],vglwert2[])
{
    new string[4300], hour,minute,sek;
    format(string,4300,"UPDATE `%s` SET `%s`='%s' WHERE `%s`='%s'",tabelle,setwert,wert,vglwert1,vglwert2);
    mysql_query(string);
    if(mysql_errno())
    {
        gettime(hour,minute,sek);
        printf("MySQL-Error [%d:%d:%d]: %s",hour,minute,sek,mysql_errno());
        return 0;
    }
    else
    {
        return 1;
    }
}

stock mysql_delete(tabelle[],vglwert1[],vglwert2[])
{
    new string[4300], hour,minute,sek;
    format(string,4300,"DELETE FROM `%s` WHERE `%s`='%s'",tabelle,vglwert1,vglwert2);
    mysql_query(string);
    if(mysql_errno())
    {
        gettime(hour,minute,sek);
        printf("MySQL-Error [%d:%d:%d]: %s",hour,minute,sek,mysql_errno());
        return 0;
    }
    else
    {
        return 1;
    }
}