Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * oSQL by iRaiDeN / JizzyB
- * Features:
- osql_CreateTable(handle,tablename[],data[]);
- osql_CreateLine(handle,tablename[],data[],values[]);
- osql_DeleteTable(handle,tablename[]);
- osql_Load(handle,tablename[],loadpublic[]);
- osql_SetInt(handle,tablename[],field[],value[],where[],towhere[]);
- osql_SetString(handle,tablename[],field[],&value[],where[],towhere[]);
- osql_SetFloat(handle,tablename[],field[],&Float:value[],where[],towhere[]);
- */
- static
- stock g_Buffer[356];
- stock osql_CreateTable(handle,tablename[],data[])
- {
- format(g_Buffer,356,"CREATE TABLE IF NOT EXISTS %s(%s)",tablename,data);
- mysql_function_query(handle,g_Buffer,false,"","");
- }
- stock osql_CreateLine(handle,tablename[],data[],values[])
- {
- format(g_Buffer,356,"INSERT INTO %s(%s) VALUES(%s)",tablename,data,values);
- mysql_function_query(handle,g_Buffer,false,"","");
- }
- stock osql_DeleteTable(handle,tablename[])
- {
- format(g_Buffer,356,"DROP TABLE %s",tablename);
- mysql_function_query(handle,g_Buffer,false,"","");
- }
- stock osql_Load(handle,tablename[],loadpublic[])
- {
- format(gQuery,sizeof(gQuery),"SELECT * FROM %s",tablename);
- static Query[128];
- format(Query,sizeof(Query),"%s",loadpublic);
- mysql_function_query(dbhandle,gQuery,true,Query,"");
- }
- stock osql_SetInt(handle,tablename[],field[],value[],where[],towhere[])
- {
- new result = strval(value);
- format(g_Buffer,356,"UPDATE %s SET %s = '%d' WHERE %s = '%s'",tablename,field,result,where,towhere);
- mysql_function_query(handle,g_Buffer,false,"","");
- }
- stock osql_SetString(handle,tablename[],field[],value[],where[],towhere[])
- {
- format(g_Buffer,356,"UPDATE %s SET %s = '%s' WHERE %s = '%s'",tablename,field,value,where,towhere);
- mysql_function_query(handle,g_Buffer,false,"","");
- }
- stock Float:osql_SetFloat(handle,tablename[],field[],Float:value,where[],towhere[])
- {
- format(g_Buffer,356,"UPDATE %s SET %s = '%f' WHERE %s = '%s'",tablename,field,value,where,towhere);
- mysql_function_query(handle,g_Buffer,false,"","");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement