[dstruct2k]

I don't think the installer made my gamesessions table.

Database error in vBulletin 3.0.0:
 
Invalid SQL: 
		SELECT COUNT(*) AS plays, SUM(finish-start) as time
		FROM gamesessions
		WHERE valid=1
 
mysql error: Table 'db87385808.gamesessions' doesn't exist
 
mysql error number: 1146

That doesn't look right though... "db87385808" is my database, not a table name...


[edit]Checked in phpmyadmin... the table is "vb3__gamesessions" so something's not working right.

[edit 2]Found the bug in arcade.php.... Most of you aren't using table prefixes, otherwise you'd have this bug too.
FIX:
Find:

$stats = $DB_site->query_first("
SELECT COUNT(*) AS plays, SUM(finish-start) as time
FROM gamesessions
WHERE valid=1
");

Replace with:

$stats = $DB_site->query_first("
SELECT COUNT(*) AS plays, SUM(finish-start) as time
FROM " . TABLE_PREFIX . "gamesessions
WHERE valid=1
");