[CMPS v2.0 RC1] Last 5 Added Arcade Games - Side Block

[untold4you]

See: [THIS THREAD] (http://www.vbadvanced.com/forum/showthread.php?p=49752#post49752) For Center Version and more information.
ibPro Version: [Here] (http://www.vbadvanced.com/forum/showthread.php?p=50441#post50441)

Screenshot:

http://www.powerplant.be/ppimages/last5addeds.gif (http://www.powerplant.be)

UPDATE:

Seems I was stupid enough to NOT include the template :confused:

Add template:

AdminCP > Styles & Templates > Style Manager > Add Template

Name the template: adv_portal_arcade_last5s

Copy this into the template:
<!-- Last 5 Games Added vBArcade Side / http://www.powerplant.be -->
<tr>
<td class="$getbgrow" width="100%">
$outp
</td>
</tr>
<!-- Last 5 Games Added vBArcade Side / http://www.powerplant.be -->
Your done.

Gr3³Tz Untold..

[Blaminator]

#Which arcade is this for? IbProArcade or v3Arcade?

[Our Sponsors]

[untold4you]

#Which arcade is this for? IbProArcade or v3Arcade?

That would be v3Arcade.

[black_ps2]

Could you make it for ibproarcade?

[Our Sponsors]

[untold4you]

Could you make it for ibproarcade?

Working on it now, first gotta fix a few bugz in ibProArcade

[MortysTW]

You ever get this working for ibProArcade?

[untold4you]

Working on it now, first gotta fix a few bugz in ibProArcade

Still working on in m8, did not found the time yet...

[bugzy]

Where do we get vb3arcade from?

I went to, http://www.v3arcade.com/, and the site doesnt go anywhere right now

[untold4you]

Where do we get vb3arcade from?

I went to, http://www.v3arcade.com/, and the site doesnt go anywhere right now

Take a look @ http://www.vbulletin.org/forum/showthread.php?threadid=60377

[rinkrat]

On running the install script:


Invalid SQL:
ALTER TABLE `games ADD datestamp INT( 11 ) NOT NULL AFTER gameid ;

mysql error: Table 'lgk2.games ADD datestamp INT( 11 ) NOT NULL AFTER gameid' doesn't exist

mysql error number: 1146

Date: Friday 01st of July 2005 10:10:24 AM
Script: http://www.letsgokings.com/bbs/admincp/install_arcade_last5.php
Referer: http://www.letsgokings.com/bbs/admincp/install_arcade_last5.php

[untold4you]

On running the install script:


Invalid SQL:
ALTER TABLE `games ADD datestamp INT( 11 ) NOT NULL AFTER gameid ;

mysql error: Table 'lgk2.games ADD datestamp INT( 11 ) NOT NULL AFTER gameid' doesn't exist

mysql error number: 1146

Date: Friday 01st of July 2005 10:10:24 AM
Script: http://www.letsgokings.com/bbs/admincp/install_arcade_last5.php
Referer: http://www.letsgokings.com/bbs/admincp/install_arcade_last5.php


Seems to me you are using vBulletin 3.5, did not test it yet on this version m8

[mightyj]

will this run on vbulletin 3.07?

This is my error:

Database error in vBulletin 3.0.7:

Invalid SQL:
ALTER TABLE `games ADD datestamp INT( 11 ) NOT NULL AFTER gameid ;

mysql error: Table 'nextgenerationofunity_com_-_forums.games ADD datestamp INT( 11 ) NOT NULL AFTER gameid ;
' doesn't exist

mysql error number: 1146

Date: Tuesday 05th of July 2005 11:50:32 PM
Script: http://www.nextgenerationofunity.com/forum/admincp/install_arcade_last5.php
Referer: http://www.nextgenerationofunity.com/forum/admincp/install_arcade_last5.php

[untold4you]

Fixed the problem, just re download the install.zip

Gr3³Tz Untold...

[mightyj]

I am now getting this error on install:

Database error in vBulletin 3.0.7:

Invalid SQL:
ALTER TABLE games ADD datestamp INT( 11 ) NOT NULL AFTER gameid ;

mysql error: You have an error in your SQL syntax near ';
' at line 2

mysql error number: 1064

Date: Thursday 07th of July 2005 09:09:11 AM
Script: http://www.nextgenerationofunity.com/forum/admincp/install_arcade_last5.php
Referer: http://www.nextgenerationofunity.com/forum/admincp/install_arcade_last5.php

[untold4you]

Re-uploaded again and checked it, no problem @ my end. Keep in mind that you do not have to run this install for IbPro. Let me know how it goes.

[Mr.G]

what do you mean by "game install file"... in the intructions
really wanna get this working

[puertoblack2003]

what do you mean by "game install file"... in the intructions
really wanna get this working


i'm in the same boat stuck on that can some 1 be specfic.

Thank you

[untold4you]

what do you mean by "game install file"... in the intructions
really wanna get this working

When you use a php file to install a new game you should find this in the file:
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "games (shortname, gameid, title, descr, file, width, height, miniimage, stdimage, gamesettings, highscorerid, highscore) VALUES ('$shortname', NULL, '$title', '$description', '$shortname.swf', '$game_width', '$game_height', '". $shortname ."2.gif', '". $shortname ."1.gif', 29, NULL, NULL)");

And replace it with:
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "games (shortname, gameid, datestamp, title, descr, file, width, height, miniimage, stdimage, gamesettings, highscorerid, highscore) VALUES ('$shortname', NULL, ". TIMENOW . ", '$title', '$description', '$shortname.swf', '$game_width', '$game_height', '". $shortname ."2.gif', '". $shortname ."1.gif', 29, NULL, NULL)");

This adds the date you installed your game.
How do you install a new game??

Gr3³Tz...

[puertoblack2003]

When you use a php file to install a new game you should find this in the file:
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "games (shortname, gameid, title, descr, file, width, height, miniimage, stdimage, gamesettings, highscorerid, highscore) VALUES ('$shortname', NULL, '$title', '$description', '$shortname.swf', '$game_width', '$game_height', '". $shortname ."2.gif', '". $shortname ."1.gif', 29, NULL, NULL)");

And replace it with:
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "games (shortname, gameid, datestamp, title, descr, file, width, height, miniimage, stdimage, gamesettings, highscorerid, highscore) VALUES ('$shortname', NULL, ". TIMENOW . ", '$title', '$description', '$shortname.swf', '$game_width', '$game_height', '". $shortname ."2.gif', '". $shortname ."1.gif', 29, NULL, NULL)");

This adds the date you installed your game.
How do you install a new game??

Gr3³Tz...


got it now new games installs
good hack**installed**

[angkor408]

Hi, how come I got this error msg when trying to add a block.

Fatal error: Call to a member function on a non-object in /hermes/web04/b2126/pow.timmy408/htdocs/forums/modules/arcade_last5_side.php on line 46


Vbulletin version: 3.5
v3arcade 1.06

here my site link: www.khmerclub.org

[bandare]

where is best to dload more games for vbarcade3 that will ensure they list right in the arcade section and retain high scores???

I can't find places that are free....