<? 
require "header.php"; 

if($_POST['remove']) {
	foreach($_POST['remove'] as $i) {
		mysql_query("DELETE FROM reported_content WHERE content = '$i'");
	}
}
if($_POST['delete']) {
	foreach($_POST['delete'] as $i) {
		mysql_query("DELETE FROM reported_content WHERE content = '$i'");
		mysql_query("DELETE FROM content WHERE record_num = '$i'");
		mysql_query("DELETE FROM content_niches WHERE record_num = '$i'");
		mysql_query("DELETE FROM content_views WHERE record_num = '$i'");
		mysql_query("DELETE FROM comments WHERE content = '$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 Content</h2>
<table width="608" border="0" align="center" cellpadding="3" cellspacing="0">
    <tr  class='menutop'>
      <td width="243"  class="style5"><span class="style5">Video</span></td>
	  <td width="46" align="center"  class="style5">Amt</td>
	  <td width="50" align="center"  class="style5"><span class="style4">Remove</span></td>
      <td width="39" align="center"  class="style5"><span class="style4">Delete</span></td>
    </tr>
<?
$bgcolor = '#323232';
$result = mysql_query("SELECT content.title, content.ip as ip, content.submitter as submitter, COUNT(reported_content.record_num) as amount, content.record_num as connum FROM content, reported_content WHERE reported_content.content = content.record_num GROUP BY content.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 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[connum]; ?>" /></td>
    </tr>
<? 
if($bgcolor == '#323232') { $bgcolor = "#414141"; } else { $bgcolor = '#323232'; }
}
?>
    <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"; ?>