diff options
| author | aura <nw@moneybot.cc> | 2026-02-17 23:42:09 +0100 |
|---|---|---|
| committer | aura <nw@moneybot.cc> | 2026-02-17 23:42:09 +0100 |
| commit | 5e2eb7d67ae933b7566f1944d0bb7744da03d586 (patch) | |
| tree | 054acff1113270a9cd07933df760f3768c1b6853 /sourcemod/scripting/gokz-localranks/db/js_top.sp | |
| parent | 341db13a008dc12bb22ceb50452d93d01476308c (diff) | |
move source stuff to its own folder
Diffstat (limited to 'sourcemod/scripting/gokz-localranks/db/js_top.sp')
| -rw-r--r-- | sourcemod/scripting/gokz-localranks/db/js_top.sp | 286 |
1 files changed, 0 insertions, 286 deletions
diff --git a/sourcemod/scripting/gokz-localranks/db/js_top.sp b/sourcemod/scripting/gokz-localranks/db/js_top.sp deleted file mode 100644 index a336a90..0000000 --- a/sourcemod/scripting/gokz-localranks/db/js_top.sp +++ /dev/null @@ -1,286 +0,0 @@ - -static int jumpTopMode[MAXPLAYERS + 1]; -static int jumpTopType[MAXPLAYERS + 1]; -static int blockNums[MAXPLAYERS + 1][JS_TOP_RECORD_COUNT]; -static int jumpInfo[MAXPLAYERS + 1][JS_TOP_RECORD_COUNT][3]; - - - -void DB_OpenJumpTop(int client, int mode, int jumpType, int blockType) -{ - char query[1024]; - - Transaction txn = SQL_CreateTransaction(); - - FormatEx(query, sizeof(query), sql_jumpstats_gettop, jumpType, mode, blockType, jumpType, mode, blockType, JS_TOP_RECORD_COUNT); - txn.AddQuery(query); - - DataPack data = new DataPack(); - data.WriteCell(GetClientUserId(client)); - data.WriteCell(mode); - data.WriteCell(jumpType); - data.WriteCell(blockType); - - SQL_ExecuteTransaction(gH_DB, txn, DB_TxnSuccess_GetJumpTop, DB_TxnFailure_Generic_DataPack, data, DBPrio_Low); -} - -void DB_TxnSuccess_GetJumpTop(Handle db, DataPack data, int numQueries, Handle[] results, any[] queryData) -{ - data.Reset(); - int client = GetClientOfUserId(data.ReadCell()); - int mode = data.ReadCell(); - int type = data.ReadCell(); - int blockType = data.ReadCell(); - delete data; - - if (!IsValidClient(client)) - { - return; - } - - jumpTopMode[client] = mode; - jumpTopType[client] = type; - - int rows = SQL_GetRowCount(results[0]); - if (rows == 0) - { - GOKZ_PrintToChat(client, true, "%t", "No Jumpstats Found"); - DisplayJumpTopBlockTypeMenu(client, mode, type); - return; - } - - char display[128], alias[33], title[65], admin[65]; - int jumpid, steamid, block, strafes; - float distance, sync, pre, max, airtime; - - bool clientIsAdmin = CheckCommandAccess(client, "sm_deletejump", ADMFLAG_ROOT, false); - - Menu menu = new Menu(MenuHandler_JumpTopList); - menu.Pagination = 5; - - if (blockType == 0) - { - menu.SetTitle("%T", "Jump Top Submenu - Title (Jump)", client, gC_ModeNames[mode], gC_JumpTypes[type]); - - FormatEx(title, sizeof(title), "%s %s %T", gC_ModeNames[mode], gC_JumpTypes[type], "Top", client); - strcopy(display, sizeof(display), "----------------------------------------------------------------"); - display[strlen(title)] = '\0'; - - PrintToConsole(client, title); - PrintToConsole(client, display); - - for (int i = 0; i < rows; i++) - { - SQL_FetchRow(results[0]); - jumpid = SQL_FetchInt(results[0], JumpstatDB_Top20_JumpID); - steamid = SQL_FetchInt(results[0], JumpstatDB_Top20_SteamID); - SQL_FetchString(results[0], JumpstatDB_Top20_Alias, alias, sizeof(alias)); - distance = float(SQL_FetchInt(results[0], JumpstatDB_Top20_Distance)) / GOKZ_DB_JS_DISTANCE_PRECISION; - strafes = SQL_FetchInt(results[0], JumpstatDB_Top20_Strafes); - sync = float(SQL_FetchInt(results[0], JumpstatDB_Top20_Sync)) / GOKZ_DB_JS_SYNC_PRECISION; - pre = float(SQL_FetchInt(results[0], JumpstatDB_Top20_Pre)) / GOKZ_DB_JS_PRE_PRECISION; - max = float(SQL_FetchInt(results[0], JumpstatDB_Top20_Max)) / GOKZ_DB_JS_MAX_PRECISION; - airtime = float(SQL_FetchInt(results[0], JumpstatDB_Top20_Air)) / GOKZ_DB_JS_AIRTIME_PRECISION; - - FormatEx(display, sizeof(display), "#%-2d %.4f %s", i + 1, distance, alias); - - menu.AddItem(IntToStringEx(i), display); - - if (clientIsAdmin) - { - FormatEx(admin, sizeof(admin), "<id: %d>", jumpid); - } - - PrintToConsole(client, "#%-2d %.4f %s <STEAM_1:%d:%d> [%d %t | %.2f%% %t | %.2f %t | %.2f %t | %.4f %t] %s", - i + 1, distance, alias, steamid & 1, steamid >> 1, - strafes, "Strafes", sync, "Sync", pre, "Pre", max, "Max", airtime, "Air", - admin); - - jumpInfo[client][i][0] = steamid; - jumpInfo[client][i][1] = type; - jumpInfo[client][i][2] = mode; - blockNums[client][i] = 0; - } - } - else - { - menu.SetTitle("%T", "Jump Top Submenu - Title (Block Jump)", client, gC_ModeNames[mode], gC_JumpTypes[type]); - - FormatEx(title, sizeof(title), "%s %T %s %T", gC_ModeNames[mode], "Block", client, gC_JumpTypes[type], "Top", client); - strcopy(display, sizeof(display), "----------------------------------------------------------------"); - display[strlen(title)] = '\0'; - - PrintToConsole(client, title); - PrintToConsole(client, display); - - for (int i = 0; i < rows; i++) - { - SQL_FetchRow(results[0]); - jumpid = SQL_FetchInt(results[0], JumpstatDB_Top20_JumpID); - steamid = SQL_FetchInt(results[0], JumpstatDB_Top20_SteamID); - SQL_FetchString(results[0], JumpstatDB_Top20_Alias, alias, sizeof(alias)); - block = SQL_FetchInt(results[0], JumpstatDB_Top20_Block); - distance = float(SQL_FetchInt(results[0], JumpstatDB_Top20_Distance)) / GOKZ_DB_JS_DISTANCE_PRECISION; - strafes = SQL_FetchInt(results[0], JumpstatDB_Top20_Strafes); - sync = float(SQL_FetchInt(results[0], JumpstatDB_Top20_Sync)) / GOKZ_DB_JS_SYNC_PRECISION; - pre = float(SQL_FetchInt(results[0], JumpstatDB_Top20_Pre)) / GOKZ_DB_JS_PRE_PRECISION; - max = float(SQL_FetchInt(results[0], JumpstatDB_Top20_Max)) / GOKZ_DB_JS_MAX_PRECISION; - airtime = float(SQL_FetchInt(results[0], JumpstatDB_Top20_Air)) / GOKZ_DB_JS_AIRTIME_PRECISION; - - FormatEx(display, sizeof(display), "#%-2d %d %T (%.4f) %s", i + 1, block, "Block", client, distance, alias); - menu.AddItem(IntToStringEx(i), display); - - if (clientIsAdmin) - { - FormatEx(admin, sizeof(admin), "<id: %d>", jumpid); - } - - PrintToConsole(client, "#%-2d %d %t (%.4f) %s <STEAM_1:%d:%d> [%d %t | %.2f%% %t | %.2f %t | %.2f %t | %.4f %t] %s", - i + 1, block, "Block", distance, alias, steamid & 1, steamid >> 1, - strafes, "Strafes", sync, "Sync", pre, "Pre", max, "Max", airtime, "Air", - admin); - - jumpInfo[client][i][0] = steamid; - jumpInfo[client][i][1] = type; - jumpInfo[client][i][2] = mode; - blockNums[client][i] = block; - } - } - menu.Display(client, MENU_TIME_FOREVER); - PrintToConsole(client, ""); -} - -// =====[ MENUS ]===== - -void DisplayJumpTopModeMenu(int client) -{ - Menu menu = new Menu(MenuHandler_JumpTopMode); - menu.SetTitle("%T", "Jump Top Mode Menu - Title", client); - GOKZ_MenuAddModeItems(client, menu, false); - menu.Display(client, MENU_TIME_FOREVER); -} - -void DisplayJumpTopTypeMenu(int client, int mode) -{ - jumpTopMode[client] = mode; - - Menu menu = new Menu(MenuHandler_JumpTopType); - menu.SetTitle("%T", "Jump Top Type Menu - Title", client, gC_ModeNames[jumpTopMode[client]]); - JumpTopTypeMenuAddItems(menu); - menu.Display(client, MENU_TIME_FOREVER); -} - -static void JumpTopTypeMenuAddItems(Menu menu) -{ - char display[32]; - for (int i = 0; i < JUMPTYPE_COUNT - 3; i++) - { - FormatEx(display, sizeof(display), "%s", gC_JumpTypes[i]); - menu.AddItem(IntToStringEx(i), display); - } -} - -void DisplayJumpTopBlockTypeMenu(int client, int mode, int type) -{ - jumpTopMode[client] = mode; - jumpTopType[client] = type; - - Menu menu = new Menu(MenuHandler_JumpTopBlockType); - menu.SetTitle("%T", "Jump Top Block Type Menu - Title", client, gC_ModeNames[jumpTopMode[client]], gC_JumpTypes[jumpTopType[client]]); - JumpTopBlockTypeMenuAddItems(client, menu); - menu.Display(client, MENU_TIME_FOREVER); -} - -static void JumpTopBlockTypeMenuAddItems(int client, Menu menu) -{ - char str[64]; - FormatEx(str, sizeof(str), "%T", "Jump Records", client); - menu.AddItem("jump", str); - FormatEx(str, sizeof(str), "%T %T", "Block", client, "Jump Records", client); - menu.AddItem("blockjump", str); -} - - - -// =====[ MENU HANDLERS ]===== - -public int MenuHandler_JumpTopMode(Menu menu, MenuAction action, int param1, int param2) -{ - if (action == MenuAction_Select) - { - // param1 = client, param2 = mode - DisplayJumpTopTypeMenu(param1, param2); - } - else if (action == MenuAction_End) - { - delete menu; - } - return 0; -} - -public int MenuHandler_JumpTopType(Menu menu, MenuAction action, int param1, int param2) -{ - if (action == MenuAction_Select) - { - // param1 = client, param2 = type - DisplayJumpTopBlockTypeMenu(param1, jumpTopMode[param1], param2); - } - else if (action == MenuAction_Cancel && param2 == MenuCancel_Exit) - { - DisplayJumpTopModeMenu(param1); - } - else if (action == MenuAction_End) - { - delete menu; - } - return 0; -} - -public int MenuHandler_JumpTopBlockType(Menu menu, MenuAction action, int param1, int param2) -{ - if (action == MenuAction_Select) - { - // param1 = client, param2 = block type - DB_OpenJumpTop(param1, jumpTopMode[param1], jumpTopType[param1], param2); - } - else if (action == MenuAction_Cancel && param2 == MenuCancel_Exit) - { - DisplayJumpTopTypeMenu(param1, jumpTopMode[param1]); - } - else if (action == MenuAction_End) - { - delete menu; - } - return 0; -} - -public int MenuHandler_JumpTopList(Menu menu, MenuAction action, int param1, int param2) -{ - if (action == MenuAction_Select) - { - char path[PLATFORM_MAX_PATH]; - if (blockNums[param1][param2] == 0) - { - BuildPath(Path_SM, path, sizeof(path), - "%s/%d/%d_%s_%s.%s", - RP_DIRECTORY_JUMPS, jumpInfo[param1][param2][0], jumpTopType[param1], gC_ModeNamesShort[jumpInfo[param1][param2][2]], gC_StyleNamesShort[0], RP_FILE_EXTENSION); - } - else - { - BuildPath(Path_SM, path, sizeof(path), - "%s/%d/%s/%d_%d_%s_%s.%s", - RP_DIRECTORY_JUMPS, jumpInfo[param1][param2][0], RP_DIRECTORY_BLOCKJUMPS, jumpTopType[param1], blockNums[param1][param2], gC_ModeNamesShort[jumpInfo[param1][param2][2]], gC_StyleNamesShort[0], RP_FILE_EXTENSION); - } - GOKZ_RP_LoadJumpReplay(param1, path); - } - - if (action == MenuAction_Cancel && param2 == MenuCancel_Exit) - { - DisplayJumpTopBlockTypeMenu(param1, jumpTopMode[param1], jumpTopType[param1]); - } - else if (action == MenuAction_End) - { - delete menu; - } - return 0; -} |
