Help with view members page

[stelthius]

Hello guys,

 

I'm working on a member list page that has paginate built into it to sort members in a way you like, but my problem is i cannot get the page to pull the required information from the database, i login on my test account so the site has 1 user online but my members page doesnt show any result, any help is appretiated.

 

(Note <? & ?> is not causing my problems)

 

Members.php

<?

$thisPage='members';
$view = $_GET['view'];
$page = $_GET['page'];
include("include/session.php");
global $database;
function getPagerData($numHits, $limit, $page) 
{ 
$numHits = (int) $numHits; 
$limit = max((int) $limit, 1); 
$page = (int) $page; 
$numPages = ceil($numHits / $limit); 

$page = max($page, 1); 
$page = min($page, $numPages); 

$offset = ($page - 1) * $limit; 

$ret = new stdClass; 

$ret->offset = $offset; 
$ret->limit = $limit; 
$ret->numPages = $numPages; 
$ret->page = $page; 

return $ret; 
}

if ($view=='On'){
$total = $database->getNumActiveUsers();
// number of elements per page
$limit = 2; 
}
else
if ($view=='All'){
$total = $database->getNumMembers();
// number of elements per page
$limit = 2; 
}

// work out the pager values 
$pager = getPagerData($total, $limit, $page); 
$offset = $pager->offset; 
$limit = $pager->limit; 
$page = $pager->page;


// Query for Online members
if ($view=='On'){
$view = 'On';

if($database->getNumActiveUsers() == 0){
echo '<div class="middle">No members are currently online.<br /><a href="members.php?view=All&page=1">View All Instead</a></div>';
return;
}
else


if(!defined('TBL_ACTIVE_USERS')) {
die("Error processing page");
}

// here is were im joining the active users and user tables

$q = "SELECT active_users.*, users.avatar ".
"FROM active_users, users ".
"WHERE active_users.username = users.username ORDER BY timestamp
DESC LIMIT $offset, $limit";
$result = $database->query($q);

$num_rows = mysql_numrows($result);
if(!$result || ($num_rows < 0)){
echo '<div class="middle">Error displaying info</div>';
return;
}
else if($num_rows > 0){
echo '<div id="edituser">
<div class="tag2">Online Members<br /><a href="members.php?view=All&page=1">View All</a></div>';
}

}
else
if ($view=='All'){
$view = 'All';

if(!defined('TBL_USERS')) {
die("Error processing page");
}

$q = "SELECT username, avatar, timestamp FROM users ORDER BY timestamp
DESC LIMIT $offset, $limit";
$result = $database->query($q);
/* Error occurred, return given name by default */
$num_rows = mysql_numrows($result);
if(!$result || ($num_rows < 0)){
echo '<div class="middle">Error displaying info</div>';
return;
}
if($num_rows == 0){
echo '<div class="middle">No members to display.</div>';
return;
}
echo '<div id="edituser">
<div class="tag2">Members<br /><a href="members.php?view=On&page=1">View Online</a>
</div>';
}

echo '<div id="edit">
<span class="row">
<span class="label emph">User</span>
<span class="field emph">Last Active</span>
</span>';
for($i=0; $i<$num_rows; $i++){
$uname = mysql_result($result,$i,"username");
$uimg = mysql_result($result,$i,"avatar");
$time = mysql_result($result,$i,"timestamp");
$user = $session->username;

$today = getdate($time);
include("gettime.php");

echo '<span class="userrow">
<span class="user"><a href="userinfo.php?user='.$uname.'">';
/* Avatar */
if(!mysql_result($result,$i,"avatar")){
echo '<img title="no avatar uploaded" alt="no avatar uploaded" src="no_avatar.gif" />';
}
else{
$alt = '"'.$uname.'"';
echo "<img title=$alt alt=$alt ";
echo 'class="memavatar" src="userimg/'.$uimg.'" />';
}
echo '</a><span class="name">';
echo "<a href=\"userinfo.php?user=$uname\">$uname</a>";

if((mysql_result($result,$i,"username")) == $user){
echo "</span></span>";
}
else
if(!$session->logged_in){
echo " | <a title=\"Login to PM members\" name=\"Login2PM\">Send PM</a></span></span>";
}
else{
echo " | <a href=\"compose.php?user=$uname\">Send PM</a></span></span>";
}

echo "<span class=\"time\">$thedate<br />$thetime</span>
</span>";
}
echo '
</div>';
include("paginate.php");
echo '</div>';
?>

 

*Forgot to add a link http://62.31.203.205/test/members.php*

 

Many Thanks Rick.