X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fconfig-functions.php;h=29c0a7a2e12ec4f4ee05f1fbbb2d48d38d028462;hb=dabf3d37a62230bc705be02682c656f4cb4a344f;hp=7b398bc93e6d7c57b43d6f324ac13edf97e8f019;hpb=e5dffd4249c97200cbad02f3f4eaf5c373fdb89a;p=mailer.git

diff --git a/inc/config-functions.php b/inc/config-functions.php
index 7b398bc93e..29c0a7a2e1 100644
--- a/inc/config-functions.php
+++ b/inc/config-functions.php
@@ -305,7 +305,7 @@ function updateConfiguration ($entries, $values, $updateMode = '', $config = '0'
 			// Update mode set?
 			if (!empty($updateMode)) {
 				// Update entry
-				$SQL .= sprintf("`%s`=`%s`%s%s,", $entry, $entry, $updateMode, (float) $values[$idx]);
+				$SQL .= sprintf('`%s`=`%s`%s%01.5f,', $entry, $entry, $updateMode, (float) $values[$idx]);
 			} else {
 				// Check if string or number but no array
 				if (is_array($values[$idx])) {
@@ -313,6 +313,7 @@ function updateConfiguration ($entries, $values, $updateMode = '', $config = '0'
 					reportBug(__FUNCTION__, __LINE__, 'values[' . $idx . '] should not be an array! Content=<pre>'.print_r($values[$idx], TRUE).'</pre>');
 				} elseif ($values[$idx] == 'UNIX_TIMESTAMP()') {
 					// Function UNIX_TIMESTAMP() detected
+					//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Function UNIX_TIMESAMP() detected: entry=' . $entry);
 					$SQL .= sprintf('`%s`=UNIX_TIMESTAMP(),', $entry);
 
 					// Set timestamp in array as well
@@ -326,15 +327,17 @@ function updateConfiguration ($entries, $values, $updateMode = '', $config = '0'
 
 					// Update mode set
 					// @TODO Call setConfigEntry() somehow
-					$SQL .= $entries = sprintf('`%s`=`%s`%s%s', $entry, $entry, $updateMode, (float) $values[$idx]);
+					$SQL .= $entries = sprintf('`%s`=`%s`%s%01.5f', $entry, $entry, $updateMode, (float) $values[$idx]);
 				} elseif (($values[$idx] + 0) === $values[$idx]) {
 					// Number detected
-					$SQL .= sprintf('`%s`=%s,', $entry, (float) $values[$idx]);
+					//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Number detected: entry=' . $entry . ',values[' . $idx . '/' . gettype($values[$idx]) . ']=' . $values[$idx]);
+					$SQL .= sprintf('`%s`=%01.5f,', $entry, (float) $values[$idx]);
 
 					// Set it in config as well
 					setConfigEntry($entry, $values[$idx]);
 				} else {
 					// String detected
+					//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Regular value detected: entry=' . $entry . ',values[' . $idx . '/' . gettype($values[$idx]) . ']=' . $values[$idx]);
 					$SQL .= sprintf("`%s`='%s',", $entry, sqlEscapeString($values[$idx]));
 
 					// Set it in config as well
@@ -354,21 +357,24 @@ function updateConfiguration ($entries, $values, $updateMode = '', $config = '0'
 
 		// Update mode set
 		// @TODO Call setConfigEntry() somehow
-		$SQL = sprintf('`%s`=`%s`%s%s', $entries, $entries, $updateMode, (float) $values);
-	} elseif (($values + 0) === $values) {
-		// Number detected
-		$SQL = sprintf('`%s`=%s', $entries, (float) $values);
-
-		// Set it in config first
-		setConfigEntry($entries, (float) $values);
+		$SQL = sprintf('`%s`=`%s`%s%01.5f', $entries, $entries, $updateMode, (float) $values);
 	} elseif ($values == 'UNIX_TIMESTAMP()') {
 		// Function UNIX_TIMESTAMP() detected
+		//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Function UNIX_TIMESAMP() detected: entries=' . $entries);
 		$SQL = sprintf('`%s`=UNIX_TIMESTAMP()', $entries);
 
 		// Set timestamp in array as well
 		setConfigEntry($entries, time());
+	} elseif (($values + 0) === $values) {
+		// Number detected
+		//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Number detected: entries=' . $entries . ',values[' . gettype($values) . ']=' . $values);
+		$SQL = sprintf('`%s`=%01.5f', $entries, (float) $values);
+
+		// Set it in config first
+		setConfigEntry($entries, (float) $values);
 	} else {
 		// Regular entry to update
+		//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Regular value detected: entries=' . $entries . ',values[' . gettype($values) . ']=' . $values);
 		$SQL = sprintf("`%s`='%s'", $entries, sqlEscapeString($values));
 
 		// Set it in config as well
@@ -377,7 +383,7 @@ function updateConfiguration ($entries, $values, $updateMode = '', $config = '0'
 
 	// Run database update
 	//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'SQL=' . $SQL);
-	sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_config` SET " . $SQL . " WHERE `config`=%s LIMIT 1",
+	sqlQueryEscaped('UPDATE `{?_MYSQL_PREFIX?}_config` SET ' . $SQL . ' WHERE `config`=%s LIMIT 1',
 			array(bigintval($config)), __FUNCTION__, __LINE__);
 	//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'SQL=' . $SQL . ',affectedRows=' . sqlAffectedRows());
 
@@ -407,7 +413,7 @@ function FILTER_LOAD_CONFIGURATION ($no = '0') {
 		incrementStatsEntry('cache_hits');
 	} elseif ((!isExtensionActive('cache')) || (!isset($GLOBALS['cache_array']['config'][$no]))) {
 		// Load config from DB
-		$result_config = sqlQueryEscaped("SELECT * FROM `{?_MYSQL_PREFIX?}_config` WHERE `config`='%s' LIMIT 1",
+		$result_config = sqlQueryEscaped('SELECT * FROM `{?_MYSQL_PREFIX?}_config` WHERE `config`=%s LIMIT 1',
 			array(bigintval($no)), __FUNCTION__, __LINE__);
 
 		// Is the config there?