v3 Arcade - Games Arcade & Challenge System [vB 3.0.3]

v3 Arcade [3.0.3]
Games Arcade for vB3
Game copyrights belong to their respective owners.
v3 Arcade - Copyright ?2004 John Warwick, All Rights Reserved.
__________________________________
Arcade Verson: 1.0
vB Version: vBulletin 3.0.3
Author: John Warwick
Email: John[at]eovieinteractive.com
Site: www.v3arcade.com
??????????????????????????????????

Updates
==========================
1.0.0 - Initial release

1.0.1 - Bug fix update
? This release addressed a couple of small bugs. Information on fixing
these issues can be found in the FAQ. (Included in this zip.)

1.0.2 - Bug fixes and new features
? This release makes all games on the Arcade main page appear in the
order which they were installed, regardless of whether or not it has
been played. (With the newest games at the top.)
? It includes a
page navigation system, allowing users to browse games by page. By default, 10 games appear per page.
? There is also a new search feature, for finding games by name/description. (Accessible through the "Search" menu in the navigation bar.)
? This release should be less CPU intensive than previous versions.

1.0.3 - Bug fixes
? Security fixes

History & Hack Information
- So, what is the v3 Arcade?
The v3 Arcade is exactly what the name implies - an online games arcade that offers seamless integration with your vBulletin forum.

The v3 Arcade is the first of the new generation of vBulletin additions. Back from its roots, the v3 Arcade is the vBulletin 3 edition of my original Arcade written in late 2002 (not to be confused with futureal's 'ProArcade', which was written during the Arcade's beta phase).

v3 Arcade Features Include:
? Integrated Flash gaming for vBulletin 3
? Advanced leader board system
? FULL Mozilla/Netscape Compatibility
? Moderation abilities for Mods/Super Mods/Admins
? PM & Email notification for events
? Advanced statistics for all users
? A higher level of security
? "Arcade Challenges", 1-on-1 contests between users
? Arcade awards system
? Automated and manual score pruning tools

This installation comes loaded with the following games:
? Tetris
? Snake
? Asteroids
? Chopper Challenge
? Space Invaders

If you have the source (.FLA) for a game that you want to use in the v3 Arcade, you can send the required files to john@v3arcade.com for conversion. (Providing permission has been given by the original author.) Within a reasonable delay, I'll post the converted game and installation script on vBulletin.org.


Testing
Tested on vBulletin 3.0.3, across multiple unhacked installations.


Thanks to...
? Kura: For helping out with vB3 difficulties!
? Erwin: Whose vB2 Flash Player inspired the original hacks
? Paul Neave: For providing the source for 4 of the standard v3 Arcade games


IMPORTANT NOTES
? If you do install this hack, please click on the INSTALL button. There are going to be some updates for this which you're really not going to want to miss!
? Each Arcade page has an Eovie Interactive and Flash Player link at the bottom. This is optional, but greatly appreciated.
? You may have noticed that this release of the v3 Arcade is not fully phrased. To phrase the arcade would require well over a hundred phrases to be added, making for a lengthy installation process! Futures version of the v3 Arcade will be phrased, with a more automated installation.
? And don't forget - BACKUP BEFORE YOU INSTALL!


Regarding the "ProArcade"
There has been a lot of debate on vb.org recently about the ownership of hack "concepts". My original Arcade hack (on which the v3 Arcade is based), was a progression of the my vBTetris Leaderboard hack - both of which came about before the ProArcade. I've spoken to Erwin regarding this, and he can confirm that this has always been an independent development; hence the v3 Arcade was authorised for release.

Fixes
If you're installing the Arcade from scratch, there are no fixes or updates to be applied. Simply follow the instructions in Installation.txt.
If you've already installed the Arcade, make the changes in Updates.txt.

[Click HERE to view a list of released games and modifications!]

Demos/Add-Ons/Beta Testing
www.v3arcade.com

Download the v3 Arcade (1.0.3) here:

[armkbdotcom]

Originally Posted by lierduh

Herhaps adding a navigation bar at the top of the game list can be more effecitve.

Just modify "arcade_main" template.

Add these two lines before the block of code below:

<span class="smallfont"><br></span>
$pagenav

PHP Code:

<!-- small space --> 
<span class="smallfont"><br> 
</span> 
<!-- /small space --> 
<!-- games  --> 
<table cellpadding="$stylevar[outerborderwidth]" cellspacing="0" 


