dkforest

commit 3b7d9284d4b4a95d86177a14be0d977b54cb91ae
parent 0a1aeec11a296a900d9de797855120eac63fdb83
Author: n0tr1v <n0tr1v@protonmail.com>
Date:   Tue, 24 Jan 2023 18:47:30 -0800

fix order by

Diffstat:
M
pkg/web/handlers/handlers.go
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/pkg/web/handlers/handlers.go b/pkg/web/handlers/handlers.go
@@ -1148,7 +1148,7 @@ INNER JOIN users u ON u.id = t.user_id
 LEFT JOIN forum_messages m ON m.thread_id = t.id AND m.id = (SELECT max(id) FROM forum_messages WHERE thread_id = t.id)
 -- Join last message user
 INNER JOIN users lu ON lu.id = m.user_id
-where u.username = ? and t.is_club = 0 order by rank limit 100`, data.AuthorFilter).Scan(&data.ForumThreads).Error; err != nil {
+where u.username = ? and t.is_club = 0 order by id desc limit 100`, data.AuthorFilter).Scan(&data.ForumThreads).Error; err != nil {
 			logrus.Error(err)
 		}
 		return c.Render(http.StatusOK, "forum-search", data)