]> de.git.xonotic.org Git - xonotic/xonotic-data.pk3dir.git/blob - qcsrc/common/playerstats.qc
Update default video settings
[xonotic/xonotic-data.pk3dir.git] / qcsrc / common / playerstats.qc
1 #include "playerstats.qh"
2
3 #if defined(CSQC)
4 #elif defined(MENUQC)
5 #elif defined(SVQC)
6         #include <common/constants.qh>
7         #include <common/stats.qh>
8         #include <common/util.qh>
9         #include <common/weapons/_all.qh>
10         #include <server/anticheat.qh>
11         #include <server/client.qh>
12         #include <server/intermission.qh>
13         #include <server/scores.qh>
14         #include <server/weapons/accuracy.qh>
15         #include <server/world.qh>
16 #endif
17
18
19 #ifdef GAMEQC
20 REPLICATE(cvar_cl_allow_uid2name, int, "cl_allow_uid2name");
21 REPLICATE(cvar_cl_allow_uidranking, bool, "cl_allow_uidranking");
22 REPLICATE(cvar_cl_allow_uidtracking, int, "cl_allow_uidtracking");
23 #endif
24
25 #ifdef SVQC
26 REPLICATE_APPLYCHANGE("cl_allow_uidtracking", { PlayerStats_GameReport_AddPlayer(this); });
27 #endif
28
29 #ifdef SVQC
30 void PlayerStats_Prematch()
31 {
32         //foobar
33 }
34
35 // Deletes current playerstats DB, creates a new one and fully initializes it
36 void PlayerStats_GameReport_Reset_All()
37 {
38         strfree(PS_GR_OUT_TL);
39         strfree(PS_GR_OUT_PL);
40         strfree(PS_GR_OUT_EVL);
41
42         if (PS_GR_OUT_DB >= 0)
43         {
44                 db_close(PS_GR_OUT_DB);
45                 PlayerStats_GameReport_Init();
46         }
47         if(PS_GR_OUT_DB < 0)
48                 return;
49
50         for (int i = 0; i < 16; ++i)
51                 if (teamscorekeepers[i])
52                         PlayerStats_GameReport_AddTeam(i + 1);
53         FOREACH_CLIENT(true, {
54                 // NOTE Adding back a player we are applying any cl_allow_uidtracking change
55                 // usually only possible by reconnecting to the server
56                 strfree(it.playerstats_id);
57                 PlayerStats_GameReport_AddEvent(sprintf("kills-%d", it.playerid));
58                 PlayerStats_GameReport_AddPlayer(it);
59         });
60         FOREACH(Scores, true, {
61                 string label = scores_label(it);
62                 if (label == "")
63                         continue;
64                 PlayerStats_GameReport_AddEvent(strcat(PLAYERSTATS_TOTAL, label));
65                 PlayerStats_GameReport_AddEvent(strcat(PLAYERSTATS_SCOREBOARD, label));
66         });
67         for(int i = 0; i < MAX_TEAMSCORE; ++i)
68         {
69                 string label = teamscores_label(i);
70                 if (label == "")
71                         continue;
72                 PlayerStats_GameReport_AddEvent(strcat(PLAYERSTATS_TOTAL, label));
73                 PlayerStats_GameReport_AddEvent(strcat(PLAYERSTATS_SCOREBOARD, label));
74         }
75 }
76
77 void PlayerStats_GameReport_AddPlayer(entity e)
78 {
79         if((PS_GR_OUT_DB < 0) || (e.playerstats_id)) { return; }
80
81         // set up player identification
82         string s = "";
83
84         if((e.crypto_idfp != "") && (CS_CVAR(e).cvar_cl_allow_uidtracking == 1))
85                 { s = e.crypto_idfp; }
86         else if(IS_BOT_CLIENT(e))
87                 { s = sprintf("bot#%g#%s", skill, e.cleanname); }
88
89         if((s == "") || find(NULL, playerstats_id, s)) // already have one of the ID - next one can't be tracked then!
90         {
91                 if(IS_BOT_CLIENT(e))
92                         { s = sprintf("bot#%d", e.playerid); }
93                 else
94                         { s = sprintf("player#%d", e.playerid); }
95         }
96
97         e.playerstats_id = strzone(s);
98
99         // now add the player to the database
100         string key = sprintf("%s:*", e.playerstats_id);
101         string p = db_get(PS_GR_OUT_DB, key);
102
103         if(p == "")
104         {
105                 if(PS_GR_OUT_PL)
106                 {
107                         db_put(PS_GR_OUT_DB, key, PS_GR_OUT_PL);
108                         strunzone(PS_GR_OUT_PL);
109                 }
110                 else { db_put(PS_GR_OUT_DB, key, "#"); }
111                 PS_GR_OUT_PL = strzone(e.playerstats_id);
112         }
113 }
114
115 void PlayerStats_GameReport_AddTeam(int t)
116 {
117         if(PS_GR_OUT_DB < 0) { return; }
118
119         string key = sprintf("%d", t);
120         string p = db_get(PS_GR_OUT_DB, key);
121
122         if(p == "")
123         {
124                 if(PS_GR_OUT_TL)
125                 {
126                         db_put(PS_GR_OUT_DB, key, PS_GR_OUT_TL);
127                         strunzone(PS_GR_OUT_TL);
128                 }
129                 else { db_put(PS_GR_OUT_DB, key, "#"); }
130                 PS_GR_OUT_TL = strzone(key);
131         }
132 }
133
134 void PlayerStats_GameReport_AddEvent(string event_id)
135 {
136         if(PS_GR_OUT_DB < 0) { return; }
137
138         string key = sprintf("*:%s", event_id);
139         string p = db_get(PS_GR_OUT_DB, key);
140
141         if(p == "")
142         {
143                 if(PS_GR_OUT_EVL)
144                 {
145                         db_put(PS_GR_OUT_DB, key, PS_GR_OUT_EVL);
146                         strunzone(PS_GR_OUT_EVL);
147                 }
148                 else { db_put(PS_GR_OUT_DB, key, "#"); }
149                 PS_GR_OUT_EVL = strzone(event_id);
150         }
151 }
152
153 float PlayerStats_GameReport_Event(string prefix, string event_id, float value)
154 {
155         if((prefix == "") || PS_GR_OUT_DB < 0) { return 0; }
156
157         string key = sprintf("%s:%s", prefix, event_id);
158         float val = stof(db_get(PS_GR_OUT_DB, key));
159         val += value;
160         db_put(PS_GR_OUT_DB, key, ftos(val));
161         return val;
162 }
163
164 void PlayerStats_GameReport_Accuracy(entity p)
165 {
166         #define ACCMAC(suffix, field) \
167                 PlayerStats_GameReport_Event_Player(p, \
168                         sprintf("acc-%s-%s", it.netname, suffix), CS(p).accuracy.(field[i-1]));
169         FOREACH(Weapons, it != WEP_Null, {
170                 ACCMAC("hit", accuracy_hit)
171                 ACCMAC("fired", accuracy_fired)
172                 ACCMAC("cnt-hit", accuracy_cnt_hit)
173                 ACCMAC("cnt-fired", accuracy_cnt_fired)
174                 ACCMAC("frags", accuracy_frags)
175         });
176         #undef ACCMAC
177 }
178
179 void PlayerStats_GameReport_FinalizePlayer(entity p)
180 {
181         if((p.playerstats_id == "") || PS_GR_OUT_DB < 0) { return; }
182
183         // add global info!
184         if(p.alivetime)
185         {
186                 PlayerStats_GameReport_Event_Player(p, PLAYERSTATS_ALIVETIME, time - p.alivetime);
187                 p.alivetime = 0;
188         }
189
190         db_put(PS_GR_OUT_DB, sprintf("%s:_playerid", p.playerstats_id), ftos(p.playerid));
191
192         if(CS_CVAR(p).cvar_cl_allow_uid2name == 1 || IS_BOT_CLIENT(p))
193                 db_put(PS_GR_OUT_DB, sprintf("%s:_netname", p.playerstats_id), playername(p.netname, p.team, false));
194
195         if(teamplay)
196                 db_put(PS_GR_OUT_DB, sprintf("%s:_team", p.playerstats_id), ftos(p.team));
197
198         if(stof(db_get(PS_GR_OUT_DB, sprintf("%s:%s", p.playerstats_id, PLAYERSTATS_ALIVETIME))) > 0)
199                 PlayerStats_GameReport_Event_Player(p, PLAYERSTATS_JOINS, 1);
200
201         PlayerStats_GameReport_Accuracy(p);
202         anticheat_report_to_playerstats(p);
203
204         if(IS_REAL_CLIENT(p))
205         {
206                 if(CS(p).latency_cnt)
207                 {
208                         float latency = max(0, CS(p).latency_sum / CS(p).latency_cnt);
209                         if(latency)
210                         {
211                                 // if previous average latency exists (player disconnected and reconnected)
212                                 // make the average of previous and current average latency
213                                 float prev_latency = PlayerStats_GameReport_Event_Player(p, PLAYERSTATS_AVGLATENCY, 0);
214                                 float new_latency = !prev_latency ? latency : (prev_latency + latency) / 2;
215                                 PlayerStats_GameReport_Event_Player(p, PLAYERSTATS_AVGLATENCY, -prev_latency + new_latency);
216                         }
217                 }
218
219                 db_put(PS_GR_OUT_DB, sprintf("%s:_ranked", p.playerstats_id), ftos(CS_CVAR(p).cvar_cl_allow_uidranking));
220         }
221
222         strfree(p.playerstats_id);
223 }
224
225 void PlayerStats_GameReport(bool finished)
226 {
227         if(PS_GR_OUT_DB < 0) { return; }
228
229         PlayerScore_Sort(score_dummyfield, 0, false, false);
230         PlayerScore_Sort(scoreboard_pos, 1, true, true);
231         if(teamplay) { PlayerScore_TeamStats(); }
232
233         FOREACH_CLIENT(true, {
234                 // add personal score rank
235                 PlayerStats_GameReport_Event_Player(it, PLAYERSTATS_RANK, it.score_dummyfield);
236
237                 // scoreboard data
238                 if(it.scoreboard_pos)
239                 {
240                         // scoreboard is valid!
241                         PlayerStats_GameReport_Event_Player(it, PLAYERSTATS_SCOREBOARD_VALID, 1);
242
243                         // add scoreboard position
244                         PlayerStats_GameReport_Event_Player(it, PLAYERSTATS_SCOREBOARD_POS, it.scoreboard_pos);
245
246                         // add scoreboard data
247                         PlayerScore_PlayerStats(it);
248
249                         // if the match ended normally, add winning info
250                         if(finished)
251                         {
252                                 PlayerStats_GameReport_Event_Player(it, PLAYERSTATS_WINS, it.winning);
253                                 PlayerStats_GameReport_Event_Player(it, PLAYERSTATS_MATCHES, 1);
254                         }
255                 }
256
257                 // collect final player information
258                 PlayerStats_GameReport_FinalizePlayer(it);
259         });
260
261         if(autocvar_g_playerstats_gamereport_uri == "" || warmup_stage)
262         {
263                 PlayerStats_GameReport_DelayMapVote = false;
264                 db_close(PS_GR_OUT_DB);
265                 PS_GR_OUT_DB = -1;
266                 return;
267         }
268
269         PlayerStats_GameReport_DelayMapVote = true;
270         url_multi_fopen(
271                 autocvar_g_playerstats_gamereport_uri,
272                 FILE_APPEND,
273                 PlayerStats_GameReport_Handler,
274                 NULL
275         );
276 }
277
278 void PlayerStats_GameReport_Init() // initiated before InitGameplayMode so that scores are added properly
279 {
280         serverflags &= ~SERVERFLAG_PLAYERSTATS;
281         serverflags &= ~SERVERFLAG_PLAYERSTATS_CUSTOM;
282
283         if(autocvar_g_playerstats_gamereport_uri == "") { return; }
284
285         PS_GR_OUT_DB = db_create();
286
287         if(PS_GR_OUT_DB >= 0)
288         {
289                 PlayerStats_GameReport_DelayMapVote = true;
290
291                 if(autocvar_g_playerstats_gamereport_uri != cvar_defstring("g_playerstats_gamereport_uri"))
292                         serverflags |= SERVERFLAG_PLAYERSTATS | SERVERFLAG_PLAYERSTATS_CUSTOM;
293                 else if(checkextension("DP_CRYPTO") && checkextension("DP_QC_URI_POST"))
294                         // XonStat submission requires player and server IDs, and HTTPS POST
295                         serverflags |= SERVERFLAG_PLAYERSTATS;
296
297                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ALIVETIME);
298                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_AVGLATENCY);
299                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_WINS);
300                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_MATCHES);
301                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_JOINS);
302                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_SCOREBOARD_VALID);
303                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_SCOREBOARD_POS);
304                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_RANK);
305
306                 // accuracy stats
307                 FOREACH(Weapons, it != WEP_Null, {
308                         PlayerStats_GameReport_AddEvent(strcat("acc-", it.netname, "-hit"));
309                         PlayerStats_GameReport_AddEvent(strcat("acc-", it.netname, "-fired"));
310                         PlayerStats_GameReport_AddEvent(strcat("acc-", it.netname, "-cnt-hit"));
311                         PlayerStats_GameReport_AddEvent(strcat("acc-", it.netname, "-cnt-fired"));
312                         PlayerStats_GameReport_AddEvent(strcat("acc-", it.netname, "-frags"));
313                 });
314
315                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_3);
316                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_5);
317                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_10);
318                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_15);
319                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_20);
320                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_25);
321                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_30);
322                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_BOTLIKE);
323                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_FIRSTBLOOD);
324                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_FIRSTVICTIM);
325
326                 anticheat_register_to_playerstats();
327         }
328         else { PlayerStats_GameReport_DelayMapVote = false; }
329 }
330
331 // this... is a hack, a temporary one until we get a proper duel gametype
332 // TODO: remove duel hack after servers have migrated to the proper duel gametype!
333 string PlayerStats_GetGametype()
334 {
335         if(IS_GAMETYPE(DEATHMATCH) && autocvar_g_maxplayers == 2)
336         {
337                 // probably duel, but let's make sure
338                 int plcount = 0;
339                 FOREACH_CLIENT(IS_PLAYER(it), ++plcount);
340                 if(plcount <= 2)
341                         return "duel";
342         }
343         return GetGametype();
344 }
345
346 void PlayerStats_GameReport_Handler(entity fh, entity pass, float status)
347 {
348         string t, tn;
349         string p, pn;
350         string e, en;
351         string nn, tt;
352         string s;
353
354         switch(status)
355         {
356                 // ======================================
357                 // -- OUTGOING GAME REPORT INFORMATION --
358                 // ======================================
359                 /* SPECIFICATIONS:
360                  * V: format version (always a fixed number) - this MUST be the first line!
361                  * #: comment (MUST be ignored by any parser)
362                  * R: release information on the server
363                  * G: game type
364                  * O: mod name (icon request) as in server browser
365                  * M: map name
366                  * I: match ID (see "matchid" in world.qc)
367                  * S: "hostname" of the server
368                  * C: number of "unpure" cvar changes
369                  * U: UDP port number of the server
370                  * D: duration of the match
371                  * RP: number of rounds played
372                  * L: "ladder" in which the server is participating in
373                  * P: player ID of an existing player; this also sets the owner for all following "n", "e" and "t" lines (lower case!)
374                  * Q: team number of an existing team (format: team#NN); this also sets the owner for all following "e" lines (lower case!)
375                  * i: player index
376                  * n: nickname of the player (optional)
377                  * t: team ID
378                  * r: player ranking enabled / disabled
379                  * e: followed by an event name, a space, and the event count/score
380                  *  event names can be:
381                  *   alivetime: total playing time of the player
382                  *   avglatency: average network latency compounded throughout the match
383                  *   wins: number of games won (can only be set if matches is set)
384                  *   matches: number of matches played to the end (not aborted by map switch)
385                  *   joins: number of matches joined (always 1 unless player never played during the match)
386                  *   scoreboardvalid: set to 1 if the player was there at the end of the match
387                  *   total-<scoreboardname>: total score of that scoreboard item
388                  *   scoreboard-<scoreboardname>: end-of-game score of that scoreboard item (can differ in non-team games)
389                  *   achievement-<achievementname>: achievement counters (their "count" is usually 1 if nonzero at all)
390                  *   kills-<index>: number of kills against the indexed player
391                  *   rank <number>: rank of player
392                  *   acc-<weapon netname>-hit: total damage dealt
393                  *   acc-<weapon netname>-fired: total damage that all fired projectiles *could* have dealt
394                  *   acc-<weapon netname>-cnt-hit: amount of shots that actually hit
395                  *   acc-<weapon netname>-cnt-fired: amount of fired shots
396                  *   acc-<weapon netname>-frags: amount of frags dealt by weapon
397                  */
398                 case URL_READY_CANWRITE:
399                 {
400                         url_fputs(fh, "V 9\n");
401                         #ifdef WATERMARK
402                         url_fputs(fh, sprintf("R %s\n", WATERMARK));
403                         #endif
404                         url_fputs(fh, sprintf("G %s\n", PlayerStats_GetGametype()));
405                         url_fputs(fh, sprintf("O %s\n", modname));
406                         url_fputs(fh, sprintf("M %s\n", GetMapname()));
407                         url_fputs(fh, sprintf("I %s\n", matchid));
408                         url_fputs(fh, sprintf("S %s\n", cvar_string("hostname")));
409                         url_fputs(fh, sprintf("C %d\n", cvar_purechanges_count));
410                         url_fputs(fh, sprintf("U %d\n", cvar("port")));
411                         url_fputs(fh, sprintf("D %f\n", max(0, time - game_starttime)));
412                         if (rounds_played > 0)
413                                 url_fputs(fh, sprintf("RP %d\n", rounds_played));
414                         if (autocvar_g_playerstats_gamereport_ladder != "")
415                                 url_fputs(fh, sprintf("L %s\n", autocvar_g_playerstats_gamereport_ladder));
416
417                         // TEAMS
418                         if(teamplay)
419                         {
420                                 for(t = PS_GR_OUT_TL; (tn = db_get(PS_GR_OUT_DB, sprintf("%d", stof(t)))) != ""; t = tn)
421                                 {
422                                         // start team section
423                                         url_fputs(fh, sprintf("Q team#%s\n", t));
424
425                                         // output team events // todo: does this do unnecessary loops? perhaps we should do a separate "team_events_last" tracker..."
426                                         for(e = PS_GR_OUT_EVL; (en = db_get(PS_GR_OUT_DB, sprintf("*:%s", e))) != ""; e = en)
427                                         {
428                                                 float v = stof(db_get(PS_GR_OUT_DB, sprintf("team#%d:%s", stof(t), e)));
429                                                 if(v != 0) { url_fputs(fh, sprintf("e %s %g\n", e, v)); }
430                                         }
431                                 }
432                         }
433
434                         // PLAYERS
435                         for(p = PS_GR_OUT_PL; (pn = db_get(PS_GR_OUT_DB, sprintf("%s:*", p))) != ""; p = pn)
436                         {
437                                 // start player section
438                                 url_fputs(fh, sprintf("P %s\n", p));
439
440                                 // playerid/index (entity number for this server)
441                                 nn = db_get(PS_GR_OUT_DB, sprintf("%s:_playerid", p));
442                                 if(nn != "") { url_fputs(fh, sprintf("i %s\n", nn)); }
443
444                                 // player name
445                                 nn = db_get(PS_GR_OUT_DB, sprintf("%s:_netname", p));
446                                 if(nn != "") { url_fputs(fh, sprintf("n %s\n", nn)); }
447
448                                 // team identification number
449                                 if(teamplay)
450                                 {
451                                         tt = db_get(PS_GR_OUT_DB, sprintf("%s:_team", p));
452                                         url_fputs(fh, sprintf("t %s\n", tt));
453                                 }
454
455                                 // elo ranking enabled
456                                 nn = db_get(PS_GR_OUT_DB, sprintf("%s:_ranked", p));
457                                 if(nn != "") { url_fputs(fh, sprintf("r %s\n", nn)); }
458
459                                 // output player events
460                                 for(e = PS_GR_OUT_EVL; (en = db_get(PS_GR_OUT_DB, sprintf("*:%s", e))) != ""; e = en)
461                                 {
462                                         float v = stof(db_get(PS_GR_OUT_DB, sprintf("%s:%s", p, e)));
463                                         if(v != 0) { url_fputs(fh, sprintf("e %s %g\n", e, v)); }
464                                 }
465                         }
466                         url_fputs(fh, "\n");
467                         url_fclose(fh);
468                         break;
469                 }
470
471                 // ======================================
472                 // -- INCOMING GAME REPORT INFORMATION --
473                 // ======================================
474                 /* SPECIFICATIONS:
475                  * stuff
476                  */
477                 case URL_READY_CANREAD:
478                 {
479                         // url_fclose is processing, we got a response for writing the data
480                         // this must come from HTTP
481                         LOG_DEBUG("Got response from player stats server:");
482                         while((s = url_fgets(fh))) { LOG_DEBUG("  ", s); }
483                         LOG_DEBUG("End of response.");
484                         url_fclose(fh);
485                         break;
486                 }
487
488                 case URL_READY_CLOSED:
489                 {
490                         // url_fclose has finished
491                         LOG_DEBUG("Player stats written");
492                         PlayerStats_GameReport_DelayMapVote = false;
493                         if(PS_GR_OUT_DB >= 0)
494                         {
495                                 db_close(PS_GR_OUT_DB);
496                                 PS_GR_OUT_DB = -1;
497                         }
498                         break;
499                 }
500
501                 case URL_READY_ERROR:
502                 default:
503                 {
504                         LOG_INFO("Player stats writing failed: ", ftos(status));
505                         PlayerStats_GameReport_DelayMapVote = false;
506                         if(PS_GR_OUT_DB >= 0)
507                         {
508                                 db_close(PS_GR_OUT_DB);
509                                 PS_GR_OUT_DB = -1;
510                         }
511                         break;
512                 }
513         }
514 }
515
516 void PlayerStats_PlayerBasic(entity joiningplayer, float newrequest)
517 {
518         GameRules_scoring_add(joiningplayer, ELO, -1);
519         // http://stats.xonotic.org/player/GgXRw6piDtFIbMArMuiAi8JG4tiin8VLjZgsKB60Uds=/elo.txt
520         if(autocvar_g_playerstats_playerbasic_uri != "")
521         {
522                 string uri = autocvar_g_playerstats_playerbasic_uri;
523                 if (joiningplayer.crypto_idfp == "") {
524                         GameRules_scoring_add(joiningplayer, ELO, -1);
525                 } else {
526                         // create the database if it doesn't already exist
527                         if(PS_B_IN_DB < 0)
528                                 PS_B_IN_DB = db_create();
529
530                         // now request the information
531                         uri = strcat(uri, "/player/", uri_escape(uri_escape(uri_escape(joiningplayer.crypto_idfp))), "/elo.txt");
532                         LOG_DEBUG("Retrieving playerstats from URL: ", uri);
533                         url_single_fopen(
534                                 uri,
535                                 FILE_APPEND,
536                                 PlayerStats_PlayerBasic_Handler,
537                                 joiningplayer
538                         );
539
540                         // set status appropriately // todo: check whether the player info exists in the database previously
541                         if(newrequest)
542                         {
543                                 // database still contains useful information, so don't clear it of a useful status
544                                 joiningplayer.playerstats_basicstatus = PS_B_STATUS_WAITING;
545                         }
546                         else
547                         {
548                                 // database was previously empty or never hit received status for some reason
549                                 joiningplayer.playerstats_basicstatus = PS_B_STATUS_UPDATING;
550                         }
551                 }
552         }
553         else
554         {
555                 // server has this disabled, kill the DB and set status to idle
556                 GameRules_scoring_add(joiningplayer, ELO, -1);
557                 if(PS_B_IN_DB >= 0)
558                 {
559                         db_close(PS_B_IN_DB);
560                         PS_B_IN_DB = -1;
561
562                         FOREACH_CLIENT(IS_REAL_CLIENT(it), it.playerstats_basicstatus = PS_B_STATUS_IDLE);
563                 }
564         }
565 }
566
567 SHUTDOWN(PlayerStats_PlayerBasic_Shutdown)
568 {
569         if(PS_B_IN_DB >= 0)
570         {
571                 db_close(PS_B_IN_DB);
572                 PS_B_IN_DB = -1;
573         }
574
575         if(PS_GR_OUT_DB >= 0)
576         {
577                 db_close(PS_GR_OUT_DB);
578                 PS_GR_OUT_DB = -1;
579         }
580 }
581
582 void PlayerStats_PlayerBasic_CheckUpdate(entity joiningplayer)
583 {
584         // determine whether we should retrieve playerbasic information again
585
586         LOG_DEBUGF("PlayerStats_PlayerBasic_CheckUpdate('%s'): %f",
587                 joiningplayer.netname,
588                 time
589         );
590
591         // TODO: check to see if this playerid is inside the database already somehow...
592         // for now we'll just check the field, but this won't work for players who disconnect and reconnect properly
593         // although maybe we should just submit another request ANYWAY?
594         if(!joiningplayer.playerstats_basicstatus)
595         {
596                 PlayerStats_PlayerBasic(
597                         joiningplayer,
598                         (joiningplayer.playerstats_basicstatus == PS_B_STATUS_RECEIVED)
599                 );
600         }
601 }
602
603 void PlayerStats_PlayerBasic_Handler(entity fh, entity p, float status)
604 {
605         switch(status)
606         {
607                 case URL_READY_CANWRITE:
608                 {
609                         LOG_DEBUG("-- Sending data to player stats server");
610                         /*url_fputs(fh, "V 1\n");
611                         #ifdef WATERMARK
612                         url_fputs(fh, sprintf("R %s\n", WATERMARK));
613                         #endif
614                         url_fputs(fh, sprintf("l %s\n", cvar_string("_menu_prvm_language"))); // language
615                         url_fputs(fh, sprintf("c %s\n", cvar_string("_menu_prvm_country"))); // country
616                         url_fputs(fh, sprintf("n %s\n", cvar_string("_cl_name"))); // name
617                         url_fputs(fh, sprintf("m %s %s\n", cvar_string("_cl_playermodel"), cvar_string("_cl_playerskin"))); // model/skin
618                         */url_fputs(fh, "\n");
619                         url_fclose(fh);
620                         return;
621                 }
622
623                 case URL_READY_CANREAD:
624                 {
625                         bool handled = false;
626                         string gt = string_null;
627                         for (string s = ""; (s = url_fgets(fh)); ) {
628                                 int n = tokenizebyseparator(s, " "); // key value? data
629                                 if (n == 1) continue;
630                                 string key = "", value = "", data = "";
631                                 if (n == 2) {
632                     key = argv(0);
633                     data = argv(1);
634                                 } else if (n >= 3) {
635                     key = argv(0);
636                     value = argv(1);
637                     data = argv(2);
638                                 }
639                 switch (key) {
640                     case "V":
641                         // PlayerInfo_AddItem(p, "_version", data);
642                         break;
643                     case "R":
644                         // PlayerInfo_AddItem(p, "_release", data);
645                         break;
646                     case "T":
647                         // PlayerInfo_AddItem(p, "_time", data);
648                         break;
649                     case "S":
650                         // PlayerInfo_AddItem(p, "_statsurl", data);
651                         break;
652                     case "P":
653                         // PlayerInfo_AddItem(p, "_hashkey", data);
654                         break;
655                     case "n":
656                         // PlayerInfo_AddItem(p, "_playernick", data);
657                         break;
658                     case "i":
659                         // PlayerInfo_AddItem(p, "_playerid", data);
660                         // p.xonstat_id = stof(data);
661                         break;
662                     case "G":
663                         gt = data;
664                         break;
665                     case "e":
666                         //LOG_TRACE("G: ", gt);
667                         //LOG_TRACE("e: ", data);
668                         if (gt == PlayerStats_GetGametype()) {
669                             handled = true;
670                             float e = stof(data);
671                             GameRules_scoring_add(p, ELO, +1 + e);
672                         }
673                         if (gt == "") {
674                             // PlayerInfo_AddItem(p, value, data);
675                         } else {
676                             // PlayerInfo_AddItem(p, sprintf("%s/%s", gt, value), data);
677                         }
678                         break;
679                 }
680                         }
681                         url_fclose(fh);
682                         if (handled) return;
683                         break;
684                 }
685                 case URL_READY_CLOSED:
686                 {
687                         // url_fclose has finished
688                         LOG_INFO("Player stats synchronized with server");
689                         return;
690                 }
691
692                 case URL_READY_ERROR:
693                 default:
694                 {
695                         LOG_INFO("Receiving player stats failed: ", ftos(status));
696                         break;
697                 }
698         }
699         GameRules_scoring_add(p, ELO, -1);
700 }
701 #endif // SVQC
702
703 #ifdef MENUQC
704
705
706 #if 0 // reading the entire DB at once
707         string e = "", en = "";
708         float i = 0;
709         for(e = PS_D_IN_EVL; (en = db_get(PS_D_IN_DB, e)) != ""; e = en)
710         {
711                 LOG_INFOF("%d:%s:%s", i, e, db_get(PS_D_IN_DB, sprintf("#%s", e)));
712                 ++i;
713         }
714 #endif
715
716 void PlayerStats_PlayerDetail_AddItem(string event, string data)
717 {
718         if(PS_D_IN_DB < 0) { return; }
719
720         // create a marker for the event so that we can access it later
721         string marker = sprintf("%s", event);
722         if(db_get(PS_D_IN_DB, marker) == "")
723         {
724                 if(PS_D_IN_EVL)
725                 {
726                         db_put(PS_D_IN_DB, marker, PS_D_IN_EVL);
727                         strunzone(PS_D_IN_EVL);
728                 }
729                 else { db_put(PS_D_IN_DB, marker, "#"); }
730                 PS_D_IN_EVL = strzone(marker);
731         }
732
733         // now actually set the event data
734         db_put(PS_D_IN_DB, sprintf("#%s", event), data);
735         LOG_DEBUG("Added item ", sprintf("#%s", event), "=", data, " to PS_D_IN_DB");
736 }
737
738 void PlayerStats_PlayerDetail()
739 {
740         // http://stats.xonotic.org/player/me
741         if((autocvar_g_playerstats_playerdetail_uri != "") && (crypto_getmyidstatus(0) > 0))
742         {
743                 // create the database if it doesn't already exist
744                 if(PS_D_IN_DB < 0)
745                         PS_D_IN_DB = db_create();
746
747                 //uri = strcat(uri, "/player/", uri_escape(crypto_getmyidfp(0)));
748                 LOG_DEBUG("Retrieving playerstats from URL: ", autocvar_g_playerstats_playerdetail_uri);
749                 url_single_fopen(
750                         autocvar_g_playerstats_playerdetail_uri,
751                         FILE_APPEND,
752                         PlayerStats_PlayerDetail_Handler,
753                         NULL
754                 );
755
756                 PlayerStats_PlayerDetail_Status = PS_D_STATUS_WAITING;
757         }
758         else
759         {
760                 // player has this disabled, kill the DB and set status to idle
761                 if(PS_D_IN_DB >= 0)
762                 {
763                         db_close(PS_D_IN_DB);
764                         PS_D_IN_DB = -1;
765                 }
766
767                 PlayerStats_PlayerDetail_Status = PS_D_STATUS_IDLE;
768         }
769 }
770
771 void PlayerStats_PlayerDetail_CheckUpdate()
772 {
773         // determine whether we should retrieve playerdetail information again
774         float gamecount = cvar("cl_matchcount");
775
776         #if 0
777         LOG_INFOF("PlayerStats_PlayerDetail_CheckUpdate(): %f >= %f, %d > %d",
778                 time,
779                 PS_D_NEXTUPDATETIME,
780                 PS_D_LASTGAMECOUNT,
781                 gamecount
782         );
783         #endif
784
785         if(
786                 (time >= PS_D_NEXTUPDATETIME)
787                 ||
788                 (gamecount > PS_D_LASTGAMECOUNT)
789         )
790         {
791                 PlayerStats_PlayerDetail();
792                 PS_D_NEXTUPDATETIME = (time + autocvar_g_playerstats_playerdetail_autoupdatetime);
793                 PS_D_LASTGAMECOUNT = gamecount;
794         }
795 }
796
797 void PlayerStats_PlayerDetail_Handler(entity fh, entity unused, float status)
798 {
799         switch(status)
800         {
801                 case URL_READY_CANWRITE:
802                 {
803                         LOG_DEBUG("PlayerStats_PlayerDetail_Handler(): Sending data to player stats server...");
804                         url_fputs(fh, "V 1\n");
805                         #ifdef WATERMARK
806                         url_fputs(fh, sprintf("R %s\n", WATERMARK));
807                         #endif
808                         url_fputs(fh, sprintf("l %s\n", cvar_string("_menu_prvm_language"))); // language
809                         //url_fputs(fh, sprintf("c %s\n", cvar_string("_cl_country"))); // country
810                         url_fputs(fh, sprintf("n %s\n", cvar_string("_cl_name"))); // name
811                         url_fputs(fh, sprintf("m %s %s\n", cvar_string("_cl_playermodel"), cvar_string("_cl_playerskin"))); // model/skin
812                         url_fputs(fh, "\n");
813                         url_fclose(fh);
814                         break;
815                 }
816
817                 case URL_READY_CANREAD:
818                 {
819                         //print("PlayerStats_PlayerDetail_Handler(): Got response from player stats server:\n");
820                         string input = "";
821                         string gametype = "overall";
822                         while((input = url_fgets(fh)))
823                         {
824                                 float count = tokenizebyseparator(input, " ");
825                                 string key = "", event = "", data = "";
826
827                                 if(argv(0) == "#") { continue; }
828
829                                 if(count == 2)
830                                 {
831                                         key = argv(0);
832                                         data = substring(input, argv_start_index(1), strlen(input) - argv_start_index(1));
833                                 }
834                                 else if(count >= 3)
835                                 {
836                                         key = argv(0);
837                                         event = argv(1);
838                                         data = substring(input, argv_start_index(2), strlen(input) - argv_start_index(2));
839                                 }
840                                 else { continue; }
841
842                                 switch(key)
843                                 {
844                                         // general info
845                                         case "V": PlayerStats_PlayerDetail_AddItem("version", data); break;
846                                         case "R": PlayerStats_PlayerDetail_AddItem("release", data); break;
847                                         case "T": PlayerStats_PlayerDetail_AddItem("time", data); break;
848
849                                         // player info
850                                         case "S": PlayerStats_PlayerDetail_AddItem("statsurl", data); break;
851                                         case "P": PlayerStats_PlayerDetail_AddItem("hashkey", data); break;
852                                         case "n": PlayerStats_PlayerDetail_AddItem("playernick", data); break;
853                                         case "i": PlayerStats_PlayerDetail_AddItem("playerid", data); break;
854
855                                         // other/event info
856                                         case "G": gametype = data; break;
857                                         case "e":
858                                         {
859                                                 if(event != "" && data != "")
860                                                 {
861                                                         PlayerStats_PlayerDetail_AddItem(
862                                                                 sprintf(
863                                                                         "%s/%s",
864                                                                         gametype,
865                                                                         event
866                                                                 ),
867                                                                 data
868                                                         );
869                                                 }
870                                                 break;
871                                         }
872
873                                         default:
874                                         {
875                                                 LOG_INFOF(
876                                                         "PlayerStats_PlayerDetail_Handler(): ERROR: "
877                                                         "Key went unhandled? Is our version outdated?\n"
878                                                         "PlayerStats_PlayerDetail_Handler(): "
879                                                         "Key '%s', Event '%s', Data '%s'",
880                                                         key,
881                                                         event,
882                                                         data
883                                                 );
884                                                 break;
885                                         }
886                                 }
887
888                                 #if 0
889                                 LOG_INFOF(
890                                         "PlayerStats_PlayerDetail_Handler(): "
891                                         "Key '%s', Event '%s', Data '%s'",
892                                         key,
893                                         event,
894                                         data
895                                 );
896                                 #endif
897                         }
898                         //print("PlayerStats_PlayerDetail_Handler(): End of response.\n");
899                         url_fclose(fh);
900                         PlayerStats_PlayerDetail_Status = PS_D_STATUS_RECEIVED;
901                         statslist.getStats(statslist);
902                         break;
903                 }
904
905                 case URL_READY_CLOSED:
906                 {
907                         // url_fclose has finished
908                         LOG_INFO("PlayerStats_PlayerDetail_Handler(): Player stats synchronized with server.");
909                         break;
910                 }
911
912                 case URL_READY_ERROR:
913                 default:
914                 {
915                         LOG_INFO("PlayerStats_PlayerDetail_Handler(): Receiving player stats failed: ", ftos(status));
916                         PlayerStats_PlayerDetail_Status = PS_D_STATUS_ERROR;
917                         if(PS_D_IN_DB >= 0)
918                         {
919                                 db_close(PS_D_IN_DB);
920                                 PS_D_IN_DB = -1;
921                         }
922                         break;
923                 }
924         }
925 }
926 #endif
927
928 /*
929 void PlayerInfo_AddPlayer(entity e)
930 {
931         if(playerinfo_db < 0)
932                 return;
933
934         string key;
935         key = sprintf("#%d:*", e.playerid); // TODO: use hashkey instead?
936
937         string p;
938         p = db_get(playerinfo_db, key);
939         if(p == "")
940         {
941                 if(playerinfo_last)
942                 {
943                         db_put(playerinfo_db, key, playerinfo_last);
944                         strunzone(playerinfo_last);
945                 }
946                 else
947                         db_put(playerinfo_db, key, "#");
948                 playerinfo_last = strzone(ftos(e.playerid));
949                 print("  Added player ", ftos(e.playerid), " to playerinfo_db\n");//DEBUG//
950         }
951 }
952
953 void PlayerInfo_AddItem(entity e, string item_id, string val)
954 {
955         if(playerinfo_db < 0)
956                 return;
957
958         string key;
959         key = sprintf("*:%s", item_id);
960
961         string p;
962         p = db_get(playerinfo_db, key);
963         if(p == "")
964         {
965                 if(playerinfo_events_last)
966                 {
967                         db_put(playerinfo_db, key, playerinfo_events_last);
968                         strunzone(playerinfo_events_last);
969                 }
970                 else
971                         db_put(playerinfo_db, key, "#");
972                 playerinfo_events_last = strzone(item_id);
973         }
974
975         key = sprintf("#%d:%s", e.playerid, item_id);
976         db_put(playerinfo_db, key, val);
977         print("  Added item ", key, "=", val, " to playerinfo_db\n");//DEBUG//
978 }
979
980 string PlayerInfo_GetItem(entity e, string item_id)
981 {
982         if(playerinfo_db < 0)
983                 return "";
984
985         string key;
986         key = sprintf("#%d:%s",  e.playerid, item_id);
987         return db_get(playerinfo_db, key);
988 }
989
990 string PlayerInfo_GetItemLocal(string item_id)
991 {
992         entity p = spawn();
993         p.playerid = 0;
994         return PlayerInfo_GetItem(p, item_id);
995 }
996
997 void PlayerInfo_ready(entity fh, entity p, float status)
998 {
999         float n;
1000         string s;
1001
1002         PlayerInfo_AddPlayer(p);
1003
1004         switch(status)
1005         {
1006                 case URL_READY_CANWRITE:
1007                         print("-- Sending data to player stats server\n");
1008                         url_fputs(fh, "V 1\n");
1009 #ifdef WATERMARK
1010                         url_fputs(fh, sprintf("R %s\n", WATERMARK));
1011 #endif
1012 #ifdef MENUQC
1013                         url_fputs(fh, sprintf("l %s\n", cvar_string("_menu_prvm_language"))); // language
1014                         url_fputs(fh, sprintf("c %s\n", cvar_string("_menu_prvm_country"))); // country
1015                         url_fputs(fh, sprintf("n %s\n", cvar_string("_cl_name"))); // name
1016                         url_fputs(fh, sprintf("m %s %s\n", cvar_string("_cl_playermodel"), cvar_string("_cl_playerskin"))); // model/skin
1017 #endif
1018                         url_fputs(fh, "\n");
1019                         url_fclose(fh);
1020                         break;
1021                 case URL_READY_CANREAD:
1022                         print("-- Got response from player stats server:\n");
1023                         string gametype = string_null;
1024                         while((s = url_fgets(fh)))
1025                         {
1026                                 print("  ", s, "\n");
1027
1028                                 string key = "", value = "", data = "";
1029
1030                                 n = tokenizebyseparator(s, " "); // key (value) data
1031                                 if (n == 1)
1032                                         continue;
1033                                 else if (n == 2)
1034                                 {
1035                                         key = argv(0);
1036                                         data = argv(1);
1037                                 }
1038                                 else if (n >= 3)
1039                                 {
1040                                         key = argv(0);
1041                                         value = argv(1);
1042                                         data = argv(2);
1043                                 }
1044
1045                                 if (data == "")
1046                                         continue;
1047
1048                                 if (key == "#")
1049                                         continue;
1050                                 else if (key == "V")
1051                                         PlayerInfo_AddItem(p, "_version", data);
1052                                 else if (key == "R")
1053                                         PlayerInfo_AddItem(p, "_release", data);
1054                                 else if (key == "T")
1055                                         PlayerInfo_AddItem(p, "_time", data);
1056                                 else if (key == "S")
1057                                         PlayerInfo_AddItem(p, "_statsurl", data);
1058                                 else if (key == "P")
1059                                         PlayerInfo_AddItem(p, "_hashkey", data);
1060                                 else if (key == "n")
1061                                         PlayerInfo_AddItem(p, "_playernick", data);
1062                                 else if (key == "i")
1063                                         PlayerInfo_AddItem(p, "_playerid", data);
1064                                 else if (key == "G")
1065                                         gametype = data;
1066                                 else if (key == "e" && value != "")
1067                                 {
1068                                         if (gametype == "")
1069                                                 PlayerInfo_AddItem(p, value, data);
1070                                         else
1071                                                 PlayerInfo_AddItem(p, sprintf("%s/%s", gametype, value), data);
1072                                 }
1073                                 else
1074                                         continue;
1075                         }
1076                         print("-- End of response.\n");
1077                         url_fclose(fh);
1078                         break;
1079                 case URL_READY_CLOSED:
1080                         // url_fclose has finished
1081                         print("Player stats synchronized with server\n");
1082                         break;
1083                 case URL_READY_ERROR:
1084                 default:
1085                         print("Receiving player stats failed: ", ftos(status), "\n");
1086                         break;
1087         }
1088 }
1089
1090 void PlayerInfo_Init()
1091 {
1092         playerinfo_db = db_create();
1093 }
1094
1095 #ifdef SVQC
1096 void PlayerInfo_Basic(entity p)
1097 {
1098         print("-- Getting basic PlayerInfo for player ",ftos(p.playerid)," (SVQC)\n");
1099
1100         if(playerinfo_db < 0)
1101                 return;
1102
1103         string uri;
1104         uri = autocvar_g_playerinfo_uri;
1105         if(uri != "" && p.crypto_idfp != "")
1106         {
1107                 uri = strcat(uri, "/elo/", uri_escape(p.crypto_idfp));
1108                 print("Retrieving playerstats from URL: ", uri, "\n");
1109                 url_single_fopen(uri, FILE_READ, PlayerInfo_ready, p);
1110         }
1111 }
1112 #endif
1113
1114 #ifdef MENUQC
1115 void PlayerInfo_Details()
1116 {
1117         print("-- Getting detailed PlayerInfo for local player (MENUQC)\n");
1118
1119         if(playerinfo_db < 0)
1120                 return;
1121
1122         string uri;
1123         uri = autocvar_g_playerinfo_uri; // FIXME
1124         if(uri != "" && crypto_getmyidstatus(0) > 0)
1125         {
1126                 //uri = strcat(uri, "/player/", uri_escape(crypto_getmyidfp(0)));
1127                 uri = strcat(uri, "/player/me");
1128                 print("Retrieving playerstats from URL: ", uri, "\n");
1129                 url_single_fopen(uri, FILE_APPEND, PlayerInfo_ready, NULL);
1130         }
1131 }
1132 #endif
1133
1134 #ifdef CSQC
1135 // FIXME - crypto_* builtin functions missing in CSQC (csprogsdefs.qh:885)
1136 void PlayerInfo_Details()
1137 {
1138         print("-- Getting detailed PlayerInfo for local player (CSQC)\n");
1139
1140         if(playerinfo_db < 0)
1141                 return;
1142
1143         string uri;
1144         uri = autocvar_g_playerinfo_uri; // FIXME
1145         if(uri != "" && crypto_getmyidstatus(0) > 0)
1146         {
1147                 uri = strcat(uri, "/player/", uri_escape(crypto_getmyidfp(0)));
1148                 print("Retrieving playerstats from URL: ", uri, "\n");
1149                 url_single_fopen(uri, FILE_READ, PlayerInfo_ready, p);
1150         }
1151 }
1152
1153 #endif
1154 */