<? 
require "header.php"; 

if($_POST['remove']) {
	foreach($_POST['remove'] as $i) {
		mysql_query("DELETE FROM reported_comments WHERE comment = '$i'");
	}
}
if($_POST['delete']) {
	foreach($_POST['delete'] as $i) {
		mysql_query("DELETE FROM reported_comments WHERE comment = '$i'");
		mysql_query("DELETE FROM comments WHERE record_num = '$i'");
	}
}
?>
<h1><span class="style1">Admin Area</span></h1>
<hr>
<div class="box" id="pagecontent">
<p><? echo $error; ?></p>
<form id="form1" name="form1" method="post" action="">
<h2 align='center'>Reported Comments</h2>
<table width="686" border="0" align="center" cellpadding="3" cellspacing="0" style='border: 1px solid #BAC9CF;'>
    <tr>
      <td width="155" bgcolor="#C0C0BE" class="style5"><span class="style5">Video</span></td>
	  <td width="285" bgcolor="#C0C0BE" class="style5">Comment</td>
	  <td width="81" align="center" bgcolor="#C0C0BE" class="style5">Poster IP</td>
	  <td width="36" align="center" bgcolor="#C0C0BE" class="style5">Amt</td>
	  <td width="50" align="center" bgcolor="#C0C0BE" class="style5"><span class="style4">Remove</span></td>
      <td width="41" align="center" bgcolor="#C0C0BE" class="style5"><span class="style4">Delete</span></td>
    </tr>
<?
$bgcolor = "#FFFFFF";
$result = mysql_query("SELECT content.title, comments.ip as ip, comments.comment, COUNT(reported_comments.record_num) as amount, content.record_num as connum, comments.record_num AS recnum FROM content, comments, reported_comments WHERE comments.content = content.record_num AND reported_comments.comment = comments.record_num GROUP BY comments.record_num ORDER BY amount DESC") or die(mysql_error());
while($row = mysql_fetch_array($result)) { 
?>
    <tr bgcolor = '<? echo $bgcolor; ?>'>
      <td class="style4"><a href='/video.php?id=<? echo $row[connum]; ?>' target='_blank'><? echo $row[title]; ?></a></td>
	  <td class="style4"><? echo $row[comment]; ?></td>
	  <td align="center" class="style4"><? echo $row[ip]; ?></td>
	  <td align="center" class="style4"><? echo $row[amount]; ?></td>
	  <td align="center"><input name="remove[]" type="checkbox" class="style4" value="<? echo $row[recnum]; ?>" /></td>
      <td align="center"><input name="delete[]" type="checkbox" class="style4" value="<? echo $row[recnum]; ?>" /></td>
    </tr>
<? 
if($bgcolor == '#FFFFFF') { $bgcolor = "#E7E7E7"; } else { $bgcolor = '#FFFFFF'; }
}
?>
    <tr bgcolor = '<? echo $bgcolor; ?>'>
      <td colspan="8" class="style4"><center>
        <p><br />
          <input name="Submit" type="submit" class="style4" value="Delete Selected" />
        </p>
        <p>*Amt = Number of times flagged | Remove: Removes from this list | Delete: Deletes comment </p>
      </center></td>
    </tr>
</table>
  <p>&nbsp;</p>
  </form>
  </div>
<p style="clear: both;"></p>
<? require "footer.php"; ?>