📄 stats.php
字号:
<?php /* ------------------------- */
include("_include-config.php");
/* ------------------------- */ ?>
<html>
<head>
<title>[( Elite Avengers )]</title>
<link rel="stylesheet" type="text/css" href="css-v1.css">
</head>
<body>
<!------------------------------------------------------ Site Stats ------------------------------------------------------>
<TABLE cellSpacing=5 cellPadding=2 width="100%" border=0>
<TR>
<TD vAlign=top align=middle width="50%">
<TABLE borderColor=black cellSpacing=0 cellPadding=2
width="99%" border=1>
<TR>
<TD class=subTitle align=middle colSpan=2>Site Stats</TD></TR>
<TR>
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`='1'");
$member = mysql_num_rows($select);
$members = number_format($member,0);
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`='0'");
$member = mysql_num_rows($select);
$membersinactive = number_format($member,0);
?>
<TD class="mainTxt">Total Users:</TD>
<TD class="mainTxt"><b><? echo $members; ?> (<? echo $membersinactive; ?> not activated)</b></TD></TR>
<TR>
<?
$dbres = mysql_query("SELECT `cash` FROM `[users]` WHERE `level` > '0' AND `level` <= '50' AND `activated`='1' AND `health`>'0'");
$cash = 0;
while($user1 = mysql_fetch_object($dbres))
$cash += $user1->cash;
$cash1 = number_format($cash,0);
?>
<TD class="mainTxt">Total Cash:</TD>
<TD class="mainTxt"><b>$<? echo $cash1; ?></b></TD></TR>
<TR>
<?
$dbres = mysql_query("SELECT `bank` FROM `[users]` WHERE `level` > '0' AND `level` <= '50' AND `activated`='1' AND `health`>'0'");
$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]` WHERE `activated`='1' AND `level` > '0' AND `level` <= '50' AND `health`>'0'");
$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">Total Money:</TD>
<td width="50%" class="mainTxt"><b>$<? echo $total; ?></b> (<b>$<? echo $totalplayer; ?></b> per player)</td></TR>
<TR>
<?
$dbres = mysql_query("SELECT * FROM `[clans]` WHERE `level` = '1'");
$bank = 0;
$cash = 0;
$crews = mysql_num_rows($dbres);
while($crew = mysql_fetch_object($dbres)) {
$crewbank += $crew->bank;
$crewcash += $crew->cash;
}
$totalcrew = round($crewcash+$crewbank);
$totalcrewmoney = number_format($totalcrew,0);
$perC = $totalcrew/$crews;
$perCmoney = number_format($perC,0);
?>
<TD class="mainTxt">Crew Money:</TD>
<TD class="mainTxt"><b>$<? echo $totalcrewmoney; ?></b> (<b>$<? echo $perCmoney; ?></b> per crew)</TD>
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`='1'");
$members = mysql_num_rows($select);
$dbres = mysql_query("SELECT * FROM `[users]` WHERE `health`<='0' AND `activated`='1'");
$dead = mysql_num_rows($dbres);
$percdead = round($dead/$members*100);
$dbres = mysql_query("SELECT * FROM `[users]` WHERE `health`>'0' AND `activated`='1'");
$alive = mysql_num_rows($dbres);
$percalive = round($alive/$members*100);
$dbres = mysql_query("SELECT SUM(messages) AS `messages` FROM `[users]` WHERE `health`>'0'");
$messages = mysql_fetch_object($dbres);
$messages = number_format($messages->messages,0);
?>
<TR>
<TD class="mainTxt">Total Messages Sent:</TD>
<TD class="mainTxt"><b><? echo $messages; ?></b></TD>
</TR>
<TR>
<TD class="mainTxt">Users Dead:</TD>
<TD class="mainTxt"><b><? echo $dead; ?> (<? echo $percdead; ?>% of players)</b></TD>
</TR>
<TR>
<TD class="mainTxt">Users Alive:</TD>
<TD class="mainTxt"><b><? echo $alive; ?> (<? echo $percalive; ?>% of players)</b></TD>
</TR>
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE type=1 AND activated=1 AND `level` > '0' AND `level` <= '50'");
$admirals = mysql_num_rows($select);
$select = mysql_query("SELECT * FROM `[users]` WHERE type=2 AND activated=1 AND `level` > '0' AND `level` <= '50'");
$mafiabosses = mysql_num_rows($select);
$select = mysql_query("SELECT * FROM `[users]` WHERE type=3 AND activated=1 AND `level` > '0' AND `level` <= '50'");
$agents = mysql_num_rows($select);
?>
<tr>
<TD class="mainTxt">Admirals:</TD>
<TD class="mainTxt"><b><? echo $admirals; ?></b></TD></TR>
<tr>
<TD class="mainTxt">Mafia Bosses:</TD>
<TD class="mainTxt"><b><? echo $mafiabosses; ?></b></TD></TR>
<tr>
<TD class="mainTxt">Agents:</TD>
<TD class="mainTxt"><b><? echo $agents; ?></b></TD></TR>
</TABLE><br>
<!------------ END Site Stats ------------>
<!-------------------- Crews -------------------->
<TABLE class=sub2 borderColor=black cellSpacing=0 cellPadding=2
width="99%" border=1>
<TR>
<TD class=subTitle align=middle colSpan=4>Current Crews</TD></TR>
<TR>
<TD class=subTitle align=middle>Name</TD>
<TD class=subTitle align=middle>Boss</TD>
<TD class=subTitle align=middle>Members</TD>
<TD class=subTitle align=middle>Recruiting?</TD></TR>
<?
$select = mysql_query("SELECT * FROM `[clans]` ORDER BY started");
while($list = mysql_fetch_object($select)) {
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `clan`='$list->name'");
$nummembers = mysql_num_rows($dbres);
$recruiting = ($list->recruiting == 1) ? "Yes" : "No";
echo "
<tr><td class=mainTxt><b><a href='clan.php?x=$list->name'>$list->name</a></b></td>
<td class=mainTxt><a href='profile.php?x=$list->owner'>$list->owner</a></td>
<td class=mainTxt>$nummembers</td>
<td class=mainTxt>$recruiting</td></tr>";
}
?>
<TR>
<?
$dbres = mysql_query("SELECT `id` FROM `[clans]` WHERE `name`!='Elite Avengers'");
$totalcrewswadmin = mysql_num_rows($dbres);
?>
<TD align=right colSpan=4 class=mainTxt>Total Crews: <? echo $totalcrewswadmin; ?>/20</TD></TR></TABLE></TD>
<!------------ END Crews ------------>
<!--------------- Richest Players ----------->
<TD vAlign=top align=middle width="50%">
<TABLE class=sub2 borderColor=black cellSpacing=0 cellPadding=2
width="99%" border=1>
<TR>
<TD class=subTitle align=middle colSpan=3>Richest players</TD></TR>
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE activated=1 AND level<=50 ORDER BY round(cash+bank) DESC LIMIT 0,5");
while($list = mysql_fetch_object($select)) {
$money = round($list->cash+$list->bank);
if ($money <= 5000 AND $money >= 0) {
$mrank = "Straydog";
} elseif ($money > 5000 AND $money <= 50000) {
$mrank = "Lower Class";
} elseif ($money > 50000 AND $money <= 100000) {
$mrank = "Respectable Man";
} elseif ($money > 100000 AND $money <= 250000) {
$mrank = "Middle Class";
} elseif ($money > 250000 AND $money <= 500000) {
$mrank = "Wealthy";
} elseif ($money > 500000 AND $money <= 1000000) {
$mrank = "Upper Class";
} elseif ($money > 1000000 AND $money <= 2500000) {
$mrank = "Rich";
} elseif ($money > 2500000 AND $money <= 5000000) {
$mrank = "Very Rich";
} elseif ($money > 5000000 AND $money <= 10000000) {
$mrank = "Dangerously Rich";
} elseif ($money > 10000000) {
$mrank = "Notoriously Rich";
}
echo "<tr><td class=mainTxt><a href='profile.php?x=$list->login'>$list->login</a></td><td class=mainTxt><b>$mrank</b></td></tr>";
}
?>
</TABLE><br>
<!------------ END Richest Players ------------>
<!-------------------- Best Users -------------------->
<TABLE borderColor=black cellSpacing=0 cellPadding=2
width="99%" border=1> <TR>
<TD class=subTitle align=middle colSpan=2>Best users</TD></TR>
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE activated=1 AND level<=50 AND level>0 ORDER BY round((attack+defence)/2+clicks*5) DESC LIMIT 0,5");
while($list = mysql_fetch_object($select)) {
$totalpower = round(($list->attack+$list->defence)/2+$list->clicks*5);
if ($totalpower <= 1500 AND $totalpower >= 0) {
$rank = "Scum";
$rank = ($list->type == 1) ? "Private" : "$rank";
$rank = ($list->type == 3) ? "Constable" : "$rank";
} elseif ($totalpower > 1500 AND $totalpower <= 3000) {
$rank = "Pee Wee";
$rank = ($list->type == 1) ? "Private First Class" : "$rank";
$rank = ($list->type == 3) ? "Senior Constable" : "$rank";
} elseif ($totalpower > 3000 AND $totalpower <= 7000) {
$rank = "Thug";
$rank = ($list->type == 1) ? "Specialist" : "$rank";
$rank = ($list->type == 3) ? "Incremental Senior Constable" : "$rank";
} elseif ($totalpower > 7000 AND $totalpower <= 15000) {
$rank = "Gangster";
$rank = ($list->type == 1) ? "Corporal" : "$rank";
$rank = ($list->type == 3) ? "Sergeant" : "$rank";
} elseif ($totalpower > 15000 AND $totalpower <= 23000) {
$rank = "Hitman";
$rank = ($list->type == 1) ? "Sergeant" : "$rank";
$rank = ($list->type == 3) ? "Incremental Sergeant" : "$rank";
} elseif ($totalpower > 23000 AND $totalpower <= 30000) {
$rank = "Assassin";
$rank = ($list->type == 1) ? "Staff Sergeant" : "$rank";
$rank = ($list->type == 3) ? "Inspector" : "$rank";
} elseif ($totalpower > 30000 AND $totalpower <= 45000) {
$rank = "Boss";
$rank = ($list->type == 1) ? "Sergeant First Class" : "$rank";
$rank = ($list->type == 3) ? "Chief Inspector" : "$rank";
} elseif ($totalpower > 45000 AND $totalpower <= 60000) {
$rank = "Godfather";
$rank = ($list->type == 1) ? "Master Sergeant" : "$rank";
$rank = ($list->type == 3) ? "Superintendent" : "$rank";
} elseif ($totalpower > 60000 AND $totalpower <= 100000) {
$rank = "Legendary Godfather";
$rank = ($list->type == 1) ? "First Sergeant" : "$rank";
$rank = ($list->type == 3) ? "Chief Superintendent" : "$rank";
} elseif ($totalpower > 100000 AND $totalpower <= 150000) {
$rank = "Don";
$rank = ($list->type == 1) ? "Sergeant Major" : "$rank";
$rank = ($list->type == 3) ? "Assistant Commissioner" : "$rank";
} elseif ($totalpower > 150000 AND $totalpower <= 250000) {
$rank = "Respectable Don";
$rank = ($list->type == 1) ? "Command Sergeant Major" : "$rank";
$rank = ($list->type == 3) ? "Deputy Commissioner" : "$rank";
} elseif ($totalpower > 250000) {
$rank = "Legendary Don";
$rank = ($list->type == 1) ? "Sergeant Major Of The Army" : "$rank";
$rank = ($list->type == 3) ? "Commissioner Of Police" : "$rank";
} else {
$rank = "Error!";
}
echo "<tr><td class=mainTxt><a href='profile.php?x=$list->login'>$list->login</a></td><td class=mainTxt><b>$rank</b></td></tr>";
}
?>
</TABLE><br>
<!------------ END Best Users ------------>
<!---------------- Last 10 Signups -------------->
<TABLE class=sub2 borderColor=black cellSpacing=0 cellPadding=2
width="99%" border=1>
<TR>
<TD class=subTitle align=middle colSpan=3>Last 10 signups</TD></TR>
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`=1 AND `health`>0 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>
<!------------ END LAst 10 signups ------------>
<!-------------------- Most Clicks -------------------->
<TABLE class=sub2 borderColor=black cellSpacing=0 cellPadding=2
width="99%" border=1>
<TR>
<TD class=subTitle align=middle colSpan=3>Most clicks</TD></TR>
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`=1 AND `level` > 0 AND `level`<=50 AND `health`>0 ORDER BY clicks DESC LIMIT 0,5");
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->clicks</TD></TR>";
}
?>
</TABLE><BR>
<!------------ END Most Clicks ------------>
<!----------------- Most Refferals --------------->
<TABLE class=sub2 borderColor=black cellSpacing=0 cellPadding=2
width="99%" border=1>
<TR>
<TD class=subTitle align=middle colSpan=3>Most refferals</TD></TR>
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE `activated`=1 AND `level` > 0 AND `level`<=50 AND `health`>0 ORDER BY recruiters DESC LIMIT 0,5");
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->recruiters</TD></TR>";
}
?>
</TABLE><BR>
</td></tr>
<TD vAlign=top align=middle width="50%"> <TABLE borderColor=black cellSpacing=0 cellPadding=2 width="99%" border=1>
</TABLE></td></tr>
</table>
<table width="100%" align="center">
<tr><td class="subTitle"><b>〤opyright Elite Avengers 2005-2006 All rights reserved</b></td></tr>
</table>
</body>
</html>
<? mysql_close(); ?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -