*/ require 'includes/application_top.php'; require DIR_WS_MODULES . 'prod_cat_header_code.php'; $action = isset($_GET['action']) ? $_GET['action'] : ''; if (isset($_GET['page'])) { $_GET['page'] = (int) $_GET['page']; } if (isset($_GET['product_type'])) { $_GET['product_type'] = (int) $_GET['product_type']; } if (isset($_GET['cID'])) { $_GET['cID'] = (int) $_GET['cID']; } // If the action will affect the cache entries if (preg_match("/(insert|update|setflag)/i", $action)) { usu_reset_cache_data('true'); } if (!isset($_SESSION['categories_products_sort_order'])) { $_SESSION['categories_products_sort_order'] = CATEGORIES_PRODUCTS_SORT_ORDER; } if (!isset($_GET['reset_categories_products_sort_order'])) { $reset_categories_products_sort_order = $_SESSION['categories_products_sort_order']; } if (zen_not_null($action)) { switch ($action) { case 'set_categories_products_sort_order': $_SESSION['categories_products_sort_order'] = $_GET['reset_categories_products_sort_order']; $action = ''; zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $_GET['cPath'] . ((isset($_GET['pID']) and !empty($_GET['pID'])) ? '&pID=' . $_GET['pID'] : '') . ((isset($_GET['page']) and !empty($_GET['page'])) ? '&page=' . $_GET['page'] : ''))); break; case 'set_editor':
function usu_check_cache_options($action) { $temp = explode('-', $action); if (sizeof($temp) < 2) { $temp[] = 'global'; } $temp[1] = strtoupper($temp[1]); switch ($temp[0]) { case 'enable': $action = 'true'; if (SEO_USE_CACHE_GLOBAL == 'false' && $temp[1] != 'GLOBAL') { zen_db_perform(TABLE_CONFIGURATION, array('configuration_value' => $action), 'update', '`configuration_key`=\'SEO_USE_CACHE_GLOBAL\''); echo '<div><span class="alert">' . sprintf(SEO_CONFIG_ADJUSTED, constant('SEO_USE_CACHE_' . $temp[1] . '_TITLE'), SEO_USE_CACHE_GLOBAL_TITLE, $action) . '</span></div>'; } zen_db_perform(TABLE_CONFIGURATION, array('configuration_value' => $action), 'update', '`configuration_key`=\'SEO_USE_CACHE_' . $temp[1] . '\''); usu_reset_cache_data('true'); break; case 'disable': $action = 'false'; zen_db_perform(TABLE_CONFIGURATION, array('configuration_value' => $action), 'update', '`configuration_key`=\'SEO_USE_CACHE_' . $temp[1] . '\''); usu_reset_cache_data('true'); break; default: } return $action; }
/** * Checks the value of the various URL cache options. If the value has been * changed, the value will be updated in the database and the URL cache reset. * * @param string $value the current value for the URL cache option * @return string the value to display for the URL cache option */ function usu_check_cache_options($value) { $temp = explode('-', $value); if (sizeof($temp) < 2) { $temp[] = 'global'; } $temp[1] = strtoupper($temp[1]); switch ($temp[0]) { case 'enable': $value = 'true'; if (USU_CACHE_GLOBAL == 'false' && $temp[1] != 'GLOBAL') { zen_db_perform(TABLE_CONFIGURATION, array('configuration_value' => $value), 'update', '`configuration_key`=\'USU_CACHE_GLOBAL\''); echo '<div><span class="alert">' . sprintf(USU_PLUGIN_WARNING_CONFIG_ADJUSTED, usu_get_configuration_title('USU_CACHE_' . $temp[1]), usu_get_configuration_title('USU_CACHE_GLOBAL')) . '</span></div>'; unset($text, $option_text); } zen_db_perform(TABLE_CONFIGURATION, array('configuration_value' => $value), 'update', '`configuration_key`=\'USU_CACHE_' . $temp[1] . '\''); usu_reset_cache_data('true'); break; case 'disable': $value = 'false'; if ($temp[1] == 'GLOBAL') { echo '<div><span class="alert">' . USU_PLUGIN_WARNING_GLOBAL_DISABLED . '</span></div>'; } zen_db_perform(TABLE_CONFIGURATION, array('configuration_value' => $value), 'update', '`configuration_key`=\'USU_CACHE_' . $temp[1] . '\''); usu_reset_cache_data('true'); break; default: } return $value; }
function ultimate_seo_install($version) { global $db, $messageStack; $failed = false; // Check to make sure all new files have been uploaded. // These are not intended to be perfect checks, just a quick 'hey you'. $files = array(DIR_FS_ADMIN . DIR_WS_INCLUDES . 'extra_datafiles/seo.php', DIR_FS_ADMIN . DIR_WS_FUNCTIONS . 'extra_functions/seo.php', DIR_FS_ADMIN . DIR_WS_LANGUAGES . 'english/extra_definitions/seo.php', DIR_FS_CATALOG . DIR_WS_INCLUDES . 'extra_datafiles/seo.php', DIR_FS_CATALOG . DIR_WS_INCLUDES . 'auto_loaders/config.seo.php', DIR_FS_CATALOG . DIR_WS_INCLUDES . 'init_includes/init_seo_config.php', DIR_FS_CATALOG . DIR_WS_CLASSES . 'seo.url.php'); foreach ($files as $file) { if (!file_exists($file)) { $messageStack->add(sprintf(SEO_INSTALL_ERROR_FILE_NOT_FOUND, $file), 'error'); $failed = true; } } // Attempt a database upgrade before doing anything else. ultimate_seo_upgrade($version); // Now check the required tables if not already present $check = $db->Execute('SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES ' . 'WHERE TABLE_SCHEMA = \'' . DB_DATABASE . '\' ' . 'AND TABLE_NAME = \'' . TABLE_SEO_CACHE . '\''); if ($check->EOF) { $db->Execute('CREATE TABLE `' . TABLE_SEO_CACHE . '` ( ' . '`cache_id` VARCHAR(32) NOT NULL default \'\', ' . '`cache_language_id` TINYINT(1) NOT NULL default \'0\', ' . '`cache_name` VARCHAR(255) NOT NULL default \'\', ' . '`cache_data` MEDIUMTEXT NOT NULL, ' . '`cache_global` TINYINT(1) NOT NULL default \'1\', ' . '`cache_gzip` TINYINT(1) NOT NULL default \'1\', ' . '`cache_method` VARCHAR(20) NOT NULL default \'RETURN\', ' . '`cache_date` DATETIME NOT NULL default \'0000-00-00 00:00:00\', ' . '`cache_expires` DATETIME NOT NULL default \'0000-00-00 00:00:00\', ' . 'PRIMARY KEY (`cache_id`,`cache_language_id`), ' . 'KEY `cache_id` (`cache_id`), ' . 'KEY `cache_language_id` (`cache_language_id`), ' . 'KEY `cache_global` (`cache_global`) ' . ') ENGINE=MyISAM'); } // Now check the configuration group $group_id = 0; $check = $db->Execute('SELECT `configuration_group_id` FROM `' . TABLE_CONFIGURATION_GROUP . '` ' . 'WHERE `configuration_group_title` = \'' . SEO_CONFIGURATION_GROUP_TITLE . '\''); if ($check->EOF) { $max_sort = $db->Execute('SELECT MAX(sort_order) AS `max_sort` FROM `' . TABLE_CONFIGURATION_GROUP . '`'); if (!$max_sort->EOF) { $max_sort = $max_sort->fields['max_sort'] + 1; // Create configuration group $db->Execute('INSERT INTO `' . TABLE_CONFIGURATION_GROUP . '` ' . 'VALUES (\'\', \'' . SEO_CONFIGURATION_GROUP_TITLE . '\', ' . '\'' . SEO_CONFIGURATION_GROUP_DESCRIPTION . '\', \'' . $max_sort . '\', \'1\')'); $group_id = (int) $db->insert_ID(); } else { $messageStack->add(sprintf(SEO_INSTALL_ERROR_SORT_ORDER, TABLE_CONFIGURATION_GROUP), 'error'); $failed = true; } } else { $group_id = (int) $check->fields['configuration_group_id']; } // Install (or update) any needed configuration items if ($group_id != 0) { $sql_data_array = array('configuration_group_id' => $group_id, 'sort_order' => 0, 'last_modified' => 'null', 'date_added' => 'now()'); foreach (ultimate_seo_default_settings($version) as $key => $data) { $check = $db->Execute('SELECT `configuration_id` FROM `' . TABLE_CONFIGURATION . '` ' . 'WHERE `configuration_key`=\'' . $key . '\''); if ($check->EOF) { $data['configuration_key'] = $key; $data['configuration_title'] = constant($key . '_TITLE'); $data['configuration_description'] = constant($key . '_DESCRIPTION'); zen_db_perform(TABLE_CONFIGURATION, array_merge($sql_data_array, $data)); } else { unset($data['configuration_value']); ultimate_seo_upgrade_option($key, array_merge($data, array('sort_order' => $sql_data_array['sort_order']))); } $sql_data_array['sort_order']++; } // Update the version stored in the database for this plugin $sql_data_array = array('last_modified' => 'now()', 'configuration_value' => $version, 'set_function' => 'zen_cfg_select_option(array(\\\'' . $version . '\\\'),'); zen_db_perform(TABLE_CONFIGURATION, $sql_data_array, 'update', '`configuration_key`=\'USU_VERSION\''); unset($sql_data_array); // Reset the cache to deal with any stale entries usu_reset_cache_data('true'); } unset($defaults); // Add support for admin profiles if (function_exists('zen_register_admin_page')) { if (!zen_page_key_exists('configUltimateSEO')) { $max_sort = $db->Execute('SELECT MAX(sort_order) AS `max_sort` FROM `' . TABLE_ADMIN_PAGES . '` WHERE `menu_key`=\'configuration\''); if (!$max_sort->EOF) { $max_sort = $max_sort->fields['max_sort'] + 1; // Register the administrative page zen_register_admin_page('configUltimateSEO', 'SEO_CONFIGURATION_GROUP_TITLE', 'FILENAME_CONFIGURATION', 'gID=' . $group_id, 'configuration', 'Y', $max_sort); } else { $messageStack->add(sprintf(SEO_INSTALL_ERROR_SORT_ORDER, TABLE_ADMIN_PAGES), 'error'); $failed = true; } } } return $failed; }