[Steve W.]

Oh, and instead of:

$DB_site->query("UPDATE user SET birthday='$birthday',options='$options',usergroupi d='$usergroupid',username='".addslashes(htmlspecia lchars($ausername))."'$pwdinclude,email='".addslas hes(htmlspecialchars($email))."',styleid='$usersty leid',parentemail='".addslashes(htmlspecialchars($ parentemail))."',coppauser=$coppauser,homepage='". addslashes(htmlspecialchars($homepage))."',icq='". addslashes(htmlspecialchars($icq))."',aim='".addsl ashes(htmlspecialchars($aim))."',yahoo='".addslash es(htmlspecialchars($yahoo))."',signature='".addsl ashes($signature)."',adminemail=$adminemail,showem ail=$showemail,invisible=$invisible,usertitle='".a ddslashes($usertitle)."',customtitle=$customtitle, joindate=$joindate,cookieuser=$cookieuser,nosessio nhash=$nosessionhash,daysprune='$daysprune',lastvi sit=$lastvisit,lastactivity=$lastactivity,lastpost =$lastpost,posts='$posts',timezoneoffset='$timezon eoffset',emailnotification=$emailnotification,rece ivepm='$receivepm',emailonpm='$emailonpm',ipaddres s='".addslashes($aipaddress)."',pmpopup=IF(pmpopup =2 AND $pmpopup=1,pmpopup,'$pmpopup') WHERE userid=$userid");

I have:

$DB_site->query("UPDATE user SET birthday='$birthday',options='$options',usergroupi d='$usergroupid',username='".addslashes(htmlspecia lchars($ausername))."'$pwdinclude,email='".addslas hes(htmlspecialchars($email))."',styleid='$usersty leid',parentemail='".addslashes(htmlspecialchars($ parentemail))."',coppauser=$coppauser,homepage='". addslashes(htmlspecialchars($homepage))."',icq='". addslashes(htmlspecialchars($icq))."',aim='".addsl ashes(htmlspecialchars($aim))."',yahoo='".addslash es(htmlspecialchars($yahoo))."',signature='".addsl ashes($signature)."',adminemail=$adminemail,showem ail=$showemail,invisible=$invisible,usertitle='".a ddslashes($usertitle)."',customtitle=$customtitle, joindate=$joindate,cookieuser=$cookieuser,nosessio nhash=$nosessionhash,daysprune='$daysprune',lastvi sit=$lastvisit,lastactivity=$lastactivity,lastpost =$lastpost,posts='$posts',profileview='$profilevie w',timezoneoffset='$timezoneoffset',emailnotificat ion=$emailnotification,receivepm='$receivepm',emai lonpm='$emailonpm',ipaddress='".addslashes($aipadd ress)."',pmpopup=IF(pmpopup=2 AND $pmpopup=1,pmpopup,'$pmpopup') WHERE userid=$userid");