Changeset 4385 for trunk/admin/include

Timestamp:

Nov 29, 2009, 1:35:19 PM (15 years ago)

Author:

nikrou

Message:

Feature_1255 :

• single quotes in queries
• start using $confdblayer

Location:

trunk/admin/include

Files:

• c13y_internal.class.php (modified) (2 diffs)
• functions.php (modified) (1 diff)
• plugins.class.php (modified) (4 diffs)

trunk/admin/include/c13y_internal.class.php

@@ -39 +39 @@
   function c13y_version($c13y)
   {
+    global $conf;
+
     $check_list = array();
 
@@ -44 +46 @@
 
     $db_version = pwg_get_db_version();
-    $check_list[] = array('type' => 'MySQL', 'current' => $db_version, 'required' => REQUIRED_MYSQL_VERSION);
+    $check_list[] = array('type' => $conf['dblayer'],
+                          'current' => $db_version, 
+                          'required' => constant('REQUIRED_'.strtoupper($conf['dblayer']).'_VERSION')
+                          );
 
     foreach ($check_list as $elem)

trunk/admin/include/functions.php

@@ -417 +417 @@
 {
   $query = '
-SELECT id, if(id_uppercat is null,\'\',id_uppercat) AS id_uppercat, uppercats, rank, global_rank
+SELECT id, id_uppercat, uppercats, rank, global_rank
   FROM '.CATEGORIES_TABLE.'
   ORDER BY id_uppercat,rank,name';

trunk/admin/include/plugins.class.php

@@ -81 +81 @@
         {
           $query = '
-INSERT INTO ' . PLUGINS_TABLE . ' (id,version) VALUES ("'
-. $plugin_id . '","' . $this->fs_plugins[$plugin_id]['version'] . '"
+INSERT INTO ' . PLUGINS_TABLE . ' (id,version) VALUES (\''
+. $plugin_id . '\',\'' . $this->fs_plugins[$plugin_id]['version'] . '\'
 )';
           pwg_query($query);
@@ -111 +111 @@
           $query = '
 UPDATE ' . PLUGINS_TABLE . '
-SET state="active", version="'.$this->fs_plugins[$plugin_id]['version'].'"
-WHERE id="' . $plugin_id . '"';
+SET state=\'active\', version=\''.$this->fs_plugins[$plugin_id]['version'].'\'
+WHERE id=\'' . $plugin_id . '\'';
           pwg_query($query);
         }
@@ -127 +127 @@
         }
         $query = '
-UPDATE ' . PLUGINS_TABLE . ' SET state="inactive" WHERE id="' . $plugin_id . '"';
+UPDATE ' . PLUGINS_TABLE . ' SET state=\'inactive\' WHERE id=\'' . $plugin_id . '\'';
         pwg_query($query);
         if (file_exists($file_to_include))
@@ -145 +145 @@
         }
         $query = '
-DELETE FROM ' . PLUGINS_TABLE . ' WHERE id="' . $plugin_id . '"';
+DELETE FROM ' . PLUGINS_TABLE . ' WHERE id=\'' . $plugin_id . '\'';
         pwg_query($query);
         if (file_exists($file_to_include))