Suggestion
database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE id='".$database->database_real_escape_string($_GET["id"])."'");
$row=$database->database_fetch_array($query);
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);
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/suggestion.php?id=".$_GET["id"]."
Category: ".$row1["title"]."
Title: ".$row["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/suggestion.php?id=".$_GET["id"]);
}*/
}
if($_GET["id"]!="")
{
?>
ID:
Category:
database_query("SELECT * FROM bateworldcom_zips.suggestion_categories WHERE id='".$row["category"]."' ORDER BY title DESC");
$row1=$database->database_fetch_array($query1);
echo $row1["title"];?>
Suggestion:
More Info:
Status:
SuggestionApprovedIn ProgressRejectedCompleted
User:
database_query("SELECT * FROM `se_admins` WHERE admin_id='".$row["admincreator"]."'");
$row2=$database->database_fetch_array($query2);
echo $row2["admin_username"];
}else{
$query2=$database->database_query("SELECT * FROM `se_users` WHERE user_id='".$row["user"]."'");
$row2=$database->database_fetch_array($query2);
?>
">
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))
{
$query2=$database->database_query("SELECT * FROM `se_admins` WHERE admin_id='".$row1["adminid"]."'");
$row2=$database->database_fetch_array($query2);
?>
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))
{
?>
Waiting on:
database_query("SELECT * FROM `se_admins` WHERE admin_id='".$row["waitingon"]."'");
$row2=$database->database_fetch_array($query2);
?>