Add Suggestion





database_query("UPDATE bateworldcom_zips.suggestions SET suggestion='".$database->database_real_escape_string($_POST["suggestion"])."', category='".$database->database_real_escape_string($_POST["category"])."', moreinfo='".$database->database_real_escape_string(nl2br($_POST["moreinfo"]))."', status='".$database->database_real_escape_string($_POST["status"])."', urgency='".$database->database_real_escape_string($_POST["urgency"])."', assignedto='".$database->database_real_escape_string($_POST["assignedto"])."', waitingon='".$database->database_real_escape_string($_POST["waitingon"])."' WHERE id='".$database->database_real_escape_string($_POST["id"])."'"); $query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_steps WHERE projectid='".$database->database_real_escape_string($_POST["id"])."'"); while($row1=$database->database_fetch_array($query1)) {$steps[]=$row1["text"];} if($steps!==$_POST["step"]){ $database->database_query("DELETE FROM bateworldcom_zips.suggestion_steps WHERE projectid='".$database->database_real_escape_string($_POST["id"])."'") or die($database->database_error()); foreach($_POST["step"] as $step) { $query=$database->database_query("INSERT INTO bateworldcom_zips.suggestion_steps SET projectid='".$database->database_real_escape_string($_POST["id"])."', text='".$database->database_real_escape_string($step)."'"); } } $query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($_POST["id"])."'"); while($row1=$database->database_fetch_array($query1)) {$members[]=$row1["adminid"];} if($members!==$_POST["assignedto"]){ $database->database_query("DELETE FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($_POST["id"])."'"); foreach($_POST["assignedto"] as $assignedto) { $query=$database->database_query("INSERT INTO bateworldcom_zips.suggestions_members SET projectid='".$database->database_real_escape_string($_POST["id"])."', adminid='".$database->database_real_escape_string($assignedto)."'") or die($database->database_error()); } } $query6=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE id='".$database->database_real_escape_string($_POST["id"])."'"); $row6=$database->database_fetch_array($query6); $query7=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_categories WHERE id='".$row6["category"]."' ORDER BY title DESC"); $row7=$database->database_fetch_array($query7); $query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($_GET["id"])."'"); while($row1=$database->database_fetch_array($query1)) { $query2=$database->database_query("SELECT * FROM se_admins WHERE admin_id='".$database->database_real_escape_string($row1["adminid"])."'"); while($row2=$database->database_fetch_array($query2)) { mail($row2["admin_email"], "Project ".$_POST["id"]." has been updated", "Project ".$_POST["id"]." has been updated. https://bateworld.com/bwadmin/add_suggestion.php?id=".$_POST["id"]." Category: ".$row7["title"]." Title: ".$row6["suggestion"]); } } echo "Suggestion Updated"; } if($_POST["comment"]!="") { $database->database_query("INSERT INTO bateworldcom_zips.suggestion_admin_comments SET time='".time()."', comment='".$database->database_real_escape_string(nl2br($_POST["comment"]))."', user='".$database->database_real_escape_string($admin->admin_info["admin_id"])."', suggestionid='".$database->database_real_escape_string($_GET["id"])."'") or die($database->database_error()); $query4=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($_GET["id"])."'"); while($row4=$database->database_fetch_array($query4)) { $query3=$database->database_query("SELECT * FROM bateworldcom.se_admins WHERE admin_id='".$database->database_real_escape_string($row4["adminid"])."'"); $row3=$database->database_fetch_array($query3); $query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_categories WHERE id='".$row["category"]."' ORDER BY title DESC"); $row1=$database->database_fetch_array($query1); $query6=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE id='".$database->database_real_escape_string($_POST["id"])."'"); $row6=$database->database_fetch_array($query6); $query7=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_categories WHERE id='".$row6["category"]."' ORDER BY title DESC"); $row7=$database->database_fetch_array($query7); mail($row3["admin_email"], "New admin comment to a suggestion", "A new comment has been posted to a suggestion you are assigned to. https://bateworld.com/bwadmin/add_suggestion.php?id=".$_GET["id"]." Category: ".$row7["title"]." Title: ".$row6["suggestion"]); } /*if($row["assignedto"]!=$row["admincreator"]){ $query3=$database->database_query("SELECT * FROM bateworldcom.se_admins WHERE admin_id='".$database->database_real_escape_string($row["assignedto"])."'"); $row3=$database->database_fetch_array($query3); mail($row3["admin_email"], "New admin comment to a suggestion", "A new comment has been posted to a suggestion you have created. https://bateworld.com/bwadmin/add_suggestion.php?id=".$_GET["id"]); }*/ } $query=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE id='".$database->database_real_escape_string($_GET["id"])."'"); while($row=$database->database_fetch_array($query)) { ?>
">
Category:
Suggestion:
" />
More Info:
Status:
checked="checked" /> Suggestion
checked="checked" /> In Review
checked="checked" /> Approved
checked="checked" /> In Progress
checked="checked" /> Rejected
checked="checked" /> Completed
Involves:
database_query("SELECT * FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($_GET["id"])."'"); while($row1=$database->database_fetch_array($query1)) {$members[]=$row1["adminid"];} $query1=$database->database_query("SELECT * FROM `se_admins`"); while($row1=$database->database_fetch_array($query1)) { ?>
" checked="checked" name="assignedto[]">
Urgency:
Steps:
database_query("SELECT * FROM bateworldcom_zips.suggestion_steps WHERE projectid='".$database->database_real_escape_string($_GET["id"])."' ORDER BY id ASC") or die($database->database_error()); while($row1=$database->database_fetch_array($query1)) { ?>

Add Step
Waiting on:
" name="id" />


database_query("INSERT INTO bateworldcom_zips.suggestions SET date='".time()."', suggestion='".$database->database_real_escape_string($_POST["suggestion"])."', admin='1', category='".$database->database_real_escape_string($_POST["category"])."', moreinfo='".$database->database_real_escape_string(nl2br($_POST["moreinfo"]))."', status='".$database->database_real_escape_string($_POST["status"])."', urgency='".$database->database_real_escape_string($_POST["urgency"])."', admincreator='".$admin->admin_info["admin_id"]."'"); $projectid=$database->database_insert_id(); foreach($_POST["step"] as $step) { $query=$database->database_query("INSERT INTO bateworldcom_zips.suggestion_steps SET projectid='".$projectid."', text='".$database->database_real_escape_string($step)."'"); } foreach($_POST["assignedto"] as $assignedto) { $query=$database->database_query("INSERT INTO bateworldcom_zips.suggestions_members SET projectid='".$projectid."', adminid='".$database->database_real_escape_string($assignedto)."'") or die($database->database_error()); } $query6=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE id='".$database->database_real_escape_string($projectid)."'"); $row6=$database->database_fetch_array($query6); $query7=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_categories WHERE id='".$row6["category"]."' ORDER BY title DESC"); $row7=$database->database_fetch_array($query7); $query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($projectid)."'"); while($row1=$database->database_fetch_array($query1)) { $query2=$database->database_query("SELECT * FROM se_admins WHERE admin_id='".$database->database_real_escape_string($row1["adminid"])."'"); while($row2=$database->database_fetch_array($query2)) { mail($row2["admin_email"], "Project ".$_POST["id"]." has been added", "Project ".$_POST["id"]." has been updated. https://bateworld.com/bwadmin/add_suggestion.php?id=".$_POST["id"]." Category: ".$row7["title"]." Title: ".$row6["suggestion"]); } } echo "Suggestion added"; } ?>
">
Category:
Suggestion:
" />
More Info:
Status:
Suggestion
checked="checked" /> In Review
checked="checked" /> Approved
In Progress
Rejected
Completed
Involves:
database_query("SELECT * FROM `se_admins`"); while($row1=$database->database_fetch_array($query1)) { ?>
" admin_info["admin_id"]){?>checked="checked" name="assignedto[]">
Urgency:
Steps:
Add Step