From d87e4d855c7c54c401ad900103b84816e3c1da11 Mon Sep 17 00:00:00 2001 From: Björn Geiger Date: Fri, 28 Oct 2011 14:54:41 +0200 Subject: Statistics --- application/models/EventMapper.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/application/models/EventMapper.php b/application/models/EventMapper.php index b228ebf..274cc34 100755 --- a/application/models/EventMapper.php +++ b/application/models/EventMapper.php @@ -277,7 +277,7 @@ class Application_Model_EventMapper $select = $this->getDbTable()->select() ->setIntegrityCheck(false) ->from(array('pce' => 'poolctrl_event'), - array('over' => 'SUM(IF(pce.running=1,1,0))', 'not_over' => 'SUM(IF(pce.running=0,1,0))') + array('over' => 'SUM(IF(pce.running=1,1,0))', 'not_over' => 'SUM(IF(pce.running=1,0,1))') ) ->join(array('pcec' => 'poolctrl_eventcategory'), 'pce.category = pcec.eventcategoryID', -- cgit v1.2.3-55-g7522