habe mich gestern daran gemacht neue Profilfelder (4Stück) einzubauen, was aber abschließend nicht 100%ig funktioniert hat. Hier meine Probleme:
Bei der Registrierung: Could not insert data into user table
Hier der Code (erste Zeile = 626, letzte Zeile = 643)INSERT INTO users (user_id, username, user_forename, user_surname, user_regdate, user_password, user_email, user_icq, user_website, user_company, user_house, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, 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, user_level, user_allow_pm, user_active, user_actkey) VALUES (32, 'Martin2', 'Martin', '****', '*****', '****', '****', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 1, 'd.m.Y, H:i', 'german', 2, 0, 1, 0, '****')
Line : 643
File : usercp_register.php
Code: Alles auswählen
$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_forename, user_surname, user_regdate, user_password, user_email, user_icq, user_website, user_company, user_house, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, 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, user_level, user_allow_pm, user_active, user_actkey)
VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', '" . str_replace("\'", "''", $forename) . "', '" . str_replace("\'", "''", $surname) . "', '" . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $company) . "', '" . str_replace("\'", "''", $house) . "', '" . 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, ";
if ( $board_config['require_activation'] == USER_ACTIVATION_SELF || $board_config['require_activation'] == USER_ACTIVATION_ADMIN || $coppa )
{
$user_actkey = gen_rand_string(true);
$key_len = 54 - (strlen($server_url));
$key_len = ( $key_len > 6 ) ? $key_len : 6;
$user_actkey = substr($user_actkey, 0, $key_len);
$sql .= "0, '" . str_replace("\'", "''", $user_actkey) . "')";
}
else
{
$sql .= "1, '')";
}
if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) )
{
message_die(GENERAL_ERROR, 'Could not insert data into users table', '', __LINE__, __FILE__, $sql);
Mein zweites Problem: Wenn ich die neuen Felder aktualisier, werden die Aktualisierungen auch in Datenbank eingetragen, aber beim erneuten anschauen des eigenen Profils nicht gezeigt. Wenn ich mir das Profil als "Fremder" anschaue, ist das wieder kein Problem.
Das sind zumindest die Fehler, die ich bisher gefunden hab.
Vielen Dank im Voraus!
