Icy Phoenix :: View topic - SOLVED

n1cks21 [ Tue 10 Feb, 2009 18:52 ]
Post subject: SOLVED - User Block Mod

Not sure what I am trying to achieve is possible, I want to replace the avatar pic in the User Block with an image however the url for the image will include {memberrow.custom_fields.CUSTOM_FIELD}

I have had a look at the block but got really confused

any help ???

Limun [ Fri 13 Feb, 2009 16:30 ]
Post subject: Re: User Block Mod

are we talking about this user block?

what you want to do exactly ?

n1cks21 [ Sat 14 Feb, 2009 00:43 ]
Post subject: Re: User Block Mod

Limun wrote: [View Post]
are we talking about this user block?

what you want to do exactly ?

Yes thats the block, when a user logs in instead of showing there avatar picture I would like to diaplay an image from this url:-

"http://avatar.xboxlive.com/avatar/{memberrow.custom_fields.CUSTOM_FIELD}/avatar-body.png"

I think that {memberrow.custom_fields.CUSTOM_FIELD} is the Custom Profile Field I set.

this is the image that would be displayed if I signed in

which is "http://avatar.xboxlive.com/avatar/n1cks21/avatar-body.png"

hope thats make sense

spydie [ Sat 14 Feb, 2009 00:48 ]
Post subject: Re: User Block Mod

youve got 2 possibilitys.

you can upload the avatar to your site or you enable gravatar and put the link to your avatar on your personal profil avatar managment

Limun [ Sat 14 Feb, 2009 01:12 ]
Post subject: Re: User Block Mod

you can try like this

Spoiler: [ Show ]

but i m not sure if its gona work because i dont know what did you add in Custom Profile Field
and i m not sure about this link

Code: [Hide] [Select]

http://avatar.xboxlive.com/avatar/{memberrow.custom_fields.CUSTOM_FIELD}/avatar-body.png

well try then we gona see

n1cks21 [ Sat 14 Feb, 2009 04:05 ]
Post subject: Re: User Block Mod

No It Didnt work

when I clicked on the image link it was "http://avatar.xboxlive.com/avatar//avatar-body.png%3C/img%3E%3Cbr%20/%3E%3Cbr%20/%3E%3Cspan%20class=" so it obviously didnt know what {memberrow.custom_fields.CUSTOM_FIELD} was and I am not sure what all that junk is after the png, as a test I tried it in my memberlist_body.tpl :-

Code: [Hide] [Select]

<!-- BEGIN custom_fields -->

	<td class="row1 row-center">{memberrow.custom_fields.CUSTOM_FIELD}</td>

    img src="http://avatar.xboxlive.com/avatar/{memberrow.custom_fields.CUSTOM_FIELD}/avatar-body.png</img> 

    <!-- END custom_fields -->

the image didnt show however the link was "http://avatar.xboxlive.com/avatar/n1cks21/avatar-body.png%3C/img%3E%20%20%20%20%20%20%20%3Ctd%20class="

which shows it did know what {memberrow.custom_fields.CUSTOM_FIELD} was it just didnt work because of all the junk after png

I dont want to upload the avatars to my site as members do change them every now and then and it would mean uploading them all the time.

hope that makes sense

DWho [ Sat 14 Feb, 2009 11:33 ]
Post subject: Re: User Block Mod

remove memberrow. twice from this code

Code: [Hide] [Select]

<!-- BEGIN custom_fields -->

   <td class="row1 row-center">{memberrow.custom_fields.CUSTOM_FIELD}</td>

   img src="http://avatar.xboxlive.com/avatar/{memberrow.custom_fields.CUSTOM_FIELD}/avatar-body.png</img>

   <!-- END custom_fields -->

memberrow is used in the memberlist code and the variable is not used in the block...

let me know

n1cks21 [ Sat 14 Feb, 2009 12:21 ]
Post subject: Re: User Block Mod

