Advertisement
Guest User

oSQL by iRaiDeN

a guest
May 31st, 2014
375
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.01 KB | None | 0 0
  1. /*
  2.     * oSQL by iRaiDeN / JizzyB
  3.     * Features:
  4.         osql_CreateTable(handle,tablename[],data[]);
  5.         osql_CreateLine(handle,tablename[],data[],values[]);
  6.         osql_DeleteTable(handle,tablename[]);
  7.         osql_Load(handle,tablename[],loadpublic[]);
  8.         osql_SetInt(handle,tablename[],field[],value[],where[],towhere[]);
  9.         osql_SetString(handle,tablename[],field[],&value[],where[],towhere[]);
  10.         osql_SetFloat(handle,tablename[],field[],&Float:value[],where[],towhere[]);
  11. */
  12.  
  13. static
  14.     stock g_Buffer[356];
  15.  
  16. stock osql_CreateTable(handle,tablename[],data[])
  17. {
  18.     format(g_Buffer,356,"CREATE TABLE IF NOT EXISTS %s(%s)",tablename,data);
  19.     mysql_function_query(handle,g_Buffer,false,"","");
  20. }
  21.  
  22. stock osql_CreateLine(handle,tablename[],data[],values[])
  23. {
  24.     format(g_Buffer,356,"INSERT INTO %s(%s) VALUES(%s)",tablename,data,values);
  25.     mysql_function_query(handle,g_Buffer,false,"","");
  26. }
  27.  
  28. stock osql_DeleteTable(handle,tablename[])
  29. {
  30.     format(g_Buffer,356,"DROP TABLE %s",tablename);
  31.     mysql_function_query(handle,g_Buffer,false,"","");
  32. }
  33.  
  34. stock osql_Load(handle,tablename[],loadpublic[])
  35. {
  36.         format(gQuery,sizeof(gQuery),"SELECT * FROM %s",tablename);
  37.         static Query[128];
  38.         format(Query,sizeof(Query),"%s",loadpublic);
  39.         mysql_function_query(dbhandle,gQuery,true,Query,"");
  40. }
  41.  
  42. stock osql_SetInt(handle,tablename[],field[],value[],where[],towhere[])
  43. {
  44.     new result = strval(value);
  45.     format(g_Buffer,356,"UPDATE %s SET %s = '%d' WHERE %s = '%s'",tablename,field,result,where,towhere);
  46.     mysql_function_query(handle,g_Buffer,false,"","");
  47. }
  48.  
  49. stock osql_SetString(handle,tablename[],field[],value[],where[],towhere[])
  50. {
  51.     format(g_Buffer,356,"UPDATE %s SET %s = '%s' WHERE %s = '%s'",tablename,field,value,where,towhere);
  52.     mysql_function_query(handle,g_Buffer,false,"","");
  53. }
  54.  
  55. stock Float:osql_SetFloat(handle,tablename[],field[],Float:value,where[],towhere[])
  56. {
  57.     format(g_Buffer,356,"UPDATE %s SET %s = '%f' WHERE %s = '%s'",tablename,field,value,where,towhere);
  58.     mysql_function_query(handle,g_Buffer,false,"","");
  59. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement