Index: include/func.php
===================================================================
diff -u -r1.395.2.367 func.php
--- include/func.php	23 Jul 2007 06:46:41 -0000	1.395.2.367
+++ include/func.php	16 Aug 2007 05:25:49 -0000
@@ -40,7 +40,9 @@
 # Database abstract layer functions
 #
 function db_connect($sql_host, $sql_user, $sql_password) {
-        return mysql_connect($sql_host, $sql_user, $sql_password);
+        $result = mysql_connect($sql_host, $sql_user, $sql_password);
+		define("MYSQL5",substr(mysql_get_server_info(),0,1)=="5");
+		return $result;
 }
 
 function db_select_db($sql_db) {
@@ -51,6 +53,10 @@
 		global $debug_mode;
 		global $mysql_autorepair;
 
+		if(MYSQL5 && preg_match("/\s*SELECT/i", $query)) {
+			$query = preg_replace("/FROM([^\"\']+?)LEFT\s+?JOIN/is","FROM($1)LEFT JOIN",$query);
+		}
+
 		if(defined("START_TIME")) {
 			global $__sql_time;
 			$t = func_microtime();