Still not what we wanted. Lot of space from the right is wasted.

[Spinball]

Hi Folks,
I have just upgraded from vbulletin 3.0.1 to 3.0.3.
Having previously had 1.0.0 of this hack installed, I am slightly confused as to what I need to do to bring it up to 1.0.2.
I have gone through and put all the code changes in.
All the templates seem to be the same so I haven't changed any of those.
But I'm worried about running forumroot/admincp/install_arcade.php incase it overwrites any database information allready there.
Can you please confirm whether I need to run this again or not?

Also I have several tables in the database from the vB2 installation :

arcadeconfig, arcadegames, arcadescoregroups, arcadescores and arcadetopscores

am I right in assuming these are no longer used and I can delete all of them?
Thanks

[dethfire]

this hack worked great for a few months , now suddendly I get this error everytime members visit the arcade:

Database error in vBulletin 3.0.1:

Invalid SQL: 
					SELECT games.title, games.gameid AS gameid, gamesessions.*,user.username FROM gamesessions AS gamesessions
					LEFT JOIN user AS user ON gamesessions.userid = user.userid
					LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
					WHERE gamesessions.valid=1 AND gamesessions.sessiontype=1 ORDER BY gamesessions.finish DESC
				
mysql error: Got error 127 from table handler

mysql error number: 1030

Script: http://www.cool-teens.com/forum/arcade.php?

[Pseudomizer]

Originally Posted by dethfire

this hack worked great for a few months , now suddendly I get this error everytime members visit the arcade:

Database error in vBulletin 3.0.1:

Invalid SQL: 
					SELECT games.title, games.gameid AS gameid, gamesessions.*,user.username FROM gamesessions AS gamesessions
					LEFT JOIN user AS user ON gamesessions.userid = user.userid
					LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
					WHERE gamesessions.valid=1 AND gamesessions.sessiontype=1 ORDER BY gamesessions.finish DESC
				
mysql error: Got error 127 from table handler

mysql error number: 1030

Script: http://www.cool-teens.com/forum/arcade.php?

Perhaps your table has been corrupted. Try to repair the table and it should work again.

Cheers,

[evilTone]

Database error in vBulletin 3.0.3:

Invalid SQL: 
		SELECT gamesessions.*, user.username, user.userid, games.*, games.title AS title FROM gamesessions AS gamesessions
		LEFT JOIN user AS user ON user.userid = gamesessions.userid
		LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
		WHERE (gamename='asteroids' AND score='7210') AND sessiontype=1 ORDER BY gamesessions.gamename DESC
	
mysql error: Column: 'score' in where clause is ambiguous

mysql error number: 1052

any ideas ?
if i clear the table 'gamesessions', then it works for a short time, around 2-3 games then this error comes back.
error also goes away if i 'reset public scores'

i tried the "repair table" option mentioned above also :/

[trackpads]

Originally Posted by armkbdotcom

Still not what we wanted. Lot of space from the right is wasted.

**bump** :-)

[Areku]

176 pages! Holy cow!

Has any1 work around a "bug"? that displays "g:ia M j" on the TIME column (not the LENGTH one) instead of the time?

Thanks!

[Areku]

I've just installed this AWESOMELYGREAT hack and I'd like to make note to John about certain things we'd love to see in the package:

- Game setup instructions: once you have arcade up and running, how do you add new games? that's not covered on the .txts on the package

- the fact of multilingual boards, ie. ease of translations, ie. keep languages off of the arcade.php file

- some way of challenge your users from profile or list of members or direct input of some sort. If u set it up with default values, the arcade won't let you challenge any1 unless he has played on some game before, righT?

[Areku]

Originally Posted by Socrate

hello all

everything works well except only one thing, I have always the date like this in the scores:

PHP Code:

g:ia M J 


it is not posted, have an idea please?

Same problem here, and i just installed it!

Did u solve it Socrate?

Any1?

Thanks!

[jpt62089]

Originally Posted by jpt62089

just installed on my fresh VB... I dont have permission to access the arcade... I checked the group settings and they are go...

Please be easy on my this is my first VB mod! :ninja:

nvm i got it fixed...

[Battle_Ring]

Very Easily Installed...Great Hack...

[Areku]

Originally Posted by jpt62089

nvm i got it fixed...

how did u fix it, jpt62089?

