Memberlist

<table width=100%>
  <tr><td align="center">
	<form action="memberlist.php" method="get">
	Voorbeeld: "<b>a*</b>" zal een lijst geven van namen die beginnen met een A<br>
	<input type="hidden" name="s" value="search"><input type="text" name="q" value="<?php echo $_REQUEST['q']; ?>"> <input type="submit" value="Zoek!"><br>
	</form>
  </td></tr>
</table>
<table width=100%>
  <tr><td align="center" class="subTitle" style="letter-spacing: normal;" width=20><b>#</b></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center"><a href="memberlist.php?s=login"><b>Nickname</a></b></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center" width=150><a href="list.php?s=type"><b>Type</b></a></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center" width=150><a href="list.php?s=type"><b>E-mail</b></a></td>
<?php /* ------------------------- */


  $begin				= ($_GET['p'] >= 0) ? $_GET['p']*30 : 0;
  if($_GET['s'] == "login") {
       $dbres				= mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`type`,`email` FROM `users` ORDER BY `login` ASC LIMIT $begin,30");
}else
    $dbres				= mysql_query("SELECT `id`, UNIX_TIMESTAMP(`signup`) AS `signup`, `login`, `email`, UNIX_TIMESTAMP(`online`) AS `online`, `type`, `pass`, `ip`, FROM `users` WHERE `login` ORDER BY `id` ASC LIMIT $begin,30");


  for($j=$begin+1; $info = mysql_fetch_object($dbres); $j++) { #hierzo krijg ik een mysql error
    $login				= $info->login;


    $type				= Array("","Drugsdealer","Wetenschapper","Agent");
    $type				= $type[$info->type];
	$type				= $info->email;




    print <<<ENDHTML
  <tr><td align="center" class="mainTxt" width=20>$j</td>
	<td class="mainTxt"><a href="profile.php?x={$info->login}">$login</a></td>
	<td align="center" class="mainTxt" width=150>$type</td>
	<td align="center" class="mainTxt" width=150>$Email</td>
ENDHTML;


  }


  if($_GET['s'] == "online" && $data->level & 0x80)
    $dbres				= mysql_query("SELECT `id` FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300");
  else if($_GET['s'] == "online")
    $dbres				= mysql_query("SELECT `id` FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300");
  else if($_GET['s'] == "admin")
    $dbres				= mysql_query("SELECT `id` FROM `users` WHERE `level` & 0x80 AND UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 ORDER BY `login` LIMIT $begin,30");
  else if($_GET['s'] == "search") {
    $dbres				= mysql_query("SELECT `id` FROM `users` WHERE `login` LIKE '{$_GET['q']}' ORDER BY `login`");
    $_GET['q']				= preg_replace('/%/','*',$_GET['q']);
  }
  else
    $dbres				= mysql_query("SELECT id FROM `users`");
  print "</table>\n\n<table width=100%>\n  <tr><td class=\"mainTxt\" align=\"center\">";
  if(mysql_num_rows($dbres) <= 30)
    print "< 1 ></td></tr></table>\n";
  else {
    if($begin/30 == 0)
      print "<< ";
    else
      print "<a href=\"memberlist.php?s={$_GET['s']}&q={$_GET['q']}&p=". ($begin/30-1) ."\"><<</a> ";


    for($i=0; $i<mysql_num_rows($dbres)/30; $i++) {
      print "<a href=\"memberlist.php?s={$_GET['s']}&q={$_GET['q']}&p=$i\">". ($i+1) ."</a> ";
    }


    if($begin+30 >= mysql_num_rows($dbres))
      print ">> ";
    else
      print "<a href=\"memberlist.php?s={$_GET['s']}&q={$_GET['q']}&p=". ($begin/30+1) ."\">>></a>";
  }


  $dbres				= mysql_query("SELECT `id` FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300");
  $online				= mysql_num_rows($dbres);
  $dbres				= mysql_query("SELECT `id` FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300");
  $anonymous				= mysql_num_rows($dbres);
?>
</table>
<table width=100%>


  </tr>
</table>

<table width=100%>
  <tr><td align="center" class="subTitle" style="letter-spacing: normal;" width=20><b>#</b></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center"><b>Nickname</b></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center" width=150><b>Type</b></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center" width=100><b>E-Mail</b></td>
<?php /* ------------------------- */


	$result               = mysql_query("SELECT * FROM `users`");
	$data				= mysql_fetch_object($result);
	
	    $login				= $info->login;
    $type				= Array("","Drugsdealer","Wetenschapper","Agent");
    $type				= $type[$info->type];
	$email				= $info->email;


  while ($info = mysql_fetch_array($result)) {
  
if ($data) {
    print "
  <tr><td align=\"center\" class=\"content\" width=20>{$info->id}</td>
	<td class=\"content\"><a href=\"profile.php?x={$info->login}\">$login</a></td>
	<td align=\"center\" class=\"content\" width=150>{$type}</td>
	<td align=\"center\" class=\"content\" width=100>{$email}</td>
";
}
}


/* ------------------------- */ ?>
</table>


  </tr>