DWho wrote: [View Post]
remove memberrow. twice from this code

Code: [Hide] [Select]
Code: [Show]

<td class="row1 row-center">{memberrow.custom_fields.CUSTOM_FIELD}</td>
img src="http://avatar.xboxlive.com/avatar/avatar-body.png</img>


memberrow is used in the memberlist code and the variable is not used in the block...

let me know

I tried it in user_block_block, but got the same problem no picture and the URL was:-

"http://avatar.xboxlive.com/avatar//avatar-body.png%3C/img%3E%3Cbr%20/%3E%3Cbr%20/%3E%3Cspan%20class="

again it doesnt know what {custom_fields.CUSTOM_FIELD} is and I still dont know what all that junk is after the png "%3C/img%3E%3Cbr%20/%3E%3Cbr%20/%3E%3Cspan%20class="

DWho [ Sat 14 Feb, 2009 13:50 ]
Post subject: Re: User Block Mod

Have you added the php code into the block php file..?

otherwise it will not know where to call the information from...

n1cks21 [ Sat 14 Feb, 2009 14:13 ]
Post subject: Re: User Block Mod

DWho wrote: [View Post]
Have you added the php code into the block php file..?

otherwise it will not know where to call the information from...

erm.... no

which php code ????

DWho [ Sat 14 Feb, 2009 17:40 ]
Post subject: Re: User Block Mod

Well for example in memberlist.php you have this code..

Code: [Hide] [Select]

	// Custom Profile Fields MOD - BEGIN

	include_once($phpbb_root_path . 'includes/functions_profile_fields.' . $phpEx);

	$profile_data = get_fields('WHERE view_in_memberlist = ' . VIEW_IN_MEMBERLIST . ' AND users_can_view = ' . ALLOW_VIEW);

	foreach($profile_data as $field)

	{

		$template->assign_block_vars('custom_field_names', array('FIELD_NAME' => $field['field_name']));

	}

	$template->assign_var('NUMCOLS', count($profile_data) + 12);

	// Custom Profile Fields MOD - END

and

Code: [Hide] [Select]

		// Custom Profile Fields MOD - BEGIN

		foreach($profile_data as $field)

		{

			$name = text_to_column($field['field_name']);

			$sql2 = "SELECT $name FROM " . USERS_TABLE . "

				WHERE user_id = $user_id";

			if(!($result2 = $db->sql_query($sql2)))

				message_die(GENERAL_ERROR,'Could not get custom profile data','',__LINE__,__FILE__,$sql2);

			$val = $db->sql_fetchrow($result2);

			$val = displayable_field_data($val[$name],$field['field_type']);

			$template->assign_block_vars('memberrow.custom_fields',array('CUSTOM_FIELD' => $val));

		}

		// Custom Profile Fields MOD - END

this pulls the info from your database and the template code you used above will then show the correct ode in the block...

you then need to find the code out of the above that fits the user_block.php file to show correctly...

hope the gives you a few hints..

spydie [ Sat 14 Feb, 2009 18:31 ]
Post subject: Re: User Block Mod

one question .

is that the size you want your avatar to apear ???

looks a bit big for me

n1cks21 [ Sat 14 Feb, 2009 19:43 ]
Post subject: Re: User Block Mod

DWho wrote: [View Post]
Well for example in memberlist.php you have this code..

Code: [Hide] [Select]
Code: [Show]
// Custom Profile Fields MOD - BEGIN
include_once($phpbb_root_path . 'includes/functions_profile_fields.' . $phpEx);
$profile_data = get_fields('WHERE view_in_memberlist = ' . VIEW_IN_MEMBERLIST . ' AND users_can_view = ' . ALLOW_VIEW);

foreach($profile_data as $field)
{
$template->assign_block_vars('custom_field_names', array('FIELD_NAME' => $field['field_name']));
}

