X-Git-Url: http://mop.ddnsfree.com/gitweb/?p=brisk.git;a=blobdiff_plain;f=web%2FObj%2Fdbase_pgsql.phh;h=6299f81e206db418708697ef6aa1a8880c157ab1;hp=f9f6888756d663f8ab8b1ca46c107fff2bd11d8e;hb=035bbc47bddfd26c5506d8b684c9fe3da79fc136;hpb=bdc40b38c38e78e26d6f4a8a3a7a4be650eb7d2b diff --git a/web/Obj/dbase_pgsql.phh b/web/Obj/dbase_pgsql.phh index f9f6888..6299f81 100644 --- a/web/Obj/dbase_pgsql.phh +++ b/web/Obj/dbase_pgsql.phh @@ -735,29 +735,34 @@ class BriskDB if ($i < $n) break; - $cnt_sql = sprintf("UPDATE %susers SET (match_cnt, game_cnt) + // FIXME: uncomment when counters are updated + if (0 == 1) { + $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); - for ($i = 0 ; $i < $n ; $i++) { - $codes_where .= sprintf("%scode = %d", ($i == 0 ? "" : " OR "), $ucodes[$i]); - } - - $cnt_sql = sprintf("UPDATE %susers SET (game_cnt) + // 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) = (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; + 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; + } } }