Ledenlijst tellen

jemajeroen

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

R.Jipping

Voor een $i variable die de nummering dient te tellen gebruik ik altijd gewoon standaard

PHP

$i++;

Deze dient zoals normaal direct onder de while te worden aangegeven.

Wanneer je dat hebt gedaan zet je een echo op de juiste plek in de WHILE.

PHP

<?php echo $i ?>

jemajeroen

dat doet hij nu toch al ^o)

alleen hij telt niet door

FrankY

Maak van die {$i} op regel 154 eens {$j} ?

jemajeroen

hoezo j?

FrankY

Omdat hier:

PHP

for($j=$begin+1; $info = mysql_fetch_assoc($dbres); $j++)
{

$j word gebruikt

jemajeroen

ja bedankt het werkt

ICTscripters

Dé plek voor IT

Dé plek voor IT

Het Grote Vibe Code Topic

Ictscripters Chat

PWYL source gezocht

Help testers nodig voor android app Urgent

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Afspraken systeem met planbeperking

Developer Gezocht

Na 15 jaar terug van weggeweest: iCriminals.nl is terug (BETA)!

370 Nieuwe Domeinnamen April 2026

Snel een website nodig?

Sicarras.com - Moderne Mafia Text-Based RPG

Ledenlijst tellen

Participate now!

Datalek bij leverancier Canvas - Universiteit van Amsterdam

Data privacy in 2026: Hoe de naleving van GDPR verandert

Tech.eu - Europees Start-up, Financiering en Technologienieuws

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2