";
}
else
{
$$order_var = "&order=desc";
$$img_var = " 
";
}
if ( $this->ifthd->input['m_search'] )
{
$s_extra .= "&m_search=". $this->ifthd->input['m_search'];
}
$link_id = "ID". $img_id ."";
$link_name = "Name". $img_name ."";
$link_mgroup = "Group". $img_mgroup ."";
$link_open_tickets = "Open Tickets". $img_open_tickets ."";
$link_tickets = "Tickets". $img_tickets ."";
if ( $this->ifthd->input['sort'] )
{
$link_extra .= "&sort=". $this->ifthd->input['sort'];
}
if ( $this->ifthd->input['order'] )
{
$link_extra .= "&order=". $this->ifthd->input['order'];
}
if ( $this->ifthd->input['m_search'] )
{
$link_extra .= "&m_search=". $this->ifthd->input['m_search'];
}
#=============================
# Grab Members
#=============================
if ( $this->ifthd->input['st'] )
{
$start = $this->ifthd->input['st'];
}
else
{
$start = 0;
}
// Search?
if ( $this->ifthd->input['m_search'] )
{
// Filter?
if ( $this->ifthd->input['group'] )
{
$this->ifthd->core->db->query( "SELECT * FROM ". DB_PRE ."members WHERE mgroup = '". $this->ifthd->input['group'] ."' && name LIKE '%". $this->ifthd->input['m_search'] ."%' ORDER BY ". $sort ." ". $order );
}
else
{
$this->ifthd->core->db->query( "SELECT * FROM ". DB_PRE ."members WHERE name LIKE '%". $this->ifthd->input['m_search'] ."%' ORDER BY ". $sort ." ". $order );
}
}
else
{
// Filter?
if ( $this->ifthd->input['group'] )
{
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'members',
'where' => array( 'mgroup', '=', $this->ifthd->input['group'] ),
'order' => array( $sort => $order ),
) );
}
else
{
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'members',
'order' => array( $sort => $order ),
) );
}
$this->ifthd->core->db->execute();
}
$member_rows = ""; // Initialize for Security
$row_count = 0; // Initialize for Security
if ( ! $mem_count = $this->ifthd->core->db->get_num_rows() )
{
$this->ifthd->skin->error('no_members_found');
}
// Search?
if ( $this->ifthd->input['m_search'] )
{
// Filter?
if ( $this->ifthd->input['group'] )
{
$this->ifthd->core->db->query( "SELECT * FROM ". DB_PRE ."members WHERE mgroup = '". $this->ifthd->input['group'] ."' && name LIKE '%". $this->ifthd->input['m_search'] ."%' ORDER BY ". $sort ." ". $order ." LIMIT ". $start .", 20" );
}
else
{
$this->ifthd->core->db->query( "SELECT * FROM ". DB_PRE ."members WHERE name LIKE '%". $this->ifthd->input['m_search'] ."%' ORDER BY ". $sort ." ". $order ." LIMIT ". $start .", 20" );
}
}
else
{
// Filter?
if ( $this->ifthd->input['group'] )
{
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'members',
'where' => array( 'mgroup', '=', $this->ifthd->input['group'] ),
'order' => array( $sort => $order ),
'limit' => array( $start, 20 ),
) );
}
else
{
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'members',
'order' => array( $sort => $order ),
'limit' => array( $start, 20 ),
) );
}
$this->ifthd->core->db->execute();
}
while( $m = $this->ifthd->core->db->fetch_row() )
{
$row_count ++;
( $row_count & 1 ) ? $row_class = 'option1-med' : $row_class = 'option2-med';
#=============================
# Fix Up Information
#=============================
$mem_group = $this->ifthd->core->cache['group'][ $m['mgroup'] ]['g_name'];
$member_rows .= "
| {$link_id} | {$link_name} | {$link_mgroup} | {$link_open_tickets} | {$link_tickets} | Edit | Delete |
|---|
";
}
else
{
$$order_var = "&order=desc";
$$img_var = " ";
}
$link_id = "ID". $img_id ."";
$link_name = "Name". $img_name ."";
$link_email_val = "Email Validated". $img_email_val ."";
$link_extra = ""; // Initialize for Security
if ( $this->ifthd->input['sort'] )
{
$link_extra .= "&sort=". $this->ifthd->input['sort'];
}
if ( $this->ifthd->input['order'] )
{
$link_extra .= "&order=". $this->ifthd->input['order'];
}
#=============================
# Grab Members
#=============================
if ( $this->ifthd->input['st'] )
{
$start = $this->ifthd->input['st'];
}
else
{
$start = 0;
}
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'members',
'where' => array( 'admin_val', '!=', 1 ),
'order' => array( $sort => $order ),
) );
$this->ifthd->core->db->execute();
$member_rows = ""; // Initialize for Security
$row_count = 0; // Initialize for Security
if ( ! $mem_count = $this->ifthd->core->db->get_num_rows() )
{
$this->ifthd->skin->error('no_members_found');
}
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'members',
'where' => array( 'admin_val', '!=', 1 ),
'order' => array( $sort => $order ),
'limit' => array( $start, 20 ),
) );
$this->ifthd->core->db->execute();
while( $m = $this->ifthd->core->db->fetch_row() )
{
$row_count ++;
( $row_count & 1 ) ? $row_class = 'option1-med' : $row_class = 'option2-med';
#=============================
# Fix Up Information
#=============================
( $m['email_val'] ) ? $m['email_val'] = 'Yes' : $m['email_val'] = 'No';
$member_rows .= "
| {$link_id} | {$link_name} | {$link_email_val} | Approve | Edit | Delete |
|---|
| Username | {$m['name']} |
| {$m['email']} | |
| Group | {$this->ifthd->core->cache['group'][ $m['mgroup'] ]['g_name']} |
| Local Time | {$mem_time} |
| Joined | {$mem_joined} |
| Open Tickets | {$m['open_tickets']} |
| Tickets | {$m['tickets']} |
| Rating | {$m['rating']} |
";
}
else
{
$ift_html .= "
";
}
}
for ( $x = $x; $x <= 5; $x++ )
{
$ift_html .= "
";
}
return $ift_html;
}
}
?>