diff options
| author | Cassio de Campos <cassiopc@gmail.com> | 2017-11-01 15:50:20 +0000 |
|---|---|---|
| committer | Cassio de Campos <cassiopc@gmail.com> | 2017-11-01 15:50:20 +0000 |
| commit | d905ad849668e2d961a1277f5e5cc66fff7d1219 (patch) | |
| tree | 4bb46b69ed8728e834f71284ca94e1e441b15d89 | |
| parent | 063619bb2a9e6fb5c26fd68a631653dc8a388a0d (diff) | |
| download | boca-d905ad849668e2d961a1277f5e5cc66fff7d1219.tar.gz boca-d905ad849668e2d961a1277f5e5cc66fff7d1219.zip | |
no need to send some stuff to main
| -rw-r--r-- | src/fextdata.php | 34 |
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"; |