phpBB.de

Code: Alles auswählen

<?php
/**
*
* @package phpBB3
* @version $Id: functions_profileviews.php 252 2009-11-23 20:51:27Z lefty74 $
* @copyright (c) 2008 lefty74
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
	exit;
}

/**
* this  is the visit counter
**/
function count_visit($profile_user_id)
{
	global $config, $db, $user;

	$time = time();
	// Check whether the user viewing has already viewed the profile before
	$sql = 'SELECT *
		FROM ' . PROFILE_VIEWS_TABLE . "
		WHERE profile_user_id = " . (int) $profile_user_id . " 
		AND viewer_user_id = " . (int) $user->data['user_id'];

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

	if ( $row = $db->sql_fetchrow($result) )
	{
		if ( ($row['viewer_visit_time'] + $config['flood_profile_views']) < $time )
		{
			//user has viewed before so only update the time of last view and the counter
			$viewer_user_counter = $row['viewer_user_counter'] + 1;
			$sql_ary = array(
			'viewer_visit_time'		=> (int) $time,
			'viewer_user_counter'	=> (int) $viewer_user_counter
			);

			$sql = 'UPDATE ' . PROFILE_VIEWS_TABLE . '
				SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
				WHERE viewer_user_id = ' . (int) $user->data['user_id'] . '
				AND profile_user_id = ' . (int) $profile_user_id;
			$db->sql_query($sql);
		}
	}
	else
	{
		//first time the user views the profile so lets insert him into the database
		$sql_ary = array(
			'profile_user_id'		=> (int) $profile_user_id,
			'viewer_user_id'		=> (int) $user->data['user_id'],
			'viewer_visit_time'		=> (int) $time,
			'viewer_user_counter'	=> 1
		);

		$db->sql_query('INSERT INTO ' . PROFILE_VIEWS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));

	}
	$db->sql_freeresult($result);
}		
		
/**
* Generate the profile view list in the users profile
**/
function generate_profile_view_list($user_id)
{
	global $config, $db, $user;
	global $template, $phpbb_root_path, $phpEx;

	$profile_user_id_list = $total_profile_views = '';
	$profile_views = array();
	// generate the profile views list
	$user_id = (int) $user_id;
	$sql = 'SELECT p.*, u.user_id, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, u.username, u.user_colour
		FROM ' . PROFILE_VIEWS_TABLE . ' p, ' . USERS_TABLE. " u
		WHERE p.profile_user_id = $user_id
			AND p.viewer_user_id = u.user_id
		ORDER BY p.viewer_visit_time DESC";
	$result = $db->sql_query($sql);
	while ($row = $db->sql_fetchrow($result))
	{
		$profile_views[] = $row;
		$total_profile_views = $total_profile_views + $row['viewer_user_counter'];
	}
	$db->sql_freeresult($result);

	for ($i = 0, $end = (sizeof($profile_views) < $config['amount_profile_views']) ? sizeof($profile_views) : $config['amount_profile_views']; $i < $end; $i ++)
	{

		if ( $profile_views[$i]['user_id'] == ANONYMOUS)
		{
			$profile_views[$i]['username'] = $user->lang['GUEST'];
		}


		$avatar_max_dimensions = $avatar_width = $avatar_title = $avatar_height = $profile_views_avatar = '';
		$avatar_max_dimensions = (int) $config['pvavatar_max_dimensions']; 
		$avatar_title = sprintf($user->lang['PROFILE_VIEWS_AVA_TITLE'], $profile_views[$i]['username'], $user->format_date($profile_views[$i]['viewer_visit_time']));
		if ( !empty($profile_views[$i]['user_avatar']) )
		{

			if ( $profile_views[$i]['user_avatar_width'] >= $profile_views[$i]['user_avatar_height'] )
			{
				$avatar_width = ( $profile_views[$i]['user_avatar_width'] > $avatar_max_dimensions ) ? $avatar_max_dimensions : $profile_views[$i]['user_avatar_width'] ;
				$avatar_height = ( $avatar_width == $avatar_max_dimensions ) ? round($avatar_max_dimensions / $profile_views[$i]['user_avatar_width'] * $profile_views[$i]['user_avatar_height']) : $profile_views[$i]['user_avatar_height'] ;
			}
			else
			{
				$avatar_height = ( $profile_views[$i]['user_avatar_height'] > $avatar_max_dimensions ) ? $avatar_max_dimensions : $profile_views[$i]['user_avatar_height'] ;
				$avatar_width = ( $avatar_height == $avatar_max_dimensions ) ? round($avatar_max_dimensions / $profile_views[$i]['user_avatar_height'] * $profile_views[$i]['user_avatar_width']) : $profile_views[$i]['user_avatar_width'] ;
			}
			$profile_views_avatar = get_user_avatar($profile_views[$i]['user_avatar'], $profile_views[$i]['user_avatar_type'], $avatar_width, $avatar_height, $profile_views[$i]['username']);

		}
		else
		{
			$avatar_img = $phpbb_root_path . 'styles/' . $user->theme['imageset_path'] . '/theme/images/no_avatar.gif';
			$profile_views_avatar = '<img src="' . $avatar_img . '" width="' . $avatar_max_dimensions . '" title="' . $avatar_title . '" alt="' . $profile_views[$i]['username'] . '" height="' . $avatar_max_dimensions . '" />';
		}

		$profile_views_name = ( utf8_strlen($profile_views[$i]['username']) > 9 ) ? utf8_substr($profile_views[$i]['username'], 0, 6) . '...' : $profile_views[$i]['username'];

		$template->assign_block_vars('profile_views', array(
		'AVATAR'				=> ( $profile_views[$i]['viewer_user_id'] == ANONYMOUS ) ? $profile_views_avatar : '<a href="' . get_username_string('profile', $profile_views[$i]['user_id'], $profile_views[$i]['username'], $profile_views[$i]['user_colour']) . '" title="' . $avatar_title . '">' . $profile_views_avatar . '</a>',
		'PROFILE_VIEWS_LIST'	=> ( $profile_views[$i]['viewer_user_id'] == ANONYMOUS ) ? '<span title="' . $avatar_title . '" >' . $profile_views[$i]['username'] . '</span>' : '<span title="' . $avatar_title . '" >' . get_username_string('full', $profile_views[$i]['user_id'], $profile_views_name, $profile_views[$i]['user_colour']) . '</span>',
		));
	}
	$template->assign_vars(array(
	'S_PROFILE_VIEWS'		=> $config['display_profile_views'] ? true : false,
	'PROFILE_VIEWS'			=> $total_profile_views,
	'S_PROFILE_VIEW_ACTION'	=> append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=profile_views&u=' . $user_id),
	));
}

