<tr class="data-table-head">
				<td colspan="3">Player Locations</td>
			</tr>
			<tr class="bg1">
				<td>
					<div id="map" style="margin:10px auto;width: 430px; height: 290px;"></div>
				</td>
			</tr>
		</table>
	</div>
</div><br />

<?php 
flush();
$tblMembers = new Table(array(new TableColumn('lastName', 'Name', 'width=32&flag=1&link=' . urlencode('mode=playerinfo&amp;player=%k')), new TableColumn('skill', 'Points', 'width=6&align=right'), new TableColumn('activity', 'Activity', 'width=10&sort=no&type=bargraph'), new TableColumn('connection_time', 'Time', 'width=13&align=right&type=timestamp'), new TableColumn('kills', 'Kills', 'width=6&align=right'), new TableColumn('percent', 'Clan Kills', 'width=10&sort=no&type=bargraph'), new TableColumn('percent', '%', 'width=6&sort=no&align=right&append=' . urlencode('%')), new TableColumn('deaths', 'Deaths', 'width=6&align=right'), new TableColumn('kpd', 'Kpd', 'width=6&align=right')), 'playerId', 'skill', 'kpd', true, 20, 'members_page', 'members_sort', 'members_sortorder', 'members', 'desc', true);
$result = $db->query("\r\n\t\tSELECT\r\n\t\t\thlstats_Players.playerId,\r\n\t\t\thlstats_Players.lastName,\r\n\t\t\thlstats_Players.country,\r\n\t\t\thlstats_Players.flag,\r\n\t\t\thlstats_Players.skill,\r\n\t\t\thlstats_Players.connection_time,\r\n\t\t\thlstats_Players.kills,\r\n\t\t\thlstats_Players.deaths,\r\n\t\t\tROUND(hlstats_Players.kills / IF(hlstats_Players.deaths = 0, 1, hlstats_Players.deaths), 2) AS kpd,\r\n\t\t\tROUND(hlstats_Players.kills / IF(" . $clandata['kills'] . " = 0, 1, " . $clandata['kills'] . ") * 100, 2) AS percent,\r\n\t\t\tactivity\r\n\t\tFROM\r\n\t\t\thlstats_Players\r\n\t\tWHERE\r\n\t\t\thlstats_Players.clan={$clan}\r\n\t\t\tAND hlstats_Players.hideranking = 0\r\n\t\tGROUP BY\r\n\t\t\thlstats_Players.playerId\r\n\t\tORDER BY\r\n\t\t\t{$tblMembers->sort} {$tblMembers->sortorder},\r\n\t\t\t{$tblMembers->sort2} {$tblMembers->sortorder},\r\n\t\t\thlstats_Players.skill DESC\r\n\t\tLIMIT {$tblMembers->startitem},{$tblMembers->numperpage}\r\n\t");
$resultCount = $db->query("\r\n\t\tSELECT\r\n\t\t\tCOUNT(*)\r\n\t\tFROM\r\n\t\t\thlstats_Players\r\n\t\tWHERE\r\n\t\t\thlstats_Players.clan={$clan}\r\n\t\t\tAND hlstats_Players.hideranking = 0\r\n\t");
list($numitems) = $db->fetch_row($resultCount);
?>

<div style="clear:both;padding-top:20px;"></div>
<?php 
printSectionTitle('Members');
$tblMembers->draw($result, $numitems, 95);
?>
<br /><br />
<?php 
if ($g_options['show_google_map'] == 1) {
    include INCLUDE_PATH . '/google_maps.php';
    printMap('clan');
}
if ($_SESSION['nojs'] == 1) {
    echo 'You are currently viewing the basic version of this page, please enable JavaScript and reload the page to access full functionality.<br />';
}
echo 'Generated in real-time by <a href="http://www.hlxce.com" target="_blank">HLstatsX Community Edition ' . $g_options['version'] . '</a>';
if ($g_options['showqueries'] == 1) {
    echo '
			<br />
			Executed ' . $db->querycount . " queries, generated this page in {$scripttime} Seconds\n";
}
?>
<br />
All images are copyrighted by their respective owners.

<?php 
echo '<br /><br />[<a href="' . $g_options['scripturl'] . "?mode=admin\">Admin</a>]";
if (isset($_SESSION['loggedin'])) {
    echo '&nbsp;[<a href="hlstats.php?logout=1">Logout</a>]';
}
?>
</div>
</div>
<?php 
global $mode, $redirect_to_game;
if ($g_options["show_google_map"] == 1 && $mode == "contents" && $redirect_to_game > 0) {
    include INCLUDE_PATH . '/google_maps.php';
    printMap();
}
?>
</body>
</html>
Exemple #3
0
<?php

require_once '../inc/boinc_db.inc';
require_once '../inc/util.inc';
require_once '../inc/translation.inc';
require_once '../project/project_specific_prefs.inc';
db_init();
$title = "Triggers for the Past Day, Week, and Month";
page_head(tra($title), null, $title, "", true, null, true);
echo "<h2>" . $title . "</h2><BR>";
echo "<table>";
printMap("D");
printMap("W");
printMap("M");
echo "</table>";
page_tail();
function printMap($timeint)
{
    $minmag = MIN_MAGNITUDE;
    switch ($timeint) {
        case "D":
            $interval = "Day";
            $mapfile = MAP_TRIGGER_D;
            $minmag = MIN_MAGNITUDE_D;
            break;
        case "W":
            $interval = "Week";
            $mapfile = MAP_TRIGGER_W;
            $minmag = MIN_MAGNITUDE_W;
            break;
        case "M":