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

Crimora.nl

RPG game gebouwd met AI

(Verkoop) Criminals

Het Grote Vibe Code Topic

Ictscripters Chat

Het oorspronkelijke Criminals Script

StraatBaas is back, maar hoe?!

PWYL source gezocht

306 Nieuwe Domeinnamen Juni 2026

4-letter domein: Togi.nl

359 Nieuwe Domeinnamen Mei 2026

Ledenlijst tellen

Participate now!

Quanscient ontvangt €10M om AI- en kwantum-native hardware engineering te bevorderen - Tech.eu

Datalek bij leverancier Canvas - Universiteit van Amsterdam

Data privacy in 2026: Hoe de naleving van GDPR verandert

Functioneel ontwerp

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

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

Gebruikers die dit topic bekijken