Files
Testing/bwadmin/contact1.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

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>&nbsp;|&nbsp;<a href="contact.php?delete=<?=$row["id"]?>&amp;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";
?>