From ba6f21caeb405c7e8512a09941fefbc97286e45f Mon Sep 17 00:00:00 2001
From: Aleksander Machniak <alec@alec.pl>
Date: Wed, 21 Nov 2012 19:52:03 +0100
Subject: Framework files moved to lib/Roundcube

---
 program/include/rcube_db_sqlsrv.php | 157 ------------------------------------
 1 file changed, 157 deletions(-)
 delete mode 100644 program/include/rcube_db_sqlsrv.php

(limited to 'program/include/rcube_db_sqlsrv.php')

diff --git a/program/include/rcube_db_sqlsrv.php b/program/include/rcube_db_sqlsrv.php
deleted file mode 100644
index 8b6ffe807..000000000
--- a/program/include/rcube_db_sqlsrv.php
+++ /dev/null
@@ -1,157 +0,0 @@
-<?php
-
-/**
- +-----------------------------------------------------------------------+
- | program/include/rcube_db_sqlsrv.php                                   |
- |                                                                       |
- | This file is part of the Roundcube Webmail client                     |
- | Copyright (C) 2005-2012, The Roundcube Dev Team                       |
- |                                                                       |
- | Licensed under the GNU General Public License version 3 or            |
- | any later version with exceptions for skins & plugins.                |
- | See the README file for a full license statement.                     |
- |                                                                       |
- | PURPOSE:                                                              |
- |   Database wrapper class that implements PHP PDO functions            |
- |   for MS SQL Server database                                          |
- |                                                                       |
- +-----------------------------------------------------------------------+
- | Author: Aleksander Machniak <alec@alec.pl>                            |
- +-----------------------------------------------------------------------+
-*/
-
-
-/**
- * Database independent query interface
- * This is a wrapper for the PHP PDO
- *
- * @package    Framework
- * @subpackage Database
- */
-class rcube_db_sqlsrv extends rcube_db
-{
-    public $db_provider = 'mssql';
-
-    /**
-     * Driver initialization
-     */
-    protected function init()
-    {
-        $this->options['identifier_start'] = '[';
-        $this->options['identifier_end'] = ']';
-    }
-
-    /**
-     * Database character set setting
-     */
-    protected function set_charset($charset)
-    {
-        // UTF-8 is default
-    }
-
-    /**
-     * Return SQL function for current time and date
-     *
-     * @return string SQL function to use in query
-     */
-    public function now()
-    {
-        return "getdate()";
-    }
-
-    /**
-     * Return SQL statement to convert a field value into a unix timestamp
-     *
-     * This method is deprecated and should not be used anymore due to limitations
-     * of timestamp functions in Mysql (year 2038 problem)
-     *
-     * @param string $field Field name
-     *
-     * @return string SQL statement to use in query
-     * @deprecated
-     */
-    public function unixtimestamp($field)
-    {
-        return "DATEDIFF(second, '19700101', $field) + DATEDIFF(second, GETDATE(), GETUTCDATE())";
-    }
-
-    /**
-     * Abstract SQL statement for value concatenation
-     *
-     * @return string SQL statement to be used in query
-     */
-    public function concat(/* col1, col2, ... */)
-    {
-        $args = func_get_args();
-
-        if (is_array($args[0])) {
-            $args = $args[0];
-        }
-
-        return '(' . join('+', $args) . ')';
-    }
-
-    /**
-     * Adds TOP (LIMIT,OFFSET) clause to the query
-     *
-     * @param string $query  SQL query
-     * @param int    $limit  Number of rows
-     * @param int    $offset Offset
-     *
-     * @return string SQL query
-     */
-    protected function set_limit($query, $limit = 0, $offset = 0)
-    {
-        $limit  = intval($limit);
-        $offset = intval($offset);
-
-        $orderby = stristr($query, 'ORDER BY');
-        if ($orderby !== false) {
-            $sort  = (stripos($orderby, ' desc') !== false) ? 'desc' : 'asc';
-            $order = str_ireplace('ORDER BY', '', $orderby);
-            $order = trim(preg_replace('/\bASC\b|\bDESC\b/i', '', $order));
-        }
-
-        $query = preg_replace('/^SELECT\s/i', 'SELECT TOP ' . ($limit + $offset) . ' ', $query);
-
-        $query = 'SELECT * FROM (SELECT TOP ' . $limit . ' * FROM (' . $query . ') AS inner_tbl';
-        if ($orderby !== false) {
-            $query .= ' ORDER BY ' . $order . ' ';
-            $query .= (stripos($sort, 'asc') !== false) ? 'DESC' : 'ASC';
-        }
-        $query .= ') AS outer_tbl';
-        if ($orderby !== false) {
-            $query .= ' ORDER BY ' . $order . ' ' . $sort;
-        }
-
-        return $query;
-    }
-
-    /**
-     * Returns PDO DSN string from DSN array
-     */
-    protected function dsn_string($dsn)
-    {
-        $params = array();
-        $result = 'sqlsrv:';
-
-        if ($dsn['hostspec']) {
-            $host = $dsn['hostspec'];
-
-            if ($dsn['port']) {
-                $host .= ',' . $dsn['port'];
-            }
-            $params[] = 'Server=' . $host;
-        }
-
-        if ($dsn['database']) {
-            $params[] = 'Database=' . $dsn['database'];
-        }
-
-        if (!empty($params)) {
-            $result .= implode(';', $params);
-        }
-
-        return $result;
-    }
-}
-- 
cgit v1.2.3