2 /************************************************************************
\r
3 * MXChange v0.2.1 Start: 11/28/2004 *
\r
4 * =============== Last change: 11/28/2004 *
\r
6 * -------------------------------------------------------------------- *
\r
7 * File : load_cache.php *
\r
8 * -------------------------------------------------------------------- *
\r
9 * Short description : Load more cache files *
\r
10 * -------------------------------------------------------------------- *
\r
11 * Kurzbeschreibung : Mehr Cache-Dateien nachladen *
\r
12 * -------------------------------------------------------------------- *
\r
14 * -------------------------------------------------------------------- *
\r
15 * Copyright (c) 2003 - 2007 by Roland Haeder *
\r
16 * For more information visit: http://www.mxchange.org *
\r
18 * This program is free software; you can redistribute it and/or modify *
\r
19 * it under the terms of the GNU General Public License as published by *
\r
20 * the Free Software Foundation; either version 2 of the License, or *
\r
21 * (at your option) any later version. *
\r
23 * This program is distributed in the hope that it will be useful, *
\r
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
\r
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
\r
26 * GNU General Public License for more details. *
\r
28 * You should have received a copy of the GNU General Public License *
\r
29 * along with this program; if not, write to the Free Software *
\r
30 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
\r
31 * MA 02110-1301 USA *
\r
32 ************************************************************************/
\r
34 // Some security stuff...
\r
35 if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))
\r
37 $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";
\r
41 // Let's start with the admins table...
\r
42 if (($CACHE->cache_file("admins", true) == true))
\r
46 $ADMINS = $CACHE->cache_load();
\r
49 if (is_array($ADMINS['login']) && is_array($ADMINS['def_acl']) && is_array($ADMINS['aid']))
\r
52 if (count($ADMINS['login']) == count($ADMINS['aid']) && count($ADMINS['login']) == count($ADMINS['def_acl']) && count($ADMINS['aid']) == count($ADMINS['def_acl']))
\r
54 //* DEBUG: */ echo "<PRE>";
\r
55 //* DEBUG: */ print_r($ADMINS);
\r
57 // The cache file seems to be fine
\r
58 foreach ($ADMINS['login'] as $k=>$login)
\r
60 // Rewrite default_acl
\r
61 $ADMINS['aid'][$login] = $ADMINS['aid'][$k];
\r
62 $ADMINS['password'][$login] = $ADMINS['password'][$k];
\r
63 $ADMINS['email'][$login] = $ADMINS['email'][$k];
\r
65 // Some extra data depening on version
\r
66 if (GET_EXT_VERSION("admins") >= "0.3")
\r
68 $ADMINS['def_acl'][$login] = $ADMINS['def_acl'][$k];
\r
69 if (GET_EXT_VERSION("admins") >= "0.6.7")
\r
71 $ADMINS['la_mode'][$login] = $ADMINS['la_mode'][$k];
\r
75 //* DEBUG: */ print_r($ADMINS);
\r
78 unset($ADMINS['aid'][$k]);
\r
79 unset($ADMINS['def_acl'][$k]);
\r
80 unset($ADMINS['la_mode'][$k]);
\r
81 unset($ADMINS['password'][$k]);
\r
82 unset($ADMINS['email'][$k]);
\r
85 //* DEBUG: */ print_r($ADMINS);
\r
88 foreach ($ADMINS['login'] as $k=>$login)
\r
90 $ADMINS['login'][$ADMINS['aid'][$login]] = $login;
\r
91 if (!in_array($k, $ADMINS['aid']))
\r
93 unset($ADMINS['login'][$k]);
\r
97 //* DEBUG: */ echo "****\n";
\r
98 //* DEBUG: */ print_r($ADMINS);
\r
99 //* DEBUG: */ echo "</PRE>";
\r
100 //* DEBUG: */ die();
\r
104 // Nope, cache file is corrupted!
\r
105 $CACHE->cache_destroy();
\r
110 // Nope, cache file is corrupted!
\r
111 $CACHE->cache_destroy();
\r
115 elseif (($CONFIG['cache_admins'] == "Y") && ($CSS != "1") && ($CSS != "-1"))
\r
117 // Create cache file
\r
118 $CACHE->cache_init("ADMINS");
\r
120 // Load every data from DB to cache file
\r
122 if (GET_EXT_VERSION("admins") >= "0.3") $ADD = ", default_acl AS def_acl";
\r
123 if (GET_EXT_VERSION("admins") >= "0.6.7") $ADD .= ", la_mode";
\r
125 $result_admins = SQL_QUERY("SELECT id AS aid, login, password, email".$ADD."
\r
126 FROM "._MYSQL_PREFIX."_admins
\r
127 ORDER BY login", __FILE__, __LINE__);
\r
128 while($dummy = SQL_FETCHARRAY($result_admins))
\r
131 $CACHE->add_row($dummy);
\r
135 SQL_FREERESULT($result_admins);
\r
139 $CACHE->cache_close();
\r
141 // Next cached table is the module registry (mod_reg)...
\r
142 if ($CACHE->cache_file("mod_reg", true) == true)
\r
146 $MODULES = $CACHE->cache_load();
\r
148 // Valid cache file
\r
150 foreach ($MODULES as $k=>$array)
\r
152 $CNT += count($array);
\r
155 // When there is a period (.) in the result this test will fail and so the cache file is
\r
156 // damaged/corrupted
\r
158 if (count($MODULES) > 0 ) $TEST = ($CNT / (count($MODULES)));
\r
159 if ($TEST != bigintval($TEST))
\r
161 // Cache file is corrupted!
\r
162 $CACHE->cache_destroy();
\r
167 // Rewrite module cache
\r
169 foreach ($MODULES['module'] as $key=>$mod)
\r
171 $MODULES['id'][$mod] = $MODULES['id'][$key];
\r
172 unset($MODULES['id'][$key]);
\r
173 $MODULES['title'][$mod] = $MODULES['title'][$key];
\r
174 unset($MODULES['title'][$key]);
\r
175 $MODULES['locked'][$mod] = $MODULES['locked'][$key];
\r
176 unset($MODULES['locked'][$key]);
\r
177 $MODULES['hidden'][$mod] = $MODULES['hidden'][$key];
\r
178 unset($MODULES['hidden'][$key]);
\r
179 $MODULES['admin_only'][$mod] = $MODULES['admin_only'][$key];
\r
180 unset($MODULES['admin_only'][$key]);
\r
181 $MODULES['mem_only'][$mod] = $MODULES['mem_only'][$key];
\r
182 unset($MODULES['mem_only'][$key]);
\r
183 $MODULES['has_menu'][$mod] = $MODULES['has_menu'][$key];
\r
184 unset($MODULES['has_menu'][$key]);
\r
188 elseif (($CONFIG['cache_modreg'] == "Y") && ($CSS != "1") && ($CSS != "-1"))
\r
190 // Create cache file here
\r
191 $CACHE->cache_init("MODULES");
\r
193 // Load all modules and their data
\r
194 if (GET_EXT_VERSION("sql_patches") >= "0.3.6")
\r
197 $result = SQL_QUERY("SELECT id, module, title, locked, hidden, admin_only, title, mem_only, has_menu
\r
198 FROM "._MYSQL_PREFIX."_mod_reg ORDER BY id", __FILE__, __LINE__);
\r
202 // Don't load has_menu
\r
203 $result = SQL_QUERY("SELECT id, module, title, locked, hidden, admin_only, title, mem_only
\r
204 FROM "._MYSQL_PREFIX."_mod_reg ORDER BY id", __FILE__, __LINE__);
\r
206 while ($DATA = SQL_FETCHARRAY($result))
\r
208 // Add row to cache file
\r
209 $CACHE->add_row($DATA);
\r
213 SQL_FREERESULT($result);
\r
217 $CACHE->cache_close();
\r
219 // Next cached table is the configuration (config)...
\r
220 if ($CACHE->cache_file("config", true) == true)
\r
222 // Load config from cache
\r
224 $CFG_CACHE = $CACHE->cache_load();
\r
226 // Valid cache file
\r
228 foreach ($CFG_CACHE as $k=>$array)
\r
230 $CNT += count($array);
\r
233 // When there is a period (.) in the result this test will fail and so the cache file is
\r
234 // damaged/corrupted
\r
236 if (count($CFG_CACHE) > 0 ) $TEST = ($CNT / (count($CFG_CACHE)));
\r
237 if ($TEST != bigintval($TEST))
\r
239 // Cache file is corrupted!
\r
240 $CACHE->cache_destroy();
\r
244 elseif (($CONFIG['cache_config'] == "Y") && ($CSS != "1") && ($CSS != "-1"))
\r
246 // Create cache file here
\r
247 $CACHE->cache_init("CONFIG");
\r
249 // Load all modules and their data
\r
250 $result = SQL_QUERY("SELECT * FROM "._MYSQL_PREFIX."_config ORDER BY config", __FILE__, __LINE__);
\r
251 while ($DATA = SQL_FETCHARRAY($result))
\r
253 // Add row to cache file
\r
254 $CACHE->add_row($DATA);
\r
258 SQL_FREERESULT($result);
\r
262 $CACHE->cache_close();
\r
264 // Next cached table is the referral system (refsystem)...
\r
265 if ($CACHE->cache_file("refsystem", true) == true)
\r
267 // Load referral system from cache
\r
268 global $REF_SYSTEM;
\r
269 $REF_SYSTEM = $CACHE->cache_load();
\r
271 // Valid cache file
\r
273 foreach ($REF_SYSTEM as $k=>$array)
\r
275 $CNT += count($array);
\r
278 // When there is a period (.) in the result this test will fail and so the cache file is
\r
279 // damaged/corrupted
\r
281 if (count($REF_SYSTEM) > 0 ) $TEST = ($CNT / (count($REF_SYSTEM)));
\r
282 if ($TEST != bigintval($TEST))
\r
284 // Cache file is corrupted!
\r
285 $CACHE->cache_destroy();
\r
286 unset($REF_SYSTEM);
\r
289 elseif (($CONFIG['cache_refsys'] == "Y") && ($CSS != "1") && ($CSS != "-1"))
\r
291 // Create cache file here
\r
292 $CACHE->cache_init("REFSYSTEM");
\r
294 // Load all modules and their data
\r
295 $result = SQL_QUERY("SELECT id, userid, level, counter FROM "._MYSQL_PREFIX."_refsystem ORDER BY userid, level", __FILE__, __LINE__);
\r
296 while ($DATA = SQL_FETCHARRAY($result))
\r
298 // Add row to cache file
\r
299 $CACHE->add_row($DATA);
\r
303 SQL_FREERESULT($result);
\r
307 $CACHE->cache_close();
\r
309 // Next cached table is the referral system (refdepths)...
\r
310 if ($CACHE->cache_file("refdepths", true) == true)
\r
312 // Load referral system from cache
\r
313 global $REF_DEPTHS;
\r
314 $REF_DEPTHS = $CACHE->cache_load();
\r
316 // Valid cache file
\r
318 foreach ($REF_DEPTHS as $k=>$array)
\r
320 $CNT += count($array);
\r
323 // When there is a period (.) in the result this test will fail and so the cache file is
\r
324 // damaged/corrupted
\r
326 if (count($REF_DEPTHS) > 0 ) $TEST = ($CNT / (count($REF_DEPTHS)));
\r
327 if ($TEST != bigintval($TEST))
\r
329 // Cache file is corrupted!
\r
330 $CACHE->cache_destroy();
\r
331 unset($REF_DEPTHS);
\r
334 elseif (($CONFIG['cache_refdepth'] == "Y") && ($CSS != "1") && ($CSS != "-1"))
\r
336 // Create cache file here
\r
337 $CACHE->cache_init("REFDEPTHS");
\r
339 // Load all modules and their data
\r
340 $result = SQL_QUERY("SELECT id, level, percents FROM "._MYSQL_PREFIX."_refdepths ORDER BY level", __FILE__, __LINE__);
\r
341 while ($DATA = SQL_FETCHARRAY($result))
\r
343 // Add row to cache file
\r
344 $CACHE->add_row($DATA);
\r
348 SQL_FREERESULT($result);
\r
352 $CACHE->cache_close();
\r
354 // Next cached table is the referral system (admins_acls)...
\r
355 if (GET_EXT_VERSION("admins") >= "0.3")
\r
357 // Check for cache file
\r
358 if ($CACHE->cache_file("admins_acls", true) == true)
\r
360 // Load referral system from cache
\r
361 global $ADMINS_ACLS;
\r
362 $ADMINS_ACLS = $CACHE->cache_load();
\r
364 // Valid cache file
\r
366 foreach ($ADMINS_ACLS as $k=>$array)
\r
368 $CNT += count($array);
\r
371 // When there is a period (.) in the result this test will fail and so the cache file is
\r
372 // damaged/corrupted
\r
373 if (count($ADMINS_ACLS) > 0)
\r
376 if (count($ADMINS_ACLS) > 0 ) $TEST = ($CNT / (count($ADMINS_ACLS)));
\r
377 if ($TEST != bigintval($TEST))
\r
379 // Cache file is corrupted!
\r
380 $CACHE->cache_destroy();
\r
381 unset($ADMINS_ACLS);
\r
385 elseif (($CONFIG['cache_acls'] == "Y") && ($CSS != "1") && ($CSS != "-1"))
\r
387 // Create cache file here
\r
388 $CACHE->cache_init("ADMINS_ACLS");
\r
390 // Load all modules and their data
\r
391 $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__);
\r
392 while ($DATA = SQL_FETCHARRAY($result))
\r
394 // Add row to cache file
\r
395 $CACHE->add_row($DATA);
\r
399 SQL_FREERESULT($result);
\r
403 $CACHE->cache_close();
\r