<?php
$titel .= 'Ledenlijst';
?>
<?=cHeader();?>
<div class="contentGreyTitle"><h1>Ledenlijst</h1></div>
<div class="contentText">
<table cellpadding="5" cellspacing="0" width="100%">
<tr class="grey">
<td class="subTitle" style="border-bottom: 0;" width='15px'>#</td>
<td class="subTitle" style="border-bottom: 0;" width='150px'>Naam</td>
<td class="subTitle" style="border-bottom: 0;" width='150px'>Clan</td>
<td class="subTitle" style="border-bottom: 0;" width='100px'><a href="list.php?x=contant">Contant</a></td>
<td class="subTitle" style="border-bottom: 0;" width='100px'><a href="list.php?x=power">Power</a></td>
<td class="subTitle" style="border-bottom: 0;" width='100px'>Actie</td>
</tr>
</table>
<?php
// Aantal pagina's per pagina toegelaten
if(isset($_GET['x']) and $_GET['x'] == 'online'){ $res1 = mysql_query("SELECT COUNT(id) FROM `[users]` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 AND showonline=1");
}else{
$res1 = mysql_query("SELECT COUNT(id) FROM `[users]`"); } // vraag het AANTAL items op
$items_totaal = mysql_result($res1, 0); // het totaal aantal items
mysql_free_result($res1); // geef het resultaat vrij
$items_per_pagina = 30; // vrij te kiezen
$aantal_paginas = ceil($items_totaal / $items_per_pagina); // het aantal items per pagina
// de huidige pagina opvragen
$huidige_pagina = 0; // default
if(isset($_GET['a']) && is_numeric($_GET['a']) && $_GET['a'] > 0 && $_GET['a'] < $aantal_paginas) {
$huidige_pagina = $_GET['a'];
}
// items van de huidige pagina ophalen
$offset = $huidige_pagina * $items_per_pagina;
if(isset($_GET['x']) and $_GET['x'] == "contant")
{
$query = mysql_query("SELECT login, level, vipdagen, clan, attack, defence, cash, land, admin,rank, online, pimprecht, hulpadmin, pimpnaam, pimpkleur FROM `[users]` ORDER BY cash DESC, login ASC LIMIT ".$offset.","
.$items_per_pagina) or die("res2:". mysql_error());
}
if(isset($_GET['x']) and $_GET['x'] == "rank")
{
$query = mysql_query("SELECT login, level, vipdagen, clan, attack, defence, cash, land, admin,rank, online, pimprecht, hulpadmin, pimpnaam, pimpkleur FROM `[users]` ORDER BY rank DESC, login ASC LIMIT ".$offset.","
.$items_per_pagina) or die("res2:". mysql_error());
}
elseif(!isset($_GET['x']) or $_GET['x'] == "power")
{
$query = mysql_query("SELECT login, level, vipdagen, clan, attack, defence, cash, land, admin, rank , online, pimprecht, hulpadmin, pimpnaam, pimpkleur FROM `[users]` ORDER BY (attack + defence) DESC, login ASC LIMIT ".$offset.","
.$items_per_pagina);
}elseif($_GET['x'] == "online")
{
$query = mysql_query("SELECT login, level, vipdagen, clan, attack, defence, cash, land, admin, rank , online, pimprecht, hulpadmin, pimpnaam, pimpkleur FROM `[users]` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 AND showonline=1 ORDER BY (attack + defence) DESC, login ASC LIMIT ".$offset.","
.$items_per_pagina);
}
if(!isset($_GET['p']))
{
$aantal = 0;
}
else
{
$aantal = $_GET['p'] * 30;
}
while($info = mysql_fetch_assoc($query))
{
$extra = '';
$aantal++;
if($info['admin'] == 1)
{
$login2 = '<strong><font color="red">'.$info['login'].'</font></strong>';
$extra = '<img src="./images/game/admin.gif" border="0" alt="admin"> ';
}
elseif($info['hulpadmin'] == 1)
{
$login2 = '<strong><font color="green">'.$info['login'].'</font></strong>';
$extra = '<img src="./images/game/online.gif" border="0" alt="hulp-admin"> ';
}
elseif($info['vipdagen'] > 0)
{
$login2 = '<strong><font color="yellow">'.$info['login'].'</font></strong></a> <img src="./images/game/vip.gif" border="0" alt="Vip"> ';
}
else
{
$login2 = $info['login']."</a>";
}
$login3 = '';
$login3 = ($info['pimprecht'] == 1) ? "<font color=orange> [Ownage]</font>" : $login3;
$login3 = ($info['pimprecht'] == 2) ? "<font color=green> [Pwnzor]</font>" : $login3;
$login3 = ($info['pimprecht'] == 3) ? "<font color=black> [Bitch]</font>" : $login3;
$login3 = ($info['pimprecht'] == 4) ? "<font color=#3399ff> [Mafia]</font>": $login3;
$login3 = ($info['pimprecht'] == 5) ? "<font color=#ff0000> [Devil]</font>" : $login3;
$login3 = ($info['pimprecht'] == 6) ? "<font color=green> [Afwezig]</font>" : $login3;
$login3 = ($info['pimprecht'] == 8) ? "<font color=darkblue> [Lunchpauze]</font>" : $login3;
$login3 = ($info['pimprecht'] == 7) ? "<font color=darkpurple> [Bezet]</font>" : $login3;
$login3 = ($info['pimprecht'] == 9) ? "<font color=purple> [Tv]</font>" : $login3;
$login3 = ($info['pimprecht'] == 10) ? "<font color=gray> [Slaapt]</font>" : $login3;
$login3 = ($info['pimprecht'] == 12) ? "<font color=#8B0000> [Angel]</font>" : $login3;
$login3 = ($info['pimprecht'] == 13) ? "<font color=#D2691E> [Gangster]</font>" : $login3;
$login3 = ($info['pimprecht'] == 20) ? "<font color='".$info['pimpkleur']."'>".$info['pimpnaam']."</font>" : $login3;
if(empty($info['clan']))
{
$clan = '<strong>Geen</strong>';
}
else
{
$clan = '<a href="clan/clanprofiel.php?x='.$info['clan'].'">'.$info['clan'].'</a><img src="./images/game/clan.gif" border="0" alt="clan"> ';
}
?>
<table cellpadding="5" cellspacing="0" width="100%">
<tr class="grey">
<td align="center" class="mainTxt" style="padding:2px" width='15px'><?=$aantal;?></td>
<td class="mainTxt" width='150px'><a href="profile.php?x=<?=$info['login'];?>" width="200"><?=$login2;?></a> <?=$extra.$login3;?></td>
<td align="left" class="mainTxt" width='150px'><?=$clan;?></td>
<td align="left" class="mainTxt" width='100px'>€ <?=number_format(round($info['cash']));?></td>
<td align="left" class="mainTxt" width='100px'><?=number_format(round(($info['attack'] + $info['defence'])));?></td>
<?php
if(($data['type'] != 3 || ($data['type'] == 3 && $info['type'] != 3)) && ($info['clan'] != $data['clan'] || $info['clan'] == ""))
?>
<td align="left" class="mainTxt" width='100px'><a href="attack.php?x=<?=$info['login'];?>"><img src="images/icons/aanval.ico" alt="Aanvallen !" height="16" border=0></a></td>
</tr>
</table>
<?php
}
$dbres = mysql_query("SELECT id FROM `[users]`");
?>
<table cellpadding="5" cellspacing="0" width="100%">
<tr>
<td class="subTitle" colspan="6"><strong>Navigatie</strong></td>
</tr>
<tr>
<td class="mainTxt" colspan="6">Pagina <?=($huidige_pagina+1);?> van <?=$aantal_paginas;?> •
<?php
function querystring($nav_var) {
$qstring = "?"; // de querystring
if(sizeof($_GET) > 1 || !in_array($nav_var, array_keys($_GET))) {
// meer queryvariabelen te onthouden dan enkel $_GET[$nav_var]
foreach($_GET as $k => $v) {
if($k != $nav_var) {
$qstring .= $k."=".$v."&";
}
}
}
return $qstring;
}
$q = $_SERVER['PHP_SELF'].querystring("a");
for($i = 0; $i < $aantal_paginas; $i++) {
if($huidige_pagina == $i) {
// huidige pagina is niet klikbaar
echo "<strong>".($i+1)."</strong>";
} else {
// een andere pagina - gebruik hier $q
echo "<a href="index-v1.php?p=list&a=".$i."">".($i+1)."</a>";
}
// deel-streepje tussen alle items
if($i < $aantal_paginas - 1) {
echo " - ";
}
}
?>
</tr>
</table>
</div>
|
