[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