phpBB Sverige

Kod: Markera allt

$sql = "SELECT u.user_avatar, u.user_avatar_type, u.user_id, u.user_allowavatar, u.username
			FROM " . USERS_TABLE . " u
			WHERE u.user_id = " . $userdata['user_id'] ;
		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not query user information', '', __LINE__, __FILE__, $sql);
		}
			$avatarrow = $db->sql_fetchrow($result);

		if ( $avatarrow['user_avatar_type'] && $userdata['user_id'] != ANONYMOUS && $avatarrow['user_allowavatar'] )
		{
			switch( $avatarrow['user_avatar_type'] )
			{
				case USER_AVATAR_UPLOAD:
					$user_avatar = ( $board_config['allow_avatar_upload'] ) ? $board_config['avatar_path'] . '/' . $avatarrow['user_avatar'] : '';
					break;
				case USER_AVATAR_REMOTE:
					$user_avatar = ( $board_config['allow_avatar_remote'] ) ? $avatarrow['user_avatar'] : '';
					break;
				case USER_AVATAR_GALLERY:
					$user_avatar = ( $board_config['allow_avatar_local'] ) ? $board_config['avatar_gallery_path'] . '/' . $avatarrow['user_avatar'] : '';
					break;
			}
			$user_avatar = '<a href="' . append_sid('search.'.$phpEx.'?search_id=egosearch') .
					'"><img src="' . $user_avatar . '" alt="' . $avatarrow['username'] . '" border="0" /></a><br>';
		}
		$user_name = '<a href="' . append_sid('profile.'.$phpEx.'?mode=editprofile') .
				'"><b>' . $avatarrow['username'] . '</b></a>';

		$sql = "SELECT COUNT(post_id) as tot
			FROM " . POSTS_TABLE . "
			WHERE post_time >= " . $userdata['user_lastvisit'] . "
			AND poster_id != " . $userdata['user_id'];

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

		if( $result )
		{
			$row = $db->sql_fetchrow($result);
			$user_newposts = '<a href="' . append_sid('search.'.$phpEx.'?search_id=newposts') .
						'" class="gensmall">' . $lang['Search_new'] . ' (' . $row['tot'] .')</a>';
		}
	
	else
	{
		$user_avatar = '';
	}