diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-09-03 13:35:46 +0300 |
|---|---|---|
| committer | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-09-03 13:35:46 +0300 |
| commit | 0183c98bd8b21e15ada176431cdda32581cd119a (patch) | |
| tree | d8809c0ee8c8741a507317f38ff0a83730076a84 /backend/handlers | |
| parent | feat: update user logs (#55) (diff) | |
| download | lphub-0183c98bd8b21e15ada176431cdda32581cd119a.tar.gz lphub-0183c98bd8b21e15ada176431cdda32581cd119a.tar.bz2 lphub-0183c98bd8b21e15ada176431cdda32581cd119a.zip | |
fix: order mod logs by most recent (#55)
Former-commit-id: 661ee1f70cbc8e8705e9145de9cfdc48c97daf02
Diffstat (limited to 'backend/handlers')
| -rw-r--r-- | backend/handlers/logs.go | 3 |
1 files changed, 2 insertions, 1 deletions
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) { | |||
| 83 | } | 83 | } |
| 84 | response := LogsResponse{Logs: []LogsResponseDetails{}} | 84 | response := LogsResponse{Logs: []LogsResponseDetails{}} |
| 85 | sql := `SELECT u.user_name, l.user_id, l.type, l.description, l.date | 85 | sql := `SELECT u.user_name, l.user_id, l.type, l.description, l.date |
| 86 | FROM logs l INNER JOIN users u ON l.user_id = u.steam_id WHERE type != 'Score'` | 86 | FROM logs l INNER JOIN users u ON l.user_id = u.steam_id WHERE type != 'Score' |
| 87 | ORDER BY l.date DESC LIMIT 100;` | ||
| 87 | rows, err := database.DB.Query(sql) | 88 | rows, err := database.DB.Query(sql) |
| 88 | if err != nil { | 89 | if err != nil { |
| 89 | c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error())) | 90 | c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error())) |