klein Vraagje

KIngTomD

ik weet zo niet hoe je admin uit Statistieken kan halen?

kan iemand me uitleggen hoe ik admins uit Statistieken krijg?

zodat geld enzo niet mee getelt in het spel word..

alvast bedankt!

tcbhome

Ja hoor

voorbeeld

PHP

$select = mysql_query("SELECT * FROM users WHERE admin='0' ORDER BY power DESC LIMIT 0,5");

Thisguyisgone

En nu de goede versie :p

PHP

$select = mysql_query("SELECT * FROM users WHERE admin='Nee' ORDER BY power DESC LIMIT 0,5");

tcbhome

Citaat van Ferhatje
En nu de goede versie :p
PHP
$select = mysql_query("SELECT * FROM users WHERE admin='Nee' ORDER BY power DESC LIMIT 0,5");

Is toch het zelfde van mij? Juist heb je de 0 in Nee gedaan :d :p

Thisguyisgone

Jah, moet ook zo voor Criminolz

tcbhome

Citaat van Ferhatje

Jah, moet ook zo voor Criminolz

owja had het niet gezien :p

KIngTomD

Dankje

in welke map moet ik die droppen zodat die werkt?

Thisguyisgone

Gewoon in je script top5.php
Dan zoek je de regels etc.
Post het anders is hier.

KIngTomD

dit is me stats.php

PHP

<?php
  include("config.php");
$dbres = mysql_query("SELECT *,UNIX_TIMESTAMP(`pc`) AS `pc`,UNIX_TIMESTAMP(`transport`) AS `transport`,UNIX_TIMESTAMP(`bc`) AS `bc`,UNIX_TIMESTAMP(`slaap`) AS `slaap`,UNIX_TIMESTAMP(`kc`) AS `kc`,UNIX_TIMESTAMP(`start`) AS `start`,UNIX_TIMESTAMP(`crime`) AS `crime`,UNIX_TIMESTAMP(`ac`) AS `ac` FROM `users` WHERE `login`='{$_SESSION['login']}'");  
$data    = mysql_fetch_object($dbres);
  if(! check_login()) {
    header("Location: login.php");
    exit;
  }
?>
<html>
<head>
<title>Vendetta</title>
<link rel="stylesheet" type="text/css" href="style.css">
<meta name="keywords" content="Vendetta,Crimegame,crimegame,vendetta">
<meta name="language" content="english">
<META name="description" lang="nl" content="Vendetta crimegame met pit.">
</head>
<?
$dbres = mysql_query("SELECT * FROM `users` WHERE `activated`='1'");
$gebruikers = mysql_num_rows($dbres);
$dbres = mysql_query("SELECT * FROM `users` WHERE `status`='levend' AND `activated`='1'");
$levend = mysql_num_rows($dbres);
$dbres = mysql_query("SELECT * FROM `users` WHERE `status`='dood' AND `activated`='1'");
$dood = mysql_num_rows($dbres);




