From 4009f8a4938575e3fefcd25b1559fde350cd7b99 Mon Sep 17 00:00:00 2001 From: Cassio de Campos Date: Sun, 5 Nov 2017 15:46:56 +0100 Subject: bf --- src/fscore.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/fscore.php') diff --git a/src/fscore.php b/src/fscore.php index 6d1482f..e1485d9 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 r.runstatus !~ 'deleted'" . + "p.problemnumber=r.runproblem and r.contestnumber=$contest and r.runsitenumber=$site and u.userenabled='t' and (not r.runstatus ~ 'deleted')" . "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)"); -- cgit v1.2.3