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))
{
?>
database_query("SELECT * FROM bateworldcom_zips.suggestion_admin_comments WHERE suggestionid='".$database->database_real_escape_string($_GET["id"])."' ORDER BY id ASC");
while($row1=$database->database_fetch_array($query1))
{?>
database_query("SELECT * FROM bateworldcom.se_admins WHERE admin_id='".$row1["user"]."'");
$row2=$database->database_fetch_array($query2);
echo $row2["admin_username"];
?>
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";
}
?>