Code: Alles auswählen
$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_plz, user_allow_mass_email, user_popup_notes, disallow_profile_search, user_absence_mode, user_absence, user_absence_text, user_profile_view_popup, user_vorname, user_name, user_strasse, user_ort, user_telefon, user_skype, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_startup, user_attachsig, user_setbm, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, statusmail_days, statusmail_last, statusmail_viewchars, user_gender, user_single, user_emotion, user_emotion_profile, user_emotion_post, user_level, user_allow_pm, status_offline_text, status_online_text, user_birthday, user_next_birthday_greeting, user_active, user_actkey)
VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $plz) . "', $user_allow_mass_email, $popup_notes, $disallow_profile_search, $user_absence_mode, $user_absence, '" . str_replace("\'", "''", $user_absence_text) . "', $profile_view_popup, '" . str_replace("\'", "''", $vorname) . "', '" . str_replace("\'", "''", $name) . "', '" . str_replace("\'", "''", $strasse) . "', '" . str_replace("\'", "''", $ort) . "', '" . str_replace("\'", "''", $telefon) . "', '" . str_replace("\'", "''", $skype) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $user_startup, $attachsig, $setbm, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, '$statusmail_days', ".time().", '".$board_config['statusmail_viewchars']."', '$gender', '$single', '$emotion', '$emotion_profile', '$emotion_post', 0, 1, " . str_replace("\'", "''", $sig_offline) . "', '" . str_replace("\'", "''", $sig_online) . "', ' '$birthday', '$next_birthday_greeting', ";edit: fehlermeldung nach klick auf absenden:
Code: Alles auswählen
Could not insert data into users table
DEBUG MODE
SQL Error : 1136 Column count doesn't match value count at row 1
INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_plz, user_allow_mass_email, user_popup_notes, disallow_profile_search, user_absence_mode, user_absence, user_absence_text, user_profile_view_popup, user_vorname, user_name, user_strasse, user_ort, user_telefon, user_skype, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_startup, user_attachsig, user_setbm, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, statusmail_days, statusmail_last, statusmail_viewchars, user_gender, user_single, user_emotion, user_emotion_profile, user_emotion_post, user_level, user_allow_pm, status_offline_text, status_online_text, user_birthday, user_next_birthday_greeting, user_active, user_actkey) VALUES (408, 'aaa', 1186579656, '47bce5c74f589f4867dbd57e9ca9f808', 'aaa@a.com', '', '', '', 'aaa', '', '', 0, 0, 0, 1, 0, '', 0, 'aaa', 'aaa', '', '', '', '', '', '', '', 0, 1, '', '', '', 0, 1, 0, 1, 1, 1, 1, 0, 1, 1, 1, 'd.m.Y, H:i', 'german', 10, '7', 1186579656, '300', '0', '0', '0', '1', '1', 0, 1, ', '', ' '999999', '', 0, '70e2b0')
Line : 1064
File : usercp_register.php
