plugins/tasklist

Thomas Brüderli bruederli at kolabsys.com
Wed Sep 19 19:05:35 CEST 2012


 plugins/tasklist/drivers/database/tasklist_database_driver.php |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 51510f1665087a9017c740643f468c4cc449b9f1
Author: Thomas Bruederli <thomas at roundcube.net>
Date:   Wed Sep 19 19:05:55 2012 +0200

    Use CASE instead of IF statement to be compatible with postgres

diff --git a/plugins/tasklist/drivers/database/tasklist_database_driver.php b/plugins/tasklist/drivers/database/tasklist_database_driver.php
index 51d6ec1..bcc994c 100644
--- a/plugins/tasklist/drivers/database/tasklist_database_driver.php
+++ b/plugins/tasklist/drivers/database/tasklist_database_driver.php
@@ -69,7 +69,7 @@ class tasklist_database_driver extends tasklist_driver
         $result = $this->rc->db->query(
           "SELECT *, tasklist_id AS id FROM " . $this->db_lists . "
            WHERE user_id=?
-           ORDER BY IF(name='INBOX', 0, 1), name",
+           ORDER BY CASE WHEN name='INBOX' THEN 0 ELSE 1 END, name",
            $this->rc->user->ID
         );
 





More information about the commits mailing list