<? 
require "../../header.php"; 

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

?>
<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="comments.php">Latest Comments</a></span>  
            </div>
        </div>
        <div id="right_bg">  
      		<h2>Latest<strong>Comments</strong></h2>
            <p>This page contains the most recent comments posted on your site, allowing for an easy and quick way to moderate spam and garbage comments.</p>
            <div id="index_left" style='width: 100%;'>            
<form id="form1" name="form1" method="post" action="">
<?
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); 

$bgcolor = '#ffffff';
if(is_numeric($_GET[id])) { 
	$and = "AND content = '$_GET[id]'";
}
$result_count = mysql_query("SELECT record_num FROM comments WHERE type = 2 $and ORDER BY timestamp");
$result = mysql_query("SELECT comments.*, (SELECT users.username FROM users WHERE users.record_num = comments.content) AS username FROM comments WHERE comments.type = 2 $and ORDER BY timestamp DESC LIMIT $from,$max_results");
$total_results = mysql_num_rows($result_count);
$total_pages = ceil($total_results / $max_results);
?>
  <table width="750" border="0" align="center" cellpadding="3" cellspacing="0" class='pagetable'>
     <thead>
     <tr class='menutop'>
      <th width="105" align='left'>Name</td>
      <th width="162" align='left'>Username</td>
      <th width="345" align='left'>Comment</td>
      <th width="57" align="center">Edit</td>
      <th width="51" align="center">Delete</td>
    </tr>
    </thead>
<?
while($row = mysql_fetch_array($result)) { 
?>
      <tr bgcolor = '<? echo $bgcolor; ?>'>
      <td class="style4"><? echo $row[name]; ?></td>
      <td class="style4"><a href="../../edit_user.php?id=<? echo $row[content]; ?>"><? if(strlen($row[username]) > 25) { echo substr($row[username],0,25)."..."; } else { echo $row[username]; }  ?></a></td>
      <td class="style4"><? echo $row[comment]; ?></td>
      <td align="center" class="style4"><a href='edit_comment.php?id=<? echo $row[record_num]; ?>'>Edit</a></td>
      <td align="center"><input name="comments[]" type="checkbox" class="style4" value="<? echo $row[record_num]; ?>" /></td>
    </tr>
<? 
if($bgcolor == '#ffffff') { $bgcolor = "#EBEBEB"; } else { $bgcolor = '#ffffff'; }
}
?>
</table>
<br />
<center><input type="submit" name="button" id="button" value="Delete Selected" /></center>
<br />
<div id='adminPagination'><center><? echo showAdminPagination($total_pages); ?></center></div>
</form>
            </div>
        </div>
        <div id="right_bottom"></div>
        </div>
    </div>
</div>



<? require "../../footer.php"; ?>