]> de.git.xonotic.org Git - xonotic/xonotic-data.pk3dir.git/blob - qcsrc/common/playerstats.qc
Update playerdetail database handler, actually BUILD the databases
[xonotic/xonotic-data.pk3dir.git] / qcsrc / common / playerstats.qc
1 #ifdef SVQC
2 //float PS_PM_IN_DB;   // playerstats_prematch_in_db      // db for info COLLECTED at the beginning of a match
3 float PS_GR_OUT_DB;  // playerstats_gamereport_out_db   // db of info SENT at the end of a match
4 //float PS_GR_IN_DB;   // playerstats_gamereport_in_db    // db for info COLLECTED at the end of a match
5 //float PS_B_IN_DB;    // playerstats_playerbasic_in_db   // db for info COLLECTED for basic player info (ELO)
6 // http://stats.xonotic.org/player/GgXRw6piDtFIbMArMuiAi8JG4tiin8VLjZgsKB60Uds=/elo.txt -- this works, 
7 // http://stats.xonotic.org/player/ENkUjf83vKMVZcNm%2F6Ao1EmXEj1apQ6XvdQTxwELvmA%3D/elo.txt -- but this doesn't?!?
8 // ENkUjf83vKMVZcNm/6Ao1EmXEj1apQ6XvdQTxwELvmA=
9 #endif
10
11 #ifdef MENUQC
12 float PS_D_IN_DB; // playerstats_playerdetail_in_db  // db for info COLLECTED for detailed player profile display
13 // http://stats.xonotic.org/player/me
14 #endif
15
16 #ifdef SVQC
17 //string PS_PM_IN_EVL;   // playerstats_prematch_in_events_last
18 string PS_GR_OUT_TL;   // playerstats_gamereport_out_teams_last
19 string PS_GR_OUT_PL;   // playerstats_gamereport_out_players_las
20 string PS_GR_OUT_EVL;  // playerstats_gamereport_out_events_last
21 //string PS_GR_IN_PL;    // playerstats_gamereport_in_players_last
22 //string PS_GR_IN_EVL;   // playerstats_gamereport_in_events_last
23 //string PS_B_IN_PL;     // playerstats_playerbasic_in_players_last
24 //string PS_B_IN_EVL;    // playerstats_playerbasic_in_events_last
25 #endif
26
27 #ifdef MENUQC
28 string PS_D_IN_EVL; // playerstats_playerdetail_in_events_last
29 #endif
30
31 #ifdef SVQC
32 void PlayerStats_Prematch(void)
33 {
34         //foobar
35 }
36
37 void PlayerStats_GameReport_AddPlayer(entity e)
38 {
39         if((PS_GR_OUT_DB < 0) || (e.playerstats_id)) { return; }
40
41         // set up player identification
42         string s = string_null;
43
44         if((e.crypto_idfp != "") && (e.cvar_cl_allow_uidtracking == 1))
45                 { s = e.crypto_idfp; }
46         else if(IS_BOT_CLIENT(e))
47                 { s = sprintf("bot#%g#%s", skill, e.cleanname); }
48                 
49         if((s == "") || find(world, playerstats_id, s)) // already have one of the ID - next one can't be tracked then!
50         {
51                 if(IS_BOT_CLIENT(e))
52                         { s = sprintf("bot#%d", e.playerid); }
53                 else
54                         { s = sprintf("player#%d", e.playerid); }
55         }
56         
57         e.playerstats_id = strzone(s);
58
59         // now add the player to the database
60         string key = sprintf("%s:*", e.playerstats_id);
61         string p = db_get(PS_GR_OUT_DB, key);
62         
63         if(p == "")
64         {
65                 if(PS_GR_OUT_PL)
66                 {
67                         db_put(PS_GR_OUT_DB, key, PS_GR_OUT_PL);
68                         strunzone(PS_GR_OUT_PL);
69                 }
70                 else { db_put(PS_GR_OUT_DB, key, "#"); }
71                 PS_GR_OUT_PL = strzone(e.playerstats_id);
72         }
73 }
74
75 void PlayerStats_GameReport_AddTeam(float t)
76 {
77         if(PS_GR_OUT_DB < 0) { return; }
78
79         string key = sprintf("%d", t);
80         string p = db_get(PS_GR_OUT_DB, key);
81         
82         if(p == "")
83         {
84                 if(PS_GR_OUT_TL)
85                 {
86                         db_put(PS_GR_OUT_DB, key, PS_GR_OUT_TL);
87                         strunzone(PS_GR_OUT_TL);
88                 }
89                 else { db_put(PS_GR_OUT_DB, key, "#"); }
90                 PS_GR_OUT_TL = strzone(key);
91         }
92 }
93
94 void PlayerStats_GameReport_AddEvent(string event_id)
95 {
96         if(PS_GR_OUT_DB < 0) { return; }
97
98         string key = sprintf("*:%s", event_id);
99         string p = db_get(PS_GR_OUT_DB, key);
100         
101         if(p == "")
102         {
103                 if(PS_GR_OUT_EVL)
104                 {
105                         db_put(PS_GR_OUT_DB, key, PS_GR_OUT_EVL);
106                         strunzone(PS_GR_OUT_EVL);
107                 }
108                 else { db_put(PS_GR_OUT_DB, key, "#"); }
109                 PS_GR_OUT_EVL = strzone(event_id);
110         }
111 }
112
113 // referred to by PS_GR_P_ADDVAL and PS_GR_T_ADDVAL
114 float PlayerStats_GameReport_Event(string prefix, string event_id, float value)
115 {
116         if((prefix == "") || PS_GR_OUT_DB < 0) { return 0; }
117
118         string key = sprintf("%s:%s", prefix, event_id);
119         float val = stof(db_get(PS_GR_OUT_DB, key));
120         val += value;
121         db_put(PS_GR_OUT_DB, key, ftos(val));
122         return val;
123 }
124
125 void PlayerStats_GameReport_Accuracy(entity p)
126 {
127         entity w;
128         float i;
129
130         for(i = WEP_FIRST; i <= WEP_LAST; ++i)
131         {
132                 w = get_weaponinfo(i);
133
134                 #define ACCMAC(suffix,field) \
135                         PS_GR_P_ADDVAL(p, sprintf("acc-%s-%s", w.netname, suffix), p.accuracy.(field[i-1]));
136
137                 ACCMAC("hit", accuracy_hit)
138                 ACCMAC("fired", accuracy_fired)
139                 ACCMAC("cnt-hit", accuracy_cnt_hit)
140                 ACCMAC("cnt-fired", accuracy_cnt_fired)
141                 ACCMAC("frags", accuracy_frags)
142
143                 #undef ACCMAC
144         }
145 }
146
147 void PlayerStats_GameReport_FinalizePlayer(entity p)
148 {
149         if((p.playerstats_id == "") || PS_GR_OUT_DB < 0) { return; }
150
151         // add global info!
152         if(p.alivetime)
153         {
154                 PS_GR_P_ADDVAL(p, PLAYERSTATS_ALIVETIME, time - p.alivetime);
155                 p.alivetime = 0;
156         }
157
158         db_put(PS_GR_OUT_DB, sprintf("%s:_playerid", p.playerstats_id), ftos(p.playerid));
159
160         if(p.cvar_cl_allow_uid2name == 1 || IS_BOT_CLIENT(p))
161                 db_put(PS_GR_OUT_DB, sprintf("%s:_netname", p.playerstats_id), p.netname);
162
163         if(teamplay)
164                 db_put(PS_GR_OUT_DB, sprintf("%s:_team", p.playerstats_id), ftos(p.team));
165
166         if(stof(db_get(PS_GR_OUT_DB, sprintf("%s:%s", p.playerstats_id, PLAYERSTATS_ALIVETIME))) > 0)
167                 PS_GR_P_ADDVAL(p, PLAYERSTATS_JOINS, 1);
168
169         PlayerStats_GameReport_Accuracy(p);
170
171         if(IS_REAL_CLIENT(p))
172         {
173                 if(p.latency_cnt)
174                 {
175                         float latency = (p.latency_sum / p.latency_cnt);
176                         if(latency) { PS_GR_P_ADDVAL(p, PLAYERSTATS_AVGLATENCY, latency); }
177                 }
178         }
179
180         strunzone(p.playerstats_id);
181         p.playerstats_id = string_null;
182 }
183
184 void PlayerStats_GameReport(float finished)
185 {
186         if(PS_GR_OUT_DB < 0) { return; }
187         
188         PlayerScore_Sort(score_dummyfield, 0, 0, 0);
189         PlayerScore_Sort(scoreboard_pos, 1, 1, 1);
190         if(teamplay) { PlayerScore_TeamStats(); }
191
192         entity p;
193         FOR_EACH_CLIENT(p)
194         {
195                 // add personal score rank
196                 PS_GR_P_ADDVAL(p, PLAYERSTATS_RANK, p.score_dummyfield);
197
198                 // scoreboard data
199                 if(p.scoreboard_pos)
200                 {
201                         // scoreboard is valid!
202                         PS_GR_P_ADDVAL(p, PLAYERSTATS_SCOREBOARD_VALID, 1);
203
204                         // add scoreboard position
205                         PS_GR_P_ADDVAL(p, PLAYERSTATS_SCOREBOARD_POS, p.scoreboard_pos);
206
207                         // add scoreboard data
208                         PlayerScore_PlayerStats(p);
209
210                         // if the match ended normally, add winning info
211                         if(finished)
212                         {
213                                 PS_GR_P_ADDVAL(p, PLAYERSTATS_WINS, p.winning);
214                                 PS_GR_P_ADDVAL(p, PLAYERSTATS_MATCHES, 1);
215                         }
216                 }
217
218                 // collect final player information
219                 PlayerStats_GameReport_FinalizePlayer(p);
220         }
221
222         if(autocvar_g_playerstats_gamereport_uri != "")
223         {
224                 PlayerStats_GameReport_DelayMapVote = TRUE;
225                 url_multi_fopen(
226                         autocvar_g_playerstats_gamereport_uri,
227                         FILE_APPEND,
228                         PlayerStats_GameReport_Handler,
229                         world
230                 );
231         }
232         else
233         {
234                 PlayerStats_GameReport_DelayMapVote = FALSE;
235                 db_close(PS_GR_OUT_DB);
236                 PS_GR_OUT_DB = -1;
237         }
238 }
239
240 void PlayerStats_GameReport_Init() // initiated before InitGameplayMode so that scores are added properly
241 {
242         if(autocvar_g_playerstats_gamereport_uri == "") { return; }
243
244         PS_GR_OUT_DB = -1;
245         PS_GR_OUT_DB = db_create();
246
247         if(PS_GR_OUT_DB >= 0)
248         {
249                 PlayerStats_GameReport_DelayMapVote = TRUE;
250
251                 serverflags |= SERVERFLAG_PLAYERSTATS;
252
253                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ALIVETIME);
254                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_AVGLATENCY);
255                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_WINS);
256                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_MATCHES);
257                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_JOINS);
258                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_SCOREBOARD_VALID);
259                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_SCOREBOARD_POS);
260                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_RANK);
261
262                 // accuracy stats
263                 entity w;
264                 float i;
265                 for(i = WEP_FIRST; i <= WEP_LAST; ++i)
266                 {
267                         w = get_weaponinfo(i);
268                         PlayerStats_GameReport_AddEvent(strcat("acc-", w.netname, "-hit"));
269                         PlayerStats_GameReport_AddEvent(strcat("acc-", w.netname, "-fired"));
270                         PlayerStats_GameReport_AddEvent(strcat("acc-", w.netname, "-cnt-hit"));
271                         PlayerStats_GameReport_AddEvent(strcat("acc-", w.netname, "-cnt-fired"));
272                         PlayerStats_GameReport_AddEvent(strcat("acc-", w.netname, "-frags"));
273                 }
274
275                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_3);
276                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_5);
277                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_10);
278                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_15);
279                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_20);
280                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_25);
281                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_KILL_SPREE_30);
282                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_BOTLIKE);
283                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_FIRSTBLOOD);
284                 PlayerStats_GameReport_AddEvent(PLAYERSTATS_ACHIEVEMENT_FIRSTVICTIM);
285         }
286         else { PlayerStats_GameReport_DelayMapVote = FALSE; }
287 }
288
289 void PlayerStats_GameReport_Handler(entity fh, entity pass, float status)
290 {
291         string t, tn;
292         string p, pn;
293         string e, en;
294         string nn, tt;
295         string s;
296
297         switch(status)
298         {
299                 // ======================================
300                 // -- OUTGOING GAME REPORT INFORMATION --
301                 // ======================================
302                 /* SPECIFICATIONS:
303                  * V: format version (always a fixed number) - this MUST be the first line!
304                  * #: comment (MUST be ignored by any parser)
305                  * R: release information on the server
306                  * G: game type
307                  * O: mod name (icon request) as in server browser
308                  * M: map name
309                  * I: match ID (see "matchid" in g_world.qc)
310                  * S: "hostname" of the server
311                  * C: number of "unpure" cvar changes
312                  * U: UDP port number of the server
313                  * D: duration of the match
314                  * L: "ladder" in which the server is participating in
315                  * P: player ID of an existing player; this also sets the owner for all following "n", "e" and "t" lines (lower case!)
316                  * Q: team number of an existing team (format: team#NN); this also sets the owner for all following "e" lines (lower case!)
317                  * i: player index
318                  * n: nickname of the player (optional)
319                  * t: team ID
320                  * e: followed by an event name, a space, and the event count/score
321                  *  event names can be:
322                  *   alivetime: total playing time of the player
323                  *   avglatency: average network latency compounded throughout the match
324                  *   wins: number of games won (can only be set if matches is set)
325                  *   matches: number of matches played to the end (not aborted by map switch)
326                  *   joins: number of matches joined (always 1 unless player never played during the match)
327                  *   scoreboardvalid: set to 1 if the player was there at the end of the match
328                  *   total-<scoreboardname>: total score of that scoreboard item
329                  *   scoreboard-<scoreboardname>: end-of-game score of that scoreboard item (can differ in non-team games)
330                  *   achievement-<achievementname>: achievement counters (their "count" is usually 1 if nonzero at all)
331                  *   kills-<index>: number of kills against the indexed player
332                  *   rank <number>: rank of player
333                  *   acc-<weapon netname>-hit: total damage dealt
334                  *   acc-<weapon netname>-fired: total damage that all fired projectiles *could* have dealt
335                  *   acc-<weapon netname>-cnt-hit: amount of shots that actually hit
336                  *   acc-<weapon netname>-cnt-fired: amount of fired shots
337                  *   acc-<weapon netname>-frags: amount of frags dealt by weapon
338                  */
339                 case URL_READY_CANWRITE:
340                 {
341                         url_fputs(fh, "V 9\n");
342                         #ifdef WATERMARK
343                         url_fputs(fh, sprintf("R %s\n", WATERMARK));
344                         #endif
345                         url_fputs(fh, sprintf("G %s\n", GetGametype()));
346                         url_fputs(fh, sprintf("O %s\n", modname));
347                         url_fputs(fh, sprintf("M %s\n", GetMapname()));
348                         url_fputs(fh, sprintf("I %s\n", matchid));
349                         url_fputs(fh, sprintf("S %s\n", cvar_string("hostname")));
350                         url_fputs(fh, sprintf("C %d\n", cvar_purechanges_count));
351                         url_fputs(fh, sprintf("U %d\n", cvar("port")));
352                         url_fputs(fh, sprintf("D %f\n", max(0, time - game_starttime)));
353                         url_fputs(fh, sprintf("L %s\n", autocvar_g_playerstats_gamereport_ladder));
354
355                         // TEAMS
356                         if(teamplay)
357                         {
358                                 for(t = PS_GR_OUT_TL; (tn = db_get(PS_GR_OUT_DB, sprintf("%d", stof(t)))) != ""; t = tn)
359                                 {
360                                         // start team section
361                                         url_fputs(fh, sprintf("Q team#%s\n", t));
362
363                                         // output team events // todo: does this do unnecessary loops? perhaps we should do a separate "team_events_last" tracker..."
364                                         for(e = PS_GR_OUT_EVL; (en = db_get(PS_GR_OUT_DB, sprintf("*:%s", e))) != ""; e = en)
365                                         {
366                                                 float v = stof(db_get(PS_GR_OUT_DB, sprintf("team#%d:%s", stof(t), e)));
367                                                 if(v != 0) { url_fputs(fh, sprintf("e %s %g\n", e, v)); }
368                                         }
369                                 }
370                         }
371
372                         // PLAYERS
373                         for(p = PS_GR_OUT_PL; (pn = db_get(PS_GR_OUT_DB, sprintf("%s:*", p))) != ""; p = pn)
374                         {
375                                 // start player section
376                                 url_fputs(fh, sprintf("P %s\n", p));
377
378                                 // playerid/index (entity number for this server)
379                                 nn = db_get(PS_GR_OUT_DB, sprintf("%s:_playerid", p));
380                                 if(nn != "") { url_fputs(fh, sprintf("i %s\n", nn)); }
381
382                                 // player name 
383                                 nn = db_get(PS_GR_OUT_DB, sprintf("%s:_netname", p));
384                                 if(nn != "") { url_fputs(fh, sprintf("n %s\n", nn)); }
385
386                                 // team identification number
387                                 if(teamplay)
388                                 {
389                                         tt = db_get(PS_GR_OUT_DB, sprintf("%s:_team", p));
390                                         url_fputs(fh, sprintf("t %s\n", tt));
391                                 }
392
393                                 // output player events
394                                 for(e = PS_GR_OUT_EVL; (en = db_get(PS_GR_OUT_DB, sprintf("*:%s", e))) != ""; e = en)
395                                 {
396                                         float v = stof(db_get(PS_GR_OUT_DB, sprintf("%s:%s", p, e)));
397                                         if(v != 0) { url_fputs(fh, sprintf("e %s %g\n", e, v)); }
398                                 }
399                         }
400                         url_fputs(fh, "\n");
401                         url_fclose(fh);
402                         break;
403                 }
404
405                 // ======================================
406                 // -- INCOMING GAME REPORT INFORMATION --
407                 // ======================================
408                 /* SPECIFICATIONS:
409                  * stuff
410                  */
411                 case URL_READY_CANREAD:
412                 {
413                         // url_fclose is processing, we got a response for writing the data
414                         // this must come from HTTP
415                         print("Got response from player stats server:\n");
416                         while((s = url_fgets(fh))) { print("  ", s, "\n"); }
417                         print("End of response.\n");
418                         url_fclose(fh);
419                         break;
420                 }
421                 
422                 case URL_READY_CLOSED:
423                 {
424                         // url_fclose has finished
425                         print("Player stats written\n");
426                         PlayerStats_GameReport_DelayMapVote = FALSE;
427                         db_close(PS_GR_OUT_DB);
428                         PS_GR_OUT_DB = -1;
429                         break;
430                 }
431                 
432                 case URL_READY_ERROR:
433                 default:
434                 {
435                         print("Player stats writing failed: ", ftos(status), "\n");
436                         PlayerStats_GameReport_DelayMapVote = FALSE;
437                         if(PS_GR_OUT_DB >= 0)
438                         {
439                                 db_close(PS_GR_OUT_DB);
440                                 PS_GR_OUT_DB = -1;
441                         }
442                         break;
443                 }
444         }
445 }
446
447 void PlayerStats_PlayerBasic()
448 {
449         entity player;
450         //PS_D_IN_DB = -1;
451         //PS_D_IN_DB = db_create();
452
453         //if(PS_D_IN_DB < 0) { return; }
454
455         FOR_EACH_REALCLIENT(player)
456         {
457                 string uri = autocvar_g_playerstats_playerbasic_uri;
458                 if((uri != "") && (player.crypto_idfp != ""))
459                 {
460                         uri = strcat(uri, "/player/", uri_escape(uri_escape(player.crypto_idfp)), "/elo.txt");
461                         print("Retrieving playerstats from URL: ", uri, "\n");
462                         url_single_fopen(
463                                 uri,
464                                 FILE_APPEND,
465                                 PlayerStats_PlayerBasic_Handler,
466                                 player
467                         );
468                 }
469
470                 /*p.crypto_idfp != "")
471                 {
472                         uri = strcat(uri, "/elo/", uri_escape(p.crypto_idfp));
473                         print("Retrieving playerstats from URL: ", uri, "\n");
474                         url_single_fopen(uri, FILE_READ, PlayerInfo_ready, p);
475                 }*/
476         }
477 }
478
479 void PlayerStats_PlayerBasic_Handler(entity fh, entity p, float status)
480 {
481         switch(status)
482         {
483                 case URL_READY_CANWRITE:
484                 {
485                         print("-- Sending data to player stats server\n");
486                         /*url_fputs(fh, "V 1\n");
487                         #ifdef WATERMARK
488                         url_fputs(fh, sprintf("R %s\n", WATERMARK));
489                         #endif
490                         url_fputs(fh, sprintf("l %s\n", cvar_string("_menu_prvm_language"))); // language
491                         url_fputs(fh, sprintf("c %s\n", cvar_string("_menu_prvm_country"))); // country
492                         url_fputs(fh, sprintf("g %s\n", cvar_string("_menu_prvm_gender"))); // gender
493                         url_fputs(fh, sprintf("n %s\n", cvar_string("_cl_name"))); // name
494                         url_fputs(fh, sprintf("m %s %s\n", cvar_string("_cl_playermodel"), cvar_string("_cl_playerskin"))); // model/skin
495                         */url_fputs(fh, "\n");
496                         url_fclose(fh);
497                         break;
498                 }
499                 
500                 case URL_READY_CANREAD:
501                 {
502                         string s = "";
503                         print("-- Got response from player stats server:\n");
504                         //string gametype = string_null;
505                         while((s = url_fgets(fh)))
506                         {
507                                 print("  ", s, "\n");
508                                 /*
509                                 string key = "", value = "", data = "";
510
511                                 n = tokenizebyseparator(s, " "); // key (value) data
512                                 if (n == 1)
513                                         continue;
514                                 else if (n == 2)
515                                 {
516                                 key = argv(0);
517                                 data = argv(1);
518                                 }
519                                 else if (n >= 3)
520                                 {
521                                                                 key = argv(0);
522                                                                 value = argv(1);
523                                                                 data = argv(2);
524                                 }
525
526                                 if (data == "")
527                                 continue;
528
529                                 if (key == "#")
530                                 continue;
531                                 else if (key == "V")
532                                 PlayerInfo_AddItem(p, "_version", data);
533                                 else if (key == "R")
534                                 PlayerInfo_AddItem(p, "_release", data);
535                                 else if (key == "T")
536                                 PlayerInfo_AddItem(p, "_time", data);
537                                 else if (key == "S")
538                                 PlayerInfo_AddItem(p, "_statsurl", data);
539                                 else if (key == "P")
540                                 PlayerInfo_AddItem(p, "_hashkey", data);
541                                 else if (key == "n")
542                                 PlayerInfo_AddItem(p, "_playernick", data);
543                                 else if (key == "i")
544                                 PlayerInfo_AddItem(p, "_playerid", data);
545                                 else if (key == "G")
546                                 gametype = data;
547                                 else if (key == "e" && value != "")
548                                 {
549                                 if (gametype == "")
550                                 PlayerInfo_AddItem(p, value, data);
551                                 else
552                                 PlayerInfo_AddItem(p, sprintf("%s/%s", gametype, value), data);
553                                 }
554                                 else
555                                 continue;
556                                 */
557                         }
558                         print("-- End of response.\n");
559                         url_fclose(fh);
560                         break;
561                 }
562                 case URL_READY_CLOSED:
563                 {
564                         // url_fclose has finished
565                         print("Player stats synchronized with server\n");
566                         break;
567                 }
568                 
569                 case URL_READY_ERROR:
570                 default:
571                 {
572                         print("Receiving player stats failed: ", ftos(status), "\n");
573                         break;
574                 }
575         }
576 }
577 #endif // SVQC
578
579 #ifdef MENUQC
580
581
582 #if 0 // reading the entire DB at once
583         string e = "", en = "";
584         float i = 0;
585         for(e = PS_D_IN_EVL; (en = db_get(PS_D_IN_DB, e)) != ""; e = en)
586         {
587                 print(sprintf("%d:%s:%s\n", i, e, db_get(PS_D_IN_DB, sprintf("#%s", e))));
588                 ++i;
589         }
590 #endif
591
592 void PlayerStats_PlayerDetail_AddItem(string event, string data)
593 {
594         if(PS_D_IN_DB < 0) { return; }
595
596         // create a marker for the event so that we can access it later
597         string marker = sprintf("%s", event);
598         if(db_get(PS_D_IN_DB, marker) == "")
599         {
600                 if(PS_D_IN_EVL)
601                 {
602                         db_put(PS_D_IN_DB, marker, PS_D_IN_EVL);
603                         strunzone(PS_D_IN_EVL);
604                 }
605                 PS_D_IN_EVL = strzone(marker);
606         }
607
608         // now actually set the event data
609         db_put(PS_D_IN_DB, sprintf("#%s", event), data);
610         print("Added item ", sprintf("#%s", event), "=", data, " to PS_D_IN_DB\n");
611 }
612
613 void PlayerStats_PlayerDetail()
614 {
615         //PS_D_IN_DB = -1;
616         //PS_D_IN_DB = db_create();
617
618         if(PS_D_IN_DB < 0)
619         {
620                 PS_D_IN_DB = -1;
621                 PS_D_IN_DB = db_create();
622         }
623         else
624         {
625                 // kill the old db and try again
626                 //db_close(PS_D_IN_DB);
627                 //PS_D_IN_DB = -1;
628         }
629
630         if((autocvar_g_playerstats_playerdetail_uri != "") && (crypto_getmyidstatus(0) > 0))
631         {
632                 //uri = strcat(uri, "/player/", uri_escape(crypto_getmyidfp(0)));
633                 print("Retrieving playerstats from URL: ", autocvar_g_playerstats_playerdetail_uri, "\n");
634                 url_single_fopen(
635                         autocvar_g_playerstats_playerdetail_uri,
636                         FILE_APPEND,
637                         PlayerStats_PlayerDetail_Handler,
638                         world
639                 );
640         }
641 }
642
643 void PlayerStats_PlayerDetail_Handler(entity fh, entity unused, float status)
644 {
645         switch(status)
646         {
647                 case URL_READY_CANWRITE:
648                 {
649                         print("-- Sending data to player stats server\n");
650                         url_fputs(fh, "V 1\n");
651                         #ifdef WATERMARK
652                         url_fputs(fh, sprintf("R %s\n", WATERMARK));
653                         #endif
654                         url_fputs(fh, sprintf("l %s\n", cvar_string("_menu_prvm_language"))); // language
655                         url_fputs(fh, sprintf("c %s\n", cvar_string("_menu_prvm_country"))); // country
656                         url_fputs(fh, sprintf("g %s\n", cvar_string("_menu_prvm_gender"))); // gender
657                         url_fputs(fh, sprintf("n %s\n", cvar_string("_cl_name"))); // name
658                         url_fputs(fh, sprintf("m %s %s\n", cvar_string("_cl_playermodel"), cvar_string("_cl_playerskin"))); // model/skin
659                         url_fputs(fh, "\n");
660                         url_fclose(fh);
661                         break;
662                 }
663                 
664                 case URL_READY_CANREAD:
665                 {
666                         print("-- Got response from player stats server:\n");
667                         string input = "";
668                         string gametype = "overall";
669                         while((input = url_fgets(fh)))
670                         {
671                                 //print(input, "\n");
672                                 float count = tokenizebyseparator(input, " ");
673                                 string key = "", event = "", data = "";
674
675                                 if(argv(0) == "#") { continue; }
676                                 
677                                 if(count == 2)
678                                 {
679                                         key = argv(0);
680                                         data = substring(input, argv_start_index(1), strlen(input) - argv_start_index(1));
681                                 }
682                                 else if(count >= 3)
683                                 {
684                                         key = argv(0);
685                                         event = argv(1);
686                                         data = substring(input, argv_start_index(2), strlen(input) - argv_start_index(2));
687                                 }
688                                 else { continue; }
689
690                                 switch(key)
691                                 {
692                                         // general info
693                                         case "V": PlayerStats_PlayerDetail_AddItem("version", data); break;
694                                         case "R": PlayerStats_PlayerDetail_AddItem("release", data); break;
695                                         case "T": PlayerStats_PlayerDetail_AddItem("time", data); break;
696
697                                         // player info
698                                         case "S": PlayerStats_PlayerDetail_AddItem("statsurl", data); break;
699                                         case "P": PlayerStats_PlayerDetail_AddItem("hashkey", data); break;
700                                         case "n": PlayerStats_PlayerDetail_AddItem("playernick", data); break;
701                                         case "i": PlayerStats_PlayerDetail_AddItem("playerid", data); break;
702
703                                         // other/event info
704                                         case "G": gametype = data; break;
705                                         case "e":
706                                         {
707                                                 if(event != "" && data != "")
708                                                 {
709                                                         PlayerStats_PlayerDetail_AddItem(
710                                                                 sprintf(
711                                                                         "%s/%s",
712                                                                         gametype,
713                                                                         event
714                                                                 ),
715                                                                 data
716                                                         );
717                                                 }
718                                                 break;
719                                         }
720                                         
721                                         default: print("PlayerStats_PlayerDetail_Handler(): Key went unhandled?\n"); break;
722                                 }
723
724                                 #if 0
725                                 print(sprintf(
726                                         "PlayerStats_PlayerDetail_Handler(): key '%s', event '%s', data '%s'\n",
727                                         key,
728                                         event,
729                                         data
730                                 ));
731                                 #endif
732                         }
733                         print("-- End of response.\n");
734                         url_fclose(fh);
735                         break;
736                 }
737                 case URL_READY_CLOSED:
738                 {
739                         // url_fclose has finished
740                         print("Player stats synchronized with server\n");
741                         break;
742                 }
743                 
744                 case URL_READY_ERROR:
745                 default:
746                 {
747                         print("Receiving player stats failed: ", ftos(status), "\n");
748                         break;
749                 }
750         }
751 }
752 #endif
753
754 /*
755 void PlayerInfo_AddPlayer(entity e)
756 {
757         if(playerinfo_db < 0)
758                 return;
759
760         string key;
761         key = sprintf("#%d:*", e.playerid); // TODO: use hashkey instead?
762
763         string p;
764         p = db_get(playerinfo_db, key);
765         if(p == "")
766         {
767                 if(playerinfo_last)
768                 {
769                         db_put(playerinfo_db, key, playerinfo_last);
770                         strunzone(playerinfo_last);
771                 }
772                 else
773                         db_put(playerinfo_db, key, "#");
774                 playerinfo_last = strzone(ftos(e.playerid));
775                 print("  Added player ", ftos(e.playerid), " to playerinfo_db\n");//DEBUG//
776         }
777 }
778
779 void PlayerInfo_AddItem(entity e, string item_id, string val)
780 {
781         if(playerinfo_db < 0)
782                 return;
783
784         string key;
785         key = sprintf("*:%s", item_id);
786
787         string p;
788         p = db_get(playerinfo_db, key);
789         if(p == "")
790         {
791                 if(playerinfo_events_last)
792                 {
793                         db_put(playerinfo_db, key, playerinfo_events_last);
794                         strunzone(playerinfo_events_last);
795                 }
796                 else
797                         db_put(playerinfo_db, key, "#");
798                 playerinfo_events_last = strzone(item_id);
799         }
800
801         key = sprintf("#%d:%s", e.playerid, item_id);
802         db_put(playerinfo_db, key, val);
803         print("  Added item ", key, "=", val, " to playerinfo_db\n");//DEBUG//
804 }
805
806 string PlayerInfo_GetItem(entity e, string item_id)
807 {
808         if(playerinfo_db < 0)
809                 return "";
810
811         string key;
812         key = sprintf("#%d:%s",  e.playerid, item_id);
813         return db_get(playerinfo_db, key);
814 }
815
816 string PlayerInfo_GetItemLocal(string item_id)
817 {
818         entity p = spawn();
819         p.playerid = 0;
820         return PlayerInfo_GetItem(p, item_id);
821 }
822
823 void PlayerInfo_ready(entity fh, entity p, float status)
824 {
825         float n;
826         string s;
827
828         PlayerInfo_AddPlayer(p);
829
830         switch(status)
831         {
832                 case URL_READY_CANWRITE:
833                         print("-- Sending data to player stats server\n");
834                         url_fputs(fh, "V 1\n");
835 #ifdef WATERMARK
836                         url_fputs(fh, sprintf("R %s\n", WATERMARK));
837 #endif
838 #ifdef MENUQC
839                         url_fputs(fh, sprintf("l %s\n", cvar_string("_menu_prvm_language"))); // language
840                         url_fputs(fh, sprintf("c %s\n", cvar_string("_menu_prvm_country"))); // country
841                         url_fputs(fh, sprintf("g %s\n", cvar_string("_menu_prvm_gender"))); // gender
842                         url_fputs(fh, sprintf("n %s\n", cvar_string("_cl_name"))); // name
843                         url_fputs(fh, sprintf("m %s %s\n", cvar_string("_cl_playermodel"), cvar_string("_cl_playerskin"))); // model/skin
844 #endif
845                         url_fputs(fh, "\n");
846                         url_fclose(fh);
847                         break;
848                 case URL_READY_CANREAD:
849                         print("-- Got response from player stats server:\n");
850                         string gametype = string_null;
851                         while((s = url_fgets(fh)))
852                         {
853                                 print("  ", s, "\n");
854
855                                 string key = "", value = "", data = "";
856
857                                 n = tokenizebyseparator(s, " "); // key (value) data
858                                 if (n == 1)
859                                         continue;
860                                 else if (n == 2)
861                                 {
862                                         key = argv(0);
863                                         data = argv(1);
864                                 }
865                                 else if (n >= 3)
866                                 {
867                                         key = argv(0);
868                                         value = argv(1);
869                                         data = argv(2);
870                                 }
871
872                                 if (data == "")
873                                         continue;
874
875                                 if (key == "#")
876                                         continue;
877                                 else if (key == "V")
878                                         PlayerInfo_AddItem(p, "_version", data);
879                                 else if (key == "R")
880                                         PlayerInfo_AddItem(p, "_release", data);
881                                 else if (key == "T")
882                                         PlayerInfo_AddItem(p, "_time", data);
883                                 else if (key == "S")
884                                         PlayerInfo_AddItem(p, "_statsurl", data);
885                                 else if (key == "P")
886                                         PlayerInfo_AddItem(p, "_hashkey", data);
887                                 else if (key == "n")
888                                         PlayerInfo_AddItem(p, "_playernick", data);
889                                 else if (key == "i")
890                                         PlayerInfo_AddItem(p, "_playerid", data);
891                                 else if (key == "G")
892                                         gametype = data;
893                                 else if (key == "e" && value != "")
894                                 {
895                                         if (gametype == "")
896                                                 PlayerInfo_AddItem(p, value, data);
897                                         else
898                                                 PlayerInfo_AddItem(p, sprintf("%s/%s", gametype, value), data);
899                                 }
900                                 else
901                                         continue;
902                         }
903                         print("-- End of response.\n");
904                         url_fclose(fh);
905                         break;
906                 case URL_READY_CLOSED:
907                         // url_fclose has finished
908                         print("Player stats synchronized with server\n");
909                         break;
910                 case URL_READY_ERROR:
911                 default:
912                         print("Receiving player stats failed: ", ftos(status), "\n");
913                         break;
914         }
915 }
916
917 void PlayerInfo_Init()
918 {
919         playerinfo_db = -1;
920         playerinfo_db = db_create();
921 }
922
923 #ifdef SVQC
924 void PlayerInfo_Basic(entity p)
925 {
926         print("-- Getting basic PlayerInfo for player ",ftos(p.playerid)," (SVQC)\n");
927
928         if(playerinfo_db < 0)
929                 return;
930
931         string uri;
932         uri = autocvar_g_playerinfo_uri;
933         if(uri != "" && p.crypto_idfp != "")
934         {
935                 uri = strcat(uri, "/elo/", uri_escape(p.crypto_idfp));
936                 print("Retrieving playerstats from URL: ", uri, "\n");
937                 url_single_fopen(uri, FILE_READ, PlayerInfo_ready, p);
938         }
939 }
940 #endif
941
942 #ifdef MENUQC
943 void PlayerInfo_Details()
944 {
945         print("-- Getting detailed PlayerInfo for local player (MENUQC)\n");
946
947         if(playerinfo_db < 0)
948                 return;
949
950         string uri;
951         uri = autocvar_g_playerinfo_uri; // FIXME
952         if(uri != "" && crypto_getmyidstatus(0) > 0)
953         {
954                 //uri = strcat(uri, "/player/", uri_escape(crypto_getmyidfp(0)));
955                 uri = strcat(uri, "/player/me");
956                 print("Retrieving playerstats from URL: ", uri, "\n");
957                 url_single_fopen(uri, FILE_APPEND, PlayerInfo_ready, world);
958         }
959 }
960 #endif
961
962 #ifdef CSQC
963 /*
964  * FIXME - crypto_* builtin functions missing in CSQC (csprogsdefs.qc:885)
965 void PlayerInfo_Details()
966 {
967         print("-- Getting detailed PlayerInfo for local player (CSQC)\n");
968
969         if(playerinfo_db < 0)
970                 return;
971
972         string uri;
973         uri = autocvar_g_playerinfo_uri; // FIXME
974         if(uri != "" && crypto_getmyidstatus(0) > 0)
975         {
976                 uri = strcat(uri, "/player/", uri_escape(crypto_getmyidfp(0)));
977                 print("Retrieving playerstats from URL: ", uri, "\n");
978                 url_single_fopen(uri, FILE_READ, PlayerInfo_ready, p);
979         }
980 }
981
982 #endif
983 */