From e46f34c6e44dfb6580ffe422d55d7ce5ef6ea78f Mon Sep 17 00:00:00 2001
From: plegall <plg@piwigo.org>
Date: Tue, 31 May 2011 22:14:48 +0000
Subject: bug 2310 fixed: conf_update_param() does not erase config.comment
 column anymore, we only insert a new row if the param does not exist yet in
 the table.

git-svn-id: http://piwigo.org/svn/branches/2.2@11160 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 include/functions.inc.php | 22 ++++++++++++++++++----
 1 file changed, 18 insertions(+), 4 deletions(-)

(limited to 'include/functions.inc.php')

diff --git a/include/functions.inc.php b/include/functions.inc.php
index 015eb8849..7012db248 100644
--- a/include/functions.inc.php
+++ b/include/functions.inc.php
@@ -1022,19 +1022,33 @@ SELECT param, value
 function conf_update_param($param, $value)
 {
   $query = '
-DELETE
+SELECT
+    param,
+    value
   FROM '.CONFIG_TABLE.'
   WHERE param = \''.$param.'\'
 ;';
-  pwg_query($query);
+  $params = array_from_query($query, 'param');
 
-  $query = '
+  if (count($params) == 0)
+  {
+    $query = '
 INSERT
   INTO '.CONFIG_TABLE.'
   (param, value)
   VALUES(\''.$param.'\', \''.$value.'\')
 ;';
-  pwg_query($query);
+    pwg_query($query);
+  }
+  else
+  {
+    $query = '
+UPDATE '.CONFIG_TABLE.'
+  SET value = \''.$value.'\'
+  WHERE param = \''.$param.'\'
+;';
+    pwg_query($query);
+  }
 }
 
 /**
-- 
cgit v1.2.3