$sql .= " ORDER BY site_id DESC "; $r->set_value($key, get_db_value($sql)); } // check data for categories columns $cc_eg->set_value("category_id", 0); $cc_eg->change_property("column_id", USE_IN_SELECT, true); $cc_eg->change_property("column_id", USE_IN_WHERE, false); $cc_eg->change_property("category_id", USE_IN_WHERE, true); $cc_eg->change_property("category_id", USE_IN_SELECT, true); $columns_number = $cc_eg->get_db_values(); } if ($columns_number == 0) { $columns_number = 5; } // set parameters $r->set_parameters(); $t->set_var("rp", htmlspecialchars($return_page)); // set categories columns $t->set_var("cc_number", $columns_number); $cc_eg->set_parameters_all($columns_number); // set styles for tabs $tabs = array("general" => array("title" => ADMIN_GENERAL_MSG), "tax" => array("title" => TAX_SETTINGS_MSG), "appearance" => array("title" => PROD_APPEARANCE_MSG), "merchants_affiliates" => array("title" => MERCHANTS_AFFILIATES_MSG), "points" => array("title" => POINTS_AND_CREDITS_MSG), "images" => array("title" => IMAGES_MSG), "google_base" => array("title" => GOOGLE_BASE_SETTINGS_MSG), "import_export" => array("title" => IMPORT_EXPORT_MSG), "fast_checkout" => array("title" => FAST_CHECKOUT_MSG), "table_view" => array("title" => TABLE_VIEW_MSG), "keywords" => array("title" => KEYWORDS_SEARCH_MSG)); parse_admin_tabs($tabs, $tab, 6); // multisites if ($sitelist) { $sites = get_db_values("SELECT site_id,site_name FROM " . $table_prefix . "sites ORDER BY site_id ", ""); set_options($sites, $param_site_id, "param_site_id"); $t->parse("sitelist", false); } include_once "./admin_footer.php"; $t->pparse("main");