Mfg
Smoker
Problem beim ändern des Profils(MySQL Syntax Fehler)
Forumsregeln
phpBB 2.0 hat das Ende seiner Lebenszeit überschritten
phpBB 2.0 wird nicht mehr aktiv unterstützt. Insbesondere werden - auch bei Sicherheitslücken - keine Patches mehr bereitgestellt. Der Einsatz von phpBB 2.0 erfolgt daher auf eigene Gefahr. Wir empfehlen einen Umstieg auf phpBB 3.1, welches aktiv weiterentwickelt wird und für welches regelmäßig Updates zur Verfügung gestellt werden.
Eine Neuinstallation von phpBB 2.0 wird auf phpBB.de nicht mehr unterstützt.
Siehe auch Entwicklungs-Ende von phpBB 2.0 - Auswirkungen auf phpBB.de
phpBB 2.0 hat das Ende seiner Lebenszeit überschritten
phpBB 2.0 wird nicht mehr aktiv unterstützt. Insbesondere werden - auch bei Sicherheitslücken - keine Patches mehr bereitgestellt. Der Einsatz von phpBB 2.0 erfolgt daher auf eigene Gefahr. Wir empfehlen einen Umstieg auf phpBB 3.1, welches aktiv weiterentwickelt wird und für welches regelmäßig Updates zur Verfügung gestellt werden.
Eine Neuinstallation von phpBB 2.0 wird auf phpBB.de nicht mehr unterstützt.
Siehe auch Entwicklungs-Ende von phpBB 2.0 - Auswirkungen auf phpBB.de
aso schuldige hier is sie:
#
# includes/usercp_register.php
#
#-----[ FINDE ]---------------------------------------------------
#
$strip_var_list = array('username' => 'username', 'email' => 'email', 'icq' => 'icq', 'aim' => 'aim', 'msn' => 'msn', 'yim' => 'yim', 'website' => 'website', 'location' => 'location', 'occupation' => 'occupation', 'interests' => 'interests');
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
'interests'
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, 'music' => 'music'
#
#-----[ FINDE ]---------------------------------------------------
#
validate_optional_fields($icq, $aim, $msn, $yim, $website, $location, $occupation, $interests, $signature);
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
$interests
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, $music
#
#-----[ FINDE ]---------------------------------------------------
#
$interests = stripslashes($interests);
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
$music = stripslashes($music);
#
#-----[ FINDE ]---------------------------------------------------
#
$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_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . "
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
$interests) . "'
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, user_music = '" . str_replace("\'", "''", $music) . "'
#
#-----[ FINDE ]---------------------------------------------------
#
$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_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) . "', " . time() . ", '" . str_replace("\'", "''", $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, $popuppm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
user_interests
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, user_music
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
$interests) . "'
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, '" . str_replace("\'", "''", $music) . "'
#
#-----[ FINDE ]---------------------------------------------------
#
$interests = stripslashes($interests);
#
#-----[ DANACH EINFÜGEN ]---------------------------------------------------
#
$music = stripslashes($music);
#
#-----[ FINDE ]---------------------------------------------------
#
$interests = $userdata['user_interests'];
#
#-----[ DANACH EINFÜGEN ]---------------------------------------------------
#
$music = $userdata['user_music'];
#
#-----[ FINDE ]---------------------------------------------------
#
display_avatar_gallery($mode, $avatar_category, $user_id, $email, $current_email, $coppa, $username, $email, &$new_password, &$cur_password, $password_confirm, $icq, $aim, $msn, $yim, $website, $location, $occupation, $interests, $signature, $viewemail, $notifypm, $popuppm, $notifyreply, $attachsig, $allowhtml, $allowbbcode, $allowsmilies, $allowviewonline, $user_style, $user_lang, $user_timezone, $user_dateformat, $userdata['session_id']);
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
$user_dateformat
#
#-----[ DANACH EINFÜGEN ]---------------------------------------------------
#
, $music
#
#-----[ FINDE (nur ein Auszug, suche nach der letzten Zeile) ]--------------------------
#
$template->assign_vars(array(
.
.
.
.
'INTERESTS' => $interests,
#
#-----[ DANACH EINFÜGEN ]---------------------------------------------------
#
'MUSIC' => $music,
#
#-----[ FINDE ]---------------------------------------------------
#
'L_INTERESTS' => $lang['Interests'],
#
#-----[ DANACH EINFÜGEN ]---------------------------------------------------
#
'L_MUSIC' => $lang['Music'],
#
#-----[ ÖFFNEN ]------------------------------------------
#
# includes/usercp_avatar.php
#
#-----[ FINDE ]---------------------------------------------------
#
function display_avatar_gallery($mode, &$category, &$user_id, &$email, &$current_email, &$coppa, &$username, &$email, &$new_password, &$cur_password, &$password_confirm, &$icq, &$aim, &$msn, &$yim, &$website, &$location, &$occupation, &$interests, &$signature, &$viewemail, &$notifypm, &$popuppm, &$notifyreply, &$attachsig, &$allowhtml, &$allowbbcode, &$allowsmilies, &$hideonline, &$style, &$language, &$timezone, &$dateformat, &$session_id)
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
&$dateformat
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, &$music
#
#-----[ FINDE ]---------------------------------------------------
#
$params = array('coppa', 'user_id', 'username', 'email', 'current_email', 'icq', 'aim', 'msn', 'yim', 'website', 'location', 'occupation', 'interests', 'signature', 'viewemail', 'notifypm', 'popuppm', 'notifyreply', 'attachsig', 'allowhtml', 'allowbbcode', 'allowsmilies', 'hideonline', 'style', 'language', 'timezone', 'dateformat');
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
'dateformat'
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, 'music'
#
#-----[ ÖFFNEN ]------------------------------------------
#
# includes/usercp_register.php
#
#-----[ FINDE ]---------------------------------------------------
#
$strip_var_list = array('username' => 'username', 'email' => 'email', 'icq' => 'icq', 'aim' => 'aim', 'msn' => 'msn', 'yim' => 'yim', 'website' => 'website', 'location' => 'location', 'occupation' => 'occupation', 'interests' => 'interests');
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
'interests'
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, 'music' => 'music'
#
#-----[ FINDE ]---------------------------------------------------
#
validate_optional_fields($icq, $aim, $msn, $yim, $website, $location, $occupation, $interests, $signature);
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
$interests
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, $music
#
#-----[ FINDE ]---------------------------------------------------
#
$interests = stripslashes($interests);
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
$music = stripslashes($music);
#
#-----[ FINDE ]---------------------------------------------------
#
$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_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . "
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
$interests) . "'
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, user_music = '" . str_replace("\'", "''", $music) . "'
#
#-----[ FINDE ]---------------------------------------------------
#
$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_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) . "', " . time() . ", '" . str_replace("\'", "''", $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, $popuppm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
user_interests
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, user_music
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
$interests) . "'
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, '" . str_replace("\'", "''", $music) . "'
#
#-----[ FINDE ]---------------------------------------------------
#
$interests = stripslashes($interests);
#
#-----[ DANACH EINFÜGEN ]---------------------------------------------------
#
$music = stripslashes($music);
#
#-----[ FINDE ]---------------------------------------------------
#
$interests = $userdata['user_interests'];
#
#-----[ DANACH EINFÜGEN ]---------------------------------------------------
#
$music = $userdata['user_music'];
#
#-----[ FINDE ]---------------------------------------------------
#
display_avatar_gallery($mode, $avatar_category, $user_id, $email, $current_email, $coppa, $username, $email, &$new_password, &$cur_password, $password_confirm, $icq, $aim, $msn, $yim, $website, $location, $occupation, $interests, $signature, $viewemail, $notifypm, $popuppm, $notifyreply, $attachsig, $allowhtml, $allowbbcode, $allowsmilies, $allowviewonline, $user_style, $user_lang, $user_timezone, $user_dateformat, $userdata['session_id']);
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
$user_dateformat
#
#-----[ DANACH EINFÜGEN ]---------------------------------------------------
#
, $music
#
#-----[ FINDE (nur ein Auszug, suche nach der letzten Zeile) ]--------------------------
#
$template->assign_vars(array(
.
.
.
.
'INTERESTS' => $interests,
#
#-----[ DANACH EINFÜGEN ]---------------------------------------------------
#
'MUSIC' => $music,
#
#-----[ FINDE ]---------------------------------------------------
#
'L_INTERESTS' => $lang['Interests'],
#
#-----[ DANACH EINFÜGEN ]---------------------------------------------------
#
'L_MUSIC' => $lang['Music'],
#
#-----[ ÖFFNEN ]------------------------------------------
#
# includes/usercp_avatar.php
#
#-----[ FINDE ]---------------------------------------------------
#
function display_avatar_gallery($mode, &$category, &$user_id, &$email, &$current_email, &$coppa, &$username, &$email, &$new_password, &$cur_password, &$password_confirm, &$icq, &$aim, &$msn, &$yim, &$website, &$location, &$occupation, &$interests, &$signature, &$viewemail, &$notifypm, &$popuppm, &$notifyreply, &$attachsig, &$allowhtml, &$allowbbcode, &$allowsmilies, &$hideonline, &$style, &$language, &$timezone, &$dateformat, &$session_id)
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
&$dateformat
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, &$music
#
#-----[ FINDE ]---------------------------------------------------
#
$params = array('coppa', 'user_id', 'username', 'email', 'current_email', 'icq', 'aim', 'msn', 'yim', 'website', 'location', 'occupation', 'interests', 'signature', 'viewemail', 'notifypm', 'popuppm', 'notifyreply', 'attachsig', 'allowhtml', 'allowbbcode', 'allowsmilies', 'hideonline', 'style', 'language', 'timezone', 'dateformat');
#
#-----[ FINDE in dieser Zeile ]---------------------------------------------------
#
'dateformat'
#
#-----[ DANACH EINFUEGEN ]---------------------------------------------------
#
, 'music'
#
#-----[ ÖFFNEN ]------------------------------------------
