v3Arcade Random Game &

[stangger5]

Random game with game description..

Thanks to ConqSoft for his template work
and Chucky's, untold4u's and goblues !!!!

The Zip folder attached is to add the module manually ..

Enjoy !!:cool:

[dieselpowered]

Random game with game description..

Thanks to ConqSoft for his template work
and Chucky's, untold4u's and goblues !!!!

The Zip folder attached is to add the module manually ..

Enjoy !!:cool:

Works great...thanks!

[Our Sponsors]

[goblues]

nice work! :D

[alicat]

nice, but have you noticed the highscores? each has .000 after it :) how to remove that?

i've tried TRUNCATE, ROUND....blast, i cannot suss it

-A

[Our Sponsors]

[stangger5]

nice, but have you noticed the highscores? each has .000 after it :) how to remove that?

i've tried TRUNCATE, ROUND....blast, i cannot suss it

-A

OK,,fixed the .000

[alicat]

thanx dude!

[lairnoc]

i'll try it

[DementedMindz]

i changed my template around a bit cause its not 100% html complaint so i made mine 100% complaint in adv_portal_random_arcade i have this code if anyone wants to try it


<tr>
<td class="$bgclass">
<fieldset class="fieldset" style="margin:0px 0px 0px 0px">

<br/>

<div align="center">Have You Played ?

<br/>
<br/>

<a href="$vboptions[bburl]/arcade.php?$session[sessionurl]do=play&amp;gameid=$randomgame[gameid]"><img src="$vboptions[bburl]/$vboptions[arcadeimages]/$randomgameimg" border="0" alt="Have You Played ?" /></a>

<br/>
<br/>

<a href="$vboptions[bburl]/arcade.php?$session[sessionurl]do=play&amp;gameid=$randomgame[gameid]"><strong>$randomgame[title]</strong></a>

<br/>
<br/>

<a href="$vboptions[bburl]/arcade.php?$session[sessionurl]do=scores&amp;gameid=$randomgame[gameid]">High Score is $randomgame[highscore]</a>

<br/>
<br/>

</div></fieldset></td>
</tr>

[plateau]

thanks works well。

[plateau]

any arcade news module working for 2.x?

[stangger5]

any arcade news module working for 2.x?

Yes there is...
Look at v3arcade.com in the Modification Releases section...

[plateau]

thank u stangger

[frosch68]

many thanks, works well at www.mx5gemeinschaft.info/Spieleforum/index.php !!!!

[hammondfra]

Maybe I am dumb or something, but I get an SQL error when I use this module. It states it can not locate the table in which it is looking for. What am I doing wrong?

I had it loaded once, but all I got was a red X, then I realized I didn't put the code in, went to enter it...and bam takes me to the SQL Error page......Thanks in advance if anyone can point me in the correct direction to load this module correctly.

[sakli_duslerr]

thank you :)

[Velas]

Is it possible to show in this block the user who gets the highscore?

[theczech]

Maybe I am dumb or something, but I get an SQL error when I use this module. It states it can not locate the table in which it is looking for. What am I doing wrong?

I had it loaded once, but all I got was a red X, then I realized I didn't put the code in, went to enter it...and bam takes me to the SQL Error page......Thanks in advance if anyone can point me in the correct direction to load this module correctly.

I got the same error.

I followed the installation directions, tried the above mentioned template, but to no success.

[dubmedia]

How do i "ad a template" please help! ive done everything else accept this.

[Magnumutz]

Does this works with ibp arcade too?

[Mick2015]

hey thanks alot works sweet

[dart vader]

nice work

[MummaLJ]

its not working for me either....

[Stealth07]

i get a error Database error in vBulletin 3.7.1:

Invalid SQL:
SELECT gameid,title,description,stdimage,highscore FROM arcade_games ORDER BY RAND() LIMIT 1;

MySQL Error : Table 'daydiee.arcade_games' doesn't exist
Error Number : 1146
Request Date : Friday, June 27th 2008 @ 01:16:36 PM
Error Date : Friday, June 27th 2008 @ 01:16:38 PM
Script : http://daydie.co.uk/index.php
Referrer : http://daydie.co.uk/index.php
IP Address : 86.27.162.204
Username : daydie
Classname : vB_Database
MySQL Version : 5.0.45-log

[traxxadd]

Hey guys this isnt coded for 3.7 need to uninstall and make a request

[ArbStar]

Hey

Thnx for the Add-on

Does it work with vBulletin 3.7.2 & ibProArcade ..?!

[stangger5]

This works just fine with v3arcade and vb3.7.X..

It will not work with ibpProarcade..

I have made some that do tho...

[e7saas]

thanks

[BirdOPrey5]

I got the same error.

I followed the installation directions, tried the above mentioned template, but to no success.

The name of the table is wrong, the new version of the arcade may have changed the name of the games table... edit the .php file, go to the line:

$randomgame = $db->query_first("SELECT gameid,title,description,stdimage,highscore FROM ".TABLE_PREFIX."arcade_games ORDER BY RAND() LIMIT 1");


and add "v3" before the "arcade_games" to make it:

$randomgame = $db->query_first("SELECT gameid,title,description,stdimage,highscore FROM ".TABLE_PREFIX."v3arcade_games ORDER BY RAND() LIMIT 1");


While your at it if you only want to display random games from a single category of games you can change it to the following:

$randomgame = $db->query_first("SELECT gameid,title,description,stdimage,highscore FROM ".TABLE_PREFIX."v3arcade_games WHERE categoryid = 4 ORDER BY RAND() LIMIT 1");

For me 'categoryid = 4' is my arcade games category, as opposed to shooters/puzzles/etc...

[KW802]

The name of the table is wrong, the new version of the arcade may have changed the name of the games table... edit the .php file, go to the line:The table names were changed as part of the 2.0.0 major rewrite. :)

Here is another vBa CMPS module that same may be interested in...

http://www.v3arcade.com/forums/showthread.php?t=3002

It is the same module used on the front page of v3Arcade.com with the v3A stats.