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>";
?>

Meer tonen

Mokerr

Dit is geen Criminolz?

ICTscripters

Dé plek voor IT

Dé plek voor IT

[PROJECT] Gamekeuring.nl - Hét onafhankelijke keuringsplatform voor maffiagames & RPG's!

Ictscripters / Koen

🚀 WE ZOEKEN TESTERS! 🚀

Kweekrijk - van stekje tot Imperium

Crimora.nl

Programmeren geocht die samen met mij maffiaskrill.com

Gezocht mafiasnextkill

nieuwe game

Straatbaas.eu – complete Nederlandstalige en Engelstalige online maffia-RPG

402 Nieuwe Domeinnamen Augustus 2026

Ik verkoop maffiaskrill.com voor 30 eur0

klein Vraagje

Participate now!

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