";
//echo $json;
//print_r($data);
htmlfooter();
exit;
$sql = "SELECT
users.ID,
users.displayName,
(SELECT SUM(moves) FROM solutions WHERE solutions.userID = users.ID AND solutions.dateModified < CURRENT_DATE) AS totalMoves,
(SELECT SUM(moves) FROM solutions
WHERE solutions.userID = users.ID AND
solutions.dateModified BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY) AND CURRENT_DATE) AS totalMovesThisWeek,
(SELECT COUNT(*) FROM solutions WHERE solutions.userID = users.ID AND solutions.dateModified < CURRENT_DATE) AS totalMazes,
users.totalWins,
users.totalTies,
IfNull(userData.wallColor, '#666666') as wallColor,
IfNull(userData.displayColor, '#cccccc'),
userData.wallEmblem,
users.datejoined as dateJoined,
users.dateLogin as dateLogin
FROM `users`
LEFT JOIN `userData` ON users.ID = userData.userID
GROUP BY users.ID
$order
";
$result = mysql_query($sql);
$cat['Rank'] = '';
$cat['Badge'] = '';
$cat['Name'] = '';
$cat['Mazes']['c'] = 'totalMazes';
$cat['Mazes']['title'] = 'Total Mazes Played';
$cat['Moves']['c'] = 'totalMoves';
$cat['Moves']['title'] = 'Total Moves Mazed';
$cat['Past Week']['c'] = 'totalMovesThisWeek';
$cat['Past Week']['title'] = 'Total Moves In Past 7 Days (Excluding Today)';
$cat['Wins']['c'] = 'totalWins';
$cat['Wins']['title'] = 'Total Wins (Champion)';
$cat['Ties']['c'] = 'totalTies';
$cat['Ties']['title'] = 'Total Ties';
$cat['Joined']['c'] = 'dateJoined';
$cat['Joined']['title'] = 'Pathery life begins';
$cat['Last Login']['c'] = 'dateLogin';
$cat['Last Login']['title'] = 'Last Pathery fix on';
echo "
Members wall
";
//Echo Table Headers
foreach ($cat as $name => $item) {
$co = 'desc';
if (isset($item['c'])) {
if ($item['c'] == $c) {
$name = "$name";
if ($o == 'DESC') {
$co = 'asc';
}
}
echo "| $name | ";
} else {
echo "$name | ";
}
}
//Echo Table Data
$i = 0;
while (list($userID, $display, $moveCount, $moveCountWeek, $mazeCount, $winCount, $tieCount, $wallColor, $nameColor, $wallEmblem, $joined, $lastLogon) = mysql_fetch_row($result)) {
//Prepare data
$i++;
$joined = Date("Y-m-d", strtotime($joined));
$lastLogon = Date("Y-m-d", strtotime($lastLogon));
if (!$moveCount)
$moveCount = 0;
if (!$moveCountWeek)
$moveCountWeek = 0;
if ($lastLogon == 0)
$lastLogon = "Never";
//Prepare background for this line
$background = '#262631';
if ($i % 2 == 1)
$background = '#20202a';
if ($_SESSION['userID'] == $userID)
$background = '#343c57';
echo "
| $i |
|
$display |
$mazeCount |
$moveCount |
$moveCountWeek |
$winCount |
$tieCount |
$joined |
$lastLogon |
";
}
echo "
Copyright © 2011-2012 pathery.com
";
htmlFooter();
?>