a mini hack to split the arcade into multiple pages..
first find:
Code:
// Query to get the other data for the high scores
$result_topscore2 = $DB_site->query("
SELECT gamesessions.*, user.username, user.userid, games.*, games.title AS title FROM " . TABLE_PREFIX . "gamesessions AS gamesessions
LEFT JOIN " . TABLE_PREFIX . "user AS user ON user.userid = gamesessions.userid
LEFT JOIN " . TABLE_PREFIX . "games AS games ON gamesessions.gamename = games.shortname
$whereclause AND $sessionclause ORDER BY gamesessions.gamename DESC
");
and change it to:
Code:
// Query to get the other data for the high scores
$result_topscore2 = $DB_site->query("
SELECT gamesessions.*, user.username, user.userid, games.*, games.title AS title FROM " . TABLE_PREFIX . "gamesessions AS gamesessions
LEFT JOIN " . TABLE_PREFIX . "user AS user ON user.userid = gamesessions.userid
LEFT JOIN " . TABLE_PREFIX . "games AS games ON gamesessions.gamename = games.shortname
$whereclause AND $sessionclause ORDER BY gamesessions.gamename ASC
");
now find:
Code:
// creates a $gamesettings array, usage $gamesettings[gamename]
$result_gamesettings = $DB_site->query("SELECT gameid, shortname, gamesettings FROM " . TABLE_PREFIX . "games");
while ($gameset = $DB_site->fetch_array($result_gamesettings)) {
$gamesettings[$gameset[shortname]] = convert_bits_to_array($gameset[gamesettings],$_GAMESCHECK);
}
$DB_site->free_result($result_gamesettings);
and change it to:
Code:
$pagenumber = $_REQUEST['page'];
if ($pagenumber == "") $pagenumber=1;
$page_start=($pagenumber-1)*12;
// creates a $gamesettings array, usage $gamesettings[gamename]
$result_gamesettings = $DB_site->query("SELECT gameid, shortname, title, gamesettings FROM " . TABLE_PREFIX . "games ORDER BY shortname ASC LIMIT $page_start,12");
while ($gameset = $DB_site->fetch_array($result_gamesettings)) {
$gamesettings[$gameset[shortname]] = convert_bits_to_array($gameset[gamesettings],$_GAMESCHECK);
}
$DB_site->free_result($result_gamesettings);
$result= $DB_site->query_first("SELECT COUNT(games.gameid) AS gcount FROM ". TABLE_PREFIX ."games AS games ORDER BY shortname ASC");
$totalpages=ceil(($result[gcount])/12);
$perpage=1;
$pagenav = construct_page_nav($totalpages, "arcade.php?$session[sessionurl]");
you now need to edit the
arcade_main template.
find:
and below add:
Code:
<div style="float:right;">$pagenav</div>
Finished.. Enjoy