Ich versuche die user_id in das Nickpage_Table bei der Registrierung einzugeben:
Code: Alles auswählen
$sql = "INSERT INTO " . USERS_TABLE . " a, ".NICKPAGE_TABLE." b (b.uid, a.user_id, a.username, a.user_regdate, a.user_password, a.user_email, a.user_inv1, a.user_inv2, a.user_inv3, a.user_occ, a.user_from_flag, a.user_absence_mode, a.user_absence, a.user_absence_text, a.user_popup_notes, a.user_sig, a.user_sig_bbcode_uid, a.user_avatar, a.user_avatar_type, a.user_viewemail, a.user_aim, a.user_yim, a.user_msnm, a.user_skype, a.user_attachsig, a.user_allowsmile, a.user_allowhtml, a.user_allowbbcode, a.user_allow_viewonline, a.user_notify, a.user_notify_pm, a.user_popup_pm, a.user_timezone, a.user_dateformat, a.user_lang, a.user_style, a.user_gender, a.user_level, a.user_allow_pm, a.user_birthday, a.user_next_birthday_greeting, a.user_active, a.user_actkey)
VALUES ($user_id, $user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $user_inv1) . "', '" . str_replace("\'", "''", $user_inv2) . "', '" . str_replace("\'", "''", $user_inv3) . "', '" . str_replace("\'", "''", $occupation) . "', '$user_flag', $user_absence_mode, $user_absence, '" . str_replace("\'", "''", $user_absence_text) . "', $popup_notes, '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', '" . str_replace("\'", "''", $skype) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, '$gender', 0, 1, '$birthday', '$next_birthday_greeting', ";
