Major Additions - [DBTech] vBArcade v2 (vB5)

vBArcade is a professional modular flash arcade game system. Easily converts your old favorites, and finds thousands more with the click of a button.

This new modern arcade uses AJAX to enhance the playing experience and encourage users to compete both locally and globally among participating sites. Streamlined import and editing managers put games from mochi, v3arcade, ibproarcade and more into your arcade with ease. Fine-tuned access and scoring tools allow you to keep competition fresh and exciting, as well as social network tools to bring new users in to your site!

-------------------------------------------------------------------------------------------

If you like this mod please hit the button to the right ---->

Please remember to click the, button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications.

We appreciate the support!

-------------------------------------------------------------------------------------------

Documentation
https://www.dragonbyte-tech.com/docs/vbarcade

-------------------------------------------------------------------------------------------

Major Features:

Modular Game Handling: Currently supports games from pnflash, ibproarcade, v3arcade, mochi, (plus armor, kongregate, flashgamedistribution, spilgames in pro) and more can be added with a single file.

Access and Score Tools: Set exactly when users can play certain games, and for how often. Archive extra or old scores to allow room for new champions.

Social and Global: Not only can games be sent to all the major social networks, but participating sites can rank their scores together and display champions everywhere.

Beautiful Modern Design: Streamlined and professional, using AJAX to enhance and simplify the playing experience, like searching, replays, full screen and cinema mode, and category tabs.

Fast Paced Competition: Ultimate tournament system that rewards fast players while mitigating no-shows, allowing all your matches to finish strong, and everyone has fun.

Lite

Friendly Challenges

• Automatic 1 round tournament of 2 players, with preset config
• Initiated from simple username prompt, while playing a game
• Can disable certain games from eligibility
• Auto-pruned if either player declines invitation

"Most Trophies" Module

• Lists top 3 players and how many trophies they hold
• Displays avatar and link to member profile
• Displays username if avatars are turned off
• "Show Avatars" module configuration
• Respects user's choice to hide avatars if applicable

"Longest Players" Module

• Lists top 3 players and how long they've played
• Displays avatar and link to member profile
• Displays username if avatars are turned off
• "Show Avatars" module configuration
• "Maximum Players to Show" module configuration
• Respects user's choice to hide avatars if applicable

"You Might Like" Module

• Displays a semi-random game similar to existing one
• Fetches random game from the same category if one exists
• "Show Game Icon" module configuration

Global Scoring Integration

• Synchronises scoring with the Global Scoring system
• Displays Global Champion if enabled

Commenting

• Add / Edit comments for your scores on games
• AJAX-powered

Score Alerts

• Receive Email and/or PM notifications when your score is beaten
• Respects vBulletin's notification settings
• Contains link to the game for quick play

Score Tracking

• latest and champion scores
• most winners and longest players
• average scores, plays and playtime
• yourself and locally
• local rankings

General / Other

• Modern streamlined appearance with AJAX for replay and searching
• Tweet, Like, Pin, or +1 a game
• Easy game resizing
• Ajax ratings
• Set descriptions, instructions, controls, keywords - even authors and copyrights
• Assign games to multiple categories - with icons descriptions
• Manually or one-button mass install games from any source
• existing arcade installation (plus scores and settings): ibProArcade, v3 Arcade
• package upload or ftp directory: pnFlash, ibProArcade v3 Arcade, Mochi
• featured games feed: Mochi
• Obtain local scores from supported APIs: ibProArcade, v3 Arcade, pnFlash, Mochi
• Use time played as backup score when unsupported
• Retrieve scores from global network of participating sites
• See global champions with links
• Automatically archive old or duplicate scores

Additional Features (Pro)

Tournaments

• Any local scoring game, with unique titles and descriptions
• Shown as a detailed horizontal tree, while playing the game
• Auto-prune tournaments that don't reach minimum players
• Convert related settings from other arcades
• Invite/Reminder Email/PM alerts, with notifications
• Invite specific users and/or allow specific usergroups to join
• Optionally auto-confirm all invited players to begin immediately
• Create recurring tournaments and optionally rematch players
• Optional privacy hides tournaments from nonparticipants
• Track all matches, with results and standings, from admincp
• Easily search, sort, begin, clone, mass delete from admincp
• Optionally disallow practicing a game a player is competing in

Tournament Matches

