From 1031fcf6dbc575d963acc2b9522cdc2940957526 Mon Sep 17 00:00:00 2001 From: "Matteo Nastasi (mop)" Date: Tue, 25 Feb 2014 18:31:15 +0100 Subject: [PATCH] cont command: missing update of ttok and table id fixed --- web/Obj/dbase_pgsql.phh | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/web/Obj/dbase_pgsql.phh b/web/Obj/dbase_pgsql.phh index d5b2770..05a42f7 100644 --- a/web/Obj/dbase_pgsql.phh +++ b/web/Obj/dbase_pgsql.phh @@ -399,6 +399,7 @@ class BriskDB function match_continue($match_code, $table, $tidx) { GLOBAL $G_dbpfx; + $sql_ttok = escsql($table->table_token); if (($users = $this->users_get($match_code, FALSE /*without minmaxidx*/, TRUE /*new game*/)) == FALSE) { log_crit(sprintf("%s::%s: retrieve users fails", __CLASS__, __FUNCTION__)); @@ -473,6 +474,14 @@ class BriskDB $users[$gam_obj->friend]['login'] : ""), $gam_obj->pnt, $gam_obj->asta_pnt); + // update matches with new ttok and table idx + $mtc_sql = sprintf("UPDATE %sbin5_matches SET (ttok, tidx) = ('%s', %d) WHERE code = %d RETURNING *;", + $G_dbpfx, $sql_ttok, $tidx, $match_code); + if (($mtc_pg = $this->query($mtc_sql)) == FALSE || pg_numrows($mtc_pg) != 1) { + log_crit(sprintf("%s::%s: update matches table failed", __CLASS__, __FUNCTION__)); + return (FALSE); + } + return (TRUE); } -- 2.17.1