2 /************************************************************************
3 * Mailer v0.2.1-FINAL Start: 07/31/2011 *
4 * =================== Last change: 07/31/2011 *
6 * -------------------------------------------------------------------- *
7 * File : load-points_data.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Load more cache files *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Mehr Cache-Dateien nachladen *
12 * -------------------------------------------------------------------- *
15 * $Tag:: 0.2.1-FINAL $ *
17 * -------------------------------------------------------------------- *
18 * Copyright (c) 2003 - 2009 by Roland Haeder *
19 * Copyright (c) 2009 - 2013 by Mailer Developer Team *
20 * For more information visit: http://mxchange.org *
22 * This program is free software; you can redistribute it and/or modify *
23 * it under the terms of the GNU General Public License as published by *
24 * the Free Software Foundation; either version 2 of the License, or *
25 * (at your option) any later version. *
27 * This program is distributed in the hope that it will be useful, *
28 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
29 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
30 * GNU General Public License for more details. *
32 * You should have received a copy of the GNU General Public License *
33 * along with this program; if not, write to the Free Software *
34 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
36 ************************************************************************/
38 // Some security stuff...
39 if (!defined('__SECURITY')) {
41 } elseif (isInstaller()) {
42 // Do not run in installation phase
43 //* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'Run from installation phase.');
45 } elseif (!isExtensionInstalledAndNewer('sql_patches', '0.8.0')) {
46 // Is not installed or recent enough
50 // Let's start with the admins table...
51 if (($GLOBALS['cache_instance']->loadCacheFile('points_data')) && ($GLOBALS['cache_instance']->extensionVersionMatches('sql_patches'))) {
53 $GLOBALS['cache_array']['points_data'] = $GLOBALS['cache_instance']->getArrayFromCache();
56 if (!isset($GLOBALS['cache_array']['points_data']['subject'])) {
57 // Try to remove the cache file
58 $GLOBALS['cache_instance']->removeCacheFile();
60 // Not found, so better abort here
61 reportBug(__FILE__, __LINE__, 'points_data has been generated, but does not contain "subject". Please try to reload to fix this.');
64 // Init temporary array
65 $pointsData = array();
67 // Rewrite all to subject
68 foreach ($GLOBALS['cache_array']['points_data']['subject'] as $key => $subject) {
69 // Re-add key with subject
70 foreach ($GLOBALS['cache_array']['points_data'] as $key2 => $array) {
71 // Is key2 not 'subject'?
72 if ($key2 != 'subject') {
74 $pointsData[$subject][$key2] = $GLOBALS['cache_array']['points_data'][$key2][$key];
79 // Set the array back and remove temporary
80 $GLOBALS['cache_array']['points_data'] = $pointsData;
82 } elseif (((isHtmlOutputMode()) || (isAjaxOutputMode()) || (isRawOutputMode())) && (isExtensionInstalledAndNewer('sql_patches', '0.8.6'))) {
84 $GLOBALS['cache_instance']->init();
86 // Query the database about this
87 $result = sqlQuery('SELECT * FROM `{?_MYSQL_PREFIX?}_points_data` ORDER BY `id` ASC', __FILE__, __LINE__);
88 while ($data = sqlFetchArray($result)) {
90 $GLOBALS['cache_instance']->addRow($data);
94 sqlFreeResult($result);
97 $GLOBALS['cache_instance']->storeExtensionVersion('sql_patches');
98 $GLOBALS['cache_instance']->finalize();