Changeset 5452 for trunk/admin

Timestamp:

Mar 29, 2010, 8:16:33 PM (14 years ago)

Author:

nikrou

Message:

Fix some issues with database engines :

• insert into syntax not correct for posgresql or sqlite
• add languages table
• incorrect function for row count (sqlite)

Location:

trunk/admin/include

Files:

• languages.class.php (modified) (1 diff)
• themes.class.php (modified) (1 diff)

trunk/admin/include/languages.class.php

@@ -79 +79 @@
         }
 
-        $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;

trunk/admin/include/themes.class.php

@@ -115 +115 @@
         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);
         }