WhenIsWhere activity graph

[Samtron]

BTW: look at beh: tdm-player142794
He sucks so much he can't even make teamkills

I win, 1,5 %

BeH wins: 0.78%

[RunTMC]

Damn! Got me!
I hoped that nobody calculate it.

[wurst]

why?
ur environmental behaviour is ok as it seems...
rasta could consider less nades

[wurst]

ah @ completion of the sheet...

Code: Select all

SELECT
ROUND((p.kills/p.teamkills),2) AS ktkratio
from xlr_playerstats p where p.id = '$xlr_id'
limit 0,1


how about such:

Code: Select all

SELECT
   ROUND((p.kills/p.teamkills),2) AS ktkratio
  ,c.name AS GameNick
  ,pb.username AS ForumsNick

FROM xlr_playerstats p
INNER JOIN clients c ON c.id = p.client_id
INNER JOIN phpbb_users pb ON pb.xlr_id_22222 = p.id

WHERE p.id = 284

LIMIT 0,1


just tell me what kind of data u would like to put/pull/plug
aj... WHats with daily TK collection?

[natirips]

What happened to total "wasted" time in last month at the bottom? If it's not a resource hog nor complicated to implement I'd like it back.

[wurst]

ah, SUM() , right

[wurst]

"little" fix...

daily stats are cummulated on a daily base, through that the line of the actual day never contained a ratio.
today i had some nice games and wanted to see my ratio.

now (tadaaaaa) its filled.
i take the xlr_stats data of now, then substract last days kills and deaths. for the case its the first line (today)...

todays_realtime_ratio.png

(8.66 KiB) Downloaded 3681 times