diff options
Diffstat (limited to 'src/fextdata.php')
| -rw-r--r-- | src/fextdata.php | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/src/fextdata.php b/src/fextdata.php index 8dfb134..f78c7f9 100644 --- a/src/fextdata.php +++ b/src/fextdata.php @@ -626,7 +626,20 @@ function genSQLs($contest, $site, $updatetime) { $sql['sitetable']="select * 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 * from problemtable where contestnumber=$contest and fake='f' 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 and updatetime >= $updatetime"; $sql['clartable']="select * from clartable where contestnumber=$contest and clarsitenumber=$site and updatetime >= $updatetime"; |