Habe aber bis jetzt nur das gefunden:
Code: Alles auswählen
#########################################################################################
##
## 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("\"", """, $interests) . '" />';
#
#-----[ BELOW ADD ]---------------------------------------------------
#
$s_hidden_fields .= '<input type="hidden" name="gamertag" value="' . str_replace("\"", """, $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'] : ' ';
#
#-----[ 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 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"> </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 folkwo ist der mod fürs bild?
