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/ftask.php | |
| parent | 1bfadfa27cb0b94d2063054ccf78f8bfedd62f59 (diff) | |
| download | boca-d8f2907fb00b701f91e6e98d33c4e6c0dd0619a5.tar.gz boca-d8f2907fb00b701f91e6e98d33c4e6c0dd0619a5.zip | |
bug fixes
Diffstat (limited to 'src/ftask.php')
| -rw-r--r-- | src/ftask.php | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/src/ftask.php b/src/ftask.php index 73336c3..c54503a 100644 --- a/src/ftask.php +++ b/src/ftask.php @@ -396,7 +396,7 @@ function DBNewTask($param, $c=null, $autotask=false) { $tasknumber = $a["nexttask"] + 1; DBExec($c, "update sitetable set sitenexttask=$tasknumber" . " where sitenumber=$site and contestnumber=$contest and sitenexttask<$tasknumber", "DBNewTask(update site)"); - $taskinc = myunique(); + $taskinc = myunique($tasknumber); if(($taskinc % 2) == 0) $taskinc--; if($autotask) $taskinc++; $tasknumber = $taskinc; @@ -435,12 +435,17 @@ function DBNewTask($param, $c=null, $autotask=false) { } else $oid="NULL"; if($taskinc >= $tasknumber) { - while(!DBExecNonStop($c, "INSERT INTO tasktable (contestnumber, sitenumber, tasknumber, usernumber, taskdate, " . + while(true) { + DBExec($c,"SAVEPOINT sp" . $tasknumber,"DBNewTask(insert task sp)"); + if(DBExecNonStop($c, "INSERT INTO tasktable (contestnumber, sitenumber, tasknumber, usernumber, taskdate, " . "taskdatediff, taskdatediffans, taskfilename, taskdata, taskstatus, taskdesc, tasksystem, ". "color, colorname, updatetime) " . "VALUES ($contest, $site, $tasknumber, $user, $taskdate, $taskdatediff, $taskdatediffans, '$filename', $oid, '$status', " . "'$desc', '$sys', '$color', '$colorname', $updatetime)", - "DBNewTask(insert task)")) { + "DBNewTask(insert task)")) { + break; + } + DBExec($c,"ROLLBACK TO SAVEPOINT sp" . $tasknumber,"DBNewTask(insert task sp rollback)"); $tasknumber+=2; if($tasknumber > $taskinc + 6) { DBExec($c, "INSERT INTO tasktable (contestnumber, sitenumber, tasknumber, usernumber, taskdate, " . |