ik heb een scrip waar een bug inzit
als je 1+100 kogels koopt krijg je er 100 gratis
hier is het scrip
wil iemand voor mij de fouten eruit halen?
alvast bedankt
ik heb een scrip waar een bug inzit
als je 1+100 kogels koopt krijg je er 100 gratis
hier is het scrip
wil iemand voor mij de fouten eruit halen?
alvast bedankt
ik heb hier een vendetta scrip die ik voor me site gebruik maar er zit een bug in..
as je 1+100 kogels koop krijg je 101 koges voor 1 kogelprijs wie wilt deze fout hersellen>? alvast bedankt!
Code:
http://www.codedump.be/code/1373/
Admin edit K.Rens: gelieve de code niet terug hierin te zetten.
die werkt niet bij mij...
kan je hier wat mee? is klein stukje van stats.php
ik werk met 'level' in plaats van status admin
<?
$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> </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>€ $cash</td>
</tr>
<tr>
<td>Totaal geld op de bank</td>
<td>€ $bank</td>
</tr>
<tr>
<td>Totaal aantal kogels</td>
<td>$kogel</td>
</tr>
</td></tr></table></table>
Toon Meer
okee bedankt in welke .php heb je die geplaatst?
Hoe haal je een admin uit de statistieken zodat de admin's zijn geld niet daarin word weergeven en zo.
alvast bedankt! :piraat:
dit is me stats.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> </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>€ $cash</td>
</tr>
<tr>
<td>Totaal geld op de bank</td>
<td>€ $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ë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ë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>€{$winst}</td>
<td align=center>€{$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>€{$winst}</td>
<td align=center>€{$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>€{$winst}</td>
<td align=center>€{$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>€ $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>€ $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
Dankje
in welke map moet ik die droppen zodat die werkt?
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!