Extension ext-mediadata now excludes testers

[mailer.git] / inc / sql-functions.php

diff --git a/inc/sql-functions.php b/inc/sql-functions.php
index 9982711f408a4783d574b449493c67ef4ef11d80..069f459d93a35b471a06883d80301c91d8799433 100644 (file)
--- a/inc/sql-functions.php
+++ b/inc/sql-functions.php
@@ -137,7 +137,7 @@ function getUpdateSqlFromArray ($array, $tableName, $whereColumn, $whereData, $e
                        continue;
                } // END - if
 
-               // Do we have a non-string (e.g. number, NULL, SQL function or back-tick at the beginning?
+               // Is there a non-string (e.g. number, NULL, SQL function or back-tick at the beginning?
                if (is_null($multiDimId)) {
                        // Handle one-dimensional data
                        if (is_null($value)) {
@@ -146,7 +146,7 @@ function getUpdateSqlFromArray ($array, $tableName, $whereColumn, $whereData, $e
                        } elseif ((substr($value, -2, 2) == '()') || (substr($value, 0, 1) == '`')) {
                                // SQL function needs no ticks (')
                                $SQL .= '`' . $entry . '`=' . SQL_ESCAPE($value) . ',';
-                       } elseif ('' . bigintval($value, true, false) . '' == '' . $value . '')  {
+                       } elseif ('' . bigintval($value, TRUE, FALSE) . '' == '' . $value . '')  {
                                // No need for ticks (')
                                $SQL .= '`' . $entry . '`=' . $value . ',';
                        } else {
@@ -161,7 +161,7 @@ function getUpdateSqlFromArray ($array, $tableName, $whereColumn, $whereData, $e
                        } elseif ((substr($value[$multiDimId], -2, 2) == '()') || (substr($value[$multiDimId], 0, 1) == '`')) {
                                // SQL function needs no ticks (')
                                $SQL .= '`' . $entry . '`=' . SQL_ESCAPE($value[$multiDimId]) . ',';
-                       } elseif (('' . bigintval($value[$multiDimId], true, false) . '' == '' . $value[$multiDimId] . ''))  {
+                       } elseif (('' . bigintval($value[$multiDimId], TRUE, FALSE) . '' == '' . $value[$multiDimId] . ''))  {
                                // No need for ticks (')
                                $SQL .= '`' . $entry . '`=' . $value[$multiDimId] . ',';
                        } else {
@@ -184,7 +184,7 @@ function getInsertSqlFromArray ($array, $tableName) {
        $SQL = 'INSERT INTO
 `{?_MYSQL_PREFIX?}_' . $tableName . '`
 (
-`' . implode('`,`', array_keys(postRequestArray())) . '`
+`' . implode('`, `', array_keys(postRequestArray())) . '`
 ) VALUES (';
 
        // Walk through all entries
@@ -199,7 +199,7 @@ function getInsertSqlFromArray ($array, $tableName) {
                } elseif (substr($value, -2, 2) == '()') {
                        // SQL function needs no ticks (')
                        $SQL .= SQL_ESCAPE($value) . ',';
-               } elseif ('' . bigintval($value, true, false) . '' == '' . $value . '') {
+               } elseif ('' . bigintval($value, TRUE, FALSE) . '' == '' . $value . '') {
                        // Number detected, no need for ticks (')
                        $SQL .= bigintval($value) . ',';
                } elseif ('' . (float) $value . '' == '' . $value . '') {