phpBB.nl

Code: Selecteer alles

# 
#-----[ FIND ]---------------------------------------------------
# 
$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("\'", "''", $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 . " 

# 
#-----[ IN-LINE FIND ]---------------------------------------------------
# 
user_interests = '" . str_replace("\'", "''", $interests) . "'

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
$user_title

# 
#-----[ IN-LINE FIND ]---------------------------------------------------
# 
$sql = "UPDATE " . USERS_TABLE . " 

# 
#-----[ ABOVE, ADD ]---------------------------------------------------
# 
$user_title = ( $allow_custom_rank ) ? ', user_custom_rank = \''.str_replace("\'", "''", $custom_rank).'\'' : '';

Code: Selecteer alles

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' user_timezone = 0, user_dateformat = 'D M d, Y g:i a', user_la

UPDATE phpbb_users SET user_email = 'venom_mohaa@hotmail.com', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = , user_timezone = 0, user_dateformat = 'D M d, Y g:i a', user_lang = 'english' , user_style = 2, user_active = 1, user_actkey = '', no_report_popup = 0, no_report_mail = 0 WHERE user_id = 4

Line : 540
File : /home/wwwxtra/public_html/IronicArt/includes/usercp_register.php

Code: Selecteer alles

$user_title = ( $allow_custom_rank ) ? ', user_custom_rank = \''.str_replace("\'", "''", $custom_rank).'\'' : '';
			$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_title, user_sig = '" . str_replace("\'", "''", $signature) . "', user_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '" . 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_lang = '" . str_replace("\'", "''", $user_lang) . "' , user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . " 

Code: Selecteer alles

user_interests = '" . str_replace("\'", "''", $interests) . "', $user_title, user_sig =

Code: Selecteer alles

user_interests = '" . str_replace("\'", "''", $interests) . "'$user_title, user_sig =

Code: Selecteer alles

Parse error: parse error, unexpected ')' in /home/wwwxtra/public_html/IronicArt/includes/usercp_register.php on line 536

Code: Selecteer alles

$user_title = ( $allow_custom_rank ) ? ', user_custom_rank = \''.str_replace("\'", "''", $custom_rank).'\'' : '';
			$sql = "UPDATE " . USERS_TABLE . "