3. Place the included title_install.php into your root phpBB directory, and then
run it. This will make the necessary database alterations. When it has
completed, make sure it didn't report any errors, and then delete the file.
WARNING: FAILURE TO DELETE THIS FILE MAY PUT YOUR FORUM, SITE, AND SERVER AT
A POTENTIAL SECURITY RISK.
Could not update users table
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_allowbbcode = 1, user_allow_viewonline = 1, user_notify =
UPDATE phpbb_users SET user_email = '[email protected]', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_custom_title = 'Owner and Resident Superhero', user_sig = '[img:90b13fd7cf]http://card.mygamercard.net/gelsig/blue/bcharlt1.png[/img:90b13fd7cf] [img:90b13fd7cf]http://img340.imageshack.us/img340/836/cmpunkoo1.jpg[/img:90b13fd7cf] [img:90b13fd7cf]http://img528.imageshack.us/img528/8040 ... edykb8.jpg[/img:90b13fd7cf]', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_sig_bbcode_uid = '90b13fd7cf', user_allowsmile = 1, user_allowhtml = 0, user_allowavatar = , user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_allow_pm = , user_notify_pm = 1, games_block_pm = , user_birthday = 01081978, user_allowdesc = '', user_allowmoddesc = '', user_showdescriptions = '1', user_showtooltips = '1', user_tooltips_parse = '1', user_tooltips_static = '0', user_toolimg_width = '250', user_toolimg_height = '250', user_popup_pm = , user_lang = 'english', user_style = 1, user_timezone = -5, user_dateformat = 'd M Y h:i a', user_active = , user_rank = WHERE user_id = 2
Line : 622
File : usercp_register.php
#-----[ FIND ]------------------------------------------
#
$signature = str_replace('
#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Verify the user is allowed to alter their custom title. If not, replace it with their old one.
if ($custom_title_activated == FALSE)
{
$custom_title = addslashes($userdata['user_custom_title']);
}
// Check the length of the custom title. Prevents people from editing the HTML to get a longer one.
if (strlen($custom_title) > $board_config['custom_title_maxlength'])
{
if ($custom_title != addslashes($userdata['user_custom_title'])) {
$custom_title = addslashes($userdata['user_custom_title']);
$error = TRUE;
if (isset($error_msg)) $error_msg .= '<br />';
$error_msg .= $lang['Custom_title_toolong'];
}
}
if ($custom_title != addslashes($userdata['user_custom_title'])) {
$custom_title = addslashes($userdata['user_custom_title']);
$error = TRUE;
if (isset($error_msg)) $error_msg .= '<br />';
$error_msg .= $lang['Custom_title_toolong'];
}
}
$signature = (isset($signature)) ? str_replace('<br />', "\n", $signature) : '';
$signature_bbcode_uid = '';
Strange, i just downloaded a copy and i found the file /includes/usercp_register.php...HobbyIllustrator wrote:Negative. In a freshly downloaded phpBB2's "included" folder, there is no usercp_register.php file.