vb.org Archive - Add-On Releases - v3 Arcade - Games Arcade System for 3.6.0

Page 2 of 78

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Add-On Releases - v3 Arcade - Games Arcade System for 3.6.0 (https://vborg.vbsupport.ru/showthread.php?t=114012)

tidy_boy

11-27-2005 11:42 AM

Quote:

Originally Posted by John

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	11-27-2005 11:43 AM

Quote:

Originally Posted by jaffaman

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	11-27-2005 11:43 AM

Quote:

Originally Posted by Zachariah

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

11-27-2005 11:44 AM

anybody know where i can get a sudoku flash game from?

divided_by_fear

11-27-2005 11:48 AM

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	11-27-2005 11:48 AM

thanks!

tidy_boy

11-27-2005 11:52 AM

Quote:

Originally Posted by tidy_boy

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

11-27-2005 11:54 AM

same here sitll got the error

trackpads

11-27-2005 11:54 AM

Oh sooo sweet :) Thanks John!

Blam Forumz

11-27-2005 11:54 AM

The importer script, do i run it before or after i isntall v3arcade?

John	11-27-2005 11:55 AM

Quote:

Originally Posted by Blam Forumz

The importer script, do i run it before or after i isntall v3arcade?

After.

b6gm6n

11-27-2005 11:55 AM

Thanx John, wonderfull...

-b6

John	11-27-2005 11:55 AM

Quote:

Originally Posted by tidy_boy

any ideas john on how to fix this please

Try this?

https://vborg.vbsupport.ru/showpost....2&postcount=42

waza	11-27-2005 11:56 AM

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

tidy_boy

11-27-2005 11:56 AM

Quote:

Originally Posted by John

Try this?

https://vborg.vbsupport.ru/showpost....2&postcount=42

I tried that mate did not work

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

jaffaman

11-27-2005 11:57 AM

I have done that m8 and still gettint the error :( i dont have much luck doing this sort of thing lol

John	11-27-2005 11:58 AM

Are either of you using table prefixes?

tidy_boy

11-27-2005 11:59 AM

Quote:

Originally Posted by John

Are either of you using table prefixes?

my table prefix is vb3_

John	11-27-2005 11:59 AM

Quote:

Originally Posted by waza

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

11-27-2005 12:00 PM

I'm also getting the:

Code:

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	11-27-2005 12:00 PM

Oh, got it.

Find:

Code:

$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

Code:

$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

11-27-2005 12:01 PM

I get this when I Try to runt he arcadeupdate.php:

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

Snake

11-27-2005 12:01 PM

Thanks man! :D

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

Supes

11-27-2005 12:02 PM

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...?do=productadd
IP Address : **.**.**.***
Username : ******
Classname : vb_database

tidy_boy

11-27-2005 12:02 PM

Quote:

Originally Posted by John

Oh, got it.

Find:

Code:

$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

Code:

$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

11-27-2005 12:04 PM

Quote:

Originally Posted by John

Oh, got it.

Find:

Code:

$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

Code:

$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

Code:

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

Quote:

Originally Posted by tidy_boy

Where do i look for this?

arcade.php

John	11-27-2005 12:04 PM

Quote:

Originally Posted by tidy_boy

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

11-27-2005 12:04 PM

This is what i have got in my config m8

PHP Code:


		
			
TABLE PREFIX ******

    //    Prefix that your vBulletin tables have in the database.

$config['Database']['tableprefix'] = 'vb3_';



    /

Impreza04

11-27-2005 12:04 PM

Tried the replacment line and get the same error

PHP Code:


		
			
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

11-27-2005 12:04 PM

Quote:

Originally Posted by Aftermath

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	11-27-2005 12:05 PM

Quote:

Originally Posted by Trosun

Still getting the

Code:

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	11-27-2005 12:06 PM

Quote:

Originally Posted by Impreza04

Tried the replacment line and get the same error

PHP Code:


		
			
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

11-27-2005 12:08 PM

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	11-27-2005 12:09 PM

Try the attached file?

tidy_boy

11-27-2005 12:09 PM

Quote:

Originally Posted by Abbas

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

11-27-2005 12:09 PM

I'm a proud branding free user - glad this got to be posted here without any trouble! :)

uae	11-27-2005 12:09 PM

Thanks John :)

Snake

11-27-2005 12:09 PM

Quote:

Originally Posted by Chris M

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

11-27-2005 12:09 PM

Perfection :)

John	11-27-2005 12:10 PM

Quote:

Originally Posted by Abbas

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

All times are GMT. The time now is 01:01 PM.

Page 2 of 78

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03378 seconds Memory Usage 1,864KB 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 (9)bbcode_code_printable (3)bbcode_php_printable (19)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)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
Messages: