database_query("DELETE FROM contactemails WHERE id='".mysql_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()
{?>
| Subject | Message | Email | Actions |
$reports_query = "SELECT * FROM contactemails ORDER BY id DESC";
$query=mysql_query($reports_query) or die(mysql_error());
while($row=mysql_fetch_array($query))
{
?>| =$row["subject"]?> | =$row["message"]?>
Name: =$row["name"]?>
Username: =$row["username"]?>
IP Address: =$row["ip"]?>
Relevant info: =$row["info"]?>
|
|
?subject=RE: =$row["subject"]?>&body==$row["message"]?>">Reply | &task=delete">Delete |
}?>
}
// 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/admin_footer.php";
?>