📄 statistieken.php
字号:
<?php /* ------------------------- */
include("_include-config.php");
/* ------------------------- */ ?>
<html>
<head>
<title>Worldcrime</title>
<link rel="stylesheet" type="text/css" href="css-v3.css">
</head>
<body>
<TABLE cellSpacing=5 cellPadding=2 width="100%" border=0 height="539">
<TR>
<TD vAlign=top align=middle width="53%">
<TABLE borderColor=black cellSpacing=0 cellPadding=2 width="99%" border=0>
<TR>
<td align=center background=topic.gif>Site Statistieken</TD>
<td align=center background=topic.gif></TD></TR>
<TR>
<?
$select = mysql_query("SELECT * FROM `[users]`");
$member = mysql_num_rows($select);
$members = number_format($member,0);
?>
<TD class="mainTxt">Totaal leden:</TD>
<TD class="mainTxt"><b><? echo $members; ?></b></TD></TR>
<TR>
<?
$dbres = mysql_query("SELECT `cash` FROM `[users]` WHERE `level` > '0' AND `level` < '256'");
$cash = 0;
while($user1 = mysql_fetch_object($dbres))
$cash += $user1->cash;
$cash1 = number_format($cash,0);
?>
<TD class="mainTxt">Totaal contant:</TD>
<TD class="mainTxt"><b>$<? echo $cash1; ?></b></TD></TR>
<TR>
<?
$dbres = mysql_query("SELECT `bank` FROM `[users]` WHERE `level` > '0' AND `level` < '256'");
$bank = 0;
while($user = mysql_fetch_object($dbres))
$bank += $user->bank;
$bank1 = number_format($bank,0);
?>
<TD class="mainTxt">Bank:</TD>
<TD class="mainTxt"><b>$<? echo $bank1; ?></b></TD></TR>
<TR>
<?
$select = mysql_query("SELECT * FROM `[users]`");
$members = mysql_num_rows($select);
$total1 = round($bank+$cash);
$total = number_format($total1,0);
$totalplayer = round($total1/$members);
$totalplayer = number_format($totalplayer,0);
?>
<TD class="mainTxt">Totaal geld:</TD>
<td width="50%" class="mainTxt"><b>$<? echo $total; ?></b> (<b>$<? echo $totalplayer; ?></b> per
speler)</td></TR>
<TR>
<?
$dbres = mysql_query("SELECT * FROM `[messages]`");
$messages = mysql_num_rows($dbres);
$messages = number_format($messages,0);
?>
<TD class="mainTxt">Totaal berichten verstuurd:</TD>
<TD class="mainTxt"><b><? echo $messages; ?></b></TD></TR>
<TR>
<?
$dbres = mysql_query("SELECT * FROM `[users]` WHERE `health` < '0'");
$dead = mysql_num_rows($dbres);
$percdead = round($dead/$members*100);
?>
<TD class="mainTxt">Vermoorde leden:</TD>
<TD class="mainTxt"><b><? echo $dead; ?> </b></TD></TR>
<TR>
<?
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `level`=0");
$membersban = mysql_num_rows($dbres);
?>
<TD class="mainTxt">Verbannen leden:</TD>
<TD class="mainTxt"><b><? echo $membersban; ?> </b></TD></TR>
<TR>
<?
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `level`=100");
$membersban = mysql_num_rows($dbres);
?>
<TD class="mainTxt">Administrator's:</TD>
<TD class="mainTxt"><b><? echo $membersban; ?> </b></TD></TR>
<TR>
<?
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `hulpadmin`=1");
$membersban = mysql_num_rows($dbres);
?>
<TD class="mainTxt">Hulp admins:</TD>
<TD class="mainTxt"><b><? echo $membersban; ?> </b></TD></TR>
<TR>
<?
$dbres = mysql_query("SELECT * FROM `[users]` WHERE `health` > '1'");
$alive = mysql_num_rows($dbres);
$percalive = round($alive/$members*100);
$alive2 = mysql_num_rows($select);
$alive4 = number_format($alive,0);
?>
<TD class="mainTxt">Levende leden:</TD>
<TD class="mainTxt"><b><? echo $alive4; ?> </b></TD></TR>
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE activated=1");
$admirals = mysql_num_rows($select);
?>
</TABLE>
<TABLE class=sub2 borderColor=gris cellSpacing=0 cellPadding=0 width="99%" border=0>
<TR><TD align=right colSpan=4 class=mainTxt> </TD></TR>
</TABLE>
<TD vAlign=top align=middle width="0%">
<TABLE class=sub2 borderColor=black cellSpacing=0 cellPadding=2 width="99%" border=0>
<TR>
<td align=center background=topic.gif>Rijkste spelers</TD>
<td align=center background=topic.gif></TD>
</TR>
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE activated=1 AND level<255 ORDER BY round(cash+bank) DESC LIMIT 0,10");
while($list = mysql_fetch_object($select)) {
$money = round($list->cash+$list->bank);
$money2 = number_format($money,0);
echo "<tr><td class=mainTxt><a href='profile.php?x=$list->login'>$list->login</a></td><td class=mainTxt><b>$ $money2</b></td></tr>";
}
?>
</TABLE><BR>
<TABLE class=sub2 borderColor=black cellSpacing=0 cellPadding=2
width="99%" border=0>
<TR>
<td align=center background=topic.gif>Nieuwste leden</TD>
<td align=center background=topic.gif></TD></TR>
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`=1 ORDER BY signup DESC LIMIT 0,10");
while($list = mysql_fetch_object($select)) {
echo "
<TR>
<TD class=mainTxt><A href='profile.php?x=$list->login'>$list->login</A></TD>
<TD class=mainTxt>$list->signup</TD></TR>";
}
?>
</TABLE><BR>
</td></tr>
<TR>
</body>
</html>
<? mysql_close(); ?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -