vb.org Archive

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)

danielmorashov 04-04-2021 03:38 AM

Quote:

Originally Posted by yilmaz (Post 2606800)
I made some changes.
Setup was successful.
But since there is no flash support, the installed games do not happen.

https://vborg.vbsupport.ru/attachmen...hmentid=158761

Thank you so much for checking the system it's a shame there's no FLASH support in browsers I'm waiting for more updates

stangger5 01-21-2022 11:52 AM

Does anyone still have this arcade installed for me to test html5 games with?

I have html5 games working with [DBTech] vBArcade v2 (vB4).

yilmaz 03-27-2022 06:05 PM

1 Attachment(s)
I installed it for testing purposes.
I was able to run it on VB 5.6.7 and PHP 8.0.17.
The rest is up to you as there is no browser to find games and flash support.

boss22 03-27-2022 08:22 PM

Quote:

Originally Posted by yilmaz (Post 2608368)
I installed it for testing purposes.
I was able to run it on VB 5.6.7 and PHP 8.0.17.
The rest is up to you as there is no browser to find games and flash support.

You can test games with flash - use ruffle - will try

boss22 03-27-2022 09:02 PM

An unexpected error was returned: 'Call to undefined function fetch_word_wrapped_string()'

on arcade home page - no games show - installed 4 games

yilmaz 03-27-2022 09:57 PM

Quote:

Originally Posted by boss22 (Post 2608370)
An unexpected error was returned: 'Call to undefined function fetch_word_wrapped_string()'

on arcade home page - no games show - installed 4 games

https://vborg.vbsupport.ru/showpost....&postcount=123

I updated the file, just upload it to ftp.

boss22 03-29-2022 02:25 PM

Playing games (flash) were ok - but problem are record scores !

stangger5 03-29-2022 05:08 PM

This arcade was never made for v32 flash games.
v32 games need the gamedate folder and the files per game inside it,for the games to save scores.

I have fixed this issue with the vb4 version.

html5 games will work also.

boss22 03-29-2022 06:04 PM

Had never åroblem with v32 flash games on vb4 [DBTech] vBArcade v2

now on vb5 have problem with scores

Ashlar217 04-21-2022 03:18 PM

Confirmed clean install on 5.6.7

Now to find working games

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 12:54 PM.

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.01477 seconds
  • Memory Usage 1,835KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (17)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