$template->assign_var('NUMCOLS', count($profile_data) + 12);
// Custom Profile Fields MOD - END

and

Code: [Hide] [Select]
Code: [Show]
// Custom Profile Fields MOD - BEGIN
foreach($profile_data as $field)
{
$name = text_to_column($field['field_name']);
$sql2 = "SELECT $name FROM " . USERS_TABLE . "
WHERE user_id = $user_id";
if(!($result2 = $db->sql_query($sql2)))
message_die(GENERAL_ERROR,'Could not get custom profile data','',__LINE__,__FILE__,$sql2);

$val = $db->sql_fetchrow($result2);
$val = displayable_field_data($val[$name],$field['field_type']);

$template->assign_block_vars('memberrow.custom_fields',array('CUSTOM_FIELD' => $val));
}
// Custom Profile Fields MOD - END

this pulls the info from your database and the template code you used above will then show the correct ode in the block...

you then need to find the code out of the above that fits the user_block.php file to show correctly...

hope the gives you a few hints..

no hints just a headache hahahahahahahahahaha

maybe I should knock this idea on the head it's way to complicated for me

shame nice idea though

DWho [ Sat 14 Feb, 2009 20:08 ]
Post subject: Re: User Block Mod

Do you want everyone to have the same image...? or the image that gets placed in the users custom field if they have placed an image there...?

n1cks21 [ Sat 14 Feb, 2009 22:49 ]
Post subject: Re: User Block Mod

DWho wrote: [View Post]
Do you want everyone to have the same image...? or the image that gets placed in the users custom field if they have placed an image there...?

sorry, let me explain..... my site is an xbox 360 site and when members sign up they get asked for there xbox gamertag (custom field), anyone's xbox avatar can been seen at the url of "http://avatar.xboxlive.com/avatar/(gamertag)/avatar-body.png", the best example I can give is if you check My Site you can see my xbox avatar now, if/when I change my avatar through xbox live that picture automatically updates.

all I need to do is pull the info from the database from my Custom Field and insert it into the url, so that when a member signes in they have there own xbox avatar shown in user_block_block which sounds simply but I have no idea how

Chaotic [ Sun 15 Feb, 2009 03:46 ]
Post subject: Re: User Block Mod

I understand exactly what you are wanting to do. I have an Xbox themed website as well and I used to use the Xbox LIVE Gamercard MOD on my site.

I was thinking you could adapt a few changes in the MOD I'm about to post that may give you the results you want. Wherever you see offical Xbox codes, replace them with the avatar codes you have. It's a lengthy MOD and you'll have to find things that aren't easily found using FIND. I was going to perfect this MOD for IP and release it here if the original MOD author would get back to me.

Give it a try, but make sure you back up all files that you edit.

Spoiler: [ Show ]

Code: [Hide] [Select]

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

##

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

n1cks21 [ Sun 15 Feb, 2009 04:17 ]
Post subject: Re: User Block Mod

thanks Chaotic I will give it a try, I am not very confident around IP but am willing to try...... at least you understand what I am trying to do, I am not very good at explaining things......

Nick

Chaotic [ Sun 15 Feb, 2009 04:25 ]
Post subject: Re: User Block Mod

You also need to make these changes after installing the MOD. Be aware that you'll be using iFrame. It's recommended you don't use this code, so please use at your own risk. We won't be held responsible for any harm that may come of adding these codes!

To display the gamercard in profile:

OPEN: /includes/usercp_viewprofile.php

FIND:

Code: [Hide] [Select]

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

REPLACE WITH:

Code: [Hide] [Select]

   'GAMERTAG' => ( $profiledata['user_gamertag'] ) ? '<iframe src="http://gamercard.xbox.com/' . $profiledata['user_gamertag']. '.card" scrolling="no" frameBorder="0" height="140" width="204"></iframe>'  :'',

To display gamercard in viewtopic:

OPEN: /viewtopic.php

FIND:

