Files
Testing/bwadmin/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

231 lines
7.7 KiB
PHP

<?php
$page = "admin_general1";
include "admin_header.php";
if(isset($_GET['task'])) { $task = $_GET['task']; } elseif(isset($_POST['task'])) { $task = $_POST['task']; } else { $task = "main"; }
if(isset($_GET['p'])) { $p = (int) $_GET['p']; } elseif(isset($_POST['p'])) { $p = (int) $_POST['p']; } else { $p = 1; }
if(isset($_GET['forum_id'])) { $forum_id = (int) $_GET['forum_id']; } elseif(isset($_POST['forum_id'])) { $forum_id = (int) $_POST['forum_id']; } else { $forum_id = 23; }
function general()
{ global $user, $url, $database, $admin;
?><h2>Suggestion</h2>
<br />
<br />
<br />
<br />
<script>
loadCSS('/templates/styles_forum.css');
loadCSSbegin('/include/bootstrap/css/bootstrap.css');
loadjsfile('/include/bootstrap/js/bootstrap.js');
</script>
<?php
$query=$database->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"]!="")
{
?>
<div class="col-sm-2">
ID: </div><div class="col-sm-6"><?php
echo $row["id"];?>
</div><div class="clearfix"></div>
<div class="col-sm-2">
Category: </div><div class="col-sm-6"><?php
$query1=$database->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"];?>
</div><div class="clearfix"></div><div class="col-sm-2">
Suggestion: </div><div class="col-sm-6"><?php echo $row["suggestion"];?></div><div class="clearfix"></div><div class="col-sm-2">
More Info: </div><div class="col-sm-6"><?php echo $row["moreinfo"];?></div><div class="clearfix"></div><div class="col-sm-2">
Status: </div><div class="col-sm-6"><?php if($row["status"]==0){?>Suggestion<?php }?><?php if($row["status"]==1){?>Approved<?php }?><?php if($row["status"]==2){?>In Progress<?php }?><?php if($row["status"]==3){?>Rejected<?php }?><?php if($row["status"]==4){?>Completed<?php }?></div><div class="clearfix"></div>
<div class="col-sm-2">
User: </div><div class="col-sm-6"><?php if($row["admin"]==1){
$query2=$database->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);
?><a href="/profile.php?user=<?php echo $row2["user_username"];?>"><?php echo $row2["user_username"];?></a><?php
}?>
</div><div class="clearfix"></div>
<div class="col-sm-2">
Involves: </div><div class="col-sm-6"><?php
unset($members);
$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='".$row1["adminid"]."'");
$row2=$database->database_fetch_array($query2);
?>
<?php echo $row2["admin_username"];?>
<?php
}?></div>
<div class="clearfix"></div>
<div class="col-sm-2">
Urgency: </div><div class="col-sm-6">
<?php echo $row["urgency"]; ?>
</div>
<div class="clearfix"></div>
<div class="col-sm-2"> Steps:
</div><div class="col-sm-6">
<div class="steps">
<?php
$x=1;
$query1=$database->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))
{
?><?php echo $x." ".$row1["text"];?><br />
<br />
<?php $x++;
}
?>
</div>
</div>
<div class="clearfix"></div>
<div class="col-sm-2">
Waiting on: </div><div class="col-sm-6"><?php
unset($members);
$query2=$database->database_query("SELECT * FROM `se_admins` WHERE admin_id='".$row["waitingon"]."'");
$row2=$database->database_fetch_array($query2);
?>
<?php echo $row2["admin_username"];?>
<?php
?>
</div>
<div class="clearfix"></div>
<div class="col-sm-12">
<br />
<br />
<div class="col-sm-12">
<ul class="nav nav-tabs">
<li><a href="/suggestion.php?id=<?php echo $_GET["id"];?>" class="jquerycss">Comments</a></li>
<li class="active"><a data-toggle="tab" href="#menu1" class="jquerycss">Admin Comments</a></li>
</ul>
<div class="tab-content">
<div id="menu1" class="tab-pane fade tabpadding active in">
<div class="col-sm-8"><strong>Comment</strong></div>
<div class="col-sm-2"><strong>User</strong></div>
<div class="col-sm-2"><strong>Time</strong></div>
<div class="clearfix"></div>
<?php
$query1=$database->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))
{?>
<div class="col-sm-8"><?php echo $row1["comment"];?><br />
<br />
</div>
<div class="col-sm-2"><?php
$query2=$database->database_query("SELECT * FROM bateworldcom.se_admins WHERE admin_id='".$row1["user"]."'");
$row2=$database->database_fetch_array($query2);
echo $row2["admin_username"];
?></div>
<div class="col-sm-2"><?php echo date("F j, Y g:i A",$row1["time"]);?></div>
<div class="clearfix"></div>
<hr />
<?php }?>
<form action="suggestion.php?id=<?php echo $_GET["id"];?>" method="post">
Submit comment:<br />
<textarea name="comment" style="width:350px; height:200px;"></textarea><br />
<input type="submit" value="Submit Comment" />
</form>
</div>
</div>
</div>
<?php
}
}
include "admin_footer.php";
?>