gamertag from phpbb to integraMOD [Solved]

Your phpBB Version: 2.0.
phpBB Type: Integramod 141
MODs: No
Your knowledge: Beginner
Board URL: http://gamerzreunite.com
PHP Version:
MySQL Version:
What was done before the problem appeared?
na
What was done to try to solve the problem?
na
De.scription and Message
`Anyone know how to convert this code to work with IM141?
Would be very greatfull if you could help out <img>
phpBB Type: Integramod 141
MODs: No
Your knowledge: Beginner
Board URL: http://gamerzreunite.com
PHP Version:
MySQL Version:
What was done before the problem appeared?
na
What was done to try to solve the problem?
na
De.scription and Message
`Anyone know how to convert this code to work with IM141?
Would be very greatfull if you could help out <img>
- Code: Select all
########################################################################################### ## Mod Title]http://www.xbox-forums.com/[/url] please visit.############################################################################################### Versions:#### 1.0.1 #############################################################################################-----[ SQL ]-------------------------------------------# # First execute the following sql query via phpmyadmin. ALTER TABLE phpbb_users ADD user_gamertag VARCHAR(255) AFTER user_interests; ############################################################################################ #-----[ OPEN ]------------------------------------------ # # language/lang_english/lang_main.php# #-----[ FIND ]---------------------------------------------------# $lang['Interests'] = 'Interests'; # #-----[ BELOW ADD ]---------------------------------------------------# $lang['Gamertag'] = 'Gamertag'; # #-----[ OPEN ]------------------------------------------ # # includes/usercp_viewprofile.php# #-----[ FIND ]---------------------------------------------------# 'INTERESTS' => ( $profiledata['user_interests'] ) ? $profiledata['user_interests'] : ' ', # #-----[ BELOW ADD ]---------------------------------------------------# 'GAMERTAG' => ( $profiledata['user_gamertag'] ) ? $profiledata['user_gamertag'] : ' ','L_GAMERTAG' => $lang['Gamertag'], # #-----[ OPEN ]------------------------------------------ # # includes/usercp_register.php# #-----[ FIND ]---------------------------------------------------# $strip_var_list = array('username' => 'username', 'email' => 'email', 'icq' => 'icq', 'aim' => 'aim', 'msn' => 'msn', 'yim' => 'yim', 'website' => 'website', 'location' => 'location', 'occupation' => 'occupation', 'interests' => 'interests'); # #-----[ IN-LINE FIND ]---------------------------------------------------# 'interests' # #-----[ IN-LINE ADD ]---------------------------------------------------# , 'gamertag' => 'gamertag' # #-----[ FIND ]---------------------------------------------------# $interests = stripslashes($interests); # #-----[ BELOW ADD ]---------------------------------------------------# $gamertag = stripslashes($gamertag); # #-----[ FIND AGAIN]---------------------------------------------------# $interests = stripslashes($interests); # #-----[ BELOW ADD ]---------------------------------------------------# $gamertag = stripslashes($gamertag); # #-----[ FIND ]---------------------------------------------------# $sql = "UPDATE " . USERS_TABLE . " # #-----[ IN-LINE FIND ]---------------------------------------------------# $interests) . "' # #-----[ IN-LINE ADD ]---------------------------------------------------# , user_gamertag = '" . str_replace("'", "''", $gamertag) . "' # #-----[ FIND ]---------------------------------------------------# $sql = "INSERT INTO " . USERS_TABLE . " # #-----[ IN-LINE FIND ]---------------------------------------------------# user_interests # #-----[ IN-LINE ADD ]---------------------------------------------------# , user_gamertag # #-----[ IN-LINE FIND ]---------------------------------------------------# $interests) . "' # #-----[ IN-LINE ADD ]---------------------------------------------------# , '" . str_replace("'", "''", $gamertag) . "' # #-----[ FIND ]---------------------------------------------------# $interests = $userdata['user_interests']; # #-----[ BELOW ADD ]---------------------------------------------------# $gamertag = $userdata['user_gamertag']; # #-----[ FIND ]---------------------------------------------------# display_avatar_gallery($mode, $avatar_category # #-----[ IN-LINE FIND ]---------------------------------------------------# $interests # #-----[ IN-LINE ADD ]---------------------------------------------------# , $gamertag # #-----[ FIND ]--------------------------# $template->assign_vars(array('USERNAME' => $username,'CUR_PASSWORD' => $cur_password,'NEW_PASSWORD' => $new_password,'PASSWORD_CONFIRM' => $password_confirm,'EMAIL' => $email,'CONFIRM_IMG' => $confirm_image, 'YIM' => $yim,'ICQ' => $icq,'MSN' => $msn,'AIM' => $aim,'OCCUPATION' => $occupation,'INTERESTS' => $interests, # #-----[ BELOW ADD ]---------------------------------------------------# 'GAMERTAG' => $gamertag,'L_GAMERTAG' => $lang['Gamertag'], ##-----[ FIND ]------------------------------------------------------------------ validate_optional_fields($icq, $aim, $msn, $yim, $website, $location, $occupation, $interests, $signature); ##-----[IN-LINE FIND]---------------------------------------------------------------# $interests ##-----[IN-LINE ADD] ,$gamertag # #-----[ OPEN ]------------------------------------------ # # includes/usercp_avatar.php# #-----[ FIND ]---------------------------------------------------# function display_avatar_gallery($mode, &$category # #-----[ IN-LINE FIND ]---------------------------------------------------# &$interests # #-----[ IN-LINE ADD ]---------------------------------------------------# , &$gamertag # #-----[ FIND ]---------------------------------------------------# $params = array('coppa', 'user_id' # #-----[ IN-LINE FIND ]---------------------------------------------------# 'interests' # #-----[ IN-LINE ADD ]---------------------------------------------------# , 'gamertag' # #-----[ OPEN ]------------------------------------------ # # admin/admin_users.php # #-----[ FIND ]---------------------------------------------------# $interests = ( !empty($HTTP_POST_VARS['interests']) ) ? trim(strip_tags( $HTTP_POST_VARS['interests'] ) ) : ''; # #-----[ BELOW ADD ]---------------------------------------------------# $gamertag = ( !empty($HTTP_POST_VARS['gamertag']) ) ? trim(strip_tags( $HTTP_POST_VARS['gamertag'] ) ) : ''; # #-----[ FIND ]--------------------------------------------# $interests = htmlspecialchars(stripslashes($interests)); # #-----[ BELOW ADD ]---------------------------------------------------# $gamertag = htmlspecialchars(stripslashes($gamertag)); # #-----[ FIND AGAIN ]--------------------------------------------# $interests = htmlspecialchars(stripslashes($interests)); # #-----[ BELOW ADD ]---------------------------------------------------# $gamertag = htmlspecialchars(stripslashes($gamertag)); # #-----[ FIND ]---------------------------------------------------# $sql = "UPDATE " . USERS_TABLE . " # #-----[ IN-LINE FIND ]---------------------------------------------------# $interests) . "' # #-----[ IN-LINE ADD ]---------------------------------------------------# , user_gamertag = '" . str_replace("'", "''", $gamertag) . "' # #-----[ FIND ]---------------------------------------------------# $interests = htmlspecialchars($this_userdata['user_interests']); # #-----[ BELOW ADD ]---------------------------------------------------# $gamertag = htmlspecialchars($this_userdata['user_gamertag']); # #-----[ FIND ]---------------------------------------------------# $s_hidden_fields .= '<input>'; # #-----[ FIND ]---------------------------------------------------# 'INTERESTS' => $interests, # #-----[ BELOW ADD ]---------------------------------------------------# 'GAMERTAG' => $gamertag, 'L_GAMERTAG' => $lang['Gamertag'], # #-----[ OPEN ]------------------------------------------ # # templates/YOUR_TEMPLATE/profile_add_body.tpl# #-----[ FIND ]---------------------------------------------------# <tr> <td><span>{L_INTERESTS}:</span></td> <td> <input> </td></tr> # #-----[ BELOW ADD ]---------------------------------------------------# <tr> <td><span>{L_GAMERTAG}:</span></td> <td> <input> </td></tr> # #-----[ OPEN ]------------------------------------------ # # templates/YOUR_TEMPLATE/profile_view_body.tpl# #-----[ FIND ]---------------------------------------------------# <tr> <td><span>{L_INTERESTS}:</span></td> <td> <b><span>{INTERESTS}</span></b></td></tr> # #-----[ BELOW ADD ]---------------------------------------------------# <tr> <td><span>{L_GAMERTAG}:</span></td> <td> <b><span>{GAMERTAG}</span></b></td></tr> # #-----[ OPEN ]------------------------------------------ # # templates/YOUR_TEMPLATE/admin/user_edit_body.tpl# #-----[ FIND ]---------------------------------------------------# <tr> <td><span>{L_INTERESTS}</span></td> <td> <input> </td></tr> # #-----[ BELOW ADD ]---------------------------------------------------# <tr> <td><span>{L_GAMERTAG}</span></td> <td> <input></td> </tr> #-----[ OPEN ]------------------------------------------# # memberlist.php# #-----[ FIND ]---------------------------------------------------# $mode_types_text = array($lang['Sort_Joined'], $lang['Sort_Username'], $lang['Sort_Location'], $lang['Sort_Posts'], $lang['Sort_Email'], $lang['Sort_Website'], $lang['Sort_Top_Ten']);$mode_types = array('joindate', 'username', 'location', 'posts', 'email', 'website', 'topten'); # #-----[ IN-LINE FIND ]---------------------------------------------------# $lang['Sort_Location'] # #-----[ IN-LINE ADD ]---------------------------------------------------# , $lang['Gamertag'] # #-----[ IN-LINE FIND ]---------------------------------------------------# 'location' # #-----[ IN-LINE ADD ]---------------------------------------------------# , 'gamertag' # #-----[ FIND ]---------------------------------------------------# 'L_FROM' => $lang['Location'], # #-----[ BELOW ADD ]---------------------------------------------------# 'L_GAMERTAG' => $lang['Gamertag'], # #-----[ FIND ]---------------------------------------------------# case 'location':$order_by = "user_from $sort_order LIMIT $start, " . $board_config['topics_per_page'];break; # #-----[ BELOW ADD ]---------------------------------------------------# case 'gamertag':$order_by = "user_gamertag $sort_order LIMIT $start, " . $board_config['topics_per_page'];break; # #-----[ FIND ]---------------------------------------------------# $sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar # #-----[ IN-LINE FIND ]---------------------------------------------------# user_from # #-----[ IN-LINE ADD ]---------------------------------------------------# , user_gamertag # #-----[ FIND ]---------------------------------------------------# $from = ( !empty($row['user_from']) ) ? $row['user_from'] : ' '; # #-----[ BELOW ADD ]---------------------------------------------------# $gamertag = ( !empty($row['user_gamertag']) ) ? $row['user_gamertag'] : ' '; # #-----[ FIND ]---------------------------------------------------# 'FROM' => $from, # #-----[ BELOW ADD ]---------------------------------------------------# 'GAMERTAG' => $gamertag, # #-----[ OPEN ]------------------------------------------# # templates/YOUR_TEMPLATE/memberlist_body.tpl# #-----[ FIND ]---------------------------------------------------# <th>{L_FROM}</th> # #-----[ BELOW ADD ]---------------------------------------------------# <th>{L_GAMERTAG}</th> # #-----[ FIND ]---------------------------------------------------# <td><span>{memberrow.FROM}</span></td> # #-----[ BELOW ADD ]---------------------------------------------------# <td><span>{memberrow.GAMERTAG}</span></td> # #-----[ FIND ]---------------------------------------------------# # OPTIONAL- Please check your template before performing the next change as it may not be needed.# Please increase your colspan value by 1 on the next line. If youÂÂÂ ´ve installed other mods the value# may be bigger than the default 8. Find the next line and increase the colspan by 1.# <td> </td> # #-----[ 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 # #-----[ IN-LINE FIND ]---------------------------------------------------# u.user_from # #-----[ IN-LINE ADD ]---------------------------------------------------# , u.user_gamertag # #-----[ FIND ]---------------------------------------------------# $poster_from = ( $postrow[$i]['user_from'] && $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Location'] . ': ' . $postrow[$i]['user_from'] : ''; # #-----[ BELOW ADD ]---------------------------------------------------# $poster_gamertag = ( $postrow[$i]['user_gamertag'] && $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Gamertag'] . ': ' . $postrow[$i]['user_gamertag'] : ''; # #-----[ FIND ]---------------------------------------------------# 'POSTER_FROM' => $poster_from, # #-----[ BELOW ADD ]---------------------------------------------------# 'POSTER_GAMERTAG' => $poster_gamertag, # #-----[ OPEN ]------------------------------------------# # templates/YOUR_TEMPLATE/viewtopic_body.tpl# #-----[ FIND ]---------------------------------------------------# {postrow.POSTER_FROM} # #-----[ AFTER ADD ]---------------------------------------------------# <br>{postrow.POSTER_GAMERTAG} ########################################################################################## ## That's all folk