dswp.de http://www.dswp.de/old/ |
|
WhenIsWhere activity graph http://www.dswp.de/old/forum-gameserver-support/wheniswhere-activity-graph-t3802-20.html |
Page 3 of 3 |
Author: | Samtron [ 09.30.11 ] |
Post subject: | Re: WhenIsWhere activity graph |
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% |
Author: | RunTMC [ 09.30.11 ] |
Post subject: | Re: WhenIsWhere activity graph |
Damn! Got me! I hoped that nobody calculate it. |
Author: | wurst [ 09.30.11 ] |
Post subject: | Re: WhenIsWhere activity graph |
why? ur environmental behaviour is ok as it seems... rasta could consider less nades |
Author: | wurst [ 09.30.11 ] |
Post subject: | Re: WhenIsWhere activity graph |
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? |
Author: | natirips [ 09.30.11 ] |
Post subject: | Re: WhenIsWhere activity graph |
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. |
Author: | wurst [ 09.30.11 ] |
Post subject: | Re: WhenIsWhere activity graph |
ah, SUM() , right |
Author: | wurst [ 10.27.11 ] |
Post subject: | Re: WhenIsWhere activity graph |
"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 3391 times ] |
Page 3 of 3 | All times are UTC + 1 hour |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |