X-Git-Url: http://mop.ddnsfree.com/gitweb/?p=brisk.git;a=blobdiff_plain;f=web%2FObj%2Fdbase_pgsql.phh;h=77c215f83940975a122a5dddf0df4c46388a7545;hp=6299f81e206db418708697ef6aa1a8880c157ab1;hb=0b13b1b5ef313a06e58d2d44ffd09670a4dd8eb5;hpb=a49570c74281b84f6540fd96f6bde277c70e6516 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; } }