• Each tournament sets number of play attempts per match
• Active match highlighted, with clear status messages
• Playing all attempts optional, can be manually forfeit/completed
• Enforced time limit per match, or automatically forfeit/completed
• Notifications throughout, or optional reminder Email/PM alert
• Remaining attempts shown with live countdown for time limit
• Select between best, latest, or average attempt as match score
• Optionally hide scores until match is completed
• Match ties broken by first player who reached that score
• Replays automatically switch to the relevant match with AJAX
• Random player chosen to advance in a double forfeit
• Fast players can advance to future rounds and pair up early
• Optionally count tournament scores towards regular leaderboards

Group

• vBArcade exclusive round-robin format
• Every player matches every other player once
• Player with the best win record at the end declared champion
• Supports any number of players, including odd
• Begins at end of tournament countdown, if minimum is met
• Players paired sequentially, then randomly with unplayed players
• Players can move to new opponent even if match not decided

Knockout

• Familiar multi-round format
• Players pair up, winner of each match advances
• Winner of the final round declared champion
• Currently available up to 6 rounds (64 players)
• Begins immediately on finally required player joining
• Players who win their match can play next match prior to pairing

Score Alerts

• Automatically create a new thread or post on highscore
• Uses vBulletin APIs to insert the content
• Works with vBulletin features like commenting

Category Passwords

• Set passwords to your categories
• AJAX input password before game list loads
• No reloads necessary

General / Other

• Submit your scores to the global network for global display
• Play games from Spil Games, FlashGameDistribution, Armor and Kongregate
• Get local scoring support from GamerSafe games
• Show off the legacy champion even if you archived all scores
• Cinema mode darkens the screen while you play
• Mark games on your personal favorites list
• Retrieve and display global stats to compare
• Get all of your scores ranked globally, with function to sync local scores

Features Still Missing (Lite)

General / Other

• post your score to your Facebook wall
  FB integration with vB5 isn't 100% complete yet, this will be re-examined when that time comes.
• Show off your trophy collection in your postbit
  The vB5 postbit isn't designed to be as cluttered as the vB4 postbit can be, so this will be on the shelf for the time being.

-------------------------------------------------------------------------------------------
This mod displays a copyright notification in the footer of all pages which includes:

• 1 Link to DragonByte Technologies homepage
• 1 Link to Product Description page of this modification

[PrestonM]

I assume this is dead now? No clue where to get the HTML5 games spoke of. I assume they install the same as the old flash games used to? Anyone have a link where to download the HTML5 games from or already have that can be purchased maybe?

[Ashlar217]

Try here for games: https://next-level-arcade.com/forum.php

The owner is very cool, and you can download both flash and html 5 games.

The problem with this mod in it's current state is that first, the scoring doesn't work. but Stannger from the above website helped get it working. There are still other issues, but it is possible to get this working on latest version of vb5.

[TheDigitalCouch]

You might be able to get some of these to work.
https://www.edopedia.com/blog/open-s...ascript-games/

They are all Open Source.

[Gizmo99]

Hi Guys

tried to install this and it fails on and traced error to

CREATE TABLE IF NOT EXISTS `dbtech_vbarcade_favorite` ( `gameid` varchar(255) NOT NULL, `userid` int(10) unsigned NOT NULL DEFAULT '0', `timestamp` int(10) unsigned NOT NULL DEFAULT '0', UNIQUE KEY `gameid` (`gameid`,`userid`) ) ENGINE=MyISAM

Give the error

#1071 - Specified key was too long; max key length is 1000 bytes

The code in 100.php

