database_query("INSERT INTO bateworldcom_zips.suggestions SET user='".$database->database_real_escape_string($user->user_info["user_id"])."', suggestion='".$database->database_real_escape_string($_POST["title"])."', category='".$database->database_real_escape_string($_POST["category"])."', moreinfo='".$database->database_real_escape_string(nl2br($_POST["moreinfo"]))."', date='".time()."'");
$id=$database->database_insert_id();
$database->database_query("INSERT INTO bateworldcom_zips.suggestions_members SET projectid='".$id."', adminid='1'") or die($database->database_error());
$database->database_query("INSERT INTO bateworldcom_zips.suggestions_members SET projectid='".$id."', adminid='3'") or die($database->database_error());
$database->database_query("INSERT INTO bateworldcom_zips.suggestions_members SET projectid='".$id."', adminid='26'") or die($database->database_error());
$database->database_query("INSERT INTO bateworldcom_zips.suggestions_members SET projectid='".$id."', adminid='11'") or die($database->database_error());
$query2=$database->database_query("SELECT * FROM se_admins WHERE admin_id='1'");
while($row2=$database->database_fetch_array($query2))
{
mail($row2["admin_email"], "Member suggestion ".$id." has been added", "Member suggestion ".$id." has been added by a member.
https://bateworld.com/bwadmin/add_suggestion.php?id=".$id);
}
$query2=$database->database_query("SELECT * FROM se_admins WHERE admin_id='3'");
while($row2=$database->database_fetch_array($query2))
{
mail($row2["admin_email"], "Member suggestion ".$id." has been added", "Member suggestion ".$id." has been added by a member.
https://bateworld.com/bwadmin/add_suggestion.php?id=".$id);
}
$query2=$database->database_query("SELECT * FROM se_admins WHERE admin_id='33'");
while($row2=$database->database_fetch_array($query2))
{
mail($row2["admin_email"], "Member suggestion ".$id." has been added", "Member suggestion ".$id." has been added by a member.
https://bateworld.com/bwadmin/add_suggestion.php?id=".$id);
}
$query2=$database->database_query("SELECT * FROM se_admins WHERE admin_id='11'");
while($row2=$database->database_fetch_array($query2))
{
mail($row2["admin_email"], "Member suggestion ".$id." has been added", "Member suggestion ".$id." has been added by a member.
https://bateworld.com/bwadmin/add_suggestion.php?id=".$id);
}
$message="Hi ".$user->user_info["user_username"]."
Thanks for your suggestion! We regularly review all feedback, good and bad. While we do look at each and every submission, we cannot guarantee that your suggestion will be implemented. If we can use your suggestion to improve Bateworld, we will let you know.
Happy bating!
P.S. Need help with something immediately? You can review our FAQ for fast answers or open a Help Desk ticket now.";
$subject="Thank you for your suggestion";
send_generic($user->user_info["user_email"], "mailservices@b8world.com", $subject, $message, $search, $replace, $bcc = FALSE);
?>
Your suggestion has been added.