Files
Testing/suggestions.php

818 lines
36 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
$page = "general";
include "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(isset($_GET['category'])) { $category = (int) $_GET['category']; } elseif(isset($_POST['category'])) { $category = (int) $_POST['category']; } else { $category = ""; }
if(isset($_GET['search'])) { $search = $_GET['search']; } elseif(isset($_POST['search'])) { $search = $_POST['search']; } else { $search = ""; }
if($category=="0"){$category="";}
?>
<style>.tabpadding{padding: 15px;}</style>
<h2>Suggestions</h2>
<?php if($v==1){?>
We welcome your suggestions. To see comments on each suggestion, click on the actual suggestion. If you want to vote, click on vote.<br />
<?php }?><br />
<br />
<br />
<div class="col-sm-3">
Category: <select name="category" onchange="window.location.href='suggestions.php?category='+this.value"><option value=""></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>
<?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>
function voteforsuggestion(id){
jQuery.ajax({
url: "misc_js.php?task=vote_suggestion&id="+id,
context: document.body,
success: function(data) {
if(data!=""){
jQuery(".votecount"+id).html(data+"<br />votes");
}
return data;
}
}).done(function() {
});
}
</script>
</div>
<div class="col-sm-3">
<form method="get" action="suggestions.php"><input type="text" name="search" placeholder="Search" value="<?php echo $search;?>" style="color:black;" /><input type="submit" name="submit" value="Search" /></form>
</div>
<div class="col-sm-4 pull-right text-right">
<a href="add_suggestion.php">Add New Suggestion</a>
</div><div class="clearfix"></div>
<br />
<br />
<ul class="nav nav-tabs hidden-xs hidden-sm visible-md visible-lg">
<li class="jquerycss <?php if($v==1){?>active<?php }?>"><a href="suggestions.php?category=<?php echo $category;?>&search=<?php echo $search;?>&v=1">Suggestions</a></li>
<li class="jquerycss <?php if($v==2){?>active<?php }?>"><a href="suggestions.php?category=<?php echo $category;?>&search=<?php echo $search;?>&v=2" >Approved</a></li>
<!--<li class="jquerycss <?php if($v==3){?>active<?php }?>"><a href="suggestions.php?category=<?php echo $category;?>&search=<?php echo $search;?>&v=3" >In Progress</a></li>
<li class="jquerycss <?php if($v==4){?>active<?php }?>"><a href="suggestions.php?category=<?php echo $category;?>&search=<?php echo $search;?>&v=4" >Rejected</a></li>-->
<li class="jquerycss <?php if($v==5){?>active<?php }?>"><a href="suggestions.php?category=<?php echo $category;?>&search=<?php echo $search;?>&v=5" >Completed</a></li>
</ul>
<div class="visible-xs visible-sm hidden-md hidden-lg">Select Tab:<br />
<select class="mb10 form-control form-custom visible-xs visible-sm hidden-md hidden-lg tabdropdown" id="tab_selector" onchange="window.location.href=this.value">
<option <?php if($v==1){?>selected="selected"<?php }?> value="suggestions.php?category=<?php echo $category;?>&search=<?php echo $search;?>&v=1" >Suggestions</a></li>
<option <?php if($v==2){?>selected="selected"<?php }?> value="suggestions.php?category=<?php echo $category;?>&search=<?php echo $search;?>&v=2" >Approved</a></li>
<!--<option <?php if($v==3){?>selected="selected"<?php }?> value="suggestions.php?category=<?php echo $category;?>&search=<?php echo $search;?>&v=3" >In Progress</a></li>
<option <?php if($v==4){?>selected="selected"<?php }?> value="suggestions.php?category=<?php echo $category;?>&search=<?php echo $search;?>&v=4" >Rejected</a></li>-->
<option <?php if($v==5){?>selected="selected"<?php }?> value="suggestions.php?category=<?php echo $category;?>&search=<?php echo $search;?>&v=5" >Completed</a></li>
</select>
</div>
<div class="tab-content">
<div id="home" class="tab-pane fade in <?php if($v==1){?>active in<?php }?> tabpadding">
<?php
if($_GET["category"]!="")
{
$category= " AND category='".$database->database_real_escape_string($_GET["category"])."'";
}
if($search!=""){$search_query=" AND (suggestion LIKE '%".$search."%' OR moreinfo LIKE '%".$search."%')";}
if($v==1){
$reports_query="SELECT * FROM bateworldcom_zips.suggestions WHERE admin=0 AND (status=0 OR status=5) ".$category.$search_query." ORDER BY id DESC";
$query=$database->database_query($reports_query);
$total_users = $database->database_num_rows($database->database_query($reports_query));
// MAKE USER PAGES
$users_per_page = 20;
$p=$_GET["p"];
if($p<1){$p=1;}
//$query = $database->database_query("SELECT * FROM {$type}comments WHERE object_id='".$$focus."' ORDER BY id DESC");
if($p==""){$p=1;}
$total_files = $total_users;
$page_vars = make_page($total_files, $users_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query($reports_query . " LIMIT ".$database->database_real_escape_string($page_vars[0]).", ".$users_per_page);
$total_friends1=$database->database_num_rows($query);
if($page_vars[2]> 1){?>
<div class='browse_pages'>
<? if($page_vars[1]!= 1){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=1"><span class="white arrow">&#171;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p-1?>" onclick="loadXMLDoc(<?=$p-1?>);"><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</span></font><? }?>
| <?
foreach($for as $foo){?>
<a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$foo?>"><?=$foo?></a>
<? }?> |
<? if($page_vars[1]!= $page_vars[2]){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p+1?>"><span class="white arrow">&#8250;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$page_vars[2]?>"><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</span></font><? }?>
<br /><span style="font-weight:normal;"><? if(($page_vars[0]+1)==($page_vars[0]+$total_friends1)){?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }else{?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }?></span><br />
<form method="get">Go to Page: <input type="text" name="p" id="p1" class="gotext" style="color:black;" /><input type="hidden" name="v" value="<?=$v?>" /><input type="submit" value="Go" /></form>
</div>
<? }
if($total_files==0)
{
echo "No suggestions found";
}
while($row=$database->database_fetch_array($query))
{
?>
<div class="suggestioncontainer">
<div class="col-sm-1 center no-gutter">
<span class="votecount<?php echo $row["id"];?>"><?php echo $row["votes"];?><br />
votes</span><br />
<input type="button" name"vote" onclick="voteforsuggestion('<?php echo $row["id"];?>');" value="Vote" />
</div>
<div class="col-sm-8 no-gutter pad5top">
<strong>ID:</strong> <?php echo $row["id"];?><br />
<a href="suggestion.php?id=<?php echo $row["id"];?>"><?php echo $row["suggestion"];?></a>
<?php echo html_entity_decode($row["moreinfo"]);?>
<?php if($row["explanation"]!=""){?><br />
<br />
<strong>Admin note: </strong><?php echo $row["explanation"];}?>
<div class="clear clearfix"></div>
</div>
<div class="col-sm-2"><?php
if($row["lastupdate"]>0){echo date("F j, Y g:i A",$row["lastupdate"]);}else{
echo date("F j, Y g:i A",$row["date"]);}?><br />
<?php
if($row["status"]==5){?>Under Review<?php }?></div>
<div class="clear clearfix"></div>
</div>
<hr />
<?php
}
$total_users = $database->database_num_rows($database->database_query($reports_query));
// MAKE USER PAGES
$users_per_page = 20;
$p=$_GET["p"];
if($p<1){$p=1;}
//$query = $database->database_query("SELECT * FROM {$type}comments WHERE object_id='".$$focus."' ORDER BY id DESC");
if($p==""){$p=1;}
$total_files = $total_users;
$page_vars = make_page($total_files, $users_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{}
$query=$database->database_query($reports_query . " LIMIT ".$database->database_real_escape_string($page_vars[0]).", ".$users_per_page);
$total_friends1=$database->database_num_rows($query);
if($page_vars[2]> 1){?>
<div class='browse_pages'>
<? if($page_vars[1]!= 1){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=1"><span class="white arrow">&#171;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p-1?>" onclick="loadXMLDoc(<?=$p-1?>);"><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</span></font><? }?>
| <?
foreach($for as $foo){?>
<a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$foo?>"><?=$foo?></a>
<? }?> |
<? if($page_vars[1]!= $page_vars[2]){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p+1?>"><span class="white arrow">&#8250;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$page_vars[2]?>"><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</span></font><? }?>
<br /><span style="font-weight:normal;"><? if(($page_vars[0]+1)==($page_vars[0]+$total_friends1)){?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }else{?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }?></span><br />
<form method="get">Go to Page: <input type="text" name="p" id="p1" class="gotext" style="color:black;" /><input type="hidden" name="v" value="<?=$v?>" /><input type="submit" value="Go" /></form>
</div>
<? }
}
?>
</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 admin=0 AND status=1 ".$category.$search_query." ORDER BY votes DESC";
$query=$database->database_query($reports_query);
$total_users = $database->database_num_rows($database->database_query($reports_query));
// MAKE USER PAGES
$users_per_page = 20;
$p=$_GET["p"];
if($p<1){$p=1;}
//$query = $database->database_query("SELECT * FROM {$type}comments WHERE object_id='".$$focus."' ORDER BY id DESC");
if($p==""){$p=1;}
$total_files = $total_users;
$page_vars = make_page($total_files, $users_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query($reports_query . " LIMIT ".$database->database_real_escape_string($page_vars[0]).", ".$users_per_page);
$total_friends1=$database->database_num_rows($query);
if($page_vars[2]> 1){?>
<div class='browse_pages'>
<? if($page_vars[1]!= 1){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=1"><span class="white arrow">&#171;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p-1?>" onclick="loadXMLDoc(<?=$p-1?>);"><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</span></font><? }?>
| <?
foreach($for as $foo){?>
<a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$foo?>"><?=$foo?></a>
<? }?> |
<? if($page_vars[1]!= $page_vars[2]){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p+1?>"><span class="white arrow">&#8250;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$page_vars[2]?>"><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</span></font><? }?>
<br /><span style="font-weight:normal;"><? if(($page_vars[0]+1)==($page_vars[0]+$total_friends1)){?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }else{?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }?></span><br />
<form method="get">Go to Page: <input type="text" name="p" id="p1" class="gotext" style="color:black;" /><input type="hidden" name="v" value="<?=$v?>" /><input type="submit" value="Go" /></form>
</div>
<? }
if($total_files==0)
{
echo "No suggestions found";
}
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="suggestion.php?id=<?php echo $row["id"];?>"><?php echo $row["suggestion"];?></a>
<?php echo html_entity_decode($row["moreinfo"]);?> <?php if($row["explanation"]!=""){?><br />
<br />
<strong>Admin note: </strong><?php echo $row["explanation"];}?><div class="clear clearfix"></div>
</div>
<div class="col-sm-2"><?php echo date("F j, Y g:i A",$row["date"]);?></div>
<div class="clear clearfix"></div>
</div>
<hr />
<?php
}
$total_users = $database->database_num_rows($database->database_query($reports_query));
// MAKE USER PAGES
$users_per_page = 20;
$p=$_GET["p"];
if($p<1){$p=1;}
//$query = $database->database_query("SELECT * FROM {$type}comments WHERE object_id='".$$focus."' ORDER BY id DESC");
if($p==""){$p=1;}
$total_files = $total_users;
$page_vars = make_page($total_files, $users_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{}
$query=$database->database_query($reports_query . " LIMIT ".$database->database_real_escape_string($page_vars[0]).", ".$users_per_page);
$total_friends1=$database->database_num_rows($query);
if($page_vars[2]> 1){?>
<div class='browse_pages'>
<? if($page_vars[1]!= 1){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=1"><span class="white arrow">&#171;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p-1?>" onclick="loadXMLDoc(<?=$p-1?>);"><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</span></font><? }?>
| <?
foreach($for as $foo){?>
<a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$foo?>"><?=$foo?></a>
<? }?> |
<? if($page_vars[1]!= $page_vars[2]){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p+1?>"><span class="white arrow">&#8250;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$page_vars[2]?>"><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</span></font><? }?>
<br /><span style="font-weight:normal;"><? if(($page_vars[0]+1)==($page_vars[0]+$total_friends1)){?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }else{?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }?></span><br />
<form method="get">Go to Page: <input type="text" name="p" id="p1" class="gotext" style="color:black;" /><input type="hidden" name="v" value="<?=$v?>" /><input type="submit" value="Go" /></form>
</div>
<? }
}
?>
</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 admin=0 AND status=2 ".$category.$search_query." ORDER BY votes DESC";
$query=$database->database_query($reports_query);
$total_users = $database->database_num_rows($database->database_query($reports_query));
// MAKE USER PAGES
$users_per_page = 20;
$p=$_GET["p"];
if($p<1){$p=1;}
//$query = $database->database_query("SELECT * FROM {$type}comments WHERE object_id='".$$focus."' ORDER BY id DESC");
if($p==""){$p=1;}
$total_files = $total_users;
$page_vars = make_page($total_files, $users_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query($reports_query . " LIMIT ".$database->database_real_escape_string($page_vars[0]).", ".$users_per_page);
$total_friends1=$database->database_num_rows($query);
if($page_vars[2]> 1){?>
<div class='browse_pages'>
<? if($page_vars[1]!= 1){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=1"><span class="white arrow">&#171;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p-1?>" onclick="loadXMLDoc(<?=$p-1?>);"><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</span></font><? }?>
| <?
foreach($for as $foo){?>
<a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$foo?>"><?=$foo?></a>
<? }?> |
<? if($page_vars[1]!= $page_vars[2]){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p+1?>"><span class="white arrow">&#8250;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$page_vars[2]?>"><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</span></font><? }?>
<br /><span style="font-weight:normal;"><? if(($page_vars[0]+1)==($page_vars[0]+$total_friends1)){?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }else{?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }?></span><br />
<form method="get">Go to Page: <input type="text" name="p" id="p1" class="gotext" style="color:black;" /><input type="hidden" name="v" value="<?=$v?>" /><input type="submit" value="Go" /></form>
</div>
<? }
if($total_files==0)
{
echo "No suggestions found";
}
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="suggestion.php?id=<?php echo $row["id"];?>"><?php echo $row["suggestion"];?></a>
<?php echo html_entity_decode($row["moreinfo"]);?> <?php if($row["explanation"]!=""){?><br />
<br />
<strong>Admin note: </strong><?php echo $row["explanation"];}?><div class="clear clearfix"></div>
</div>
<div class="col-sm-2"><?php echo date("F j, Y g:i A",$row["date"]);?></div>
<div class="clear clearfix"></div>
</div>
<hr />
<?php
}
$total_users = $database->database_num_rows($database->database_query($reports_query));
// MAKE USER PAGES
$users_per_page = 20;
$p=$_GET["p"];
if($p<1){$p=1;}
//$query = $database->database_query("SELECT * FROM {$type}comments WHERE object_id='".$$focus."' ORDER BY id DESC");
if($p==""){$p=1;}
$total_files = $total_users;
$page_vars = make_page($total_files, $users_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{}
$query=$database->database_query($reports_query . " LIMIT ".$database->database_real_escape_string($page_vars[0]).", ".$users_per_page);
$total_friends1=$database->database_num_rows($query);
if($page_vars[2]> 1){?>
<div class='browse_pages'>
<? if($page_vars[1]!= 1){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=1"><span class="white arrow">&#171;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p-1?>" onclick="loadXMLDoc(<?=$p-1?>);"><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</span></font><? }?>
| <?
foreach($for as $foo){?>
<a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$foo?>"><?=$foo?></a>
<? }?> |
<? if($page_vars[1]!= $page_vars[2]){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p+1?>"><span class="white arrow">&#8250;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$page_vars[2]?>"><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</span></font><? }?>
<br /><span style="font-weight:normal;"><? if(($page_vars[0]+1)==($page_vars[0]+$total_friends1)){?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }else{?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }?></span><br />
<form method="get">Go to Page: <input type="text" name="p" id="p1" class="gotext" style="color:black;" /><input type="hidden" name="v" value="<?=$v?>" /><input type="submit" value="Go" /></form>
</div>
<? }
}?>
</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 admin=0 AND status=3 ".$category.$search_query." ORDER BY votes DESC";
$query=$database->database_query($reports_query);
$total_users = $database->database_num_rows($database->database_query($reports_query));
// MAKE USER PAGES
$users_per_page = 20;
$p=$_GET["p"];
if($p<1){$p=1;}
//$query = $database->database_query("SELECT * FROM {$type}comments WHERE object_id='".$$focus."' ORDER BY id DESC");
if($p==""){$p=1;}
$total_files = $total_users;
$page_vars = make_page($total_files, $users_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query($reports_query . " LIMIT ".$database->database_real_escape_string($page_vars[0]).", ".$users_per_page);
$total_friends1=$database->database_num_rows($query);
if($page_vars[2]> 1){?>
<div class='browse_pages'>
<? if($page_vars[1]!= 1){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=1"><span class="white arrow">&#171;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p-1?>" onclick="loadXMLDoc(<?=$p-1?>);"><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</span></font><? }?>
| <?
foreach($for as $foo){?>
<a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$foo?>"><?=$foo?></a>
<? }?> |
<? if($page_vars[1]!= $page_vars[2]){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p+1?>"><span class="white arrow">&#8250;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$page_vars[2]?>"><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</span></font><? }?>
<br /><span style="font-weight:normal;"><? if(($page_vars[0]+1)==($page_vars[0]+$total_friends1)){?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }else{?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }?></span><br />
<form method="get">Go to Page: <input type="text" name="p" id="p1" class="gotext" style="color:black;" /><input type="hidden" name="v" value="<?=$v?>" /><input type="submit" value="Go" /></form>
</div>
<? }
if($total_files==0)
{
echo "No suggestions found";
}
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="suggestion.php?id=<?php echo $row["id"];?>"><?php echo $row["suggestion"];?></a>
<?php echo html_entity_decode($row["moreinfo"]);?> <?php if($row["explanation"]!=""){?><br />
<br />
<strong>Admin note: </strong><?php echo $row["explanation"];}?><div class="clear clearfix"></div>
</div>
<div class="col-sm-2"><?php echo date("F j, Y g:i A",$row["date"]);?></div>
<div class="clear clearfix"></div>
</div>
<hr />
<?php
}
$total_users = $database->database_num_rows($database->database_query($reports_query));
// MAKE USER PAGES
$users_per_page = 20;
$p=$_GET["p"];
if($p<1){$p=1;}
//$query = $database->database_query("SELECT * FROM {$type}comments WHERE object_id='".$$focus."' ORDER BY id DESC");
if($p==""){$p=1;}
$total_files = $total_users;
$page_vars = make_page($total_files, $users_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{}
$query=$database->database_query($reports_query . " LIMIT ".$database->database_real_escape_string($page_vars[0]).", ".$users_per_page);
$total_friends1=$database->database_num_rows($query);
if($page_vars[2]> 1){?>
<div class='browse_pages'>
<? if($page_vars[1]!= 1){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=1"><span class="white arrow">&#171;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p-1?>" onclick="loadXMLDoc(<?=$p-1?>);"><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</span></font><? }?>
| <?
foreach($for as $foo){?>
<a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$foo?>"><?=$foo?></a>
<? }?> |
<? if($page_vars[1]!= $page_vars[2]){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p+1?>"><span class="white arrow">&#8250;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$page_vars[2]?>"><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</span></font><? }?>
<br /><span style="font-weight:normal;"><? if(($page_vars[0]+1)==($page_vars[0]+$total_friends1)){?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }else{?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }?></span><br />
<form method="get">Go to Page: <input type="text" name="p" id="p1" class="gotext" style="color:black;" /><input type="hidden" name="v" value="<?=$v?>" /><input type="submit" value="Go" /></form>
</div>
<? }
}?>
</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 admin=0 AND status=4 ".$category.$search_query." ORDER BY votes DESC";
$query=$database->database_query($reports_query);
$total_users = $database->database_num_rows($database->database_query($reports_query));
// MAKE USER PAGES
$users_per_page = 20;
$p=$_GET["p"];
if($p<1){$p=1;}
//$query = $database->database_query("SELECT * FROM {$type}comments WHERE object_id='".$$focus."' ORDER BY id DESC");
if($p==""){$p=1;}
$total_files = $total_users;
$page_vars = make_page($total_files, $users_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query($reports_query . " LIMIT ".$database->database_real_escape_string($page_vars[0]).", ".$users_per_page);
$total_friends1=$database->database_num_rows($query);
if($page_vars[2]> 1){?>
<div class='browse_pages'>
<? if($page_vars[1]!= 1){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=1"><span class="white arrow">&#171;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p-1?>" onclick="loadXMLDoc(<?=$p-1?>);"><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</span></font><? }?>
| <?
foreach($for as $foo){?>
<a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$foo?>"><?=$foo?></a>
<? }?> |
<? if($page_vars[1]!= $page_vars[2]){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p+1?>"><span class="white arrow">&#8250;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$page_vars[2]?>"><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</span></font><? }?>
<br /><span style="font-weight:normal;"><? if(($page_vars[0]+1)==($page_vars[0]+$total_friends1)){?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }else{?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }?></span><br />
<form method="get">Go to Page: <input type="text" name="p" id="p1" class="gotext" style="color:black;" /><input type="hidden" name="v" value="<?=$v?>" /><input type="submit" value="Go" /></form>
</div>
<? }
if($total_files==0)
{
echo "No suggestions found";
}
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="suggestion.php?id=<?php echo $row["id"];?>"><?php echo $row["suggestion"];?></a><br />
<?php echo html_entity_decode($row["moreinfo"]);?> <?php if($row["explanation"]!=""){?><br />
<br />
<strong>Admin note: </strong><?php echo $row["explanation"];}?><div class="clear clearfix"></div>
</div>
<div class="col-sm-2"><?php echo date("F j, Y g:i A",$row["date"]);?></div>
<div class="clear clearfix"></div>
</div>
<hr />
<?php
}
$total_users = $database->database_num_rows($database->database_query($reports_query));
// MAKE USER PAGES
$users_per_page = 20;
$p=$_GET["p"];
if($p<1){$p=1;}
//$query = $database->database_query("SELECT * FROM {$type}comments WHERE object_id='".$$focus."' ORDER BY id DESC");
if($p==""){$p=1;}
$total_files = $total_users;
$page_vars = make_page($total_files, $users_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{}
$query=$database->database_query($reports_query . " LIMIT ".$database->database_real_escape_string($page_vars[0]).", ".$users_per_page);
$total_friends1=$database->database_num_rows($query);
if($page_vars[2]> 1){?>
<div class='browse_pages'>
<? if($page_vars[1]!= 1){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?v=<?php echo $v;?>&p=1"><span class="white arrow">&#171;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?v=<?php echo $v;?>&p=<?=$p-1?>" onclick="loadXMLDoc(<?=$p-1?>);"><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</span></font><? }?>
| <?
foreach($for as $foo){?>
<a href="<?php echo $_SERVER["PHP_SELF"];?>?v=<?php echo $v;?>&p=<?=$foo?>"><?=$foo?></a>
<? }?> |
<? if($page_vars[1]!= $page_vars[2]){?><a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$p+1?>"><span class="white arrow">&#8250;</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?category=<?php echo $category;?>&search=<?php echo $search;?>&v=<?php echo $v;?>&p=<?=$page_vars[2]?>"><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</span></font><? }?>
<br /><span style="font-weight:normal;"><? if(($page_vars[0]+1)==($page_vars[0]+$total_friends1)){?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }else{?>
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
<? }?></span><br />
<form method="get">Go to Page: <input type="text" name="p" id="p1" class="gotext" /><input type="hidden" name="v" value="<?=$v?>" /><input type="submit" value="Go" /></form>
</div>
<? }
}?>
</div>
</div>
</div>
<? }
include "footer.php";
?>