#########################################################################################
## 
## Mod Title:    Xbox Live Gamertag
## Mod Version:  1.0.1 (tested and installed on phpbb 2.0.12)
## Author        Defender
##
## Description:  This will add a gamertag field to profile, memberlist, and topic view.
##               This is perfect for game related forums.  Gamertag is the name of your 
##               xbox name when you play.
##
##
## Install time: 15 minutes 
## 
## 
##
## Files to edit:12
##admin/admin_users.php
##        language/lang_english/lang_main.php
##            includes/usercp_viewprofile.php 
##        includes/usercp_register.php
##      includes/usercp_avatar.php
##              memberlist.php 
##viewtopic.php
##            templates/YOUR_TEMPLATE/admin/user_edit_body.tpl
##         templates/YOUR_TEMPLATE/profile_add_body.tpl 
##      templates/YOUR_TEMPLATE/profile_view_body.tpl
##templates/YOUR_TEMPLATE/memberlist_body.tpl
##              templates/YOUR_TEMPLATE/viewtopic_body.tpl
##
#########################################################################################
## 
## Notes: 
## Always and I mean ALWAYS make sure to have a backup before attempting to install. 
##
##
## Templates:  Be sure to install this properly on YOUR_TEMPLATE.  Keep in mind that 
##             any template you use may NOT be exact to the template changes here.
## 
## This mod will adds 1 new column to the 'user' database table and that's it.
## You can see this mod in action at http://www.xbox-forums.com/ 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 type="hidden" name="interests" value="' . str_replace("\"", "&quot;", $interests) . '" />';

# 
#-----[ BELOW ADD ]---------------------------------------------------
# 
$s_hidden_fields .= '<input type="hidden" name="gamertag" value="' . str_replace("\"", "&quot;", $gamertag) . '" />'; 

# 
#-----[ FIND ]---------------------------------------------------
# 
'INTERESTS' => $interests,

# 
#-----[ BELOW ADD ]---------------------------------------------------
# 
'GAMERTAG' => $gamertag, 
'L_GAMERTAG' => $lang['Gamertag'],


# 
#-----[ OPEN ]------------------------------------------ 
#  
# templates/YOUR_TEMPLATE/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>

# 
#-----[ BELOW ADD ]---------------------------------------------------
# 
<tr> 
  <td class="row1"><span class="gen">{L_GAMERTAG}:</span></td>
  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="gamertag" size="35" maxlength="150" value="{GAMERTAG}" /> </td>
</tr>


# 
#-----[ OPEN ]------------------------------------------ 
#  
# templates/YOUR_TEMPLATE/profile_view_body.tpl
# 
#-----[ FIND ]---------------------------------------------------
# 
<tr> 
  <td valign="top" align="right"><span class="gen">{L_INTERESTS}:</span></td>
  <td> <b><span class="gen">{INTERESTS}</span></b></td>
</tr>

# 
#-----[ BELOW ADD ]---------------------------------------------------
# 
<tr> 
  <td valign="top" align="right"><span class="gen">{L_GAMERTAG}:</span></td>
  <td> <b><span class="gen">{GAMERTAG}</span></b></td>
</tr>



# 
#-----[ OPEN ]------------------------------------------ 
#  
# templates/YOUR_TEMPLATE/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>

# 
#-----[ BELOW ADD ]---------------------------------------------------
# 
        <tr> 
          <td class="row1"><span class="gen">{L_GAMERTAG}</span></td> 
          <td class="row2"> <input class="post" type="text" name="gamertag" size="35" maxlength="50" value="{GAMERTAG}" /></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'] : '&nbsp;';

# 
#-----[ BELOW ADD ]---------------------------------------------------
# 

$gamertag = ( !empty($row['user_gamertag']) ) ? $row['user_gamertag'] : '&nbsp;';

# 
#-----[ FIND ]---------------------------------------------------
# 
'FROM' => $from,

# 
#-----[ BELOW ADD ]---------------------------------------------------
# 
'GAMERTAG' => $gamertag,


# 
#-----[ OPEN ]------------------------------------------
#  
# templates/YOUR_TEMPLATE/memberlist_body.tpl
# 
#-----[ FIND ]---------------------------------------------------
# 
  <th class="thTop" nowrap="nowrap">{L_FROM}</th>

# 
#-----[ BELOW ADD ]---------------------------------------------------
# 
  <th class="thTop" nowrap="nowrap">{L_GAMERTAG}</th>

# 
#-----[ FIND ]---------------------------------------------------
# 
  <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gen">{memberrow.FROM}</span></td>

# 
#-----[ BELOW ADD ]---------------------------------------------------
# 
  <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gen">{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 class="catbottom" colspan="8" height="28">&nbsp;</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