diff options
author | BlueRaja <BlueRaja.admin@gmail.com> | 2013-01-24 04:27:22 -0600 |
---|---|---|
committer | BlueRaja <BlueRaja.admin@gmail.com> | 2013-01-24 04:27:22 -0600 |
commit | 15826a7bb675c5ab9c407d9667d97aaf96d075ca (patch) | |
tree | 99e21ff38cac7f46c576fa992d1d3f25e43de25e /pages | |
parent | 09d59e739812e353616359f4ef0f388ddefb1ae7 (diff) | |
download | pathery-15826a7bb675c5ab9c407d9667d97aaf96d075ca.tar.xz |
oh wtf, that code isn't even used anymore -_-
Diffstat (limited to 'pages')
-rw-r--r-- | pages/memberlist.php | 138 |
1 files changed, 0 insertions, 138 deletions
diff --git a/pages/memberlist.php b/pages/memberlist.php index cf5f3bd..99f81ca 100644 --- a/pages/memberlist.php +++ b/pages/memberlist.php @@ -59,142 +59,4 @@ $json = json_encode($data); htmlfooter();
-exit;
-
-$sql = "SELECT
- users.ID,
- users.displayName,
- users.totalMoves,
- (
- SELECT SUM(moves)
- FROM solutions
- INNER JOIN mapOfTheDay ON solutions.mapID = mapOfTheDay.mapID
- WHERE solutions.userID = users.ID
- AND mapOfTheDay.mapExpireTime BETWEEN DATE_SUB(NOW(), INTERVAL 7 DAY) AND NOW()
- ) AS totalMovesThisWeek,
- users.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 "
-<div class='wrapper'>
-<h2>Members wall</h2>
-
-<table class='score'>
- <tr>";
-
-//Echo Table Headers
-foreach ($cat as $name => $item) {
- $co = 'desc';
- if (isset($item['c'])) {
- if ($item['c'] == $c) {
- $name = "<i>$name</i>";
- if ($o == 'DESC') {
- $co = 'asc';
- }
- }
- echo "<th title='$item[title]'><a href='?c=$item[c]&o=$co'>$name</a></th>";
- } else {
- echo "<th>$name</th>";
- }
-}
-
-//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 "
-<tr style='background-color: $background; color:$nameColor;' >
- <td>$i</td>
- <td>
- <div class='grid_td' style='width:35px; height:35px; background:$wallColor url(images/marks/$wallEmblem);'>
- <div style='background-color:transparent;' class='grid_td_inner grid_td_rocks'>
- </div>
- </div>
- </td>
- <td><span title='UserID: $userID'><a href='achievements?id=$userID' style='color:$nameColor'>$display</a></span></td>
-
- <td>$mazeCount</td>
- <td>$moveCount</td>
- <td>$moveCountWeek</td>
- <td>$winCount</td>
- <td>$tieCount</td>
-
- <td>$joined</td>
- <td>$lastLogon</td>
-</tr>";
-}
-echo "
- </table>
- <br />
- <br />
- </td>
- </tr>
-</table>
-</div>
-
-<div id='copy' style='width:100%;clear: both'>
- Copyright © 2011-2012 pathery.com
-</div>
-";
-
-htmlFooter();
?>
|