$pass_parameters = get_transfer_params();
$main_page = get_custom_friendly_url($product_page);
}
$sql_params = array();
$sql_params["brackets"] = "(";
$sql_params["join"] = $related_type_join;
$sql_params["where"] = $related_type_where;
$items_ids = VA_Products::find_all_ids($sql_params, VIEW_CATEGORIES_ITEMS_PERM);
if (!$items_ids) {
return;
}
$total_records = count($items_ids);
$allowed_items_ids = VA_Products::find_all_ids("i.item_id IN (" . $db->tosql($items_ids, INTEGERS_LIST) . ")", VIEW_ITEMS_PERM);
$pages_number = 5;
$n = new VA_Navigator($settings["templates_dir"], "navigator.html", $main_page);
$page_number = $n->set_navigator("ri_navigator", "ri_page", SIMPLE, $pages_number, $records_per_page, $total_records, false, $pass_parameters, array(), "#related-products");
$db->RecordsPerPage = $records_per_page;
$db->PageNumber = $page_number;
# ****************************** new MS
$allowed_items_ids = VA_Products::find_all_ids("i.item_id IN (" . $db->tosql($items_ids, INTEGERS_LIST) . ")", VIEW_ITEMS_PERM);
//Customization by Vital - second image mouseover
$mouseover_images = array();
$sql = " SELECT item_id, image_small FROM " . $table_prefix . "items_images WHERE item_id IN (" . $db->tosql($allowed_items_ids, INTEGERS_LIST) . ") ORDER BY item_id, image_title ";
$db->query($sql);
while ($db->next_record()) {
$mouseover_images[$db->f("item_id")][] = $db->f("image_small");
}
# ***************************** new MS
$sql = " SELECT i.item_id, i.item_type_id, i.item_name, i.a_title, i.friendly_url, i.short_description, i.small_image, i.small_image_alt, ";
$sql .= " i.buying_price, i." . $price_field . ", i." . $properties_field . ", i." . $sales_field . ", i.is_sales, i.tax_id, i.tax_free, ";
$sql .= " i.buying_price, i." . $price_field . ", i." . $properties_field . ", i." . $sales_field . ", i.is_sales, i.tax_id, i.tax_free, ";
// ORDER FIX order by items_categories item_order instead of item item_order (i.item_order)
// set up variables for navigator
$n = new VA_Navigator($settings["templates_dir"], "navigator.html", $products_page);
$products_nav_type = get_setting_value($vars, "products_nav_type", 1);
$products_nav_pages = get_setting_value($vars, "products_nav_pages", 5);
$products_nav_first_last = get_setting_value($vars, "products_nav_first_last", 0);
$products_nav_prev_next = get_setting_value($vars, "products_nav_prev_next", 1);
$inactive_links = false;
//Customization by Vital
$t->set_var("all_products_style", "display: none;");
//END customization
if ($show_all) {
$records_per_page = $total_records;
}
$n->set_parameters($products_nav_first_last, $products_nav_prev_next, $inactive_links);
$page_number = $n->set_navigator("navigator", "pn_pr", $products_nav_type, $products_nav_pages, $records_per_page, $total_records, false, $pass_parameters);
$total_pages = ceil($total_records / $records_per_page);
// generate page link with query parameters
$query_string = get_query_string($pass_parameters, "", "", false);
$rp = $products_page;
$rp .= $query_string;
$cart_link = $rp;
$cart_link .= strlen($query_string) ? "&" : "?";
$cart_link .= "rnd=" . $random_value . "&";
// set hidden parameter with category_id parameter
//$hidden_parameters = $pass_parameters;
//$hidden_parameters["category_id"] = $category_id;
//get_query_string($hidden_parameters, "", "", true);
// remove page and sorting parameters from url
$details_query = get_query_string($details_parameters, array("pn_pr", "sort_ord", "sort_dir"), "", false);
$product_link = get_custom_friendly_url("product_details.php") . $details_query;
add_root_categories_to_site_map_tree("articles_" . $article_top_category_id, $articles_top_category["c.category_name"], $category_url, $show_categories, $show_items);
}
}
add_root_categories_to_site_map_tree("forums", FORUM_TITLE, get_custom_friendly_url("forums.php"), $site_map_forum_categories, $site_map_forums);
add_root_categories_to_site_map_tree("ads", ADS_TITLE, get_custom_friendly_url("ads.php"), $site_map_ad_categories, $site_map_ads);
add_root_categories_to_site_map_tree("manuals", MANUALS_TITLE, get_custom_friendly_url("manuals.php"), $site_map_manual_categories, $site_map_manuals, $site_map_manual_articles);
$t->set_file("block_body", "block_site_map.html");
$t->set_var("item", "");
$t->set_var("items_rows", "");
$t->set_var("navigator_block", "");
$n = new VA_Navigator($settings["templates_dir"], "navigator.html", $current_page);
$current_record = 0;
$pages_number = 1;
$records_per_page = get_setting_value($sitemap_settings, "site_map_records_per_page", "");
if ($records_per_page) {
$page_number = $n->set_navigator("navigator", "page", SIMPLE, $pages_number, $records_per_page, $total_records, false);
$first_record_on_page = ($page_number - 1) * $records_per_page;
$last_record_on_page = $page_number * $records_per_page;
} else {
$first_record_on_page = 0;
$last_record_on_page = 0;
}
if ($site_map_tree) {
array_walk($site_map_tree, 'show_site_map_tree');
}
$block_parsed = true;
$t->parse("block_body", false);
function add_root_categories_to_site_map_tree($type = "products", $first_title = "", $first_url = "", $show_categories = 0, $show_items = 0, $show_subitems = 0)
{
global $db, $table_prefix, $settings;
global $site_map_tree, $total_records;
$where = "c.category_id IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ") ";
if (strlen($search_string)) {
$search_values = explode(" ", $search_string);
for ($si = 0; $si < sizeof($search_values); $si++) {
$where .= " AND (a.short_description LIKE '%" . $db->tosql($search_values[$si], TEXT, false) . "%' ";
$where .= " OR a.full_description LIKE '%" . $db->tosql($search_values[$si], TEXT, false) . "%' ";
$where .= " OR a.article_title LIKE '%" . $db->tosql($search_values[$si], TEXT, false) . "%') ";
}
}
$articles_ids = VA_Articles::find_all_ids($where, VIEW_CATEGORIES_ITEMS_PERM);
$total_records = count($articles_ids);
// set up variables for navigator
$n = new VA_Navigator($settings["templates_dir"], "navigator.html", $articles_page);
$records_per_page = get_setting_value($vars, "articles_recs", 10);
$pages_number = 5;
$page_number = $n->set_navigator("navigator", $page_param, SIMPLE, $pages_number, $records_per_page, $total_records, false, $pass_parameters);
$total_pages = ceil($total_records / $records_per_page);
// generate page link with query parameters
$pass_parameters["page"] = $page;
$query_string = get_query_string($pass_parameters, "article_id", "", true);
$rp = $articles_page;
$rp .= $query_string;
$article_link = "article.php" . $query_string;
$article_link .= strlen($query_string) ? "&" : "?";
$article_link .= "article_id=";
$reviews_link = "articles_reviews.php" . $query_string;
$reviews_link .= strlen($query_string) ? "&" : "?";
$reviews_link .= "article_id=";
$t->set_var("rp_url", urlencode($rp));
$t->set_var("rp", htmlspecialchars($rp));
$t->set_var("total_records", $total_records);
