aboutsummaryrefslogtreecommitdiff
path: root/src/fextdata.php
diff options
context:
space:
mode:
Diffstat (limited to 'src/fextdata.php')
-rw-r--r--src/fextdata.php34
1 files changed, 18 insertions, 16 deletions
diff --git a/src/fextdata.php b/src/fextdata.php
index 136360d..9413f06 100644
--- a/src/fextdata.php
+++ b/src/fextdata.php
@@ -685,22 +685,24 @@ function genSQLs($contest, $site, $updatetime, $mainsite=1) {
"sitemaxjudgewaittime, " .
"updatetime " .
" from sitetable where contestnumber=$contest and sitenumber=$site and updatetime >= $updatetime";
- $sql['answertable']="select * from answertable where contestnumber=$contest and fake='f' and updatetime >= $updatetime";
- $sql['langtable']="select * from langtable where contestnumber=$contest and updatetime >= $updatetime";
- $sql['problemtable']="select " .
- "contestnumber, " .
- "problemnumber, " .
- "problemname, " .
- "problemfullname, " .
- "problembasefilename, " .
- "probleminputfilename, " .
- "probleminputfile, " .
- "probleminputfilehash, " .
- "fake, " .
- //"problemcolorname, " .
- //"problemcolor, " .
- "updatetime" .
- " from problemtable where contestnumber=$contest and fake='f' and updatetime >= $updatetime";
+ if($site != $mainsite) {
+ $sql['answertable']="select * from answertable where contestnumber=$contest and fake='f' and updatetime >= $updatetime";
+ $sql['langtable']="select * from langtable where contestnumber=$contest and updatetime >= $updatetime";
+ $sql['problemtable']="select " .
+ "contestnumber, " .
+ "problemnumber, " .
+ "problemname, " .
+ "problemfullname, " .
+ "problembasefilename, " .
+ "probleminputfilename, " .
+ "probleminputfile, " .
+ "probleminputfilehash, " .
+ "fake, " .
+ //"problemcolorname, " .
+ //"problemcolor, " .
+ "updatetime" .
+ " from problemtable where contestnumber=$contest and fake='f' and updatetime >= $updatetime";
+ }
$sql['sitetimetable']="select * from sitetimetable where contestnumber=$contest and sitenumber=$site and updatetime >= $updatetime";
$sql['usertable']="select * from usertable where contestnumber=$contest and (usersitenumber=$site or usersitenumber=$mainsite) and updatetime >= $updatetime";
$sql['clartable']="select * from clartable where contestnumber=$contest and clarsitenumber=$site and updatetime >= $updatetime";