Hallo mede scripters,
Ik zit met een (groot) probleem.. In een source zat nog iFrame, dat heb ik eruit gehaald en ben nu bezig met op elke pagina het rechter en linker menu te includen. Alleen stuit ik op een probleem daarmee. Bijvoorbeeld bij de pagina Statistieken.
In bijlage 1 zie je zoals die hoort, maar als ik dan in het selectievakje naar bijvoorbeeld Beste spelers ga (type 2) dan krijg ik het gene in bijlage 2. Oftewel content en rechtermenu verdwijnt.
Helaas is dit het geval bij meerdere pagina's, en zou ik graag een oplossing voor willen.
Een deel van de pagina:
PHP
<?php
include("_ml.php");
$car = mysql_query("SELECT * FROM `cars` WHERE `xpnodig` < $data->xp ORDER BY rand() LIMIT 0,1");
$garage = mysql_fetch_object($car);
$jailtime = (time() + 60);
function speeltijd($ding)
{
$minutenhelp = floor(($ding / 60));
$uur = round(floor(($minutenhelp / 60)));
$minuten = round(((($minutenhelp / 60)) - floor(($minutenhelp / 60))) * 60);
$seconden = round(((($ding / 60) - floor(($ding / 60))) * 60));
return ''.$uur.' uur, '.$minuten.' min. & '.$seconden.' sec.';
}
$_GET['type'] = safe($_GET['type']);
if(!($_GET['type'] >= 1 && $_GET['type'] <= 29)){ $_GET['type'] = 1; }
?>
<body onload="javascript:correct_png();"><center>
<table width="100%" align="center">
<tr><td class="subTitle"><b>Statistieken</b></td></tr>
<tr><td class="mainTxt"><center><br />
<table width="80%" align="center">
<tr><td class="lightTxt"><center><b>Statistieken</b></center></td></tr>
<tr><td class="lightTxt2">
<br /><center><form action="statistieken.php">
<select onchange="form.submit();" name="type">
<option value="1">Algemeen</option>
<option value="2">Beste spelers (Power)</option>
<option value="3">Beste spelers (Rank)</option>
<option value="4">Meeste gangsters</option>
<option value="25">Meeste hoeren</option>
<option value="22">Objecten status</option>
<option value="5">Rijkste spelers</option>
<option value="1">--</option>
<option value="6">Meeste auto steel pogingen</option>
<option value="7">Meeste bank overval pogingen</option>
<option value="8">Meeste driveby pogingen</option>
<option value="9">Meeste misdaad pogingen</option>
<option value="10">Meeste moord pogingen</option>
<option value="23">Meeste race pogingen</option>
<option value="11">Meeste route 66 pogingen</option>
<option value="12">Meeste GM pogingen</option>
<option value="13">Meeste waardetransport pogingen</option>
<option value="16">Meeste werk pogingen</option>
<option value="14">Meeste aanvallen gewonnen</option>
<option value="15">Meeste aanvallen verloren</option>
<option value="21">Meeste speeltijd</option>
<option value="1">--</option>
<option value="17">Ronde Resultaten</option>
</select></form></center><br />
</td></tr>
</table>
<br>
<?php
if($_GET['type'] == 1){
$gebruikers = mysql_num_rows(mysql_query("SELECT * FROM `users`"));
$auto = mysql_num_rows(mysql_query("SELECT * FROM `garage`"));
$levend = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `status`='levend'"));
$dood = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `status`='dood'"));
$online = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300"));
$nieuw24uur = mysql_num_rows(mysql_query("SELECT `id` FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`start`) < 86400"));
$online24uur = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 86400"));
$verbannenleden = mysql_num_rows(mysql_query("SELECT * FROM `bans`"));
$admins = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `level`='255'"));
$administrators = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `level`='1000'"));
$berichten = number_format(mysql_num_rows(mysql_query("SELECT `id` FROM `messages`")), 0, '.' , '.');
$dbres = mysql_query("SELECT `zak`,`bank`,`kogels`,`bitches`,`zwitser`,`speeltijd` FROM `users`");
while($blah = mysql_fetch_object($dbres)){
$bank = $bank+$blah->bank;
$cash = $cash+$blah->zak;
$zwitser = $zwitser+$blah->zwitser;
$kogel = $kogel+$blah->kogels;
$bitches = $bitches+$blah->bitches;
$speeltime = $speeltime+$blah->speeltijd;
}
$bank = number_format($bank, 0, '.' , '.');
$cash = number_format($cash, 0, '.' , '.');
$zwitser = number_format($zwitser, 0, '.' , '.');
$kogel = number_format($kogel, 0, '.' , '.');
$bitches = number_format($bitches, 0, '.' , '.');
$speeltime = speeltijd($speeltime);
echo '<table width="90%" align="center">
<td class="lightTxt" colspan="2">Algemeen</td>
<tr><td class="lightTxt2" width="50%"><img src="images/icons3/user.png" height="16" width="16" border="0"> Totaal leden:</td><td class="lightTxt2" width="50%">'.$gebruikers.'</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/user-green.png" height="16" width="16" border="0"> Online leden:</td><td class="lightTxt2">'.$online.'</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/user-green.png" height="16" width="16" border="0"> Vandaag ingelogd:</td><td class="lightTxt2">'.$online24uur.'</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/user--plus.png" height="16" width="16" border="0"> Aanmeldingen in 24u:</td><td class="lightTxt2">'.$nieuw24uur.'</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/money-coin.png" height="16" width="16" border="0"> Totaal contant:</td><td class="lightTxt2">€'.$cash.',-</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/bank-coin.png" height="16" width="16" border="0"> Totaal bank:</td><td class="lightTxt2">€'.$bank.',-</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/building-coin.png" height="16" width="16" border="0"> Totaal zwitserse bank:</td><td class="lightTxt2">€'.$zwitser.',-</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/shield.png" height="16" width="16" border="0"> Totaal kogels:</td><td class="lightTxt2">'.$kogel.'</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/user-female.png" height="16" width="16" border="0"> Totaal hoeren:</td><td class="lightTxt2">'.$bitches.'</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/mail.png" height="16" width="16" border="0"> Totaal berichten:</td><td class="lightTxt2">'.$berichten.'</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/car.png" height="16" width="16" border="0"> Totaal auto\'s:</td><td class="lightTxt2">'.$auto.'</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/clock-frame.png" height="16" width="16" border="0"> Totale speeltijd:</td><td class="lightTxt2">'.$speeltime.'</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/user-thief-baldie.png" height="16" width="16" border="0"> Verbannen leden:</td><td class="lightTxt2">'.$verbannenleden.'</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/user-white.png" height="16" width="16" border="0"> Levende leden:</td><td class="lightTxt2">'.$levend.'</td></tr>
<tr><td class="lightTxt2"><img src="images/icons3/user-black.png" height="16" width="16" border="0"> Dode leden:</td><td class="lightTxt2">'.$dood.'</td></tr>
<td> </td>
</table>';
$_GET['stats'] = safe($_GET['stats']);
if($_GET['stats'] == '2'){ $stitel = 'Nieuwe leden'; $bestand = 'nieuw'; }
elseif($_GET['stats'] == '3'){ $stitel = 'Speeltijd leden'; $bestand = 'speeltijd'; }
else{ $stitel = 'Online leden'; $bestand = 'online'; }
?>
<table width="100%" align="center">
<tr><td class="lightTxt"><?= $stitel ?></td></tr>
<tr><td class="lightTxt2"><center><img src="../stats/<?php echo ''.$bestand.''; ?>.php" width="516" height="235" border="0"></center></tr>
<tr><td class="lightTxt2" align="center"><center><img src="images/icons/user.png" width="16" height="16" border="0"> <a href="?stats=1">Online leden</a> <img src="images/icons/user_add.png" width="16" height="16" border="0"> <a href="?stats=2">Nieuwe leden</a> <img src="images/icons/time.png" width="16" height="16" border="0"> <a href="?stats=3">Speeltijd leden</a></center></td></tr>
</table>
<?php
}
if($_GET['type'] == 2){
echo '<table width="90%" align="center">
<tr><td class="lightTxt" colspan="5"><b>Beste spelers (Power)</b></td></tr>';
$dbres = mysql_query("SELECT `id`,`aanval`,`verdediging`,`clicks` FROM `users` ORDER BY (`aanval`+`verdediging`)/2+`clicks`*5 DESC,`login` ASC LIMIT 0,10");
while($info = mysql_fetch_object($dbres))
{
$j++;
echo '<tr><td class="lightTxt2" width="20">'.$j.'.</td><td class="lightTxt2" width="20">'.usericon($info->id).'</td><td class="lightTxt2" width="45%">'.usernaam($info->id,1,1).'</td><td class="lightTxt2" width="20"><img src="images/icons3/lightning.png" height="16" width="16" border="0"></td><td class="lightTxt2" width="50%">'.number_format(round(($info->aanval+$info->verdediging)/2+$info->clicks*5),0,",",".").'</td></tr>';
}
echo '<tr><td class="lightTxt" colspan="5"> </td></tr></table>';
}