[trackpads]

I had an idea about adding regular (unconverted) games to the arcade. I think this would be a great idea and would open the Arcade to thousands of legal games like the ones from miniclip which cant be converted.

http://www.v3arcade.com/play/showthread.php?p=12045

What do you guys think?

[Swanny231]

I am having problems with the group premissions
here is what I did.
(Parse error: parse error in /var/www/html/forums/admincp/usergroup.php on line 846)
usergroup.php

PHP Code:

print_table_header($vbphrase['general_permissions']);
    print_yes_no_row($vbphrase['can_see_invisible_users'], 'usergroup[canseehidden]', $ug_bitfield['canseehidden']);
    print_yes_no_row($vbphrase['can_view_member_info'], 'usergroup[canviewmembers]', $ug_bitfield['canviewmembers']);
    print_yes_no_row($vbphrase['can_edit_own_profile'], 'usergroup[canmodifyprofile]', $ug_bitfield['canmodifyprofile']);
    print_yes_no_row($vbphrase['can_set_self_invisible'], 'usergroup[caninvisible]', $ug_bitfield['caninvisible']);
    print_yes_no_row($vbphrase['show_edited_by_note_on_edited_messages'], 'usergroup[showeditedby]', $ug_bitfield['showeditedby']);
    print_yes_no_row($vbphrase['can_use_custom_title'], 'usergroup[canusecustomtitle]', $ug_bitfield['canusecustomtitle']);
    print_yes_no_row($vbphrase['can_use_signatures'], 'usergroup[canusesignature]', $ug_bitfield['canusesignature']);
    print_yes_no_row($vbphrase['can_view_others_profile_pictures'], 'usergroup[canseeprofilepic]', $ug_bitfield['canseeprofilepic']);
    print_yes_no_row($vbphrase['can_view_hidden_custom_fields'], 'usergroup[canseehiddencustomfields]', $ug_bitfield['canseehiddencustomfields']);
    print_table_break();
    print_column_style_code(array('width: 70%', 'width: 30%'));

    print_table_header("Arcade Permissions");
    print_yes_no_row("Can View the Arcade? <dfn>Allows usergroup to view the arcade, including high scores and leaderboards</dfn>", 'usergroup[canviewarcade]', $ug_bitfield['canviewarcade']);
    print_yes_no_row("Can Play Games in the Arcade? <dfn>Allows usergroup to play arcade games</dfn>", 'usergroup[canplayarcade]', $ug_bitfield['canplayarcade']);
    print_yes_no_row("Can Post Comments? <dfn>Allows usergroup to post comments when they achieve a high score</dfn>", 'usergroup[canmakecomments]', $ug_bitfield['canmakecomments']);
    print_yes_no_row("Can Edit Leaderboard Comments? <dfn>Allows usergroup to edit comments left by other members</dfn>", 'usergroup[caneditscores]', $ug_bitfield['caneditscores']);
    print_yes_no_row("Can Delete Leaderboard Scores? <dfn>Allows usergroup to delete scores and comments left by other members</dfn>", 'usergroup[candelscores]', $ug_bitfield['candelscores']);
    print_table_break();
        print_column_style_code(array('width: 70%', 'width: 30%'));

    print_table_header($vbphrase['forum_viewing_permissions']);
    print_yes_no_row($vbphrase['can_view_board'], 'usergroup[canview]', $ug_bitfield['canview']);
    print_yes_no_row($vbphrase['can_view_others_threads'], 'usergroup[canviewothers]', $ug_bitfield['canviewothers']);
    print_yes_no_row($vbphrase['can_see_deletion_notices'], 'usergroup[canseedelnotice]', $ug_bitfield['canseedelnotice']);
    print_yes_no_row($vbphrase['can_search_forums'], 'usergroup[cansearch]', $ug_bitfield['cansearch']);
    print_yes_no_row($vbphrase['can_use_email_to_friend'], 'usergroup[canemail]', $ug_bitfield['canemail']);
    print_yes_no_row($vbphrase['can_download_attachments'], 'usergroup[cangetattachment]', $ug_bitfield['cangetattachment']);
    print_table_break();
    print_column_style_code(array('width: 70%', 'width: 30%')); 


[Swanny231]

How to install new games ????? I dont have the install games tab in the arcade settings ?

As for my above post I just removed the hack on the usergroup and went into my sql and did the permissions manually