PDA

View Full Version : Add-On Releases - v3 Arcade - Games Arcade System for 3.6.0


Pages : [1] 2 3 4 5 6 7 8 9 10 11 12 13

John
27 Nov 2005, 13:09
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 (http://www.vbulletin.org/forum/showthread.php?t=137911)
=================================
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 (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 (http://www.v3arcade.com). For information on legally removing the branding, please visit www.v3arcade.com (http://www.v3arcade.com).


=================================
www.v3arcade.com (http://www.v3arcade.com)
=================================

If you're looking for more games, add-ons, support, tutorials, or anything Arcade related - www.v3arcade.com (http://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
27 Nov 2005, 13:12
Screenshot batch number 1. (Front end)

John
27 Nov 2005, 13:13
Screenshot batch number 2. (Front end)

BiReL41r
27 Nov 2005, 13:13
I've been waiting, can't wait. Gonna install right away! Thanks!

EDIT: Crap, didn't see that either, sorry!

John
27 Nov 2005, 13:16
Screenshot batch number 3. (www.v3arcade.com Game Store integration)

John
27 Nov 2005, 13:16
Screenshot batch number 4. (www.v3arcade.com Game Store integration)

John
27 Nov 2005, 13:17
Screenshot batch number 5. (Admin CP)

waza
27 Nov 2005, 13:20
Ok, here I go again:
Finally, thx man!

TJFweb
27 Nov 2005, 13:20
Woot First Install!

Edit: Oops... beaten by one guy :P

bing11
27 Nov 2005, 13:21
thank you

sensimilla
27 Nov 2005, 13:22
thanks alot!!! it been worth the time .. I love it keep up the good work!

plubius
27 Nov 2005, 13:22
At long last the wait is over. It is good to see this old hack with new life. Excellent work, John.

tidy_boy
27 Nov 2005, 13:22
hey john I have purchased the branding free ages ago so i will be upgrading. Do i just ftp all the files to my server and import the product but allow ovewrite

Cheers

John
27 Nov 2005, 13:23
hey john I have purchased the branding free ages ago so i will be upgrading. Do i just ftp all the files to my server and import the product but allow ovewrite

Cheers

Yep - just check the overwrite box when you import and it should be flawless. Worked nicely on v3arcade.com earlier on today.

Detomah
27 Nov 2005, 13:24
/me upgrades to full release.

Is it safe to use with all of O.K's 3.5.1 beta v3arcade addons still, or are they going to need rebuilding? (aimed at O.K. more than John)

Lizard King
27 Nov 2005, 13:26
I was still keeping my tables from vb3.0.x installation. Even i choosed overwrite i had the following 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 @ 08:24:30 AM
Script : http://*/admincp/plugin.php
Referrer : http://*/admincp/plugin.php?do=productadd
IP Address : -----
Username : *****
Classname : vb_database

John
27 Nov 2005, 13:27
* Detomah upgrades to full release.


Is it safe to use with all of O.K's arcade addons still, or are they going to need rebuilding? (aimed at O.K. more than John)

I've got a feeling that most of them will be okay.

Electronic Punk
27 Nov 2005, 13:28
Installed :)

John
27 Nov 2005, 13:28
I was still keeping my tables from vb3.0.x installation. Even i choosed overwrite i had the following error

As per the instructions:

If you're installing on a fresh copy of vBulletin 3.5, you don't need to worry about anything. If you're upgrading from an old 3.0.x version, please make sure that you've removed all old arcade templates from your vBulletin forum before you begin. Also, remove any fields containing the word "arcade" from the "user" and "usergroup" tables.

AshokForums.com
27 Nov 2005, 13:29
Thanks.. You rock john.. :)

Lizard King
27 Nov 2005, 13:29
John is there a quick query which i can get rid of all ex installations tables ?

Blam Forumz
27 Nov 2005, 13:31
Thanks!, Is there an importer to convert all scores and stuff from ibpro arcade to v3?

John
27 Nov 2005, 13:31
Thanks!, Is there an importer to convert all scores and stuff from ibpro arcade to v3?

Read the instructions, it says in there.

John
27 Nov 2005, 13:32
John is there a quick query which i can get rid of all ex installations tables ?

If you're upgrading and important, you don't want to do that. But you'll need to drop that field that's causing the installation to fail - use:

ALTER TABLE usergroup DROP arcadepermissions

tidy_boy
27 Nov 2005, 13:33
hey joh I get this error when I go to my arcade after upgrade

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM vb3_arcade_challenges
LEFT JOIN vb3_user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN vb3_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN vb3_arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error : Unknown table 'arcade_challenges'
Error Number : 1051
Date : Sunday, November 27th 2005 @ 02:32:05 PM
Script : http://www.harddanceaddict.net/forum/arcade.php
Referrer : http://www.harddanceaddict.net/forum/index.php
IP Address :
Username : tidy_boy
Classname : vb_database

John
27 Nov 2005, 13:34
hey joh I get this error when I go to my arcade after upgrade

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM vb3_arcade_challenges
LEFT JOIN vb3_user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN vb3_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN vb3_arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error : Unknown table 'arcade_challenges'
Error Number : 1051
Date : Sunday, November 27th 2005 @ 02:32:05 PM
Script : http://www.harddanceaddict.net/forum/arcade.php
Referrer : http://www.harddanceaddict.net/forum/index.php
IP Address :
Username : tidy_boy
Classname : vb_database

You did overwrite the product, didn't you?

tidy_boy
27 Nov 2005, 13:35
You did overwrite the product, didn't you?

yes I did mate

michaelbenson
27 Nov 2005, 13:35
Excellent, excellent, excellent!
Great update.

Zachariah
27 Nov 2005, 13:35
Wow man I was looking for 20 min on your site for the arcade.
- I gave up and found it here.


/me cries.

I'll shoot off a bunch of VBA CMPS after the install.
- Gimi few hours

John
27 Nov 2005, 13:35
That's weird. Run this:

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)
)

It should have done that as part of the product upgrade, though. :/

pyro.699
27 Nov 2005, 13:36
damit nvm /;

Error:
Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

got this when updating my usergroups

jaffaman
27 Nov 2005, 13:36
I am getting this as well i have updated from a beta version Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM vb3_arcade_challenges
LEFT JOIN vb3_user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN vb3_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN vb3_arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error : Unknown table 'arcade_challenges'
Error Number : 1051
Date : Sunday, November 27th 2005 @ 08:32:35 AM
Script : http://www.grimreapers.co.uk/vb/arcade.php
Referrer : http://www.grimreapers.co.uk/vb/arcade.php
IP Address : 212.159.109.203
Username : jaffaman
Classname : vb_database

tidy_boy
27 Nov 2005, 13:38
That's weird. Run this:

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)
)

It should have done that as part of the product upgrade, though. :/

That did not work still get an error

John
27 Nov 2005, 13:39
That did not work still get an error

The same error?

Lizard King
27 Nov 2005, 13:40
It worked out. Thanks for the awesome script John. I have one question. I still have all my games and i never dropped my tables. Is there any chance i can get these games working ? Because i dont have the game install scripts anymore.

tidy_boy
27 Nov 2005, 13:40
The same error?

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM vb3_arcade_challenges
LEFT JOIN vb3_user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN vb3_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN vb3_arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error : Unknown table 'arcade_challenges'
Error Number : 1051
Date : Sunday, November 27th 2005 @ 02:38:05 PM
Script : http://www.harddanceaddict.net/forum/arcade.php
Referrer : http://www.harddanceaddict.net/forum/index.php
IP Address :
Username : tidy_boy
Classname : vb_database

