klein Vraagje

KIngTomD · 3 Maart 2010

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 · 3 Maart 2010

Ja hoor

voorbeeld

PHP

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

Thisguyisgone · 3 Maart 2010

En nu de goede versie :p

PHP

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

tcbhome · 3 Maart 2010

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 · 3 Maart 2010

Jah, moet ook zo voor Criminolz

tcbhome · 3 Maart 2010

Citaat van Ferhatje

Jah, moet ook zo voor Criminolz

owja had het niet gezien :p

KIngTomD · 4 Maart 2010

Dankje

in welke map moet ik die droppen zodat die werkt?

Thisguyisgone · 4 Maart 2010

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

KIngTomD · 5 Maart 2010

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 · 5 Maart 2010

Dit is geen Criminolz?

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Plesk installer

cpanel / whm themes

PHP Point of Sale

Probleem omtrent Tinymce

Kunnen jullie mij helpen met deze enquete

een eigen cloud sever

Probleem C++ en CL

193 Nieuwe domeinnamen April 2025

228 Nieuwe domeinnamen Maart 2025

285 Nieuwe domeinnamen Februari 2025

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

Delen