diff options
Diffstat (limited to 'boca-1.5.0/src/frun.php')
| -rw-r--r-- | boca-1.5.0/src/frun.php | 388 |
1 files changed, 195 insertions, 193 deletions
diff --git a/boca-1.5.0/src/frun.php b/boca-1.5.0/src/frun.php index fcf05c0..cd6cd50 100644 --- a/boca-1.5.0/src/frun.php +++ b/boca-1.5.0/src/frun.php @@ -18,14 +18,14 @@ // Last modified 21/jul/2012 by cassio@ime.usp.br function DBDropRunTable() { - $c = DBConnect(); - $r = DBExec($c, "drop table \"runtable\"", "DBDropRunTable(drop table)"); + $c = DBConnect(); + $r = DBExec($c, "drop table \"runtable\"", "DBDropRunTable(drop table)"); } function DBCreateRunTable() { - $c = DBConnect(); - $conf = globalconf(); - if($conf["dbuser"]=="") $conf["dbuser"]="bocauser"; - $r = DBExec($c, " + $c = DBConnect(); + $conf = globalconf(); + if($conf["dbuser"]=="") $conf["dbuser"]="bocauser"; + $r = DBExec($c, " CREATE TABLE \"runtable\" ( \"contestnumber\" int4 NOT NULL, -- (id do concurso) \"runsitenumber\" int4 NOT NULL, -- (local de origem da submissao) @@ -71,14 +71,14 @@ CONSTRAINT \"lang_fk\" FOREIGN KEY (\"contestnumber\", \"runlangnumber\") REFERENCES \"langtable\" (\"contestnumber\", \"langnumber\") ON DELETE CASCADE ON UPDATE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE )", "DBCreateRunTable(create table)"); - $r = DBExec($c, "REVOKE ALL ON \"runtable\" FROM PUBLIC", "DBCreateRunTable(revoke public)"); + $r = DBExec($c, "REVOKE ALL ON \"runtable\" FROM PUBLIC", "DBCreateRunTable(revoke public)"); $r = DBExec($c, "GRANT ALL ON \"runtable\" TO \"".$conf["dbuser"]."\"", "DBCreateRunTable(grant bocauser)"); $r = DBExec($c, "CREATE UNIQUE INDEX \"run_index\" ON \"runtable\" USING btree ". - "(\"contestnumber\" int4_ops, \"runsitenumber\" int4_ops, \"runnumber\" int4_ops)", - "DBCreateRunTable(create run_index)"); + "(\"contestnumber\" int4_ops, \"runsitenumber\" int4_ops, \"runnumber\" int4_ops)", + "DBCreateRunTable(create run_index)"); $r = DBExec($c, "CREATE INDEX \"run_index2\" ON \"runtable\" USING btree ". - "(\"contestnumber\" int4_ops, \"runsitenumber\" int4_ops, \"usernumber\" int4_ops)", - "DBCreateRunTable(create run_index2)"); + "(\"contestnumber\" int4_ops, \"runsitenumber\" int4_ops, \"usernumber\" int4_ops)", + "DBCreateRunTable(create run_index2)"); } ///////////////////////////////funcoes de runs/////////////////////////////////////////////////////// @@ -95,33 +95,35 @@ function DBUpdateRun($contest, $usersite, $usernumber, $runsite, $runnumber, $an return DBUpdateRunC($contest, $usersite, $usernumber, $runsite, $runnumber, $answer, 0); } function DBUpdateRunC($contest, $usersite, $usernumber, $runsite, $runnumber, $answer, $chief, $c=null) { - $a = DBGetRow("select * from answertable where answernumber=$answer and contestnumber=$contest",0,null, - "DBUpdateRunC(get answer)"); + $bw = 0; + if($c==null) { + $bw = 1; + $c = DBConnect(); + DBExec($c, "begin work", "DBUpdateRunC(transaction)"); + } + + $a = DBGetRow("select * from answertable where answernumber=$answer and contestnumber=$contest",0,$c, + "DBUpdateRunC(get answer)"); if ($a == null) { + DBExec($c, "rollback work", "DBUpdateRunC(rollback)"); MSGError("Problem with the answer table. Contact an admin now!"); LogLevel("Unable to judge a run because the answer was not found (run=$runnumber, site=$runsite, ". - "contest=$contest, answer=$answer).",0); + "contest=$contest, answer=$answer).",0); return false; } if ($a["fake"] == 't') { + DBExec($c, "rollback work", "DBUpdateRunC(rollback)"); MSGError("You must choose a valid answer."); LogLevel("Unable to judge a run because of the fake answer (run=$runnumber, site=$runsite, ". - "contest=$contest, answer=$answer).",0); + "contest=$contest, answer=$answer).",0); return false; } $yes = $a["yes"]; - $b = DBSiteInfo($contest, $runsite); + $b = DBSiteInfo($contest, $runsite, $c); if ($b == null) { exit; } - $bw = 0; - if($c==null) { - $bw = 1; - $c = DBConnect(); - DBExec($c, "begin work", "DBUpdateRunC(transaction)"); - } - $sql = "select * from runtable as r where r.contestnumber=$contest and " . "r.runsitenumber=$runsite and r.runnumber=$runnumber"; if ($chief != 1) { @@ -136,7 +138,7 @@ function DBUpdateRunC($contest, $usersite, $usernumber, $runsite, $runnumber, $a if($bw == 1) { DBExec($c, "rollback work", "DBUpdateRunC(rollback)"); LogLevel("Unable to judge a run (maybe it was already judged or catched by a chief) " . - "(run=$runnumber, site=$runsite, contest=$contest).",2); + "(run=$runnumber, site=$runsite, contest=$contest).",2); MSGError("Unable to judge the run (maybe it was already judged or catched by a chief)"); } return false; @@ -145,67 +147,67 @@ function DBUpdateRunC($contest, $usersite, $usernumber, $runsite, $runnumber, $a $t = $b["currenttime"]; $team=$temp["usernumber"]; - if ($temp["runanswer"] != "") - $tinhabalao = DBBalloon($contest, $runsite, $temp["usernumber"], $temp["runproblem"], ($bw==1)); + if ($temp["runanswer"] != "") + $tinhabalao = DBBalloon($contest, $runsite, $temp["usernumber"], $temp["runproblem"], ($bw==1),$c); else $tinhabalao = false; - if($temp["runjudge1"]==$usernumber && $temp["runjudgesite1"]==$usersite) { - DBExec($c, "update runtable set runanswer1=$answer, updatetime=".time()." " . - "where contestnumber=$contest and runnumber=$runnumber and runsitenumber=$runsite", + if($temp["runjudge1"]==$usernumber && $temp["runjudgesite1"]==$usersite) { + DBExec($c, "update runtable set runanswer1=$answer, updatetime=".time()." " . + "where contestnumber=$contest and runnumber=$runnumber and runsitenumber=$runsite", "DBUpdateRunC(update run judge1)"); - $outra = $temp["runanswer2"]; - } - if($temp["runjudge2"]==$usernumber && $temp["runjudgesite2"]==$usersite) { - DBExec($c, "update runtable set runanswer2=$answer, updatetime=".time()." " . - "where contestnumber=$contest and runnumber=$runnumber and runsitenumber=$runsite", + $outra = $temp["runanswer2"]; + } + if($temp["runjudge2"]==$usernumber && $temp["runjudgesite2"]==$usersite) { + DBExec($c, "update runtable set runanswer2=$answer, updatetime=".time()." " . + "where contestnumber=$contest and runnumber=$runnumber and runsitenumber=$runsite", "DBUpdateRunC(update run judge2)"); - $outra = $temp["runanswer1"]; - } - $newstatus = 'judging'; - if($chief == 1 || ($outra != 0 && $outra == $answer && $temp["runstatus"] != "judged+") || - ($outra != 0 && $outra == $answer && $temp["runanswer"]==$answer)) { - $newstatus = 'judged'; - DBExec($c, "update runtable set runstatus='judged', " . - "runjudge=$usernumber, runjudgesite=$usersite, " . - "runanswer=$answer, rundatediffans=$t, updatetime=".time()." " . - "where contestnumber=$contest and runnumber=$runnumber and runsitenumber=$runsite", - "DBUpdateRunC(update run)"); - - $tembalao = DBBalloon($contest, $runsite, $temp["usernumber"], $temp["runproblem"], ($bw==1)); - + $outra = $temp["runanswer1"]; + } + $newstatus = 'judging'; + if($chief == 1 || ($outra != 0 && $outra == $answer && $temp["runstatus"] != "judged+") || + ($outra != 0 && $outra == $answer && $temp["runanswer"]==$answer)) { + $newstatus = 'judged'; + DBExec($c, "update runtable set runstatus='judged', " . + "runjudge=$usernumber, runjudgesite=$usersite, " . + "runanswer=$answer, rundatediffans=$t, updatetime=".time()." " . + "where contestnumber=$contest and runnumber=$runnumber and runsitenumber=$runsite", + "DBUpdateRunC(update run)"); + + $tembalao = DBBalloon($contest, $runsite, $temp["usernumber"], $temp["runproblem"], ($bw==1),$c); + // if ($runsite==$usersite) { - if (!$tinhabalao && $tembalao) { - if (($b = DBSiteInfo($contest, $runsite)) == null) - return true; - $ta = $b["currenttime"]; - $tf = $b["sitelastmileanswer"]; - if ($ta < $tf) { - $u = DBUserInfo ($contest, $runsite, $team); + if (!$tinhabalao && $tembalao) { + if (($b = DBSiteInfo($contest, $runsite, $c)) == null) + return true; + $ta = $b["currenttime"]; + $tf = $b["sitelastmileanswer"]; + if ($ta < $tf) { + $u = DBUserInfo ($contest, $runsite, $team, $c); + if($u['usertype']=='team') { + $p = DBGetProblemData ($contest, $temp["runproblem"],$c); + DBNewTask_old ($contest, $runsite, $team, + escape_string("\"" . $u["username"] ."\" must have a balloon for problem " . + $p[0]["problemname"] . ": " . $p[0]["fullname"]), + "", "", "t", $p[0]["color"], $p[0]["colorname"], $c); + } + } + } else if ($tinhabalao && !$tembalao) { + $u = DBUserInfo ($contest, $runsite, $team, $c); if($u['usertype']=='team') { - $p = DBGetProblemData ($contest, $temp["runproblem"]); - DBNewTask_old ($contest, $runsite, $team, - escape_string("\"" . $u["username"] ."\" must have a balloon for problem " . - $p[0]["problemname"] . ": " . $p[0]["fullname"]), - "", "", "t", $p[0]["color"], $p[0]["colorname"], $c); + $p = DBGetProblemData ($contest, $temp["runproblem"],$c); + DBNewTask_old ($contest, $runsite, $team, escape_string("\"" . + $u["username"] ."\" must have _NO_ balloon for problem " . $p[0]["problemname"] . + ": " . $p[0]["fullname"]). ". Please verify and remove it, if needed.", "", "", + "t", $p[0]["color"], $p[0]["colorname"], $c); } } - } else if ($tinhabalao && !$tembalao) { - $u = DBUserInfo ($contest, $runsite, $team); - if($u['usertype']=='team') { - $p = DBGetProblemData ($contest, $temp["runproblem"]); - DBNewTask_old ($contest, $runsite, $team, escape_string("\"" . - $u["username"] ."\" must have _NO_ balloon for problem " . $p[0]["problemname"] . - ": " . $p[0]["fullname"]). ". Please verify and remove it, if needed.", "", "", - "t", $p[0]["color"], $p[0]["colorname"], $c); - } - } // } } if($bw == 1) { DBExec($c, "commit work", "DBUpdateRunC(commit)"); LOGLevel("Run updated (run=$runnumber,site=$runsite,user=$team,contest=$contest,newstatus=$newstatus,". - "judge=$usernumber(site=$usersite),answer=$answer(".$a["runanswer"].")).", 3); + "judge=$usernumber(site=$usersite),answer=$answer(".$a["runanswer"].")).", 3); } return true; } @@ -218,11 +220,11 @@ function DBRunGiveUp($number,$site,$contest,$usernumber,$usersite) { $c = DBConnect(); DBExec($c, "begin work", "DBRunGiveUp(transaction)"); $sql = "select * from runtable as r where r.contestnumber=$contest and " . - "r.runsitenumber=$site and r.runnumber=$number"; + "r.runsitenumber=$site and r.runnumber=$number"; if ($usernumber != 1 && $usersite != -1) { $sql .= " and (r.runstatus='judging' or r.runstatus='judged+') and " . - "((r.runjudge1=$usernumber and r.runjudgesite1=$usersite) or " . - " (r.runjudge2=$usernumber and r.runjudgesite2=$usersite))"; + "((r.runjudge1=$usernumber and r.runjudgesite1=$usersite) or " . + " (r.runjudge2=$usernumber and r.runjudgesite2=$usersite))"; $tx = "Judge"; } else $tx = "Chief"; $r = DBExec ($c, $sql . " for update", "DBRunGiveUp(get run for update)"); @@ -230,12 +232,12 @@ function DBRunGiveUp($number,$site,$contest,$usernumber,$usersite) { if ($n != 1) { DBExec($c, "rollback work", "DBRunGiveUp(rollback)"); LogLevel("Unable to return a run (maybe the timeout or a chief returned it first). ". - "(run=$number, site=$site, contest=$contest)",2); + "(run=$number, site=$site, contest=$contest)",2); return false; } $temp = DBRow($r, 0); - $tinhabalao = DBBalloon($contest, $site, $temp["usernumber"], $temp["runproblem"]); + $tinhabalao = DBBalloon($contest, $site, $temp["usernumber"], $temp["runproblem"],true,$c); $outra = -1; if($temp["runjudge1"]==$usernumber && $temp["runjudgesite1"]==$usersite) { @@ -264,56 +266,56 @@ function DBRunGiveUp($number,$site,$contest,$usernumber,$usersite) { DBExec($c, "update runtable set runstatus='openrun', runanswer=0, runjudge=NULL, runjudgesite=NULL, ". "runanswer1=0, runanswer2=0, runjudge1=NULL, runjudge2=NULL, runjudgesite1=NULL, runjudgesite2=NULL, ". "updatetime=" . - time()." where contestnumber=$contest and runnumber=$number and runsitenumber=$site", - "DBRunGiveUp(update run)"); + time()." where contestnumber=$contest and runnumber=$number and runsitenumber=$site", + "DBRunGiveUp(update run)"); $newstatus='openrun'; } - } - $tembalao = DBBalloon($contest, $site, $temp["usernumber"], $temp["runproblem"]); + } + $tembalao = DBBalloon($contest, $site, $temp["usernumber"], $temp["runproblem"],true,$c); if ($tinhabalao && !$tembalao) { - $u = DBUserInfo ($contest, $site, $temp["usernumber"]); + $u = DBUserInfo ($contest, $site, $temp["usernumber"], $c); if($u['usertype']=='team') { - $p = DBGetProblemData ($contest, $temp["runproblem"]); - DBNewTask_old ($contest, $site, $temp["usernumber"], escape_string("\"" . - $u["username"] ."\" must have _NO_ balloon for problem " . $p[0]["problemname"] . - ": " . $p[0]["fullname"]), "", "", "t", $p[0]["color"], $p[0]["colorname"], $c); + $p = DBGetProblemData ($contest, $temp["runproblem"],$c); + DBNewTask_old ($contest, $site, $temp["usernumber"], escape_string("\"" . + $u["username"] ."\" must have _NO_ balloon for problem " . $p[0]["problemname"] . + ": " . $p[0]["fullname"]), "", "", "t", $p[0]["color"], $p[0]["colorname"], $c); } } DBExec($c, "commit work", "DBRunGiveUp(commit)"); LOGLevel("Run returned (run=$number, site=$site, contest=$contest, user=$usernumber(site=$usersite)), ". - "newstatus=$newstatus", 3); + "newstatus=$newstatus", 3); return true; } function DBRunDelete($number,$site,$contest,$user,$usersite) { $c = DBConnect(); DBExec($c, "begin work", "DBRunDelete(transaction)"); $sql = "select * from runtable as r where r.contestnumber=$contest and " . - "r.runsitenumber=$site and r.runnumber=$number"; + "r.runsitenumber=$site and r.runnumber=$number"; $r = DBExec ($c, $sql . " for update", "DBRunDelete(get run for update)"); $n = DBnlines($r); if ($n != 1) { DBExec($c, "rollback work", "DBRunDelete(rollback)"); LogLevel("Unable to delete a run. ". - "(run=$number, site=$site, contest=$contest)",1); + "(run=$number, site=$site, contest=$contest)",1); return false; } $temp = DBRow($r, 0); - $tinhabalao = DBBalloon($contest, $site, $temp["usernumber"], $temp["runproblem"]); + $tinhabalao = DBBalloon($contest, $site, $temp["usernumber"], $temp["runproblem"],true,$c); DBExec($c, "update runtable set runstatus='deleted', runjudge=$user, runjudgesite=$usersite, updatetime=" . time()." where contestnumber=$contest and runnumber=$number and runsitenumber=$site", - "DBRunDelete(update run)"); + "DBRunDelete(update run)"); - $tembalao = DBBalloon($contest, $site, $temp["usernumber"], $temp["runproblem"]); + $tembalao = DBBalloon($contest, $site, $temp["usernumber"], $temp["runproblem"],true,$c); if ($tinhabalao && !$tembalao) { - $u = DBUserInfo ($contest, $site, $temp["usernumber"]); + $u = DBUserInfo ($contest, $site, $temp["usernumber"], $c); if($u['usertype']=='team') { - $p = DBGetProblemData ($contest, $temp["runproblem"]); - DBNewTask_old ($contest, $site, $temp["usernumber"], escape_string("\"" . - $u["username"] . "\" must have _NO_ balloon for problem " . $p[0]["problemname"] . - ": " . $p[0]["fullname"]), "", "", "t", $p[0]["color"], $p[0]["colorname"], $c); + $p = DBGetProblemData ($contest, $temp["runproblem"],$c); + DBNewTask_old ($contest, $site, $temp["usernumber"], escape_string("\"" . + $u["username"] . "\" must have _NO_ balloon for problem " . $p[0]["problemname"] . + ": " . $p[0]["fullname"]), "", "", "t", $p[0]["color"], $p[0]["colorname"], $c); } } @@ -337,29 +339,29 @@ function DBGetRunToAnswerC($number,$site,$contest,$chief) { $c = DBConnect(); DBExec($c, "begin work", "DBGetRunToAnswerC(transaction)"); $sql = "select r.contestnumber as contestnumber, r.runsitenumber as sitenumber, r.runanswer as answer, " . - "r.runanswer1 as answer1, r.runanswer2 as answer2, " . - "r.runjudge as judge, r.runjudgesite as judgesite, " . - "r.runjudge1 as judge1, r.runjudgesite1 as judgesite1, r.runjudge2 as judge2, r.runjudgesite2 as judgesite2, " . - "r.runnumber as number, r.rundatediff as timestamp, r.runstatus as status, " . - "r.rundata as sourceoid, r.runfilename as sourcename, l.langnumber as langnumber, " . - "p.problemname as problemname, p.problemnumber as problemnumber, l.langname as language, l.langextension as extension, " . - "r.autoip as autoip, r.autobegindate as autobegin, r.autoenddate as autoend, r.autoanswer as autoanswer, ". - "r.autostdout as autostdout, r.autostderr as autostderr ". - - "from runtable as r, problemtable as p, langtable as l " . - "where r.contestnumber=$contest and p.contestnumber=r.contestnumber and " . - "r.runproblem=p.problemnumber and r.runsitenumber=$site and " . - "r.runlangnumber=l.langnumber and r.contestnumber=l.contestnumber and " . - "r.runnumber=$number"; + "r.runanswer1 as answer1, r.runanswer2 as answer2, " . + "r.runjudge as judge, r.runjudgesite as judgesite, " . + "r.runjudge1 as judge1, r.runjudgesite1 as judgesite1, r.runjudge2 as judge2, r.runjudgesite2 as judgesite2, " . + "r.runnumber as number, r.rundatediff as timestamp, r.runstatus as status, " . + "r.rundata as sourceoid, r.runfilename as sourcename, l.langnumber as langnumber, " . + "p.problemname as problemname, p.problemnumber as problemnumber, l.langname as language, l.langextension as extension, " . + "r.autoip as autoip, r.autobegindate as autobegin, r.autoenddate as autoend, r.autoanswer as autoanswer, ". + "r.autostdout as autostdout, r.autostderr as autostderr ". + + "from runtable as r, problemtable as p, langtable as l " . + "where r.contestnumber=$contest and p.contestnumber=r.contestnumber and " . + "r.runproblem=p.problemnumber and r.runsitenumber=$site and " . + "r.runlangnumber=l.langnumber and r.contestnumber=l.contestnumber and " . + "r.runnumber=$number"; if ($chief != 1) { $sql .= " and (r.runstatus='openrun' or " . - "(r.runstatus='judged+' and r.runjudge is NULL) or " . - "((r.runstatus='judging' or r.runstatus='judged+') and " . - " (r.runjudge1 is null or r.runjudge2 is null or " . - " ((r.runjudge1=" . $_SESSION["usertable"]["usernumber"] . " and " . - " r.runjudgesite1=" . $_SESSION["usertable"]["usersitenumber"] . ") or " . - " (r.runjudge2=" . $_SESSION["usertable"]["usernumber"] . " and " . - " r.runjudgesite2=" . $_SESSION["usertable"]["usersitenumber"] . ")))))"; + "(r.runstatus='judged+' and r.runjudge is NULL) or " . + "((r.runstatus='judging' or r.runstatus='judged+') and " . + " (r.runjudge1 is null or r.runjudge2 is null or " . + " ((r.runjudge1=" . $_SESSION["usertable"]["usernumber"] . " and " . + " r.runjudgesite1=" . $_SESSION["usertable"]["usersitenumber"] . ") or " . + " (r.runjudge2=" . $_SESSION["usertable"]["usernumber"] . " and " . + " r.runjudgesite2=" . $_SESSION["usertable"]["usersitenumber"] . ")))))"; $tx = "Judge"; } else $tx = "Chief"; $r = DBExec ($c, $sql . " for update", "DBGetRunToAnswerC(get run/prob/lang for update)"); @@ -367,39 +369,39 @@ function DBGetRunToAnswerC($number,$site,$contest,$chief) { if ($n != 1) { DBExec($c, "rollback work", "DBGetRunToAnswerC(rollback)"); LogLevel("Unable to get a run (maybe other judge got it first). (run=$number, site=$site, ". - "contest=$contest)",2); + "contest=$contest)",2); return false; } $a = DBRow($r,0); if ($chief != 1) { - $upd=""; + $upd=""; if($a["status"]=="openrun") $upd="runstatus='judging',"; if(($a["judge1"]!=$_SESSION["usertable"]["usernumber"] || - $a["judgesite1"]!=$_SESSION["usertable"]["usersitenumber"]) && - ($a["judge2"]!=$_SESSION["usertable"]["usernumber"] || - $a["judgesite2"]!=$_SESSION["usertable"]["usersitenumber"])) { + $a["judgesite1"]!=$_SESSION["usertable"]["usersitenumber"]) && + ($a["judge2"]!=$_SESSION["usertable"]["usernumber"] || + $a["judgesite2"]!=$_SESSION["usertable"]["usersitenumber"])) { if($a["judge1"]=='' && $a['judgesite1']=='') { DBExec($c, "update runtable set runjudge1=" . $_SESSION["usertable"]["usernumber"] . - ",$upd updatetime=".time().", " . - "runjudgesite1=" . $_SESSION["usertable"]["usersitenumber"] . " " . - "where contestnumber=$contest and runnumber=$number and runsitenumber=$site", - "DBGetRunToAnswerC(update run judge1)"); + ",$upd updatetime=".time().", " . + "runjudgesite1=" . $_SESSION["usertable"]["usersitenumber"] . " " . + "where contestnumber=$contest and runnumber=$number and runsitenumber=$site", + "DBGetRunToAnswerC(update run judge1)"); } else { DBExec($c, "update runtable set runjudge2=" . $_SESSION["usertable"]["usernumber"] . - ",$upd updatetime=".time().", " . - "runjudgesite2=" . $_SESSION["usertable"]["usersitenumber"] . " " . - "where contestnumber=$contest and runnumber=$number and runsitenumber=$site", - "DBGetRunToAnswerC(update run judge2)"); + ",$upd updatetime=".time().", " . + "runjudgesite2=" . $_SESSION["usertable"]["usersitenumber"] . " " . + "where contestnumber=$contest and runnumber=$number and runsitenumber=$site", + "DBGetRunToAnswerC(update run judge2)"); } - } + } } DBExec($c, "commit work", "DBGetRunToAnswerC(commit)"); LOGLevel("User got a run (run=$number, site=$site, contest=$contest, user=". - $_SESSION["usertable"]["usernumber"]. - "(site=".$_SESSION["usertable"]["usersitenumber"] .")).", 3); + $_SESSION["usertable"]["usernumber"]. + "(site=".$_SESSION["usertable"]["usersitenumber"] .")).", 3); return $a; } function DBGetRunToAutojudging($contest, $ip) { @@ -427,13 +429,13 @@ function DBGetRunToAutojudging($contest, $ip) { return false; } $a = DBRow($r,0); - $t = time(); + $t = time(); DBExec($c, "update runtable set autoip='" . $ip . "', " . - "autobegindate=$t, autoenddate=null, autoanswer=null, autostdout=null, autostderr=null, " . - "updatetime=$t " . - "where contestnumber=${a["contest"]} and runnumber=${a["number"]} and runsitenumber=${a["site"]}", - "DBGetRunToAutojudging(update run)"); + "autobegindate=$t, autoenddate=null, autoanswer=null, autostdout=null, autostderr=null, " . + "updatetime=$t " . + "where contestnumber=${a["contest"]} and runnumber=${a["number"]} and runsitenumber=${a["site"]}", + "DBGetRunToAutojudging(update run)"); DBExec($c, "commit work", "DBGetRunToAutojudging(commit)"); LOGLevel("Autojudging got a run (run=${a["number"]}, site=${a["site"]}, contest=${a["contest"]})", 3); @@ -444,8 +446,8 @@ function DBUpdateRunAutojudging($contest, $site, $number, $ip, $answer, $stdout, $c = DBConnect(); DBExec($c, "begin work", "DBUpdateRunAutojudging(transaction)"); $sql = "select * from runtable as r " . - "where r.contestnumber=$contest and r.runnumber=$number and r.runsitenumber=$site and " . - "r.autoip='$ip'"; + "where r.contestnumber=$contest and r.runnumber=$number and r.runsitenumber=$site and " . + "r.autoip='$ip'"; $r = DBExec ($c, $sql . " for update", "DBUpdateRunAutoJudging(get run for update)"); $n = DBnlines($r); if ($n != 1) { @@ -455,7 +457,7 @@ function DBUpdateRunAutojudging($contest, $site, $number, $ip, $answer, $stdout, } $a = DBRow($r,0); $b = DBSiteInfo($contest, $site, $c); - $t = time(); + $t = time(); if (($oid1 = DB_lo_import($c, $stdout)) === false) { DBExec($c, "rollback work", "DBUpdateRunAutojudging(rollback-stdout)"); @@ -488,7 +490,7 @@ function DBUpdateRunAutojudging($contest, $site, $number, $ip, $answer, $stdout, if(DBUpdateRunO($contest, $site, $a["usernumber"], $site, $number, $retval, $c)==false) { DBExec($c, "rollback work", "DBUpdateRunAutoJudging(rollback)"); LOGError("Unable to automatically update a run answer (run=$number, site=$site, ". - "contest=$contest, answer='$answer', retval=$retval)"); + "contest=$contest, answer='$answer', retval=$retval)"); return false; } DBExec($c, "commit work", "DBUpdateRunAutojudging(commit)"); @@ -499,7 +501,7 @@ function DBGiveUpRunAutojudging($contest, $site, $number, $ip="", $ans="") { $c = DBConnect(); DBExec($c, "begin work", "DBGiveUpRunAutojudging(transaction)"); $sql = "select * from runtable as r " . - "where r.contestnumber=$contest and r.runnumber=$number and r.runsitenumber=$site"; + "where r.contestnumber=$contest and r.runnumber=$number and r.runsitenumber=$site"; $r = DBExec ($c, $sql . " for update", "DBGiveUpRunAutoJudging(get run for update)"); $n = DBnlines($r); if ($n != 1) { @@ -508,19 +510,19 @@ function DBGiveUpRunAutojudging($contest, $site, $number, $ip="", $ans="") { return false; } $a = DBRow($r,0); - $t = time(); - - if($ip=="") { - DBExec($c, "update runtable set autoenddate=null, autoanswer=null, autostdout=null, autostderr=null, " . - "updatetime=$t, autobegindate=null, autoip='' " . - "where contestnumber=$contest and runnumber=$number and runsitenumber=$site", - "DBGiveUpRunAutojudging(update run)"); - } else { - DBExec($c, "update runtable set autoenddate=$t, autoanswer='$ans', autostdout=null, ". - "autostderr=null, updatetime=$t, autoip='$ip' " . - "where contestnumber=$contest and runnumber=$number and runsitenumber=$site", - "DBGiveUpRunAutojudging(update run-withip)"); - } + $t = time(); + + if($ip=="") { + DBExec($c, "update runtable set autoenddate=null, autoanswer=null, autostdout=null, autostderr=null, " . + "updatetime=$t, autobegindate=null, autoip='' " . + "where contestnumber=$contest and runnumber=$number and runsitenumber=$site", + "DBGiveUpRunAutojudging(update run)"); + } else { + DBExec($c, "update runtable set autoenddate=$t, autoanswer='$ans', autostdout=null, ". + "autostderr=null, updatetime=$t, autoip='$ip' " . + "where contestnumber=$contest and runnumber=$number and runsitenumber=$site", + "DBGiveUpRunAutojudging(update run-withip)"); + } DBExec($c, "commit work", "DBGiveUpRunAutojudging(commit)"); LOGLevel("Run gaveup from Autojudging (run=$number, site=$site, contest=$contest)", 3); return true; @@ -554,27 +556,27 @@ function DBOpenRunsSNS($contest,$site,$st,$order='run') { "l.langnumber=r.runlangnumber and a.answernumber=r.runanswer and " . "a.contestnumber=r.contestnumber"; if ($site != "x") { - $str = explode(",", $site); - $sql .= " and (r.runsitenumber=-1"; - for ($i=0;$i<count($str);$i++) { + $str = explode(",", $site); + $sql .= " and (r.runsitenumber=-1"; + for ($i=0;$i<count($str);$i++) { if (is_numeric($str[$i])) $sql .= " or r.runsitenumber=".$str[$i]; - } - $sql .= ")"; + } + $sql .= ")"; } if ($st == 1) { - $sql .= " and (not (r.runjudge1=". $_SESSION["usertable"]["usernumber"] . " and " . - "r.runjudgesite1=". $_SESSION["usertable"]["usersitenumber"] . " and r.runanswer1!=0)) and "; - $sql .= " (not (r.runjudge2=". $_SESSION["usertable"]["usernumber"] . " and " . - "r.runjudgesite2=". $_SESSION["usertable"]["usersitenumber"] . " and r.runanswer2!=0)) and " . - - "(not ((r.runjudge1!=". $_SESSION["usertable"]["usernumber"] . " or " . - "r.runjudgesite1!=". $_SESSION["usertable"]["usersitenumber"] . ") and " . - " (r.runjudge2!=". $_SESSION["usertable"]["usernumber"] . " or " . - "r.runjudgesite2!=". $_SESSION["usertable"]["usersitenumber"] . ") and " . - " (not (r.runjudge1 is null)) and (not (r.runjudge2 is null))))"; + $sql .= " and (not (r.runjudge1=". $_SESSION["usertable"]["usernumber"] . " and " . + "r.runjudgesite1=". $_SESSION["usertable"]["usersitenumber"] . " and r.runanswer1!=0)) and "; + $sql .= " (not (r.runjudge2=". $_SESSION["usertable"]["usernumber"] . " and " . + "r.runjudgesite2=". $_SESSION["usertable"]["usersitenumber"] . " and r.runanswer2!=0)) and " . + + "(not ((r.runjudge1!=". $_SESSION["usertable"]["usernumber"] . " or " . + "r.runjudgesite1!=". $_SESSION["usertable"]["usersitenumber"] . ") and " . + " (r.runjudge2!=". $_SESSION["usertable"]["usernumber"] . " or " . + "r.runjudgesite2!=". $_SESSION["usertable"]["usersitenumber"] . ") and " . + " (not (r.runjudge1 is null)) and (not (r.runjudge2 is null))))"; $sql .= " and (not r.runstatus = 'judged') " . - " and not r.runstatus ~ 'deleted' order by "; + " and not r.runstatus ~ 'deleted' order by "; } else $sql .= " order by "; if($order == "site") @@ -583,9 +585,9 @@ function DBOpenRunsSNS($contest,$site,$st,$order='run') { $sql .= "r.runstatus,"; else if ($order == "judge") $sql .= "r.runjudge,r.runjudgesite,"; - else if ($order == "problem") - $sql .= "p.problemname,"; - else if ($order == "language") + else if ($order == "problem") + $sql .= "p.problemname,"; + else if ($order == "language") $sql .= "l.langname,"; else if ($order == "answer") $sql .= "a.runanswer,"; @@ -837,11 +839,11 @@ function DBNewRun($param,$c=null) { /* // isso gera problemas de portabilidade e de seguranca (quando outros usuarios tambem tem shell // no servidor e podem construir paginas web. Eles podem usar essas paginas para acessar esses arquivos, // pois os mesmos ficaram com dono apache/www-data/etc) - umask(0077); - @mkdir("/tmp/boca"); - if (!move_uploaded_file ($filepath, - "/tmp/boca/contest${contest}.site${site}.run${n}.user${user}.problem${problem}.time${t}.${filename}")) - LOGLevel("Run not saved as file (run=$n,site=$site,contest=$contest", 1); + umask(0077); + @mkdir("/tmp/boca"); + if (!move_uploaded_file ($filepath, + "/tmp/boca/contest${contest}.site${site}.run${n}.user${user}.problem${problem}.time${t}.${filename}")) + LOGLevel("Run not saved as file (run=$n,site=$site,contest=$contest", 1); */ } //recebe o numero do contest, o numero do site e o numero do usuario @@ -892,25 +894,25 @@ function DBUserRunsYES($contest,$site,$user) { $c = DBConnect(); $r = DBExec($c, "select distinct p.problemcolorname as colorname, p.problemcolor as color, " . "r.rundatediff as timestamp, p.problemnumber as number " . - "from runtable as r, problemtable as p, answertable as a " . - "where r.contestnumber=$contest and p.contestnumber=r.contestnumber and " . - "r.contestnumber=a.contestnumber and r.runproblem=p.problemnumber and " . - "r.runsitenumber=$site and r.usernumber=$user and not r.runstatus ~ 'deleted' and " . - "(r.rundatediffans<=$t or (r.runstatus != 'judged' and r.rundatediff<=$t)) and " . - "a.answernumber=r.runanswer and a.yes='t' order by r.rundatediff", - "DBUserRunsYES(get run/prob/ans/lang)"); + "from runtable as r, problemtable as p, answertable as a " . + "where r.contestnumber=$contest and p.contestnumber=r.contestnumber and " . + "r.contestnumber=a.contestnumber and r.runproblem=p.problemnumber and " . + "r.runsitenumber=$site and r.usernumber=$user and not r.runstatus ~ 'deleted' and " . + "(r.rundatediffans<=$t or (r.runstatus != 'judged' and r.rundatediff<=$t)) and " . + "a.answernumber=r.runanswer and a.yes='t' order by r.rundatediff", + "DBUserRunsYES(get run/prob/ans/lang)"); $n = DBnlines($r); $a = array(); $j=0; - $p = array(); + $p = array(); for ($i=0;$i<$n;$i++) { $aa = DBRow($r,$i); if ($aa["timestamp"] < $b["sitelastmileanswer"]) { - if(!isset($p[$aa["number"]])) { - $p[$aa["number"]] = 1; - $a[$j] = $aa; - $j++; - } + if(!isset($p[$aa["number"]])) { + $p[$aa["number"]] = 1; + $a[$j] = $aa; + $j++; + } } } return $a; |