John
27 Nov 2005, 13:40
I am getting this as well i have updated from a beta version Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM vb3_arcade_challenges
LEFT JOIN vb3_user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN vb3_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN vb3_arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error : Unknown table 'arcade_challenges'
Error Number : 1051
Date : Sunday, November 27th 2005 @ 08:32:35 AM
Script : http://www.grimreapers.co.uk/vb/arcade.php
Referrer : http://www.grimreapers.co.uk/vb/arcade.php
IP Address : 212.159.109.203
Username : jaffaman
Classname : vb_database

And if you try to add the table manually, using that query I posted?

jaffaman
27 Nov 2005, 13:40
This is the error i get


An error occurred while attempting to execute your query. The following information was returned.
error number: 1050
error desc: Table 'arcade_challenges' already exists

John
27 Nov 2005, 13:41
It worked out. Thanks for the awesome script John. I have one question. I still have all my games and i never dropped my tables. Is there any chance i can get these games working ? Because i dont have the game install scripts anymore.

admincp/arcadeimport.php :)

Zachariah
27 Nov 2005, 13:42
It worked out. Thanks for the awesome script John. I have one question. I still have all my games and i never dropped my tables. Is there any chance i can get these games working ? Because i dont have the game install scripts anymore.

Ouch, usaly in the install script has size, keys to use, directions, and the $score key to use for that game.

tidy_boy
27 Nov 2005, 13:42
And if you try to add the table manually, using that query I posted?

I added it manually and it the command was successful but I still get that db error

John
27 Nov 2005, 13:43
This is the error i get


An error occurred while attempting to execute your query. The following information was returned.
error number: 1050
error desc: Table 'arcade_challenges' already exists

You already had an arcade_challenges table to begin with? :ermm:

The current version number you've got installed is 1.0.0, right? If so, run this:

DROP TABLE IF EXISTS arcade_challenges

And then this:

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)
)

John
27 Nov 2005, 13:43
Ouch, usaly in the install script has size, keys to use, directions, and the $score key to use for that game.

But if he never dropped the tables, he still has all that data.

Wordplay
27 Nov 2005, 13:44
anybody know where i can get a sudoku flash game from?

divided_by_fear
27 Nov 2005, 13:48
will the mods on your site still work.... the ones in the beta section... cause my leader board dont work... was just wondering if they will work with this?

bold
27 Nov 2005, 13:48
thanks!

tidy_boy
27 Nov 2005, 13:52
I added it manually and it the command was successful but I still get that db error

any ideas john on how to fix this please

jaffaman
27 Nov 2005, 13:54
same here sitll got the error

trackpads
27 Nov 2005, 13:54
Oh sooo sweet :) Thanks John!

Blam Forumz
27 Nov 2005, 13:54
The importer script, do i run it before or after i isntall v3arcade?

John
27 Nov 2005, 13:55
The importer script, do i run it before or after i isntall v3arcade?

After.

b6gm6n
27 Nov 2005, 13:55
Thanx John, wonderfull...

-b6

John
27 Nov 2005, 13:55
any ideas john on how to fix this please

Try this?

http://www.vbulletin.org/forum/showpost.php?p=832852&postcount=42

waza
27 Nov 2005, 13:56
John, The arcade is calling: arcade_challenges, but the table is forum_arcade_challenges so you probably forgot the ".TABLE_PREFIX." somewhere...

tidy_boy
27 Nov 2005, 13:56
Try this?

http://www.vbulletin.org/forum/showpost.php?p=832852&postcount=42


I tried that mate did not work

Edit there is no vb3_ before the arcade_challenges in my db mate

jaffaman
27 Nov 2005, 13:57
I have done that m8 and still gettint the error :( i dont have much luck doing this sort of thing lol

John
27 Nov 2005, 13:58
Are either of you using table prefixes?

tidy_boy
27 Nov 2005, 13:59
Are either of you using table prefixes?

my table prefix is vb3_

John
27 Nov 2005, 13:59
John, The arcade is calling: arcade_challenges, but the table is forum_arcade_challenges so you probably forgot the ".TABLE_PREFIX." somewhere...

I don't see any missing table prefixes ... :ermm:

Trosun
27 Nov 2005, 14:00
I'm also getting the:

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, 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=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error : Unknown table 'arcade_challenges'
Error Number : 1051
Date : Sunday, November 27th 2005 @ 02:58:07 PM
Classname : vb_database


I did a fresh install, I've tried reinstalling aswell.
I've tried dropping the table and running the query you submitted earlier.
I've tried with and without the table prefix. And i've checked that the table exists.

Again, i had nothing arcade'ish installed prior to this installation.

edit: I am using prefix

John
27 Nov 2005, 14:00
Oh, got it.

Find:
$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
$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
27 Nov 2005, 14:01
I get this when I Try to runt he arcadeupdate.php:


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

Snake
27 Nov 2005, 14:01
Thanks man! :D

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

Supes
27 Nov 2005, 14:02
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/plugin.php?do=productadd
IP Address : **.**.**.***
Username : ******
Classname : vb_database

tidy_boy
27 Nov 2005, 14:02
Oh, got it.

Find:
$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
$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
27 Nov 2005, 14:04
Oh, got it.

Find:
$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
$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

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

Where do i look for this?
arcade.php

John
27 Nov 2005, 14:04
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
27 Nov 2005, 14:04
This is what i have got in my config m8TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'vb3_';

/

Impreza04
27 Nov 2005, 14:04
Tried the replacment line and get the same error

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
27 Nov 2005, 14:04
Thanks man! :D

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

John
27 Nov 2005, 14:05
Still getting the

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


arcade.php

My mistake, I missed another one. ;)

John
27 Nov 2005, 14:06
Tried the replacment line and get the same error

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

Ok, one sec....

Abbas
27 Nov 2005, 14:08
Sorry for sounding a bit n00b but the second step in the instructions is:

2. Import product-v3arcade.xml as a new product

How and where do I import this in Vb as a new product?

-Abbas

John
27 Nov 2005, 14:09
Try the attached file?

tidy_boy
27 Nov 2005, 14:09
Sorry for sounding a bit n00b but the second step in the instructions is:

2. Import product-v3arcade.xml as a new product

How and where do I import this in Vb as a new product?

-Abbas


Log into your admincp > Plugin Systems > Manage Products > Add/Import Product

FleaBag
27 Nov 2005, 14:09
I'm a proud branding free user - glad this got to be posted here without any trouble! :)

uae
27 Nov 2005, 14:09
Thanks John :)

Snake
27 Nov 2005, 14:09
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

lol I guess that sounds about right. I am starting to like v3Arcade even more than ibPro. I'll give it a try and check it out now.

Impreza04
27 Nov 2005, 14:09
Perfection :)

John
27 Nov 2005, 14:10
Sorry for sounding a bit n00b but the second step in the instructions is:

2. Import product-v3arcade.xml as a new product

How and where do I import this in Vb as a new product?

-Abbas

"Manage Products", it's a link in the Admin CP on the left hand side. (Under "Plugin System")

tidy_boy
27 Nov 2005, 14:10
Try the attached file?


Thanks john it works woohooo you the man

blackpudding
27 Nov 2005, 14:10
john, re...

"please make sure that you've removed all old arcade templates from your vBulletin forum before you begin."

how do i do this? i have lots of arcade templates in the system but i can't see a way to delete them?

thanks

