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

Beta-testers gezocht voor Crypto-oefenplatform

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

Developer Gezocht

Op zoek naar de legends

[FREE] WeFact Hosting module

Help testers nodig voor android app Urgent

Versio vervanger

Afspraken systeem met planbeperking

350 Nieuwe Domeinnamen Januari 2026

321 Nieuwe Domeinnamen December 2025

Meerdere mafia game template te koop

klein Vraagje

Participate now!

Fijne feestdagen

Kritieke update voor Really Simple Security-plug-in

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

Functioneel ontwerp

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

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