diff options
Diffstat (limited to 'sourcemod/scripting/gokz-localranks/db/get_completion.sp')
| -rw-r--r-- | sourcemod/scripting/gokz-localranks/db/get_completion.sp | 155 |
1 files changed, 155 insertions, 0 deletions
diff --git a/sourcemod/scripting/gokz-localranks/db/get_completion.sp b/sourcemod/scripting/gokz-localranks/db/get_completion.sp new file mode 100644 index 0000000..fbc76e7 --- /dev/null +++ b/sourcemod/scripting/gokz-localranks/db/get_completion.sp @@ -0,0 +1,155 @@ +/* + Gets the number and percentage of maps completed. +*/ + + + +void DB_GetCompletion(int client, int targetSteamID, int mode, bool print) +{ + char query[1024]; + + DataPack data = new DataPack(); + data.WriteCell(GetClientUserId(client)); + data.WriteCell(targetSteamID); + data.WriteCell(mode); + data.WriteCell(print); + + Transaction txn = SQL_CreateTransaction(); + + // Retrieve Alias of SteamID + FormatEx(query, sizeof(query), sql_players_getalias, targetSteamID); + txn.AddQuery(query); + // Get total number of ranked main courses + txn.AddQuery(sql_getcount_maincourses); + // Get number of main course completions + FormatEx(query, sizeof(query), sql_getcount_maincoursescompleted, targetSteamID, mode); + txn.AddQuery(query); + // Get number of main course completions (PRO) + FormatEx(query, sizeof(query), sql_getcount_maincoursescompletedpro, targetSteamID, mode); + txn.AddQuery(query); + + // Get total number of ranked bonuses + txn.AddQuery(sql_getcount_bonuses); + // Get number of bonus completions + FormatEx(query, sizeof(query), sql_getcount_bonusescompleted, targetSteamID, mode); + txn.AddQuery(query); + // Get number of bonus completions (PRO) + FormatEx(query, sizeof(query), sql_getcount_bonusescompletedpro, targetSteamID, mode); + txn.AddQuery(query); + + SQL_ExecuteTransaction(gH_DB, txn, DB_TxnSuccess_GetCompletion, DB_TxnFailure_Generic_DataPack, data, DBPrio_Low); +} + +public void DB_TxnSuccess_GetCompletion(Handle db, DataPack data, int numQueries, Handle[] results, any[] queryData) +{ + data.Reset(); + int client = GetClientOfUserId(data.ReadCell()); + int targetSteamID = data.ReadCell(); + int mode = data.ReadCell(); + bool print = data.ReadCell(); + delete data; + + if (!IsValidClient(client)) + { + return; + } + + char playerName[MAX_NAME_LENGTH]; + int totalMainCourses, completions, completionsPro; + int totalBonuses, bonusCompletions, bonusCompletionsPro; + + // Get Player Name from results + if (SQL_FetchRow(results[0])) + { + SQL_FetchString(results[0], 0, playerName, sizeof(playerName)); + } + + // Get total number of main courses + if (SQL_FetchRow(results[1])) + { + totalMainCourses = SQL_FetchInt(results[1], 0); + } + // Get completed main courses + if (SQL_FetchRow(results[2])) + { + completions = SQL_FetchInt(results[2], 0); + } + // Get completed main courses (PRO) + if (SQL_FetchRow(results[3])) + { + completionsPro = SQL_FetchInt(results[3], 0); + } + + // Get total number of bonuses + if (SQL_FetchRow(results[4])) + { + totalBonuses = SQL_FetchInt(results[4], 0); + } + // Get completed bonuses + if (SQL_FetchRow(results[5])) { + bonusCompletions = SQL_FetchInt(results[5], 0); + } + // Get completed bonuses (PRO) + if (SQL_FetchRow(results[6])) + { + bonusCompletionsPro = SQL_FetchInt(results[6], 0); + } + + // Print completion message to chat if specified + if (print) + { + if (totalMainCourses + totalBonuses == 0) + { + GOKZ_PrintToChat(client, true, "%t", "No Ranked Maps"); + } + else + { + GOKZ_PrintToChat(client, true, "%t", "Map Completion", + playerName, + completions, totalMainCourses, completionsPro, totalMainCourses, + bonusCompletions, totalBonuses, bonusCompletionsPro, totalBonuses, + gC_ModeNamesShort[mode]); + } + } + + // Set scoreboard MVP stars to percentage PRO completion of server's default mode + if (totalMainCourses + totalBonuses != 0 && targetSteamID == GetSteamAccountID(client) && mode == GOKZ_GetDefaultMode()) + { + CS_SetMVPCount(client, RoundToFloor(float(completionsPro + bonusCompletionsPro) / float(totalMainCourses + totalBonuses) * 100.0)); + } +} + +void DB_GetCompletion_FindPlayer(int client, const char[] target, int mode) +{ + DataPack data = new DataPack(); + data.WriteCell(GetClientUserId(client)); + data.WriteString(target); + data.WriteCell(mode); + + DB_FindPlayer(target, DB_TxnSuccess_GetCompletion_FindPlayer, data, DBPrio_Low); +} + +public void DB_TxnSuccess_GetCompletion_FindPlayer(Handle db, DataPack data, int numQueries, Handle[] results, any[] queryData) +{ + data.Reset(); + int client = GetClientOfUserId(data.ReadCell()); + char playerSearch[33]; + data.ReadString(playerSearch, sizeof(playerSearch)); + int mode = data.ReadCell(); + delete data; + + if (!IsValidClient(client)) + { + return; + } + + else if (SQL_GetRowCount(results[0]) == 0) + { + GOKZ_PrintToChat(client, true, "%t", "Player Not Found", playerSearch); + return; + } + else if (SQL_FetchRow(results[0])) + { + DB_GetCompletion(client, SQL_FetchInt(results[0], 0), mode, true); + } +}
\ No newline at end of file |