From 0183c98bd8b21e15ada176431cdda32581cd119a Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Sun, 3 Sep 2023 13:35:46 +0300
Subject: fix: order mod logs by most recent (#55)

Former-commit-id: 661ee1f70cbc8e8705e9145de9cfdc48c97daf02
---
 backend/handlers/logs.go | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'backend/handlers/logs.go')

diff --git a/backend/handlers/logs.go b/backend/handlers/logs.go
index b5704d6..8880607 100644
--- a/backend/handlers/logs.go
+++ b/backend/handlers/logs.go
@@ -83,7 +83,8 @@ func ModLogs(c *gin.Context) {
 	}
 	response := LogsResponse{Logs: []LogsResponseDetails{}}
 	sql := `SELECT u.user_name, l.user_id, l.type, l.description, l.date 
-	FROM logs l INNER JOIN users u ON l.user_id = u.steam_id WHERE type != 'Score'`
+	FROM logs l INNER JOIN users u ON l.user_id = u.steam_id WHERE type != 'Score'
+	ORDER BY l.date DESC LIMIT 100;`
 	rows, err := database.DB.Query(sql)
 	if err != nil {
 		c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
-- 
cgit v1.2.3