diff options
Diffstat (limited to 'sourcemod-1.5-dev/scripting/include/smlib/sql.inc')
| -rw-r--r-- | sourcemod-1.5-dev/scripting/include/smlib/sql.inc | 108 |
1 files changed, 0 insertions, 108 deletions
diff --git a/sourcemod-1.5-dev/scripting/include/smlib/sql.inc b/sourcemod-1.5-dev/scripting/include/smlib/sql.inc deleted file mode 100644 index 8bc8ca6..0000000 --- a/sourcemod-1.5-dev/scripting/include/smlib/sql.inc +++ /dev/null @@ -1,108 +0,0 @@ -#if defined _smlib_sql_included - #endinput -#endif -#define _smlib_sql_included - -#include <sourcemod> -#include <dbi> - -/** - * Executes a threaded SQL Query (See: SQL_TQuery) - * This function supports the printf Syntax. - * - * - * @param database A database Handle. - * @param callback Callback; database is in "owner" and the query Handle is passed in "hndl". - * @param data Extra data value to pass to the callback. - * @param format Query string, printf syntax supported - * @param priority Priority queue to use - * @param ... Variable number of format parameters. - * @noreturn - */ -stock SQL_TQueryF(Handle:database, SQLTCallback:callback, any:data, DBPriority:priority=DBPrio_Normal, const String:format[], any:...) { - - if (database == INVALID_HANDLE) { - ThrowError("[SMLIB] Error: Invalid database handle."); - return; - } - - decl String:query[16384]; - VFormat(query, sizeof(query), format, 6); - - SQL_TQuery(database, callback, query, data, priority); -} - -/** - * Fetches an integer from a field in the current row of a result set (See: SQL_FetchInt) - * - * @param query A query (or statement) Handle. - * @param field The field index (starting from 0). - * @param result Optional variable to store the status of the return value. - * @return An integer value. - * @error Invalid query Handle or field index, invalid - * type conversion requested from the database, - * or no current result set. - */ -stock SQL_FetchIntByName(Handle:query, String:fieldName[], &DBResult:result=DBVal_Error) { - - new fieldNum; - SQL_FieldNameToNum(query, fieldName, fieldNum); - - return SQL_FetchInt(query, fieldNum, result); -} - -/** - * Fetches a bool from a field in the current row of a result set (See: SQL_FetchInt) - * - * @param query A query (or statement) Handle. - * @param field The field index (starting from 0). - * @param result Optional variable to store the status of the return value. - * @return A bool value. - * @error Invalid query Handle or field index, invalid - * type conversion requested from the database, - * or no current result set. - */ -stock bool:SQL_FetchBoolByName(Handle:query, String:fieldName[], &DBResult:result=DBVal_Error) { - - return bool:SQL_FetchIntByName(query, fieldName, result); -} - -/** - * Fetches a float from a field in the current row of a result set. (See: SQL_FetchFloat) - * - * @param query A query (or statement) Handle. - * @param field The field index (starting from 0). - * @param result Optional variable to store the status of the return value. - * @return A float value. - * @error Invalid query Handle or field index, invalid - * type conversion requested from the database, - * or no current result set. - */ -stock Float:SQL_FetchFloatByName(Handle:query, String:fieldName[], &DBResult:result=DBVal_Error) { - - new fieldNum; - SQL_FieldNameToNum(query, fieldName, fieldNum); - - return SQL_FetchFloat(query, fieldNum, result); -} - -/** - * Fetches a string from a field in the current row of a result set. (See: SQL_FetchString) - * - * @param query A query (or statement) Handle. - * @param field The field index (starting from 0). - * @param buffer String buffer. - * @param maxlength Maximum size of the string buffer. - * @param result Optional variable to store the status of the return value. - * @return Number of bytes written. - * @error Invalid query Handle or field index, invalid - * type conversion requested from the database, - * or no current result set. - */ -stock SQL_FetchStringByName(Handle:query, String:fieldName[], String:buffer[], maxlength, &DBResult:result=DBVal_Error) { - - new fieldNum; - SQL_FieldNameToNum(query, fieldName, fieldNum); - - return SQL_FetchString(query, fieldNum, buffer, maxlength, result); -} |