Code: [Hide] [Select]

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

REPLACE WITH:

Code: [Hide] [Select]

   $poster_gamertag = ( $postrow[$i]['user_gamertag'] && $postrow[$i]['user_id'] != ANONYMOUS ) ? '<iframe src="http://gamercard.xbox.com/' . $postrow[$i]['user_gamertag'] . '.card" scrolling="no" frameBorder="0" height="140" width="204">' . $postrow[$i]['user_gamertag'] . '</iframe>' : '';

DWho [ Sun 15 Feb, 2009 11:17 ]
Post subject: Re: User Block Mod

Thanks Chaotic...saved me from going through files...

Chaotic [ Sun 15 Feb, 2009 13:35 ]
Post subject: Re: User Block Mod

No problem!

This will surely work for someone wanting to add their Xbox LIVE Avatar. All you gotta do is replace the iFrame code I bet.

n1cks21 [ Sun 15 Feb, 2009 17:40 ]
Post subject: Re: User Block Mod

I am a bit confused,

does the above code give me a Gamertag field ??? becuase I have one already that I created in Custom fields, and is shown correctly in memberlist see below :-

what I want to do is have my user_block_block

look like this when your not signed in (which is how it looks now)

and look like this when you are signed in (but with your own xbox avatar) the below was done using photoshop to give u an idea of what I am after

I only want the xbox avatar shown in the user_block_block

Chaotic [ Sun 15 Feb, 2009 17:54 ]
Post subject: Re: User Block Mod

That is totally my fault. I saw your topic title and it does say User Block.

I was thinking you wanted to show your Xbox LIVE Avatar on viewtopic, but you wanted it to replace the avatar in the User Block.

n1cks21 [ Sun 15 Feb, 2009 21:12 ]
Post subject: Re: User Block Mod

partial success, I have managed to make it work in the memberlist_body, but that is only becuase {memberrow.custom_fields.CUSTOM_FIELD} has been defined there, what I need to do is query the database in user_block_block but I am not sure how

Lopalong [ Sun 15 Feb, 2009 23:31 ]
Post subject: Re: User Block Mod

Im not sure what this Gamer thing is But!

Try this:

Copy avatar-body.png To /images/avatar-body.png

Spoiler: [ Show ]

DWho [ Mon 16 Feb, 2009 00:27 ]
Post subject: Re: User Block Mod

if Lobalongs code does not work (though I am sure it will) I will have a look as I have place custom fields code in another file recently... to pi**ed at the moment to concentrate on it..

n1cks21 [ Mon 16 Feb, 2009 01:25 ]
Post subject: Re: User Block Mod

Lopalong, your code worked however the link I need to use for the avatar is :-

"http://avatar.xboxlive.com/avatar/ custom field value for the user /avatar-body.png"

The contents of my custom field is each members gamertag (xbox name) which they are required to enter when they register mine is n1cks21

so my xbox avatar link is "http://avatar.xboxlive.com/avatar/n1cks21 /avatar-body.png"

I have used this link "http://avatar.xboxlive.com/avatar/ {memberrow.custom_fields.CUSTOM_FIELD} /avatar-body.png" in the members screen with the following results :-

a different avatar pic for each member

I need to use your code with my link, sql needs to be queried for the vale of the custom field for the member logging in and that value to be entered into the link "http://avatar.xboxlive.com/avatar/custom field value /avatar-body.png"

sorry I dont know how else to explain it

Lopalong [ Mon 16 Feb, 2009 01:46 ]
Post subject: Re: User Block Mod

Not sure where we're at with this, but try the script below as it includes the string you use elsewhere with the spaces removed.

Code: [Hide] [Select]

