diff options
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, 286 insertions, 0 deletions
diff --git a/sourcemod/scripting/gokz-localranks/db/js_top.sp b/sourcemod/scripting/gokz-localranks/db/js_top.sp new file mode 100644 index 0000000..a336a90 --- /dev/null +++ b/sourcemod/scripting/gokz-localranks/db/js_top.sp @@ -0,0 +1,286 @@ + +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; +} |