Changeset 10978 for extensions/HistoryIPExcluder

Timestamp:

May 21, 2011, 4:54:45 PM (14 years ago)

Author:

Eric

Message:

using conf_update_param() and pwg_db_real_escape_string()

Location:

extensions/HistoryIPExcluder/trunk

Files:

• admin/HIPE_admin.php (modified) (1 diff)
• include/dbupgrade.inc.php (modified) (3 diffs)
• main.inc.php (modified) (1 diff)
• maintain.inc.php (modified) (1 diff)

extensions/HistoryIPExcluder/trunk/admin/HIPE_admin.php

@@ -42 +42 @@
     'Version'   => $version,
   );
-  
-  $conf['HistoryIPConfig'] = serialize($newconf_HIPE);
-
-  $query = '
-    UPDATE '.CONFIG_TABLE.'
-    SET value="'.addslashes($conf['HistoryIPConfig']).'"
-    WHERE param="HistoryIPConfig"
-    LIMIT 1';
-  pwg_query($query);
+
+  conf_update_param('HistoryIPConfig', pwg_db_real_escape_string(serialize($newconf_HIPE)));
 
   // information message

extensions/HistoryIPExcluder/trunk/include/dbupgrade.inc.php

@@ -3 +3 @@
 /* Database upgrading functions */
 
-// This wil update only current plugin version number in database
+// This will update only current plugin version number in database
 function global_version_update()
 {
@@ -25 +25 @@
   
   $Newconf_HIPE['Version'] = $version;
-  
-  $update_conf = serialize($Newconf_HIPE);
 
-  $query = '
-UPDATE '.CONFIG_TABLE.'
-SET value="'.addslashes($update_conf).'"
-WHERE param="HistoryIPConfig"
-LIMIT 1
-;';
-
-        pwg_query($query);
+  conf_update_param('HistoryIPConfig', pwg_db_real_escape_string(serialize($Newconf_HIPE)));
 }
 
@@ -71 +62 @@
   $q = '
 INSERT INTO '.CONFIG_TABLE.' (param,value,comment)
-VALUES ("HistoryIPConfig","'.addslashes(serialize($default)).'","History IP Excluder options");
+VALUES ("HistoryIPConfig","'.pwg_db_real_escape_string(serialize($default)).'","History IP Excluder options");
 ';
       

extensions/HistoryIPExcluder/trunk/main.inc.php

@@ -32 +32 @@
 
 2.2.3             - Improved update mechanism. When no structural update of database is necessary, it sets the correct version number in plugin's configuration
-
 --------------------------------------------------------------------------------
 */

extensions/HistoryIPExcluder/trunk/maintain.inc.php

@@ -49 +49 @@
     $q = '
 INSERT INTO '.CONFIG_TABLE.' (param,value,comment)
-VALUES ("HistoryIPConfig","'.addslashes(serialize($default)).'","History IP Excluder options");
+VALUES ("HistoryIPConfig","'.pwg_db_real_escape_string(serialize($default)).'","History IP Excluder options");
 ';
     pwg_query($q);