diff options
| author | Cassio de Campos <cassiopc@gmail.com> | 2017-10-16 21:34:48 +0000 |
|---|---|---|
| committer | Cassio de Campos <cassiopc@gmail.com> | 2017-10-16 21:34:48 +0000 |
| commit | d8f2907fb00b701f91e6e98d33c4e6c0dd0619a5 (patch) | |
| tree | 2a8d0520e8f538d1cb31931b37c23ab095885890 /src/fclar.php | |
| parent | 1bfadfa27cb0b94d2063054ccf78f8bfedd62f59 (diff) | |
| download | boca-d8f2907fb00b701f91e6e98d33c4e6c0dd0619a5.tar.gz boca-d8f2907fb00b701f91e6e98d33c4e6c0dd0619a5.zip | |
bug fixes
Diffstat (limited to 'src/fclar.php')
| -rw-r--r-- | src/fclar.php | 15 |
1 files changed, 9 insertions, 6 deletions
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; } |