was mich verwirrt an der Sache (Value sollte doch der reihenfolge entsprechen?):
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("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";
und das ist die Reihenfolge in der DB, was aber nicht mit den VALUE Werten übereinstimmt (z.B. nach website kommt occupation, bei den value werten kommt aber nach website user_from):
user_id user_active username user_password
user_session_time user_session_page user_lastvisit user_regdate user_level user_posts user_timezone user_style user_lang user_dateformat user_new_privmsg user_unread_privmsg user_last_privmsg user_emailtime user_viewemail user_attachsig user_allowhtml user_allowbbcode user_allowsmile user_allowavatar user_allow_pm user_allow_viewonline user_notify user_notify_pm user_popup_pm user_rank user_avatar user_avatar_type user_email user_icq user_website user_from user_sig user_sig_bbcode_uid user_aim user_yim user_msnm user_occ user_interests user_actkey user_newpasswd user_gender user_birthday user_next_birthday_greeting user_photo user_photo_type user_profile_visits user_reminded
