Changeset 5452 for trunk/admin/include/languages.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/languages.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;