From 1c06214f0109b8c152edab2ca6e76f580fe7cc9f Mon Sep 17 00:00:00 2001 From: Björn Geiger Date: Fri, 28 Oct 2011 14:58:27 +0200 Subject: minor --- application/layouts/default.phtml | 2 +- application/models/EventMapper.php | 8 ++++---- 2 files changed, 5 insertions(+), 5 deletions(-) diff --git a/application/layouts/default.phtml b/application/layouts/default.phtml index 1c861dc..c8d0793 100755 --- a/application/layouts/default.phtml +++ b/application/layouts/default.phtml @@ -58,7 +58,7 @@ echo $this->headScript()."\n";
  • diff --git a/application/models/EventMapper.php b/application/models/EventMapper.php index d906297..d4f6b5c 100755 --- a/application/models/EventMapper.php +++ b/application/models/EventMapper.php @@ -267,7 +267,7 @@ class Application_Model_EventMapper $select = $this->getDbTable()->select() ->setIntegrityCheck(false) ->from(array('pce' => 'poolctrl_event'), - array('count1' => 'SUM(IF(pce.running=1,1,0))', 'count0' => 'SUM(IF(pce.running=1,1,0))') + array('count1' => 'SUM(IF(pce.running=1,1,0))', 'count0' => 'SUM(IF(pce.running=1,0,1))') ) ->join(array('pcec' => 'poolctrl_eventcategory'), 'pce.category = pcec.eventcategoryID', @@ -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=1,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', @@ -303,7 +303,7 @@ class Application_Model_EventMapper $select = $this->getDbTable()->select() ->setIntegrityCheck(false) ->from(array('pce' => 'poolctrl_event'), - array('count1' => 'SUM(IF(pce.running=1,1,0))', 'count0' => 'SUM(IF(pce.running=1,1,0))') + array('count1' => 'SUM(IF(pce.running=1,1,0))', 'count0' => 'SUM(IF(pce.running=1,0,1))') ) ->join(array('pcec' => 'poolctrl_eventcategory'), 'pce.category = pcec.eventcategoryID', @@ -313,7 +313,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=1,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