Verfasst: 27.01.2007 14:07
ja genau. es sollten nur die onlinen angezeigt werdenMiriam hat geschrieben: Das heisst also alle, die nicht online (also offline) sind, sollen nicht angezeigt werden?
phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
ja genau. es sollten nur die onlinen angezeigt werdenMiriam hat geschrieben: Das heisst also alle, die nicht online (also offline) sind, sollen nicht angezeigt werden?
Code: Alles auswählen
#
#-----[ OPEN ]------------------------------------------
#
listavatars.php
#
#-----[ FIND ]------------------------------------------
#
$sqlu= ' SELECT DISTINCT u.user_id, u.username, user_posts, u.user_avatar, u.user_avatar_type ' // Get all users who have posted at least 1 post
.' FROM '.USERS_TABLE.' u, '.POSTS_TABLE.' p '
.' WHERE u.user_id <> '.ANONYMOUS
.' and u.user_id = p.poster_id '
.($showonlyuserid ? ' and u.user_id = '.$showonlyuserid : '')
.' ORDER BY u.user_posts DESC '
.'';
$resultuser = $db->sql_query($sqlu);
$i = 0;
$tdclass = 1;
$sumofavatarsizesofuser = array();
$notshownavatarsofuser = array();
$sumofallavatars = 0;
$continue = '';
#
#-----[ AFTER, ADD ]------------------------------------------
#
$users = '0';
$sql = "SELECT session_user_id FROM ".SESSIONS_TABLE."
WHERE session_logged_in = 1";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$users .= "," . $row['session_user_id'];
}
$user_arr = explode(',', $users);
#
#-----[ FIND ]------------------------------------------
#
if ($avatars != '') // Display user, if the user has at least 1 avatar to show
{
$tdclass++;
$template->assign_block_vars('avatarblock', array(
'USERNAME' => $user['username'],
'USERNAMELINK' => append_sid($phpbb_root_path.'profile.'.$phpEx.'?mode=viewprofile&u='.$user['user_id']),
'ROW_CLASS' => ( !($tdclass % 2) ) ? $theme['td_class1'] : $theme['td_class2'],
'AVATARS' => $avatars
)
);
}
}
#
#-----[ BEFORE, ADD ]------------------------------------------
#
if (in_array($user['user_id'], $user_arr)) {
#
#-----[ AFTER, ADD ]------------------------------------------
#
}
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM