From 57980b4c77d5200131b65fc8d9ad42733981e33c Mon Sep 17 00:00:00 2001
From: garvinhicking <garvinhicking>
Date: Mon, 1 May 2006 13:53:40 +0000
Subject: [PATCH] SET NAMES command was not really called until now. Thanks to
 Josef Moravek from the forums!

---
 include/db/mysql.inc.php    | 10 ++++++++--
 include/db/mysqli.inc.php   |  9 +++++++--
 include/db/postgres.inc.php |  3 +++
 include/db/sqlite.inc.php   |  3 +++
 include/lang.inc.php        |  3 ++-
 5 files changed, 23 insertions(+), 5 deletions(-)

diff --git a/include/db/mysql.inc.php b/include/db/mysql.inc.php
index db9027f..49393b3 100644
--- a/include/db/mysql.inc.php
+++ b/include/db/mysql.inc.php
@@ -263,11 +263,17 @@ function serendipity_db_connect() {
 
     $serendipity['dbConn'] = $function($serendipity['dbHost'], $serendipity['dbUser'], $serendipity['dbPass']);
     mysql_select_db($serendipity['dbName']);
+    serendipity_db_reconnect();
+
+    return $serendipity['dbConn'];
+}
+
+function serendipity_db_reconnect() {
+    global $serendipity;
+
     if (defined('SQL_CHARSET') && $serendipity['dbNames']) {
         mysql_query("SET NAMES " . SQL_CHARSET, $serendipity['dbConn']);
     }
-
-    return $serendipity['dbConn'];
 }
 
 /**
diff --git a/include/db/mysqli.inc.php b/include/db/mysqli.inc.php
index 0be7888..fd13abd 100644
--- a/include/db/mysqli.inc.php
+++ b/include/db/mysqli.inc.php
@@ -232,12 +232,17 @@ function serendipity_db_connect() {
 
     $serendipity['dbConn'] = $function($serendipity['dbHost'], $serendipity['dbUser'], $serendipity['dbPass']);
     mysqli_select_db($serendipity['dbConn'], $serendipity['dbName']);
+    serendipity_db_reconnect();
+
+    return $serendipity['dbConn'];
+}
+
+function serendipity_db_reconnect() {
+    global $serendipity;
 
     if (defined('SQL_CHARSET') && $serendipity['dbNames']) {
         mysqli_query($serendipity['dbConn'], "SET NAMES " . SQL_CHARSET);
     }
-
-    return $serendipity['dbConn'];
 }
 
 /**
diff --git a/include/db/postgres.inc.php b/include/db/postgres.inc.php
index b6459dc..714d25e 100644
--- a/include/db/postgres.inc.php
+++ b/include/db/postgres.inc.php
@@ -66,6 +66,9 @@ function serendipity_db_connect() {
     return $serendipity['dbConn'];
 }
 
+function serendipity_db_reconnect() {
+}
+
 /**
  * Returns a escaped string, so that it can be safely included in a SQL string encapsulated within quotes, without allowing SQL injection.
  *
diff --git a/include/db/sqlite.inc.php b/include/db/sqlite.inc.php
index f1b52d1..9575826 100644
--- a/include/db/sqlite.inc.php
+++ b/include/db/sqlite.inc.php
@@ -56,6 +56,9 @@ function serendipity_db_connect()
     return $serendipity['dbConn'];
 }
 
+function serendipity_db_reconnect() {
+}
+
 /**
  * Returns a escaped string, so that it can be safely included in a SQL string encapsulated within quotes, without allowing SQL injection.
  *
diff --git a/include/lang.inc.php b/include/lang.inc.php
index a0bf0e9..91770e2 100644
--- a/include/lang.inc.php
+++ b/include/lang.inc.php
@@ -9,6 +9,7 @@ if (!defined('serendipity_LANG_LOADED') || serendipity_LANG_LOADED !== true) {
     if (@include(S9Y_INCLUDE_PATH . 'lang/' . $charset . 'serendipity_lang_'. $serendipity['lang'] .'.inc.php') ) {
         // Only here can we truely say the language is loaded
         define('serendipity_LANG_LOADED', true);
+        serendipity_db_reconnect();
     } elseif (IS_installed === false || (defined('IS_up2date') && IS_up2date === false)) {   /* -- Auto-Guess -- */
         // If no config file is loaded, language includes are not available.
         // Now include one. Try to auto-guess the language by looking up the HTTP_ACCEPT_LANGUAGE.
@@ -27,7 +28,7 @@ if (!defined('serendipity_MB_LOADED') && defined('serendipity_LANG_LOADED')) {
     if (function_exists('mb_language')) {
         @mb_language($serendipity['lang']);
     }
-    
+
     if (function_exists('mb_internal_encoding')) {
         @mb_internal_encoding(LANG_CHARSET);
     }
-- 
2.39.5