Untitled

<?php
	require_once('../../../Sources/GameDB.php');

	$query = "SELECT nms.name, lvl.level, wlt.amount, gang.gang, ban.steam banned, ban.expires expires
	FROM gw_playerdata nms
	INNER JOIN darkrp_levels lvl ON lvl.steam = nms.steam
	INNER JOIN darkrp_wallets wlt ON lvl.steam = wlt.steam
	LEFT JOIN gw_gang_members gang ON lvl.steam = gang.steam
	LEFT JOIN gw_bans ban ON lvl.steam = ban.steam
	WHERE nms.name != 'mercior' AND lvl.level <= 99 AND (DATEDIFF(expires, NOW()) < 14 OR expires IS NULL)
	GROUP BY nms.steam
	ORDER BY ((lvl.level*3)+(wlt.amount/1000000)) DESC
	LIMIT 120";

	$result = mysql_query($query);
?>

<!DOCTYPE html>
<html>
	<head>
		<?php include 'header.html'; ?>
	</head>
<body>

<div data-role="page" data-title="GangWars RP" data-theme="a">

	<div data-role="header">
		<a href="leaderboards.php" data-rel="back" data-icon="back" class="ui-btn-left" data-direction="reverse">Back</a>
		<h1>Top Players</h1>
	</div><!-- /header -->

<div data-role="content">
	<?php
		while ( $row = mysql_fetch_assoc($result) )
		{
			$name = htmlspecialchars($row['name']);
			$level = $row['level'];
			$gang = htmlspecialchars($row['gang']);
			$money = number_format($row['wlt.amount']);
			$score = round(($row['level']*3)+($row['amount']/1000000));

			echo "
			<div data-role='collapsible'>
				<h3>{$name}</h3>
				<strong>Level</strong> {$level}<br />
				<strong>Money</strong>: &#36;{$gang}<br />
				<strong>XP</strong>: {$money}<br />
				<strong>Points</strong>: {$score}<br />
			</div>";
		}
	?>
	</div><!-- /content -->
</div><!-- /page -->

</body>
</html>