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         $cacheArray = $cacheInstance->cache_load();
 199
 200         // Valid cache file
 201         $CNT = 0; $newCache = array();
 202         foreach ($cacheArray 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) > 0 ) $TEST = ($CNT / (count($cacheArray)));
 216         if ($TEST != bigintval($TEST)) {
 217                 // Cache file is corrupted!
 218                 $cacheInstance->cache_destroy();
 219                 unset($cacheArray);
 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 $REF_SYSTEM;
 243         $REF_SYSTEM = $cacheInstance->cache_load();
 244
 245         // Valid cache file
 246         $CNT = 0;
 247         foreach ($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($REF_SYSTEM) > 0 ) $TEST = ($CNT / (count($REF_SYSTEM)));
 255         if ($TEST != bigintval($TEST)) {
 256                 // Cache file is corrupted!
 257                 $cacheInstance->cache_destroy();
 258                 unset($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 $REF_DEPTHS;
 282         $REF_DEPTHS = $cacheInstance->cache_load();
 283
 284         // Valid cache file
 285         $CNT = 0;
 286         foreach ($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($REF_DEPTHS) > 0 ) $TEST = ($CNT / (count($REF_DEPTHS)));
 294         if ($TEST != bigintval($TEST)) {
 295                 // Cache file is corrupted!
 296                 $cacheInstance->cache_destroy();
 297                 unset($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 ?>