2 /************************************************************************
3 * MXChange v0.2.1 Start: 09/09/2008 *
4 * =============== Last change: 09/09/2008 *
6 * -------------------------------------------------------------------- *
7 * File : load_cache-config.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 (!defined('__SECURITY')) {
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) && ($cacheInstance->ext_version_matches("admins"))) {
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) {
56 $cacheArray['admins']['aid'][$login] = $cacheArray['admins']['aid'][$k];
59 $aid = $cacheArray['admins']['aid'][$login];
62 $cacheArray['admins']['password'][$aid] = $cacheArray['admins']['password'][$k];
63 $cacheArray['admins']['email'][$aid] = $cacheArray['admins']['email'][$k];
65 // Some extra data depending on version
66 if (GET_EXT_VERSION("admins") >= "0.3") {
68 $cacheArray['admins']['def_acl'][$aid] = $cacheArray['admins']['def_acl'][$k];
69 if (GET_EXT_VERSION("admins") >= "0.6.7") {
70 // "Logical Area" mode
71 $cacheArray['admins']['la_mode'][$aid] = $cacheArray['admins']['la_mode'][$k];
72 if (GET_EXT_VERSION("admins") >= "0.7.0") {
74 $cacheArray['admins']['login_failtures'][$aid] = $cacheArray['admins']['login_failtures'][$k];
75 $cacheArray['admins']['last_failture'][$aid] = $cacheArray['admins']['last_failture'][$k];
80 //* DEBUG: */ print_r($cacheArray['admins']);
83 foreach (array('aid', 'def_acl', 'la_mode', 'password', 'email', 'login_failtures', 'last_failture') as $rem) {
84 if (isset($cacheArray['admins'][$rem][$k])) unset($cacheArray['admins'][$rem][$k]);
88 //* DEBUG: */ print_r($cacheArray['admins']);
91 foreach ($cacheArray['admins']['login'] as $k => $login) {
92 $cacheArray['admins']['login'][$cacheArray['admins']['aid'][$login]] = $login;
93 if (!in_array($k, $cacheArray['admins']['aid'])) {
94 unset($cacheArray['admins']['login'][$k]);
98 //* DEBUG: */ echo "****\n";
99 //* DEBUG: */ print_r($cacheArray['admins']);
100 //* DEBUG: */ echo "</PRE>";
103 // Nope, cache file is corrupted!
104 $cacheInstance->cache_destroy();
107 // Nope, cache file is corrupted!
108 $cacheInstance->cache_destroy();
109 unset($cacheArray['admins']);
111 } elseif (($_CONFIG['cache_admins'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
113 $cacheInstance->cache_init("ADMINS");
114 $cacheInstance->store_extension_version("admins");
116 // Load every data from DB to cache file
118 if (GET_EXT_VERSION("admins") >= "0.3") $ADD = ", default_acl AS def_acl";
119 if (GET_EXT_VERSION("admins") >= "0.6.7") $ADD .= ", la_mode";
120 if (GET_EXT_VERSION("admins") >= "0.7.0") $ADD .= ", login_failtures, UNIX_TIMESTAMP(last_failture) AS last_failture";
122 // Query the database about this
123 $result_admins = SQL_QUERY("SELECT id AS aid, login, password, email".$ADD."
124 FROM "._MYSQL_PREFIX."_admins
125 ORDER BY login", __FILE__, __LINE__);
126 while($dummy = SQL_FETCHARRAY($result_admins)) {
128 $cacheInstance->add_row($dummy);
132 SQL_FREERESULT($result_admins);
135 $cacheInstance->cache_close();
142 $cacheInstance->cache_close();
144 // Next cached table are the admins_acls...
145 if (GET_EXT_VERSION("admins") >= "0.3") {
146 // Check for cache file
147 if ($cacheInstance->cache_file("admins_acls", true) == true) {
148 // Load referal system from cache
150 $cacheArray['admin_acls'] = $cacheInstance->cache_load();
151 } elseif (($_CONFIG['cache_acls'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
152 // Create cache file here
153 $cacheInstance->cache_init("ADMINS_ACLS");
155 // Load all modules and their data
156 $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__);
157 while ($data = SQL_FETCHARRAY($result)) {
158 // Add row to cache file
159 $cacheInstance->add_row($data);
163 SQL_FREERESULT($result);
170 $cacheInstance->cache_close();