danb00
27 Nov 2005, 14:11
were can i find games for this?

Trosun
27 Nov 2005, 14:12
Try the attached file?

That worked!!
Thanks alot!

John
27 Nov 2005, 14:12
john, re...

"please make sure that you've removed all old arcade templates from your vBulletin forum before you begin."

how do i do this? i have lots of arcade templates in the system but i can't see a way to delete them?

thanks

I think the most straightforward way to do it would be to select each one and click "revert" - with a bit of luck it should disappear.

Abbas
27 Nov 2005, 14:15
Thanks!

Log into your admincp > Plugin Systems > Manage Products > Add/Import Product

blackpudding
27 Nov 2005, 14:17
thanks john

pyro.699
27 Nov 2005, 14:17
damit nvm /;

Error:
Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

got this when updating my usergroups


another thing, it sets all my arcade values, back to 0 (no) so if i set them all to 1 (yes), hit save, i get that error, and go back to look, and there all 0's (nos)

Supes
27 Nov 2005, 14:20
I installed it but when I try to access it I get this message:

you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

jaffaman
27 Nov 2005, 14:20
Thanks John that worked ;) all i got to do is sort it out working on our normal server not the 1 i am testing it on lol

John
27 Nov 2005, 14:21
another thing, it sets all my arcade values, back to 0 (no) so if i set them all to 1 (yes), hit save, i get that error, and go back to look, and there all 0's (nos)

I'll have to get back to you on that, I need to get some sleep now - I've only had 4/60 hours, I'm pretty exhausted. Back soon...

John
27 Nov 2005, 14:22
I installed it but when I try to access it I get this message:

you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Set your usergroup permissions?

nexus851
27 Nov 2005, 14:22
Would this work for 3.5.0??? also how can we get the MULTIPAYER games??? how many multiplayer do u got??? =D

MissKalunji
27 Nov 2005, 14:23
Can someone help me with an importer? imports games and scores?

---MAD---
27 Nov 2005, 14:23
* Detomah upgrades to full release.

Is it safe to use with all of O.K's 3.5.1 beta v3arcade addons still, or are they going to need rebuilding? (aimed at O.K. more than John)

WOOOOOO FINNALLY!

GOOD WORK JOHN

Reformed
27 Nov 2005, 14:23
I installed it but when I try to access it I get this message:

you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

You need to edit ur usergroup and set permissions, once you do that it should rebuild you bitfields, and then you should see the arcade permissions at the bottom.



Also thanks john, i love the way the games are so easy to install from your site.

Best hack ever.

nexialys
27 Nov 2005, 14:25
i just hope to see hundreds of games for this version, because ibPro version is not free... you have to pay to be able to download more than one game per day, this is not fair... even if they have a lot.

also, i think this wil lbe more supported, as it is built 100% from scratch for 3.5 with 3.5 code only...

yoyoyoyo
27 Nov 2005, 14:25
SO- in order to install the hack guests need to be able to view the arcade page? that sucks... guests can't get past the front door of my site, and that is the way I want it. I guess I will have to go with the other arcade system since I do not want guests to be able to access my arcade. Too bad- it looked like a good hack.

nexialys
27 Nov 2005, 14:26
Can someone help me with an importer? imports games and scores?read the docs, the importer is already included in the script...

nexialys
27 Nov 2005, 14:31
SO- in order to install the hack guests need to be able to view the arcade page? that sucks... guests can't get past the front door of my site, and that is the way I want it. I guess I will have to go with the other arcade system since I do not want guests to be able to access my arcade. Too bad- it looked like a good hack.
this is stupid logic...

just after include_once "./global.php"; add this: if (!$vbulletin->userinfo['userid'])
{
print_no_permission();
}this will prevent ALL non-logged-in users to be locked out

when you have a need, just request it instead of telling it's a non-avenue!

and btw, if your users have no access to the board, they will not have more access to the arcade, as it is driven by vBulletin authentication...

FleaBag
27 Nov 2005, 14:31
Ho John, in the ACP when clicking to remove all 0 scores I get the following error...
Database error in vBulletin 3.5.1:

Invalid SQL:
UPDATE arcade_games AS arcade_games SET sessioncount=4704, highscorerid=651, highscore=3295.000 WHERE gameid=1;

MySQL Error : You have an error in your SQL syntax near 'AS arcade_games SET sessioncount=4704, highscorerid=651, highscore=3295.000 WHER' at line 1
Error Number : 1064
Date : Sunday, November 27th 2005 @ 07:14:02 AM
Script : http://www.dragonninja.co.uk/admincp/arcadeadmin.php
Referrer : http://www.dragonninja.co.uk/admincp/arcadeadmin.php?do=scores
IP Address : 62.252.32.11
Username : FleaBag
Classname : vb_database

And also, when downloading a game from v3arcade.com I get the following errors.


Warning: fopen(/www/dragonninja/games/simon.swf): failed to open stream: Permission denied in /admin/arcadeadmin.php on line 225

Warning: fopen(/www/dragonninja/images/arcade/simon1.gif): failed to open stream: Permission denied in /admin/arcadeadmin.php on line 225

Warning: fopen(/www/dragonninja/images/arcade/simon2.gif): failed to open stream: Permission denied in /admin/arcadeadmin.php on line 225

Installing Simon

Obviously the game or the images are not installed and I now have a dud entry. Any idea why?

Any help is appreciated... Thanks. :)

Supes
27 Nov 2005, 14:32
Set your usergroup permissions?

I forgot abut that, it works now! :D

nexialys
27 Nov 2005, 14:33
Ho John, in the ACP when clicking to remove all 0 scores I get the following error...
Any help is appreciated... Thanks. :)
missing quotes in the SQL query!

divided_by_fear
27 Nov 2005, 14:34
when i click remove all high score it dont even remove them dont feel bad

waza
27 Nov 2005, 14:34
John, I can't verify my license on v3arcade.com.
I'm sure the url works and guest can see the arcade.

yoyoyoyo
27 Nov 2005, 14:36
this is stupid logic...

just after include_once "./global.php"; add this: if (!$vbulletin->userinfo['userid'])
{
print_no_permission();
}this will prevent ALL non-logged-in users to be locked out

when you have a need, just request it instead of telling it's a non-avenue!

and btw, if your users have no access to the board, they will not have more access to the arcade, as it is driven by vBulletin authentication...
I don't see how this will help... in order to verify the license the site checks to see if the arcade.php is viewable by guests - if it is not it will not verify your license. My USERS have access to the board - just not GUESTS.

tcs
27 Nov 2005, 14:36
Do you still have to open up your server or site with allow_url_fopen to get games?

Abbas
27 Nov 2005, 14:36
I tried installing and although the Product Added fine, when I try to access the arcade.php page, I get a "You dont have sufficient privelages" message from vBulletin and an email with the following error comes to my inbox:

MySQL Error : Unknown column 'language.phrasegroup_arcade' in 'field list'

Help would be appreciated!

Thanks
Abbas

FleaBag
27 Nov 2005, 14:37
missing quotes in the SQL query!

Ah, I suspected as much. So that's at least 1 bug hehe. :D Any idea what I replace nex?

RWDF1
27 Nov 2005, 14:38
You already had an arcade_challenges table to begin with? :ermm:

The current version number you've got installed is 1.0.0, right? If so, run this:

DROP TABLE IF EXISTS arcade_challenges

And then this:

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)
)


Ok this may sound stupid, but where do I run this? in my mySQL database, in the vB Cpannel?

