Custom title error

[Leipo]

Bennik weer een keer met een vraag

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).'\'' : '';

Is wat ik volgens de install.txt zou moeten doen.
Maar doe ik dat krijg ik....

Could not update users table

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

Vond het al zo "gaar" dat je zomaar ergens in een lijn alleen $user_rank moet zetten.

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 . " 

Zo ziet mijn 'code er dus uit..

[Podium4]

Vind:

Code: Selecteer alles

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

Vervang met:

Code: Selecteer alles

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

Heb de mod zelf ook op hotrid.nl geinstalleerd en vond het ook al vreemd, maar het klopt wel!

[Leipo]

Oef, dat stuk was in ieder geval goed
Helaas kreeg ik nog geen 3 seconden erna weer een nieuwe error.

Code: Selecteer alles

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

De zin..

Code: Selecteer alles

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

De bovenste..

[Leipo]

Pff.. file al 2 keer gemod maar de error blijft terug komen!
Net een mes in men rug, probleem is dat ik eigenlijk al Maandag het forum klaar zou hebben en dat kan niet met die error