AFTER ADD: 

        if( $userdata['session_logged_in'] ) 

        $template->assign_vars(array( 

            'AVATAR_IMG' => '<img src="http://avatar.xboxlive.com/avatar/{memberrow.custom_fields.CUSTOM_FIELD}/avatar-body.png" alt=""/>', 

            'U_NAME_LINK' => $name_link, 

            'L_REMEMBER_ME' => $lang['Remember_me'], 

            'L_SEND_PASSWORD' => $lang['Forgotten_password'], 

            'U_SEND_PASSWORD' => append_sid(PROFILE_MG . '?mode=sendpassword'), 

            'L_REGISTER_NEW_ACCOUNT' => sprintf($lang['Register_new_account'], '<a href="' . append_sid(PROFILE_MG . '?mode=register') . '">', '</a>'), 

            'L_NEW_SEARCH' => $lang['Search_new']) 

); 

If you get any errors about "Unexpected whatever" then try this string. Either way let us know what happens.

<img src="http://avatar.xboxlive.com/avatar/' . {memberrow.custom_fields.CUSTOM_FIELD} . '/avatar-body.png" alt=""/>

Arrivederci! Now I'm out of here for a couple of months or maybe longer.

n1cks21 [ Mon 16 Feb, 2009 11:37 ]
Post subject: Re: User Block Mod

Lopalong wrote: [View Post]
Arrivederci! Now I'm out of here for a couple of months or maybe longer.

Well thanks for all your help

The above link didnt work

but I am pretty sure it's because "{memberrow.custom_fields.CUSTOM_FIELD}" has no value, I am sure there should be some sort of sql query before the above code giving "{memberrow.custom_fields.CUSTOM_FIELD}" it's value.

DWho [ Mon 16 Feb, 2009 19:25 ]
Post subject: Re: User Block Mod

Ok I got this to work for you

here is the code let me know... replace all the code in blocks/blocks_imp_user_block.php with

Spoiler: [ Show ]

Code: [Hide] [Select]

<?php

/***************************************************************************

 *			 blocks_imp_user_block.php

 *			    -------------------

 *   begin		: Saturday, March 20, 2004

 *   copyright	    : (C) 2004 masterdavid - Ronald John David

 *   website	      : http://www.integramod.com

 *   email		: webmaster@integramod.com

 *

 *   note: removing the original copyright is illegal even you have modified

 *	 the code.  Just append yours if you have modified it.

 ***************************************************************************/

/***************************************************************************

 *

 *   This program is free software; you can redistribute it and/or modify

 *   it under the terms of the GNU General Public License as published by

 *   the Free Software Foundation; either version 2 of the License, or

 *   (at your option) any later version.

 *

 ***************************************************************************/

if ( !defined('IN_PHPBB') )

{

	die('Hacking attempt');

}

if(!function_exists(imp_user_block_block_func))