$dbres = mysql_query("SELECT * FROM `users`");
while($blah = mysql_fetch_object($dbres)){
  $cash = $cash+$blah->zak;
  $bank = $bank+$blah->bank;
  $kogel = $kogel+$blah->kogels;
}
$bank = number_format($bank, 0, ',' , ',');
$cash = number_format($cash, 0, ',' , ',');
$kogel = number_format($kogel, 0, ',' , ',');
$dbres = mysql_query("SELECT * FROM `users` WHERE  UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300");
$online = mysql_num_rows($dbres);
$dbres = mysql_query("SELECT * FROM `stad` WHERE `stad`='Groningen'");
$Groningen = mysql_fetch_object($dbres);
$sGroningen = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `stad`='Groningen' AND `status`='levend'"));
$dbres = mysql_query("SELECT * FROM `stad` WHERE `stad`='Arnhem'");
$Arnhem = mysql_fetch_object($dbres);
$sArnhem = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `stad`='Arnhem' AND `status`='levend'"));
$dbres = mysql_query("SELECT * FROM `stad` WHERE `stad`='Rotterdam'");
$Rotterdam = mysql_fetch_object($dbres);
$sRotterdam = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `stad`='Rotterdam' AND `status`='levend'"));
$dbres = mysql_query("SELECT * FROM `stad` WHERE `stad`='Amsterdam'");
$amsterdam = mysql_fetch_object($dbres);
$samsterdam = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `stad`='Amsterdam' AND `status`='levend'"));
$dbres = mysql_query("SELECT * FROM `stad` WHERE `stad`='Amersfoort'");
$Amersfoort = mysql_fetch_object($dbres);
$sAmersfoort = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `stad`='Amersfoort' AND `status`='levend'"));
$dbres = mysql_query("SELECT * FROM `stad` WHERE `stad`='Den_Bosch'");
$den_bosch = mysql_fetch_object($dbres);
$sden_bosch = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `stad`='Den_Bosch' AND `status`='levend'"));
print <<<ENDHTML
<table width=100% align=center>
  <tr> 
    <td class="subTitle"><b>Statistieken</b></td>
  </tr>
  <tr><td>&nbsp;&nbsp;</td></tr>
  <tr> 
    <td class="mainTxt">
  <table width=100%><tr><td align=center><b>Gebruikers</b><br><br>
<table border="0" width="39%">
	<tr>
		<td>Totaal aantal spelers</td>
		<td>$gebruikers</td>
	</tr>
	<tr>
		<td>Totaal aantal levende spelers</td>
		<td>$levend</td>
	</tr>
	<tr>
		<td>Totaal aantal dode spelers</td>
		<td>$dood</td>
	</tr>
	<tr>
		<td>Totaal aantal online spelers</td>
		<td>$online</td>
	</tr>
	<tr>
		<td>Totaal geld op zak</td>
		<td>&euro; $cash</td>
	</tr>
	<tr>
		<td>Totaal geld op de bank</td>
		<td>&euro; $bank</td>
	</tr>
	<tr>
		<td>Totaal aantal kogels</td>
		<td>$kogel</td>
	</tr>
	</td></tr></table></table>


<table align=center width=100%><tr><td><b><center>10 nieuwste spelers</center></b><br>
      <table align=center width=50%>
  <tr> 
        <td align=center> 
        <b>Login</b></td> 
 <td align=center> 
        <b>Datum</b></td> 
      </tr>
ENDHTML;
$query = mysql_query("SELECT login,id,start FROM `users` WHERE `status`='levend' ORDER BY `id` DESC LIMIT 0,10");
while($h = mysql_fetch_object($query)) {
echo "<tr> 
        <td  align=center><a href=user.php?x=$h->login>$h->login</a></td> 
<td  align=center>$h->start</td>
</tr> ";
}
echo "</td></tr></table></table>";
echo"
<table align=center width=100%><tr><td><b><center>10 Laatste doden</center></b><br>
      <table align=center width=50%>
  <tr> 
        <td align=center> 
        <b>Login</b></td> 
        <td align=center> 
        <b>Tijd</b></td> 
      </tr>
";
$query = mysql_query("SELECT *,DATE_FORMAT(`date`,'%d-%m %H:%i') AS `time` FROM `vermoord` ORDER BY `date` DESC LIMIT 0,10");
while($q = mysql_fetch_object($query)) {
echo "<tr> 
        <td  align=center><a href=user.php?x=$q->login>$q->login</a></td> 
        <td  align=center>$q->time</td> 
</tr> ";
}
echo "</td></tr></table></table>";


print <<<ENDHTML
<table align=center width=100%><tr><td><b><center>10 meest ge&euml;erde spelers</center></b><br>
      <table align=center width=50%>
  <tr> 
        <td align=center> 
        <b>Login</b></td> 
        <td align=center> 
        <b>Respect</b></td> 
      </tr>
