summaryrefslogtreecommitdiff
path: root/sourcemod/scripting/gokz-localdb/db/cache_js.sp
diff options
context:
space:
mode:
authoraura <nw@moneybot.cc>2026-02-17 23:42:09 +0100
committeraura <nw@moneybot.cc>2026-02-17 23:42:09 +0100
commit5e2eb7d67ae933b7566f1944d0bb7744da03d586 (patch)
tree054acff1113270a9cd07933df760f3768c1b6853 /sourcemod/scripting/gokz-localdb/db/cache_js.sp
parent341db13a008dc12bb22ceb50452d93d01476308c (diff)
move source stuff to its own folder
Diffstat (limited to 'sourcemod/scripting/gokz-localdb/db/cache_js.sp')
-rw-r--r--sourcemod/scripting/gokz-localdb/db/cache_js.sp67
1 files changed, 0 insertions, 67 deletions
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