Hallo ik heb hier een script voor het xw source...
maar nu telt hij niet goed iedereen staat 2de volgens het script.
dit is heel het script:
wat is dr fout?
PHP
<?
error_reporting(E_ALL ^ E_NOTICE); // Set error level while parsing php without notice error
?>
<?php /* ------------------------- */
include("include/head2.php");
include("ban2.php");
mysql_query("UPDATE `[users]` SET `online`=NOW(),`page`='Leden Lijst' WHERE `login`='{$data['login']}'");
// DEBUG CODE:
// echo $_SESSION["login"];
// s = kolomnaam
// q = zoekterm
/* ------------------------- */ ?>
<table align=center width=630>
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE `verbannen`=0");
$member = mysql_num_rows($select);
$members = number_format($member,0);
$start = 0;
$i = $start + 1; $data = mysql_fetch_array($select, MYSQL_ASSOC); $i++;
?>
<table align=center width=630>
<tr><td class=subTitle colspan=2><b>Zoeken</b></td></tr>
<tr>
<form action="list.php" method="get">
<td class=mainTxt colspan=2 align=center>Voorbeeld: <b><font color=yellow>a*</font></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!">
</form>
<h4>Totaal aantal gebruikers: <font color=red><? echo $members; ?></font></h4>
</table>
<?
echo "
<table align=center width=630>";
print <<<ENDHTML
<ol>
<tr>
<td class=subTitle>
<b>#</td>
<td class=subTitle>
<b><u>Naam:</b></u> <a onmouseover="return overlib('Klik hier om de lijst op <font color=red>Naam</font> te selecteren',WIDTH, 150);" onmouseout=nd(); href='list.php?s=login'><img src='images/icons/up.png' height=11 border=0></a></td>
<td class=subTitle>
<b><u>Rank:</b></u> <a onmouseover="return overlib('Klik hier om de lijst op <font color=red>Rank</font> te selecteren',WIDTH, 170);" onmouseout=nd(); href='list.php?s=rank'><img src='images/icons/up.png' height=11 border=0></a></td>
<td class=subTitle>
<b><u>Crew:</b></u> <a onmouseover="return overlib('Klik hier om de lijst op <font color=red>Crew</font> te selecteren',WIDTH, 150);" onmouseout=nd(); href='list.php?s=crew'><img src='images/icons/up.png' height=11 border=0></a></td>
<td class=subTitle>
<b><u>Kracht:</b></u> <a onmouseover="return overlib('Klik hier om de lijst op <font color=red>Kracht</font> te selecteren',WIDTH, 150);" onmouseout=nd(); href='list.php?s=kracht'><img src='images/icons/up.png' height=11 border=0></a></td>
<td class=subTitle>
<b><u>Eerpunten:</b></u> <a onmouseover="return overlib('Klik hier om de lijst op <font color=red>Eerpunten</font> te selecteren',WIDTH, 120);" onmouseout=nd(); href='list.php?s=eerpunten'><img src='images/icons/up.png' height=11 border=0></a></td>
<td class=subTitle>
<b> [X]</td>
</tr>
ENDHTML;
$begin = ($_GET['p'] >= 0) ? $_GET['p']*20 : 0;
if($_GET['s'] == "login")
$dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`login`) AS `signup`,`level`,`rank`,`graff`,`family`,`betaal`,`attack`,`clicks`,`defence`,`famleader`,`honourpoints`,`cash`,`bank` FROM `[users]` WHERE `verbannen`=0 ORDER BY `login` LIMIT $begin,20");
elseif($_GET['s'] == "rank")
$dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`login`) AS `signup`,`level`,`rank`,`graff`,`family`,`betaal`,`attack`,`clicks`,`defence`,`famleader`,`honourpoints`,`cash`,`bank` FROM `[users]` WHERE `verbannen`=0 ORDER BY `rank` DESC,`login` ASC LIMIT $begin,20");
elseif($_GET['s'] == "crew")
$dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`login`) AS `signup`,`level`,`rank`,`graff`,`family`,`betaal`,`attack`,`clicks`,`defence`,`famleader`,`honourpoints`,`cash`,`bank` FROM `[users]` WHERE `verbannen`=0 ORDER BY `family` DESC,`login` ASC LIMIT $begin,20");
elseif($_GET['s'] == "kracht")
$dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`login`) AS `signup`,`level`,`rank`,`graff`,`family`,`betaal`,`attack`,`clicks`,`defence`,`famleader`,`honourpoints`,`cash`,`bank` FROM `[users]` WHERE `verbannen`=0 ORDER BY (`attack`+`defence`)/1+`clicks`*5 DESC,`login` ASC LIMIT $begin,20");
elseif($_GET['s'] == "eerpunten")
$dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`login`) AS `signup`,`level`,`rank`,`graff`,`family`,`betaal`,`attack`,`clicks`,`defence`,`famleader`,`honourpoints`,`cash`,`bank` FROM `[users]` WHERE `verbannen`=0 ORDER BY `honourpoints` DESC,`login` ASC LIMIT $begin,20");
else if($_GET['s'] == "online" && $data['level'] & 0x80)
$dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`login`) AS `signup`,`level`,`rank`,`graff`,`family`,`betaal`,`attack`,`clicks`,`defence`,`famleader`,`showonline`,`honourpoints`,`cash`,`bank` FROM `[users]` WHERE `verbannen`=0 AND UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 ORDER BY `login` LIMIT $begin,20");
else if($_GET['s'] == "online")
$dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`login`) AS `signup`,`level`,`rank`,`graff`,`family`,`betaal`,`attack`,`clicks`,`defence`,`famleader`,`showonline`,`honourpoints`,`cash`,`bank` FROM `[users]` WHERE `verbannen`=0 AND UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 AND `showonline`=1 ORDER BY `login` LIMIT $begin,20") or die (mysql_error());
else if($_GET['s'] == "admin")
$dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`login`) AS `signup`,`level`,`rank`,`graff`,`family`,`betaal`,`attack`,`clicks`,`defence`,`famleader`,`honourpoints`,`cash`,`bank` FROM `[users]` WHERE `level` & 0x80 AND UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 ORDER BY `login` LIMIT $begin,20");
else if($_GET['s'] == "search")
{
$_GET['q'] = preg_replace('/\*/','%',$_GET['q']);
$dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`login`) AS `signup`,`level`,`rank`,`graff`,`family`,`betaal`,`attack`,`clicks`,`defence`,`famleader`,`honourpoints`,`cash`,`bank` FROM `[users]` WHERE `verbannen`=0 AND `login` LIKE '{$_GET['q']}' ORDER BY `login` LIMIT $begin,20");
}
else
$dbres = mysql_query("SELECT `login`,UNIX_TIMESTAMP(`login`) AS `signup`,`level`,`rank`,`graff`,`family`,`betaal`,`attack`,`clicks`,`defence`,`famleader`,`honourpoints`,`cash`,`bank` FROM `[users]` WHERE `verbannen`=0 ORDER BY `honourpoints` DESC,`login` ASC LIMIT $begin,20");
$user = $_SESSION['login'];
for($j=$begin+1; $info = mysql_fetch_assoc($dbres); $j++)
{
$login2 = ($info['showonline'] == 0 && $data['level'] == 255 && $_GET['s'] == "online") ? "{$info['login']} *" : $info['login'];
// ????
$login2 = ($info['level'] == 255) ? "<font color=#ff0000><b>$login2</b></font>" : $login2;
$login2 = ($info['level'] == 3) ? "<font color=orange><b>$login2</b></font>" : $login2;
$login2 = ($info['famleader'] == 1) ? "<font color=green><b>$login2</b></font>" : $login2;
$login2 = ($info['betaal'] == 255) ? "<font color=yellow><b>$login2</b></font>" : $login2;
$login2 = ($info['graff'] == 1) ? "<font color=#4499EE><b>$login2</b></font>" : $login2;
$rank = Array("","Empty-Suit","No-Respect","Picciotto","Winkeldief","Pickpocket","Associate","Soldaat","Mobster","Lokale Leider","Leider","Godfather","Opper Hoofd","Maffia Lord","CH-Beginner","CH-Junkie","CH-Soldaat","CH-Kapitein","CH-Gangster","CH-Maffia","CH-Godfather","CH-Lord");
$rank = $rank[$info['rank']];
$geld22 = round($info['bank']+$info['cash']);
if ($geld22 < 99999){
$rgeld = "Niet Rijk";
}
elseif ($geld22 > 100000 && $geld22 < 999999){
$rgeld = "+100.000";
}
elseif ($geld22 > 1000000 && $geld22 < 9999999){
$rgeld = "+1 Miljoen";
}
elseif ($geld22 > 10000000 && $geld22 < 99999999){
$rgeld = "+10 Miljoen";
}
elseif ($geld22 > 100000000 && $geld22 < 499999999){
$rgeld = "+100 Miljoen";
}
elseif ($geld22 > 500000000 && $geld22 < 999999999){
$rgeld = "+500 Miljoen";
}
elseif ($geld22 > 1000000000 && $geld22 < 999999999999999999){
$rgeld = "Miljardair";
}
$family = $info['family'];
$extrapower = $info['clicks']*5;
$eerpunten = $info['honourpoints'];
$total = round(($info['attack']+$info['defence'])/1)+$extrapower;
$total = number_format($total,0,",",".");
$begin = ($_GET['p'] >= 0) ? $_GET['p']*20 : 0;
print <<<ENDHTML
<td class=mainTxt>{$i}</td>
<td class=mainTxt><a href="profile.php?x={$info['login']}">{$login2}</a></td>
<td class=mainTxt width=170>{$rank} <font color=red>/</font> {$rgeld}</td>
<td class=mainTxt>
ENDHTML;
if($info['family'] == '') {
print <<<ENDHTML
<font color=red><b>Geen</b></font>
ENDHTML;
}
else {
print <<<ENDHTML
{$family}</td>
ENDHTML;
}
print <<<ENDHTML
</td>
<td class=mainTxt>{$total}</td>
<td class=mainTxt>{$eerpunten}</td>
<td class=mainTxt><a href="click.php?x={$info['login']}">[X]</a></li></td>
</tr>
ENDHTML;
}
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,20");
else if($_GET['s'] == "search")
{
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `verbannen`=0 AND `login` LIKE '{$_GET['q']}' ORDER BY `login`");
$_GET['q'] = preg_replace('/%/','*',$_GET['q']);
}
else
$dbres = mysql_query("SELECT id FROM `[users]` WHERE `activated`=1");
print "</table>\n\n<table width=630 align=center>\n <tr><td class=\"mainTxt\" align=\"center\">";
if(mysql_num_rows($dbres) <= 20)
print "< 1 ></td></tr></table>\n";
else
{
if($begin/20 == 0)
print "<< ";
else
print "<a href=\"list.php?s={$_GET['s']}&q={$_GET['q']}&p=". ($begin/20-1) ."\"><<</a> ";
for($i=0; $i<mysql_num_rows($dbres)/20; $i++)
{
print "<a href=\"list.php?s={$_GET['s']}&q={$_GET['q']}&p=$i\">". ($i+1) ."</a> ";
}
if($begin+20 >= mysql_num_rows($dbres))
print ">> ";
else
print "<a href=\"list.php?s={$_GET['s']}&q={$_GET['q']}&p=". ($begin/20+1) ."\">>></a>";
}
print <<<ENDHTML
</tr></td>
</table>
ENDHTML;
?>
</tr></td></table>
</body>
<?php
$login2 = $user;
// DEBUG CODE:
// echo $_SESSION["login"];
?>
<br />
<br />
<table align=center><table width=630>
<tr><td class=subTitle colspan=2><b>Legenda</b></td></tr>
<tr>
<td align="right" class=mainTxt><font color="#ff0000"><b>Admins:</b></font></td>
<td class=mainTxt>Dit zijn de makers van Crime-Hell.</td>
</tr>
<tr class="inhoud">
<td align="right" class=mainTxt><font color="orange"><b>Helpdesk Medewerkers:</b></font></td>
<td class=mainTxt>Deze mensen helpen je met alle vragen over Crime-Hell.</td>
</tr>
<tr class="inhoud">
<td align="right" class=mainTxt><font color="yellow"><b>Betaalde Leden:</b></font></td>
<td class=mainTxt>Deze mensen steunen Crime-Hell en hebben een Betaald Account.</td>
</tr>
<tr class="inhoud">
<td align="right" class=mainTxt><font color="#4499EE"><b>Grafisch Medewerker:</b></font></td>
<td class=mainTxt>Deze mensen zorgen voor de layout, plaatjes etc.</td>
</tr>
<tr class="inhoud">
<td align="right" class=mainTxt><font color="green"><b>Crew Eigenaar:</b></font></td>
<td class=mainTxt>Deze mensen zijn Eigenaar van een Crew</td>
</tr>
</table>
<br />
<br />
<br />
<br />
<br />
</html>
Toon Meer