ENDHTML;
$query = mysql_query("SELECT login,respect FROM `users` WHERE `status`='levend' ORDER BY `respect` DESC LIMIT 0,10");
while($q = mysql_fetch_object($query)) {
$respect = round($q->respect,0);
echo "<tr> 
        <td  align=center><a href=user.php?x=$q->login>$q->login</a></td> 
        <td  align=center>$respect</td> 
</tr> ";
}
echo "</td></tr></table></table>";
print <<<ENDHTML
<table align=center width=100%><tr><td><b><center>10 minst ge&euml;erde spelers</center></b><br>
      <table align=center width=50%>
  <tr> 
        <td align=center> 
        <b>Login</b></td> 
        <td align=center> 
        <b>Respect</b></td> 
      </tr>
ENDHTML;
$query = mysql_query("SELECT login,respect FROM `users` ORDER BY `respect` ASC LIMIT 0,10");
while($q = mysql_fetch_object($query)) {
$respect = round($q->respect,0);
echo "<tr> 
        <td  align=center><a href=user.php?x=$q->login>$q->login</a></td> 
        <td  align=center>$respect</td> 
</tr> ";
}
echo "</td></tr></table></table>";
print <<<ENDHTML
<table align=center width=100%><tr><td><b><center>10 spelers met de meeste refferals</center></b><br>
      <table align=center width=50%>
  <tr> 
        <td align=center> 
        <b>Login</b></td> 
        <td align=center> 
        <b>Refferals</b></td> 
      </tr>
ENDHTML;
$query = mysql_query("SELECT login,nrofref FROM `users` WHERE `status`='levend' ORDER BY `nrofref` DESC LIMIT 0,10");
while($b = mysql_fetch_object($query)) {
$ref = $b->nrofref;
echo "<tr> 
        <td  align=center><a href=user.php?x=$b->login>$b->login</a></td> 
        <td  align=center>$ref</td> 
</tr> ";
}
echo "</td></tr></table></table>";


print <<<ENDHTML
<table width=100%>  <tr><td><center><b>Steden</b><br><br><table width=100%>
<table border="0" width="39%">
	<tr>
		<td><b>Stad</b></td>
		<td><b>Drugs</b></td>
		<td><b>Drank</b></td>
		<td><b>Kogels</b></td>
		<td><b>Spelers</b></td>
	</tr>
	<tr>
		<td>Groningen</td>
		<td>$Groningen->drugs</td>
		<td>$Groningen->drank</td>
		<td>$Groningen->kogels</td>
		<td>$sGroningen</td>
	</tr>
	<tr>
		<td>Arnhem</td>
		<td>$Arnhem->drugs</td>
		<td>$Arnhem->drank</td>
		<td>$Arnhem->kogels</td>
		<td>$sArnhem</td>
	</tr>
	<tr>
		<td>Rotterdam</td>
		<td>$Rotterdam->drugs</td>
		<td>$Rotterdam->drank</td>
		<td>$Rotterdam->kogels</td>
		<td>$sRotterdam</td>
	</tr>
        <tr>
		<td>Amsterdam</td>
		<td>$amsterdam->drugs</td>
		<td>$amsterdam->drank</td>
		<td>$amsterdam->kogels</td>
		<td>$samsterdam</td>
	</tr>
        <tr>
		<td>Amersfoort</td>
		<td>$Amersfoort->drugs</td>
		<td>$Amersfoort->drank</td>
		<td>$Amersfoort->kogels</td>
		<td>$sAmersfoort</td>
	</tr>
  <tr>
		<td>Den Bosch</td>
		<td>$den_bosch->drugs</td>
		<td>$den_bosch->drank</td>
		<td>$den_bosch->kogels</td>
		<td>$sden_bosch</td>
	</tr>
	</table>
	<br><br>
</table>
<table align=center width=100%><tr><td><center><br><b>Nummer raden</b><br><br>
      <table align=center width=100%>
  <tr> 
        <td align=center> 
        <b>Stad</b></td> 
        <td align=center> 
        <b>Eigenaar</b></td> 
                <td align=center> 
        <b>Winst</b></td>
		<td align=center> 
        <b>Inzet</b></td>
      </tr>
