assign_vars(array(
'L_USERNAME'=> _USER,
'L_POSTS' => _POS,
'L_JOINED' =>_JOIN,
'L_RANK' => _RANK,
'L_PM' => _PM,
'L_MESSANGER' => _IM,
'L_AIM' => _AIM,
'L_YIM' => _YIM,
'L_MSNM' => _MSN,
'L_ICQ' => _ICQ,
'L_WEBSITE' => _WEB,
'L_USERGP' => _USERGP)
);
$image = 'themes/'.$CPG_SESS['theme'].'/images/forums/lang_english/';
$ranksrow = $db->sql_ufetchrowset("SELECT * FROM ".$prefix."_bbranks ORDER BY rank_special, rank_min",SQL_ASSOC);
$result = $db->sql_query("SELECT * FROM ".$user_prefix."_users WHERE user_level >= '2' ORDER BY user_level = '3'");
$user_array = array();
while ( $row = $db->sql_fetchrow($result) );
{
$user_array[] = $row;
$user_ids[] = $row['user_id'];
}
$db->sql_freeresult($result);
if ($size = count($user_array))
{
// maybe not group_single_user here, since you don't display the single groups
$result = $db->sql_uquery('SELECT g.group_id, g.group_name, g.group_single_user, ug.user_id FROM '.$prefix.'_bbuser_group AS ug LEFT JOIN '.$prefix.'_bbgroups AS g ON ( ug.group_id = g.group_id ) WHERE ug.user_id IN IN (' . implode(', ', $user_ids) . ') AND ug.user_pending = 0');
$members_groups = array();
while ($row = $db->sql_fetchrow($result, SQL_ASSOC))
{
$members_groups[$row['user_id']][$row['group_id']] = ($row['group_single_user']) ? '' : $row['group_name'];
}
$db->sql_freeresult($result);
for ($loop = 0; $loop < $size; ++$loop)
{
$userid = $user_array[$loop]['user_id'];
if ($user_array[$loop]['user_avatar_type'] == 1)
{
$avatar = $MAIN_CFG['avatar']['path'].'/'.$user_array[$loop]['user_avatar'];
}
elseif ($user_array[$loop]['user_avatar_type'] == 2)
{
$avatar = $user_array[$loop]['user_avatar'];
}
elseif ($user_array[$loop]['user_avatar_type'] == 3)
{
$avatar = $MAIN_CFG['avatar']['gallery_path'].'/'.$user_array[$loop]['user_avatar'];
}
else
{
$avatar = $MAIN_CFG['avatar']['gallery_path'].'/'.$MAIN_CFG['avatar']['default'];
}
for ($j = 0; $j < count($ranksrow); $j++)
{
if (($user_array[$loop]['user_rank'] && $user_array[$loop]['user_rank'] == $ranksrow[$j]['rank_id'] && $ranksrow[$j]['rank_special']) || (!$user_array[$loop]['user_rank'] && $user_array[$loop]['user_posts'] >= $ranksrow[$j]['rank_min'] && !$ranksrow[$j]['rank_special']))
{
$poster_rank = $ranksrow[$j]['rank_title'];
$rank_image = ($ranksrow[$j]['rank_image']) ? '
' : '';
}
}
// Select all groups where the user is a member
if (isset($members_groups[$user_array[$loop]['user_id']]))
{
foreach ($members_groups[$user_array[$loop]['user_id']] as $id => $name)
{
if (!empty($name))
{
$s_member_groups = ''.$name.'
';
}
}
}
$cpgtpl->assign_block_vars('staff',array(
'USERNAME' => $user_array[$loop]['username'],
'LEVEL' => ($user_array[$loop]['user_level'] == 2) ? _FULLADMIN : _MODS,
'JOINED' => $user_array[$loop]['user_regdate'],
'RANK_IMG' => $rank_image,
'POSTS' => intval($user_array[$loop]['user_posts']),
'AVATAR_IMG' => $avatar,
'GROUP' => isset($s_member_groups) ? $s_member_groups : 'No Group Found',
'PM' => is_active('Private_Messages') ? '
' : '',
'WWW' => ($user_array[$loop]['user_website']) ? '
' : '',
'ICQ' => ($user_array[$loop]['user_icq']) ? '
' : '',
'AIM' => ($user_array[$loop]['user_aim']) ? '
' : '',
'MSN' => ($user_array[$loop]['user_msnm']) ? '
' : '',
'YIM' => ($user_array[$loop]['user_yim']) ? '
' : '',
'VIEWPROFILE' => getlink('Your_Account&profile='.$userid)
));
unset($user_array[$loop], $members_groups[$user_array[$loop]['user_id']]);
}
}
$cpgtpl->set_filenames(array('body' => 'staff_list.html'));
$cpgtpl->display('body');