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