mailer project continued:

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

diff --git a/inc/sql-functions.php b/inc/sql-functions.php
index d89d64d9b50a3e6df7cedbec282e87510cbee954..9982711f408a4783d574b449493c67ef4ef11d80 100644 (file)
--- a/inc/sql-functions.php
+++ b/inc/sql-functions.php
@@ -16,8 +16,8 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
- * For more information visit: http://www.mxchange.org                  *
+ * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
@@ -42,10 +42,11 @@ if (!defined('__SECURITY')) {
 
 // Init SQLs array
 function initSqls () {
-       setSqlsArray(array());
+       // Init generic array
+       setSqlsArray(array('generic' => array()));
 }
 
-// Checks wether the sqls array is initialized
+// Checks whether the sqls array is initialized
 function isSqlsInitialized () {
        return ((isset($GLOBALS['sqls'])) && (is_array($GLOBALS['sqls'])));
 }
@@ -69,7 +70,7 @@ function getSqls () {
 // Add an SQL to the list
 function addSql ($sql) {
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, sprintf("sql=%s, count=%d", $sql, countSqls()));
-       $GLOBALS['sqls']['generic'][] = (string) $sql;
+       array_push($GLOBALS['sqls']['generic'], $sql);
 }
 
 // Merge SQLs together
@@ -112,7 +113,7 @@ function countSqls () {
        return $count;
 }
 
-// Checks wether the SQLs array is filled
+// Checks whether the SQLs array is filled
 function isSqlsValid () {
        //* DEBUG: */ debugOutput(__FUNCTION__ . ':' . intval(isSqlsInitialized()) . '/' . countSqls() . '/' . getCurrentExtensionName());
        return (
@@ -124,5 +125,98 @@ function isSqlsValid () {
        );
 }
 
+// Generates an updating SQL query from given array
+function getUpdateSqlFromArray ($array, $tableName, $whereColumn, $whereData, $excludedFields, $multiDimId = NULL) {
+       // Begin SQL query
+       $SQL = 'UPDATE `{?_MYSQL_PREFIX?}_' . $tableName . '` SET ';
+
+       // Insert all data
+       foreach ($array as $entry => $value) {
+               // Skip login/id entry
+               if (in_array($entry, $excludedFields)) {
+                       continue;
+               } // END - if
+
+               // Do we have 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)) {
+                               // NULL detected
+                               $SQL .= '`' . $entry . '`=NULL,';
+                       } 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 . '')  {
+                               // No need for ticks (')
+                               $SQL .= '`' . $entry . '`=' . $value . ',';
+                       } else {
+                               // Strings need ticks (') around them
+                               $SQL .= '`' . $entry . "`='" . SQL_ESCAPE($value) . "',";
+                       }
+               } else {
+                       // Handle multi-dimensional data
+                       if (is_null($value[$multiDimId])) {
+                               // NULL detected
+                               $SQL .= '`' . $entry . '`=NULL,';
+                       } 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] . ''))  {
+                               // No need for ticks (')
+                               $SQL .= '`' . $entry . '`=' . $value[$multiDimId] . ',';
+                       } else {
+                               // Strings need ticks (') around them
+                               $SQL .= '`' . $entry . "`='" . SQL_ESCAPE($value[$multiDimId]) . "',";
+                       }
+               }
+       } // END - foreach
+
+       // Remove last 2 chars and finish query
+       $SQL = substr($SQL, 0, -1) . ' WHERE `' . $whereColumn . '`=' . $whereData . ' LIMIT 1';
+
+       // Return SQL query
+       return $SQL;
+}
+
+// "Getter" for an "INSERT INTO" SQL query
+function getInsertSqlFromArray ($array, $tableName) {
+       // Init SQL
+       $SQL = 'INSERT INTO
+`{?_MYSQL_PREFIX?}_' . $tableName . '`
+(
+`' . implode('`,`', array_keys(postRequestArray())) . '`
+) VALUES (';
+
+       // Walk through all entries
+       foreach (postRequestArray() as $key => $value) {
+               // Log debug message
+               //* NOISY-DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'tableName=' . $tableName . ',key=' . $key . ',value=' . $value);
+
+               // Add all entries
+               if (is_null($value)) {
+                       // Add NULL
+                       $SQL .= 'NULL,';
+               } elseif (substr($value, -2, 2) == '()') {
+                       // SQL function needs no ticks (')
+                       $SQL .= SQL_ESCAPE($value) . ',';
+               } elseif ('' . bigintval($value, true, false) . '' == '' . $value . '') {
+                       // Number detected, no need for ticks (')
+                       $SQL .= bigintval($value) . ',';
+               } elseif ('' . (float) $value . '' == '' . $value . '') {
+                       // Float number detected
+                       $SQL .= sprintf('%01.5f', $value);
+               } else {
+                       // Everything else might be a string, so add ticks around it
+                       $SQL .= chr(39) . SQL_ESCAPE($value) . chr(39) . ',';
+               }
+       } // END - foreach
+
+       // Finish SQL query
+       $SQL = substr($SQL, 0, -1) . ')';
+
+       // Return SQL query
+       return $SQL;
+}
+
 // [EOF]
 ?>