vb.org Archive - v3 Arcade - Games Arcade & Challenge System [vB 3.0.3]

Quote:

Originally Posted by Giveit2u43

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:

Code:

and below add:

Code:

<div style="float:right;">$pagenav</div>

Finished.. Enjoy :)

This did order them from A to Z instead of Z to A, but they are still on one page :(

Any idea's?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

X vBulletin 3.8.12 by vBS Debug Information

Page Generation 0.04001 seconds
Memory Usage 1,755KB
Queries Executed 10 (?)

More Information

Template Usage:

(1)ad_footer_end
(1)ad_footer_start
(1)ad_header_end
(1)ad_header_logo
(1)ad_navbar_below
(6)bbcode_code_printable
(6)bbcode_quote_printable
(1)footer
(1)gobutton
(1)header
(1)headinclude
(6)option
(1)pagenav
(1)pagenav_curpage
(4)pagenav_pagelink
(6)pagenav_pagelinkrel
(1)post_thanks_navbar_search
(1)printthread
(10)printthreadbit
(1)spacer_close
(1)spacer_open

Phrase Groups Available:

global
postbit
showthread

Included Files:

./printthread.php
./global.php
./includes/init.php
./includes/class_core.php
./includes/config.php
./includes/functions.php
./includes/class_hook.php
./includes/modsystem_functions.php
./includes/class_bbcode_alt.php
./includes/class_bbcode.php
./includes/functions_bigthree.php

Hooks Called:

init_startup
init_startup_session_setup_start
init_startup_session_setup_complete
cache_permissions
fetch_threadinfo_query
fetch_threadinfo
fetch_foruminfo
style_fetch
cache_templates
global_start
parse_templates
global_setup_complete
printthread_start
pagenav_page
pagenav_complete
bbcode_fetch_tags
bbcode_create
bbcode_parse_start
bbcode_parse_complete_precache
bbcode_parse_complete
printthread_post
printthread_complete

Messages:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04001 seconds Memory Usage 1,755KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: