How can I integrate this xbox.com Gamercard code to phpnuke?

New Member Joined: Apr 17, 2005 Posts: 16

Ok I follow the instructions of these two different tutorials but the problem is one is for phpbb and the other is for vBulletin and I try to fallow the manuals with my phpnuke knowledge but I not lucky Sad

Here are the codes pls help me to integrate this to phpnuke.

Code phpbb

Code:

#########################################################################################


## 


## 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'] : '&nbsp;',





# 


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


# 


'GAMERTAG' => ( $profiledata['user_gamertag'] ) ? $profiledata['user_gamertag'] : '&nbsp;',


'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

vBulletin Code
Gamer Display

Code:

##############################################################


## MOD Title: Integrating the http://www.xbox.com Gamercard Attachment


## MOD Author: stonyarc


## MOD Description: Displays it in view body 


## MOD Version: 1.0.0


##


## Credits: Based on the add new user field modification by Acid


##


##   All changes/modifications specific for gamertag are (c)2005 Xboxusersgroup.com


##   Development by stonyarc@xboxusersgroup.com


##


##


## Installation Level: Easy


## Installation Time: ~1 Minute


##


## Files to edit: 2


## viewtopic.php


## templates/subSilver/viewtopic_body.tpl


##


## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2


##############################################################


## For security purposes, please check: http://www.phpbb.com/mods/


## for the latest version of this MOD. Although MODs are checked


## before being allowed in the MODs Database there is no guarantee


## that there are no security problems within the MOD. No support


## will be given for MODs not found within the MODs Database which


## can be found at http://www.phpbb.com/mods/


##############################################################


## Author Notes: Sobman assisted in rewriting this from the guide [HERE http://www.xboxusersgroup.com/forums/showthread.php?t=47555]


## into the new phpBB mod template


##


##############################################################


## MOD History:


##


##   10-30-2005


##      - Wrote


##


##############################################################


## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD


##############################################################





# 


#-----[ OPEN ]------------------------------------------


#  


# viewtopic.php


# 


#-----[ FIND (just a quote) ]---------------------------------------------------


# 


$sql = "SELECT u.





# 


#-----[ 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 ]---------------------------------------------------


# 


   // only if you´re using an option field (delete // before the next 2 lines)


   // $info = ( $postrow[$i]['user_gamertag'] == '0' ) ? $lang['No'] : $lang['Yes'];


   // $poster_gamertag = ( $info && $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Info'] . ': ' . $info : '';


   // and uncomment the next line (add // before)


   $poster_gamertag = ( $postrow[$i]['user_gamertag'] && $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Info'] . $postrow[$i]['user_gamertag'] : '';





# 


#-----[ FIND ]---------------------------------------------------


# 


      'POSTER_FROM' => $poster_from,





# 


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


# 


      'poster_gamertag' => $poster_gamertag,











# 


#-----[ OPEN ]------------------------------------------


#  


# templates/xxx/viewtopic_body.tpl


# 


#-----[ FIND ]---------------------------------------------------


# 


{postrow.POSTER_FROM}





# 


#-----[ AFTER ADD ]---------------------------------------------------


# 


<br />


<iframe src="http://gamercard.xbox.com/{postrow.poster_gamertag}.card" scrolling="no" frameBorder="0" height="140" width="204">{postrow.poster_gamertag}</iframe>





#


#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------


#


# EoM

Gamerprofile Code

Code:

##############################################################


## MOD Title: Integrating the http://www.xbox.com Gamercard


## MOD Author: stonyarc


## MOD Description: Just a simple way to add a new field to profile. "Gamertag" 


## MOD Version: 1.0.0


##


## Credits: Based on the add new user field modification by Acid


##


##   All changes/modifications specific for gamertag are (c)2005 Xboxusersgroup.com


##   Development by stonyarc@xboxusersgroup.com


##


##


## Installation Level: Intermediate


## Installation Time: 20 Minutes


##


## Files To Edit: 8


## admin/admin_users.php


## language/lang_english/lang_main.php


## includes/usercp_viewprofile.php 


## includes/usercp_register.php


## includes/usercp_avatar.php 


## templates/subSilver/admin/user_edit_body.tpl


## templates/subSilver/profile_add_body.tpl 


## templates/subSilver/profile_view_body.tpl 


##


## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2


##############################################################


## For security purposes, please check: http://www.phpbb.com/mods/


## for the latest version of this MOD. Although MODs are checked


## before being allowed in the MODs Database there is no guarantee


## that there are no security problems within the MOD. No support


## will be given for MODs not found within the MODs Database which


## can be found at http://www.phpbb.com/mods/


##############################################################


## Author Notes: Sobman assisted in rewriting this from the guide [HERE http://www.xboxusersgroup.com/forums/showthread.php?t=47555]


## into the correct phpBB syantex


##


##############################################################


## MOD History:


##


##   10-30-2005


##      - Wrote


##


##############################################################


## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD


##############################################################





#


#-----[ SQL ]-------------------------------------------


#  


# You have to execute the following query via phpmyadmin (change prefix)..





ALTER TABLE phpbb_users ADD user_gamertag VARCHAR(255) AFTER user_interests;





# If you´re going to add/change several fields duplicate the above query and 


# change the field name "user_gamertag".


#


#########################################################################################


# 


#-----[ 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'] : '&nbsp;',





# 


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


# 


   'Gamertag' => ( $profiledata['user_gamertag'] ) ? $profiledata['user_gamertag'] : '&nbsp;',


   '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 (2x) ]---------------------------------------------------


# 


      $interests = stripslashes($interests);





# 


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


# 


      $Gamertag = stripslashes($Gamertag);





# 


#-----[ FIND (just a quote) ]---------------------------------------------------


# 


         $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 (just a quote) ]---------------------------------------------------


# 


display_avatar_gallery($mode, $avatar_category





# 


#-----[ IN-LINE FIND ]---------------------------------------------------


# 


$interests





# 


#-----[ IN-LINE ADD ]---------------------------------------------------


# 


, $Gamertag





# 


#-----[ FIND (just a quote) ]--------------------------


# 


   $template->assign_vars(array(


      .


      .


      .


      .


      'INTERESTS' => $interests,





# 


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


# 


      'Gamertag' => $Gamertag,


      'L_Gamertag' => $lang['Gamertag'],











# 


#-----[ OPEN ]------------------------------------------ 


#  


# includes/usercp_avatar.php


# 


#-----[ FIND (just a quote) ]---------------------------------------------------


# 


function display_avatar_gallery($mode, &$category





# 


#-----[ IN-LINE FIND ]---------------------------------------------------


# 


&$interests





# 


#-----[ IN-LINE ADD ]---------------------------------------------------


# 


, &$Gamertag





# 


#-----[ FIND (just a quote) ]---------------------------------------------------


# 


$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 (2x) ]--------------------------------------------


# 


         $interests = htmlspecialchars(stripslashes($interests));





# 


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


# 


         $Gamertag = htmlspecialchars(stripslashes($Gamertag));





# 


#-----[ FIND (just a quote) ]---------------------------------------------------


# 


         $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/xxx/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/xxx/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/xxx/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>





#


#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------


#


# EoM

Posted: Fri Jan 20, 2006 6:48 pm

This is not exactly a five minute job.
One of the tables mentioned that needs altering does not even exist in nuke so you would need to use the nuke_bb_users table not the phpbb_users table and hope that would work. Some of the file locations are also different because phpNuke uses a ported version not the standalone version of the phpBB forum.

I'm not saying its impossible I just didnt want you to be under some illusion someone will just pop up do it in five minutes flat.