From d8f2907fb00b701f91e6e98d33c4e6c0dd0619a5 Mon Sep 17 00:00:00 2001 From: Cassio de Campos Date: Mon, 16 Oct 2017 22:34:48 +0100 Subject: bug fixes --- src/fclar.php | 15 +++++++++------ 1 file changed, 9 insertions(+), 6 deletions(-) (limited to 'src/fclar.php') diff --git a/src/fclar.php b/src/fclar.php index fd99c53..72364e8 100644 --- a/src/fclar.php +++ b/src/fclar.php @@ -300,7 +300,7 @@ function DBNewClar($param,$c=null) { DBExec($c, "update sitetable set sitenextclar=$clarnumber" . " where sitenumber=$site and contestnumber=$contest and sitenextclar<$clarnumber", "DBNewClar(update site)"); - $clarnumber = myunique(); + $clarnumber = myunique($clarnumber); $clarinc = $clarnumber; } else { $sql = "select * from clartable as t where t.contestnumber=$contest and " . @@ -338,11 +338,14 @@ function DBNewClar($param,$c=null) { $ret=1; if($insert) { if($clarinc >= $clarnumber) { - while(!DBExecNonStop($c, "INSERT INTO clartable (contestnumber, clarsitenumber, clarnumber, usernumber, clardate, " . - "clardatediff, clardatediffans, clarproblem, clardata, claranswer, clarjudge, clarjudgesite, clarstatus, updatetime) VALUES " . - "($contest, $site, $clarnumber, $user, $clardate, $clardatediff, $clardatediffans, $problem, '$question', " . - "'$claranswer', $clarjudge, $clarjudgesite, '$clarstatus', $updatetime)", - "DBNewClar(insert clar)")) { + while(true) { + DBExec($c,"SAVEPOINT sp" . $clarnumber,"DBNewClar(insert clar sp)"); + if(DBExecNonStop($c, "INSERT INTO clartable (contestnumber, clarsitenumber, clarnumber, usernumber, clardate, " . + "clardatediff, clardatediffans, clarproblem, clardata, claranswer, clarjudge, clarjudgesite, clarstatus, updatetime) VALUES " . + "($contest, $site, $clarnumber, $user, $clardate, $clardatediff, $clardatediffans, $problem, '$question', " . + "'$claranswer', $clarjudge, $clarjudgesite, '$clarstatus', $updatetime)", + "DBNewClar(insert clar)")) break; + DBExec($c,"ROLLBACK TO SAVEPOINT sp" . $clarnumber,"DBNewClar(insert clar sp rollback)"); $clarnumber++; if($clarnumber > $clarinc + 3) break; } -- cgit v1.2.3