{

	function imp_user_block_block_func()

	{

		global $userdata, $template, $board_config, $name, $lang, $db, $phpEx;

		include_once($phpbb_root_path . 'includes/functions_groups.' . $phpEx);

		/*if( $userdata['session_logged_in'] )

		{

				$sql = "SELECT COUNT(post_id) as total

					FROM " . POSTS_TABLE . "

					WHERE post_time >= " . $userdata['user_lastvisit'] . " AND poster_id <> " . $userdata['user_id'] . " AND post_time < " . time();

					$result = $db->sql_query($sql);

			if( $result )

			{

				$row = $db->sql_fetchrow($result);

				$lang['Search_new'] = $lang['Search_new'] . "&nbsp;(" . $row['total'] . ")";

			}

		}*/

		$avatar_img = user_get_avatar($userdata['user_id'], $userdata['user_avatar'], $userdata['user_avatar_type'], $userdata['user_allowavatar']);

		// Check For Anonymous User

		if ($userdata['user_id'] != ANONYMOUS)

		{

				$username = colorize_username($userdata['user_id']);

		}

		else

		{

			$username = $lang['Guest'];

			$avatar_img = '<img src="' . $board_config['default_avatar_guests_url'] . '" alt="" />';

		}

		if ($userdata['user_id'] != '-1')

		{

			$userdata['username'] = colorize_username($userdata['user_id']);

			$name_link =  $userdata['username'];

		}

		else

		{

			$name_link = $lang['Guest'];

		}

// Custom Profile Fields - BEGIN

// Include Language

$language = $board_config['default_lang'];

if ( !file_exists($phpbb_root_path . 'language/lang_' . $language . '/lang_profile_fields.' . $phpEx) )

{

	$language = 'english';

}

include($phpbb_root_path . 'language/lang_' . $language . '/lang_profile_fields.' . $phpEx);

include_once($phpbb_root_path . 'includes/functions_profile_fields.' . $phpEx);

$profile_data = get_fields('WHERE view_in_profile = ' . VIEW_IN_PROFILE . ' AND users_can_view = ' . ALLOW_VIEW);

$profile_names = array();

$abouts = array();

$contacts = array();

foreach($profile_data as $field)

{

	$name = $field['field_name'];

	$col_name = text_to_column($field['field_name']);

	$id = $userdata['user_id'];

	$type = $field['field_type'];

	$location = $field['profile_location'];

	$field_id = $field['field_id'];

	$field_name = $field['field_name'];

	if (isset($lang[$field_id . '_' . $field_name]))

	{

		$field_name = $lang[$field_id . '_' . $field_name];

	}

	$sql = "SELECT $col_name FROM " . USERS_TABLE . "

		WHERE user_id = $id";

	if(!($result = $db->sql_query($sql)))

	{

		message_die(GENERAL_ERROR,'Could not obtain field value','',__LINE__,__FILE__,$sql);

	}

	$temp = $db->sql_fetchrow($result);

	$profile_names[$name] = displayable_field_data($temp[$col_name],$field['field_type']);

	$tmp_field = $profile_names[$name];

	if (isset($lang[$field_id . '_' . $tmp_field]))

	{

		$profile_names[$name] = $lang[$field_id . '_' . $tmp_field];

	}

	if($location == 1)

	{

		$contacts[] = '<td valign="middle" align="left" nowrap="nowrap"  width="38%"><span class="gen">' . $field_name . '</span></td><td class="row2" valign="middle" width="100%"  align="right"><span class="gen">' . $profile_names[$name] . '&nbsp;</span></td>';

	}

	else

	{

		$abouts[] = '<td class="row2" valign="middle" width="100%"  align="center"><span class="gen"><img src="http://avatar.xboxlive.com/avatar/' . $profile_names[$name] . '/avatar-body.png" /></span></td>';

	}

}

foreach($abouts as $about_field)

{

	$template->assign_block_vars('custom_about',array('ABOUT' => $about_field));

}

foreach($contacts as $contact_field)

{

	$template->assign_block_vars('custom_contact',array('CONTACT' => $contact_field));

}

// Custom Profile Fields - END

		$template->assign_vars(array(

			'AVATAR_IMG' => $avatar_img,

			'U_NAME_LINK' => $name_link,

			'L_REMEMBER_ME' => $lang['Remember_me'],

			'L_SEND_PASSWORD' => $lang['Forgotten_password'],

			'U_SEND_PASSWORD' => append_sid(PROFILE_MG . '?mode=sendpassword'),

			'L_REGISTER_NEW_ACCOUNT' => sprintf($lang['Register_new_account'], '<a href="' . append_sid(PROFILE_MG . '?mode=register') . '">', '</a>'),

			'L_NEW_SEARCH' => $lang['Search_new']

			)

		);

	}

}

imp_user_block_block_func();

?>

open templates/YOUR TEMPLATE/blocks/user_block_block.tpl

and replace all the code with

Spoiler: [ Show ]

Goto admin and set the field to whatever you are calling it...

Field Type text
Viewable in User Profile yes
These options are for if this field is to be viewed in the user's profile. about column

and save

