} else { $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_params["where"] = $sql_where; $sql_params["distinct"] = " i.item_id"; $total_records = VA_Products::count($sql_params, VIEW_CATEGORIES_ITEMS_PERM); $sql_params["distinct"] = ""; $details_parameters = $pass_parameters; // use all parameters for details page if ($friendly_urls && $page_friendly_url) { for ($fp = 0; $fp < sizeof($page_friendly_params); $fp++) { unset($pass_parameters[$page_friendly_params[$fp]]); } } $s = new VA_Sorter($settings["templates_dir"], "sorter_img.html", $products_page, "sort", "", $pass_parameters); $s->order_by = " ORDER BY ic.item_order "; // 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
if ($articles_top_category["c.friendly_url"] && $friendly_urls) { $category_url = $articles_top_category["c.friendly_url"] . $friendly_extension; } else { $category_url = "articles.php?category_id=" . $article_top_category_id; } 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;
return; } // 2. count total articles $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=";