phpBB.de

Code: Alles auswählen

   $user_id = request_var('u', 0);
   $start   = request_var('start', 0);
   $limit = request_var('limit', intval($config['number_friends']));
   $sql = $db->sql_build_query('SELECT', array(
   'SELECT'   => 'u.user_avatar, u.username, u.user_colour, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, z.user_id, u.user_regdate, u.user_lastvisit, user_posts, z.zebra_id, z.friend',
   'FROM'      => array(
      USERS_TABLE      => 'u',
   ),
   'LEFT_JOIN'   => array(
      array(
         'FROM'   => array(ZEBRA_TABLE => 'z'),
         'ON'   => 'u.user_id=z.zebra_id'      
      )
   ),
      'WHERE'      => " u.user_id=z.zebra_id AND z.friend = 1 AND z.user_id = $user_id",
      'ORDER_BY'   => 'z.zebra_id'
   ));
   $result = $db->sql_query_limit($sql, $limit, $start);
         
   while($row_av = $db->sql_fetchrow( $result ))
   {
      $avatar_friend = get_user_avatar($row_av['user_avatar'], $row_av['user_avatar_type'], $row_av['user_avatar_width'],       $row_av['user_avatar_height']);
      $friend_id = $row_av['zebra_id'];
      $avatar_size_size = $config['friend_avatar_size'];

      $template->assign_block_vars('fri',array(

            'FRI_ID'            => $row_av['zebra_id'],
            'FRI_AV'            => $avatar_friend,
            'USERNAME'         => $row_av['username'],
            'WIDTH'            => $config['friend_avatar_size'],
            'USER_COLOR'       => $row_av['user_colour'],
            'AV_LINK'         => append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=viewprofile&u=$friend_id"), 
            'FRI_AV_THUMB'      =>   ($row_av['user_avatar']) ? get_user_avatar($row_av['user_avatar'], $row_av['user_avatar_type'], ($row_av['user_avatar_width'] > $row_av['user_avatar_height']) ? $avatar_size_size : ($avatar_size_size / $row_av['user_avatar_height']) * $row_av['user_avatar_width'], ($row_av['user_avatar_height'] > $row_av['user_avatar_width']) ? $avatar_size_size : ($avatar_size_size / $row_av['user_avatar_width']) * $row_av['user_avatar_height']) : '',
            'ONLINE_USER'      => is_user_online($row_av['zebra_id'])
));
}    

Code: Alles auswählen

<!-- IF HAS_FRIENDS -->
<h6>FREUNDE</h6>
<!-- ENDIF -->

Code: Alles auswählen

    $sql = 'SELECT user_id
			FROM ' . ZEBRA_TABLE . "
			WHERE user_id = $user_id";
      
		$result = $db->sql_query($sql);
		$row = $db->sql_fetchrow($result);
    $has_friends = ($row['user_id']) ? true : false;
		$db->sql_freeresult($result);
		$template->assign_vars(array(
			'HAS_FRIENDS'	=> $has_friends,
    ));

Code: Alles auswählen

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

Code: Alles auswählen

$result['num_rows'] > 0;