ENDHTML;
$query = "SELECT * FROM casino WHERE `spel`='guess' ORDER BY `stad`"; 
$info = mysql_query($query) or die(mysql_error()); 
$count = 0; 
while ($gegeven = mysql_fetch_array($info)) { 
$winst = $gegeven["winst"]; 
$eigenaar = $gegeven["owner"]; 
$stad = $gegeven["stad"]; 
$inzet = $gegeven["inzet"]; 
$count++; 
if ($winst < 0) { $winst = "<font color=red><b>$winst</b></font>"; }
else { $winst = "<font color=009900><b>$winst</b></font>"; }
if (!$eigenaar) { $eigenaar = "<i>Te koop</i>"; }
else { $eigenaar = "<a href=user.php?x={$eigenaar}>$eigenaar</a>"; }
print <<<ENDHTML


<tr> 
        <td  align=center>$stad</td> 
        <td  align=center>$eigenaar</td> 
                <td align=center>&euro;{$winst}</td> 
				<td align=center>&euro;{$inzet}</td> 
ENDHTML;
}
print <<<ENDHTML
</td></tr></table><table align=center width=100%><tr><td><br><center><b>Blackjack</b><br><br>
      <table align=center width=100%>
  <tr> 
        <td align=center> 
        <b>Stad</b></td> 
        <td align=center> 
        <b>Eigenaar</b></td> 
                <td align=center> 
        <b>Winst</b></td>
		<td align=center> 
        <b>Inzet</b></td>
      </tr>
ENDHTML;
$query = "SELECT * FROM casino WHERE `spel`='blackjack' ORDER BY `stad`"; 
$info = mysql_query($query) or die(mysql_error()); 
$count = 0; 
while ($gegeven = mysql_fetch_array($info)) { 
$winst = $gegeven["winst"]; 
$eigenaar = $gegeven["owner"]; 
$stad = $gegeven["stad"];
$inzet = $gegeven["inzet"];  
$count++; 
if ($winst < 0) { $winst = "<font color=red><b>$winst</b></font>"; }
else { $winst = "<font color=009900><b>$winst</b></font>"; }
if (!$eigenaar) { $eigenaar = "<i>Te koop</i>"; }
else { $eigenaar = "<a href=user.php?x={$eigenaar}>$eigenaar</a>"; }
print <<<ENDHTML


<tr> 
        <td  align=center>$stad</td> 
        <td  align=center>$eigenaar</td> 
                <td align=center>&euro;{$winst}</td> 
				<td align=center>&euro;{$inzet}</td> 
				
ENDHTML;
}
print <<<ENDHTML
</td></tr></table><table align=center width=100%><tr><td><br><center><b>Fruitmachine</b><br><br>
      <table align=center width=100%>
  <tr> 
        <td align=center> 
        <b>Stad</b></td> 
        <td align=center> 
        <b>Eigenaar</b></td> 
                <td align=center> 
        <b>Winst</b></td>
		<td align=center> 
        <b>Inzet</b></td>
      </tr>
ENDHTML;
$query = "SELECT * FROM casino WHERE `spel`='fruitmachine' ORDER BY `stad`"; 
$info = mysql_query($query) or die(mysql_error()); 
$count = 0; 
while ($gegeven = mysql_fetch_array($info)) { 
$winst = $gegeven["winst"]; 
$eigenaar = $gegeven["owner"]; 
$stad = $gegeven["stad"]; 
$inzet = $gegeven["inzet"]; 
$count++; 
if ($winst < 0) { $winst = "<font color=red><b>$winst</b></font>"; }
else { $winst = "<font color=009900><b>$winst</b></font>"; }
if (!$eigenaar) { $eigenaar = "<i>Te koop</i>"; }
else { $eigenaar = "<a href=user.php?x={$eigenaar}>$eigenaar</a>"; }
print <<<ENDHTML


<tr> 
        <td  align=center>$stad</td> 
        <td  align=center>$eigenaar</td> 
                <td align=center>&euro;{$winst}</td> 
				<td align=center>&euro;{$inzet}</td> 
ENDHTML;
}