/**
* Obtain Profile Views Details
**/
function get_profile_views_details($profile_user_id)
{
	global $config, $db, $user, $auth;
	global $template, $phpbb_root_path, $phpEx;

	$start	= request_var('start', 0);
	$pv_default_key = 'c';
	$pv_sort_key = request_var('sk', $pv_default_key);
	$pv_sort_dir = request_var('sd', 'd');
	
	// Get user...
	$sql = 'SELECT *
		FROM ' . USERS_TABLE . '
		WHERE user_id = ' . (int) $profile_user_id;
	$result = $db->sql_query($sql);
	$pv_member = $db->sql_fetchrow($result);
	$db->sql_freeresult($result);

	if (!$pv_member)
	{
		trigger_error('NO_USER');
	}

	$user_id = (int) $pv_member['user_id'];

	if ($config['load_onlinetrack'])
	{
		$sql = 'SELECT MAX(session_time) AS session_time, MIN(session_viewonline) AS session_viewonline
			FROM ' . SESSIONS_TABLE . "
			WHERE session_user_id = $user_id";
		$result = $db->sql_query($sql);
		$row = $db->sql_fetchrow($result);
		$db->sql_freeresult($result);

		$pv_member['session_time'] = (isset($row['session_time'])) ? $row['session_time'] : 0;
		$pv_member['session_viewonline'] = (isset($row['session_viewonline'])) ? $row['session_viewonline'] :	0;
		unset($row);
	}

	$pf_member_avatar = get_user_avatar($pv_member['user_avatar'], $pv_member['user_avatar_type'], $pv_member['user_avatar_width'], $pv_member['user_avatar_height']);

	$template->assign_vars(show_profile($pv_member));

	$total_views = $total_viewers = $most_viewed = '';
	$sql = 'SELECT COUNT(viewer_user_id) AS total_viewers, SUM(viewer_user_counter) AS total_views, MAX(viewer_user_counter) as most_viewed
		FROM ' . PROFILE_VIEWS_TABLE . " 
		WHERE profile_user_id = " . $user_id;
	$result = $db->sql_query($sql);
	$row = $db->sql_fetchrow($result);
	$total_views = (int) $row['total_views'];
	$total_viewers = (int) $row['total_viewers'];
	$most_viewed = (int) $row['most_viewed'];
	$db->sql_freeresult($result);

	$viewers_per_page = (int) $config['amount_profile_views_detail']; 
	$avatar_max_dimensions = (int) $config['pvavatar_max_dimensions']; 
	
	// Sorting
	$pv_sort_key_sql = array('a' => 'u.username', 'b' => 'p.viewer_user_counter', 'c' => 'p.viewer_visit_time');

	$pv_order_by = '';

	// Sorting and order
	if (!isset($pv_sort_key_sql[$pv_sort_key]))
	{
		$pv_sort_key = $pv_default_key;
	}

	$pv_order_by .= ($pv_sort_key_sql[$pv_sort_key] == 'u.username') ? 'LOWER(' . $pv_sort_key_sql[$pv_sort_key] . ') ' . (($pv_sort_dir == 'a') ? 'ASC' : 'DESC') : $pv_sort_key_sql[$pv_sort_key] . ' ' . (($pv_sort_dir == 'a') ? 'ASC' : 'DESC');
	
	$pagination_url = append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=profile_views&u={$user_id}&sk={$pv_sort_key}&sd={$pv_sort_dir}");
	
	$sql_limit = min($viewers_per_page, max(1, $total_viewers - $start));

	$profile_user_id_list = $total_profile_views = '';
	$profile_views = array();

	// generate the profile views list
	$sql = 'SELECT p.*, u.*
		FROM ' . PROFILE_VIEWS_TABLE . ' p, ' . USERS_TABLE. " u
		WHERE p.profile_user_id = $user_id
		AND p.viewer_user_id = u.user_id
		ORDER BY $pv_order_by";
	$result = $db->sql_query_limit($sql, $sql_limit, $start);

	while ($row = $db->sql_fetchrow($result))
	{
		//in case someone enables guest view counting
		if ( $row['user_id'] == ANONYMOUS)
		{
			$row['username'] = $user->lang['GUEST'];
		}


		$avatar_width = $avatar_title = $avatar_height = $profile_views_avatar = '';

		if ( !empty($row['user_avatar']) )
		{
			if ( $row['user_avatar_width'] >= $row['user_avatar_height'] )
			{
				$avatar_width = ( $row['user_avatar_width'] > $avatar_max_dimensions ) ? $avatar_max_dimensions : $row['user_avatar_width'] ;
				$avatar_height = ( $avatar_width == $avatar_max_dimensions ) ? round($avatar_max_dimensions / $row['user_avatar_width'] * $row['user_avatar_height']) : $row['user_avatar_height'] ;
			}
			else
			{
				$avatar_height = ( $row['user_avatar_height'] > $avatar_max_dimensions ) ? $avatar_max_dimensions : $row['user_avatar_height'] ;
				$avatar_width = ( $avatar_height == $avatar_max_dimensions ) ? round($avatar_max_dimensions / $row['user_avatar_height'] * $row['user_avatar_width']) : $row['user_avatar_width'] ;
			}
			$profile_views_avatar = get_user_avatar($row['user_avatar'], $row['user_avatar_type'], $avatar_width, $avatar_height, $row['username']);

		}
		else
		{
			$avatar_img = $phpbb_root_path . 'styles/' . $user->theme['imageset_path'] . '/theme/images/no_avatar.gif';
			$profile_views_avatar = '<img src="' . $avatar_img . '" width="' . $avatar_max_dimensions . '" title="' . $row['username'] . '" alt="' . $row['username'] . '" height="' . $avatar_max_dimensions . '" />';
		}


		if (!empty($row['user_allow_viewemail']) || $auth->acl_get('a_email'))
		{
			$email = ($config['board_email_form'] && $config['email_enable']) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=email&u=' . $row['user_id']) : (($config['board_hide_emails'] && !$auth->acl_get('a_email')) ? '' : 'mailto:' . $row['user_email']);
		}
		else
		{
			$email = '';
		}
		$pm = ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($row['user_allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_'))) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&mode=compose&u=' . $row['user_id']) : '';

		//in case someone enables guest view counting
		if ( $row['user_id'] == ANONYMOUS)
		{
			$email = '';
			$pm = '';
		}

		//obtain the avatar and username
		$template->assign_block_vars('profile_views', array(
			'USERNAME_CLEAN'	=> get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),
			'U_PM'		=> $pm,
			'U_EMAIL'	=> $email,
			'LAST_VIEW'	=> $user->format_date($row['viewer_visit_time']),
			'VIEWS'		=> $row['viewer_user_counter'],
			'AVATAR'	=> ( $row['viewer_user_id'] == ANONYMOUS ) ? $profile_views_avatar : '<a href="' . get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']) . '" title="' . $row['username'] . '">' . $profile_views_avatar . '</a>',
	
			'USERNAME'	=> ( $row['viewer_user_id'] == ANONYMOUS ) ? $row['username'] : get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
		));
		
	}
	$db->sql_freeresult($result);

	$most_viewer = $most_viewer_avatar = $most_viewer_link = '';
	$sql = 'SELECT p.*, u.*
		FROM ' . PROFILE_VIEWS_TABLE . ' p, ' . USERS_TABLE. " u
		WHERE p.profile_user_id = $user_id
			AND p.viewer_user_counter = $most_viewed
			AND p.viewer_user_id = u.user_id
		ORDER BY p.viewer_user_counter DESC";
	$result = $db->sql_query_limit($sql, 1, 0);

	while ($row2 = $db->sql_fetchrow($result))
	{
		$avatar_width = $avatar_title = $avatar_height = $profile_views_avatar = $profile_url = '';
		
		if ( !empty($row2['user_avatar']) )
		{
			if ( $row2['user_avatar_width'] >= $row2['user_avatar_height'] )
			{
				$avatar_width = ( $row2['user_avatar_width'] > $avatar_max_dimensions ) ? $avatar_max_dimensions : $row2['user_avatar_width'] ;
				$avatar_height = ( $avatar_width == $avatar_max_dimensions ) ? round($avatar_max_dimensions / $row2['user_avatar_width'] * $row2['user_avatar_height']) : $row2['user_avatar_height'] ;
			}
			else
			{
				$avatar_height = ( $row2['user_avatar_height'] > $avatar_max_dimensions ) ? $avatar_max_dimensions : $row2['user_avatar_height'] ;
				$avatar_width = ( $avatar_height == $avatar_max_dimensions ) ? round($avatar_max_dimensions / $row2['user_avatar_height'] * $row2['user_avatar_width']) : $row2['user_avatar_width'] ;
			}
			$most_viewer_avatar = get_user_avatar($row2['user_avatar'], $row2['user_avatar_type'], $avatar_width, $avatar_height, $row2['username']);
		}
		else
		{
			$avatar_img = $phpbb_root_path . 'styles/' . $user->theme['imageset_path'] . '/theme/images/no_avatar.gif';
			$most_viewer_avatar = '<img src="' . $avatar_img . '" width="' . $avatar_max_dimensions . '" title="' . $avatar_title . '" alt="' . $row2['username'] . '" height="' . $avatar_max_dimensions . '" />';
		}

		$most_viewer_link  = '<a href="' . get_username_string('profile', $row2['user_id'], $row2['username'], $row2['user_colour']) . '">' . $most_viewer_avatar . '</a>';
		
		
		if ( $row2['user_id'] == ANONYMOUS)
		{
			$most_viewer = $user->lang['GUEST'];
		}
		else
		{
			// If your style breaks due to long usernames, uncomment below line
			//$row2['username'] = ( utf8_strlen($row2['username']) > 12 ) ? utf8_substr($row2['username'], 0, 9) . '...' : $row2['username'];
			$most_viewer = get_username_string('full', $row2['user_id'], $row2['username'], $row2['user_colour']);
		}
 	
	}
	$db->sql_freeresult($result);

