MapStats

Name	Kills	Deaths
Valhallenn	2.882	1.549
[[4GF]]Kebi	2.817	1.887
BrokenHeart....	2.267	931
[[eAF]]Zubaty-Her[Old]	1.961	1.184
Bruno	1.836	1.325
VIKY	1.700	1.912
[[<3]]KrisZz :)))))))))))	1.555	1.129
[[KaP]]Kvrdlic	1.466	1.571
[[Old]]apple	1.464	1.334
[[eAF]]Pepa on King	1.345	1.196

History
+
Request History
1 previous requests available
- Restore to current request
- 2/leagues/view/1
====
Session
+
Session
- Config
  userAgentf17a0d61e84c5c1443b44714acd4fe18
  time1685514811
  countdown10
- server_id2
- server_group_id1
====
Request
+
Request

Cake Params
- plugin(null)
- controllermap_stats
- actionview
- named(empty)
- pass
  02
- server2
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys
  0server
  1controller
  2action
- options
  server[0-9]+
- defaults
  plugin(null)
- template/:server/:controller/:action/*
====

Sql Logs

default

Total Time: 6 ms
Total Queries: 16 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Option`.`id`, `Option`.`group`, `Option`.`name`, `Option`.`value`, `Option`.`locked`, `Option`.`description` FROM `b3_xlr`.`options` AS `Option` WHERE 1 = 1	34	34	1
SELECT `Server`.`id`, `Server`.`active`, `Server`.`gamename`, `Server`.`servername`, `Server`.`servername_a`, `Server`.`dbhost`, `Server`.`dbuser`, `Server`.`dbpass`, `Server`.`dbname`, `Server`.`server_group_id`, `Server`.`statusurl`, `Server`.`slogan`, `Server`.`time_add`, `ServerGroup`.`id`, `ServerGroup`.`name`, `ServerGroup`.`description`, `ServerGroup`.`active_group` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `active` = '1'	6	6	1	maybe slow
SELECT `Server`.`id`, `Server`.`active`, `Server`.`gamename`, `Server`.`servername`, `Server`.`servername_a`, `Server`.`dbhost`, `Server`.`dbuser`, `Server`.`dbpass`, `Server`.`dbname`, `Server`.`server_group_id`, `Server`.`statusurl`, `Server`.`slogan`, `Server`.`time_add`, `ServerGroup`.`id`, `ServerGroup`.`name`, `ServerGroup`.`description`, `ServerGroup`.`active_group` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `active` = '1' ORDER BY `Server`.`id` asc LIMIT 1	1	1	1
SELECT `ServerOption`.`id`, `ServerOption`.`server_id`, `ServerOption`.`name`, `ServerOption`.`value`, `Server`.`id`, `Server`.`active`, `Server`.`gamename`, `Server`.`servername`, `Server`.`servername_a`, `Server`.`dbhost`, `Server`.`dbuser`, `Server`.`dbpass`, `Server`.`dbname`, `Server`.`server_group_id`, `Server`.`statusurl`, `Server`.`slogan`, `Server`.`time_add` FROM `b3_xlr`.`server_options` AS `ServerOption` LEFT JOIN `b3_xlr`.`servers` AS `Server` ON (`ServerOption`.`server_id` = `Server`.`id`) WHERE `ServerOption`.`server_id` = 2	16	16	1	maybe slow
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 8 LIMIT 1	1	1	1
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 2 LIMIT 1	1	1	0
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 3 LIMIT 1	1	1	0
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 5 LIMIT 1	1	1	0
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 6 LIMIT 1	1	1	0
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 7 LIMIT 1	1	1	0
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 2 LIMIT 1	1	1	0
SELECT `Server`.`id`, `Server`.`active`, `Server`.`gamename`, `Server`.`servername`, `Server`.`servername_a`, `Server`.`dbhost`, `Server`.`dbuser`, `Server`.`dbpass`, `Server`.`dbname`, `Server`.`server_group_id`, `Server`.`statusurl`, `Server`.`slogan`, `Server`.`time_add`, `ServerGroup`.`id`, `ServerGroup`.`name`, `ServerGroup`.`description`, `ServerGroup`.`active_group` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 2 LIMIT 1	1	1	1
SELECT COUNT(*) AS `count` FROM `b3_xlr`.`servers` AS `Server` WHERE `Server`.`id` = 2	1	1	0
SELECT COUNT(*) AS `count` FROM `b3_xlr`.`servers` AS `Server` WHERE `Server`.`id` = 2	1	1	0
SELECT COUNT(*) AS `count` FROM `b3_xlr`.`servers` AS `Server` WHERE `Server`.`id` = 2	1	1	0
UPDATE `b3_xlr`.`servers` SET `id` = 2, `active` = '1', `gamename` = 'cod4', `servername` = '#26', `servername_a` = ' ^44GF.CZ^7 #26 \| SD \| HC \| Cracked', `dbhost` = '127.0.0.1', `dbuser` = 'b3', `dbpass` = 'b3aeu1245', `dbname` = 'b3', `server_group_id` = 1, `statusurl` = '/home/scutifer/httpdocs/xlrstats/status26.xml', `slogan` = '', `time_add` = '0000-00-00 00:00:00' WHERE `b3_xlr`.`servers`.`id` = '2'	0	0	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

b3

Total Time: 12 ms
Total Queries: 17 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `MapStat`.`id`, `MapStat`.`name`, `MapStat`.`kills`, `MapStat`.`teamkills`, `MapStat`.`suicides`, `MapStat`.`rounds` FROM `b3`.`xlr_26_mapstats` AS `MapStat` WHERE `MapStat`.`id` = 2 LIMIT 1	1	1	0
SELECT `PlayerMap`.`id`, `PlayerMap`.`map_id`, `PlayerMap`.`player_id`, `PlayerMap`.`kills`, `PlayerMap`.`deaths`, `PlayerMap`.`teamkills`, `PlayerMap`.`teamdeaths`, `PlayerMap`.`suicides`, `PlayerMap`.`rounds`, `PlayerStat`.`id`, `PlayerStat`.`client_id`, `PlayerStat`.`kills`, `PlayerStat`.`deaths`, `PlayerStat`.`teamkills`, `PlayerStat`.`teamdeaths`, `PlayerStat`.`suicides`, `PlayerStat`.`ratio`, `PlayerStat`.`skill`, `PlayerStat`.`assists`, `PlayerStat`.`assistskill`, `PlayerStat`.`curstreak`, `PlayerStat`.`winstreak`, `PlayerStat`.`losestreak`, `PlayerStat`.`rounds`, `PlayerStat`.`hide`, `PlayerStat`.`fixed_name`, `PlayerStat`.`id_token` FROM `b3`.`xlr_26_playermaps` AS `PlayerMap` LEFT JOIN `b3`.`xlr_26_playerstats` AS `PlayerStat` ON (`PlayerMap`.`player_id` = `PlayerStat`.`id`) WHERE `PlayerMap`.`map_id` = 2 AND `PlayerStat`.`hide` = 0 ORDER BY `PlayerMap`.`kills` DESC LIMIT 10	10	10	2	maybe slow
SELECT `Player`.`id`, `Player`.`ip`, `Player`.`connections`, `Player`.`guid`, `Player`.`pbid`, `Player`.`name`, `Player`.`auto_login`, `Player`.`mask_level`, `Player`.`group_bits`, `Player`.`greeting`, `Player`.`login`, `Player`.`password`, `Player`.`time_add`, `Player`.`time_edit`, `Player`.`show`, `Player`.`spammer`, `Player`.`only_with_client`, `Player`.`trg_admin`, `Player`.`chat_mute`, `Player`.`regular` FROM `b3`.`clients` AS `Player` WHERE `Player`.`id` = 973	1	1	0
SELECT `Player`.`id`, `Player`.`ip`, `Player`.`connections`, `Player`.`guid`, `Player`.`pbid`, `Player`.`name`, `Player`.`auto_login`, `Player`.`mask_level`, `Player`.`group_bits`, `Player`.`greeting`, `Player`.`login`, `Player`.`password`, `Player`.`time_add`, `Player`.`time_edit`, `Player`.`show`, `Player`.`spammer`, `Player`.`only_with_client`, `Player`.`trg_admin`, `Player`.`chat_mute`, `Player`.`regular` FROM `b3`.`clients` AS `Player` WHERE `Player`.`id` = 157498	1	1	0
SELECT `Player`.`id`, `Player`.`ip`, `Player`.`connections`, `Player`.`guid`, `Player`.`pbid`, `Player`.`name`, `Player`.`auto_login`, `Player`.`mask_level`, `Player`.`group_bits`, `Player`.`greeting`, `Player`.`login`, `Player`.`password`, `Player`.`time_add`, `Player`.`time_edit`, `Player`.`show`, `Player`.`spammer`, `Player`.`only_with_client`, `Player`.`trg_admin`, `Player`.`chat_mute`, `Player`.`regular` FROM `b3`.`clients` AS `Player` WHERE `Player`.`id` = 255278	1	1	0
SELECT `Player`.`id`, `Player`.`ip`, `Player`.`connections`, `Player`.`guid`, `Player`.`pbid`, `Player`.`name`, `Player`.`auto_login`, `Player`.`mask_level`, `Player`.`group_bits`, `Player`.`greeting`, `Player`.`login`, `Player`.`password`, `Player`.`time_add`, `Player`.`time_edit`, `Player`.`show`, `Player`.`spammer`, `Player`.`only_with_client`, `Player`.`trg_admin`, `Player`.`chat_mute`, `Player`.`regular` FROM `b3`.`clients` AS `Player` WHERE `Player`.`id` = 244929	1	1	0
SELECT `Player`.`id`, `Player`.`ip`, `Player`.`connections`, `Player`.`guid`, `Player`.`pbid`, `Player`.`name`, `Player`.`auto_login`, `Player`.`mask_level`, `Player`.`group_bits`, `Player`.`greeting`, `Player`.`login`, `Player`.`password`, `Player`.`time_add`, `Player`.`time_edit`, `Player`.`show`, `Player`.`spammer`, `Player`.`only_with_client`, `Player`.`trg_admin`, `Player`.`chat_mute`, `Player`.`regular` FROM `b3`.`clients` AS `Player` WHERE `Player`.`id` = 234556	1	1	0
SELECT `Player`.`id`, `Player`.`ip`, `Player`.`connections`, `Player`.`guid`, `Player`.`pbid`, `Player`.`name`, `Player`.`auto_login`, `Player`.`mask_level`, `Player`.`group_bits`, `Player`.`greeting`, `Player`.`login`, `Player`.`password`, `Player`.`time_add`, `Player`.`time_edit`, `Player`.`show`, `Player`.`spammer`, `Player`.`only_with_client`, `Player`.`trg_admin`, `Player`.`chat_mute`, `Player`.`regular` FROM `b3`.`clients` AS `Player` WHERE `Player`.`id` = 253594	1	1	0
SELECT `Player`.`id`, `Player`.`ip`, `Player`.`connections`, `Player`.`guid`, `Player`.`pbid`, `Player`.`name`, `Player`.`auto_login`, `Player`.`mask_level`, `Player`.`group_bits`, `Player`.`greeting`, `Player`.`login`, `Player`.`password`, `Player`.`time_add`, `Player`.`time_edit`, `Player`.`show`, `Player`.`spammer`, `Player`.`only_with_client`, `Player`.`trg_admin`, `Player`.`chat_mute`, `Player`.`regular` FROM `b3`.`clients` AS `Player` WHERE `Player`.`id` = 255106	1	1	0
SELECT `Player`.`id`, `Player`.`ip`, `Player`.`connections`, `Player`.`guid`, `Player`.`pbid`, `Player`.`name`, `Player`.`auto_login`, `Player`.`mask_level`, `Player`.`group_bits`, `Player`.`greeting`, `Player`.`login`, `Player`.`password`, `Player`.`time_add`, `Player`.`time_edit`, `Player`.`show`, `Player`.`spammer`, `Player`.`only_with_client`, `Player`.`trg_admin`, `Player`.`chat_mute`, `Player`.`regular` FROM `b3`.`clients` AS `Player` WHERE `Player`.`id` = 239997	1	1	0
SELECT `Player`.`id`, `Player`.`ip`, `Player`.`connections`, `Player`.`guid`, `Player`.`pbid`, `Player`.`name`, `Player`.`auto_login`, `Player`.`mask_level`, `Player`.`group_bits`, `Player`.`greeting`, `Player`.`login`, `Player`.`password`, `Player`.`time_add`, `Player`.`time_edit`, `Player`.`show`, `Player`.`spammer`, `Player`.`only_with_client`, `Player`.`trg_admin`, `Player`.`chat_mute`, `Player`.`regular` FROM `b3`.`clients` AS `Player` WHERE `Player`.`id` = 230430	1	1	0
SELECT `Player`.`id`, `Player`.`ip`, `Player`.`connections`, `Player`.`guid`, `Player`.`pbid`, `Player`.`name`, `Player`.`auto_login`, `Player`.`mask_level`, `Player`.`group_bits`, `Player`.`greeting`, `Player`.`login`, `Player`.`password`, `Player`.`time_add`, `Player`.`time_edit`, `Player`.`show`, `Player`.`spammer`, `Player`.`only_with_client`, `Player`.`trg_admin`, `Player`.`chat_mute`, `Player`.`regular` FROM `b3`.`clients` AS `Player` WHERE `Player`.`id` = 240577	1	1	0
SELECT COUNT(*) AS `count` FROM `b3`.`xlr_26_playerstats` AS `PlayerStat` LEFT JOIN `b3`.`clients` AS `Player` ON (`PlayerStat`.`client_id` = `Player`.`id`) WHERE 1 = 1	1	1	4	maybe slow
SELECT SUM(kills) as total_kills FROM `b3`.`xlr_26_playerstats` AS `PlayerStat` LEFT JOIN `b3`.`clients` AS `Player` ON (`PlayerStat`.`client_id` = `Player`.`id`) WHERE 1 = 1 LIMIT 1	1	1	5	maybe slow
SELECT `WeaponStat`.`id`, `WeaponStat`.`name`, `WeaponStat`.`kills`, `WeaponStat`.`teamkills`, `WeaponStat`.`suicides` FROM `b3`.`xlr_26_weaponstats` AS `WeaponStat` WHERE 1 = 1 ORDER BY `kills` DESC LIMIT 1	1	1	0
SELECT `MapStat`.`id`, `MapStat`.`name`, `MapStat`.`kills`, `MapStat`.`teamkills`, `MapStat`.`suicides`, `MapStat`.`rounds` FROM `b3`.`xlr_26_mapstats` AS `MapStat` WHERE `MapStat`.`name` = 'mp_crash' LIMIT 1	1	1	0
SELECT `MapStat`.`id`, `MapStat`.`name`, `MapStat`.`kills`, `MapStat`.`teamkills`, `MapStat`.`suicides`, `MapStat`.`rounds` FROM `b3`.`xlr_26_mapstats` AS `MapStat` WHERE 1 = 1 ORDER BY `rounds` DESC LIMIT 1	1	1	1

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 7.36 MB

Message	Memory use
Component initialization	1.55 MB
Controller action start	3.06 MB
Controller render start	3.75 MB
Component initialization #2	4.36 MB
Controller action start #2	4.45 MB
Component initialization #3	4.50 MB
Controller action start #3	4.59 MB
Component initialization #4	4.65 MB
Controller action start #4	4.73 MB
Component initialization #5	4.79 MB
Controller action start #5	4.87 MB
Component initialization #6	4.93 MB
Controller action start #6	5.03 MB
Component initialization #7	5.09 MB
Controller action start #7	5.18 MB
Component initialization #8	5.24 MB
Controller action start #8	5.32 MB
Component initialization #9	5.42 MB
Controller action start #9	5.73 MB
Component initialization #10	5.87 MB
Controller action start #10	5.97 MB
View render complete	6.20 MB

Timers

Total Request Time: 201 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	14.58
Event: Controller.initialize	13.96
Event: Controller.startup	1.08
Controller action	34.89
Event: Controller.beforeRender	7.48
» Processing toolbar data	7.30
Rendering View	90.39
» Event: View.beforeRender	0.07
» Rendering APP/View/MapStats/view.ctp	4.37
» Event: View.afterRender	0.06
» Event: View.beforeLayout	0.06
» Rendering APP/View/Layouts/default.ctp	84.62
» » Rendering APP/View/Elements/google-analytics.ctp	0.16
» » Rendering APP/View/Elements/login.ctp	0.14
» » Rendering APP/View/Elements/menu.ctp	38.86
» » » Rendering APP/View/Elements/menu_leagues.ctp	3.13
» » » Rendering APP/View/Elements/menu_servers.ctp	33.29
» » » » Event: Controller.initialize #2	2.05
» » » » Event: Controller.startup #2	0.28
Controller action #2	0.00
» » » » » Event: Controller.shutdown	0.05
» » » » » Event: Controller.initialize #3	1.97
» » » » » Event: Controller.startup #3	0.24
Controller action #3	0.00
» » » » » » Event: Controller.shutdown #2	0.05
» » » » » » Event: Controller.initialize #4	1.98
» » » » » » Event: Controller.startup #4	0.24
Controller action #4	0.00
» » » » » » » Event: Controller.shutdown #3	0.05
» » » » » » » Event: Controller.initialize #5	2.00
» » » » » » » Event: Controller.startup #5	0.29
Controller action #5	0.00
» » » » » » » » Event: Controller.shutdown #4	0.05
» » » » » » » » Event: Controller.initialize #6	2.12
» » » » » » » » Event: Controller.startup #6	0.24
Controller action #6	0.00
» » » » » » » » » Event: Controller.shutdown #5	0.05
» » » » » » » » » Event: Controller.initialize #7	2.13
» » » » » » » » » Event: Controller.startup #7	0.24
Controller action #7	0.00
» » » » » » » » » » Event: Controller.shutdown #6	0.05
» » » » » » » » Rendering APP/View/Elements/server_info.ctp	40.85
» » » » » » » » » Event: Controller.initialize #8	2.22
» » » » » » » » » Event: Controller.startup #8	0.25
Controller action #8	0.00
» » » » » » » » » » Event: Controller.shutdown #7	0.05
» » » » » » » » » » Event: Controller.initialize #9	3.97
» » » » » » » » » » Event: Controller.startup #9	0.49
Controller action #9	0.00
» » » » » » » » » » » Event: Controller.initialize #10	2.49
» » » » » » » » » » » Event: Controller.startup #10	0.48
Controller action #10	0.00
» » » » » » » » » » » » Event: Controller.shutdown #8	0.07
» » » » » » » » » » » » Event: Controller.shutdown #9	0.07
» » » » » » » » » » » » Rendering APP/View/Elements/donate_button.ctp	0.14
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- playerData
  0
  PlayerMap
  id2995
  map_id2
  player_id303
  kills2882
  deaths1549
  teamkills1
  teamdeaths0
  suicides0
  rounds2839
  PlayerStat
  id303
  client_id973
  kills47388
  deaths24574
  teamkills2
  teamdeaths3
  suicides0
  ratio1.92838
  skill1610.85
  assists14
  assistskill8.70739
  curstreak-3
  winstreak24
  losestreak-10
  rounds45429
  hide0
  fixed_name
  id_token
  Player
  id973
  ip37.221.242.251
  connections4901
  guid2310346616862589548
  pbid0011aa0caaaa91b652b4607b8afe12ea
  nameValhallenn
  auto_login(false)
  mask_level(false)
  group_bits5
  greeting
  login
  password
  time_add1492017837
  time_edit1685463938
  show(true)
  spammer0
  only_with_client(false)
  trg_admin0
  chat_mute0
  regular0
  1
  PlayerMap
  id3300
  map_id2
  player_id306
  kills2817
  deaths1887
  teamkills0
  teamdeaths0
  suicides0
  rounds3740
  PlayerStat
  id306
  client_id157498
  kills34094
  deaths24710
  teamkills6
  teamdeaths1
  suicides0
  ratio1.37977
  skill844.232
  assists15
  assistskill11.8441
  curstreak-2
  winstreak23
  losestreak-13
  rounds52057
  hide0
  fixed_name
  id_token
  Player
  id157498
  ip81.201.48.26
  connections3103
  guid2310346613933069623
  pbid890cb2cbf95412e216bdddfb049a3a17
  name[[4GF]]Kebi
  auto_login(false)
  mask_level(false)
  group_bits64
  greeting
  login
  password
  time_add1517655773
  time_edit1677349828
  show(true)
  spammer0
  only_with_client(false)
  trg_admin0
  chat_mute0
  regular1
  2
  PlayerMap
  id11080
  map_id2
  player_id813
  kills2267
  deaths931
  teamkills0
  teamdeaths0
  suicides0
  rounds1744
  PlayerStat
  id813
  client_id255278
  kills29892
  deaths14439
  teamkills1
  teamdeaths1
  suicides0
  ratio2.07023
  skill1448.85
  assists6
  assistskill3.34471
  curstreak-1
  winstreak37
  losestreak-10
  rounds25219
  hide0
  fixed_name
  id_token
  Player
  id255278
  ip90.180.178.71
  connections628
  guid2310346616842064021
  pbidb881596c07078271ca9989d691f6a406
  nameBrokenHeart....
  auto_login(false)
  mask_level(false)
  group_bits1
  greeting
  login
  password
  time_add1615483351
  time_edit1683917609
  show(true)
  spammer0
  only_with_client(false)
  trg_admin0
  chat_mute0
  regular0
  3
  PlayerMap
  id8441
  map_id2
  player_id709
  kills1961
  deaths1184
  teamkills0
  teamdeaths0
  suicides0
  rounds2071
  PlayerStat
  id709
  client_id244929
  kills38485
  deaths21970
  teamkills0
  teamdeaths1
  suicides0
  ratio1.75171
  skill1026.96
  assists4
  assistskill3.4108
  curstreak-1
  winstreak21
  losestreak-17
  rounds40555
  hide0
  fixed_name
  id_token
  Player
  id244929
  ip188.167.250.66
  connections1466
  guid2310346613452902633
  pbid728e30063bc239ae8a0148ff632467ee
  name[[eAF]]Zubaty-Her[Old]
  auto_login(false)
  mask_level(false)
  group_bits1
  greeting
  login
  password
  time_add1599044530
  time_edit1673387168
  show(true)
  spammer5
  only_with_client(true)
  trg_admin0
  chat_mute0
  regular0
  4
  PlayerMap
  id6979
  map_id2
  player_id640
  kills1836
  deaths1325
  teamkills0
  teamdeaths0
  suicides0
  rounds2169
  PlayerStat
  id640
  client_id234556
  kills28509
  deaths22577
  teamkills0
  teamdeaths0
  suicides0
  ratio1.26275
  skill1323.42
  assists6
  assistskill4.38284
  curstreak-2
  winstreak19
  losestreak-17
  rounds35555
  hide0
  fixed_name
  id_token
  Player
  id234556
  ip178.255.168.145
  connections2378
  guid2310346615443260992
  pbida10c9ee1398f5196e3f377d795f4f922
  nameBruno
  auto_login(false)
  mask_level(false)
  group_bits1
  greeting
  login
  password
  time_add1586104930
  time_edit1685030965
  show(true)
  spammer3
  only_with_client(false)
  trg_admin0
  chat_mute0
  regular0
  5
  PlayerMap
  id10378
  map_id2
  player_id789
  kills1700
  deaths1912
  teamkills0
  teamdeaths0
  suicides0
  rounds3052
  PlayerStat
  id789
  client_id253594
  kills28793
  deaths33435
  teamkills1
  teamdeaths0
  suicides0
  ratio0.861163
  skill1339.3
  assists4
  assistskill3.67603
  curstreak-1
  winstreak18
  losestreak-47
  rounds55487
  hide0
  fixed_name
  id_token
  Player
  id253594
  ip178.255.168.158
  connections3173
  guid2310346614819462440
  pbidda66d38679f1347583f7dee77dff6904
  nameVIKY
  auto_login(false)
  mask_level(false)
  group_bits1
  greetingcusss:D
  login
  password
  time_add1612466336
  time_edit1684614244
  show(true)
  spammer15
  only_with_client(true)
  trg_admin0
  chat_mute0
  regular0
  6
  PlayerMap
  id11079
  map_id2
  player_id812
  kills1555
  deaths1129
  teamkills0
  teamdeaths0
  suicides0
  rounds1718
  PlayerStat
  id812
  client_id255106
  kills27495
  deaths18516
  teamkills0
  teamdeaths1
  suicides0
  ratio1.48493
  skill1704.98
  assists5
  assistskill3.25815
  curstreak-1
  winstreak26
  losestreak-11
  rounds30340
  hide0
  fixed_name
  id_token
  Player
  id255106
  ip109.183.91.49
  connections943
  guid2310346615602248159
  pbidbe694dd36e6caadc852dea12398867d8
  name[[<3]]KrisZz :)))))))))))
  auto_login(false)
  mask_level(false)
  group_bits1
  greeting
  login
  password
  time_add1615029057
  time_edit1685470893
  show(true)
  spammer0
  only_with_client(false)
  trg_admin0
  chat_mute0
  regular0
  7
  PlayerMap
  id7236
  map_id2
  player_id662
  kills1466
  deaths1571
  teamkills0
  teamdeaths0
  suicides0
  rounds2320
  PlayerStat
  id662
  client_id239997
  kills27019
  deaths28974
  teamkills3
  teamdeaths0
  suicides0
  ratio0.932526
  skill1305
  assists8
  assistskill5.35497
  curstreak-12
  winstreak17
  losestreak-32
  rounds43111
  hide0
  fixed_name
  id_token
  Player
  id239997
  ip88.103.233.68
  connections1014
  guid2310346613241648044
  pbid151109cec99657af331051e8eac49635
  name[[KaP]]Kvrdlic
  auto_login(false)
  mask_level(false)
  group_bits5
  greetingzdarec
  login
  password
  time_add1591283823
  time_edit1684603759
  show(true)
  spammer0
  only_with_client(false)
  trg_admin0
  chat_mute0
  regular0
  8
  PlayerMap
  id6792
  map_id2
  player_id627
  kills1464
  deaths1334
  teamkills0
  teamdeaths0
  suicides0
  rounds1991
  PlayerStat
  id627
  client_id230430
  kills21608
  deaths20017
  teamkills2
  teamdeaths0
  suicides0
  ratio1.07948
  skill695.945
  assists2
  assistskill1.61184
  curstreak1
  winstreak17
  losestreak-14
  rounds31319
  hide0
  fixed_name
  id_token
  Player
  id230430
  ip46.23.52.160
  connections1896
  guid2310346613991734011
  pbid7780b6b230d27c403841e11c48664dfa
  name[[Old]]apple
  auto_login(false)
  mask_level(false)
  group_bits128
  greetingZdravim Vas
  login
  password
  time_add1582911251
  time_edit1662822854
  show(true)
  spammer0
  only_with_client(false)
  trg_admin0
  chat_mute0
  regular0
  9
  PlayerMap
  id7620
  map_id2
  player_id671
  kills1345
  deaths1196
  teamkills0
  teamdeaths0
  suicides0
  rounds1968
  PlayerStat
  id671
  client_id240577
  kills22083
  deaths18922
  teamkills1
  teamdeaths0
  suicides0
  ratio1.16705
  skill301.291
  assists0
  assistskill0
  curstreak-1
  winstreak18
  losestreak-26
  rounds32406
  hide0
  fixed_name
  id_token
  Player
  id240577
  ip80.250.28.96
  connections4006
  guid2310346614887549562
  pbidd3ccc66f7b1bf9e77faead1d50a15a0a
  name[[eAF]]Pepa on King
  auto_login(false)
  mask_level(false)
  group_bits1
  greetingNaschle )) :D
  login
  password
  time_add1592123314
  time_edit1625159517
  show(true)
  spammer20
  only_with_client(true)
  trg_admin0
  chat_mute0
  regular0
- mapData
  MapStat
  id2
  namemp_vacant
  kills89513
  teamkills11
  suicides7
  rounds14
- isCaching(true)
- isAuthorized(false)
- user(empty)
- $request->data(empty)
- $this->validationErrors
  Permission(empty)
  Aro(empty)
  Aco(empty)
  Option(empty)
  Server(empty)
  ServerGroup(empty)
  ServerOption(empty)
  MapStat(empty)
  PlayerMap(empty)
  PlayerStat(empty)
  Player(empty)
- Loaded Helpers
  0XlrFunctions
  1TwitterBootstrap
  2Gravatar
  3Html
  4Form
  5Js
  6Number
  7SimpleGraph
  8DebugTimer
  9Toolbar
  10Bootstrap
  11Session
  12HtmlToolbar
====

Environment

App Constants

Constant	Value
XLR_VERSION	v3.0.0-beta.10

CakePHP Constants

Constant	Value
APP	/home/scutifer/httpdocs/xlrstats/app/
APP_DIR	app
APPLIBS	/home/scutifer/httpdocs/xlrstats/app/Lib/
CACHE	/home/scutifer/httpdocs/xlrstats/app/tmp/cache/
CAKE	/home/scutifer/httpdocs/xlrstats/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/scutifer/httpdocs/xlrstats/lib
CORE_PATH	/home/scutifer/httpdocs/xlrstats/lib/
CAKE_VERSION	2.4.3
CSS	/home/scutifer/httpdocs/xlrstats/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	http://135.4gf.cz
IMAGES	/home/scutifer/httpdocs/xlrstats/app/webroot/img/
IMAGES_URL	img/
JS	/home/scutifer/httpdocs/xlrstats/app/webroot/js/
JS_URL	js/
LOGS	/home/scutifer/httpdocs/xlrstats/app/tmp/logs/
ROOT	/home/scutifer/httpdocs/xlrstats
TESTS	/home/scutifer/httpdocs/xlrstats/app/Test/
TMP	/home/scutifer/httpdocs/xlrstats/app/tmp/
VENDORS	/home/scutifer/httpdocs/xlrstats/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/scutifer/httpdocs/xlrstats/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.6.40-64+ubuntu22.04.1+deb.sury.org+1
Redirect Redirect Status	200
Redirect Status	200
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http Accept Language	en-US,en;q=0.5
Http Accept Encoding	br,gzip
Http Host	135.4gf.cz
Http Connection	Keep-Alive
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin
Server Signature	Apache/2.4.52 (Ubuntu) Server at 135.4gf.cz Port 80
Server Software	Apache/2.4.52 (Ubuntu)
Server Name	135.4gf.cz
Server Addr	88.86.107.135
Server Port	80
Remote Addr	3.227.251.94
Document Root	/home/scutifer/httpdocs
Request Scheme	http
Context Prefix
Context Document Root	/home/scutifer/httpdocs
Server Admin	webmaster@localhost
Script Filename	/home/scutifer/httpdocs/xlrstats/app/webroot/index.php
Remote Port	47814
Redirect Url	/xlrstats/app/webroot/2/map_stats/view/2
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/xlrstats/2/map_stats/view/2
Script Name	/xlrstats/app/webroot/index.php
Php Self	/xlrstats/app/webroot/index.php
Request Time Float	1685500411.619
Request Time	1685500411

====

Include
+
Included Files

Include Paths
- 0/home/scutifer/httpdocs/xlrstats/lib
- 2/usr/share/php
- 3-> /home/scutifer/httpdocs/xlrstats/lib/Cake/
Included Files
- core
  Behavior
  0CORE/Model/Behavior/TreeBehavior.php
  1CORE/Model/Behavior/ContainableBehavior.php
  Cache
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/CookieComponent.php
  2CORE/Controller/Component/AclComponent.php
  3CORE/Controller/Component/Acl/DbAcl.php
  4CORE/Controller/Component/Acl/AclInterface.php
  5CORE/Controller/Component/AuthComponent.php
  6CORE/Controller/Component/RequestHandlerComponent.php
  7CORE/Controller/Component/PaginatorComponent.php
  Config
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Configure
  0CORE/Configure/PhpReader.php
  1CORE/Configure/ConfigReaderInterface.php
  Controller
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model
  0CORE/Model/Permission.php
  1CORE/Model/Model.php
  2CORE/Model/ConnectionManager.php
  3CORE/Model/BehaviorCollection.php
  4CORE/Model/Aro.php
  5CORE/Model/AclNode.php
  6CORE/Model/Aco.php
  7CORE/Model/ModelBehavior.php
  Network
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/Object.php
  Routing
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/String.php
  5CORE/Utility/Set.php
  6CORE/Utility/ClassRegistry.php
  View
  0CORE/View/HelperCollection.php
- app
  Component
  0APP/Controller/Component/XlrFunctionsComponent.php
  1APP/Controller/Component/DataTableComponent.php
  Config
  0APP/Config/core.php
  1APP/Config/security.php
  2APP/Config/bootstrap.php
  3APP/Config/xlrstats/globals.php
  4APP/Config/xlrstats/leagues.php
  5APP/Config/xlrstats/levels.php
  6APP/Config/xlrstats/ranks.php
  7APP/Config/xlrstats/gamelaunchers.php
  8APP/Config/xlrstats/games.php
  9APP/Config/routes.php
  10APP/Config/database.php
  11APP/Config/games/default.php
  12APP/Config/games/cod4.php
  Controller
  0APP/Controller/MapStatsController.php
  1APP/Controller/AppController.php
  Model
  0APP/Model/AppModel.php
  1APP/Model/MapStat.php
  2APP/Model/PlayerMap.php
  3APP/Model/PlayerStat.php
  4APP/Model/Player.php
  Other
  0APP/webroot/index.php
- plugins
  ClearCache
  Plugin
  0ClearCache/Lib/Panel/ClearCachePanel.php
  1ClearCache/Lib/ClearCache.php
  Dashboard
  Config
  0Dashboard/Config/routes.php
  Model
  0Dashboard/Model/Option.php
  1Dashboard/Model/DashboardAppModel.php
  2Dashboard/Model/Server.php
  3Dashboard/Model/ServerGroup.php
  4Dashboard/Model/ServerOption.php
  DebugKit
  Component
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Users
  Config
  0Users/Config/routes.php
  Component
  0Users/Controller/Component/RememberMeComponent.php
====
Clear Cache
+

Clear Cache

Files: All Cached Files | models | persistent

Engines: All Cache Engines | _cake_core_ | _cake_model_ | default | 1sec | 5secs | 1min | 5min | 1hour | 1week

No configured/allowed cache groups.

Result

Click on some link above.

====

4GF.CZ #26 | SD | HC | Cracked

Vacant

Top players for this map

default

Total Time: 6 ms
Total Queries: 16 queries

Query Explain:

b3

Total Time: 12 ms
Total Queries: 17 queries

Query Explain:

Memory

Timers

4GF.CZ #26 | SD | HC | Cracked

Vacant

Top players for this map

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 6 ms Total Queries: 16 queries

Query Explain:

b3

Total Time: 12 ms Total Queries: 17 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Clear Cache

Result

Total Time: 6 ms
Total Queries: 16 queries

Total Time: 12 ms
Total Queries: 17 queries