[Magic Spark]

Originally Posted by Pseudomizer

Hi Magic Spark,

please find in the proarcadeadmin.php the following source code in line 170:

PHP Code:

$DB_site->query("UPDATE arcadegames
                     SET name='$name', title='$title', description='$desc', filename='$filename', hashoffset='$hashoffset',
                         ".iif(($championdata != "") || ($deletechampicon == 1),"championpicname='$championicon_name', championpicdata='$championdata',","")."
                         ".iif(($thumbdata != "") || ($deletethumb == 1),"thumbnailname='$thumbnail_name', thumbnaildata='$thumbdata',","")."
                         active='$active', scorevar='$scorevar', gamecode='$gamecode',championactive='$championactive',championtext='$championtext',championcolor='$championcolor'
                     WHERE gameid='$gameid'"); 


and replace this with the following:

PHP Code:

$thumbnail_name= $HTTP_POST_FILES[thumbnail]['name'];

    if (($championdata != '') || ($deletechampion == 1)){
        $championsql = ",championpicname='". $championicon_name ."', championpicdata = '". $championdata ."'";
    }
    else
    {
        // DO NOTHING
    }


    if (($thumbdata != '') || ($deletethumb == 1)) {
        $thumbsql = ",thumbnailname='". $thumbnail_name ."', thumbnaildata='". $thumbdata ."'";
    }
    else
    {
        // DO NOTHING
    }

    $DB_site->query("UPDATE arcadegames
                SET name='$name', title='$title', description='$desc', filename='$filename', hashoffset='$hashoffset'". $championsql . $thumbsql ." ,active='$active', scorevar='$scorevar', gamecode='$gamecode',championactive='$championactive',championtext='$championtext',championcolor='$championcolor'
                WHERE gameid='$gameid'"); 


This should solve your problem.

Cheers,

Pseudomizer

Works great!

Thank you, Pseudomizer.