you just have to add your name to the text box you have created so for you it would be n1cks21

but I am not sure if you can create any more custom fields now though

logged out

logged in

Let me know

n1cks21 [ Mon 16 Feb, 2009 21:33 ]
Post subject: Re: User Block Mod

Thanks for looking at this for me, It still doesnt work however it doesnt give me any errors either, basically when you log in it puts you on the profile page and not the home page, if you click on home page, you simply get the users login name ??? I had already created a custom field and it was already set as

Field Type text
Viewable in User Profile yes

DWho [ Mon 16 Feb, 2009 21:36 ]
Post subject: Re: User Block Mod

I have this working on my site.... did you copy all the code over...

and set it to the about column

and you copied the code for the php block code as well as the tpl code.... 2 files

n1cks21 [ Mon 16 Feb, 2009 23:58 ]
Post subject: Re: User Block Mod

school boy error

yes it works fine now I have changed it to the about column, which you stated in your last post

Thank you soooooo much, you are the man, what a cracking xbox360 mod, one question though what are the chances of getting the text info underneath the avatar as shown on the pic below

or am I pushing my luck and I should be happy with what I have got hehehehehehehehehehe

Eitherway I would like to thank everyone who has helped.........

DWho [ Tue 17 Feb, 2009 00:32 ]
Post subject: Re: User Block Mod

Glad you got it sorted... I will post the modification in a new post so others can download the zip

where did you get the other info from then I can add it..

n1cks21 [ Tue 17 Feb, 2009 00:52 ]
Post subject: Re: User Block Mod

I seem to have this problem now, sorry only just noticed it :-

the picture that is trying to be displayed os the avatar pic

"http://avatar.xboxlive.com/avatar//avatar-body.png"

not sure why it's trying to do that ????

my code for blocks_imp_user_block

Spoiler: [ Show ]

and my user_block_block

Spoiler: [ Show ]

DWho [ Fri 20 Feb, 2009 23:42 ]
Post subject: Re: User Block Mod

did you sort this.... ?

n1cks21 [ Sat 21 Feb, 2009 01:27 ]
Post subject: Re: User Block Mod

no any help would be great

DWho [ Sat 21 Feb, 2009 12:06 ]
Post subject: Re: User Block Mod

ok try this open

user_block_block.tpl

replace all the code with this

Spoiler: [ Show ]

nothing else to change...

have tested in firefox and IE

let me know

n1cks21 [ Sat 21 Feb, 2009 13:50 ]
Post subject: Re: User Block Mod

fan-bloody-tastic

Works a treat now, a mega xbox360 mod thanks for making my idea become reality

the only thing I would like to add would be the old code below, to underneath the avatar

Spoiler: [ Show ]

once again Thank You for all your time and effort you put into this, its much appreciated.

DWho [ Sat 21 Feb, 2009 15:09 ]
Post subject: Re: User Block Mod

brilliant...

to add the last bit of code...

open user_block_block.tpl

find

Code: [Hide] [Select]

                                   <!-- BEGIN custom_about -->

                                    <span class="name">{U_NAME_LINK}</span>

                       <tr>{custom_about.ABOUT}</tr>

                       <!-- END custom_about -->

and replace with

Code: [Hide] [Select]

                                    <!-- BEGIN custom_about -->

                        <tr>{custom_about.ABOUT}</tr>

                        <!-- END custom_about -->

						<tr>

						<td align="center">

						        <span class="name">{U_NAME_LINK}</span><br />

        <span class="gensmall">{LAST_VISIT_DATE}</span><br />

        <span class="gensmall"><a href="{U_SEARCH_NEW}">{L_NEW_SEARCH}</a></span><br /><br /></td>

		<tr>

let me know

n1cks21 [ Sat 21 Feb, 2009 16:21 ]
Post subject: SOLVED - Re: User Block Mod

SPOT ON !!!!!!!!!!!!!!!!!!! it looks fantastic

