2 /************************************************************************
3 * Mailer v0.2.1-FINAL Start: 10/25/2009 *
4 * =================== Last change: 10/25/2009 *
6 * -------------------------------------------------------------------- *
7 * File : stats-functions.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Automatical purging of outdated mail links *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Auto-Loeschung von veralteten Mail-Links *
12 * -------------------------------------------------------------------- *
15 * $Tag:: 0.2.1-FINAL $ *
17 * Needs to be in all Files and every File needs "svn propset *
18 * svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
19 * -------------------------------------------------------------------- *
20 * Copyright (c) 2003 - 2009 by Roland Haeder *
21 * Copyright (c) 2009, 2010 by Mailer Developer Team *
22 * For more information visit: http://www.mxchange.org *
24 * This program is free software; you can redistribute it and/or modify *
25 * it under the terms of the GNU General Public License as published by *
26 * the Free Software Foundation; either version 2 of the License, or *
27 * (at your option) any later version. *
29 * This program is distributed in the hope that it will be useful, *
30 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
31 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
32 * GNU General Public License for more details. *
34 * You should have received a copy of the GNU General Public License *
35 * along with this program; if not, write to the Free Software *
36 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
38 ************************************************************************/
40 // Some security stuff...
41 if (!defined('__SECURITY')) {
46 function initStatsSystem () {
47 // Is stats cache loaded?
48 if ((!isset($GLOBALS['stats_loaded'])) && (getConfig('STATS_ENABLED') == 'Y')) {
49 // Init statistics array
50 $GLOBALS['stats'] = array();
52 // Load statistics entry from temporary table
56 $GLOBALS['stats_loaded'] = true;
60 // Checks if we have a statistics entry
61 function isStatsEntrySet ($entry) {
62 // Do we have the entry?
63 return (isset($GLOBALS['stats'][$entry]));
66 // Increments a statistics entry
67 function incrementStatsEntry ($entry, $amount=1) {
68 // Do we have stats enabled?
69 if (getConfig('STATS_ENABLED') != 'Y') return;
72 if (isStatsEntrySet($entry)) {
74 $GLOBALS['stats'][$entry] += $amount;
77 $GLOBALS['stats'][$entry] = $amount;
82 function getStatsEntry ($entry) {
87 if (isStatsEntrySet($entry)) {
89 $stats = $GLOBALS['stats'][$entry];
97 function setStatsEntry ($entry, $value) {
98 $GLOBALS['stats'][$entry] = $value;
102 function loadStatsTable () {
103 // Check if the link is up
104 if (!SQL_IS_LINK_UP()) return false;
106 // Do we have it there for today?
107 if (!isStatsTableCreated()) {
108 // Then create a default one
112 // Load it from database
113 $result = SQL_QUERY_ESC("SELECT `stats_entry`,`stats_value` FROM `{?_MYSQL_PREFIX?}_stats_%s` ORDER BY `stats_entry` ASC",
114 array(date('Ymd', time())), __FUNCTION__, __LINE__);
117 while ($row = SQL_FETCHARRAY($result)) {
118 $GLOBALS['stats'][$row['stats_entry']] = $row['stats_value'];
122 SQL_FREERESULT($result);
125 // Checks if the the statistics table is created
126 function isStatsTableCreated () {
127 // Check if the link is up
128 if (!SQL_IS_LINK_UP()) return false;
131 $result = SQL_QUERY_ESC("SHOW TABLES LIKE '{?_MYSQL_PREFIX?}_stats_%s'",
132 array(date('Ymd', time())), __FUNCTION__, __LINE__);
135 return SQL_NUMROWS($result);
138 // Create the dummy table
139 function createStatsTable () {
140 // Check if the link is up
141 if (!SQL_IS_LINK_UP()) return false;
144 $result = SQL_QUERY_ESC("CREATE TABLE IF NOT EXISTS `{?_MYSQL_PREFIX?}_stats_%s` (
145 `stats_entry` VARCHAR(100) NOT NULL DEFAULT '',
146 `stats_value` BIGINT(20) NOT NULL DEFAULT 0,
147 PRIMARY KEY (`stats_entry`)
148 ) TYPE=HEAP COMMENT='Temporary statistics table'",
149 array(date('Ymd', time())), __FUNCTION__, __LINE__);
152 // Write all entries to the table
153 function writeStatsTable () {
154 // Check if the link is up
155 if (!SQL_IS_LINK_UP()) return false;
157 // Empty the table first
158 SQL_QUERY_ESC("TRUNCATE `{?_MYSQL_PREFIX?}_stats_%s`",
159 array(date('Ymd', time())), __FUNCTION__, __LINE__);
161 // Begin the SQL command
162 $sql = sprintf("REPLACE INTO `{?_MYSQL_PREFIX?}_stats_%s` (`stats_entry`,`stats_value`) VALUES ",
163 date('Ymd', time()));
165 // Add all entries to the final query
166 foreach ($GLOBALS['stats'] as $entry => $value) {
167 $sql .= sprintf("('%s', %s),", $entry, bigintval($value));
170 // Finalize it and run it
171 SQL_QUERY(substr($sql, 0, -1), __FUNCTION__, __LINE__);
174 // Filter for flushing statistics
175 function FILTER_FLUSH_STATS () {
176 // Now do we have stats?
177 if ((isset($GLOBALS['stats'])) && (!isInstallationPhase()) && (getConfig('STATS_ENABLED') == 'Y')) {
178 // Write statistics to temporary table