All pastes #2069481 Raw Edit

Anonymous

public text v1 · immutable
#2069481 ·published 2011-05-26 14:47 UTC
rendered paste body
diff --git a/lib/eventum/class.stats.php b/lib/eventum/class.stats.php
index 23c77bb..0095ea1 100644
--- a/lib/eventum/class.stats.php
+++ b/lib/eventum/class.stats.php
@@ -484,7 +484,7 @@ class Stats
     {
         $prj_id = Auth::getCurrentProject();
         $stmt = "SELECT
-                    IF(sup_iss_id > 0, 'associated', 'unassociated') type,
+                    CASE WHEN sup_iss_id > 0 THEN 'associated' ELSE 'unassociated' END AS type,
                     COUNT(*) AS total_items
                  FROM
                     " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "support_email,
-- 
1.7.4.1