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"])."'"); } ?>

Suggestions

Suggestions by admin and members.



database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE admin=0 ORDER BY votes DESC"); } elseif($_GET["view"]=="inprogress") { //$query=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE status=1 ORDER BY votes DESC"); } elseif($_GET["view"]=="rejected") { //$query=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE status=3 ORDER BY votes DESC"); } elseif($_GET["view"]=="completed") { //$query=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE status=2 ORDER BY votes DESC"); } else { $_GET["view"]="new"; //$query=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE admin=0 ORDER BY id DESC"); } ?>
Add New Suggestion


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"]; }?>