Add-On Releases - v3 Arcade - Games Arcade System for 3.6.0

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.

[Edward S]

Even with the PLUG-IN system, this baby just wouldn't uninstall.. I wound up manually adding and changing and running the uninstall (from Plugin) over and over again... Finally got it removed from my system.

The reason for the CREATE TABLE statements in the code below is that the uninstaller would drop those tables before erroring out on the "drop arcadepermissions" statements... So that when I put the data in (using the ALTER TABLE statement).. the uninstaller would then croak on a "Table not found" error.. So, as I then had to go back and put the table back in, round and round and round she went... Finally got the right sequence and the uninstaller removed (safely I hope) what it wanted and finished completely..
All I can say is WHAT A MESS! - Here's the SQL statements I had to put in pieces at a time as I ran the uninstaller...

ALTER TABLE usergroup ADD arcadepermissions INT( 10 ) UNSIGNED NOT NULL;
ALTER TABLE user ADD arcadeoptions INT( 10 ) UNSIGNED NOT NULL;
ALTER TABLE user ADD challengecache INT( 10 ) UNSIGNED NOT NULL;

CREATE TABLE arcade_categories (
  categoryid int(10) unsigned NOT NULL auto_increment,
  catname varchar(250) NOT NULL default '',
  displayorder int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (categoryid)
);

INSERT INTO arcade_categories VALUES (7,'Puzzle',1),(8,'Action',2),(3,'Retro',3),(4,'Sport',4),(5,'Shooters',5),(1,'Other',100),(2,'Favorites',101);

CREATE TABLE arcade_games (
  gameid int(11) unsigned NOT NULL auto_increment,
  shortname varchar(100) NOT NULL default '',
  title varchar(100) NOT NULL default '',
  description text NOT NULL,
  file varchar(100) NOT NULL default '',
  width smallint(4) unsigned NOT NULL default '550',
  height smallint(4) unsigned NOT NULL default '400',
  miniimage varchar(100) NOT NULL default '',
  stdimage varchar(100) NOT NULL default '',
  gamepermissions int(10) unsigned NOT NULL default '7',
  highscorerid int(10) unsigned NOT NULL default '0',
  highscore int(50) unsigned NOT NULL default '0',
  gamehash varchar(50) NOT NULL default '',
  categoryid int(10) unsigned NOT NULL default '1',
  timesplayed int(10) unsigned NOT NULL default '0',
  dateadded int(10) unsigned NOT NULL default '0',
  system tinyint(1) unsigned NOT NULL default '0',
  votepoints int(3) unsigned NOT NULL default '0',
  votecount int(6) unsigned NOT NULL default '0',
  sessioncount int(10) unsigned NOT NULL default '0',
  minpoststotal int(10) unsigned NOT NULL default '0',
  minpostsperday int(10) unsigned NOT NULL default '0',
  minreglength int(10) unsigned NOT NULL default '0',
  minrep int(10) NOT NULL default '0',
  PRIMARY KEY  (gameid)
);

INSERT INTO arcade_games VALUES (1,'snake','Snake','The mobile phone classic, \"Snake\" can now be played on your PC! Save your phone battery and play to get a high score on the leaderboard','snake.swf',360,300,'snake2.gif','snake1.gif',7,0,0,'',1,0,0,0,0,0,0,0,0,0,0),(2,'spaceinvaders','Space Invaders','Space Invaders is that game that started it all. Battle against aliens in a desperate attempt to save earth from total destruction.','spaceinvaders.swf',550,400,'spaceinvaders2.gif','spaceinvaders1.gif',7,0,0,'',1,0,0,0,0,0,0,0,0,0,0),(7,'asteroids','Asteroids','The arcade classic returns! Blast your way through asteroids and the occasional flying saucer to hit the top of the leaderboard.','asteroids.swf',500,375,'asteroids2.gif','asteroids1.gif',7,0,0,'',1,0,0,0,0,0,0,0,0,0,0),(5,'chopper','Chopper Challenge','Flying a helicopter through an obstacle course... Sounds dull? It\'s harder than it looks!','chopper.swf',400,300,'chopper2.gif','chopper1.gif',7,0,0,'',1,0,0,0,0,0,0,0,0,0,0),(6,'tetris','Tetris','A classic puzzle game that will keep you entertained for hours.','tetris.swf',382,380,'tetris2.gif','tetris1.gif',7,0,0,'',1,0,0,0,0,0,0,0,0,0,0);

ALTER TABLE arcade_games ADD isreverse INT( 10 ) UNSIGNED NOT NULL;

