WhenIsWhere activity graph

Samtron · **Posted:** 09.30.11

AimMe wrote:

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

RunTMC wrote:

I win, 1,5 %

BeH wins: 0.78%

RunTMC · **Posted:** 09.30.11

Damn! Got me!

I hoped that nobody calculate it.

wurst · **Posted:** 09.30.11

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

wurst · **Posted:** 09.30.11

ah @ completion of the sheet...

Code:

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
   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 · **Posted:** 09.30.11

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 · **Posted:** 09.30.11

ah, SUM() , right

wurst · **Posted:** 10.27.11

"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)...

Attachment:

todays_realtime_ratio.png [ 8.66 KiB | Viewed 4001 times ]

WhenIsWhere activity graph

Who is online