X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fmediadata_functions.php;h=b169e35efdcfa2639307731b8439f4e5cb456150;hb=ab5ff5126ef56b08f5130a9e110b53c00d0a2761;hp=617d69d38ccdedfa89acc8553bdc775bcb60b16f;hpb=2df9f7a53f8b1dd5164f87824a324ccb3b6634cb;p=mailer.git diff --git a/inc/libs/mediadata_functions.php b/inc/libs/mediadata_functions.php index 617d69d38c..b169e35efd 100644 --- a/inc/libs/mediadata_functions.php +++ b/inc/libs/mediadata_functions.php @@ -16,7 +16,7 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2012 by Mailer Developer Team * + * Copyright (c) 2009 - 2013 by Mailer Developer Team * * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -44,24 +44,24 @@ if (!defined('__SECURITY')) { function updateMediadataEntry ($keys_array, $mode, $value) { //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'keys_array[]=' . gettype($keys_array) . ',mode=' . $mode . ',value=' . $value . ' - ENTERED!'); // Default is nothing added/updated - $added = false; + $added = FALSE; // Are there entries? - if (is_array($keys_array) && ($value > 0)) { + if (isFilledArray($keys_array) && ($value > 0)) { // Is an array so we can run it through foreach ($keys_array as $key) { // First check if it does exist - $result_media = SQL_QUERY_ESC("SELECT + $result_media = sqlQueryEscaped("SELECT `media_key` FROM `{?_MYSQL_PREFIX?}_mediadata` WHERE `media_key`='%s' LIMIT 1", array($key), __FUNCTION__, __LINE__); - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'key=' . $key . ',SQL_NUMROWS()=' . SQL_NUMROWS($result_media)); - if (SQL_NUMROWS($result_media) == 0) { + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'key=' . $key . ',sqlNumRows()=' . sqlNumRows($result_media)); + if (sqlNumRows($result_media) == 0) { // Not found so we create it (mode will be ignored here!) - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_mediadata` (`media_key`, `media_value`) VALUES ('%s', '%s')", + sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_mediadata` (`media_key`, `media_value`) VALUES ('%s', '%s')", array($key, $value), __FUNCTION__, __LINE__); } else { // Update entry @@ -72,17 +72,17 @@ LIMIT 1", array($key), __FUNCTION__, __LINE__); if ($mode == 'init') { // Initialize entry - SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_mediadata` SET `media_value`=%s WHERE `media_key`='%s' LIMIT 1", + sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_mediadata` SET `media_value`=%s WHERE `media_key`='%s' LIMIT 1", array($value, $key), __FUNCTION__, __LINE__); } else { // Update entry - SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_mediadata` SET `media_value`=`media_value`".$mode."%s WHERE `media_key`='%s' LIMIT 1", + sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_mediadata` SET `media_value`=`media_value`".$mode."%s WHERE `media_key`='%s' LIMIT 1", array($value, $key), __FUNCTION__, __LINE__); } } //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'added=' . intval($added)); - $added = (!SQL_HASZEROAFFECTED()); + $added = (!ifSqlHasZeroAffectedRows()); //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'added=' . intval($added)); } // END - foreach } // END - if @@ -90,7 +90,7 @@ LIMIT 1", array($key), __FUNCTION__, __LINE__); // Zero entries are always added if ($value == 0) { // Is zero value, so we need to set $added here to avoid wrong false result - $added = true; + $added = TRUE; } // END - if // Return result @@ -104,18 +104,46 @@ function getMediadataEntry ($key) { $value = ''; // Check for entry - $result = SQL_QUERY_ESC("SELECT `media_value` FROM `{?_MYSQL_PREFIX?}_mediadata` WHERE `media_key`='%s' LIMIT 1", + $result = sqlQueryEscaped("SELECT `media_value` FROM `{?_MYSQL_PREFIX?}_mediadata` WHERE `media_key`='%s' LIMIT 1", array($key), __FUNCTION__, __LINE__); // Is there one? - if (SQL_NUMROWS($result) == 1) { + if (sqlNumRows($result) == 1) { // Load data - list($value) = SQL_FETCHROW($result); + list($value) = sqlFetchRow($result); } // END - if // Return data return $value; } +// ---------------------------------------------------------------------------- +// Wrapper functions for configuration entries +// ---------------------------------------------------------------------------- + +// Getter for 'mt_start' +function getMtStart () { + // Is the cache entry set? + if (!isset($GLOBALS[__FUNCTION__])) { + // No, so determine it + $GLOBALS[__FUNCTION__] = getConfig('mt_start'); + } // END - if + + // Return cached entry + return $GLOBALS[__FUNCTION__]; +} + +// Getter for 'mt_stage' +function getMtStage () { + // Is the cache entry set? + if (!isset($GLOBALS[__FUNCTION__])) { + // No, so determine it + $GLOBALS[__FUNCTION__] = getConfig('mt_stage'); + } // END - if + + // Return cached entry + return $GLOBALS[__FUNCTION__]; +} + // [EOF] ?>