We welcome your suggestions. To see comments on each suggestion, click on the actual suggestion. If you want to vote, click on vote.
Category:
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");
}
?>
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){?>