self::$db->query_write("
	CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "dbtech_vbarcade_favorite`
	(
		`gameid` varchar(255) NOT NULL,
		`userid` int(10) unsigned NOT NULL DEFAULT '0',
		`timestamp` int(10) unsigned NOT NULL DEFAULT '0',
		UNIQUE KEY `gameid` (`gameid`,`userid`)
	) ENGINE=MyISAM
");
self::report('Created Table', 'dbtech_vbarcade_favorite');

Trace

Exception trace:
## phar:///var/www/core/vb/vb.phar/database.php(1204) Exception Thrown 
#0 phar:///var/www/core/vb/vb.phar/database/mysqli.php(236): vB_Database->halt()
#1 phar:///var/www/core/vb/vb.phar/database.php(587): vB_Database_MySQLi->execute_query()
#2 /var/www/vhosts/core/packages/dbtechvbarcade/install/100.php(71): vB_Database->query_write()
#3 /var/www/vhosts/core/packages/dbtechvbarcade/class_install.php(120): require_once('/var/www/vhosts...')
#4 /var/www/vhosts/core/includes/adminfunctions_product.php(947) : eval()'d code(2): DBTech_Install::install()
#5 /var/www/vhosts/core/includes/adminfunctions_product.php(947): eval()
#6 /var/www/vhosts/core/admincp/product.php(1215): install_product()
#7 /var/www/vhosts/includes/api/interface/collapsed.php(147): require_once('/var/www/vhosts...')
#8 /var/www/vhosts/includes/vb5/frontend/controller/relay.php(33): Api_Interface_Collapsed->relay()
#9 /var/www/vhosts/index.php(69): vB5_Frontend_Controller_Relay->admincp()
#10 {main}

Any ideas

[jeremystcyr69]

has anyone solved the Arcade install error at all yet?

[madace06]

SO GOT THE DATABSE RUNNING AND INSTALLED FOR V5.7.5 JUST HAVING FEW FRONT END ISSUES BUT HOPE FULL GET THERE

HERE IS THE DATABASE CODE USED I CHANGED IN CORE/PACKAGES/INSTALL/100.PHP

JUST COPY AND PAST IN TEXT FILE SAY AS 100.PHP UPLOAD AND RUN

<?php
// New Tables

self::$db->query_write("
	CREATE TABLE IF NOT EXISTS `dbtech_vbarcade_access`
	(
		`accessid` int(10) unsigned NOT NULL AUTO_INCREMENT,
		`enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
		`usergroups` text NOT NULL,
		`games` text NOT NULL,
		`displayorder` int(10) unsigned NOT NULL DEFAULT '10',
		`important` tinyint(1) unsigned NOT NULL DEFAULT '0',
		`default` tinyint(1) unsigned NOT NULL DEFAULT '0',
		`timespan` int(10) unsigned NOT NULL DEFAULT '0',
		`mintime` int(10) unsigned NOT NULL DEFAULT '0',
		`minposts` int(10) unsigned NOT NULL DEFAULT '0',
		`avgposts` double unsigned NOT NULL DEFAULT '0',
		`lastposts` int(10) unsigned NOT NULL DEFAULT '0',
		`minrep` int(10) unsigned NOT NULL DEFAULT '0',
		`earned` tinyint(1) unsigned NOT NULL DEFAULT '0',
		`maxplays` int(10) unsigned NOT NULL DEFAULT '0',
		`punish` tinyint(1) unsigned NOT NULL DEFAULT '0',
		PRIMARY KEY (`accessid`)
	) ENGINE=MyISAM
");
self::report('Created Table', 'dbtech_vbarcade_access');

self::$db->query_write("
	CREATE TABLE IF NOT EXISTS `dbtech_vbarcade_category`
	(
		`categoryid` int(10) unsigned NOT NULL AUTO_INCREMENT,
		`enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
		`title` varchar(255) NOT NULL,
		`displayorder` int(10) unsigned NOT NULL DEFAULT '10',
		`password` varchar(255) NOT NULL DEFAULT '',
		`usergroups` text NOT NULL,
		`icon` varchar(255) NOT NULL DEFAULT '',
		`description` text NOT NULL,
		PRIMARY KEY (`categoryid`)
	) ENGINE=MyISAM
");
self::report('Created Table', 'dbtech_vbarcade_category');

self::$db->query_write("
	CREATE TABLE IF NOT EXISTS `dbtech_vbarcade_data`
	(
		`gameid` varchar(255) NOT NULL,
		`local_winner` int(10) unsigned NOT NULL DEFAULT '0',
		`global_user` varchar(255) NOT NULL DEFAULT '',
		`global_link` varchar(255) NOT NULL DEFAULT '',
		`global_score` double NOT NULL DEFAULT '0',
		`local_plays` int(10) unsigned NOT NULL DEFAULT '0',
		`local_avgscore` double NOT NULL DEFAULT '0',
		`local_timespent` int(10) unsigned NOT NULL DEFAULT '0',
		`global_plays` int(10) unsigned NOT NULL DEFAULT '0',
		`global_avgscore` double NOT NULL DEFAULT '0',
		`global_timespent` int(10) unsigned NOT NULL DEFAULT '0',
		`ratings` int(10) unsigned NOT NULL DEFAULT '0',
		`avgrating` double unsigned NOT NULL DEFAULT '0',
		`favorites` int(10) unsigned NOT NULL DEFAULT '0',
		`comments` int(10) unsigned NOT NULL DEFAULT '0',
		`history_winner` int(10) unsigned NOT NULL DEFAULT '0',
		`commentthreadid` int(10) unsigned NOT NULL DEFAULT '0',
		`reportthreadid` int(10) unsigned NOT NULL DEFAULT '0',
		PRIMARY KEY (`gameid`)
	) ENGINE=InnoDB
");
self::report('Created Table', 'dbtech_vbarcade_data');

self::$db->query_write("
	CREATE TABLE IF NOT EXISTS `dbtech_vbarcade_favorite`
	(
		`gameid` varchar(255) NOT NULL,
		`userid` int(10) unsigned NOT NULL DEFAULT '0',
		`timestamp` int(10) unsigned NOT NULL DEFAULT '0',
		UNIQUE KEY `gameid` (`gameid`,`userid`)
	) ENGINE=MyISAM
");
self::report('Created Table', 'dbtech_vbarcade_favorite');

self::$db->query_write("
	CREATE TABLE IF NOT EXISTS `dbtech_vbarcade_game`
	(
		`gameid` varchar(255) NOT NULL,
		`enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
		`displayorder` int(10) unsigned NOT NULL DEFAULT '10',
		`title` varchar(255) NOT NULL,
		`description` text NOT NULL,
		`instruction` text NOT NULL,
		`controls` text NOT NULL,
		`keywords` text NOT NULL,
		`author` varchar(255) NOT NULL DEFAULT '',
		`copyright` varchar(255) NOT NULL DEFAULT '',
		`timestamp` int(10) unsigned NOT NULL DEFAULT '0',
		`width` double unsigned NOT NULL,
		`height` double unsigned NOT NULL,
		`decimals` tinyint(2) NOT NULL DEFAULT '0',
		`scoring` tinyint(1) unsigned NOT NULL DEFAULT '1',
		`tourns` tinyint(1) unsigned NOT NULL DEFAULT '1',
		`system` char(3) NOT NULL,
		`license` text NOT NULL,
		`flashfile` varchar(255) NOT NULL,
		`icon` varchar(255) NOT NULL,
		`badge` varchar(255) NOT NULL,
		PRIMARY KEY (`gameid`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
");
self::report('Created Table', 'dbtech_vbarcade_game');

self::$db->query_write("
	CREATE TABLE `dbtech_vbarcade_match`
	(
		`matchid` int(10) unsigned NOT NULL AUTO_INCREMENT,
		`tournid` int(10) unsigned NOT NULL DEFAULT '0',
		`userid` int(10) unsigned NOT NULL DEFAULT '0',
		`against` int(10) unsigned NOT NULL DEFAULT '0',
		`score` double NOT NULL DEFAULT '0',
		`timestamp` int(10) unsigned NOT NULL DEFAULT '0',
		`round` tinyint(2) unsigned NOT NULL DEFAULT '1',
		`attempt` tinyint(2) unsigned NOT NULL DEFAULT '0',
		`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
		PRIMARY KEY (`matchid`)
	) ENGINE=MyISAM
");
self::report('Created Table', 'dbtech_vbarcade_match');

self::$db->query_write("
	CREATE TABLE IF NOT EXISTS `dbtech_vbarcade_rating`
	(
		`gameid` varchar(255) NOT NULL,
		`userid` int(10) unsigned NOT NULL DEFAULT '0',
		`timestamp` int(10) unsigned NOT NULL DEFAULT '0',
		`rating` tinyint(1) unsigned NOT NULL DEFAULT '0',
		UNIQUE KEY `gameid` (`gameid`,`userid`)
	) ENGINE=MyISAM
");
self::report('Created Table', 'dbtech_vbarcade_rating');

self::$db->query_write("
	CREATE TABLE IF NOT EXISTS `dbtech_vbarcade_relation`
	(
		`gameid` varchar(255) NOT NULL,
		`categoryid` int(10) unsigned NOT NULL DEFAULT '0',
		UNIQUE KEY `gameid` (`gameid`,`categoryid`)
	) ENGINE=MyISAM
");
self::report('Created Table', 'dbtech_vbarcade_relation');

self::$db->query_write("
	CREATE TABLE IF NOT EXISTS `dbtech_vbarcade_session`
	(
		`sessionid` int(10) unsigned NOT NULL AUTO_INCREMENT,
		`global` int(10) unsigned NOT NULL DEFAULT '0',
		`gameid` varchar(255) NOT NULL,
		`label` varchar(255) NOT NULL DEFAULT '',
		`userid` int(10) unsigned NOT NULL DEFAULT '0',
		`ipaddress` char(15) NOT NULL DEFAULT '',
		`timestart` int(10) unsigned NOT NULL DEFAULT '0',
		`timefinish` int(10) unsigned NOT NULL DEFAULT '0',
		`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
		`record` tinyint(1) unsigned NOT NULL DEFAULT '0',
		`score` double NOT NULL DEFAULT '0',
		`verify` varchar(255) NOT NULL,
		`chain` varchar(255) NOT NULL DEFAULT '',
		`comment` varchar(255) NOT NULL DEFAULT '',
		`matchid` int(10) unsigned NOT NULL DEFAULT '0',
		PRIMARY KEY (`sessionid`)
	) ENGINE=InnoDB
");
self::report('Created Table', 'dbtech_vbarcade_session');

self::$db->query_write("
	CREATE TABLE IF NOT EXISTS `dbtech_vbarcade_tourn`
	(
		`tournid` int(10) unsigned NOT NULL AUTO_INCREMENT,
		`gameid` varchar(255) NOT NULL,
		`title` varchar(255) NOT NULL,
		`description` text NOT NULL,
		`timestamp` int(10) unsigned NOT NULL DEFAULT '0',
		`recurring` tinyint(1) unsigned NOT NULL DEFAULT '0',
		`private` tinyint(1) unsigned NOT NULL DEFAULT '0',
		`usergroups` text NOT NULL,
		`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
		`winner` int(10) unsigned NOT NULL DEFAULT '0',
		`rounds` tinyint(2) unsigned NOT NULL DEFAULT '1',
		`attempts` tinyint(2) unsigned NOT NULL DEFAULT '1',
		PRIMARY KEY (`tournid`)
	) ENGINE=MyISAM
");
self::report('Created Table', 'dbtech_vbarcade_tourn');


// Populate tables
self::$db->query_write("
	REPLACE INTO `dbtech_vbarcade_access`
		(`accessid`, `enabled`, `usergroups`, `games`, `displayorder`, `important`, `default`, `timespan`, `mintime`, `minposts`, `avgposts`, `lastposts`, `minrep`, `earned`, `maxplays`, `punish`)
	VALUES 
		(1, 1, '', '', 10, 0, 4, 86400, 0, 0, 0, 0, 0, 4, 0, 3)
");
self::report('Populated Table', 'dbtech_vbarcade_access');

self::$db->query_write("
	INSERT INTO `dbtech_vbarcade_category` 
		(`categoryid`, `enabled`, `title`, `displayorder`, `password`, `usergroups`)
	VALUES 
		(1, 1, 'Puzzle', 10, '', ''),
		(2, 1, 'Action', 10, '', ''),
		(3, 1, 'Retro', 10, '', ''),
		(4, 1, 'Sports', 10, '', ''),
		(5, 1, 'Shooter', 10, '', ''),
		(6, 1, 'RPG', 10, '', ''),
		(7, 1, 'Misc', 10, '', '')
");
self::report('Populated Table', 'dbtech_vbarcade_access');


// Add the administrator field
if (self::$db_alter->fetch_table_info('administrator'))
{
	self::$db_alter->add_field(array(
		'name'       => 'arcadepermissions',
		'type'       => 'int',
		'length'     => '10',
		'attributes' => 'unsigned',
		'null'       => false,	// True = NULL, false = NOT NULL
		'default'    => '0'
	));
	self::report('Altered Table', 'administrator');
}

// Add the user field
if (self::$db_alter->fetch_table_info('user'))
{
	self::$db_alter->add_field(array(
		'name'       => 'dbtech_vbarcade_matchcount',
		'type'       => 'int',
		'length'     => '10',
		'attributes' => 'unsigned',
		'null'       => false,	// True = NULL, false = NOT NULL
		'default'    => '0'
	));
	self::report('Altered Table', 'user');
}

[jeremystcyr69]

Which file did you use on here with this fix, as i am still seeing errors.