QueryBuilder_UpdateTable(table[], where[], whereclause[], connectionHandle = 1);
QueryBuilder_UpdateString(field[], value[]);
QueryBuilder_UpdateFloat(field[], Float:value);
QueryBuilder_UpdateInt(field[], value);
QueryBuilder_UpdateFinish();
QueryBuilder_MultiUpdate(format[], {Float,_}:...);
QueryBuilder_UpdateStringSingle(table[], where[], whereclause[], field[], value[], connectionHandle = 1);
QueryBuilder_UpdateIntSingle(table[], where[], whereclause[], field[], value, connectionHandle = 1);
QueryBuilder_UpdateFloatSingle(table[], where[], whereclause[], field[], Float:value, connectionHandle = 1);
QueryBuilder_FetchRecord(table[], field[], record[], fetchstr[], limit = 0, connectionHandle = 1);
QueryBuilder_GetInt(field[]);
Float:QueryBuilder_GetFloat(field[]);
QueryBuilder_GetStr(field[]);
QueryBuilder_GetStrEx(field[], dest[], size = sizeof dest, bool:pack = false);
QueryBuilder_MultiGet(getformat[], {Float,_}:...);
QueryBuilder_GetRowCount(table[], connectionHandle = 1);
QueryBuilder_PrintQuery();
QueryBuilder_Insert(table[], insformat[], {Float,_}:...);
QueryBuilder_UpdateTable(table[], where[], whereclause[], connectionHandle = 1)
description: start building a query
table[] - the table to update
where[] - where to update
whereclause[] - what record to update
connectionHandle = 1 - which connection to update (default: 1)
QueryBuilder_UpdateString(field[], value[])
description: update a string
field[] - which field to update
value[] - new string value to set
QueryBuilder_UpdateFloat(field[], Float:value)
description: update a float
field[] - which field to update
Float:value - new float value to set
QueryBuilder_UpdateInt(field[], value)
description: update an integer
field[] - which field to update
value - new integer value to set
QueryBuilder_UpdateFinish()
description: finish updating and send the query
QueryBuilder_MultiUpdate(format[], {Float,_}:...)
description: update multiple fields at once
format[] - format the field and values (like sscanf)
{Float,_}:... - Fields & Their Values (field, value)
QueryBuilder_UpdateStringSingle(table[], where[], whereclause[], field[], value[], connectionHandle = 1)
description: update a single field
table[] - which table to update
where[] - where to update
whereclause[] - what record to update
field[] - what field to update
value[] - new string to set
connectionHandle = which connection to update (default: 1)
QueryBuilder_UpdateIntSingle(table[], where[], whereclause[], field[], value, connectionHandle = 1)
description: update a single field
table[] - which table to update
where[] - where to update
whereclause[] - what record to update
field[] - what field to update
value[] - new integer to set
connectionHandle = which connection to update (default: 1)
QueryBuilder_UpdateFloatSingle(table[], where[], whereclause[], field[], Float:value, connectionHandle = 1)
description: update a single field
table[] - which table to update
where[] - where to update
whereclause[] - what record to update
field[] - what field to update
value[] - new float to set
connectionHandle = which connection to update (default: 1)
QueryBuilder_FetchRecord(table[], field[], record[], fetchstr[], limit = 0, connectionHandle = 1)
description: fetch a record
table[] - which table to fetch from
field[] - which field to fetch from
fetchstr[] - string to store the result
limit = 0 - how many records to fetch
connectionHandle = which connection to fetch (default: 1)
QueryBuilder_GetInt(field[])
description: get an integer from a field
field[] - which field to get the integer from
Float:QueryBuilder_GetFloat(field[])
description: get a float from a field
field[] - which field to get the float from
QueryBuilder_GetStr(field[])
description: get a string from a field
field[] - which field to get the string from
QueryBuilder_GetStrEx(field[], dest[], size = sizeof dest, bool:pack = false)
description: get a string from a field (extra parameters)
filed[] - which field to get the string from
dest[] - array to store the string
size - self explanatory
pack - pack the string or not
QueryBuilder_MultiGet(getformat[], {Float,_}:...)
description: load multiple values at once
getformat[] - format the field and values (like sscanf)
{Float,_}:... - Fields & Their Values (field, value)
QueryBuilder_GetRowCount(table[], connectionHandle = 1)
description: count how many rows are in a table
table[] - table to check how many rows are there
connectionHandle = which connection to count (default: 1)
QueryBuilder_PrintQuery()
description: print the current query (will print null if used outside of the query building
QueryBuilder_Insert(table[], insformat[], {Float,_}:...)
description: insert a new row into a table
insformat[] - format the field and values
{Float,_}:... - Fields & Their Values (field, value)
|
I dont see it much easier then usualy mysql_query, all I see is more , and " " typing thats all, also use shorter function names, rename them to QB_UpdateTable for example or QBUT even better, but its me, anyways, great job
|
|
I dont see it much easier then usualy mysql_query, all I see is more , and " " typing thats all, also use shorter function names, rename them to QB_UpdateTable for example or QBUT even better, but its me, anyways, great job
|