From 5e2eb7d67ae933b7566f1944d0bb7744da03d586 Mon Sep 17 00:00:00 2001
From: aura <nw@moneybot.cc>
Date: Tue, 17 Feb 2026 23:42:09 +0100
Subject: move source stuff to its own folder

---
 .../scripting/gokz-localranks/db/print_average.sp  | 152 ---------------------
 1 file changed, 152 deletions(-)
 delete mode 100644 sourcemod/scripting/gokz-localranks/db/print_average.sp

(limited to 'sourcemod/scripting/gokz-localranks/db/print_average.sp')

diff --git a/sourcemod/scripting/gokz-localranks/db/print_average.sp b/sourcemod/scripting/gokz-localranks/db/print_average.sp
deleted file mode 100644
index 7f7c4e4..0000000
--- a/sourcemod/scripting/gokz-localranks/db/print_average.sp
+++ /dev/null
@@ -1,152 +0,0 @@
-/*
-	Gets the average personal best time of a course.
-*/
-
-
-
-void DB_PrintAverage(int client, int mapID, int course, int mode)
-{
-	char query[1024];
-	
-	DataPack data = new DataPack();
-	data.WriteCell(GetClientUserId(client));
-	data.WriteCell(course);
-	data.WriteCell(mode);
-	
-	Transaction txn = SQL_CreateTransaction();
-	
-	// Retrieve Map Name of MapID
-	FormatEx(query, sizeof(query), sql_maps_getname, mapID);
-	txn.AddQuery(query);
-	// Check for existence of map course with that MapID and Course
-	FormatEx(query, sizeof(query), sql_mapcourses_findid, mapID, course);
-	txn.AddQuery(query);
-	// Get Average PB Time
-	FormatEx(query, sizeof(query), sql_getaverage, mapID, course, mode);
-	txn.AddQuery(query);
-	// Get Average PRO PB Time
-	FormatEx(query, sizeof(query), sql_getaverage_pro, mapID, course, mode);
-	txn.AddQuery(query);
-	
-	SQL_ExecuteTransaction(gH_DB, txn, DB_TxnSuccess_PrintAverage, DB_TxnFailure_Generic_DataPack, data, DBPrio_Low);
-}
-
-public void DB_TxnSuccess_PrintAverage(Handle db, DataPack data, int numQueries, Handle[] results, any[] queryData)
-{
-	data.Reset();
-	int client = GetClientOfUserId(data.ReadCell());
-	int course = data.ReadCell();
-	int mode = data.ReadCell();
-	delete data;
-	
-	if (!IsValidClient(client))
-	{
-		return;
-	}
-	
-	char mapName[33];
-	int mapCompletions, mapCompletionsPro;
-	float averageTime, averageTimePro;
-	
-	// Get Map Name from results
-	if (SQL_FetchRow(results[0]))
-	{
-		SQL_FetchString(results[0], 0, mapName, sizeof(mapName));
-	}
-	if (SQL_GetRowCount(results[1]) == 0)
-	{
-		if (course == 0)
-		{
-			GOKZ_PrintToChat(client, true, "%t", "Main Course Not Found", mapName);
-		}
-		else
-		{
-			GOKZ_PrintToChat(client, true, "%t", "Bonus Not Found", mapName, course);
-		}
-		return;
-	}
-	
-	// Get number of completions and average time
-	if (SQL_FetchRow(results[2]))
-	{
-		mapCompletions = SQL_FetchInt(results[2], 1);
-		if (mapCompletions > 0)
-		{
-			averageTime = GOKZ_DB_TimeIntToFloat(SQL_FetchInt(results[2], 0));
-		}
-	}
-	
-	// Get number of completions and average time (PRO)
-	if (SQL_FetchRow(results[3]))
-	{
-		mapCompletionsPro = SQL_FetchInt(results[3], 1);
-		if (mapCompletions > 0)
-		{
-			averageTimePro = GOKZ_DB_TimeIntToFloat(SQL_FetchInt(results[3], 0));
-		}
-	}
-	
-	// Print average time header to chat
-	if (course == 0)
-	{
-		GOKZ_PrintToChat(client, true, "%t", "Average Time Header", mapName, gC_ModeNamesShort[mode]);
-	}
-	else
-	{
-		GOKZ_PrintToChat(client, true, "%t", "Average Time Header (Bonus)", mapName, course, gC_ModeNamesShort[mode]);
-	}
-	
-	if (mapCompletions == 0)
-	{
-		CPrintToChat(client, "%t", "No Times Found");
-	}
-	else if (mapCompletionsPro == 0)
-	{
-		CPrintToChat(client, "%t, %t", 
-			"Average Time - NUB", GOKZ_FormatTime(averageTime), mapCompletions, 
-			"Average Time - No PRO Time");
-	}
-	else
-	{
-		CPrintToChat(client, "%t, %t", 
-			"Average Time - NUB", GOKZ_FormatTime(averageTime), mapCompletions, 
-			"Average Time - PRO", GOKZ_FormatTime(averageTimePro), mapCompletionsPro);
-	}
-}
-
-void DB_PrintAverage_FindMap(int client, const char[] mapSearch, int course, int mode)
-{
-	DataPack data = new DataPack();
-	data.WriteCell(GetClientUserId(client));
-	data.WriteString(mapSearch);
-	data.WriteCell(course);
-	data.WriteCell(mode);
-	
-	DB_FindMap(mapSearch, DB_TxnSuccess_PrintAverage_FindMap, data, DBPrio_Low);
-}
-
-public void DB_TxnSuccess_PrintAverage_FindMap(Handle db, DataPack data, int numQueries, Handle[] results, any[] queryData)
-{
-	data.Reset();
-	int client = GetClientOfUserId(data.ReadCell());
-	char mapSearch[33];
-	data.ReadString(mapSearch, sizeof(mapSearch));
-	int course = data.ReadCell();
-	int mode = data.ReadCell();
-	delete data;
-	
-	if (!IsValidClient(client))
-	{
-		return;
-	}
-	
-	if (SQL_GetRowCount(results[0]) == 0)
-	{
-		GOKZ_PrintToChat(client, true, "%t", "Map Not Found", mapSearch);
-		return;
-	}
-	else if (SQL_FetchRow(results[0]))
-	{  // Result is the MapID
-		DB_PrintAverage(client, SQL_FetchInt(results[0], 0), course, mode);
-	}
-} 
\ No newline at end of file
-- 
cgit v1.2.3