Referal levels for surfbar added (unfinished)
[mailer.git] / inc / load_cache.php
1 <?php
2 /************************************************************************
3  * MXChange v0.2.1                                    Start: 11/28/2004 *
4  * ===============                              Last change: 11/28/2004 *
5  *                                                                      *
6  * -------------------------------------------------------------------- *
7  * File              : load_cache.php                                   *
8  * -------------------------------------------------------------------- *
9  * Short description : Load more cache files                            *
10  * -------------------------------------------------------------------- *
11  * Kurzbeschreibung  : Mehr Cache-Dateien nachladen                     *
12  * -------------------------------------------------------------------- *
13  *                                                                      *
14  * -------------------------------------------------------------------- *
15  * Copyright (c) 2003 - 2008 by Roland Haeder                           *
16  * For more information visit: http://www.mxchange.org                  *
17  *                                                                      *
18  * This program is free software; you can redistribute it and/or modify *
19  * it under the terms of the GNU General Public License as published by *
20  * the Free Software Foundation; either version 2 of the License, or    *
21  * (at your option) any later version.                                  *
22  *                                                                      *
23  * This program is distributed in the hope that it will be useful,      *
24  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
26  * GNU General Public License for more details.                         *
27  *                                                                      *
28  * You should have received a copy of the GNU General Public License    *
29  * along with this program; if not, write to the Free Software          *
30  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
31  * MA  02110-1301  USA                                                  *
32  ************************************************************************/
33
34 // Some security stuff...
35 if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) {
36         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
37         require($INC);
38 }
39
40 // Let's start with the admins table...
41 if (($cacheInstance->cache_file("admins", true) == true)) {
42         // Load cache
43         global $cacheArray;
44         $cacheArray['admins'] = $cacheInstance->cache_load();
45
46         // Check if valid
47         if ((is_array($cacheArray['admins']['login'])) && (is_array($cacheArray['admins']['aid']))) {
48                 // Check count
49                 if (count($cacheArray['admins']['login']) == count($cacheArray['admins']['aid'])) {
50                         //* DEBUG: */ echo "<PRE>";
51                         //* DEBUG: */ print_r($cacheArray['admins']);
52
53                         // The cache file seems to be fine
54                         foreach ($cacheArray['admins']['login'] as $k=>$login) {
55                                 // Rewrite default_acl
56                                 $cacheArray['admins']['aid'][$login]      = $cacheArray['admins']['aid'][$k];
57                                 $cacheArray['admins']['password'][$login] = $cacheArray['admins']['password'][$k];
58                                 $cacheArray['admins']['email'][$login]    = $cacheArray['admins']['email'][$k];
59
60                                 // Some extra data depening on version
61                                 if (GET_EXT_VERSION("admins") >= "0.3") {
62                                         $cacheArray['admins']['def_acl'][$login]  = $cacheArray['admins']['def_acl'][$k];
63                                         if (GET_EXT_VERSION("admins") >= "0.6.7") {
64                                                 $cacheArray['admins']['la_mode'][$login]  = $cacheArray['admins']['la_mode'][$k];
65                                         }
66                                 }
67
68                                 //* DEBUG: */ print_r($cacheArray['admins']);
69
70                                 // Clear array
71                                 if (isset($cacheArray['admins']['aid'][$k]))            unset($cacheArray['admins']['aid'][$k]);
72                                 if (isset($cacheArray['admins']['def_acl'][$k]))        unset($cacheArray['admins']['def_acl'][$k]);
73                                 if (isset($cacheArray['admins']['la_mode'][$k]))        unset($cacheArray['admins']['la_mode'][$k]);
74                                 if (isset($cacheArray['admins']['password'][$k]))       unset($cacheArray['admins']['password'][$k]);
75                                 if (isset($cacheArray['admins']['email'][$k]))  unset($cacheArray['admins']['email'][$k]);
76                         }
77
78                         //* DEBUG: */ print_r($cacheArray['admins']);
79
80                         // Rewrite Login
81                         foreach ($cacheArray['admins']['login'] as $k=>$login) {
82                                 $cacheArray['admins']['login'][$cacheArray['admins']['aid'][$login]] = $login;
83                                 if (!in_array($k, $cacheArray['admins']['aid'])) {
84                                         unset($cacheArray['admins']['login'][$k]);
85                                 }
86                         }
87
88                         //* DEBUG: */ echo "****\n";
89                         //* DEBUG: */ print_r($cacheArray['admins']);
90                         //* DEBUG: */ echo "</PRE>";
91                         //* DEBUG: */ die();
92                 } else {
93                         // Nope, cache file is corrupted!
94                         $cacheInstance->cache_destroy();
95                 }
96         } else {
97                 // Nope, cache file is corrupted!
98                 $cacheInstance->cache_destroy();
99                 unset($cacheArray['admins']);
100         }
101 } elseif (($_CONFIG['cache_admins'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
102         // Create cache file
103         $cacheInstance->cache_init("ADMINS");
104
105         // Load every data from DB to cache file
106         $ADD = ", id, id";
107         if (GET_EXT_VERSION("admins") >= "0.3")   $ADD  = ", default_acl AS def_acl";
108         if (GET_EXT_VERSION("admins") >= "0.6.7") $ADD .= ", la_mode";
109
110         // Query the database about this
111         $result_admins = SQL_QUERY("SELECT id AS aid, login, password, email".$ADD."
112 FROM "._MYSQL_PREFIX."_admins
113 ORDER BY login", __FILE__, __LINE__);
114         while($dummy = SQL_FETCHARRAY($result_admins)) {
115                 // Save row
116                 $cacheInstance->add_row($dummy);
117         }
118
119         // Free memory
120         SQL_FREERESULT($result_admins);
121 }
122
123 // Close file
124 $cacheInstance->cache_close();
125
126 // Next cached table is the module registry (mod_reg)...
127 if ($cacheInstance->cache_file("mod_reg", true) == true) {
128         // Load cache
129         global $cacheArray;
130         $cacheArray['modules'] = $cacheInstance->cache_load();
131
132         // Valid cache file
133         $CNT = 0;
134         foreach ($cacheArray['modules'] as $k=>$array) {
135                 $CNT += count($array);
136         }
137
138         // When there is a period (.) in the result this test will fail and so the cache file is
139         // damaged/corrupted
140         $TEST = "failed";
141         if (count($cacheArray['modules']) > 0 ) $TEST = ($CNT / (count($cacheArray['modules'])));
142         if ($TEST != bigintval($TEST)) {
143                 // Cache file is corrupted!
144                 $cacheInstance->cache_destroy();
145                 unset($cacheArray['modules']);
146         } else {
147                 // Rewrite module cache
148                 $MOD = $cacheArray['modules'];
149                 foreach ($cacheArray['modules']['module'] as $key=>$mod) {
150                         $cacheArray['modules']['id'][$mod] = $cacheArray['modules']['id'][$key];
151                         unset($cacheArray['modules']['id'][$key]);
152                         $cacheArray['modules']['title'][$mod] = $cacheArray['modules']['title'][$key];
153                         unset($cacheArray['modules']['title'][$key]);
154                         $cacheArray['modules']['locked'][$mod] = $cacheArray['modules']['locked'][$key];
155                         unset($cacheArray['modules']['locked'][$key]);
156                         $cacheArray['modules']['hidden'][$mod] = $cacheArray['modules']['hidden'][$key];
157                         unset($cacheArray['modules']['hidden'][$key]);
158                         $cacheArray['modules']['admin_only'][$mod] = $cacheArray['modules']['admin_only'][$key];
159                         unset($cacheArray['modules']['admin_only'][$key]);
160                         $cacheArray['modules']['mem_only'][$mod] = $cacheArray['modules']['mem_only'][$key];
161                         unset($cacheArray['modules']['mem_only'][$key]);
162                         if (isset($cacheArray['modules']['has_menu'][$key])) {
163                                 $cacheArray['modules']['has_menu'][$mod] = $cacheArray['modules']['has_menu'][$key];
164                                 unset($cacheArray['modules']['has_menu'][$key]);
165                         } // END - if
166                 }
167         }
168 } elseif (($_CONFIG['cache_modreg'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
169         // Create cache file here
170         $cacheInstance->cache_init("MODULES");
171
172         // Load all modules and their data
173         if (GET_EXT_VERSION("sql_patches") >= "0.3.6") {
174                 // Load has_menu
175                 $result = SQL_QUERY("SELECT id, module, title, locked, hidden, admin_only, title, mem_only, has_menu
176 FROM "._MYSQL_PREFIX."_mod_reg ORDER BY id", __FILE__, __LINE__);
177         } else {
178                 // Don't load has_menu
179                 $result = SQL_QUERY("SELECT id, module, title, locked, hidden, admin_only, title, mem_only
180 FROM "._MYSQL_PREFIX."_mod_reg ORDER BY id", __FILE__, __LINE__);
181         }
182         while ($DATA = SQL_FETCHARRAY($result)) {
183                 // Add row to cache file
184                 $cacheInstance->add_row($DATA);
185         }
186
187         // Free memory
188         SQL_FREERESULT($result);
189 }
190
191 // Close file
192 $cacheInstance->cache_close();
193
194 // Next cached table is the configuration (config)...
195 if ($cacheInstance->cache_file("config", true) == true) {
196         // Load config from cache
197         global $cacheArray;
198         $cacheArrayConfig = $cacheInstance->cache_load();
199
200         // Valid cache file
201         $CNT = 0; $newCache = array();
202         foreach ($cacheArrayConfig as $key=>$array) {
203                 foreach ($array as $key2=>$value) {
204                         $newCache[$key2][$key] = $value;
205                 }
206                 $CNT += count($array);
207         }
208
209         // Overwrite the config with the cache version
210         $cacheArray['config'] = $newCache;
211
212         // When there is a period (.) in the result this test will fail and so the cache file is
213         // damaged/corrupted
214         $TEST = "failed";
215         if (count($cacheArray['config']) > 0 ) $TEST = ($CNT / (count($cacheArray['config'])));
216         if ($TEST != bigintval($TEST)) {
217                 // Cache file is corrupted!
218                 $cacheInstance->cache_destroy();
219                 unset($cacheArray['config']);
220         }
221 } elseif (($_CONFIG['cache_config'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
222         // Create cache file here
223         $cacheInstance->cache_init("CONFIG");
224
225         // Load all modules and their data
226         $result = SQL_QUERY("SELECT * FROM "._MYSQL_PREFIX."_config ORDER BY config", __FILE__, __LINE__);
227         while ($DATA = SQL_FETCHARRAY($result)) {
228                 // Add row to cache file
229                 $cacheInstance->add_row($DATA);
230         }
231
232         // Free memory
233         SQL_FREERESULT($result);
234 }
235
236 // Close file
237 $cacheInstance->cache_close();
238
239 // Next cached table is the referral system (refsystem)...
240 if ($cacheInstance->cache_file("refsystem", true) == true) {
241         // Load referral system from cache
242         global $cacheArray;
243         $cacheArray['ref_system'] = $cacheInstance->cache_load();
244
245         // Valid cache file
246         $CNT = 0;
247         foreach ($cacheArray['ref_system'] as $k=>$array) {
248                 $CNT += count($array);
249         }
250
251         // When there is a period (.) in the result this test will fail and so the cache file is
252         // damaged/corrupted
253         $TEST = "failed";
254         if (count($cacheArray['ref_system']) > 0 ) $TEST = ($CNT / (count($cacheArray['ref_system'])));
255         if ($TEST != bigintval($TEST)) {
256                 // Cache file is corrupted!
257                 $cacheInstance->cache_destroy();
258                 unset($cacheArray['ref_system']);
259         }
260 } elseif (($_CONFIG['cache_refsys'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
261         // Create cache file here
262         $cacheInstance->cache_init("refsystem");
263
264         // Load all modules and their data
265         $result = SQL_QUERY("SELECT id, userid, level, counter FROM "._MYSQL_PREFIX."_refsystem ORDER BY userid, level", __FILE__, __LINE__);
266         while ($DATA = SQL_FETCHARRAY($result)) {
267                 // Add row to cache file
268                 $cacheInstance->add_row($DATA);
269         }
270
271         // Free memory
272         SQL_FREERESULT($result);
273 }
274
275 // Close file
276 $cacheInstance->cache_close();
277
278 // Next cached table is the referral system (refdepths)...
279 if ($cacheInstance->cache_file("refdepths", true) == true) {
280         // Load referral system from cache
281         global $cacheArray;
282         $cacheArray['ref_depths'] = $cacheInstance->cache_load();
283
284         // Valid cache file
285         $CNT = 0;
286         foreach ($cacheArray['ref_depths'] as $k=>$array) {
287                 $CNT += count($array);
288         }
289
290         // When there is a period (.) in the result this test will fail and so the cache file is
291         // damaged/corrupted
292         $TEST = "failed";
293         if (count($cacheArray['ref_depths']) > 0 ) $TEST = ($CNT / (count($cacheArray['ref_depths'])));
294         if ($TEST != bigintval($TEST)) {
295                 // Cache file is corrupted!
296                 $cacheInstance->cache_destroy();
297                 unset($cacheArray['ref_depths']);
298         }
299 } elseif (($_CONFIG['cache_refdepth'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
300         // Create cache file here
301         $cacheInstance->cache_init("REFDEPTHS");
302
303         // Load all modules and their data
304         $result = SQL_QUERY("SELECT id, level, percents FROM "._MYSQL_PREFIX."_refdepths ORDER BY level", __FILE__, __LINE__);
305         while ($DATA = SQL_FETCHARRAY($result)) {
306                 // Add row to cache file
307                 $cacheInstance->add_row($DATA);
308         }
309
310         // Free memory
311         SQL_FREERESULT($result);
312 }
313
314 // Close file
315 $cacheInstance->cache_close();
316
317 // Next cached table is the referral system (admins_acls)...
318 if (GET_EXT_VERSION("admins") >= "0.3") {
319         // Check for cache file
320         if ($cacheInstance->cache_file("admins_acls", true) == true) {
321                 // Load referral system from cache
322                 global $cacheArray;
323                 $cacheArray['admin_acls'] = $cacheInstance->cache_load();
324
325                 // Valid cache file
326                 $CNT = 0;
327                 foreach ($cacheArray['admin_acls'] as $k=>$array) {
328                         $CNT += count($array);
329                 }
330
331                 // When there is a period (.) in the result this test will fail and so the cache file is
332                 // damaged/corrupted
333                 if (count($cacheArray['admin_acls']) > 0) {
334                         $TEST = "failed";
335                         if (count($cacheArray['admin_acls']) > 0 ) $TEST = ($CNT / (count($cacheArray['admin_acls'])));
336                         if ($TEST != bigintval($TEST)) {
337                                 // Cache file is corrupted!
338                                 $cacheInstance->cache_destroy();
339                                 unset($cacheArray['admin_acls']);
340                         }
341                 }
342         } elseif (($_CONFIG['cache_acls'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
343                 // Create cache file here
344                 $cacheInstance->cache_init("ADMINS_ACLS");
345
346                 // Load all modules and their data
347                 $result = SQL_QUERY("SELECT id, admin_id, action_menu, what_menu, access_mode FROM "._MYSQL_PREFIX."_admins_acls ORDER BY admin_id, action_menu, what_menu", __FILE__, __LINE__);
348                 while ($DATA = SQL_FETCHARRAY($result)) {
349                         // Add row to cache file
350                         $cacheInstance->add_row($DATA);
351                 }
352
353                 // Free memory
354                 SQL_FREERESULT($result);
355         }
356
357         // Close file
358         $cacheInstance->cache_close();
359 }
360
361 //
362 ?>