::Who Is Online - SWC Dev Server::

Query Count: 15
SQL Time: 0.0061075687408447
PHP Execution Time: 0.0452
Memory Usage: 6.641 MB

Using devmode.

Show $_GET Request

Array
(
)

Show $_POST Request

Array
(
)

Show $_SESSION Request

Array
(
)

Show included libs

Array
(
    [0] => /swcombine/http/svn/trunk/www/htdocs/community/online/index.php
    [1] => /swcombine/http/svn/trunk/libs/path.php
    [2] => /swcombine/http/svn/trunk/libs/server21/constants/constants.inc
    [3] => /swcombine/http/svn/trunk/libs/server21/database/DB.inc
    [4] => /swcombine/http/svn/trunk/libs/server21/entities/entityInfo.inc
    [5] => /swcombine/http/svn/trunk/libs/ext/cache/Lite.php
    [6] => /swcombine/http/svn/trunk/libs/server21/entities/entity.inc
    [7] => /swcombine/http/svn/trunk/libs/server21/factions/factions.inc
    [8] => /swcombine/http/svn/trunk/libs/server21/other/misc.inc
    [9] => /swcombine/http/svn/trunk/libs/server21/gui/constructionGUI.inc
    [10] => /swcombine/http/svn/trunk/libs/server21/gui/darkness.inc
    [11] => /swcombine/http/svn/trunk/libs/server21/gui/xajaxClass.inc
    [12] => /swcombine/http/svn/trunk/libs/server21/gui/xajaxResponseClass.inc
    [13] => /swcombine/http/svn/trunk/libs/server21/players/access.inc
    [14] => /swcombine/http/svn/trunk/libs/ext/browserClass.inc
    [15] => /swcombine/http/svn/trunk/libs/server21/entities/capabilities.inc
    [16] => /swcombine/http/svn/trunk/libs/server21/constants/specific.inc
    [17] => /swcombine/http/svn/trunk/libs/server21/classes/autoload.inc
    [18] => /swcombine/http/svn/trunk/libs/server3/context/SWCContextClass.inc
    [19] => /swcombine/http/svn/trunk/libs/server3/context/ContextClass.inc
    [20] => /swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc
    [21] => /swcombine/http/svn/trunk/libs/server21/database/DBClass.inc
    [22] => /swcombine/http/svn/trunk/libs/server21/database/LoggingDBAuditClass.inc
    [23] => /swcombine/http/svn/trunk/libs/server21/other/StringUtilClass.inc
    [24] => /swcombine/http/svn/trunk/libs/server21/other/ShutdownUtilClass.inc
    [25] => /swcombine/http/svn/trunk/libs/server21/players/AccessUtilClass.inc
    [26] => /swcombine/http/svn/trunk/libs/server21/players/LoginUtilClass.inc
    [27] => /swcombine/http/svn/trunk/libs/server21/other/BacktraceUtilClass.inc
    [28] => /swcombine/http/svn/trunk/libs/server21/database/AuditQueryClass.inc
    [29] => /swcombine/http/svn/trunk/libs/server21/database/DBAtomicClass.inc
    [30] => /swcombine/http/svn/trunk/libs/server21/other/ErrorHandlerClass.inc
    [31] => /swcombine/http/svn/trunk/libs/server21/gui/MasterTemplateClass.inc
    [32] => /swcombine/http/svn/trunk/www/inc/login.inc
    [33] => /swcombine/http/svn/trunk/libs/server21/classes/CSSClass.inc
    [34] => /swcombine/http/svn/trunk/libs/server3/ajax/Ajax2Class.inc
    [35] => /swcombine/http/svn/trunk/libs/server21/classes/JSClass.inc
    [36] => /swcombine/http/svn/trunk/libs/server21/gui/MasterTemplateErrorHandlerClass.inc
    [37] => /swcombine/http/svn/trunk/libs/server21/database/ReadOnlyDBAuditClass.inc
    [38] => /swcombine/http/svn/trunk/libs/server21/other/CGTUtilClass.inc
    [39] => /swcombine/http/svn/trunk/libs/server21/gui/widgets/AutoCompleteClass.inc
    [40] => /swcombine/http/svn/trunk/libs/server21/characters/CharacterUtilClass.inc
    [41] => /swcombine/http/svn/trunk/www/inc/swc_header.inc
    [42] => /swcombine/http/svn/trunk/libs/server21/other/CGTTimeClass.inc
    [43] => /swcombine/http/svn/trunk/libs/server21/classes/RSSClass.inc
    [44] => /swcombine/http/svn/trunk/libs/server21/classes/AJAXClass.inc
    [45] => /swcombine/http/svn/trunk/libs/server21/gui/FlashClass.inc
    [46] => /swcombine/http/svn/trunk/www/inc/swc_footer.inc
    [47] => /swcombine/http/svn/trunk/www/inc/menus/community.inc
    [48] => /swcombine/http/svn/trunk/libs/server21/gui/widgets/SideMenuClass.inc
    [49] => /swcombine/http/svn/trunk/www/inc/swc_dev_footer.inc
)

Page rendering SQL Queries

