Code: Selecteer alles
Could not update users table
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near ' user_timezone = 0, user_dateformat = 'd/m/y - H:i', user_lang = 'dutch', user_s' at line 2
UPDATE lotr_users SET user_email = 'mail@jivisstudios.nl', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 0, 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/y - H:i', user_lang = 'dutch', user_style = 1, user_active = 1, user_actkey = '', user_selected_rank = 0 WHERE user_id = 2
Line : 461
File : /storage/hosted/jivisstudios.nl/WWW/lotr/forum/includes/usercp_register.phpIk gebruik nu phpbb 2.06 en die mod is voor phpbb 2.04, misschien dat het daar aan ligt?
Dit is de installatie file van de mod:
Code: Selecteer alles
###############################################
## Hack Title: User Select Ranks
## Hack Version: 2.5.0
## Author: Antony Bailey
## Description: Allows a user to select a rank.
## Compatibility: 2.0.4
##
## Installation Level: UbërDifficult
## Installation Time: 120 minutes.
## Files To Edit: 13
## admin_ranks.php
## admin_users.php
## usercp_register.php
## usercp_avatar.php
## usercp_viewprofile.php
## viewtopic.php
## ranks_edit_body.tpl
## user_edit_body.tpl
## profile_add_body.tpl
## profile_view_body.tpl
## viewtopic_body.tpl
## lang_admin.php
## lang_main.php
##
## History:
## 1.0.0: Project started.
## 2.0.0: SQL added. Oooops!
## 2.5.0:
##
## Author Notes:
## Oh God, this was horrible. :(
##
## Support: http://www.phpbbhacks.com/forums
## Copyright: ©2003 User Select Rank 2.5.0 - Antony Bailey
##
###############################################
## You downloaded this hack from phpBBHacks.com, the #1 source for phpBB related downloads.
## Please visit http://www.phpbbhacks.com/forums for support.
###############################################
##
###############################################
## This hack is released under the GPL License.
## This hack can be freely used, but not distributed, without permission.
## Intellectual Property is retained by the hack author(s) listed above.
###############################################
#
#-----[ OPEN ]----------------------------------------------------------------
#
admin/admin_ranks.php
#
#-----[ FIND ]----------------------------------------------------------------
#
$rank_info['rank_special'] = 0;
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
$rank_info['rank_user'] = 0;
#
#-----[ FIND ]----------------------------------------------------------------
#
$rank_is_not_special = ( !$rank_info['rank_special'] ) ? "checked=\"checked\"" : "";
#
#-----[ AFTER, ADD ]----------------------------------------------------
#
$rank_is_user = ( $rank_info['rank_user'] ) ? "checked=\"checked\"" : "";
$rank_is_not_user = ( !$rank_info['rank_user'] ) ? "checked=\"checked\"" : "";
#
#-----[ FIND ]----------------------------------------------------------------
#
"NOT_SPECIAL_RANK" => $rank_is_not_special,
#
#-----[ AFTER, ADD ]----------------------------------------------------
#
"USER_RANK" => $rank_is_user,
"NOT_USER_RANK" => $rank_is_not_user,
#
#-----[ FIND ]----------------------------------------------------------------
#
"L_RANK_SPECIAL" => $lang['Rank_special'],
#
#-----[ AFTER, ADD ]----------------------------------------------------
#
"L_RANK_USER" => $lang['Rank_user'],
#
#-----[ FIND ]----------------------------------------------------------------
#
$special_rank = ( $HTTP_POST_VARS['special_rank'] == 1 ) ? TRUE : 0;
#
#-----[ AFTER, ADD ]----------------------------------------------------
#
$user_rank = ( $HTTP_POST_VARS['user_rank'] == 1 ) ? TRUE : 0;
#
#-----[ FIND ]----------------------------------------------------------------
#
SET rank_title = '" . str_replace("\'", "''", $rank_title) . "', rank_special = $special_rank, rank_min = $min_posts, rank_image = '" . str_replace("\'", "''", $rank_image) . "'
#
#-----[ REPLACE WITH ]----------------------------------------------------
#
SET rank_title = '" . str_replace("\'", "''", $rank_title) . "', rank_special = $special_rank, rank_min = $min_posts, rank_image = '" . str_replace("\'", "''", $rank_image) . "', rank_user = $user_rank
#
#-----[ FIND ]----------------------------------------------------------------
#
$sql = "INSERT INTO " . RANKS_TABLE . " (rank_title, rank_special, rank_min, rank_image)
VALUES ('" . str_replace("\'", "''", $rank_title) . "', $special_rank, $min_posts, '" . str_replace("\'", "''", $rank_image) . "')";
#
#-----[ REPLACE WITH ]----------------------------------------------------
#
$sql = "INSERT INTO " . RANKS_TABLE . " (rank_title, rank_special, rank_min, rank_image, rank_user)
VALUES ('" . str_replace("\'", "''", $rank_title) . "', $special_rank, $min_posts, '" . str_replace("\'", "''", $rank_image) . "', $user_rank)";
#
#-----[ FIND ]----------------------------------------------------------------
#
"L_SPECIAL_RANK" => $lang['Special_rank'],
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
"L_USER_RANK" => $lang['Rank_user'],
#
#-----[ FIND ]----------------------------------------------------------------
#
$special_rank = $rank_rows[$i]['rank_special'];
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
$user_rank = $rank_rows[$i]['rank_user'];
#
#-----[ FIND ]----------------------------------------------------------------
#
"SPECIAL_RANK" => ( $special_rank == 1 ) ? $lang['Yes'] : $lang['No'],
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
"USER_RANK" => ( $user_rank == 1 ) ? $lang['Yes'] : $lang['No'],
#
#-----[ FIND ]----------------------------------------------------------------
#
"L_SPECIAL_RANK" => $lang['Rank_special'],
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
"L_USER_RANK" => $lang['Rank_user'],
#
#-----[ FIND ]----------------------------------------------------------------
#
$special_rank = $rank_rows[$i]['rank_special'];
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
$user_rank = $rank_rows[$i]['rank_user'];
#
#-----[ FIND ]----------------------------------------------------------------
#
$rank_is_special = ( $special_rank ) ? $lang['Yes'] : $lang['No'];
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
$rank_is_user = ( $user_rank ) ? $lang['Yes'] : $lang['No'];
#
#-----[ FIND ]----------------------------------------------------------------
#
"SPECIAL_RANK" => $rank_is_special,
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
"USER_RANK" => $rank_is_user,
#
#-----[ OPEN ]----------------------------------------------------------------
#
admin/admin_users.php
#
#-----[ FIND ]----------------------------------------------------------------
#
$interests = ( !empty($HTTP_POST_VARS['interests']) ) ? trim(strip_tags( $HTTP_POST_VARS['interests'] ) ) : '';
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
$user_selected_rank = ( !empty($HTTP_POST_VARS['user_selected_rank']) ) ? intval( $HTTP_POST_VARS['user_selected_rank'] ) : 0;
#
#-----[ 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_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_sig_bbcode_uid = '$signature_bbcode_uid', user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowavatar = $user_allowavatar, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_allow_pm = $user_allowpm, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_active = $user_status, user_rank = $user_rank " . $avatar_sql . "
#
#-----[ REPLACE WITH ]----------------------------------------------------------
#
$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_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_sig_bbcode_uid = '$signature_bbcode_uid', user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowavatar = $user_allowavatar, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_allow_pm = $user_allowpm, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_active = $user_status, user_rank = $user_rank, user_selected_rank = $user_selected_rank " . $avatar_sql . "
## Note: Adding Inline: , user_selected_rank = $user_selected_rank
#
#-----[ FIND ]----------------------------------------------------------------
#
$s_hidden_fields .= '<input type="hidden" name="interests" value="' . str_replace("\"", "&", $interests) . '" />';
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
$s_hidden_fields .= '<input type="hidden" name="user_selected_rank" value="' . $user_selected_rank . '" />';
#
#-----[ FIND ]----------------------------------------------------------------
#
$sql = "SELECT * FROM " . RANKS_TABLE . "
#
#-----[ BEFORE, ADD ]----------------------------------------------------------
#
$sql = "SELECT * FROM " . RANKS_TABLE . "
WHERE rank_user = 1
ORDER BY rank_title";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain user ranks data', '', __LINE__, __FILE__, $sql);
}
$user_rank_select_box = '<option value="0">' . $lang['No_user_selected_rank'] . '</option>';
while( $row = $db->sql_fetchrow($result) )
{
$rank = $row['rank_title'];
$rank_id = $row['rank_id'];
$selected = ( $this_userdata['user_selected_rank'] == $rank_id ) ? ' selected="selected"' : '';
$user_rank_select_box .= '<option value="' . $rank_id . '"' . $selected . '>' . $rank . '</option>';
}
#
#-----[ FIND ]----------------------------------------------------------------
#
'INTERESTS' => $interests,
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
'USER_RANK_SELECT_BOX' => $user_rank_select_box,
#
#-----[ FIND ]----------------------------------------------------------------
#
'L_INTERESTS' => $lang['Interests'],
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
'L_USER_SELECTED_RANK' => $lang['User_selected_rank'],
#
#-----[ OPEN ]----------------------------------------------------------------
#
includes/usercp_register.php
#
#-----[ FIND ]----------------------------------------------------------------
#
$signature = str_replace('<br />', "\n", $signature);
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
$user_selected_rank = ( isset($HTTP_POST_VARS['user_selected_rank']) ) ? intval( $HTTP_POST_VARS['user_selected_rank'] ) : 0;
#
#-----[ 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("\'", "''", 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 . "
#
#-----[ REPLACE WITH ]--------------------------------------------------------
#
$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 . ", user_selected_rank = $user_selected_rank
#
#
#-----[ FIND ]----------------------------------------------------------------
#
$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)
#
#-----[ REPLACE WITH ]--------------------------------------------------------
#
$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_selected_rank, user_active, user_actkey)
#
#
#-----[ FIND ]----------------------------------------------------------------
#
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,";
#
#-----[ REPLACE, WITH ]----------------------------------------------------------
#
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, $user_selected_rank,";
#
#
#-----[ FIND ]----------------------------------------------------------------
#
$interests = $userdata['user_interests'];
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
$user_selected_rank = $userdata['user_selected_rank'];
#
#-----[ FIND ]----------------------------------------------------------------
#
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']);
#
#-----[ REPLACE WITH ]--------------------------------------------------------
#
display_avatar_gallery($mode, $avatar_category, $user_id, $email, $current_email, $coppa, $username, $email, $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, $user_selected_rank, $userdata['session_id']);
#
#
#-----[ FIND ]----------------------------------------------------------------
#
$smilies_status = ( $userdata['user_allowsmile'] && $board_config['allow_smilies'] ) ? $lang['Smilies_are_ON'] : $lang['Smilies_are_OFF'];
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
$sql = "SELECT * FROM " . RANKS_TABLE . "
WHERE rank_user = 1
ORDER BY rank_title";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain user ranks data', '', __LINE__, __FILE__, $sql);
}
$user_rank_select_box = '<option value="0">' . $lang['No_user_selected_rank'] . '</option>';
while( $row = $db->sql_fetchrow($result) )
{
$rank = $row['rank_title'];
$rank_id = $row['rank_id'];
$selected = ( $user_selected_rank == $rank_id ) ? ' selected="selected"' : '';
$user_rank_select_box .= '<option value="' . $rank_id . '"' . $selected . '>' . $rank . '</option>';
}
#
#-----[ FIND ]----------------------------------------------------------------
#
'INTERESTS' => $interests,
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
'USER_RANK_SELECT_BOX' => $user_rank_select_box,
#
#-----[ FIND ]----------------------------------------------------------------
#
'L_INTERESTS' => $lang['Interests'],
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
'L_USER_SELECTED_RANK' => $lang['User_selected_rank'],
#
#-----[ OPEN ]----------------------------------------------------------------
#
includes/usercp_avatar.php
#
#-----[ FIND ]----------------------------------------------------------------
#
function display_avatar_gallery($mode, &$category, &$user_id, &$email, &$current_email, &$coppa, &$username, &$email, &$icq, &$aim, &$msn, &$yim, &$website, &$location, &$occupation, &$interests, &$signature, &$viewemail, &$notifypm, &$popuppm, &$notifyreply, &$attachsig, &$allowhtml, &$allowbbcode, &$allowsmilies, &$allowviewonline, &$style, &$language, &$timezone, &$dateformat)
#
#-----[ REPLACE WITH ]--------------------------------------------------------
#
function display_avatar_gallery($mode, &$category, &$user_id, &$email, &$current_email, &$coppa, &$username, &$email, &$icq, &$aim, &$msn, &$yim, &$website, &$location, &$occupation, &$interests, &$signature, &$viewemail, &$notifypm, &$popuppm, &$notifyreply, &$attachsig, &$allowhtml, &$allowbbcode, &$allowsmilies, &$allowviewonline, &$style, &$language, &$timezone, &$dateformat, &$user_selected_rank)
#
#
#-----[ FIND ]----------------------------------------------------------------
#
$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', 'allowviewonline', 'style', 'language', 'timezone', 'dateformat');
#
#-----[ REPLACE WITH ]--------------------------------------------------------
#
$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', 'allowviewonline', 'style', 'language', 'timezone', 'dateformat', 'user_selected_rank');
#
#-----[ OPEN ]----------------------------------------------------------------
#
includes/usercp_viewprofile.php
#
#-----[ FIND ]----------------------------------------------------------------
#
//
// Generate page
#
#-----[ BEFORE, ADD ]---------------------------------------------------------
#
$poster_selected_rank = '';
$poster_selected_rank_image = '';
if ($profiledata['user_selected_rank'])
{
for($i = 0; $i < count($ranksrow); $i++)
{
if ( $profiledata['user_selected_rank'] == $ranksrow[$i]['rank_id'] && $ranksrow[$i]['rank_user'] )
{
$poster_selected_rank = $ranksrow[$i]['rank_title'];
$poster_selected_rank_image = ( $ranksrow[$i]['rank_image'] ) ? '<img src="' . $ranksrow[$i]['rank_image'] . '" alt="' . $poster_selected_rank . '" title="' . $poster_selected_rank . '" border="0" />' : '';
}
}
}
#
#-----[ FIND ]----------------------------------------------------------------
#
'INTERESTS' => ( $profiledata['user_interests'] ) ? $profiledata['user_interests'] : '&',
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
'USER_SELECTED_RANK' => $poster_selected_rank,
'USER_SELECTED_RANK_IMAGE' => $poster_selected_rank_image,
#
#-----[ FIND ]----------------------------------------------------------------
#
'L_INTERESTS' => $lang['Interests'],
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
'L_USER_SELECTED_RANK' => $lang['User_selected_rank'],
#
#-----[ OPEN ]----------------------------------------------------------------
#
viewtopic.php
#
#-----[ FIND ]----------------------------------------------------------------
#
$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid
#
#-----[ REPLACE WITH ]--------------------------------------------------------
#
$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_selected_rank, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid
#
#
#-----[ FIND ]----------------------------------------------------------------
#
//
// Handle anon users posting with usernames
#
#-----[ BEFORE, ADD ]---------------------------------------------------------
#
$poster_selected_rank = '';
$poster_selected_rank_image = '';
if ($postrow[$i]['user_selected_rank'])
{
for($j = 0; $j < count($ranksrow); $j++)
{
if ( $postrow[$i]['user_selected_rank'] == $ranksrow[$j]['rank_id'] && $ranksrow[$j]['rank_user'] )
{
$poster_selected_rank = $ranksrow[$j]['rank_title'];
$poster_selected_rank_image = ( $ranksrow[$j]['rank_image'] ) ? '<img src="' . $ranksrow[$j]['rank_image'] . '" alt="' . $poster_selected_rank . '" title="' . $poster_selected_rank . '" border="0" />' : '';
}
}
}
#
#-----[ FIND ]----------------------------------------------------------------
#
'POSTER_RANK' => $poster_rank,
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
'POSTER_SELECTED_RANK' => $poster_selected_rank,
'POSTER_SELECTED_RANK_IMAGE' => $poster_selected_rank_image,
'L_USER_SELECTED_RANK' => $lang['User_selected_rank'],
#
#-----[ OPEN ]----------------------------------------------------------------
#
templates/subSilver/admin/ranks_edit_body.tpl
#
#-----[ FIND ]----------------------------------------------------------------
#
<td class="row2"><input type="radio" name="special_rank" value="1" {SPECIAL_RANK} />{L_YES} &&<input type="radio" name="special_rank" value="0" {NOT_SPECIAL_RANK} /> {L_NO}</td>
</tr>
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
<tr>
<td class="row1"><span class="gen">{L_RANK_USER}</span></td>
<td class="row2"><input type="radio" name="user_rank" value="1" {USER_RANK} />{L_YES} &&<input type="radio" name="user_rank" value="0" {NOT_USER_RANK} /> {L_NO}</td>
</tr>
#
#-----[ OPEN ]----------------------------------------------------------------
#
templates/subSilver/admin/ranks_list_body.tpl
#
#-----[ FIND ]----------------------------------------------------------------
#
<th class="thTop">{L_SPECIAL_RANK}</th>
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
<th class="thTop">{L_USER_RANK}</th>
#
#-----[ FIND ]----------------------------------------------------------------
#
<td class="{ranks.ROW_CLASS}" align="center">{ranks.SPECIAL_RANK}</td>
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
<td class="{ranks.ROW_CLASS}" align="center">{ranks.USER_RANK}</td>
#
#-----[ FIND ]----------------------------------------------------------------
#
<td class="catBottom" align="center" colspan="6"><input type="submit" class="mainoption" name="add" value="{L_ADD_RANK}" /></td>
#
#-----[ REPLACE WITH ]--------------------------------------------------------
#
<td class="catBottom" align="center" colspan="7"><input type="submit" class="mainoption" name="add" value="{L_ADD_RANK}" /></td>
#
#-----[ OPEN ]----------------------------------------------------------------
#
templates/subSilver/admin/user_edit_body.tpl
#
#-----[ FIND ]----------------------------------------------------------------
#
<tr>
<td class="row1"><span class="gen">{L_INTERESTS}</span></td>
<td class="row2">
<input type="text" name="interests" size="35" maxlength="150" value="{INTERESTS}" />
</td>
</tr>
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
<tr>
<td class="row1"><span class="gen">{L_USER_SELECTED_RANK}</span></td>
<td class="row2"><select name="user_selected_rank">{USER_RANK_SELECT_BOX}</select></td>
</tr>
#
#-----[ OPEN ]----------------------------------------------------------------
#
templates/subSilver/profile_add_body.tpl
#
#-----[ FIND ]----------------------------------------------------------------
#
<tr>
<td class="row1"><span class="gen">{L_INTERESTS}:</span></td>
<td class="row2">
<input type="text" class="post"style="width: 200px" name="interests" size="35" maxlength="150" value="{INTERESTS}" />
</td>
</tr>
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
<tr>
<td class="row1"><span class="gen">{L_USER_SELECTED_RANK}</span></td>
<td class="row2"><select name="selected_rank">{USER_RANK_SELECT_BOX}</select></td>
</tr>
#
#-----[ OPEN ]----------------------------------------------------------------
#
templates/subSilver/profile_view_body.tpl
#
#-----[ FIND ]----------------------------------------------------------------
#
<tr>
<td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_INTERESTS}:</span></td>
<td> <b><span class="gen">{INTERESTS}</span></b></td>
</tr>
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
<tr>
<td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_USER_SELECTED_RANK}:</span></td>
<td> <b><span class="gen">{USER_SELECTED_RANK} {USER_SELECTED_RANK_IMAGE}</span></b></td>
</tr>
#
#-----[ OPEN ]----------------------------------------------------------------
#
templates/subSilver/viewtopic_body.tpl
#
#-----[ FIND ]----------------------------------------------------------------
#
{postrow.POSTER_AVATAR}<br /><br />
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
{postrow.L_USER_SELECTED_RANK}: {postrow.POSTER_SELECTED_RANK} {postrow.POSTER_SELECTED_RANK_IMAGE}<br />
#
#-----[ OPEN ]----------------------------------------------------------------
#
language/lang_english/lang_admin.php
#
#-----[ FIND ]----------------------------------------------------------------
#
$lang['Rank_special'] = "Set as Special Rank";
#
#-----[ AFTER, ADD ]----------------------------------------------------------
#
$lang['Rank_user'] = "User Selectable Rank";
#
#-----[ OPEN ]----------------------------------------------------------------
#
language/lang_english/lang_main.php
#
#-----[ FIND ]----------------------------------------------------------------
#
//
// That's all Folks!
#
#-----[ BEFORE, ADD ]----------------------------------------------------------
#
$lang['No_user_selected_rank'] = "No user selected rank";
$lang['User_selected_rank'] = "User selected rank";
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------------
#
#
#-----[ SQL ]-----------------------------------------------------
#
ALTER TABLE phpbb_ranks ADD rank_user TINYINT(1) DEFAULT '0';
ALTER TABLE phpbb_users ADD user_selected_rank INT(11) DEFAULT '0';
#
# EoM