PermissionsEx by Jimmy_Washington

#include <a_samp>
stock db_get(tabelle[],wert[],vglwert1[],vglwert2[])
{
    new query[4300], get[4300], DB:DB, DBResult:result;
    DB = db_open("Permissions.db");
    format(query,4300,"SELECT `%s` FROM `%s` WHERE `%s`='%s'",wert,tabelle,vglwert1,vglwert2);
    result = db_query(DB,query);
    db_get_field_assoc(result,wert,get,4300);
    db_close(DB);
    return get;
}

stock db_insert(tabelle[],wert[],var[])
{
    new query[4300], DB:DB, DBResult:result;
    DB = db_open("Permissions.db");
    format(query,4300,"INSERT INTO `%s`(`%s`) VALUES ('%s')",tabelle,wert,var);
    result = db_query(DB,query);
    return db_free_result(result);
}

stock db_update(tabelle[],wert[],var[],vglwert1[],vglwert2[])
{
    new query[4300], DB:DB, DBResult:result;
    DB = db_open("Permissions.db");
    format(query,4300,"UPDATE `%s` SET `%s`='%s' WHERE `%s`='%s'",tabelle,wert,var,vglwert1,vglwert2);
    result = db_query(DB,query);
    return db_free_result(result);
}

stock db_delete(tabelle[],vglwert1[],vglwert2[])
{
    new query[4300], DB:DB, DBResult:result;
    DB = db_open("Permissions.db");
    format(query,4300,"DELETE FROM `%s` WHERE `%s`='%s'",tabelle,vglwert1,vglwert2);
    result = db_query(DB,query);
    return db_free_result(result);
}