echo "</td></tr></table><table align=center width=100%><tr><td><br><center><b>Kogelfabrieken</b><br><br>
      <table align=center width=100%>
  <tr> 
        <td align=center> 
        <b>Stad</b></td> 
        <td align=center> 
        <b>Eigenaar</b></td> 
        <td align=center> 
        <b>Kogels</b></td>
		<td align=center> 
        <b>Prijs</b></td>
      </tr>";
$query = "SELECT winst,spel,owner,stad,inzet FROM casino WHERE `spel`='kogelfabriek' ORDER BY `stad`"; 
$info = mysql_query($query) or die(mysql_error()); 
$count = 0; 
while ($gegeven = mysql_fetch_array($info)) { 
$winst = $gegeven["winst"]; 
$prijs = $gegeven["inzet"]; 
$eigenaar = $gegeven["owner"]; 
$stad = $gegeven["stad"]; 
$count++; 
if (!$eigenaar) { $eigenaar = "<i>Te koop</i>"; }
else { $eigenaar = "<a href=user.php?x={$eigenaar}>$eigenaar</a>"; }
print <<<ENDHTML


<tr> 
        <td  align=center>$stad</td> 
        <td  align=center>$eigenaar</td> 
        <td align=center>$winst</td> 
		<td  align=center>&euro; $prijs</td> 
ENDHTML;
}
echo "</td></tr></table><table align=center width=100%><tr><td><br><center><b>Red Light Districten</b><br><br>
      <table align=center width=100%>
  <tr> 
        <td align=center> 
        <b>Stad</b></td> 
        <td align=center> 
        <b>Eigenaar</b></td> 
        <td align=center> 
        <b>Ramen</b></td>
		<td align=center> 
        <b>Prijs</b></td>
      </tr>";
$query = "SELECT winst,spel,owner,stad,inzet FROM casino WHERE `spel`='red_light_district' ORDER BY `stad`"; 
$info = mysql_query($query) or die(mysql_error()); 
$count = 0; 
while ($gegeven = mysql_fetch_array($info)) { 
$winst = $gegeven["winst"]; 
$prijs = $gegeven["inzet"]; 
$eigenaar = $gegeven["owner"]; 
$stad = $gegeven["stad"]; 
$count++; 
if (!$eigenaar) { $eigenaar = "<i>Te koop</i>"; }
else { $eigenaar = "<a href=user.php?x={$eigenaar}>$eigenaar</a>"; }
print <<<ENDHTML


<tr> 
        <td  align=center>$stad</td> 
        <td  align=center>$eigenaar</td> 
        <td align=center>$winst</td> 
		<td  align=center>&euro; $prijs</td> 
ENDHTML;
}
echo "</td></tr></table><table align=center width=100%><tr><td><br><center><b>Burgemeesters</b><br><br>
      <table align=center width=100%>
  <tr> 
        <td align=center> 
        <b>Stad</b></td> 
        <td align=center> 
        <b>Eigenaar</b></td> 
              </tr>";
$query = "SELECT * FROM stad ORDER BY `stad`"; 
$info = mysql_query($query) or die(mysql_error()); 
$count = 0; 
while ($gegeven = mysql_fetch_array($info)) { 
$eigenaar = $gegeven["mayor"]; 
$stad = $gegeven["stad"]; 
$count++; 
if (!$eigenaar) { $eigenaar = "<i>Geen</i>"; }
else { $eigenaar = "<a href=user.php?x={$eigenaar}>$eigenaar</a>"; }
print <<<ENDHTML


<tr> 
        <td  align=center>$stad</td> 
        <td  align=center>$eigenaar</td> 
        </tr>
ENDHTML;
}
echo "</td></tr></table>";
?>

Toon Meer

Mokerr

Dit is geen Criminolz?

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

klein Vraagje

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

Gebruikers die dit topic bekijken