Files
Testing/add_suggestion.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

112 lines
5.7 KiB
PHP

<?php
/* $Id: index.php 8 2009-01-11 06:02:53Z john $ */
$page="general";
include("header.php");
function general()
{ global $user, $url, $database;
if(isset($_POST["addsuggestion"]))
{
$database->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 <a href='https://bateworld.com/faq'>FAQ</a> for fast answers or open a <a href='https://support.bateworld.com/Tickets/Create?_ga=2.194330154.661384254.1685219080-213514799.1678642426'>Help Desk ticket now</a>.";
$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. <br /><br />
<?php
}
else{
?>
<div class="page_header"><span style="font-size:20pt; font-weight:bold; text-transform:uppercase;">SUGGESTIONS</span></div>
<div class="portal_spacer"></div>
<div class="portal_spacer"></div>
<div class="col-sm-3 homeleft "><div class="header">Got an idea or improvement?</div>
<div class="portal_content">
As we continue to make improvements to BateWorld, we welcome your feedback.<div class="portal_spacer"></div>
Do you have an idea about how to make bateworld.com better? Is there a feature you would like to see introduced or improved? Use the form to let us know. Just select a relevant category, write a short, clear description of what you'd like to see happen on the site, and we'll review it.
<div class="portal_spacer"></div><div class="portal_spacer"></div>
<strong>NOTE:</strong> This form is for suggestions and feedback only. For immediate assistance with the site, please check out our <a href="https://bateworld.com/faq/" target="_blank">FAQ</a> or <a href="https://support.bateworld.com/Tickets/Create" target="_blank">open a Help Desk ticket</a>.
<div class="portal_spacer"></div><div class="portal_spacer"></div><div class="portal_spacer"></div><div class="portal_spacer"></div><div class="portal_spacer"></div><div class="portal_spacer"></div>
</div></div>
<div class="col-sm-4">
<form method="post" action="add_suggestion.php">
Feedback Category<br>
<select name="category" style="max-width:200px; margin-top:5px;" class="form-control"><option></option><?php
$query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_categories ORDER BY title ASC");
while($row1=$database->database_fetch_array($query1))
{
if($row1["id"]!=7){
?>
<option value="<?php echo $row1["id"];?>" <?php if($row1["id"]==$row["category"]){?>selected="selected"<?php }?>><?php echo $row1["title"];?></option>
<?php }
}?><option value="7">Other</option></select>
<div class="portal_spacer"></div>
Headline<br>
<input type="text" name="title" style="margin-top:5px" class="form-control"><div class="portal_spacer"></div>
Suggestion/Feedback<br>
<textarea name="moreinfo" style="height:265px; margin-top:5px;" class="form-control"></textarea>
<div class="portal_spacer"></div>
<input type="submit" name="addsuggestion" value="Submit" style="padding:5px 15px 5px 15px;">
</form>
</div>
<div class="clearfix clear"></div>
<? }}
include("footer.php");
?>