| tpearl5 |
02-07-2003 06:58 PM |
Quote:
Originally posted by ethics
I have a weird problem.
In the instructions, it says to:
PHP Code:
-+-+-+
Find:
-+-+-+
$DB_site->query("UPDATE arcadeconfig
SET path='$thepath',usescoreicon='$usescoreicon',usekingicon='$usekingicon'
".iif(($scoreicon != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scorei_d'","")."
".iif(($kingicon != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingi_d'","")."
WHERE arcadeid='$arcadeid'");
The only instance of "$DB_site->query("UPDATE arcadeconfig" I get in that file is the following:
PHP Code:
$DB_site->query("UPDATE arcadeconfig
SET active='$active',path='$thepath'
".iif(($addgroup != 0) or ($delgroup != 0),",useraccess='$useraccess'","")."
,usescoreicons='$usescoreicons',usekingicon='$usekingicon',usedetailicons='$usedetailicons'
".iif(($scoreicondata != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scoreicondata'","")."
".iif(($topscoreicondata != "") || ($deletetopscoreicon == 1),",topscoreiconname='$topscoreicon_name', topscoreicondata='$topscoreicondata'","")."
".iif(($kingicondata != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingicondata'","")."
".iif(($userdetailicondata != "") || ($deleteuserdetailicon == 1),",userdetailiconname='$userdetailicon_name', userdetailicondata='$userdetailicondata'","")."
".iif(($gamedetailicondata != "") || ($deletegamedetailicon == 1),",gamedetailiconname='$gamedetailicon_name', gamedetailicondata='$gamedetailicondata'","")."
WHERE arcadeid='$arcadeid'");
It's totally different.
I think this is why I get an SQL error when I try to change the dollar amount to play the game?
This is the error I get:
Database error in vBulletin Control Panel 2.2.8:
Invalid SQL: UPDATE arcadegames
SET name='breakout', title='Breakout', description='A simple Arkanoid-style game -- see how many balls you can keep going at once!', filename='breakout.swf',
active='1', scorevar='$breakoutscore', width='', height='',
codebase='', querystring='', objectparam='',
embedparam='',championactive='1',championtext='Bre akout Champion',championcolor='#ff0000',playcost='50',ja ckpot='20',jackpotadd='5'
WHERE gameid='2'
mysql error: Unknown column 'width' in 'field list'
mysql error number: 1054
|
I'm having the same problem. I tried merging the code, but it didn't work. humm.. |
More Information