818 lines
36 KiB
PHP
818 lines
36 KiB
PHP
|
|
<?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">«</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">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</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">›</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">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</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">«</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">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</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">›</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">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</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">«</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">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</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">›</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">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</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">«</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">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</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">›</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">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</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">«</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">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</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">›</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">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</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">«</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">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</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">›</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">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</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">«</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">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</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">›</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">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</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">«</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">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</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">›</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">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</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">«</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">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</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">›</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">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</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">«</span></a> <a href="<?php echo $_SERVER["PHP_SELF"];?>?v=<?php echo $v;?>&p=<?=$p-1?>" onclick="loadXMLDoc(<?=$p-1?>);"><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</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">›</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">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</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";
|
||
|
|
?>
|