From 66aad0beeaae24f999e2544103ffe2814fb56cd3 Mon Sep 17 00:00:00 2001 From: Cassio de Campos Date: Sun, 5 Nov 2017 15:18:14 +0100 Subject: bf --- src/fextdata.php | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'src/fextdata.php') diff --git a/src/fextdata.php b/src/fextdata.php index 25ef1f0..2b2d007 100644 --- a/src/fextdata.php +++ b/src/fextdata.php @@ -702,10 +702,11 @@ function genSQLs($contest, $site, $updatetime, $mainsite=1) { //"problemcolor, " . "updatetime" . " from problemtable where contestnumber=$contest and fake='f' and updatetime >= $updatetime"; - } + $sql['usertable']="select * from usertable where contestnumber=$contest and usersitenumber!=$site and updatetime >= $updatetime"; + } else + $sql['usertable']="select * from usertable where contestnumber=$contest and usersitenumber=$site 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"; + $sql['clartable']="select * from clartable where contestnumber=$contest and updatetime >= $updatetime"; $sql['runtable']="select * from runtable where contestnumber=$contest and runsitenumber=$site and updatetime >= $updatetime"; $sql['tasktable']="select * from tasktable where contestnumber=$contest and sitenumber=$site and updatetime >= $updatetime"; return $sql; -- cgit v1.2.3