Untitled

<?php

if (!defined('CPG_NUKE'))
{
    exit;
}

$pagetitle .= 'Staff';
get_lang($module_name);
require_once('header.php');

$cpgtpl->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']) ? '<img src="'.$ranksrow[$j]['rank_image'].'" alt="'.$poster_rank.'" title="'.$poster_rank.'" border="0" />' : '';
            }
        }
        
        // 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 = '<a title="'.$name.'" href="' . getlink('Groups&amp;g='.$id) . '">'.$name.'</a><br />';
		        }
	        }
        }
        
	    $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') ? '<a href="'.getlink('Private_Messages&amp;mode=post&amp;u='.$userid).'"><img src="'.$image.'icon_pm.gif" alt="'._SENDIM.'" title="'._SENDIM.'" border="0" /></a>' : '',
		    'WWW' => ($user_array[$loop]['user_website']) ? '<a href="'.$user_array[$loop]['user_website'].'" target="_userwww"><img src="'.$image.'icon_www.gif" alt="'._VISITWEB.'" title="'._VISITWEB.'" border="0" /></a>' : '',
		    'ICQ' => ($user_array[$loop]['user_icq']) ? '<a href="http://wwp.icq.com/scripts/search.dll?to='.$user_array[$loop]['user_icq'].'"><img src="'.$image.'icon_icq.gif" alt="'._ICQ.'" title="'._ICQ.'" border="0" /></a>' : '',
		    'AIM' => ($user_array[$loop]['user_aim']) ? '<a href="aim:goim?screenname='.$user_array[$loop]['user_aim'].'&amp;message=Hello+Are+you+there?"><img src="'.$image.'icon_aim.gif" alt="'._AIM.'" title="'._AIM.'" border="0" /></a>' : '',
		    'MSN' => ($user_array[$loop]['user_msnm']) ? '<img src="'.$image.'icon_msnm.gif" alt="'._MSN.'" title="'._MSN.'" border="0" />' : '',
		    'YIM' => ($user_array[$loop]['user_yim']) ? '<a href="http://edit.yahoo.com/config/send_webmesg?.target='.$user_array[$loop]['user_yim'].'&amp;.src=pg"><img src="'.$image.'icon_yim.gif" alt="'._YIM.'" title="'._YIM.'" border="0" /></a>' : '',
		    'VIEWPROFILE' => getlink('Your_Account&amp;profile='.$userid)
		));
		
		unset($user_array[$loop], $members_groups[$user_array[$loop]['user_id']]);
	}
}
$cpgtpl->set_filenames(array('body' => 'staff_list.html'));
$cpgtpl->display('body');