<? 
require "header.php"; 

if($_POST['list']) {
	foreach($_POST['list'] as $i) {
		if(is_numeric($i)) {
			mysql_query("DELETE FROM users WHERE record_num = '$i'");
		}
	}
}

if(!isset($_GET['page']) || $_GET[page] == '') { 
	$page = 1; 
} else { 
	$page = $_GET['page']; 
}
if(!$_GET[setmax]) { $max_results = 100; } else { $max_results = $_GET[setmax]; }
$from = (($page * $max_results) - $max_results); 
?>


     <div id="right_column">
        <div id="right_top">
        	<div id="right_home"></div>
            <div id="right_right">  
            <a href="index.php">Admin Home</a>          
            <span><a href="users.php">Manage Users</a></span>  
            </div>
        </div>
        <div id="right_bg">
        
      		<h2>Manage<strong>Users</strong></h2>
            <p>To find the user you are looking for faster, you can enter either a whole or partial username or email address into the search box below.</p>
            <div id="index_left" style='width: 100%;'>            
            
           <form id="form1" name="form1" method="post" action="">
           <table border="0" align="center" cellpadding="3" cellspacing="0" class='pagetable'> 
  <thead>
  <tr>
  <th colspan=2 align='left'>Search Users</th>
  </tr>
  </thead>
    <tr>
      <td width="99" height="25" class="style4">Username/Email</td>
      <td width="446" height="25" align="left" class="style4"><input type="text" name="q" id="q" /></td>
    </tr>
    <tr>
      <td height="25" colspan="2" align="center" class="style4"><input type="submit" name="Submit2" value="Search" /></td>
    </tr>
  </table>
  <br />
  <br />
  <table width="750" border="0" align="center" cellpadding="3" cellspacing="0" class='pagetable'>
    <thead>
      <tr>
        <th width="148" align='left'>Username</th>
        <th width="243" align='left'>Email Address</th>
        <th width="71" align='center'>Login As</th>
        <th width="69" align='center'>Content</th>
        <th width="79" align='center'>Comments</th>
        <th width="36" align="center">Edit</th>
        <th width="62" align="center">Delete</th>
      </tr>
    </thead>
    <?
$bgcolor = '#ffffff';
if($_POST[q]) {
	$q = mysql_real_escape_string($_POST[q]); 
	$query = "AND (username LIKE '%$q%' OR email LIKE '%$q%')";
}
if(is_numeric($_GET[level])) {
	$levelAnd = "AND user_level = '$_GET[level]'";
}
else {
	$levelAnd = "AND user_level = 0";
}
$result_count = mysql_query("SELECT record_num FROM users WHERE 1=1 $levelAnd $query ");
$result = mysql_query("SELECT * FROM users WHERE 1=1 $levelAnd $query ORDER BY username ASC LIMIT $from,$max_results");
$total_results = mysql_num_rows($result_count);
$total_pages = ceil($total_results / $max_results);
while($row = mysql_fetch_array($result)) { 
?>
    <tr bgcolor = '<? echo $bgcolor; ?>'>
      <td class="style4"><? echo $row[username]; ?></td>
      <td class="style4"><? echo $row[email]; ?></td>
      <td align="center" class="style4"><a href='takeoverUser.php?id=<? echo $row[record_num]; ?>'>Login As</a></td>
      <td align="center" class="style4"><a href='existing_content.php?channel=&amp;pornstar=&amp;paysite=&amp;type=&amp;keywords=&amp;user=<? echo $row[record_num]; ?>&amp;Submit2=Search'>Content</a></td>
      <td align="center" class="style4"><a href='user_comments.php?id=<? echo $row[record_num]; ?>'>Comments</a></td>
      <td align="center"><a href="edit_user.php?id=<? echo $row[record_num]; ?>">Edit</a></td>
      <td align="center"><input name="list[]" type="checkbox" class="style4" value="<? echo $row[record_num]; ?>" /></td>
    </tr>
    <? 
if($bgcolor == '#ffffff') { $bgcolor = "#EBEBEB"; } else { $bgcolor = '#ffffff'; }
}
?>
    <tr bgcolor = '<? echo $bgcolor; ?>'>
      <td colspan="9" class="style4"><center>
        <br />
          <input name="Submit" type="submit" class="style4" value="Delete Selected" />
      </center></td>
    </tr>
  </table>
  <p>&nbsp;</p>
</form>
<div id='adminPagination'><center><? echo showAdminPagination($total_pages); ?></center></div>


            </div>
        </div>
        <div id="right_bottom"></div>
        </div>
    </div>
</div>








<? require "footer.php"; ?>