The Arcive of Official vBulletin Modifications Site.

v3 Arcade - Games Arcade System for 3.6.0 · **Released**: 11-26-2005

Staff note: Requesting or posting links to sites for massive game downloads is considered posting links to Warez and is not allowed. Also see: Posting/requesting (links to) Game Downloads
=================================
v3 Arcade
for vBulletin 3.6.1
=================================

"v3 Arcade" is the third Arcade system I've written for vBulletin. It's coded from scratch, not a port of an older version - and because it was coded specifically for vBulletin 3.6 it uses the product system for code modifications, and utilizes AJAX technology throughout. Here's a brief rundown of the features in this version of v3 Arcade.

- Supports both v3 Arcade and iB games.
- Download *legal* free, premium and multiplayer games directly from v3arcade.com to your Arcade installation.
- Import script to convert your old v3 Arcade installation. (A script to import games, scores and news from old IBPro installations is available here, thanks to Tigga: http:www.v3arcade.com/forums/showthread.php?t=324)
- AJAX based instant ratings, for simple to use game ratings.
- AJAX based inline score moderation.
- AJAX based instant game searching.
- Tabbed, customizable categories.
- Challenge system for one-on-one contests.
- User-permission based settings for email/PM notification, challenge settings.
- Streamlined viewing modes for users with lower resolutions.
- AJAX based quick stats, for viewing statistics by passing the cursor over a username.
- Mass import tools for importing games in bulk.
- Reverse and decimal based scoring.
- Arcade-only closure with customizable message.
- Per game criteria, allows you to control access to games by reputation, posts, registration length.
- Postbit based awards.
- Personalized recommendations for other games users might like, based on what they?re playing.
- Quick stats, letting a user know how many other scores are above and below theirs.
- Score ranking.
- Admin customizable ?score feedback?, displays a message based on how well as user has done.
- Numerous Admin CP settings to control things like popup opacity, maximum comment length, hover delay length, and numerous other behaviors.
- Full admin control over the types of content allowed in comments (BB code, HTML, smilies, etc.)
- Usergroup based access permissions.
- Fully phrased, for each translation into other languages.
- An ever growing collection of third party add-ons, thanks to Oblivion Knight.
- A slick, professional layout.

=================================
Change Log
=================================

1.0.0 - First public release.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

1.0.1 - Bug fixes and feature release.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- More visible postbit award presence.
- Reverse scoring option added to games.
- Data dictionary implementation, makes sure the Arcade database changes are correctly made.
- Template grouping.
- "Posts in the last 24 hours" criteria added to games.

1.0.5 - Bug fixes and feature release.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Added search on/off toggle function in Admin CP.
- Opera compatibility fixed.
- Welcome message now an Admin CP option.
- Use "Miniature Mode" By Default option added to the Admin CP.
- New AJAX based favorites system.
- Hooks in place for vbBux integration (coming soon from CMX_CMGSCCC)
- Per-category on/off settings.
- Default user settings for challenges and notifications.
- Database error when pruning a user?s scores with table prefix.
- Database error when viewing distinct high scores when the table is empty.
- Notification bug fixes, users should now be notified based on their Arcade settings.
- Timestamp bug fixed for news and events.

1.0.6 - Bug fixes.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Fixed a bug where unregistered users could challenge people in the Arcade.
- "Wipe All Scores" tool added.
- "arcade_award_bit" template is now cached correctly.

1.0.7 - Features and Bug fixes.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Guests can now play games, but their scores aren't recorded. If a guest plays a game, they're asked to register if they want their score recorded afterwards.
- Admins can now wipe all scores through the Admin CP.
- Admins now have a tool to enable challenges by default for all users.
- Usergroup requirements for games are now in place.
- Admins can now choose to flip the columns and have the smaller panel on the left, with the larger content area on the right.
- News & Events - now entries contain links to games.
- Numerous bug fixes.
- Mass category changer for altering game categories en masse.
- High score rebuilder in the Admin CP.

=================================
Branding Free
=================================

All v3 Arcade installations carry and require a small "v3 Arcade" logo in the footer, as well as the text "Powered by v3 Arcade" which links to http:www.v3arcade.com. For information on legally removing the branding, please visit www.v3arcade.com.

=================================
www.v3arcade.com
=================================

If you're looking for more games, add-ons, support, tutorials, or anything Arcade related - www.v3arcade.com is the place to go.

Bug tracking: http://www.v3arcade.com/forums/vbugs.php

You can contact me directly at john@v3arcade.com for support.

=================================
Many thanks to...
=================================

- All branding-free customers and donors, for supporting the project.
- Oblivion Knight, for his work on the forums and great add-ons.
- Snowy, for his work on the forums.
- Andreas a.k.a. KirbyDE, for his vB 3.5 tutorials.

=================================
Copyright
=================================

