686 lines
22 KiB
PHP
686 lines
22 KiB
PHP
|
|
<?php
|
||
|
|
$page = "admin_general1";
|
||
|
|
include "admin_header.php";
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
function general()
|
||
|
|
{ global $user, $url, $database;
|
||
|
|
|
||
|
|
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; }
|
||
|
|
if(isset($_GET['v'])) { $v = (int) $_GET['v']; } elseif(isset($_POST['v'])) { $v = (int) $_POST['v']; } else { $v = 1; }
|
||
|
|
|
||
|
|
if($task=="delete"){
|
||
|
|
$database->database_query("DELETE FROM bateworldcom_zips.suggestions WHERE id='".$database->database_real_escape_string($_GET["id"])."'");
|
||
|
|
$database->database_query("DELETE FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($_GET["id"])."'");
|
||
|
|
$database->database_query("DELETE FROM bateworldcom_zips.suggestion_admin_comments WHERE suggestionid='".$database->database_real_escape_string($_GET["id"])."'");
|
||
|
|
$database->database_query("DELETE FROM bateworldcom_zips.suggestion_comments WHERE suggestionid='".$database->database_real_escape_string($_GET["id"])."'");
|
||
|
|
$database->database_query("DELETE FROM bateworldcom_zips.suggestion_steps WHERE projectid='".$database->database_real_escape_string($_GET["id"])."'");
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<style>.tabpadding{padding: 15px;}</style>
|
||
|
|
<h2>Suggestions</h2>
|
||
|
|
Suggestions by admin and members.<br />
|
||
|
|
<br />
|
||
|
|
<br />
|
||
|
|
<br />
|
||
|
|
<div class="col-sm-6">
|
||
|
|
<select name="category" id="category" onchange="window.location.href='suggestions.php?v=<?php echo $_GET["v"];?>&urgency='+document.getElementById('urgency').value+'&category='+this.value"><option value="">Category</option><?php
|
||
|
|
$query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_categories ORDER BY title DESC");
|
||
|
|
while($row1=$database->database_fetch_array($query1))
|
||
|
|
{
|
||
|
|
?>
|
||
|
|
|
||
|
|
<option value="<?php echo $row1["id"];?>" <?php if($row1["id"]==$_GET["category"]){?>selected="selected"<?php }?>><?php echo $row1["title"];?></option>
|
||
|
|
|
||
|
|
|
||
|
|
<?php
|
||
|
|
}?></select>
|
||
|
|
|
||
|
|
<select name="urgency" id="urgency" onchange="window.location.href='suggestions.php?v=<?php echo $_GET["v"];?>&category='+document.getElementById('category').value+'&urgency='+this.value"><option value="">Urgency</option>
|
||
|
|
<option value="1" <?php if($_GET["urgency"]==1){?>selected="selected"<?php }?>>1</option>
|
||
|
|
<option value="2" <?php if($_GET["urgency"]==2){?>selected="selected"<?php }?>>2</option>
|
||
|
|
<option value="3" <?php if($_GET["urgency"]==3){?>selected="selected"<?php }?>>3</option>
|
||
|
|
<option value="4" <?php if($_GET["urgency"]==4){?>selected="selected"<?php }?>>4</option>
|
||
|
|
<option value="5" <?php if($_GET["urgency"]==5){?>selected="selected"<?php }?>>5</option>
|
||
|
|
</select>
|
||
|
|
<?php
|
||
|
|
|
||
|
|
if($_GET["view"]=="popular")
|
||
|
|
{
|
||
|
|
//$query=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE admin=0 ORDER BY votes DESC");
|
||
|
|
}
|
||
|
|
elseif($_GET["view"]=="inprogress")
|
||
|
|
{
|
||
|
|
//$query=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE status=1 ORDER BY votes DESC");
|
||
|
|
}
|
||
|
|
elseif($_GET["view"]=="rejected")
|
||
|
|
{
|
||
|
|
//$query=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE status=3 ORDER BY votes DESC");
|
||
|
|
}
|
||
|
|
elseif($_GET["view"]=="completed")
|
||
|
|
{
|
||
|
|
//$query=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE status=2 ORDER BY votes DESC");
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
$_GET["view"]="new";
|
||
|
|
//$query=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE admin=0 ORDER BY id DESC");
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
?>
|
||
|
|
|
||
|
|
<script>
|
||
|
|
loadCSS('/templates/styles_forum.css');
|
||
|
|
loadCSSbegin('/include/bootstrap/css/bootstrap.css');
|
||
|
|
loadjsfile('/include/bootstrap/js/bootstrap.js');
|
||
|
|
</script>
|
||
|
|
</div><div class="col-sm-6">
|
||
|
|
<a href="add_suggestion.php">Add New Suggestion</a>
|
||
|
|
</div><div class="clearfix"></div>
|
||
|
|
<br />
|
||
|
|
<br />
|
||
|
|
|
||
|
|
<ul class="nav nav-tabs">
|
||
|
|
<li <?php if($v==1){?>class="active"<?php }?>><a href="suggestions.php?v=1" class="jquerycss">By Members</a></li>
|
||
|
|
<li <?php if($v==6){?>class="active"<?php }?>><a href="suggestions.php?v=6" class="jquerycss">By Admin</a></li>
|
||
|
|
<li <?php if($v==7){?>class="active"<?php }?>><a href="suggestions.php?v=7" class="jquerycss">Under Review</a></li>
|
||
|
|
<li <?php if($v==2){?>class="active"<?php }?>><a href="suggestions.php?v=2" class="jquerycss">Approved</a></li>
|
||
|
|
<li <?php if($v==3){?>class="active"<?php }?>><a href="suggestions.php?v=3" class="jquerycss">In Progress</a></li>
|
||
|
|
<li <?php if($v==4){?>class="active"<?php }?>><a href="suggestions.php?v=4" class="jquerycss">Rejected</a></li>
|
||
|
|
<li <?php if($v==5){?>class="active"<?php }?>><a href="suggestions.php?v=5" class="jquerycss">Completed</a></li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="tab-content">
|
||
|
|
|
||
|
|
|
||
|
|
<div id="home" class="tab-pane fade in <?php if($v==7){?>active in<?php }?> tabpadding">
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<?php
|
||
|
|
$also="";
|
||
|
|
if($_GET["category"]!="")
|
||
|
|
{
|
||
|
|
$also=$also." AND category='".$database->database_real_escape_string($_GET["category"])."' ";
|
||
|
|
}
|
||
|
|
if($_GET["urgency"]!="")
|
||
|
|
{
|
||
|
|
$also=$also." AND urgency='".$database->database_real_escape_string($_GET["urgency"])."' ";
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
if($v==7){
|
||
|
|
|
||
|
|
$reports_query="SELECT * FROM bateworldcom_zips.suggestions WHERE status=5 ".$also." ORDER BY id DESC";
|
||
|
|
|
||
|
|
$total_users = $database->database_num_rows($database->database_query($reports_query));
|
||
|
|
|
||
|
|
// MAKE USER PAGES
|
||
|
|
$users_per_page = 100;
|
||
|
|
|
||
|
|
|
||
|
|
$page_vars = make_page($total_users, $users_per_page, $p);
|
||
|
|
|
||
|
|
$page_array = Array();
|
||
|
|
for($x=0;$x<=$page_vars[2]-1;$x++) {
|
||
|
|
if($x+1 == $page_vars[1]) { $link = "1"; } else { $link = "0"; }
|
||
|
|
$page_array[$x] = Array('page' => $x+1,
|
||
|
|
'link' => $link);
|
||
|
|
}
|
||
|
|
|
||
|
|
$reports_query .= " LIMIT $page_vars[0], $users_per_page ";
|
||
|
|
?>Page: <?php
|
||
|
|
for($i=1; $i<=$page_vars[2]; $i++)
|
||
|
|
{
|
||
|
|
if($i==$p){
|
||
|
|
echo $i." ";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
?><a href="suggestions.php?v=<?php echo $_GET["v"];?>&p=<?php echo $i;?>&usage=<?php echo $usage;?>&from=<?php echo $from;?>"><?php echo $i;?></a> <?php
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$query=$database->database_query($reports_query);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
while($row=$database->database_fetch_array($query))
|
||
|
|
{
|
||
|
|
?>
|
||
|
|
<div class="suggestioncontainer">
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<?php echo $row["votes"];?><br />
|
||
|
|
votes<br />
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-8 no-gutter pad5top">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Project ID: <?php echo $row["id"];?><br />
|
||
|
|
<?php echo $row["suggestion"];?></a>
|
||
|
|
|
||
|
|
<?php echo html_entity_decode($row["moreinfo"]);?>
|
||
|
|
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-2"><?php echo date("F j, Y g:i A",$row["date"]);?><br />
|
||
|
|
<br />
|
||
|
|
<?php if($row["admin"]==1){echo "Adminq12: "."SELECT * from bateworldcom.se_admins WHERE admin_id='".$row["admincreator"]."'";
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_admins WHERE admin_id='".$row["admincreator"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
echo $user2["admin_username"];
|
||
|
|
}else{?>By: <?php
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_users WHERE user_id='".$row["user"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
echo $user2["user_username"];
|
||
|
|
}?></div>
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Edit</a> |
|
||
|
|
<a href="suggestions.php?id=<?php echo $row["id"];?>&task=delete" onclick="return confirm('Are you sure?')">Delete</a>
|
||
|
|
</div>
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
</div>
|
||
|
|
<hr />
|
||
|
|
<?php
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
?>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<div id="home" class="tab-pane fade in <?php if($v==1){?>active in<?php }?> tabpadding">
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<?php
|
||
|
|
|
||
|
|
if($v==1){
|
||
|
|
|
||
|
|
$reports_query="SELECT * FROM bateworldcom_zips.suggestions WHERE admin=0 AND status=0 ".$also." ORDER BY id DESC";
|
||
|
|
|
||
|
|
$total_users = $database->database_num_rows($database->database_query($reports_query));
|
||
|
|
|
||
|
|
// MAKE USER PAGES
|
||
|
|
$users_per_page = 100;
|
||
|
|
|
||
|
|
|
||
|
|
$page_vars = make_page($total_users, $users_per_page, $p);
|
||
|
|
|
||
|
|
$page_array = Array();
|
||
|
|
for($x=0;$x<=$page_vars[2]-1;$x++) {
|
||
|
|
if($x+1 == $page_vars[1]) { $link = "1"; } else { $link = "0"; }
|
||
|
|
$page_array[$x] = Array('page' => $x+1,
|
||
|
|
'link' => $link);
|
||
|
|
}
|
||
|
|
|
||
|
|
$reports_query .= " LIMIT $page_vars[0], $users_per_page ";
|
||
|
|
?>Page: <?php
|
||
|
|
for($i=1; $i<=$page_vars[2]; $i++)
|
||
|
|
{
|
||
|
|
if($i==$p){
|
||
|
|
echo $i." ";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
?><a href="suggestions.php?v=<?php echo $_GET["v"];?>&p=<?php echo $i;?>&usage=<?php echo $usage;?>&from=<?php echo $from;?>"><?php echo $i;?></a> <?php
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$query=$database->database_query($reports_query);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
while($row=$database->database_fetch_array($query))
|
||
|
|
{
|
||
|
|
?>
|
||
|
|
<div class="suggestioncontainer">
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<?php echo $row["votes"];?><br />
|
||
|
|
votes<br />
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-8 no-gutter pad5top">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Project ID: <?php echo $row["id"];?><br />
|
||
|
|
<?php echo $row["suggestion"];?></a>
|
||
|
|
<?php echo html_entity_decode($row["moreinfo"]);?>
|
||
|
|
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-2"><?php echo date("F j, Y g:i A",$row["date"]);?><br />
|
||
|
|
<br />
|
||
|
|
<?php if($row["admin"]==1){echo "Admin: ";
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_admins WHERE admin_id='".$row["admincreator"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
echo $user2["admin_username"];
|
||
|
|
}else{?>By: <?php
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_users WHERE user_id='".$row["user"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
echo $user2["user_username"];
|
||
|
|
}?></div>
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Edit</a> |
|
||
|
|
<a href="suggestions.php?id=<?php echo $row["id"];?>&task=delete" onclick="return confirm('Are you sure?')">Delete</a>
|
||
|
|
</div>
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
</div>
|
||
|
|
<hr />
|
||
|
|
<?php
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
?>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<div id="home" class="tab-pane fade in <?php if($v==6){?>active in<?php }?> tabpadding">
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<?php
|
||
|
|
if($v==6){
|
||
|
|
|
||
|
|
$reports_query="SELECT * FROM bateworldcom_zips.suggestions WHERE admin=1 AND status=0 ".$also." ORDER BY id DESC";
|
||
|
|
|
||
|
|
$total_users = $database->database_num_rows($database->database_query($reports_query));
|
||
|
|
|
||
|
|
// MAKE USER PAGES
|
||
|
|
$users_per_page = 100;
|
||
|
|
|
||
|
|
|
||
|
|
$page_vars = make_page($total_users, $users_per_page, $p);
|
||
|
|
|
||
|
|
$page_array = Array();
|
||
|
|
for($x=0;$x<=$page_vars[2]-1;$x++) {
|
||
|
|
if($x+1 == $page_vars[1]) { $link = "1"; } else { $link = "0"; }
|
||
|
|
$page_array[$x] = Array('page' => $x+1,
|
||
|
|
'link' => $link);
|
||
|
|
}
|
||
|
|
|
||
|
|
$reports_query .= " LIMIT $page_vars[0], $users_per_page ";
|
||
|
|
?>Page: <?php
|
||
|
|
for($i=1; $i<=$page_vars[2]; $i++)
|
||
|
|
{
|
||
|
|
if($i==$p){
|
||
|
|
echo $i." ";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
?><a href="suggestions.php?v=<?php echo $_GET["v"];?>&p=<?php echo $i;?>&usage=<?php echo $usage;?>&from=<?php echo $from;?>"><?php echo $i;?></a> <?php
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$query=$database->database_query($reports_query);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
while($row=$database->database_fetch_array($query))
|
||
|
|
{
|
||
|
|
?>
|
||
|
|
<div class="suggestioncontainer">
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<?php echo $row["votes"];?><br />
|
||
|
|
votes<br />
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-8 no-gutter pad5top">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Project ID: <?php echo $row["id"];?><br /><?php echo $row["suggestion"];?></a>
|
||
|
|
<?php echo html_entity_decode($row["moreinfo"]);?>
|
||
|
|
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-2"><?php echo date("F j, Y g:i A",$row["date"]);?><br />
|
||
|
|
<br />
|
||
|
|
<?php if($row["admin"]==1){echo "Admin: ";
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_admins WHERE admin_id='".$row["admincreator"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
echo $user2["admin_username"];
|
||
|
|
}else{?>By: <?php
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_users WHERE user_id='".$row["user"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
echo $user2["user_username"];
|
||
|
|
}?></div>
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Edit</a> |
|
||
|
|
<a href="suggestions.php?id=<?php echo $row["id"];?>&task=delete" onclick="return confirm('Are you sure?')">Delete</a>
|
||
|
|
</div>
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
</div>
|
||
|
|
<hr />
|
||
|
|
<?php
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
?>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
|
||
|
|
<div id="menu1" class="tab-pane fade tabpadding <?php if($v==2){?>active in<?php }?>">
|
||
|
|
<?php
|
||
|
|
if($v==2){
|
||
|
|
|
||
|
|
$reports_query="SELECT * FROM bateworldcom_zips.suggestions WHERE status=1 ".$also." ORDER BY votes DESC";
|
||
|
|
|
||
|
|
$total_users = $database->database_num_rows($database->database_query($reports_query));
|
||
|
|
|
||
|
|
// MAKE USER PAGES
|
||
|
|
$users_per_page = 100;
|
||
|
|
|
||
|
|
|
||
|
|
$page_vars = make_page($total_users, $users_per_page, $p);
|
||
|
|
|
||
|
|
$page_array = Array();
|
||
|
|
for($x=0;$x<=$page_vars[2]-1;$x++) {
|
||
|
|
if($x+1 == $page_vars[1]) { $link = "1"; } else { $link = "0"; }
|
||
|
|
$page_array[$x] = Array('page' => $x+1,
|
||
|
|
'link' => $link);
|
||
|
|
}
|
||
|
|
|
||
|
|
$reports_query .= " LIMIT $page_vars[0], $users_per_page ";
|
||
|
|
?>Page: <?php
|
||
|
|
for($i=1; $i<=$page_vars[2]; $i++)
|
||
|
|
{
|
||
|
|
if($i==$p){
|
||
|
|
echo $i." ";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
?><a href="suggestions.php?v=<?php echo $_GET["v"];?>&p=<?php echo $i;?>&usage=<?php echo $usage;?>&from=<?php echo $from;?>"><?php echo $i;?></a> <?php
|
||
|
|
}
|
||
|
|
}
|
||
|
|
$query=$database->database_query($reports_query);
|
||
|
|
while($row=$database->database_fetch_array($query))
|
||
|
|
{
|
||
|
|
?>
|
||
|
|
<div class="suggestioncontainer">
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<?php echo $row["votes"];?><br />
|
||
|
|
votes<br />
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-8 no-gutter pad5top">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Project ID: <?php echo $row["id"];?><br /><?php echo $row["suggestion"];?></a>
|
||
|
|
<?php echo html_entity_decode($row["moreinfo"]);?>
|
||
|
|
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-2"><?php echo date("F j, Y g:i A",$row["date"]);?><br />
|
||
|
|
<br />
|
||
|
|
<?php if($row["admin"]==1){echo "Admin: ";
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_admins WHERE admin_id='".$row["admincreator"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
|
||
|
|
echo $user2["admin_username"];
|
||
|
|
}else{?>By: <?php
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_users WHERE user_id='".$row["user"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
echo $user2["user_username"];
|
||
|
|
}?></div>
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Edit</a> |
|
||
|
|
<a href="suggestions.php?id=<?php echo $row["id"];?>&task=delete" onclick="return confirm('Are you sure?')">Delete</a>
|
||
|
|
</div>
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
</div>
|
||
|
|
<hr />
|
||
|
|
<?php
|
||
|
|
}
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</div>
|
||
|
|
<div id="menu2" class="tab-pane fade tabpadding <?php if($v==3){?>active in<?php }?>">
|
||
|
|
<?php
|
||
|
|
if($v==3){
|
||
|
|
|
||
|
|
$reports_query="SELECT * FROM bateworldcom_zips.suggestions WHERE status=2 ".$also." ORDER BY votes DESC";
|
||
|
|
$total_users = $database->database_num_rows($database->database_query($reports_query));
|
||
|
|
|
||
|
|
// MAKE USER PAGES
|
||
|
|
$users_per_page = 100;
|
||
|
|
|
||
|
|
|
||
|
|
$page_vars = make_page($total_users, $users_per_page, $p);
|
||
|
|
|
||
|
|
$page_array = Array();
|
||
|
|
for($x=0;$x<=$page_vars[2]-1;$x++) {
|
||
|
|
if($x+1 == $page_vars[1]) { $link = "1"; } else { $link = "0"; }
|
||
|
|
$page_array[$x] = Array('page' => $x+1,
|
||
|
|
'link' => $link);
|
||
|
|
}
|
||
|
|
|
||
|
|
$reports_query .= " LIMIT $page_vars[0], $users_per_page ";
|
||
|
|
?>Page: <?php
|
||
|
|
for($i=1; $i<=$page_vars[2]; $i++)
|
||
|
|
{
|
||
|
|
if($i==$p){
|
||
|
|
echo $i." ";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
?><a href="suggestions.php?v=<?php echo $_GET["v"];?>&p=<?php echo $i;?>&usage=<?php echo $usage;?>&from=<?php echo $from;?>"><?php echo $i;?></a> <?php
|
||
|
|
}
|
||
|
|
}
|
||
|
|
$query=$database->database_query($reports_query);
|
||
|
|
while($row=$database->database_fetch_array($query))
|
||
|
|
{
|
||
|
|
|
||
|
|
?>
|
||
|
|
<div class="suggestioncontainer">
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<?php echo $row["votes"];?><br />
|
||
|
|
votes<br />
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-8 no-gutter pad5top">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Project ID: <?php echo $row["id"];?><br /><?php echo $row["suggestion"];?></a>
|
||
|
|
<?php echo html_entity_decode($row["moreinfo"]);?>
|
||
|
|
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-2"><?php echo date("F j, Y g:i A",$row["date"]);?><br />
|
||
|
|
<br />
|
||
|
|
<?php if($row["admin"]==1){echo "Admin: ";
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_admins WHERE admin_id='".$row["admincreator"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
echo $user2["admin_username"];
|
||
|
|
}else{?>By: <?php
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_users WHERE user_id='".$row["user"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
echo $user2["user_username"];
|
||
|
|
}?></div>
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Edit</a> |
|
||
|
|
<a href="suggestions.php?id=<?php echo $row["id"];?>&task=delete" onclick="return confirm('Are you sure?')">Delete</a>
|
||
|
|
</div>
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
</div>
|
||
|
|
<hr />
|
||
|
|
<?php
|
||
|
|
}
|
||
|
|
}?>
|
||
|
|
</div>
|
||
|
|
<div id="menu3" class="tab-pane fade tabpadding <?php if($v==4){?>active in<?php }?>">
|
||
|
|
<?php
|
||
|
|
|
||
|
|
if($v==4){
|
||
|
|
$reports_query="SELECT * FROM bateworldcom_zips.suggestions WHERE status=3 ".$also." ORDER BY votes DESC";
|
||
|
|
|
||
|
|
$total_users = $database->database_num_rows($database->database_query($reports_query));
|
||
|
|
|
||
|
|
// MAKE USER PAGES
|
||
|
|
$users_per_page = 100;
|
||
|
|
|
||
|
|
|
||
|
|
$page_vars = make_page($total_users, $users_per_page, $p);
|
||
|
|
|
||
|
|
$page_array = Array();
|
||
|
|
for($x=0;$x<=$page_vars[2]-1;$x++) {
|
||
|
|
if($x+1 == $page_vars[1]) { $link = "1"; } else { $link = "0"; }
|
||
|
|
$page_array[$x] = Array('page' => $x+1,
|
||
|
|
'link' => $link);
|
||
|
|
}
|
||
|
|
|
||
|
|
$reports_query .= " LIMIT $page_vars[0], $users_per_page ";
|
||
|
|
?>Page: <?php
|
||
|
|
for($i=1; $i<=$page_vars[2]; $i++)
|
||
|
|
{
|
||
|
|
if($i==$p){
|
||
|
|
echo $i." ";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
?><a href="suggestions.php?v=<?php echo $_GET["v"];?>&p=<?php echo $i;?>&usage=<?php echo $usage;?>&from=<?php echo $from;?>"><?php echo $i;?></a> <?php
|
||
|
|
}
|
||
|
|
}
|
||
|
|
$query=$database->database_query($reports_query);
|
||
|
|
while($row=$database->database_fetch_array($query))
|
||
|
|
{
|
||
|
|
?>
|
||
|
|
<div class="suggestioncontainer">
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<?php echo $row["votes"];?><br />
|
||
|
|
votes<br />
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-8 no-gutter pad5top">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Project ID: <?php echo $row["id"];?><br /><?php echo $row["suggestion"];?></a>
|
||
|
|
<?php echo html_entity_decode($row["moreinfo"]);?>
|
||
|
|
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-2"><?php echo date("F j, Y g:i A",$row["date"]);?><br />
|
||
|
|
<br />
|
||
|
|
<?php if($row["admin"]==1){echo "Admin: ";
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_admins WHERE admin_id='".$row["admincreator"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
echo $user2["admin_username"];
|
||
|
|
}else{?>By: <?php
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_users WHERE user_id='".$row["user"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
echo $user2["user_username"];
|
||
|
|
}?></div>
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Edit</a> |
|
||
|
|
<a href="suggestions.php?id=<?php echo $row["id"];?>&task=delete" onclick="return confirm('Are you sure?')">Delete</a>
|
||
|
|
</div>
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
</div>
|
||
|
|
<hr />
|
||
|
|
<?php
|
||
|
|
}
|
||
|
|
}?>
|
||
|
|
</div>
|
||
|
|
<div id="menu4" class="tab-pane fade tabpadding <?php if($v==5){?>active in<?php }?>">
|
||
|
|
<?php
|
||
|
|
if($v==5){
|
||
|
|
|
||
|
|
$reports_query="SELECT * FROM bateworldcom_zips.suggestions WHERE status=4 ".$also." ORDER BY votes DESC";
|
||
|
|
|
||
|
|
$total_users = $database->database_num_rows($database->database_query($reports_query));
|
||
|
|
|
||
|
|
// MAKE USER PAGES
|
||
|
|
$users_per_page = 100;
|
||
|
|
|
||
|
|
|
||
|
|
$page_vars = make_page($total_users, $users_per_page, $p);
|
||
|
|
|
||
|
|
$page_array = Array();
|
||
|
|
for($x=0;$x<=$page_vars[2]-1;$x++) {
|
||
|
|
if($x+1 == $page_vars[1]) { $link = "1"; } else { $link = "0"; }
|
||
|
|
$page_array[$x] = Array('page' => $x+1,
|
||
|
|
'link' => $link);
|
||
|
|
}
|
||
|
|
|
||
|
|
$reports_query .= " LIMIT $page_vars[0], $users_per_page ";
|
||
|
|
?>Page: <?php
|
||
|
|
for($i=1; $i<=$page_vars[2]; $i++)
|
||
|
|
{
|
||
|
|
if($i==$p){
|
||
|
|
echo $i." ";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
?><a href="suggestions.php?v=<?php echo $_GET["v"];?>&p=<?php echo $i;?>&usage=<?php echo $usage;?>&from=<?php echo $from;?>"><?php echo $i;?></a> <?php
|
||
|
|
}
|
||
|
|
}
|
||
|
|
$query=$database->database_query($reports_query);
|
||
|
|
while($row=$database->database_fetch_array($query))
|
||
|
|
{
|
||
|
|
?>
|
||
|
|
<div class="suggestioncontainer">
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<?php echo $row["votes"];?><br />
|
||
|
|
votes<br />
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-8 no-gutter pad5top">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Project ID: <?php echo $row["id"];?><br /><?php echo $row["suggestion"];?></a><br />
|
||
|
|
|
||
|
|
<?php echo html_entity_decode($row["moreinfo"]);?>
|
||
|
|
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<div class="col-sm-2"><?php echo date("F j, Y g:i A",$row["date"]);?><br />
|
||
|
|
<br />
|
||
|
|
<?php if($row["admin"]==1){echo "Admin: ";
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_admins WHERE admin_id='".$row["admincreator"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
echo $user2["admin_username"];
|
||
|
|
}else{?>By: <?php
|
||
|
|
$userquery=$database->database_query("SELECT * from bateworldcom.se_users WHERE user_id='".$row["user"]."'");
|
||
|
|
$user2=$database->database_fetch_array($userquery);
|
||
|
|
echo $user2["user_username"];
|
||
|
|
}?></div>
|
||
|
|
<div class="col-sm-1 center no-gutter">
|
||
|
|
<a href="add_suggestion.php?id=<?php echo $row["id"];?>">Edit</a> |
|
||
|
|
<a href="suggestions.php?id=<?php echo $row["id"];?>&task=delete" onclick="return confirm('Are you sure?')">Delete</a>
|
||
|
|
</div>
|
||
|
|
<div class="clear clearfix"></div>
|
||
|
|
</div>
|
||
|
|
<hr />
|
||
|
|
<?php
|
||
|
|
}
|
||
|
|
}?>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</div>
|
||
|
|
<? }
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
include "admin_footer.php";
|
||
|
|
?>
|