diff options
| author | Cassio de Campos <cassiopc@gmail.com> | 2017-11-05 14:47:42 +0000 |
|---|---|---|
| committer | Cassio de Campos <cassiopc@gmail.com> | 2017-11-05 14:47:42 +0000 |
| commit | 1184838f1f5289ef7135de4b566f78aa4a41af4a (patch) | |
| tree | d024f937359cb1159f34483df22b4ae2bf7720c3 | |
| parent | 4009f8a4938575e3fefcd25b1559fde350cd7b99 (diff) | |
| download | boca-1184838f1f5289ef7135de4b566f78aa4a41af4a.tar.gz boca-1184838f1f5289ef7135de4b566f78aa4a41af4a.zip | |
bf
| -rw-r--r-- | src/fscore.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/fscore.php b/src/fscore.php index e1485d9..ec03091 100644 --- a/src/fscore.php +++ b/src/fscore.php @@ -265,7 +265,7 @@ function DBRecentNews($contest, $site, $verifylastmile, $minutes=3) { "u.usernumber as usernumber, p.problemnumber as problemnumber, p.problemname, (r.rundatediffans>$ta) as fut, min(r.rundatediff) as time from " . "runtable as r, answertable as a, problemtable as p, usertable as u where r.runanswer=a.answernumber and " . "p.contestnumber=$contest and a.contestnumber=$contest and r.usernumber = u.usernumber and u.usertype='team' and " . - "p.problemnumber=r.runproblem and r.contestnumber=$contest and r.runsitenumber=$site and u.userenabled='t' and (not r.runstatus ~ 'deleted')" . + "p.problemnumber=r.runproblem and r.contestnumber=$contest and r.runsitenumber=$site and u.userenabled='t' and (not r.runstatus ~ 'deleted') and " . "r.rundatediff>=$taa and r.rundatediff<=$tf and r.rundatediff<=$ta and u.contestnumber=$contest and u.usersitenumber=$site and " . "((a.yes='t' and r.rundatediffans<=$ta) or (r.rundatediffans>$ta)) " . "group by a.yes,p.problemcolor,p.problemcolorname,p.problemname,u.userfullname,u.usernumber,p.problemnumber,fut order by time", "DBRecentNews(get runs)"); |