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 } elseif (($_CONFIG['cache_config'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
 212         // Create cache file here
 213         $cacheInstance->cache_init("CONFIG");
 214
 215         // Load all modules and their data
 216         $result = SQL_QUERY("SELECT * FROM "._MYSQL_PREFIX."_config ORDER BY config", __FILE__, __LINE__);
 217         while ($DATA = SQL_FETCHARRAY($result)) {
 218                 // Add row to cache file
 219                 $cacheInstance->add_row($DATA);
 220         }
 221
 222         // Free memory
 223         SQL_FREERESULT($result);
 224 }
 225
 226 // Close file
 227 $cacheInstance->cache_close();
 228
 229 // Next cached table is the referral system (refsystem)...
 230 if ($cacheInstance->cache_file("refsystem", true) == true) {
 231         // Load referral system from cache
 232         global $REF_SYSTEM;
 233         $REF_SYSTEM = $cacheInstance->cache_load();
 234
 235         // Valid cache file
 236         $CNT = 0;
 237         foreach ($REF_SYSTEM as $k=>$array) {
 238                 $CNT += count($array);
 239         }
 240
 241         // When there is a period (.) in the result this test will fail and so the cache file is
 242         // damaged/corrupted
 243         $TEST = "failed";
 244         if (count($REF_SYSTEM) > 0 ) $TEST = ($CNT / (count($REF_SYSTEM)));
 245         if ($TEST != bigintval($TEST)) {
 246                 // Cache file is corrupted!
 247                 $cacheInstance->cache_destroy();
 248                 unset($REF_SYSTEM);
 249         }
 250 } elseif (($_CONFIG['cache_refsys'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
 251         // Create cache file here
 252         $cacheInstance->cache_init("REFSYSTEM");
 253
 254         // Load all modules and their data
 255         $result = SQL_QUERY("SELECT id, userid, level, counter FROM "._MYSQL_PREFIX."_refsystem ORDER BY userid, level", __FILE__, __LINE__);
 256         while ($DATA = SQL_FETCHARRAY($result)) {
 257                 // Add row to cache file
 258                 $cacheInstance->add_row($DATA);
 259         }
 260
 261         // Free memory
 262         SQL_FREERESULT($result);
 263 }
 264
 265 // Close file
 266 $cacheInstance->cache_close();
 267
 268 // Next cached table is the referral system (refdepths)...
 269 if ($cacheInstance->cache_file("refdepths", true) == true) {
 270         // Load referral system from cache
 271         global $REF_DEPTHS;
 272         $REF_DEPTHS = $cacheInstance->cache_load();
 273
 274         // Valid cache file
 275         $CNT = 0;
 276         foreach ($REF_DEPTHS as $k=>$array) {
 277                 $CNT += count($array);
 278         }
 279
 280         // When there is a period (.) in the result this test will fail and so the cache file is
 281         // damaged/corrupted
 282         $TEST = "failed";
 283         if (count($REF_DEPTHS) > 0 ) $TEST = ($CNT / (count($REF_DEPTHS)));
 284         if ($TEST != bigintval($TEST)) {
 285                 // Cache file is corrupted!
 286                 $cacheInstance->cache_destroy();
 287                 unset($REF_DEPTHS);
 288         }
 289 } elseif (($_CONFIG['cache_refdepth'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
 290         // Create cache file here
 291         $cacheInstance->cache_init("REFDEPTHS");
 292
 293         // Load all modules and their data
 294         $result = SQL_QUERY("SELECT id, level, percents FROM "._MYSQL_PREFIX."_refdepths ORDER BY level", __FILE__, __LINE__);
 295         while ($DATA = SQL_FETCHARRAY($result)) {
 296                 // Add row to cache file
 297                 $cacheInstance->add_row($DATA);
 298         }
 299
 300         // Free memory
 301         SQL_FREERESULT($result);
 302 }
 303
 304 // Close file
 305 $cacheInstance->cache_close();
 306
 307 // Next cached table is the referral system (admins_acls)...
 308 if (GET_EXT_VERSION("admins") >= "0.3") {
 309         // Check for cache file
 310         if ($cacheInstance->cache_file("admins_acls", true) == true) {
 311                 // Load referral system from cache
 312                 global $cacheArray;
 313                 $cacheArray['admin_acls'] = $cacheInstance->cache_load();
 314
 315                 // Valid cache file
 316                 $CNT = 0;
 317                 foreach ($cacheArray['admin_acls'] as $k=>$array) {
 318                         $CNT += count($array);
 319                 }
 320
 321                 // When there is a period (.) in the result this test will fail and so the cache file is
 322                 // damaged/corrupted
 323                 if (count($cacheArray['admin_acls']) > 0) {
 324                         $TEST = "failed";
 325                         if (count($cacheArray['admin_acls']) > 0 ) $TEST = ($CNT / (count($cacheArray['admin_acls'])));
 326                         if ($TEST != bigintval($TEST)) {
 327                                 // Cache file is corrupted!
 328                                 $cacheInstance->cache_destroy();
 329                                 unset($cacheArray['admin_acls']);
 330                         }
 331                 }
 332         } elseif (($_CONFIG['cache_acls'] == "Y") && ($CSS != "1") && ($CSS != "-1")) {
 333                 // Create cache file here
 334                 $cacheInstance->cache_init("ADMINS_ACLS");
 335
 336                 // Load all modules and their data
 337                 $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__);
 338                 while ($DATA = SQL_FETCHARRAY($result)) {
 339                         // Add row to cache file
 340                         $cacheInstance->add_row($DATA);
 341                 }
 342
 343                 // Free memory
 344                 SQL_FREERESULT($result);
 345         }
 346
 347         // Close file
 348         $cacheInstance->cache_close();
 349 }
 350
 351 //
 352 ?>