loadCacheFile('points_data')) && ($GLOBALS['cache_instance']->extensionVersionMatches('sql_patches'))) { // Load cache $GLOBALS['cache_array']['points_data'] = $GLOBALS['cache_instance']->getArrayFromCache(); // Do we have cache? if (!isset($GLOBALS['cache_array']['points_data']['subject'])) { // Try to remove the cache file $GLOBALS['cache_instance']->removeCacheFile(); // Not found, so better abort here debug_report_bug(__FILE__, __LINE__, 'points_data has been generated, but does not contain "subject". Please try to reload to fix this.'); } // END - if // Init temporary array $pointsData = array(); // Rewrite all to subject foreach ($GLOBALS['cache_array']['points_data']['subject'] as $key=>$subject) { // Re-add key with subject foreach ($GLOBALS['cache_array']['points_data'] as $key2=>$array) { // Is key2 not 'subject'? if ($key2 != 'subject') { // Then Add it $pointsData[$subject][$key2] = $GLOBALS['cache_array']['points_data'][$key2][$key]; } // END - if } // END - foreach } // END - foreach // Set the array back and remove temporary $GLOBALS['cache_array']['points_data'] = $pointsData; unset($pointsData); } elseif ((isHtmlOutputMode()) && (isExtensionInstalledAndNewer('sql_patches', '0.8.0'))) { // Create cache file $GLOBALS['cache_instance']->init(); // Query the database about this $result = SQL_QUERY('SELECT * FROM `{?_MYSQL_PREFIX?}_points_data` ORDER BY `id` ASC', __FILE__, __LINE__); while ($dummy = SQL_FETCHARRAY($result)) { // Save row $GLOBALS['cache_instance']->addRow($dummy); } // END - while // Free memory SQL_FREERESULT($result); // Close cache $GLOBALS['cache_instance']->storeExtensionVersion('sql_patches'); $GLOBALS['cache_instance']->finalize(); } // [EOF] ?>