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

Page 7 of 312

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)

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

All times are GMT. The time now is 03:54 PM.

Page 7 of 312

« First

107

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03071 seconds Memory Usage 1,763KB 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 (7)bbcode_code_printable (2)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: