From 03b9af1f28c0d537d8459c9820e0f49464046e33 Mon Sep 17 00:00:00 2001 From: David M Date: Tue, 18 Apr 2006 02:41:59 +0000 Subject: - Olympus now properly works with MS SQL - DB backup system handles MS SQL - A few bug fixes to the backup system ;) git-svn-id: file:///svn/phpbb/trunk@5793 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/includes/db/mssql.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'phpBB/includes/db/mssql.php') diff --git a/phpBB/includes/db/mssql.php b/phpBB/includes/db/mssql.php index 0e30a2670a..dde20bed8f 100644 --- a/phpBB/includes/db/mssql.php +++ b/phpBB/includes/db/mssql.php @@ -98,6 +98,8 @@ class dbal_mssql extends dbal { global $cache; + $query = preg_replace('#FROM \(([^)]*)\)(,|[\n\r\t ]+(?:WHERE|LEFT JOIN)) #', 'FROM \1\2 ', $query); + // EXPLAIN only in extra debug mode if (defined('DEBUG_EXTRA')) { @@ -109,7 +111,6 @@ class dbal_mssql extends dbal if (!$this->query_result) { $this->num_queries++; - if (($this->query_result = @mssql_query($query, $this->db_connect_id)) === false) { $this->sql_error($query); @@ -318,7 +319,7 @@ class dbal_mssql extends dbal { return array( 'message' => @mssql_get_last_message($this->db_connect_id), - 'code' => '' + 'code' => @mssql_query("SELECT @@ERROR", $this->db_connect_id) ); } -- cgit v1.2.1