vb.org Archive
Page 14 of 14 « First 41213 14
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 5.x Products & Extensions (https://vborg.vbsupport.ru/forumdisplay.php?f=258)
-   -   Major Additions - [DBTech] vBArcade v2 (vB5) (https://vborg.vbsupport.ru/showthread.php?t=299200)

PrestonM 06-17-2022 02:52 PM
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 06-17-2022 09:19 PM
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 07-21-2022 04:16 PM
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 10-29-2022 02:35 PM
Hi Guys

tried to install this and it fails on and traced error to
Code:
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
Code:
#1071 - Specified key was too long; max key length is 1000 bytes

The code in 100.php
Code:
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
Code:
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 02-20-2023 02:51 AM
has anyone solved the Arcade install error at all yet?

madace06 09-27-2023 09:01 PM
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
Code:
<?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 10-05-2023 04:43 AM
Which file did you use on here with this fix, as i am still seeing errors.


All times are GMT. The time now is 07:53 AM.
Page 14 of 14 « First 41213 14
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01222 seconds
  • Memory Usage 1,815KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete