110 lines
3.1 KiB
PHP
110 lines
3.1 KiB
PHP
|
|
<?php
|
||
|
|
|
||
|
|
/* $Id: admin_viewreports.php 8 2009-01-11 06:02:53Z john $ */
|
||
|
|
|
||
|
|
$page = "admin_general1";
|
||
|
|
include "admin_header.php";
|
||
|
|
|
||
|
|
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = "main"; }
|
||
|
|
|
||
|
|
|
||
|
|
// DELETE SINGLE REPORT
|
||
|
|
if($task == "delete") {
|
||
|
|
|
||
|
|
$database->database_query("DELETE FROM contactemails WHERE id='".$database->database_real_escape_string($_GET["delete"])."'");
|
||
|
|
/*if($database->database_num_rows($report_query) != 0) {
|
||
|
|
$database->database_query("DELETE FROM se_reports WHERE report_id='$report_id'");
|
||
|
|
}*/
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
function general()
|
||
|
|
{
|
||
|
|
global $ads, $database;
|
||
|
|
?><?
|
||
|
|
$reports_query = "SELECT * FROM contactemails ORDER BY id DESC";
|
||
|
|
|
||
|
|
$users_per_page = 100;
|
||
|
|
$total_users = $database->database_num_rows($database->database_query($reports_query));
|
||
|
|
|
||
|
|
$page_vars = make_page($total_users, $users_per_page, $p);
|
||
|
|
|
||
|
|
$page_array = Array();
|
||
|
|
for($x=0;$x<=$page_vars[2]-1;$x++) {
|
||
|
|
if($x+1 == $page_vars[1]) { $link = "1"; } else { $link = "0"; }
|
||
|
|
$page_array[$x] = Array('page' => $x+1,
|
||
|
|
'link' => $link);
|
||
|
|
}
|
||
|
|
|
||
|
|
$reports_query .= " LIMIT $page_vars[0], $users_per_page ";
|
||
|
|
|
||
|
|
for($i=1; $i<=$page_vars[2]; $i++)
|
||
|
|
{
|
||
|
|
if($i==$p){
|
||
|
|
echo $i." ";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
?><a href="contact1.php?p=<?php echo $i;?>"><?php echo $i;?></a> <?php
|
||
|
|
}
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<br /><br />
|
||
|
|
<table><tr><td><strong>Subject</strong></td><td><strong>Message</strong></td><td>Email</td><td><strong>Actions</strong></td></tr>
|
||
|
|
|
||
|
|
<?php
|
||
|
|
$query= $database->database_query($reports_query);
|
||
|
|
while($row= $database->database_fetch_array($query))
|
||
|
|
{
|
||
|
|
?><tr><td valign="top"><?=strip_tags($row["subject"])?></td><td valign="top"><?=$row["message"]?><br>
|
||
|
|
<br>
|
||
|
|
<strong>Name:</strong> <?=$row["name"]?><br /><br />
|
||
|
|
<strong>Username:</strong> <?=$row["username"]?><br /><br />
|
||
|
|
<strong>IP Address:</strong> <?=$row["ip"]?><br><br>
|
||
|
|
<strong>Relevant info:</strong> <?=$row["info"]?>
|
||
|
|
</td>
|
||
|
|
<td valign="top"><?php echo $row["email"];?></td>
|
||
|
|
|
||
|
|
<td valign="top"><a href="mailto:<?=$row["email"]?>?subject=RE: <?=$row["subject"]?>&body=<?=$row["message"]?>">Reply</a> | <a href="contact.php?delete=<?=$row["id"]?>&task=delete">Delete</a></tr>
|
||
|
|
<?
|
||
|
|
}?></table>
|
||
|
|
<br /><br />
|
||
|
|
<?
|
||
|
|
|
||
|
|
for($i=1; $i<=$page_vars[2]; $i++)
|
||
|
|
{
|
||
|
|
if($i==$p){
|
||
|
|
echo $i." ";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
?><a href="contact1.php?p=<?php echo $i;?>"><?php echo $i;?></a> <?php
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
// CONSTRUCT QUERY USING FILTERS
|
||
|
|
|
||
|
|
|
||
|
|
if($f_object != "") { $where_clause[] = "se_reports.report_object='$f_object'"; }
|
||
|
|
if($f_reason != "") { $where_clause[] = "se_reports.report_reason='$f_reason'"; }
|
||
|
|
if($f_details != "") { $where_clause[] = " se_reports.report_details LIKE '%$f_details%'"; }
|
||
|
|
if(count($where_clause) != 0) { $reports_query .= " WHERE ".implode(" AND ", $where_clause); }
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
// ASSIGN VARIABLES AND SHOW VIEW REPORTS PAGE
|
||
|
|
$smarty->assign('total_reports', $total_reports);
|
||
|
|
$smarty->assign('pages', $page_array);
|
||
|
|
$smarty->assign('reports', $report_array);
|
||
|
|
$smarty->assign('i', $i);
|
||
|
|
$smarty->assign('u', $u);
|
||
|
|
$smarty->assign('p', $page_vars[1]);
|
||
|
|
$smarty->assign('s', $s);
|
||
|
|
$smarty->assign('f_object', $f_object);
|
||
|
|
$smarty->assign('f_reason', $f_reason);
|
||
|
|
$smarty->assign('f_details', $f_details);
|
||
|
|
include "admin_footer.php";
|
||
|
|
?>
|