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/save_time.sp | 83 ------------------------ 1 file changed, 83 deletions(-) delete mode 100644 sourcemod/scripting/gokz-localdb/db/save_time.sp (limited to 'sourcemod/scripting/gokz-localdb/db/save_time.sp') diff --git a/sourcemod/scripting/gokz-localdb/db/save_time.sp b/sourcemod/scripting/gokz-localdb/db/save_time.sp deleted file mode 100644 index 84589a5..0000000 --- a/sourcemod/scripting/gokz-localdb/db/save_time.sp +++ /dev/null @@ -1,83 +0,0 @@ -/* - Inserts the player's time into the database. -*/ - - - -void DB_SaveTime(int client, int course, int mode, int style, float runTime, int teleportsUsed) -{ - if (IsFakeClient(client)) - { - return; - } - - char query[1024]; - int steamID = GetSteamAccountID(client); - int mapID = GOKZ_DB_GetCurrentMapID(); - int runTimeMS = GOKZ_DB_TimeFloatToInt(runTime); - - DataPack data = new DataPack(); - data.WriteCell(GetClientUserId(client)); - data.WriteCell(steamID); - data.WriteCell(mapID); - data.WriteCell(course); - data.WriteCell(mode); - data.WriteCell(style); - data.WriteCell(runTimeMS); - data.WriteCell(teleportsUsed); - - Transaction txn = SQL_CreateTransaction(); - - // Save runTime to DB - FormatEx(query, sizeof(query), sql_times_insert, steamID, mode, style, runTimeMS, teleportsUsed, mapID, course); - txn.AddQuery(query); - - SQL_ExecuteTransaction(gH_DB, txn, DB_TxnSuccess_SaveTime, DB_TxnFailure_Generic_DataPack, data, DBPrio_Normal); -} - -public void DB_TxnSuccess_SaveTime(Handle db, DataPack data, int numQueries, Handle[] results, any[] queryData) -{ - data.Reset(); - int client = GetClientOfUserId(data.ReadCell()); - int steamID = data.ReadCell(); - int mapID = data.ReadCell(); - int course = data.ReadCell(); - int mode = data.ReadCell(); - int style = data.ReadCell(); - int runTimeMS = data.ReadCell(); - int teleportsUsed = data.ReadCell(); - delete data; - - if (!IsValidClient(client)) - { - return; - } - - Call_OnTimeInserted(client, steamID, mapID, course, mode, style, runTimeMS, teleportsUsed); -} - -public void DB_DeleteTime(int client, int timeID) -{ - DataPack data = new DataPack(); - data.WriteCell(client == 0 ? -1 : GetClientUserId(client)); // -1 if called from server console - data.WriteCell(timeID); - - char query[1024]; - FormatEx(query, sizeof(query), sql_times_delete, timeID); - - Transaction txn = SQL_CreateTransaction(); - txn.AddQuery(query); - - SQL_ExecuteTransaction(gH_DB, txn, DB_TxnSuccess_TimeDeleted, DB_TxnFailure_Generic_DataPack, data, DBPrio_Low); -} - -public void DB_TxnSuccess_TimeDeleted(Handle db, DataPack data, int numQueries, Handle[] results, any[] queryData) -{ - data.Reset(); - int client = GetClientOfUserId(data.ReadCell()); - int timeID = data.ReadCell(); - delete data; - - GOKZ_PrintToChatAndLog(client, true, "%t", "Time Deleted", - timeID); -} -- cgit v1.2.3