Beav`
27 Nov 2005, 14:38
John, I've run an import of my old arcade (went fine), but is there any option to remove every score for every game? Or can I just empty the gamessession table?

Thanks

nexialys
27 Nov 2005, 14:38
I don't see how this will help... in order to verify the license the site checks to see if the arcade.php is viewable by guests - if it is not it will not verify your license.AH, you did not explain it well..

to verify the license, the script wait for you to click the button... at this moment, you just have to open the GUEST access for a minute, click the button on v3arcade.com, and after verif, just close the Guest access again...

that's what most of the people do...

btw, the licensing system is not obligatory, and you can download games anyway... this system is for announcements and some other gadgets not needed for you usually...

http://www.v3arcade.com/forums/showthread.php?t=369

Snake
27 Nov 2005, 14:38
Great just installed the arcade and its working fine.

www.metalgearforum.net/arcade.php :)

nexialys
27 Nov 2005, 14:40
Ok this may sound stupid, but where do I run this? in my mySQL database, in the vB Cpannel?
http://www.vbulletin.com/docs/html/maintenance_query

you have access to a complete Documentation center when you are licensed to vBulletin...

divided_by_fear
27 Nov 2005, 14:40
it dont remove scores from when you upgrade plus when i click on a username it dont bring me to profile it gives my a i-e error instead of taking them to the profile


http://img486.imageshack.us/img486/5471/arcade4nw.th.jpg (http://img486.imageshack.us/my.php?image=arcade4nw.jpg)

Snake
27 Nov 2005, 14:41
Whoops actually I am getting this error while accessing the arcade...

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.title FROM forum_arcade_challenges
LEFT JOIN forum_user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN forum_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN forum_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:40:41 PM
Script : http://www.metalgearforum.net/arcade.php
Referrer : http://www.metalgearforum.net/index.php
IP Address : 193.188.105.22
Username : Aftermath
Classname : vb_database

jaffaman
27 Nov 2005, 14:44
Whoops actually I am getting this error while accessing the arcade...

Quote:
Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.title FROM forum_arcade_challenges
LEFT JOIN forum_user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN forum_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN forum_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:40:41 PM
Script : http://www.metalgearforum.net/arcade.php
Referrer : http://www.metalgearforum.net/index.php
IP Address : 193.188.105.22
Username : Aftermath
Classname : vb_database

Try re downloading it and overwrite the arcade.php m8 i think there was a bug in the 1st 1

husain
27 Nov 2005, 14:44
cron file is missing from the package.

yoyoyoyo
27 Nov 2005, 14:44
AH, you did not explain it well..

to verify the license, the script wait for you to click the button... at this moment, you just have to open the GUEST access for a minute, click the button on v3arcade.com, and after verif, just close the Guest access again...

that's what most of the people do...

btw, the licensing system is not obligatory, and you can download games anyway... this system is for announcements and some other gadgets not needed for you usually...

http://www.v3arcade.com/forums/showthread.php?t=369Thanks for the clarification nex - did John recruit you to be the support for this thread while he sleeps? :) thanks much.

djlotus
27 Nov 2005, 14:45
Thnak you, from every single one of my forums members, and myself.

Lea Verou
27 Nov 2005, 14:45
I have to admit that you really have a good taste, it looks very beautiful :)

nexialys
27 Nov 2005, 14:47
Thanks for the clarification nex - did John recruit you to be the support for this thread while he sleeps? :) thanks much.
i hope he did, but no, i just had 5 minutes to give for support... i'm always like that... lol

ok, now, back to diapers and milk bottles...!!

Omranic
27 Nov 2005, 14:50
Very Very Good
Instaaled ... thankx john
Now translating I'm translating it to arabic & i'll send you a full translated release to post it there if you wish

your SolidSnake@GTI

nexus851
27 Nov 2005, 14:51
maybe i should wait another few hours before i download and install this product.. seems like in a few more hours all bugs will be fixed =)


BTW, what are bitfields? and do i need to rebuild them if never installed v3 arcade before????

RWDF1
27 Nov 2005, 14:53
it wont let me save my user permissions.

RWDF1
27 Nov 2005, 14:54
ok now I am getting this- Database error in vBulletin 3.5.0:

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

MySQL Error : Table 'db123940199.arcade_games' doesn't exist
Error Number : 1146
Date : Sunday, November 27th 2005 @ 03:54:25 PM
Script : http://www.motorsport-network.com/forums/showthread.php?t=1223
Referrer : http://www.motorsport-network.com/forums/forumdisplay.php?f=6
IP Address : 62.252.0.10
Username : Robert
Classname : vb_database

JoergZ
27 Nov 2005, 14:58
Perfect. It's the best hack I have ever seen.

Now waiting only for a nice person to translate the phrases to german. (I am soooo lazy.. :D)


Thank you for this gereat enhancement and all the work you put in.

Jörg

Maagic
27 Nov 2005, 14:59
ok now I am getting this- Database error in vBulletin 3.5.0:

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

MySQL Error : Table 'db123940199.arcade_games' doesn't exist
Error Number : 1146
Date : Sunday, November 27th 2005 @ 03:54:25 PM
Script : http://www.motorsport-network.com/forums/showthread.php?t=1223
Referrer : http://www.motorsport-network.com/forums/forumdisplay.php?f=6
IP Address : 62.252.0.10
Username : Robert
Classname : vb_database


I'm getting the exact same thing when I try to view a thread. I followed the instructions exactly, also :(

Snake
27 Nov 2005, 15:02
Working fine now, thanks man.

Future suggestion:

-Choose which category to make it as the default
-Score formatting (such as , . | etc)

RWDF1
27 Nov 2005, 15:02
I'm getting the exact same thing when I try to view a thread. I followed the instructions exactly, also :(

I went to products- and disable the arcade hack, the forum should work then. I will try again when someone has a suggestion on how to fix the error

3dsoft
27 Nov 2005, 15:05
is there also a Arcade Chess game?
So that users can play chess against each other. That would be cool!

Maagic
27 Nov 2005, 15:05
I went to products- and disable the arcade hack, the forum should work then. I will try again when someone has a suggestion on how to fix the error

DOH... why didn't I think of that? LOL


TY my forum's workin again :)

jellybaby
27 Nov 2005, 15:07
Seems to be working great but does anyone know how the challenges work, I cant see anywhere to challenge another player?

Thanks

trackpads
27 Nov 2005, 15:08
Thanks man! :D

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

Its always been free, the branding free option wasnt however.

Ryan McBain
27 Nov 2005, 15:10
How do make it so a user needs a certain number of posts per day to play in the arcade? And how do you get the correct times to show up next the scores? Its in army time right now.

Booth
27 Nov 2005, 15:10
Seems to be working great but does anyone know how the challenges work, I cant see anywhere to challenge another player?

Thanks

Me too...

How do you get challenges working please someone ? :nervous:

divided_by_fear
27 Nov 2005, 15:11
hmmm i think the beta worked better... lol the final has more bugs in it then the beta did...

divided_by_fear
27 Nov 2005, 15:12
challenges have to be enabled in ur progfile and the other person has to have them enabled too it should be on by default i think but it aint

Sal Collaziano
27 Nov 2005, 15:13
Installation didn't work out for me (I had "arcade" tables in the database from an old installation) and it got really mangled.. In order to uninstall, I needed to add the arcade_games table.. That's all I know how to do. The next step would be to add a "isreverse" column but I don't know how to do that. Here's the error I'm getting:

Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE arcade_games DROP isreverse;

MySQL Error : Can't DROP 'isreverse'. Check that column/key exists
Error Number : 1091
Date : Sunday, November 27th 2005 @ 10:10:12 AM
Script : http://www.mysite.com/forums/admincp/plugin.php
Referrer : http://www.mysite.com/forums/admincp/plugin.php?do=productdelete&productid=v3arcade&s=

I'm guessing that even if I could add that column, there would be other columns.. How can I completely uninstall this system so that I can reinstall it cleanly?

Thank you...

Vizionz
27 Nov 2005, 15:17
i didnt search the whole oage but when i try to import games for ipb it just gives me a empty page i have everything chmodded

Qwest
27 Nov 2005, 15:18
Everything is working fine except the trophy I should have just won does not show in my postbit_legacy though I edited the proper postbit_legacy templat.

Please help

www.geekbb.com

Snake
27 Nov 2005, 15:18
Not really. It was a paid product but then once ibProArcade is released it's now a freebie product.

Vizionz
27 Nov 2005, 15:20
it was paid to get the beta before the release and remove the copyright. john said awhile ago the actual script would be free

MissKalunji
27 Nov 2005, 15:21
read the docs, the importer is already included in the script...

sorry.....

trackpads
27 Nov 2005, 15:21
it was paid to get the beta before the release and remove the copyright. john said awhile ago the actual script would be free

correct

nexialys
27 Nov 2005, 15:22
Not really. It was a paid product but then once ibProArcade is released it's now a freebie product.
it was not paid actually... beta release was kinda paid because only subscribers had access to it...

logical... if you want to have something before the others, to play with or code for, you have to buy a privilege... the paid subscription was not for the software, but for the Branding Free... and this branding free is actually available for subscription... it was not stopped just because of the official release... so if you want to make a branding free arcade, you can pay for the job done!

wizardace
27 Nov 2005, 15:22
MySQL Error : Unknown column 'arcadepermissions' in 'field list'
Error Number : 1054

Actually, I found two "arcadepermissions" tables in vb3_usergroups and got rid of one but as you can see now the table does not exist. How can I add it?

danb00
27 Nov 2005, 15:22
i cant find any games to download on the release site

divided_by_fear
27 Nov 2005, 15:24
he dont have any one there thats why search in these forums you will find games for download i found a 1000 i have on site now

wizardace
27 Nov 2005, 15:25
Another one:

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

MySQL Error : Table 'forums.vb3_arcade_games' doesn't exist
Error Number : 1146

Vizionz
27 Nov 2005, 15:25
anyone having a problem with the ipb import ? i get a blank page for it

nexialys
27 Nov 2005, 15:26
i cant find any games to download on the release site
please let John have a break, he just slept 4 hours in the last 60 hours to give this release a heck... next days will be focussed on debugs and games releases...

lairnoc
27 Nov 2005, 15:26
It rocks John thanx all that helped John out with this release!!!

jellybaby
27 Nov 2005, 15:29
I couldnt get the IPB games import to work either thought maybe I was doing something wrong!

Where can I find V3 games?

egyptsons
27 Nov 2005, 15:30
greeaaaaaaattttt
I will install it nowwwwwww thanks alot John

Five stars ***** for you

divided_by_fear
27 Nov 2005, 15:30
i imported 1000 games on the beta i didnt try it on the new one though...

danb00
27 Nov 2005, 15:32
well my members want the games and im getting the emails for it! i really need these games

Lizard King
27 Nov 2005, 15:34
Everything worked perfect. Thanks again for this awesome script John.

One last question are you planning to have a mass delete high scores option in close future ?

Maagic
27 Nov 2005, 15:36
"Numerous Admin CP settings to control things like popup opacity, maximum comment length, hover delay length, and numerous other behaviors."

Where is this exactly? The previous arcade had a Arcade section in the AdminCP, but I do not see one for this release.

Chadi
27 Nov 2005, 15:37
I'm getting this error when importing xml:

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:34:44 AM
Script : http://www.talkjesus.com/admincp/plugin.php
Referrer : http://www.talkjesus.com/admincp/plugin.php?do=productadd
IP Address : 69.117.99.226
Username : Chad
Classname : vb_database

My entire vbulleting database has these tables:

access
adminhelp
administrator
adminlog
adminutil
adv_gallery_categories
adv_gallery_customfields
adv_gallery_customfields_entries
adv_gallery_ecards
adv_gallery_exif
adv_gallery_favorites
adv_gallery_filetypes
adv_gallery_images
adv_gallery_moderator
adv_gallery_permissions
adv_gallery_posts
adv_gallery_rate
adv_gallery_search
adv_gallery_subscribecat
adv_gallery_subscribeimage
adv_setting
adv_settinggroup
announcement
article
articleattachment
articlecategory
articlepost
articlerating
attachment
attachmenttype
attachmentviews
avatar
bans
bbcode
calendar
calendarcustomfield
calendarmoderator
calendarpermission
connections
cpsession
cron
cronlog
customavatar
customprofilepic
custom_droplinks
custom_singlelinks
datastore
deletionlog
editlog
event
faq
favorites
flashchat_bans
flashchat_connections
flashchat_ignors
flashchat_messages
flashchat_rooms
forum
forumpermission
forumread
gamechallenges
gamenews
games
gamesessions
holiday
icon
ignors
imagecategory
imagecategorypermission
journals
journal_comments
journal_entries
journal_moods
journal_settings
language
logins
mailqueue
messages
moderation
moderator
moderatorlog
modslog
passwordhistory
paymentapi
paymentinfo
paymenttransaction
phrase
phrasetype
plugin
pm
pmreceipt
pmtext
poll
pollvote
post
posthash
postindex
post_parsed
product
productcode
profilefield
profileviews
radio
ranks
regimage
reminder
reputation
reputationlevel
rooms
search
session
setting
settinggroup
smilie
spelling_words
statistic_browser_language
statistic_browser_os
statistic_counter
statistic_java_plugin
statistic_log
statistic_log_java
statistic_referer_full
statistic_referer_short
statistic_searchengine
statistic_searchengine_keywords
statistic_setting
statistic_spider
statistic_status
statistic_tld
statistic_tld_info
stats
strikes
style
subscribeevent
subscribeforum
subscribethread
subscription
subscriptionlog
tachyforumpost
tachythreadpost
template
templatehistory
thread
threadrate
threadread
threadrules
threadviews
ticket
ticketdeleted
ticketdepartment
ticketreply
upgradelog
user
useractivation
userban
userfield
usergroup
usergroupleader
usergrouprequest
usernote
userpromotion
usertextfield
usertitle
vbfields
vbspell
vbsurvey_answer_types
vbsurvey_answer_types_sequence
vbsurvey_answer_values
vbsurvey_answer_values_sequence
vbsurvey_completed_surveys
vbsurvey_dependencies
vbsurvey_dependencies_sequence
vbsurvey_ip_track
vbsurvey_questions
vbsurvey_questions_sequence
vbsurvey_results
vbsurvey_results_sequence
vbsurvey_results_text
vbsurvey_results_text_sequence
vbsurvey_sequence
vbsurvey_surveys
vbsurvey_surveys_sequence
vbsurvey_time_limit
word

deaconxgp
27 Nov 2005, 15:40
i installed before actually deleting the arcade fields from the two tables...i deleted them after i uploaded all the files and made the template changes.

it's giving me a database error now.

any help?

and is there supposed to be an option in the Admin CP like before? i don't see it.

GoTTi
27 Nov 2005, 15:41
chadi, browse your usergroup table and search for like %...% for arcade and see if its in there. you might have to remove that table or whatever...i dunno but i havent played with this yet. just goin off the top of the head.

Mastar
27 Nov 2005, 15:42
I Got This Error:

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM arcade_challenges AS arcade_challenges
LEFT JOIN user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error : Table '*******_the.arcade_challenges' doesn't exist
Error Number : 1146
Date : Sunday, November 27th 2005 @ 11:48:15 PM
Script : http://www.*******.com/arcade.php
Referrer : http://www.*******.com/index.php?
IP Address : **.**.**.**
Username : *******
Classname : vb_database

GoTTi
27 Nov 2005, 15:42
i cant find any games to download on the release site

here ya go

http://www.vbulletingames.com/Database/

dieselpowered
27 Nov 2005, 15:42
The only issue I am having is the links in the admincp do not work??

Under vB Arcade, settings link works, all others do not (Categories, Games, Game Tools, Score Tools)

Any thoughts?

GoTTi
27 Nov 2005, 15:45
anybody know where i can get a sudoku flash game from?

check http://www.vbulletingames.com/Database/ or request it from the guy

Chadi
27 Nov 2005, 15:48
Now it says

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:47:40 AM
Script : http://www.talkjesus.com/admincp/plugin.php
Referrer : http://www.talkjesus.com/admincp/plugin.php?do=productadd
IP Address : 69.117.99.226
Username : Chad
Classname : vb_database


I even deleted the 4 tables with "games" in it. Still same error

deaconxgp
27 Nov 2005, 15:48
i don't have the v3 Arcade option in my Admin CP....i loaded the files etc as instructed but nothing.

GoTTi
27 Nov 2005, 15:48
were can i find games for this?

u can get a big chunk of the games here:
http://www.vbulletingames.com/Database/

dieselpowered
27 Nov 2005, 15:53
i don't have the v3 Arcade option in my Admin CP....i loaded the files etc as instructed but nothing.

Hit refresh, or logout and then back into the admincp.

MissKalunji
27 Nov 2005, 15:53
read the docs, the importer is already included in the script...


i dont see the docs?

dieselpowered
27 Nov 2005, 15:54
Is the trophy supposed to show in the postbit?? Cause it is not showing in mine.

**edit**

the awards and challenge are shown in the pull down menu...sorry

jellybaby
27 Nov 2005, 15:54
u can get a big chunk of the games here:
http://www.vbulletingames.com/Database/

How do you download them. I have registered and it still says registration required and I cant see any download link :disappointed:

GoTTi
27 Nov 2005, 15:55
if you guys are having problems you should really post your issues on http://www.v3arcade.com/forums/index.php

AshokForums.com
27 Nov 2005, 15:56
Might be a stupid question but.. Will games compatible with v3arcade (for vb 3.0) work with this new release???

GoTTi
27 Nov 2005, 15:56
How do you download them. I have registered and it still says registration required and I cant see any download link :disappointed:

you need to wait for the admin guy to approve your account. he takes like a day or so so be patient, he will get to it ;)

GoTTi
27 Nov 2005, 15:57
Might be a stupid question but.. Will games compatible with v3arcade (for vb 3.0) work with this new release???

yes.

all your answers all also answered @ http://www.v3arcade.com/forums/index.php

well a big portion of em

Chadi
27 Nov 2005, 16:00
Does anyone know about the database problem I am having? I cleared out anything from the search results that said "arcade" from my database but still getting the error.

GoTTi
27 Nov 2005, 16:05
after you cleared it out did u reinstall the arcade?

Chadi
27 Nov 2005, 16:06
I've been trying to re-upload the xml but I keep getting that error I pasted

AshokForums.com
27 Nov 2005, 16:07
And the code given here by John (for converting games) http://www.vbulletin.org/forum/showthread.php?t=60666

Will the same code work for this version too?

nokturno
27 Nov 2005, 16:12
thank you

Ignignokt
27 Nov 2005, 16:17
Is there a way to get awards to show in postbit and not in the dropdown?

GamerzWorld
27 Nov 2005, 16:18
Great work, about to upgrade from Beta hopefully no errors...>.<

crustymanmeat
27 Nov 2005, 16:37
Total NOOB here. I have followed the instructions but when i click on the Arcade link in the nav bar i get this message:

The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.
--------------------------------------------------------------------------------

Please try the following:

Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly.
If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted.
Click the Back button to try another link.
HTTP Error 404 - File or directory not found.
Internet Information Services (IIS)

nexialys
27 Nov 2005, 16:42
Total NOOB here. I have followed the instructions but when i click on the Arcade link in the nav bar i get this message:

The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.
That just mean you did not install the arcade in the proper path...

the files have to be located in the forum's same path... not only the imported plugin... http://www.vbulletin.com/docs/html/plugin_system

weirdpixels
27 Nov 2005, 16:43
installed and working great, thanks John :)

nexus851
27 Nov 2005, 16:43
Working perfectly... so far =)

Blam Forumz
27 Nov 2005, 16:45
I get this error when I run the arcadeupdate.php:


Database error in vBulletin 3.5.0:

Invalid SQL:
INSERT INTO arcade_games VALUES (1, 'asteroids', 'Asteroids', 'Kill some asteroids and flying saucers!', 'asteroids.swf', '500', '375', '', 'asteroids1.gif', 7, 0, 0, '', 1, 29, 1110794236, 0, 0, 0, 0, 0, 0, 0, 0);

MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Sunday, November 27th 2005 @ 11:45:04 AM
Script : http://www.blamforums.com/forum/arcadeupdate.php
Referrer :
IP Address : ########
Username : Blaminator
Classname : vb_database

Aeolian
27 Nov 2005, 16:50
welcome back!!

GrabAssGirl
27 Nov 2005, 16:52
Please help! I am an amature when it comes to this kind of thing. Could someone give me a starting point on how to fix this error:

Warning: main(./arcade/functions/functions.php): failed to open stream: No such file or directory in /arcade.php on line 88

Warning: main(./arcade/functions/functions.php): failed to open stream: No such file or directory in /arcade.php on line 88

Fatal error: main(): Failed opening required './arcade/functions/functions.php' (include_path='.:/usr/local/lib/php') in /home/tblough/domains/xuniverse.org/public_html/forums/arcade.php on line 88

TIA!!

trackpads
27 Nov 2005, 16:55
Anyone have the sql query that would allow all users to participate in challenges? I want to go back and make this default to on instead of the current off.

Thanks!

dagger77
27 Nov 2005, 17:01
first post and its in your topic :)

yapee

AlexUK
27 Nov 2005, 17:01
I just installed but I am getting some missing things, look here:

http://www.psplounge.com/forums/arcade.php

very strange. Any idea why?

Oh and how do I delete the old arcade templates in the forums?

crustymanmeat
27 Nov 2005, 17:01
I will have to uninstall this because i have been at it for at least 4hours and still can't get it to work. Thanks for all the help though.

ConqSoft
27 Nov 2005, 17:03
I just installed but I am getting some missing things, look here:

http://www.psplounge.com/forums/arcade.php

very strange. Any idea why?

Try reverting all your Arcade templates.

jrofosho
27 Nov 2005, 17:04
John Everything seemed to go fine, the arcade is now installed. But when i try to change the usergroup permissions i am getting this error:

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE usergroup SET

MySQL Error : Unknown column 'arcadepermissions' in 'field list'
Error Number : 1054
Date : Sunday, November 27th 2005 @ 09:03:12 AM
Script : http://jrofosho.com/forum/admincp/usergroup.php
Referrer : http://jrofosho.com/forum/admincp/usergroup.php?do=edit&usergroupid=6
Username : Jrofosho
Classname : vb_database

I did remove the 2 database entries like you said. I don't know what i did wrong.

Maagic
27 Nov 2005, 17:05
I will have to uninstall this because i have been at it for at least 4hours and still can't get it to work. Thanks for all the help though.

You can just disable it in your AdminCP>Plugin System>Manage Products section if it's giving you trouble

nexus851
27 Nov 2005, 17:06
Can v3 work with any FLASH GAMES when uploaded thru the import? (as in it will also record the scores)

ConqSoft
27 Nov 2005, 17:07
Can v3 work with any FLASH GAMES when uploaded thru the import? (as in it will also record the scores)
The game has to be modified to work. "just any old flash game" won't work.

Blam Forumz
27 Nov 2005, 17:10
I repeat, :(


Database error in vBulletin 3.5.0:

Invalid SQL:
INSERT INTO arcade_games VALUES (1, 'asteroids', 'Asteroids', 'Kill some asteroids and flying saucers!', 'asteroids.swf', '500', '375', '', 'asteroids1.gif', 7, 0, 0, '', 1, 29, 1110794236, 0, 0, 0, 0, 0, 0, 0, 0);

MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Sunday, November 27th 2005 @ 11:45:04 AM
Script : http://www.blamforums.com/forum/arcadeupdate.php
Referrer :
IP Address : 86.137.210.113
Username : Blaminator
Classname : vb_database



When trying to run the arcadeupdate.php file :/

Vizionz
27 Nov 2005, 17:12
you repeating aint helping nothing specially when the coder is asleep after 60 hours of coding. so be patient he will be back and help out, but posting it over and over and over is not gonna make your problem get fixed faster

Blam Forumz
27 Nov 2005, 17:13
Calm down, I only posted it twice, and just because the coder isn't awake, doesn't mean other people can't help me

BoYagoob
27 Nov 2005, 17:15
Thanks a lot :)

nexus851
27 Nov 2005, 17:18
The game has to be modified to work. "just any old flash game" won't work.

how do you modify the flash games to make it work and send the score to the v3 arcade ranking????

Maagic
27 Nov 2005, 17:18
Calm down, I only posted it twice, and just because the coder isn't awake, doesn't mean other people can't help me

True, but if no one offered any advice after your first post, bumping it won't really help. In fact some go out of their way to not help people who bump their own posts.

I'm getting that error as well, but I have my arcade disabled until the coder wakes back up and can help or someone else happens upon a fix.

ConqSoft
27 Nov 2005, 17:21
how do you modify the flash games to make it work and send the score to the v3 arcade ranking????

There are instructions on the v3arcade.com site. You will have to have the "source" to the game, and permission from the game author to edit it.

Chadi
27 Nov 2005, 17:25
What's wrong with this site?
http://www.vbulletingames.com/Database/

I registered, confirmed, logged in and see no download options

nexus851
27 Nov 2005, 17:27
There are instructions on the v3arcade.com site. You will have to have the "source" to the game, and permission from the game author to edit it.

where on v3arcade site???? i cant seem to find it..

i have a few games with author permissions so that's why i would like to know how to edit these flash games for scoring...

ConqSoft
27 Nov 2005, 17:27
That site has nothing to do with this hack...

ConqSoft
27 Nov 2005, 17:28
where on v3arcade site???? i cant seem to find it..

i have a few games with author permissions so that's why i would like to know how to edit these flash games for scoring...

http://www.v3arcade.com/forums/showthread.php?t=272

WNxWakko
27 Nov 2005, 17:29
oh ya, Ive been waiting for this release. V3 Rocks!

I am not to fond of what ibProArcade is doing regarding limitations of game downloads and forcing members to post ads to get in.

GoTTi
27 Nov 2005, 17:31
What's wrong with this site?
http://www.vbulletingames.com/Database/

I registered, confirmed, logged in and see no download options

you need to wait a day or so for the admin to activate your account. he does it manually.

nexus851
27 Nov 2005, 17:33
http://www.v3arcade.com/forums/showthread.php?t=272

seems like i dont have access to that thread b/c i didnt buy the unbranded option.. may you please paste the instructions in this thread so i can figure out the flash games,... greatly appreciated... =)

jrofosho
27 Nov 2005, 17:33
It seems like a common problem with the installation is that the database changes are being made. Any clue why? I have none of the database tables that were supposed to be added.

yoyoyoyo
27 Nov 2005, 17:33
I am not to fond of what ibProArcade is doing regarding limitations of game downloads and forcing members to post ads to get in.
IBP Pro Arcade that is released here has nothing to do with the ibproarcade site, so it is unfair to make comparisons in that regard. There are many other places to get games other than on that site for IBP pro arcade.

redlabour
27 Nov 2005, 17:33
What about a german Translation ?

PixelFx
27 Nov 2005, 17:33
Thanks.. You rock john.. :)

woot, congrats on your release john :D

Zelda-King
27 Nov 2005, 17:34
A smooth upgrade. :)

A couple of observations after upgrading from the latest beta;

- I get no challenge link in the postbit dropdown in spite of enabling them in my profile. I don't see challenge setting in the admin settings either. (I wonder why that is. It seems some other people have it.)

- The download link has disappeared after the upgrade.

- There's a setting to make awards show in the postbit and profiles but nothing shows in profiles.

Oh, and is there any additional functionality added since the beta stage that we should know about?

ConqSoft
27 Nov 2005, 17:34
seems like i dont have access to that thread b/c i didnt buy the unbranded option.. may you please paste the instructions in this thread so i can figure out the flash games,... greatly appreciated... =)

It just has a link to here, which is public: http://www.gamerseuphoria.com/temp/v3arcade/instructions.html

Lea Verou
27 Nov 2005, 17:34
Ehm, sorry to ask such a dumb question but I searched the whole thread and can't find the answer :o
I need to upgrade from the 3.0.x version.
The manual only writes about installation, not upgrade, and just mentions that there is an import script.
I tried running the import script but I got a db error (I don't know exactly what as the mail hasn't come yet).
What should I do and in what order?

Thanks a lot in advance :)
I told my users that the arcade came out and they are almost party-ing :p

ConqSoft
27 Nov 2005, 17:36
Ehm, sorry to ask such a dumb question but I searched the whole thread and can't find the answer :o
I need to upgrade from the 3.0.x version.
The manual only writes about installation, not upgrade, and just mentions that there is an import script.
I tried running the import script but I got a db error (I don't know exactly what as the mail hasn't come yet).
What should I do and in what order?

Thanks a lot in advance :)
I told my users that the arcade came out and they are almost party-ing :p
After you install, run the arcadeimport.php that comes with it. It's in the AdminCP directory.

Lea Verou
27 Nov 2005, 17:38
After you install, run the arcadeimport.php that comes with it. It's in the AdminCP directory.

Oh, after I install!!! Thanks a lot!!
And what about the database? Should I drop any fields? It writes something about that but I'm kinda scared to do it :o

jbd
27 Nov 2005, 17:39
All installed and running perfectly with 976 games on

http://www.GamesForum.com

Thanks very much Mr. Zeropage :)

nexus851
27 Nov 2005, 17:42
It just has a link to here, which is public: http://www.gamerseuphoria.com/temp/v3arcade/instructions.html

wow that looks complicated... any newbie manual in english laymen's terms for that same instruction? =(

The Icon
27 Nov 2005, 17:42
Hey guys,

I'm getting the following error message on the 'Data Rebuilding' stage of the import script (i've deliberately taken out my IP address and username details from the message):

Invalid SQL:
UPDATE arcade_games AS arcade_games SET sessioncount=2017, highscorerid=10832, highscore=4283.000 WHERE gameid=1;

MySQL Error : You have an error in your SQL syntax near 'AS arcade_games SET sessioncount=2017, highscorerid=10832, highscore=4283.000 WH' at line 1
Error Number : 1064
Date : Sunday, November 27th 2005 @ 05:15:08 PM
Script : http://**************/admincp/arcadeimport.php
Referrer : http://***************/admincp/arcadeimport.php?do=30ximport&perpage=1000&step=3&startat=17000
IP Address : ***********
Username : ***********
Classname : ***********


Any ideas why this might be happeneing?

ConqSoft
27 Nov 2005, 17:43
wow that looks complicated... any newbie manual in english laymen's terms for that same instruction? =(
That is in laymen's terms, if you know flash. If you don't know flash, then you're out of luck. ;)

sensimilla
27 Nov 2005, 17:44
All installed and running perfectly with 976 games on

http://www.GamesForum.com

Thanks very much Mr. Zeropage :)

wrong topic this is not ibproarcade thread

nexus851
27 Nov 2005, 17:48
That is in laymen's terms, if you know flash. If you don't know flash, then you're out of luck. ;)

any idea where's a quick tutorial where i can learn enough to just implement the instructions?



P.S - if i dont do this, then that means no highest score will be recorded only, right??

ConqSoft
27 Nov 2005, 17:53
Yes, it means their score won't be recorded.

PKassab
27 Nov 2005, 17:53
Im gettin this error


Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

nexus851
27 Nov 2005, 18:00
How do i challenge other players???? (i already turned on challenge in the profile options but I still dont see the commands anywhere for challenging others)

ConqSoft
27 Nov 2005, 18:01
When you click their name in a post, it's on the dropdown, if they chose to allow themselves to be challenged. (In their User CP -> Arcade Options settings.)

nexus851
27 Nov 2005, 18:07
When you click their name in a post, it's on the dropdown, if they chose to allow themselves to be challenged. (In their User CP -> Arcade Options settings.)

it's on, but when i click their name in the post... it doesnt show it on the dropdown list.. do they have to be online to work???

ConqSoft
27 Nov 2005, 18:08
No, but THEY have to choose to make themselves available for challenges, in THEIR User CP.

And, you did make the template changes shown in the installation instructions?

ReadOrDie
27 Nov 2005, 18:08
What games does this come with?

nexus851
27 Nov 2005, 18:11
No, but THEY have to choose to make themselves available for challenges, in THEIR User CP.

And, you did make the template changes shown in the installation instructions?

yeah, i made it in "postbit" not postbit_legacy... (whats the difference? or do i have to do both???)

ConqSoft
27 Nov 2005, 18:12
It depends on which postbit you're using. If your user info is shown at the left, then you're using the legacy.

Mastar
27 Nov 2005, 18:13
GETTING THIS ERROR WHEN CLICK ON THE ARCADE LINK ON MY FORUM:



Database error in vBulletin 3.5.1:

Invalid SQL:

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

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

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

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

WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error : Table 'Funnies_the.arcade_challenges' doesn't exist

Error Number : 1146

Date : Monday, November 28th 2005 @ 02:17:36 AM

Script : http://www.thebedrocktavern.com/arcade.php?

Referrer : http://www.thebedrocktavern.com/index.php?

IP Address : 12.109.5.38

Username :Funny Man

Classname : vb_database

AND GOT THIS WHEN I CLICK ON GAMES IN THE ACP:

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT COUNT(*) AS total

FROM arcade_games AS arcade_games;

MySQL Error : Table 'Funnies_the.arcade_games' doesn't exist

Error Number : 1146

Date : Monday, November 28th 2005 @ 02:22:42 AM

Script : http://www.thebedrocktavern.com/admincp/arcadeadmin.php?do=games

Referrer : http://www.thebedrocktavern.com/admincp/index.php

IP Address : 12.109.5.38

Username :Funny Man

Classname : vb_database

ANY HELP?

nexus851
27 Nov 2005, 18:13
It depends on which postbit you're using.


sorry, what do u mean by that??? im sorta a newbie to this "postbit" definition... pls explain...

my user info is shown on the top... how do i change to show on the left?

nwingate
27 Nov 2005, 18:18
How will this work with future updates from Jelsoft? Will I need to reinstall this script every time I get a security update?

I used this script on vBulletin 3 and removed it because it always took so long to update the board whenever there was a new update.

ConqSoft
27 Nov 2005, 18:21
No, it's a Product, so you won't have to reinstall when you upgrade vBulletin.

nexus851
27 Nov 2005, 18:24
yeah, i have those postbit and postbit_legacy modded already and the usercp ACCEPT CHALLENGE ON, however in the forum post, it still doesnt show up the challenge option...


What can be wrong?

ConqSoft
27 Nov 2005, 18:25
You either didn't make the edit correctly, or the user you are trying to challenge isn't allowing challenges, or you didn't enable challenges in the Arcade AdminCP. Has to be one of those.

The Icon
27 Nov 2005, 18:25
Hey guys,

I'm getting the following error message on the 'Data Rebuilding' stage of the import script (i've deliberately taken out my IP address and username details from the message):

Invalid SQL:
UPDATE arcade_games AS arcade_games SET sessioncount=2017, highscorerid=10832, highscore=4283.000 WHERE gameid=1;

MySQL Error : You have an error in your SQL syntax near 'AS arcade_games SET sessioncount=2017, highscorerid=10832, highscore=4283.000 WH' at line 1
Error Number : 1064
Date : Sunday, November 27th 2005 @ 05:15:08 PM
Script : http://**************/admincp/arcadeimport.php
Referrer : http://***************/admincp/arcadeimport.php?do=30ximport&perpage=1000&step=3&startat=17000
IP Address : ***********
Username : ***********
Classname : ***********


Any ideas why this might be happeneing?

No one else having this problem?

nwingate
27 Nov 2005, 18:29
No, it's a Product, so you won't have to reinstall when you upgrade vBulletin.

But, will you have to alter templates again after each install or should everything still work after an update?

Sorry, but I had a lot of problems with the old system. I'm excited to use this if it works right.

Thanks for the help.

nexus851
27 Nov 2005, 18:30
You either didn't make the edit correctly, or the user you are trying to challenge isn't allowing challenges, or you didn't enable challenges in the Arcade AdminCP. Has to be one of those.

i enabled challenge in each of the arcade games, unless there is a "enable challenges" option somewhere else i dont know about...,

ConqSoft
27 Nov 2005, 18:31
But, will you have to alter templates again after each install or should everything still work after an update?

Sorry, but I had a lot of problems with the old system. I'm excited to use this if it works right.

Thanks for the help.

If you have to revert any vBulletin templates to get new features/fixes, and those templates are one of the two or three that you modified to add Arcade features/links, then yes you will have to re-do those edits. That's no different than any other hack that requires changes to default vBulletin templates.

ConqSoft
27 Nov 2005, 18:33
i enabled challenge in each of the arcade games, unless there is a "enable challenges" option somewhere else i dont know about...,


In the main Arcade settings.

nexus851
27 Nov 2005, 18:35
In the main Arcade settings.


you mean "Number of Recent Challenges to Display"=3 ?? that's all i got for challenge options in the main admincp option..