Untitled

SUBMITTED BY: Guest

DATE: March 29, 2014, 2:13 p.m.

FORMAT: Text only

SIZE: 3.1 kB

Raw Download

HITS: 627

Report
  1. #define MAX_STRING_QUERY (1000)
  2. #define function:%0<%1> stock sql_%0(%1)
  3. new DB:sql_Database,DBResult:sql_Result,sql_Field[30],sql_StringSet[MAX_STRING_QUERY],sql_StringInt[MAX_STRING_QUERY],sql_StringFloat[MAX_STRING_QUERY],sql_StringCreate[MAX_STRING_QUERY],sql_QueryString[MAX_STRING_QUERY];
  4. function:SetString<DB:database,table[],field[],value[]> {
  5. format(sql_StringSet,sizeof(sql_StringSet),"UPDATE `%s` SET `%s` = '%s'",table,field,value);
  6. return db_query(database,sql_StringSet),1;
  7. }
  8. function:SetInt<DB:database,table[],field[],value> {
  9. format(sql_StringInt,sizeof(sql_StringInt),"UPDATE `%s` SET `%s` = '%d'",table,field,value);
  10. return db_query(database,sql_StringInt),1;
  11. }
  12. function:SetFloat<DB:database,table[],field[],Float:value> {
  13. format(sql_StringInt,sizeof(sql_StringInt),"UPDATE `%s` SET `%s` = '%f'",table,field,value);
  14. return db_query(database,sql_StringInt),1;
  15. }
  16. function:GetInt<DB:database,table[],field[],get[]> return strval(sql_GetString(database,table,field,get));
  17. function:GetIntEx<DB:database,table[],field[],get[],equal[]> return strval(sql_GetStringEx(database,table,field,get,equal));
  18. stock Float:sql_GetFloat(DB:database,table[],field[],get[]) return floatstr(sql_GetString(database,table,field,get));
  19. stock Float:sql_GetFloatEx(DB:database,table[],field[],get[],equal[]) return floatstr(sql_GetStringEx(database,table,field,get,equal));
  20. function:Exists<DB:database,table[],field[],value[]> {
  21. new sql_String[MAX_STRING_QUERY],bool:sql_Return;
  22. format(sql_String,sizeof(sql_String),"SELECT `%s` FROM `%s` WHERE `%s` = '%s'",field,table,field,value);
  23. sql_Result = db_query(database,sql_String);
  24. sql_Return = db_num_rows(sql_Result)?true:false;
  25. db_free_result(sql_Result);
  26. return sql_Return;
  27. }
  28. function:GetString<DB:database,table[],field[],get[]> {
  29. new sql_String[MAX_STRING_QUERY],sql_Return[100];
  30. format(sql_String,sizeof(sql_String),"SELECT * FROM `%s` WHERE `%s`",table,field);
  31. sql_Result = db_query(database,sql_String);
  32. db_get_field_assoc(sql_Result,get,sql_Field,sizeof(sql_Field));
  33. format(sql_Return,sizeof(sql_Return),"%s",sql_Field),db_free_result(sql_Result);
  34. return sql_Return;
  35. }
  36. function:GetStringEx<DB:database,table[],field[],get[],equal[]> {
  37. new sql_String[MAX_STRING_QUERY],sql_Return[100];
  38. format(sql_String,sizeof(sql_String),"SELECT * FROM `%s` WHERE `%s` = '%s'",table,field,equal);
  39. sql_Result = db_query(database,sql_String);
  40. db_get_field_assoc(sql_Result,get,sql_Field,sizeof(sql_Field));
  41. format(sql_Return,sizeof(sql_Return),"%s",sql_Field),db_free_result(sql_Result);
  42. return sql_Return;
  43. }
  44. function:Count<DB:database,table[]> {
  45. new sql_Query[MAX_STRING_QUERY];
  46. format(sql_Query,sizeof(sql_Query),"SELECT * FROM `%s`",table);
  47. sql_Result = db_query(database,sql_Query);
  48. return db_num_rows(sql_Result);
  49. }
comments powered by Disqus