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