Show Latest Arcade Addition on Forum Home

[Oblivion Knight]

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.

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.


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.. :)

[Intex]

Nice work Oblivion. Would be nice to have a module for CMPS as well :).

[Polo]

Nice Oblivion ;)

[Oblivion Knight]

Whoops.. Fixed a typo (phrase name to add - removed extra space).

Instructions updated.


Nice work Oblivion. Would be nice to have a module for CMPS as well :).I'll look into it later for you..

[starfantazy]

thanks andy!! ill "try" to install it later haha, saying i wont mess up the database again...

[DWard]

Yer I want this :)

* DWard clicks install

[mcncyo]

I got one problem with your instructions. I don't like beer :devious: ;)

[Intex]

Nice one. Thanks.


Whoops.. Fixed a typo (phrase name to add - removed extra space).

Instructions updated.


I'll look into it later for you..

[revenger681]

I would like somehting like this, only i would like to show the current arcade players and scores... I have about 15 'regular' players who play quite often in my arcade... They've been requesting new games and what-not also... So I was wondering two things:

1) How can I add latest scores and players to the main current activity area?

2) How do I install new games into my arcade, and also keep track of those scores?

Can someone please help, or point me in the right direction?

[Oblivion Knight]

Nice suggestions, but it's not really anything to do with this mod.. ;)

[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]

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]

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.. :)

[dsboyce8624]

No, problem, sorry about the confusion.

[PCOSLiving.com]

Parse error: parse error, unexpected $ in /home/pcoslivi/public_html/forums/profile.php on line 2665

I get that msg after installing this. I also have ipinfo and ustore installed.

[stan111]

this is a very koool hack
thanks a lot