From a6a3a6e0c271099b6f199c7363eba572fc7b5266 Mon Sep 17 00:00:00 2001
From: nikrou <nikrou@piwigo.org>
Date: Mon, 29 Mar 2010 18:16:33 +0000
Subject: Fix some issues with database engines : - insert into syntax not
 correct for posgresql or sqlite - add languages table - incorrect function
 for row count (sqlite)

git-svn-id: http://piwigo.org/svn/trunk@5452 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 admin/include/languages.class.php | 10 +++++-----
 admin/include/themes.class.php    | 13 +++++++------
 2 files changed, 12 insertions(+), 11 deletions(-)

(limited to 'admin/include')

diff --git a/admin/include/languages.class.php b/admin/include/languages.class.php
index 6f3348c87..db9d17b42 100644
--- a/admin/include/languages.class.php
+++ b/admin/include/languages.class.php
@@ -78,11 +78,11 @@ class languages
           break;
         }
 
-        $query = "
-INSERT INTO ".LANGUAGES_TABLE."
-  SET id = '".$language_id."',
-      name = '".$this->fs_languages[$language_id]."'
-;";
+        $query = '
+INSERT INTO '.LANGUAGES_TABLE.'
+  (id, name)
+  VALUES(\''.$language_id.'\', \''.$this->fs_languages[$language_id].'\')
+;';
         pwg_query($query);
         break;
 
diff --git a/admin/include/themes.class.php b/admin/include/themes.class.php
index 41ee5f336..cf81fb54e 100644
--- a/admin/include/themes.class.php
+++ b/admin/include/themes.class.php
@@ -114,12 +114,13 @@ class themes
 
         if (empty($errors))
         {
-          $query = "
-INSERT INTO ".THEMES_TABLE."
-  SET id = '".$theme_id."'
-    , version = '".$this->fs_themes[$theme_id]['version']."'
-    , name = '".$this->fs_themes[$theme_id]['name']."'
-;";
+          $query = '
+INSERT INTO '.THEMES_TABLE.'
+  (id, version, name)
+  VALUES(\''.$theme_id.'\',
+         \''.$this->fs_themes[$theme_id]['version'].'\',
+         \''.$this->fs_themes[$theme_id]['name'].'\')
+;';
           pwg_query($query);
         }
         break;
-- 
cgit v1.2.3