sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain ranks information', '', __LINE__, __FILE__, $sql);
}
$ranksrow = array();
while ( $row = $db->sql_fetchrow($result) )
{
$ranksrow[] = $row;
}
$db->sql_freeresult($result);
//
// Retrieve list of ignored ids
//
$sql = "SELECT i.ignored_id, u.username, u.user_id
FROM " . USERS_TABLE . " u, " . IGNORE_TABLE . " i
WHERE i.user_id = " . $userdata['user_id'] . "
AND i.ignored_id = " . $profiledata['user_id'];
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Error getting ignore listing', '', __LINE__, __FILE__, $sql);
}
$num_row = $db->sql_numrows($result);
if ($num_row > 0 )
{
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
$is_ignored = sprintf($profiledata['username'] . $lang['Is_ignored'], "", "");
$template->assign_block_vars('user_ignored', array(
'ROW_COLOR' => '#' . $row_color,
'ROW_CLASS' => $row_class,
'IGNORED' => $is_ignored)
);
}
//
// Output page header and profile_view template
//
$template->set_filenames(array(
'body' => 'profile_view_body.tpl')
);
make_jumpbox('viewforum.'.$phpEx);
//
// Calculate the number of days this user has been a member ($memberdays)
// Then calculate their posts per day
//
$regdate = $profiledata['user_regdate'];
$memberdays = max(1, round( ( time() - $regdate ) / 86400 ));
$posts_per_day = $profiledata['user_posts'] / $memberdays;
// Get the users percentage of total posts
if ( $profiledata['user_posts'] != 0 )
{
$total_posts = get_db_stat('postcount');
$percentage = ( $total_posts ) ? min(100, ($profiledata['user_posts'] / $total_posts) * 100) : 0;
}
else
{
$percentage = 0;
}
$avatar_img = '';
if ( $profiledata['user_avatar_type'] && $profiledata['user_allowavatar'] )
{
switch( $profiledata['user_avatar_type'] )
{
case USER_AVATAR_UPLOAD:
$avatar_img = ( $board_config['allow_avatar_upload'] ) ? '
' : '';
break;
case USER_AVATAR_REMOTE:
$avatar_img = ( $board_config['allow_avatar_remote'] ) ? '
' : '';
break;
case USER_AVATAR_GALLERY:
$avatar_img = ( $board_config['allow_avatar_local'] ) ? '
' : '';
break;
}
}
$poster_rank = '';
$rank_image = '';
$custom_title = '';
if ( $profiledata['user_rank'] )
{
for($i = 0; $i < count($ranksrow); $i++)
{
if ( $profiledata['user_rank'] == $ranksrow[$i]['rank_id'] && $ranksrow[$i]['rank_special'] )
{
$poster_rank = $ranksrow[$i]['rank_title'];
$rank_image = ( $ranksrow[$i]['rank_image'] ) ? '
' : '';
}
}
}
else
{
for($i = 0; $i < count($ranksrow); $i++)
{
if ( $profiledata['user_posts'] >= $ranksrow[$i]['rank_min'] && !$ranksrow[$i]['rank_special'] )
{
$poster_rank = $ranksrow[$i]['rank_title'];
$rank_image = ( $ranksrow[$i]['rank_image'] ) ? '
' : '';
}
}
}
if ( !empty($profiledata['user_custom_title']) )
{
switch( $board_config['custom_title_mode'] )
{
case CUSTOM_TITLE_MODE_INDEPENDENT:
$custom_title = $profiledata['user_custom_title'] . '
';
break;
case CUSTOM_TITLE_MODE_REPLACE_RANK:
$poster_rank = $profiledata['user_custom_title'];
break;
case CUSTOM_TITLE_MODE_REPLACE_BOTH:
$poster_rank = $profiledata['user_custom_title'];
$rank_image = '';
break;
default:
break;
}
}
$temp_url = append_sid("privmsg.$phpEx?mode=post&" . POST_USERS_URL . "=" . $profiledata['user_id']);
$pm_img = '![' . $lang['Send_private_message'] . '](' . $images['icon_pm'] . ' "' . $lang['Send_private_message'] . '")
';
$pm = '' . $lang['Send_private_message'] . '';
if ( !empty($profiledata['user_viewemail']) || $userdata['user_level'] == ADMIN )
{
$email_uri = ( $board_config['board_email_form'] ) ? append_sid("profile.$phpEx?mode=email&" . POST_USERS_URL .'=' . $profiledata['user_id']) : 'mailto:' . $profiledata['user_email'];
$email_img = '![' . $lang['Send_email'] . '](' . $images['icon_email'] . ' "' . $lang['Send_email'] . '")
';
$email = '' . $lang['Send_email'] . '';
}
else
{
$email_img = ' ';
$email = ' ';
}
$www_img = ( $profiledata['user_website'] ) ? '![' . $lang['Visit_website'] . '](' . $images['icon_www'] . ' "' . $lang['Visit_website'] . '")
' : ' ';
$www = ( $profiledata['user_website'] ) ? '' . $profiledata['user_website'] . '' : ' ';
if ( !empty($profiledata['user_icq']) )
{
$icq_status_img = '
';
$icq_img = '![' . $lang['ICQ'] . '](' . $images['icon_icq'] . ' "' . $lang['ICQ'] . '")
';
$icq = '' . $lang['ICQ'] . '';
}
else
{
$icq_status_img = ' ';
$icq_img = ' ';
$icq = ' ';
}
$aim_img = ( $profiledata['user_aim'] ) ? '![' . $lang['AIM'] . '](' . $images['icon_aim'] . ' "' . $lang['AIM'] . '")
' : ' ';
$aim = ( $profiledata['user_aim'] ) ? '' . $lang['AIM'] . '' : ' ';
$msn_img = ( $profiledata['user_msnm'] ) ? $profiledata['user_msnm'] : ' ';
$msn = $msn_img;
$yim_img = ( $profiledata['user_yim'] ) ? '![' . $lang['YIM'] . '](' . $images['icon_yim'] . ' "' . $lang['YIM'] . '")
' : '';
$yim = ( $profiledata['user_yim'] ) ? '' . $lang['YIM'] . '' : '';
$skype_img = ( $profiledata['user_skype'] ) ? '![' . $lang['SKYPE'] . '](' . $images['icon_skype'] . ' "' . $lang['SKYPE'] . '")
' : '';
$skype = ( $profiledata['user_skype'] ) ? '' . $lang['SKYPE'] . '' : '';
$temp_url = append_sid("search.$phpEx?search_author=" . urlencode($profiledata['username']) . "&showresults=posts");
$search_img = '![' . sprintf($lang['Search_user_posts'], $profiledata['username']) . '](' . $images['icon_search'] . ' "' . sprintf($lang['Search_user_posts'], $profiledata['username']) . '")
';
$search = '' . sprintf($lang['Search_user_posts'], $profiledata['username']) . '';
if ( $profiledata['user_weblog'] )
{
$sql = "SELECT weblog_name FROM " . WEBLOGS_TABLE . " WHERE weblog_id = " . $profiledata['user_weblog'];
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't obtain weblogs information.", "", __LINE__, __FILE__, $sql);
}
if( $row = $db->sql_fetchrow($result) )
{
$weblog = '' . $row['weblog_name'] . '';
}
}
//
// Generate page
//
$page_title = $lang['Viewing_profile'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
if (function_exists('get_html_translation_table'))
{
$u_search_author = urlencode(strtr($profiledata['username'], array_flip(get_html_translation_table(HTML_ENTITIES))));
}
else
{
$u_search_author = urlencode(str_replace(array('&', ''', '"', '<', '>'), array('&', "'", '"', '<', '>'), $profiledata['username']));
}
$template->assign_vars(array(
'USERNAME' => $profiledata['username'],
'JOINED' => create_date($lang['DATE_FORMAT'], $profiledata['user_regdate'], $board_config['board_timezone']),
'POSTER_RANK' => $poster_rank,
'CUSTOM_TITLE' => $custom_title,
'RANK_IMAGE' => $rank_image,
'POSTS_PER_DAY' => $posts_per_day,
'POSTS' => $profiledata['user_posts'],
'PERCENTAGE' => $percentage . '%',
'POST_DAY_STATS' => sprintf($lang['User_post_day_stats'], $posts_per_day),
'POST_PERCENT_STATS' => sprintf($lang['User_post_pct_stats'], $percentage),
'SEARCH_IMG' => $search_img,
'SEARCH' => $search,
'PM_IMG' => $pm_img,
'PM' => $pm,
'EMAIL_IMG' => $email_img,
'EMAIL' => $email,
'WWW_IMG' => $www_img,
'WWW' => $www,
'ICQ_STATUS_IMG' => $icq_status_img,
'ICQ_IMG' => $icq_img,
'ICQ' => $icq,
'AIM_IMG' => $aim_img,
'AIM' => $aim,
'MSN_IMG' => $msn_img,
'MSN' => $msn,
'YIM_IMG' => $yim_img,
'YIM' => $yim,
'SKYPE_IMG' => $skype_img,
'SKYPE' => $skype,
'WEBLOG' => $weblog,
'L_WEBLOG' => $lang['Weblog'],
'LOCATION' => ( $profiledata['user_from'] ) ? $profiledata['user_from'] : ' ',
'OCCUPATION' => ( $profiledata['user_occ'] ) ? $profiledata['user_occ'] : ' ',
'INTERESTS' => ( $profiledata['user_interests'] ) ? $profiledata['user_interests'] : ' ',
'AVATAR_IMG' => $avatar_img,
'L_VIEWING_PROFILE' => sprintf($lang['Viewing_user_profile'], $profiledata['username']),
'L_ABOUT_USER' => sprintf($lang['About_user'], $profiledata['username']),
'L_AVATAR' => $lang['Avatar'],
'L_POSTER_RANK' => $lang['Poster_rank'],
'L_JOINED' => $lang['Joined'],
'L_TOTAL_POSTS' => $lang['Total_posts'],
'L_SEARCH_USER_POSTS' => sprintf($lang['Search_user_posts'], $profiledata['username']),
'L_CONTACT' => $lang['Contact'],
'L_EMAIL_ADDRESS' => $lang['Email_address'],
'L_EMAIL' => $lang['Email'],
'L_PM' => $lang['Private_Message'],
'L_ICQ_NUMBER' => $lang['ICQ'],
'L_YAHOO' => $lang['YIM'],
'L_SKYPE' => $lang['SKYPE'],
'L_AIM' => $lang['AIM'],
'L_MESSENGER' => $lang['MSNM'],
'L_WEBSITE' => $lang['Website'],
'L_LOCATION' => $lang['Location'],
'L_OCCUPATION' => $lang['Occupation'],
'L_INTERESTS' => $lang['Interests'],
'U_SEARCH_USER' => append_sid("search.$phpEx?search_author=" . $u_search_author),
// Photo Album Addon v2.x.x by Smartor
'U_PERSONAL_GALLERY' => append_sid("album_personal.$phpEx?user_id=" . $profiledata['user_id']),
'L_PERSONAL_GALLERY' => sprintf($lang['Personal_Gallery_Of_User'], $profiledata['username']),
'S_PROFILE_ACTION' => append_sid("profile.$phpEx"))
);
$cm_viewprofile->post_vars($template,$profiledata,$userdata);
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>