database_query($reports_query);
while($row= $database->database_fetch_array($query))
{
$path=$_SERVER["DOCUMENT_ROOT"]."/wall/include/wall/images/upload/".$row['userid']."/".$row["img_name"];
@unlink($path);
$database->database_query("DELETE FROM community_wall WHERE wid='".$row["wid"]."'");
}
}
}
function general()
{
global $ads, $database, $task;
if(isset($_POST['p'])) { $p = $_POST['p']; } elseif(isset($_GET['p'])) { $p = $_GET['p']; } else { $p = 1; }
if(isset($_POST['usage'])) { $usage = $_POST['usage']; } elseif(isset($_GET['usage'])) { $usage = $_GET['usage']; } else { $usage = ""; }
if(isset($_POST['from'])) { $from = $_POST['from']; } elseif(isset($_GET['from'])) { $from = $_GET['from']; } else { $from = ""; }
?>
Community Wall
All posts from the Community Wall
if($usage!="")
{
if($usage=="0")
{
$permission="AND (userpermission=".$usage." OR userpermission IS NULL)";
}
else{
$permission="AND userpermission=".$usage;
}
}
else{$permission="";}
if($from!="")
{
$usert=" AND se_users.user_username LIKE'%".$from."%'";
}
else{$usert="";}
$reports_query = "SELECT * FROM community_wall, se_users WHERE community_wall.userid=se_users.user_id ".$permission.$usert." ORDER BY wid DESC";
$total_users = $database->database_num_rows($database->database_query($reports_query));
// MAKE USER PAGES
$users_per_page = 100;
$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 ";
?>
}
// 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";
?>