diff options
| author | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-02-01 17:35:21 +0100 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-02-01 17:38:58 +0100 |
| commit | 333ce080274bcc1a93c2ce12340ae5abfe9e5c0d (patch) | |
| tree | 293f3f724daea5c52d7a6ba6612d26cf726cd0fc | |
| parent | 1e9d539acfb609dd7a6f085295f0d068d69cb077 (diff) | |
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>
| -rw-r--r-- | web/lib/acctfuncs.inc.php | 2 |
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(); |