The Arcive of Official vBulletin Modifications Site.

Addon: Auto-populate Navbar menu (for John's Arcade V3) · **Released**: 02-06-2004

Addon: Auto-populate Navbar menu (for John's Arcade V3)

What this hack does:

It replaces the link in your navbar for the Arcade with a Dropdown menu of all the games that are active in your Arcade.

Motivation: Extrapolated from my other auto-populating menu for Erwin's vB3 hack ...

Files to edit: 2
global.php
includes/functions.php
Template to edit: 1
navbar
New phrases to insert: 1
Queries added: 1

Step 1: Add the following in the Phrase Manager under GLOBAL

Alternate: you can import the single phrase using the included XML file

************************************************** ******
Name: arcade_addon_title
Phrase: The Arcade!
************************************************** ******

Step 2: Add the following at the bottom of global.php

Find:

Code:

/*======================================================================*\
|| ####################################################################
|| # Downloaded:

Add Before:

PHP Code:


			
// Addon to John's vB3 ArcadeV3 hack - created by Natch

    $nav_arcade = genArcadeMenu();

// Addon to John's vB3 ArcadeV3 hack - created by Natch

Step 3: Add the following at the bottom of includes/functions.php

Find:

Code:

/*======================================================================*\
|| ####################################################################
|| # Downloaded:

Add Before:

PHP Code:


			
// Addon to John's vB3 ArcadeV3 hack - created by Natch

function genArcadeMenu() {

    global $DB_site,$vboptions;

    $theseGames = $DB_site->query("SELECT gameid,title,gamesettings FROM " . TABLE_PREFIX . "games ORDER BY title");

    while ($thisGame = $DB_site->fetch_array($theseGames)) {

        $arcmenu.= (is_int($thisGame[gamesettings]/2)) ? "" : "\t\t<tr><td class=\"vbmenu_option\"><a href=\"$vboptions[bburl]/arcade.php?$session[sessionurl]do=play&amp;gameid=".$thisGame[gameid]."\">".$thisGame[title]."</a></td></tr>\n";

    }

    return $arcmenu;

}

// Addon to John's vB3 ArcadeV3 hack - created by Natch

Step 4: Add the following to the template 'navbar'

Find:

Code:

<!-- / NAVBAR POPUP MENUS -->

Add Before:

Code:

<!-- Addon to John's vB3 ArcadeV3 hack - created by Natch -->
	<if condition="$show['member']"> <!-- remove this line and the endif if you wish all users and guests to view the menu -->
	<!-- flash arcade auto-menu -->
	<div class="vbmenu_popup" id="flasharcade_menu" style="display:none">
		<table cellpadding="4" cellspacing="1" border="0">
		<tr><td class="thead"><a href="$vboptions[bburl]/arcade.php?$session[sessionurl]" title="$vbphrase[arcade_addon_title]">$vbphrase[arcade_addon_title]</a></td></tr>
$nav_arcade
		</table>
	</div>
	<!-- / flash arcade auto-menu -->
	</if>
<!-- Addon to John's vB3 ArcadeV3 hack - created by Natch -->

Find:

Code:

<td class="vbmenu_control"><a href="arcade.php?$session[sessionurl]">Arcade</a></td>

REPLACE WITH:

Code:

<!-- Addon to John's vB3 ArcadeV3 hack - created by Natch -->
			<if condition="$show['member']"> <!-- remove this line and the endif if you wish all users and guests to view the menu -->
				<td id="flasharcade" class="vbmenu_control"><a href="#flasharcade">$vbphrase[arcade_addon_title]</a> <script type="text/javascript"> vbmenu_register("flasharcade"); </script></td>
			</if>
<!-- Addon to John's vB3 ArcadeV3 hack - created by Natch -->

NOTE: in the two navbar edits there are conditionals that WILL CAUSE the menu to only appear to Registered users - remove these conditional wrappers to show the menu to all and sundry ...

Should work

Enjoy, and props to John for his great Hack ...
U can see a demo @ http://www.mobileforces.org/ << running vBulletin 3.0.0 RC4 and vBIndex RC3, on PHP v4.3.4, MySQL 4.0.15

Screenshots attached: one with all default games enabled, and one with asteroids disabled

UPDATE: fixed up my comments - damn that copy and paste ... those that downloaded the attachment b4 5AM +11GMT, re-get the attachment, or make the following alterations to the above script:

Find twice:

Code:

// remove this line and the endif if you wish all users and  guests to view the menu

Replace with:

Code:

<!-- remove this line and the endif if you wish all users and guests to view the menu -->

UPDATE: IF YOU WANT ONLY N MOST POPULAR GAMES - check out this post

UPDATE: if you wat IMGAES in your dropdown menu, check out this post

Natch · #12 02-07-2004, 04:39 PM

Good thing the drop-downs are persistent and you can scroll LOL ...

But what could be done to improve this is to evaluate which are the most popular 15 games, and only put them in the menu ... probably based on the number of times played, or the length of time played ... if it became an issue that could be implemented ...

M1th · #13 02-07-2004, 04:48 PM

Quote:

Originally Posted by Natch

But what could be done to improve this is to evaluate which are the most popular 15 games, and only put them in the menu ... probably based on the number of times played, or the length of time played ... if it became an issue that could be implemented ...

now, that I like. The sql query will no doubt get abit complicated, though since you'd need to do a join table and use 'count', order by, limit etc.

gmarik · #14 02-07-2004, 07:27 PM

Any chance to use it without DHTML on?

Natch · #15 02-08-2004, 03:25 AM

Quote:

Originally Posted by gmarik

Any chance to use it without DHTML on?

How would you want it - like in a Sidebar menu ? or a vBIndex custom box ?

Sure - could be done

BlackxRam · #16 02-08-2004, 05:46 AM

THIS IS AWESOME LOOKING. But right now even with a dozen or so games the LIST is Huge!

I like the idea of HAVING an option like ONLY use top 5 games. or Whatever you want to make the limit. Personally I would like to use Top5 most visited Games. Someone might want to use Top 10. Perhaps a editable field in the Arcade Panel for this option.

Ill use this hack soon if it ever gets those features.

Ill keep in touch with this thread.

Natch · #17 02-08-2004, 06:51 AM

Another option (if it is just the size of the list that is too big) is to edit the CSS statements for the navbar popup links - drop them down a fint size and it should help a lot ...

Sometimes I forget that not everyone has 1280x1024 ...

I'll look into this ok guys ?

Natch · #18 02-10-2004, 04:58 AM

Quote:

Originally Posted by Natch

Another option (if it is just the size of the list that is too big) is to edit the CSS statements for the navbar popup links - drop them down a fint size and it should help a lot ...

Sometimes I forget that not everyone has 1280x1024 ...

I'll look into this ok guys ?

OK - I've created the new function to populate the menu with only the N most played games - atm the value of N will be hardcoded by you the hacker into your global.php (where the function is called), but for the next release (which will have this variant as an option) I will add it to the Arcade ACP Options page (once I learn how to do ACP options LOL) - I will not be updating the original instructions until the next release ...

IF YOU WANT TO HAVE ONLY N MOST POPULAR OPTIONS

Find in includes/functions.php

PHP Code:


			
// Addon to John's vB3 ArcadeV3 hack - created by Natch

function genArcadeMenu() {

    global $DB_site,$vboptions;

    $theseGames = $DB_site->query("SELECT gameid,title,gamesettings FROM " . TABLE_PREFIX . "games ORDER BY title");

    while ($thisGame = $DB_site->fetch_array($theseGames)) {

        $arcmenu.= (is_int($thisGame[gamesettings]/2)) ? "" : "\t\t<tr><td class=\"vbmenu_option\"><a href=\"$vboptions[bburl]/arcade.php?$session[sessionurl]do=play&amp;gameid=".$thisGame[gameid]."\">".$thisGame[title]."</a></td></tr>\n";

    }

    return $arcmenu;

}

// Addon to John's vB3 ArcadeV3 hack - created by Natch

Replace with:

PHP Code:


			
// Addon to John's vB3 ArcadeV3 hack - created by Natch

function genArcadeMenu($limit) {

    global $DB_site,$vboptions;

    $theseGames = $DB_site->query("

                    SELECT " . TABLE_PREFIX . "games.gameid AS gameid, " . TABLE_PREFIX . "games.title AS title, " . TABLE_PREFIX . "games.gamesettings as gamesettings, COUNT(" . TABLE_PREFIX . "gamesessions.gamename) AS popularity 

                    FROM " . TABLE_PREFIX . "games 

                    INNER JOIN " . TABLE_PREFIX . "gamesessions 

                    ON " . TABLE_PREFIX . "games.shortname = " . TABLE_PREFIX . "gamesessions.gamename 

                    GROUP BY title 

                    ORDER BY popularity DESC 

                    LIMIT $limit

                    ");

    while ($thisGame = $DB_site->fetch_array($theseGames)) {

        $arcmenu.= (is_int($thisGame[gamesettings]/2)) ? "" : "\t\t<tr><td class=\"vbmenu_option\"><a href=\"$vboptions[bburl]/arcade.php?$session[sessionurl]do=play&amp;gameid=".$thisGame[gameid]."\">".$thisGame[title]."</a></td></tr>\n";

    }

    return $arcmenu;

}

// Addon to John's vB3 ArcadeV3 hack - created by Natch

Find in global.php

PHP Code:


			
// Addon to John's vB3 ArcadeV3 hack - created by Natch

    $nav_arcade = genArcadeMenu();

// Addon to John's vB3 ArcadeV3 hack - created by Natch

Replace with:

PHP Code:


			
// Addon to John's vB3 ArcadeV3 hack - created by Natch

    $nav_arcade = genArcadeMenu("6");

// Addon to John's vB3 ArcadeV3 hack - created by Natch

This should do it ... change the value in the global function call (above) to match your required number of menu options ...

Amzadi · #19 02-10-2004, 05:51 AM

Got a screen capture of this?

Natch · #20 02-10-2004, 08:41 AM

Check out the first post - this is just a modification of the first script ...

dirtymerc · #21 02-11-2004, 05:35 AM

Everything worked, but my arcade button is missing, its just a drop down arrow??? www.offthetopic.com/forums

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05151 seconds Memory Usage 2,357KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (8)bbcode_code (6)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!