Danke für Idde, aber ich bekomme immernoch den ERROR, habe die zeilen durch deinen code ersetzt:
Code: Alles auswählen
$sql = "UPDATE " . USERS_TABLE . "
SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) . "', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_sig_bbcode_uid = '$signature_bbcode_uid', user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowavatar = $user_allowavatar, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_allow_pm = $user_allowpm, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_active = $user_status, user_rank = $user_rank", user_teamtitle = '" . str_replace("\'", "''", $teamtitle) . "', user_realname = '" . str_replace("\'", "''", $realname) . "', user_adress = '" . str_replace("\'", "''", $adress) . "', user_birth = '$birth', user_photo = '" . str_replace("\'", "''", $photo) . "', user_slogan = '" . str_replace("\'", "''", $slogan) . "', user_topt_title = '" . str_replace("\'", "''", $opt_title) . "', user_topt_text = '" . str_replace("\'", "''", $opt_text) . "', team_website = '$team_website', team_email = '$team_email', team_pm = '$team_pm' . $avatar_sql . "
WHERE user_id = $user_id";