All code in distributed in this zip is Copyright ?2005 John Warwick, with the following exceptions:
class_tar.php - Credits within.
All Actionscript code within the included .swf files, unless otherwise noted.

John · #62 11-27-2005, 12:00 PM

Oh, got it.

Find:

Code:

$challenges = $db->query_read("SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM " . TABLE_PREFIX . "arcade_challenges

Replace with

Code:

$challenges = $db->query_read("SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM " . TABLE_PREFIX . "arcade_challenges AS arcade_challenges

Blam Forumz · #63 11-27-2005, 12:01 PM

I get this when I Try to runt he arcadeupdate.php:

http://www.blamforums.com/forum/arcadeupdate.php

Snake · #64 11-27-2005, 12:01 PM

Thanks man!

Question. I wonder why you have changed your mind and made the arcade as a free product?

Supes · #65 11-27-2005, 12:02 PM

Trying to import the plugin I get this error :

Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE usergroup ADD arcadepermissions INT( 10 ) UNSIGNED NOT NULL;

MySQL Error : Duplicate column name 'arcadepermissions'
Error Number : 1060
Date : Sunday, November 27th 2005 @ 09:00:49 AM
Script : http://www.emuhub.com/forums/admincp/plugin.php
Referrer : http://www.emuhub.com/forums/admincp...?do=productadd
IP Address : **.**.**.***
Username : ******
Classname : vb_database

tidy_boy · #66 11-27-2005, 12:02 PM

Quote:

Originally Posted by John

Oh, got it.

Find:

Code:

$challenges = $db->query_read("SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM " . TABLE_PREFIX . "arcade_challenges

Replace with

Code:

$challenges = $db->query_read("SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM " . TABLE_PREFIX . "arcade_challenges AS arcade_challenges

Where do i look for this?

Trosun · #67 11-27-2005, 12:04 PM

Quote:

Originally Posted by John

Oh, got it.

Find:

Code:

$challenges = $db->query_read("SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM " . TABLE_PREFIX . "arcade_challenges

Replace with

Code:

$challenges = $db->query_read("SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM " . TABLE_PREFIX . "arcade_challenges AS arcade_challenges

Still getting the

Code:

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.title FROM vb35_arcade_challenges
	LEFT JOIN vb35_user AS touser ON (touser.userid=arcade_challenges.touserid)
	LEFT JOIN vb35_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
	LEFT JOIN vb35_arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
	WHERE (status=0 AND touserid=1) OR (status=1 AND touserid=1 AND tosessionid=0) OR (status=1 AND fromuserid=1 AND fromsessionid=0);

MySQL Error  : Unknown table 'arcade_challenges'
Error Number : 1051

Quote:

Originally Posted by tidy_boy

Where do i look for this?

arcade.php

John · #68 11-27-2005, 12:04 PM

Quote:

Originally Posted by tidy_boy

Where do i look for this?

lol, sorry - I forgot to say, arcade.php.

Zip updated. (You can just download it again and overwrite arcade.php)

jaffaman · #69 11-27-2005, 12:04 PM

This is what i have got in my config m8

PHP Code:


			
TABLE PREFIX ******

    //    Prefix that your vBulletin tables have in the database.

$config['Database']['tableprefix'] = 'vb3_';



    /

Impreza04 · #70 11-27-2005, 12:04 PM

Tried the replacment line and get the same error

PHP Code:


			
Database error in vBulletin 3.5.1:



Invalid SQL:

SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.title FROM vB_arcade_challenges

    LEFT JOIN vB_user AS touser ON (touser.userid=arcade_challenges.touserid)

    LEFT JOIN vB_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)

    LEFT JOIN vB_arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)

    WHERE (status=0 AND touserid=1) OR (status=1 AND touserid=1 AND tosessionid=0) OR (status=1 AND fromuserid=1 AND fromsessionid=0);



MySQL Error  : Unknown table 'arcade_challenges'

Error Number : 1051

Date         : Sunday, November 27th 2005 @ 02:04:13 PM

Script       : http://www.playstation-racing.co.uk/forum/arcade.php?

Referrer     : http://www.playstation-racing.co.uk/forum/index.php

Chris M · #71 11-27-2005, 12:04 PM

Quote:

Originally Posted by Aftermath

Thanks man!

Question. I wonder why you have changed your mind and made the arcade as a free product?

a.) Most likely to compete with IPBProArcade - As a paid product it wouldn't do as well against it's free alternative...
b.) I doubt John "needs" the money - I imagine he will do just fine with the $60 branding free and premium forum access on v3arcade.com
c.) If he wants to get vBulletin.org users feedback, usage and whatnot, he needs it to be free to do so

Chris

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06019 seconds Memory Usage 2,345KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (7)bbcode_code (2)bbcode_php (5)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!