[0.00008] SET mysql_set_charset = utf8;
[0.00006] USE staging_prod
[0.00008] SET autocommit = 0;
[0.00006] SET SQL_MODE = TRADITIONAL;
[0.00006] SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
[0.00005] START TRANSACTION;
[0.00005] USE staging_prod
[0.00006] SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
[0.00005] COMMIT
[0.00208] SELECT c.handle, c.faction, c.pProfile FROM characters AS c, players AS p WHERE p.loginStamp > 415997660 AND p.plHandle = c.handle ORDER BY c.handle
[0.00071] SELECT plHandle FROM players WHERE creationStamp > 415913060 AND plHandle != "" ORDER BY creationStamp DESC

Header

[0.00066] SELECT count(*) AS ttl FROM `players` WHERE `loginStamp` > 415394660
[0.00060] SELECT count(*) AS ttl FROM `players` WHERE `loginStamp` > 415997660

Footer

Banner Exchange

[0.00062] SELECT DISTINCT counter FROM bannerRotate WHERE type=0
[0.00015] SELECT counter FROM bannerRotate WHERE name='Purchasing Banner Counter' LIMIT 1
[0.00028] SELECT * FROM bannerRotate WHERE type=0 ORDER BY counter LIMIT 1
[0.00034] UPDATE bannerRotate SET counter=0 WHERE name='Purchasing Banner Counter' LIMIT 1
[0.00012] UPDATE bannerRotate SET counter=counter+1 WHERE bannerID=1

	Year	Day	Time
	13	69	19:24:20

MySQLDatabase::	connect	[]	(/swcombine/http/svn/trunk/libs/path.php:84)
	require_once	["/swcombine/http/svn/trunk/libs/path.php"]	(/swcombine/http/svn/trunk/www/htdocs/community/online/index.php:2)

	db_select	["staging_prod"]	(/swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc:72)
MySQLDatabase::	changeDatabase	["staging_prod"]	(/swcombine/http/svn/trunk/libs/server21/database/DB.inc:28)
	db_query	["SET autocommit = 0;"]	(/swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc:46)
MySQLDatabase::	connect	[]	(/swcombine/http/svn/trunk/libs/path.php:84)
	require_once	["/swcombine/http/svn/trunk/libs/path.php"]	(/swcombine/http/svn/trunk/www/htdocs/community/online/index.php:2)

	db_query	["SET autocommit = 0;"]	(/swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc:46)
MySQLDatabase::	connect	[]	(/swcombine/http/svn/trunk/libs/path.php:84)
	require_once	["/swcombine/http/svn/trunk/libs/path.php"]	(/swcombine/http/svn/trunk/www/htdocs/community/online/index.php:2)

	db_query	["SET SQL_MODE = TRADITIONAL;"]	(/swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc:50)
MySQLDatabase::	connect	[]	(/swcombine/http/svn/trunk/libs/path.php:84)
	require_once	["/swcombine/http/svn/trunk/libs/path.php"]	(/swcombine/http/svn/trunk/www/htdocs/community/online/index.php:2)

	db_query	["SET SESSION TRANSACTION ISOLATION LEVEL REPEA...TABLE READ"]	(/swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc:57)
MySQLDatabase::	connect	[]	(/swcombine/http/svn/trunk/libs/path.php:84)
	require_once	["/swcombine/http/svn/trunk/libs/path.php"]	(/swcombine/http/svn/trunk/www/htdocs/community/online/index.php:2)

	db_query	["START TRANSACTION;"]	(/swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc:61)
MySQLDatabase::	connect	[]	(/swcombine/http/svn/trunk/libs/path.php:84)
	require_once	["/swcombine/http/svn/trunk/libs/path.php"]	(/swcombine/http/svn/trunk/www/htdocs/community/online/index.php:2)

	db_query	["COMMIT"]	(/swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc:77)
MySQLDatabase::	query	["COMMIT"]	(/swcombine/http/svn/trunk/libs/server21/database/DBAtomicClass.inc:162)
DBAtomic::	commit	[]	(/swcombine/http/svn/trunk/libs/server21/database/DBAtomicClass.inc:77)
DBAtomic::	readonly	[]	(/swcombine/http/svn/trunk/www/htdocs/community/online/index.php:4)

ReadOnlyDBAudit::	begin	["SELECT c.handle, c.faction, c.pProfile ... FROM characters AS c, players AS p WHERE p.loginStamp > 415997660 AND p.plHandle = c.handle ORDER BY c.handle"]	(/swcombine/http/svn/trunk/libs/server21/database/DB.inc:34)
	db_query	["SELECT c.handle, c.faction, c.pProfile ... FROM characters AS c, players AS p WHERE p.loginStamp > 415997660 AND p.plHandle = c.handle ORDER BY c.handle"]	(/swcombine/http/svn/trunk/libs/server21/gui/darkness.inc:422)
	onlinePlayers	[415997660]	(/swcombine/http/svn/trunk/www/htdocs/community/online/index.php:13)

ReadOnlyDBAudit::	begin	["SELECT plHandle FROM players WHERE creationSt...amp > 415913060 AND plHandle != "" ORDER BY creationStamp DESC"]	(/swcombine/http/svn/trunk/libs/server21/database/DB.inc:34)
	db_query	["SELECT plHandle FROM players WHERE creationSt...amp > 415913060 AND plHandle != "" ORDER BY creationStamp DESC"]	(/swcombine/http/svn/trunk/libs/server21/gui/darkness.inc:402)
	newestMembers	[]	(/swcombine/http/svn/trunk/www/htdocs/community/online/index.php:14)

Logged in as
Guest