CREATE TABLE arcade_news (
  newsid int(10) unsigned NOT NULL auto_increment,
  newstext mediumtext NOT NULL,
  newstype varchar(20) NOT NULL default '',
  datestamp int(13) unsigned NOT NULL default '0',
  PRIMARY KEY  (newsid)
);

INSERT INTO arcade_news VALUES (1,'Arcade Installation Complete','auto', " . TIMENOW . ");

CREATE TABLE arcade_sessions (
  sessionid int(10) unsigned NOT NULL auto_increment,
  gameid int(10) unsigned NOT NULL default '0',
  gamename varchar(20) NOT NULL default '',
  userid int(7) unsigned NOT NULL default '0',
  start int(10) unsigned NOT NULL default '0',
  finish int(10) unsigned NOT NULL default '0',
  ping float(7,2) unsigned NOT NULL default '0.00',
  comment varchar(200) NOT NULL default '',
  valid tinyint(1) unsigned NOT NULL default '0',
  score int(50) unsigned NOT NULL default '0',
  sessiontype tinyint(1) unsigned NOT NULL default '1',
  challengeid int(15) unsigned NOT NULL default '0',
  PRIMARY KEY  (sessionid)
);

CREATE TABLE arcade_challenges (
  challengeid int(10) unsigned NOT NULL auto_increment,
  fromuserid int(10) unsigned NOT NULL default '0',
  touserid int(10) unsigned NOT NULL default '0',
  winnerid int(10) unsigned NOT NULL default '0',
  loserid int(10) unsigned NOT NULL default '0',
  gameid int(10) unsigned NOT NULL default '0',
  datestamp int(10) unsigned NOT NULL default '0',
  fromsessionid int(10) unsigned NOT NULL default '0',
  tosessionid int(10) unsigned NOT NULL default '0',
  fromscore float(15,3) unsigned NOT NULL default '0.000',
  toscore float(15,3) unsigned NOT NULL default '0.000',
  status tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (challengeid)
);

CREATE TABLE arcade_ratings (
  ratingid int(10) unsigned NOT NULL auto_increment,
  gameid int(10) unsigned NOT NULL default '0',
  userid int(10) unsigned NOT NULL default '0',
  rating int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (ratingid)
);

Why is it authors only worry about PUTTING the stuff into your database and really spend little time helping you remove it safely and properly?...

[coachjohns]

I get this error when I click on the Arcade in the navbar

error 404: File not found


The document you requested is not found.

What do I do to fix it?

[Neo_obs]

is it possible to hide the navbar link from users who are not allowed to use the arcade?

[CongTuDepTrai]

thanks a lot

[burratha]

Originally Posted by Neo_obs

is it possible to hide the navbar link from users who are not allowed to use the arcade?

ditto here, please. This is a long thread and if this can be answered without me having to pick through 87 pages I'd appreciate it.

Thanks in advance.

SH

[blablablabla]

installed a arcade V3 hack but i wanted to uninstall it... so i deleted all the changes i did in the templates and when i was gonna uninstall the plugin itself this msg showed up

it shows up when i try to read threads too

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT title,highscorerid,highscore,miniimage,gameid FROM amy_forumarcade_games WHERE highscorerid IS NOT NULL AND (gamepermissions & 2);

MySQL Error : Table 'amydiamond_org.amy_forumarcade_games' doesn't exist
Error Number : 1146
Date : Wednesday, March 8th 2006 @ 02:19:08 PM
Script : http://amydiamond.org/forum/showthread.php?t=5
Referrer : http://amydiamond.org/forum/forumdisplay.php?f=24
IP Address : 84.48.41.223
Username : Diamond
Classname : vb_database

[Treak]

i installled this and i keep getting the i do not have access to this and im the admin lol it also doesn't show up in my admin cp panel... but it shows up n the manage products thing.. any ideas..

[LuceGoo]

Is there a way of disabling the autopm people receive when someone beats your score?

[MrZeropage]

@Treak:
Did you upload the content of the /includes-Folder ?

@LuceGoo:
in v2.5.4+ each user can adjust the notification-settings in his Arcade-Settings
in the upcoming v2.5.5+ there is a global switch in AdminCP

[duplu]

Originally Posted by MrZeropage

@Treak:
Did you upload the content of the /includes-Folder ?

@LuceGoo:
in v2.5.4+ each user can adjust the notification-settings in his Arcade-Settings
in the upcoming v2.5.5+ there is a global switch in AdminCP

Oops wrong arcade Mr Zeropage!

@Treak - ensure you go into the usergroups in your admincp and update the settings so each usergroup can see and play the arcade. Yes, this even applies to admins