Changeset 6654 for trunk/plugins

Timestamp:

Jul 3, 2010, 2:20:38 PM (14 years ago)

Author:

nikrou

Message:

Bug 1755 : Needs single quotes in queries official plugins

Location:

trunk/plugins

Files:

• LocalFilesEditor/maintain.inc.php (modified) (2 diffs)
• c13y_upgrade/initialize.inc.php (modified) (1 diff)

trunk/plugins/LocalFilesEditor/maintain.inc.php

@@ -28 +28 @@
   $query = '
 INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment)
-VALUES ("LocalFilesEditor" , "off" , "LocalFiles Editor plugin parameters");';
+VALUES (\'LocalFilesEditor\' , \'off\' , \'LocalFiles Editor plugin parameters\');';
 
   pwg_query($query);
@@ -37 +37 @@
   global $prefixeTable;
 
-  $query = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="LocalFilesEditor" LIMIT 1;';
+  $query = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param=\'LocalFilesEditor\' LIMIT 1;';
   pwg_query($query);
 }

trunk/plugins/c13y_upgrade/initialize.inc.php

@@ -48 +48 @@
   upper('.$conf['user_fields']['email'].')
 having count(*) > 1
-limit 0,1
+limit 1
 ;';