pewnie mozna to jakos left joinem w jednym zapytaniu roziwazac ale ja nie umiem :-p
mozesz zrobi tak
znajdź
Kod:
$sql = "SELECT user_id, username, user_rank, user_posts, user_session_time
FROM ".USERS_TABLE."
WHERE user_id > 0
ORDER BY user_rank DESC, username ASC";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain user/day information', '', __LINE__, __FILE__, $sql);
}
$day_userlist = '';
$day_users = 0;
$not_day_userlist = '';
$not_day_users = 0;
while( $row = $db->sql_fetchrow($result) )
{
if ( $row['user_allow_viewonline'] )
{
$user_day_link = color_username($row['user_id'],$row['username'],$row['user_rank'],$row['user_posts']);
}
else
{
$user_day_link = color_username($row['user_id'],$row['username'],$row['user_rank'],$row['user_posts']);
}
if ( $row['user_allow_viewonline'] || $userdata['user_level'] == ADMIN )
{
if ( $row['user_session_time'] >= ( time() - $users_list_delay * 3600 ) )
{
$day_userlist .= ( $day_userlist != '' ) ? ', ' . $user_day_link : $user_day_link;
$day_users++;
}
else
{
$not_day_userlist .= ( $not_day_userlist != '' ) ? ', ' . $user_day_link : $user_day_link;
$not_day_users++;
}
}
}
zmien na
Kod:
$sql = "SELECT user_id, username, user_rank, user_posts, user_allow_viewonline, user_session_time
FROM ".USERS_TABLE."
WHERE user_id > 0
AND user_rank <> 0
ORDER BY user_rank ASC, username ASC";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain user/day information', '', __LINE__, __FILE__, $sql);
}
$day_userlist = '';
$day_users = 0;
$not_day_userlist = '';
$not_day_users = 0;
while( $row = $db->sql_fetchrow($result) )
{
if ( $row['user_allow_viewonline'] )
{
$user_day_link = color_username($row['user_id'],$row['username'],$row['user_rank'],$row['user_posts']);
}
else
{
$user_day_link = color_username($row['user_id'],$row['username'],$row['user_rank'],$row['user_posts']);
}
if ( $row['user_allow_viewonline'] || $userdata['user_level'] == ADMIN )
{
if ( $row['user_session_time'] >= ( time() - $users_list_delay * 3600 ) )
{
$day_userlist .= ( $day_userlist != '' ) ? ', ' . $user_day_link : $user_day_link;
$day_users++;
}
else
{
$not_day_userlist .= ( $not_day_userlist != '' ) ? ', ' . $user_day_link : $user_day_link;
$not_day_users++;
}
}
}
$sql = "SELECT user_id, username, user_rank, user_posts, user_allow_viewonline, user_session_time
FROM ".USERS_TABLE."
WHERE user_id > 0
AND user_rank = 0
ORDER BY user_rank ASC, username ASC";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain user/day information', '', __LINE__, __FILE__, $sql);
}
while( $row = $db->sql_fetchrow($result) )
{
if ( $row['user_allow_viewonline'] )
{
$user_day_link = color_username($row['user_id'],$row['username'],$row['user_rank'],$row['user_posts']);
}
else
{
$user_day_link = color_username($row['user_id'],$row['username'],$row['user_rank'],$row['user_posts']);
}
if ( $row['user_allow_viewonline'] || $userdata['user_level'] == ADMIN )
{
if ( $row['user_session_time'] >= ( time() - $users_list_delay * 3600 ) )
{
$day_userlist .= ( $day_userlist != '' ) ? ', ' . $user_day_link : $user_day_link;
$day_users++;
}
else
{
$not_day_userlist .= ( $not_day_userlist != '' ) ? ', ' . $user_day_link : $user_day_link;
$not_day_users++;
}
}
}
AIFM [1%] - kiedyś powstanie
Uwagi moderatora abc (dodane 10 Cze 2006, 13:10):
Ostatnio edytowany przez abc, 10 Cze 2006, 13:10, edytowano w sumie 1 raz