2 /************************************************************************
3 * MXChange v0.2.1 Start: 11/28/2004 *
4 * =============== Last change: 11/28/2004 *
6 * -------------------------------------------------------------------- *
7 * File : load_cache.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Load more cache files *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Mehr Cache-Dateien nachladen *
12 * -------------------------------------------------------------------- *
14 * -------------------------------------------------------------------- *
15 * Copyright (c) 2003 - 2008 by Roland Haeder *
16 * For more information visit: http://www.mxchange.org *
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. *
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. *
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, *
32 ************************************************************************/
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";
40 // Let's start with the admins table...
41 if (($cacheInstance->cache_file("admins", true) == true)) {
44 $cacheArray['admins'] = $cacheInstance->cache_load();
47 if ((is_array($cacheArray['admins']['login'])) && (is_array($cacheArray['admins']['aid']))) {
49 if (count($cacheArray['admins']['login']) == count($cacheArray['admins']['aid'])) {
50 //* DEBUG: */ echo "<PRE>";
51 //* DEBUG: */ print_r($cacheArray['admins']);
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];
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];
68 //* DEBUG: */ print_r($cacheArray['admins']);
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]);
78 //* DEBUG: */ print_r($cacheArray['admins']);
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]);
88 //* DEBUG: */ echo "****\n";
89 //* DEBUG: */ print_r($cacheArray['admins']);
90 //* DEBUG: */ echo "</PRE>";
93 // Nope, cache file is corrupted!
94 $cacheInstance->cache_destroy();
97 // Nope, cache file is corrupted!
98 $cacheInstance->cache_destroy();
99 unset($cacheArray['admins']);
101 } elseif (($_CONFIG['cache_admins'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
103 $cacheInstance->cache_init("ADMINS");
105 // Load every data from DB to cache file
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";
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)) {
116 $cacheInstance->add_row($dummy);
120 SQL_FREERESULT($result_admins);
124 $cacheInstance->cache_close();
126 // Next cached table is the module registry (mod_reg)...
127 if ($cacheInstance->cache_file("mod_reg", true) == true) {
130 $cacheArray['modules'] = $cacheInstance->cache_load();
134 foreach ($cacheArray['modules'] as $k=>$array) {
135 $CNT += count($array);
138 // When there is a period (.) in the result this test will fail and so the cache file is
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']);
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]);
168 } elseif (($_CONFIG['cache_modreg'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
169 // Create cache file here
170 $cacheInstance->cache_init("MODULES");
172 // Load all modules and their data
173 if (GET_EXT_VERSION("sql_patches") >= "0.3.6") {
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__);
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__);
182 while ($DATA = SQL_FETCHARRAY($result)) {
183 // Add row to cache file
184 $cacheInstance->add_row($DATA);
188 SQL_FREERESULT($result);
192 $cacheInstance->cache_close();
194 // Next cached table is the configuration (config)...
195 if ($cacheInstance->cache_file("config", true) == true) {
196 // Load config from cache
198 $cacheArrayConfig = $cacheInstance->cache_load();
201 $CNT = 0; $newCache = array();
202 foreach ($cacheArrayConfig as $key=>$array) {
203 foreach ($array as $key2=>$value) {
204 $newCache[$key2][$key] = $value;
206 $CNT += count($array);
209 // Overwrite the config with the cache version
210 $cacheArray['config'] = $newCache;
212 // When there is a period (.) in the result this test will fail and so the cache file is
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']);
221 } elseif (($_CONFIG['cache_config'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
222 // Create cache file here
223 $cacheInstance->cache_init("CONFIG");
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);
233 SQL_FREERESULT($result);
237 $cacheInstance->cache_close();
239 // Next cached table is the referral system (refsystem)...
240 if ($cacheInstance->cache_file("refsystem", true) == true) {
241 // Load referral system from cache
243 $cacheArray['ref_system'] = $cacheInstance->cache_load();
247 foreach ($cacheArray['ref_system'] as $k=>$array) {
248 $CNT += count($array);
251 // When there is a period (.) in the result this test will fail and so the cache file is
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']);
260 } elseif (($_CONFIG['cache_refsys'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
261 // Create cache file here
262 $cacheInstance->cache_init("refsystem");
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);
272 SQL_FREERESULT($result);
276 $cacheInstance->cache_close();
278 // Next cached table is the referral system (refdepths)...
279 if ($cacheInstance->cache_file("refdepths", true) == true) {
280 // Load referral system from cache
282 $cacheArray['ref_depths'] = $cacheInstance->cache_load();
286 foreach ($cacheArray['ref_depths'] as $k=>$array) {
287 $CNT += count($array);
290 // When there is a period (.) in the result this test will fail and so the cache file is
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']);
299 } elseif (($_CONFIG['cache_refdepth'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
300 // Create cache file here
301 $cacheInstance->cache_init("REFDEPTHS");
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);
311 SQL_FREERESULT($result);
315 $cacheInstance->cache_close();
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
323 $cacheArray['admin_acls'] = $cacheInstance->cache_load();
327 foreach ($cacheArray['admin_acls'] as $k=>$array) {
328 $CNT += count($array);
331 // When there is a period (.) in the result this test will fail and so the cache file is
333 if (count($cacheArray['admin_acls']) > 0) {
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']);
342 } elseif (($_CONFIG['cache_acls'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
343 // Create cache file here
344 $cacheInstance->cache_init("ADMINS_ACLS");
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);
354 SQL_FREERESULT($result);
358 $cacheInstance->cache_close();