Changeset 341

Timestamp:

09/08/06 10:16:47 (2 years ago)

Author:

thomasb

Message:

Updated MDB2 with MSSQL support + some cosmetics

Location:

trunk/roundcubemail/program

Files:

• include/main.inc (modified) (1 diff)
• include/rcube_mdb2.inc (modified) (2 diffs)
• js/app.js (modified) (1 diff)

trunk/roundcubemail/program/include/main.inc

@@ -186 +186 @@
   if (!$valid || ($_SERVER['REQUEST_METHOD']!='POST' && $now-$_SESSION['auth_time'] > 300))
     {
-          $_SESSION['last_auth'] = $_SESSION['auth_time'];
+    $_SESSION['last_auth'] = $_SESSION['auth_time'];
     $_SESSION['auth_time'] = $now;
     setcookie('sessauth', rcmail_auth_hash(session_id(), $now));

trunk/roundcubemail/program/include/rcube_mdb2.inc

@@ -412 +412 @@
 
   /**
+   * Return SQL function for current time and date
+   *
+   * @return string SQL function to use in query
+   * @access public
+   */
+  function now()
+    {
+    switch($this->db_provider)
+      {
+      case 'mssql':
+        return "getdate()";
+
+      default:
+        return "now()";
+      }
+    }
+
+
+  /**
    * Return SQL statement to convert a field value into a unix timestamp
    *
@@ -425 +444 @@
         return "EXTRACT (EPOCH FROM $field)";
         break;
+
+      case 'mssql':
+        return "datediff(s, '1970-01-01 00:00:00', $field)";
 
       default:

trunk/roundcubemail/program/js/app.js

@@ -50 +50 @@
 
   // default environment vars
-  this.env.keep_alive = 50;        // seconds
+  this.env.keep_alive = 60;        // seconds
   this.env.request_timeout = 180;  // seconds
   this.env.draft_autosave = 0;     // seconds