From af738dbc2a48713f59779410955282aa5760b741 Mon Sep 17 00:00:00 2001
From: David M <davidmj@users.sourceforge.net>
Date: Fri, 4 Jan 2008 18:35:49 +0000
Subject: Ch-ch-ch-changes - Made us more DB independent by making many queries
 capability based instead of DB specific - Finished PHP5ifying of the acm_file
 class, now with some (hopefully) enhancements to its performance - Sped up
 viewforum considerably (also goes towards mcp_forum)

I really hope I didn't explode CVS...


git-svn-id: file:///svn/phpbb/trunk@8301 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/includes/db/sqlite.php | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

(limited to 'phpBB/includes/db/sqlite.php')

diff --git a/phpBB/includes/db/sqlite.php b/phpBB/includes/db/sqlite.php
index 5ae36df4f5..c6f6f8fc9b 100644
--- a/phpBB/includes/db/sqlite.php
+++ b/phpBB/includes/db/sqlite.php
@@ -25,6 +25,12 @@ include_once($phpbb_root_path . 'includes/db/dbal.' . $phpEx);
 */
 class dbal_sqlite extends dbal
 {
+	// like MS ACCESS, SQLite does not support COUNT(DISTINCT ...)
+	var $count_distinct = false;
+
+	// can't truncate a table
+	var $truncate = false;
+
 	/**
 	* Connect to server
 	*/
@@ -257,6 +263,20 @@ class dbal_sqlite extends dbal
 		return 'GLOB \'' . $this->sql_escape($expression) . '\'';
 	}
 
+	/**
+	* Expose a DBMS specific function
+	*/
+	function sql_function($type, $col)
+	{
+		switch ($type)
+		{
+			case 'length_varchar':
+			case 'length_text':
+				return 'LENGTH(' . $col . ')';
+			break;
+		}
+	}
+
 	/**
 	* return sql error array
 	* @access private
-- 
cgit v1.2.1