From 15826a7bb675c5ab9c407d9667d97aaf96d075ca Mon Sep 17 00:00:00 2001 From: BlueRaja Date: Thu, 24 Jan 2013 04:27:22 -0600 Subject: oh wtf, that code isn't even used anymore -_- --- pages/memberlist.php | 138 --------------------------------------------------- 1 file changed, 138 deletions(-) (limited to 'pages') 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 " -
-

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 ""; - } else { - echo ""; - } -} - -//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 " - - - - - - - - - - - - - -"; -} -echo " -
$name$name
$i -
-
-
-
-
$display$mazeCount$moveCount$moveCountWeek$winCount$tieCount$joined$lastLogon
-
-
- - - -
- -
- Copyright © 2011-2012 pathery.com -
-"; - -htmlFooter(); ?> -- cgit v1.2.3