From 5e2eb7d67ae933b7566f1944d0bb7744da03d586 Mon Sep 17 00:00:00 2001 From: aura Date: Tue, 17 Feb 2026 23:42:09 +0100 Subject: move source stuff to its own folder --- sourcemod/scripting/gokz-localdb/db/cache_js.sp | 67 ------------------------- 1 file changed, 67 deletions(-) delete mode 100644 sourcemod/scripting/gokz-localdb/db/cache_js.sp (limited to 'sourcemod/scripting/gokz-localdb/db/cache_js.sp') diff --git a/sourcemod/scripting/gokz-localdb/db/cache_js.sp b/sourcemod/scripting/gokz-localdb/db/cache_js.sp deleted file mode 100644 index b0df708..0000000 --- a/sourcemod/scripting/gokz-localdb/db/cache_js.sp +++ /dev/null @@ -1,67 +0,0 @@ -/* - Caches the player's personal best jumpstats. -*/ - - - -void DB_CacheJSPBs(int client, int steamID) -{ - ClearCache(client); - - char query[1024]; - - Transaction txn = SQL_CreateTransaction(); - - FormatEx(query, sizeof(query), sql_jumpstats_getpbs, steamID); - txn.AddQuery(query); - - FormatEx(query, sizeof(query), sql_jumpstats_getblockpbs, steamID, steamID); - txn.AddQuery(query); - - SQL_ExecuteTransaction(gH_DB, txn, DB_TxnSuccess_CacheJSPBs, DB_TxnFailure_Generic, GetClientUserId(client), DBPrio_High); -} - -public void DB_TxnSuccess_CacheJSPBs(Handle db, int userID, int numQueries, Handle[] results, any[] queryData) -{ - int client = GetClientOfUserId(userID); - if (client < 1 || client > MaxClients || !IsClientAuthorized(client) || IsFakeClient(client)) - { - return; - } - - int distance, mode, jumpType, block; - - while (SQL_FetchRow(results[0])) - { - distance = SQL_FetchInt(results[0], 0); - mode = SQL_FetchInt(results[0], 1); - jumpType = SQL_FetchInt(results[0], 2); - - gI_PBJSCache[client][mode][jumpType][JumpstatDB_Cache_Distance] = block; - } - - while (SQL_FetchRow(results[1])) - { - distance = SQL_FetchInt(results[1], 0); - mode = SQL_FetchInt(results[1], 1); - jumpType = SQL_FetchInt(results[1], 2); - block = SQL_FetchInt(results[1], 3); - - gI_PBJSCache[client][mode][jumpType][JumpstatDB_Cache_BlockDistance] = distance; - gI_PBJSCache[client][mode][jumpType][JumpstatDB_Cache_Block] = block; - } -} - -void ClearCache(int client) -{ - for (int mode = 0; mode < MODE_COUNT; mode += 1) - { - for (int type = 0; type < JUMPTYPE_COUNT; type += 1) - { - for (int cache = 0; cache < JUMPSTATDB_CACHE_COUNT; cache += 1) - { - gI_PBJSCache[client][mode][type][cache] = 0; - } - } - } -} \ No newline at end of file -- cgit v1.2.3