X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fstats-functions.php;h=b4fd58326db00066c8d41ddd3f656c3b5b65d60a;hp=149e6820f27625f693398d028a52d53d1b07813a;hb=6dcb879ba3abb21843503cacc65d1fe0848eb90f;hpb=74b7fbc5030bb2938a9859020876da63e6d15c0b diff --git a/inc/stats-functions.php b/inc/stats-functions.php index 149e6820f2..b4fd58326d 100644 --- a/inc/stats-functions.php +++ b/inc/stats-functions.php @@ -10,13 +10,8 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Auto-Loeschung von veralteten Mail-Links * * -------------------------------------------------------------------- * - * $Revision:: $ * - * $Date:: $ * - * $Tag:: 0.2.1-FINAL $ * - * $Author:: $ * - * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2012 by Mailer Developer Team * + * Copyright (c) 2009 - 2016 by Mailer Developer Team * * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -102,7 +97,7 @@ function setStatsEntry ($entry, $value) { // Loads stats table function loadStatsTable () { // Check if the link is up - if (!SQL_IS_LINK_UP()) return FALSE; + if (!isSqlLinkUp()) return FALSE; // Is it there for today? if (!isStatsTableCreated()) { @@ -111,40 +106,40 @@ function loadStatsTable () { } // END - if // Load it from database - $result = SQL_QUERY_ESC("SELECT `stats_entry`, `stats_value` FROM `{?_MYSQL_PREFIX?}_stats_%s` ORDER BY `stats_entry` ASC", + $result = sqlQueryEscaped("SELECT `stats_entry`, `stats_value` FROM `{?_MYSQL_PREFIX?}_stats_%s` ORDER BY `stats_entry` ASC", array( generateDateTime(time(), '6') ), __FUNCTION__, __LINE__); // Read all rows - while ($row = SQL_FETCHARRAY($result)) { + while ($row = sqlFetchArray($result)) { $GLOBALS['stats'][$row['stats_entry']] = $row['stats_value']; } // END - while // Free the result - SQL_FREERESULT($result); + sqlFreeResult($result); } // Checks if the the statistics table is created function isStatsTableCreated () { // Check if the link is up - if (!SQL_IS_LINK_UP()) return FALSE; + if (!isSqlLinkUp()) return FALSE; // Ask for it - $result = SQL_QUERY_ESC("SHOW TABLES LIKE '{?_MYSQL_PREFIX?}_stats_%s'", + $result = sqlQueryEscaped("SHOW TABLES LIKE '{?_MYSQL_PREFIX?}_stats_%s'", array(generateDateTime(time(), '6')), __FUNCTION__, __LINE__); // Is there a row? - return SQL_NUMROWS($result); + return sqlNumRows($result); } // Create the dummy table function createStatsTable () { // Check if the link is up - if (!SQL_IS_LINK_UP()) return FALSE; + if (!isSqlLinkUp()) return FALSE; // Create it here - $result = SQL_QUERY_ESC("CREATE TEMPORARY TABLE IF NOT EXISTS `{?_MYSQL_PREFIX?}_stats_%s` ( + $result = sqlQueryEscaped("CREATE TEMPORARY TABLE IF NOT EXISTS `{?_MYSQL_PREFIX?}_stats_%s` ( `stats_entry` VARCHAR(100) NOT NULL DEFAULT '', `stats_value` BIGINT(20) NOT NULL DEFAULT 0, PRIMARY KEY (`stats_entry`) @@ -155,14 +150,14 @@ PRIMARY KEY (`stats_entry`) // Write all entries to the table function writeStatsTable () { // Check if the link is up - if (!SQL_IS_LINK_UP()) return FALSE; + if (!isSqlLinkUp()) return FALSE; // Empty the table first - SQL_QUERY_ESC("TRUNCATE `{?_MYSQL_PREFIX?}_stats_%s`", + sqlQueryEscaped('TRUNCATE `{?_MYSQL_PREFIX?}_stats_%s`', array(generateDateTime(time(), '6')), __FUNCTION__, __LINE__); // Begin the SQL command - $sql = sprintf("REPLACE INTO `{?_MYSQL_PREFIX?}_stats_%s` (`stats_entry`, `stats_value`) VALUES ", + $sql = sprintf('REPLACE INTO `{?_MYSQL_PREFIX?}_stats_%s` (`stats_entry`, `stats_value`) VALUES ', generateDateTime(time(), '6')); // Add all entries to the final query @@ -171,13 +166,13 @@ function writeStatsTable () { } // END - foreach // Finalize it and run it - SQL_QUERY(substr($sql, 0, -1), __FUNCTION__, __LINE__); + sqlQuery(substr($sql, 0, -1), __FUNCTION__, __LINE__); } // Filter for flushing statistics function FILTER_FLUSH_STATS () { // Now do we have stats? - if ((isset($GLOBALS['stats'])) && (!isInstallationPhase()) && (ifInternalStatsEnabled())) { + if ((isset($GLOBALS['stats'])) && (!isInstaller()) && (ifInternalStatsEnabled())) { // Write statistics to temporary table writeStatsTable();