summaryrefslogtreecommitdiffstats
path: root/web
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2014-02-01 17:35:21 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2014-02-01 17:38:58 +0100
commit333ce080274bcc1a93c2ce12340ae5abfe9e5c0d (patch)
tree293f3f724daea5c52d7a6ba6612d26cf726cd0fc /web
parent1e9d539acfb609dd7a6f085295f0d068d69cb077 (diff)
downloadaurweb-333ce080274bcc1a93c2ce12340ae5abfe9e5c0d.tar.xz
Sort last TU votes by vote and by user name
Instead of using a random secondary order, sort by the ID of the last vote first, then by user name. Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'web')
-rw-r--r--web/lib/acctfuncs.inc.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/web/lib/acctfuncs.inc.php b/web/lib/acctfuncs.inc.php
index b4081b5..aee56e2 100644
--- a/web/lib/acctfuncs.inc.php
+++ b/web/lib/acctfuncs.inc.php
@@ -1007,7 +1007,7 @@ function last_votes_list() {
$q .= "TU_VoteInfo, Users WHERE TU_VoteInfo.ID = TU_Votes.VoteID AND ";
$q .= "TU_VoteInfo.End < UNIX_TIMESTAMP() AND ";
$q .= "Users.ID = TU_Votes.UserID AND Users.AccountTypeID = 2 ";
- $q .= "GROUP BY UserID ORDER BY LastVote DESC";
+ $q .= "GROUP BY UserID ORDER BY LastVote DESC, UserName ASC";
$result = $dbh->query($q);
$details = array();