again thanks for all your time, effort and trouble

DWho [ Sat 21 Feb, 2009 16:29 ]
Post subject: Re: User Block Mod

no problem happy to help... glad it is all fixed now...

n1cks21 [ Sun 22 Feb, 2009 01:36 ]
Post subject: Re: SOLVED - User Block Mod

dont want to be a pain in the arse but the only other change is simply cosmetic

Forum Page

the avatar pic has a border of some sort so there is a line across the block

Home Page

same as the first one with a border but the bottom is a different colour from the top

*****************UPDATE******************

I fixed it by doing the following, not sure if it's the best way or indeed the easiest but I do like to try and fix my problems first:-

blocks_imp_user_block

Spoiler: [ Show ]

and

user_block_block

Spoiler: [ Show ]

bgcolor="#081838" and changed this to the colour I wanted.

result is:-

DWho [ Sun 22 Feb, 2009 13:41 ]
Post subject: Re: SOLVED - User Block Mod

Nice one and thanks for posting the fix....

n1cks21 [ Mon 23 Feb, 2009 15:48 ]
Post subject: Re: SOLVED - User Block Mod

no worries, there was propbably a better way, but it works for me

thanks again.............

n1cks21 [ Sun 13 Sep, 2009 11:23 ]
Post subject: Re: SOLVED - User Block Mod

Hi all the above mod is fantastic and works a treat on my site however it's time to move to 1.3.0.53 and I wondered how hard it would be to update the above mod to work on the new version ????

cheers

Nick

Lopalong [ Sun 13 Sep, 2009 14:00 ]
Post subject: Re: SOLVED - User Block Mod

I shouldn't think it would be any problem - But did you check that DWho hasn't already done it and has it available on his site - Before you asked the question?

I also find it annoying that users suggest such things as "I will upgrade to 53 etc, so long as this MOD is available"

You upgrade - Then I'll sure Mike will (if necessary) upgrade the MOD - WHEN HE FINDS THE TIME!

n1cks21 [ Sun 13 Sep, 2009 14:31 ]
Post subject: Re: SOLVED - User Block Mod

Lopalong wrote: [View Post]
I shouldn't think it would be any problem - But did you check that DWho hasn't already done it and has it available on his site - Before you asked the question?

I also find it annoying that users suggest such things as "I will upgrade to 53 etc, so long as this MOD is available"

You upgrade - Then I'll sure Mike will (if necessary) upgrade the MOD - WHEN HE FINDS THE TIME!

yeah I did have a look on DWho site, I didnt see it so I posted the question on here..... I would also like to avoid downtime as well, so it only makes sense to upgrade and install the mods at the same time, I have installed the new software on the test area of my server, I now want to add the mods so I know everything works before I go live. I have already installed 2 of your fantastic mods (Security Question and Urls) and all I think is left is the above mod as well as the 80% mod.

I always give praise to you guys as I think you all do a fantastic job, my site has had lots of positive feedback and I owe that to you guys..... so I am sorry if I offended or annoyed you....

Lopalong [ Sun 13 Sep, 2009 14:41 ]
Post subject: Re: SOLVED - User Block Mod

Then it would be appropriate for you to register at Mike's site and ask him if he would consider checking the MOD and upgrading it (if necessary) when he gets the time. Because pushing the issue ain't going to win you any friends.

MODS take a lot of work my friend - So does upgrading existing ones to IP v1.3* - And, you haven't even tested what you've got yet, (Even on localhost - which you should have) so you don't even know if it doesn't work.

n1cks21 [ Sun 13 Sep, 2009 14:54 ]
Post subject: Re: SOLVED - User Block Mod

my bad, I wrongly assumed that all previous mods wouldnt work on the new version. I will put my current mods on the new version and see what happens.

thanks for the info and sorry for wssting your time............

Icy Phoenix

Old Support Topics - SOLVED - User Block Mod