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
|