tRemove database queries from html.go - scoreboard - Interactive scoreboard for CTF-like games
  HTML git clone git://git.z3bra.org/scoreboard.git
   DIR Log
   DIR Files
   DIR Refs
       ---
   DIR commit 61269ee4372b67a9d212fc9227c2c46acbb58f39
   DIR parent dc2f40166091506f6da7f28f9c85c086f6b225a5
  HTML Author: Willy Goiffon <contact@z3bra.org>
       Date:   Mon, 30 Sep 2024 15:03:58 +0200
       
       Remove database queries from html.go
       
       Diffstat:
         M html.go                             |      20 ++++----------------
       
       1 file changed, 4 insertions(+), 16 deletions(-)
       ---
   DIR diff --git a/html.go b/html.go
       t@@ -23,27 +23,15 @@ type Template struct {
        
        func (p *Player) BadgeHTML() string {
                var badges strings.Builder
       +        var flags []Flag
        
       -        query := `SELECT
       -          flag.badge
       -          FROM flag
       -          INNER JOIN score ON score.flag = flag.value
       -          WHERE score.name = ?;`
       -
       -        rows, err := p.db.Query(query, p.name)
       +        flags, err := db_get_user_flags(p.db, p.name)
                if err != nil {
                        return ""
                }
        
       -        var n int = 0
       -        for rows.Next() {
       -                var b string
       -                err := rows.Scan(&b)
       -                if err != nil {
       -                        return ""
       -                }
       -                badges.WriteString(b)
       -                n = n + 1
       +        for n, f := range flags {
       +                badges.WriteString(f.badge)
                        if n % 8 == 0 {
                                badges.WriteString("\n")
                        }