summaryrefslogtreecommitdiff
path: root/sourcemod-1.5-dev/scripting/include/smlib/sql.inc
diff options
context:
space:
mode:
Diffstat (limited to 'sourcemod-1.5-dev/scripting/include/smlib/sql.inc')
-rw-r--r--sourcemod-1.5-dev/scripting/include/smlib/sql.inc108
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);
-}