$template->assign_vars(array(
		'PROFILE_VIEWS'		=> $total_views,
		'PROFILE_VIEWERS'	=> $total_viewers,
		'RETURN_TO_PROFILE'	=> sprintf($user->lang['RETURN_PROFILE'], '<a href="' . get_username_string('profile', $pv_member['user_id'], $pv_member['username'], $pv_member['user_colour']) . '">', '</a>'),
		'MOST_VIEWED'		=> ($most_viewed) ? $most_viewed: '',
		'MOST_VIEWER'		=> ($most_viewer) ? $most_viewer : '',
		'VISITORS_PROFILE'	=> sprintf($user->lang['VISITORS_OF_PROFILE'], $pv_member['username']),
		'TITLE' 			=> sprintf($user->lang['PROFILE_VIEWS_OF'],$pv_member['username']),

		'U_SORT_PV_USERNAME'	=> append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=profile_views&u=' . $user_id . '&sk=a&sd=' . (($pv_sort_key == 'a' && $pv_sort_dir == 'a') ? 'd' : 'a')),
		'U_SORT_PV_VIEWS'		=> append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=profile_views&u=' . $user_id . '&sk=b&sd=' . (($pv_sort_key == 'b' && $pv_sort_dir == 'a') ? 'd' : 'a')),
		'U_SORT_PV_LAST_VIEW'	=> append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=profile_views&u=' . $user_id . '&sk=c&sd=' . (($pv_sort_key == 'c' && $pv_sort_dir == 'a') ? 'd' : 'a')),

		'PM_IMG'		=> $user->img('icon_contact_pm', $user->lang['SEND_PRIVATE_MESSAGE']),
		'EMAIL_IMG'		=> $user->img('icon_contact_email', $user->lang['EMAIL']),
		'AVATAR'		=> $most_viewer_link,
		'PAGINATION'    => generate_pagination($pagination_url, $total_viewers, $viewers_per_page, $start),
		'PAGE_NUMBER'   => on_page($total_viewers, $viewers_per_page, $start),
		'TOTAL_VIEWERS' => ($total_viewers == 1) ? $user->lang['PROFILE_VIEWER'] : sprintf($user->lang['PROFILE_VIEWERS'], $total_viewers)

	));
}

?>