fix some concurrency issues when judging a run; update scripts to look for /etc/boca.conf if it exists

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;