From 0b13b1b5ef313a06e58d2d44ffd09670a4dd8eb5 Mon Sep 17 00:00:00 2001 From: "Matteo Nastasi (mop)" Date: Fri, 30 Oct 2015 08:43:19 +0100 Subject: [PATCH] enabled match and hands counters --- web/Obj/dbase_pgsql.phh | 36 +++++++++++++++--------------------- web/brisk.css | 2 +- web/index.php | 2 +- 3 files changed, 17 insertions(+), 23 deletions(-) diff --git a/web/Obj/dbase_pgsql.phh b/web/Obj/dbase_pgsql.phh index 6299f81..77c215f 100644 --- a/web/Obj/dbase_pgsql.phh +++ b/web/Obj/dbase_pgsql.phh @@ -735,34 +735,28 @@ class BriskDB if ($i < $n) break; - // FIXME: uncomment when counters are updated - if (0 == 1) { - $cnt_sql = sprintf("UPDATE %susers SET (match_cnt, game_cnt) + $cnt_sql = sprintf("UPDATE %susers SET (match_cnt, game_cnt) = (match_cnt+1, game_cnt+1) WHERE %s;", - $G_dbpfx, $codes_where); - error_log($cnt_sql); - if (($cnt_pg = $this->query($cnt_sql)) == FALSE || pg_affected_rows($cnt_pg) != $n) { - log_crit(sprintf("bin5_points_save: failed increment match and game [%s]", $cnt_sql)); - break; - } + $G_dbpfx, $codes_where); + error_log($cnt_sql); + if (($cnt_pg = $this->query($cnt_sql)) == FALSE || pg_affected_rows($cnt_pg) != $n) { + log_crit(sprintf("bin5_points_save: failed increment match and game [%s]", $cnt_sql)); + break; } } else { $mtc_obj = pg_fetch_object($mtc_pg,0); - // FIXME: uncomment when counters are updated - if (0 == 1) { - for ($i = 0 ; $i < $n ; $i++) { - $codes_where .= sprintf("%scode = %d", ($i == 0 ? "" : " OR "), $ucodes[$i]); - } - $cnt_sql = sprintf("UPDATE %susers SET (game_cnt) + for ($i = 0 ; $i < $n ; $i++) { + $codes_where .= sprintf("%scode = %d", ($i == 0 ? "" : " OR "), $ucodes[$i]); + } + $cnt_sql = sprintf("UPDATE %susers SET (game_cnt) = (game_cnt+1) WHERE %s;", - $G_dbpfx, $codes_where); - error_log($cnt_sql); - if (($cnt_pg = $this->query($cnt_sql)) == FALSE || pg_affected_rows($cnt_pg) != $n) { - log_crit(sprintf("bin5_points_save: failed increment game [%s]", $cnt_sql)); - break; - } + $G_dbpfx, $codes_where); + error_log($cnt_sql); + if (($cnt_pg = $this->query($cnt_sql)) == FALSE || pg_affected_rows($cnt_pg) != $n) { + log_crit(sprintf("bin5_points_save: failed increment game [%s]", $cnt_sql)); + break; } } diff --git a/web/brisk.css b/web/brisk.css index 430c83b..d4bafaa 100644 --- a/web/brisk.css +++ b/web/brisk.css @@ -307,4 +307,4 @@ div.apprentice { background-color: #ffd780; border: 1px solid #ffae00; padding: 8px; -} \ No newline at end of file +} diff --git a/web/index.php b/web/index.php index ea7f22b..d68f270 100644 --- a/web/index.php +++ b/web/index.php @@ -1379,9 +1379,9 @@ type="submit" class="button" onclick="this.form.elements['realsub'].value = 'chi -di seguito le opzioni che verranno attivate successivamente: +di seguito le opzioni che verranno attivate successivamente: Da evitare Amico -- 2.17.1