diff options
| author | Cassio de Campos <cassiopc@gmail.com> | 2017-11-06 13:38:14 +0000 |
|---|---|---|
| committer | Cassio de Campos <cassiopc@gmail.com> | 2017-11-06 13:38:14 +0000 |
| commit | 2a257632e56643602a47e850ef83265949defc82 (patch) | |
| tree | 3c95b64910b36f4dc7f62b287975684e8f26eafa /src | |
| parent | 864d3ad640d7f2cfaaf814f61ed9e50681ac6aa0 (diff) | |
| download | boca-2a257632e56643602a47e850ef83265949defc82.tar.gz boca-2a257632e56643602a47e850ef83265949defc82.zip | |
remove duplicate clars
Diffstat (limited to 'src')
| -rw-r--r-- | src/fextdata.php | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/src/fextdata.php b/src/fextdata.php index ce23299..b74bab0 100644 --- a/src/fextdata.php +++ b/src/fextdata.php @@ -624,6 +624,9 @@ function importFromXML($ar,$contest,$site,$tomain=false,$uptime=0,$mainsite=-1) if($ret==2) { $logstr .= "$serv - Clarification " . $param['clarnumber']."/".$param['sitenumber'] ." updated\n"; LOGInfo("importFromXML: Clarification " . $param['clarnumber']."/".$param['sitenumber'] ." updated"); + if($param['sitenumber'] == $mainsite && $mainsite != $site) { + DBClarDelete($param['clarnumber'], $site, $param['contestnumber'], $param['usernumber'], $param['sitenumber']); + } } } else { @@ -705,7 +708,7 @@ function genSQLs($contest, $site, $updatetime, $mainsite=1) { } $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['clartable']="select * from clartable where contestnumber=$contest and updatetime >= $updatetime"; + $sql['clartable']="select * from clartable where contestnumber=$contest and (clarsitenumber=$site or clarsitenumber=$mainsite) 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; |