Changeset 5452 for trunk/admin/include/themes.class.php

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)

File:

• trunk/admin/include/themes.class.php (modified) (1 diff)

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);
         }