database_query("DELETE FROM bateworldcom_zips.suggestions WHERE id='".$database->database_real_escape_string($_GET["id"])."'");
$database->database_query("DELETE FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($_GET["id"])."'");
$database->database_query("DELETE FROM bateworldcom_zips.suggestion_admin_comments WHERE suggestionid='".$database->database_real_escape_string($_GET["id"])."'");
$database->database_query("DELETE FROM bateworldcom_zips.suggestion_comments WHERE suggestionid='".$database->database_real_escape_string($_GET["id"])."'");
$database->database_query("DELETE FROM bateworldcom_zips.suggestion_steps WHERE projectid='".$database->database_real_escape_string($_GET["id"])."'");
}
?>
database_real_escape_string($_GET["category"])."' ";
}
if($_GET["urgency"]!="")
{
$also=$also." AND urgency='".$database->database_real_escape_string($_GET["urgency"])."' ";
}
if($v==7){
$reports_query="SELECT * FROM bateworldcom_zips.suggestions WHERE status=5 ".$also." ORDER BY id 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 ";
?>Page:
&p=&usage=&from="> database_query($reports_query);
while($row=$database->database_fetch_array($query))
{
?>
votes
database_query("SELECT * from bateworldcom.se_admins WHERE admin_id='".$row["admincreator"]."'");
$user2=$database->database_fetch_array($userquery);
echo $user2["admin_username"];
}else{?>By: database_query("SELECT * from bateworldcom.se_users WHERE user_id='".$row["user"]."'");
$user2=$database->database_fetch_array($userquery);
echo $user2["user_username"];
}?>
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 ";
?>Page:
&p=&usage=&from="> database_query($reports_query);
while($row=$database->database_fetch_array($query))
{
?>
votes
database_query("SELECT * from bateworldcom.se_admins WHERE admin_id='".$row["admincreator"]."'");
$user2=$database->database_fetch_array($userquery);
echo $user2["admin_username"];
}else{?>By: database_query("SELECT * from bateworldcom.se_users WHERE user_id='".$row["user"]."'");
$user2=$database->database_fetch_array($userquery);
echo $user2["user_username"];
}?>
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 ";
?>Page:
&p=&usage=&from="> database_query($reports_query);
while($row=$database->database_fetch_array($query))
{
?>
votes
database_query("SELECT * from bateworldcom.se_admins WHERE admin_id='".$row["admincreator"]."'");
$user2=$database->database_fetch_array($userquery);
echo $user2["admin_username"];
}else{?>By: database_query("SELECT * from bateworldcom.se_users WHERE user_id='".$row["user"]."'");
$user2=$database->database_fetch_array($userquery);
echo $user2["user_username"];
}?>
}
include "admin_footer.php";
?>