list($rankid)=$db->query_first("SELECT rankid FROM bb".$n."_ranks WHERE groupid IN ('0','$wbbuserdata[groupid]') AND needposts<='$wbbuserdata[userposts]' AND gender IN ('0','".intval($r_gender)."') ORDER BY needposts DESC, gender DESC",1);
$db->query("UPDATE bb".$n."_users SET email='".addslashes(htmlspecialchars($r_email))."', usertext='".addslashes(htmlspecialchars($r_usertext))."', icq='".intval($r_icq)."', aim='".addslashes(htmlspecialchars($r_aim))."', yim='".addslashes(htmlspecialchars($r_yim))."', msn='".addslashes(htmlspecialchars($r_msn))."', homepage='".addslashes(htmlspecialchars($r_homepage))."', birthday='".addslashes(htmlspecialchars($birthday))."', gender='".intval($r_gender)."'".ifelse($rankid!=$wbbuserdata['rankid'],", rankid='$rankid'","")." WHERE userid = '$wbbuserdata[userid]'");
if($fieldvalues) $db->query("UPDATE bb".$n."_userfields SET $fieldvalues WHERE userid = '$wbbuserdata[userid]'");
|