X-Git-Url: https://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=web%2FObj%2Fdbase_pgsql.phh;h=abe9e730337db7a2ef611e739fabc2d8d9c2e547;hb=ca4114fe5a3d9afe1d3b6861128fa96720f738f5;hp=f2149997674058ca53f4532210fcf946faec8ae7;hpb=215e2a24fbec8d1a6a95dddf617dea99b05676eb;p=brisk.git diff --git a/web/Obj/dbase_pgsql.phh b/web/Obj/dbase_pgsql.phh index f214999..abe9e73 100644 --- a/web/Obj/dbase_pgsql.phh +++ b/web/Obj/dbase_pgsql.phh @@ -291,7 +291,7 @@ class BriskDB // ttok text UNIQUE, // tidx - function bin5_points_save($date, $table, $tidx, $ucodes, $pts) + function bin5_points_save($date, $table, $tidx, $action, $ucodes, $pts) { GLOBAL $G_dbpfx; $sql_ttok = escsql($table->table_token); @@ -323,7 +323,7 @@ class BriskDB log_crit(sprintf("bin5_points_save: failed at insert match [%s]", $mtc_sql)); break; } - $mtc_obj = pg_fetch_object($mtc_pg,0); + $mtc_obj = pg_fetch_object($mtc_pg, 0); for ($i = 0 ; $i < $n ; $i++) { $ord_sql = sprintf("INSERT INTO %sbin5_table_orders (mcode, ucode, pos) VALUES (%d, %d, %d);", @@ -343,9 +343,9 @@ class BriskDB /* * games management */ - $gam_sql = sprintf("INSERT INTO %sbin5_games (mcode, tstamp, asta_pnt, pnt, asta_win, friend, mazzo, mult) - VALUES (%d, to_timestamp(%d), %d, %d, %d, %d, %d, %d) RETURNING *;", - $G_dbpfx, $mtc_obj->code, $date, + $gam_sql = sprintf("INSERT INTO %sbin5_games (mcode, tstamp, act, asta_pnt, pnt, asta_win, friend, mazzo, mult) + VALUES (%d, to_timestamp(%d), %d, %d, %d, %d, %d, %d, %d) RETURNING *;", + $G_dbpfx, $mtc_obj->code, $date, $action, $table->old_asta_pnt, $table->old_pnt, $table->old_asta_win, $table->old_friend, @@ -379,7 +379,8 @@ class BriskDB $is_trans = FALSE; - $ret = TRUE; + $table->match_id = $mtc_obj->code; + $ret = TRUE; } while (0); if ($is_trans)