Show Latest Arcade Addition on Forum Home

This is a very basic hack that will add a line to your "What's Going On?" box which shows the latest addition that you have made to your arcade (ie. the last game that you installed).

It should be noted that installing this WILL add 1 small QUERY to index.php. This should have little - if any - affect on server load or loading times.

[high]If you have DWard's "Show total amount of arcade games on Forum Home" hack installed, you can merge the queries so that it adds only 1 query instead of 2 - and the instructions have now been updated to tell you how.[/high]


With thanks to mavherzog, there is now also an ibProArcade version of this mod in the zip. The v3arcade version is prefixed "V3A" and the ibProArcade version is prefixed "IBPRO".


Please click install if you find this useful..

[mavherzog]

I modified this slightly to work with ibProArcade. Basically, all I had to do was change the DB query in index.php to match up with the right table and field names for ibProArcade. Instead of adding this to index.php:

// Latest Addition to Arcade
$result_newgame = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "games ORDER BY gameid DESC LIMIT 1");
$result_newgametitle = $DB_site->fetch_array($result_newgame);
$newgame = $result_newgametitle['title'];
$newgameid = $result_newgametitle['gameid'];

Add this instead:

// Latest Addition to Arcade
$result_newgame = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "games_list ORDER BY gid DESC LIMIT 1");
$result_newgametitle = $DB_site->fetch_array($result_newgame);
$newgame = $result_newgametitle['gtitle'];
$newgameid = $result_newgametitle['gid'];

Apologies if this had been addressed before.

[Oblivion Knight]

Schweet! With your permission I'd like to include that in the zip as an ibProArcade version of the mod.

You'll be credited, obviously.

[mavherzog]

Originally Posted by Oblivion Knight

Schweet! With your permission I'd like to include that in the zip as an ibProArcade version of the mod.

You'll be credited, obviously.

Go right ahead!!

[94DROPTOPZ]

Very nice!

Thank you... "Clicks Install"

[MPM.com]

My apologies if this has been asked before, but is there a hack similar to this that works with the vbadvanced cmps? www.mobilephonemadness.com

Would like the current top players in a module on thehome page if thats possible?

Mark

[Oblivion Knight]

You could try asking over at http://www.vbadvanced.com - they'll know more than I.

[MustangLisa]

Great hack, thanks!!

[dsboyce8624]

Originally Posted by MPM.com

My apologies if this has been asked before, but is there a hack similar to this that works with the vbadvanced cmps? www.mobilephonemadness.com

Would like the current top players in a module on thehome page if thats possible?

Mark

You should search for the leaderboard hack and see about porting it to a CMPS module. Probably not too hard.

[dsboyce8624]

I wanted this in the NAVBAR so it would attract more attention so here is what I did:

If you DO NOT have my Number of v3 Arcade Games in vBadvanced Stats Block hack installed:

In global.php find:

		$vbphrase['total_x_nav_compiled'] = construct_phrase($vbphrase['total_x_nav'], $bbuserinfo['pmtotal']);


Below it add:

		// Latest Arcade Game
		$result_newgame = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "games ORDER BY gameid DESC LIMIT 1");
		$result_newgametitle = $DB_site->fetch_array($result_newgame);
		$newgame = $result_newgametitle['title'];
		$newgameid = $result_newgametitle['gameid'];


OTHERWISE:


If you DO have my Number of v3 Arcade Games in vBadvanced Stats Block hack installed:

In global.php find:

	       	$result_allgames = $DB_site->query("
 		SELECT * FROM " . TABLE_PREFIX . "games $searchclause ORDER BY gameid DESC
        		");
        	
        		$gamecount = $DB_site->num_rows($result_allgames);



Replace it with:


		$result_games = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "games $searchclause ORDER BY gameid DESC");
		$result_newgametitle = $DB_site->fetch_array($result_games, 1);
		$gamecount = $DB_site->num_rows($result_games);
		$newgame = $result_newgametitle['title'];
		$newgameid = $result_newgametitle['gameid'];


AND, for BOTH cases:


Template Edit:

In NAVBAR find:

			<phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]">$vbphrase[last_visited_x_at_y]</phrase>
			<if condition="$show['pmstats']"><br />


Replace with:

			<phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]">$vbphrase[last_visited_x_at_y]</phrase> <br />
			Newest Arcade Game: <a href="arcade.php?$session[sessionurl]do=play&gameid=$newgameid">$newgame</a>			
			
			<if condition="$show['pmstats']"><br />

If you use vBa CMPS add the following to AdminCP->vBa CMPS->Default Settings->Portal Output Global Variables:

		newgame
		newgameid

Done.

Hopefully this will get more people to notice that you have an arcade. I know that the arcade has attracted and kept users for me.

Dennis

[Oblivion Knight]

Thanks for sharing Dennis, an alternative is always handy..