1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
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);
}
}
|
