aboutsummaryrefslogtreecommitdiffstats
path: root/include
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2011-05-31 22:14:48 +0000
committerplegall <plg@piwigo.org>2011-05-31 22:14:48 +0000
commite46f34c6e44dfb6580ffe422d55d7ce5ef6ea78f (patch)
tree045c48d964a67eba3c5cb24d55ca46c547967fc5 /include
parent21b369a8a5a8f3a71bf06bd781dbff80362b52f3 (diff)
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
Diffstat (limited to '')
-rw-r--r--include/functions.inc.php22
1 files changed, 18 insertions, 4 deletions
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);
+ }
}
/**