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); ?>