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