From 1399d45c68e7d14fc1f3e8f2b5451669cce4ffa4 Mon Sep 17 00:00:00 2001 From: Patrick Davison Date: Thu, 29 Nov 2012 15:00:11 -0800 Subject: Lots of fixes and changes. nofollow on login links. tutorial fix changed how $accepted works changed how $wallColor/Emblem works fixed a bug when multiple players scored at the same momment. --- do.php | 2 +- includes/datas.php | 6 +++--- includes/header.php | 22 +++------------------- index.php | 24 +++++++++++++++++++++--- js/mapspecs.js | 6 ++---- pages/home.php | 26 ++++++-------------------- pages/share.php | 8 +++++++- pages/tutorial.php | 2 +- 8 files changed, 44 insertions(+), 52 deletions(-) diff --git a/do.php b/do.php index b58b1d2..329af35 100644 --- a/do.php +++ b/do.php @@ -188,7 +188,7 @@ if ($_GET['r'] == 'getpath') { WHERE `mapID` = '$mapID' AND `userID` = users.ID - ORDER BY `moves` DESC, `dateModified` ASC + ORDER BY `moves` DESC, `dateModified` ASC, solutions.ID DESC LIMIT 1"; $result = mysql_query($sql); if (mysql_num_rows($result) > 0) { diff --git a/includes/datas.php b/includes/datas.php index fa8bfb0..f1f4377 100644 --- a/includes/datas.php +++ b/includes/datas.php @@ -5,7 +5,7 @@ include_once('db.inc.php'); //FirePHP stuff - TODO: Delete -require_once('includes/FirePHPCore/FirePHP.class.php'); +//require_once('includes/FirePHPCore/FirePHP.class.php'); //FirePHP stuff - TODO: Delete //Select Stats/Scores. @@ -719,7 +719,7 @@ function trackMOTDstats($mapType) { DATE_FORMAT(maps.dateCreated,'%Y-%m-%d') AND `mapType` = '$mapType' GROUP BY solutions.userID - ORDER BY Moves DESC, MAX(dateModified) ASC + ORDER BY Moves DESC, MAX(dateModified) ASC, solutions.ID DESC "; $mainResult = mysql_query($sql); @@ -804,7 +804,7 @@ function getScores($mapid, $pageNumber = 1, $pageDivide = 10) { LEFT JOIN `userData` ON users.ID = userData.userID WHERE solutions.mapID = '$mapid' - ORDER BY solutions.moves DESC, solutions.dateModified ASC + ORDER BY solutions.moves DESC, solutions.dateModified ASC, solutions.ID DESC "; $result = mysql_query($sql); //$utime = date("g:i A (T)"); diff --git a/includes/header.php b/includes/header.php index 74a773a..c415e75 100644 --- a/includes/header.php +++ b/includes/header.php @@ -1,20 +1,4 @@ @@ -37,7 +21,7 @@ function htmlHeader($css = array(), $title = 'Pathery', $desc = '', $scripts = a echo ""; ?> - +