From 16cc5cdde76f20ef90eca915aa69a567bf8319d0 Mon Sep 17 00:00:00 2001
From: Romain Beauxis <toots@rastageeks.org>
Date: Sun, 20 May 2007 15:34:16 +0000
Subject: [PATCH] Added custom patch for using php timestamp capabilities since
 sqlite 2 does not have it..

---
 debian/changelog                              |  5 +++
 debian/patches/series                         |  1 +
 ..._timestamp_implementation_for_sqlite.patch | 40 +++++++++++++++++++
 3 files changed, 46 insertions(+)
 create mode 100644 debian/patches/use_php_timestamp_implementation_for_sqlite.patch

diff --git a/debian/changelog b/debian/changelog
index cad3a46..9b7f92d 100644
--- a/debian/changelog
+++ b/debian/changelog
@@ -1,8 +1,13 @@
 roundcube (0.1~rc1~dfsg-1) unstable; urgency=low
 
+  [ Vincent Bernat ]
   * New upstream release
+  [ Romain Beauxis ]
   * Fixed dh_link calls
     Closes: #423824
+  * Added custom patch to use php unix timestamp support
+    with sqlite since UNIX_TIMESTAMP is not supported by sqlite
+    before 3.
 
  -- Vincent Bernat <bernat@luffy.cx>  Sun, 20 May 2007 13:59:44 +0200
 
diff --git a/debian/patches/series b/debian/patches/series
index d9c2b5e..4422224 100644
--- a/debian/patches/series
+++ b/debian/patches/series
@@ -1,3 +1,4 @@
 dbconfig-common_support.patch
 correct_install_path.patch
 use_mcrypt.patch
+use_php_timestamp_implementation_for_sqlite.patch
diff --git a/debian/patches/use_php_timestamp_implementation_for_sqlite.patch b/debian/patches/use_php_timestamp_implementation_for_sqlite.patch
new file mode 100644
index 0000000..c5f631b
--- /dev/null
+++ b/debian/patches/use_php_timestamp_implementation_for_sqlite.patch
@@ -0,0 +1,40 @@
+diff -urN roundcubemail-0.1~rc1~dfsg.orig/program/include/rcube_db.inc roundcubemail-0.1~rc1~dfsg/program/include/rcube_db.inc
+--- roundcubemail-0.1~rc1~dfsg.orig/program/include/rcube_db.inc	2007-04-28 20:07:12.000000000 +0200
++++ roundcubemail-0.1~rc1~dfsg/program/include/rcube_db.inc	2007-05-20 17:28:05.000000000 +0200
+@@ -27,6 +27,13 @@
+  */
+ require_once('DB.php');
+ 
++/* User function for getting timestamps under sqlite */
++function custom_date_to_timestamp($data) {
++   $date = strptime($data,'%Y-%m-%d %H:%M:%S');
++   return mktime($date['tm_hour'],$date['tm_min'],$date['tm_sec'],$date['tm_mon']+1,$date['tm_mday'],1900 + $date['tm_year']);
++}
++
++
+ 
+ /**
+  * Database independent query interface
+@@ -152,6 +159,9 @@
+       $dsn = $this->db_dsnw;
+ 
+     $this->db_handle = $this->dsn_connect($dsn);
++    if ($this->db_provider == "sqlite") {
++        sqlite_create_function($this->db_handle->connection,'custom_date_to_timestamp','custom_date_to_timestamp',1);    
++    }
+     $this->db_connected = $this->db_handle ? TRUE : FALSE;
+     }
+     
+@@ -462,8 +471,11 @@
+       case 'mssql':
+         return "datediff(s, '1970-01-01 00:00:00', $field)";
+ 
++      case 'sqlite':
++        return "custom_date_to_timestamp($field)";
++
+       default:
+-        return "UNIX_TIMESTAMP($field)";
++        return "UNIX_TIMESTAMP($field)"; 
+       }
+     }
+ 
-- 
2.39.2