$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");