Changeset 12151 for extensions/HistoryIPExcluder

Timestamp:

Sep 13, 2011, 10:03:04 PM (13 years ago)

Author:

Eric

Message:

• Use data serialization for database storage
• Use pwg_db_real_escape_string() instead of addslashes()

Location:

extensions/HistoryIPExcluder/branches/2.2

Files:

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

extensions/HistoryIPExcluder/branches/2.2/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/branches/2.2/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/branches/2.2/language/it_IT/index.php

@@ -1 +1 @@
 <?php
 // +-----------------------------------------------------------------------+
-// | PhpWebGallery - a PHP based picture gallery                           |
-// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
-// | Copyright (C) 2003-2007 PhpWebGallery Team - http://phpwebgallery.net |
+// | Piwigo - a PHP based photo gallery                                    |
 // +-----------------------------------------------------------------------+
-// | file          : $Id: index.php 1912 2007-03-16 06:30:07Z rub $
-// | last update   : $Date: 2007-03-16 07:30:07 +0100 (ven, 16 mar 2007) $
-// | last modifier : $Author: rub $
-// | revision      : $Revision: 1912 $
+// | Copyright(C) 2008-2011 Piwigo Team                  http://piwigo.org |
+// | Copyright(C) 2003-2008 PhpWebGallery Team    http://phpwebgallery.net |
+// | Copyright(C) 2002-2003 Pierrick LE GALL   http://le-gall.net/pierrick |
 // +-----------------------------------------------------------------------+
 // | This program is free software; you can redistribute it and/or modify  |

extensions/HistoryIPExcluder/branches/2.2/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/branches/2.2/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);