*** Built: Fri Jan 28 01:45:24 2011 ***
*** http://www.viart.com ***
*** ***
****************************************************************************
*/
include_once "./includes/common.php";
include_once "./messages/" . $language_code . "/cart_messages.php";
include_once "./messages/" . $language_code . "/forum_messages.php";
include_once "./includes/products_functions.php";
include_once "./includes/shopping_cart.php";
include_once "./includes/ads_functions.php";
include_once "./includes/navigator.php";
$tax_rates = get_tax_rates();
$cms_page_code = "custom_page";
$script_name = "page.php";
$current_page = get_custom_friendly_url("page.php");
$custom_page_id = "";
$custom_page_code = get_param("page");
$user_id = get_session("session_user_id");
$user_info = get_session("session_user_info");
$user_type_id = get_setting_value($user_info, "user_type_id", "");
$page_friendly_url = "";
$page_friendly_params = array();
if (strlen($custom_page_code)) {
$sql = " SELECT p.page_id, p.friendly_url, p.meta_title,p.meta_description,p.meta_keywords,p.is_html,p.page_type,p.page_url,p.page_path,";
$sql .= " p.page_title,p.page_body FROM ";
if (isset($site_id)) {
$sql .= "(";
}
if (strlen($user_id)) {
$sql .= "(";
$google_base_filename = 'googlebase.xml';
}
$google_base_tax = get_setting_value($settings, "google_base_tax", true);
$google_base_days_expiry = get_setting_value($settings, "google_base_days_expiry", 30);
$google_base_product_condition = get_setting_value($settings, "google_base_product_condition", "new");
$gb_global_type_id = get_setting_value($settings, "google_base_product_type_id", 0);
$gb_global_type = "";
if ($gb_global_type_id) {
$sql = " SELECT type_name FROM " . $table_prefix . "google_base_types ";
$sql .= " WHERE type_id=" . $db->tosql($gb_global_type_id, INTEGER);
$gb_global_type = get_db_value($sql);
}
$site_url = get_setting_value($settings, "site_url");
$friendly_urls = get_setting_value($settings, "friendly_urls", 0);
$friendly_extension = get_setting_value($settings, "friendly_extension", "");
$product_link = $site_url . get_custom_friendly_url("product_details.php") . "?item_id=";
$current_date = getdate();
$expiration_date = mktime($current_date["hours"], $current_date["minutes"], $current_date["seconds"], $current_date["mon"], $current_date["mday"] + $google_base_days_expiry, $current_date["year"]);
$expiration_date_formatted = date("Y-m-d", $expiration_date);
$dbd = new VA_SQL();
$dbd->DBType = $db->DBType;
$dbd->DBDatabase = $db->DBDatabase;
$dbd->DBUser = $db->DBUser;
$dbd->DBPassword = $db->DBPassword;
$dbd->DBHost = $db->DBHost;
$dbd->DBPort = $db->DBPort;
$dbd->DBPersistent = $db->DBPersistent;
// write in file or output to the browser
$write_to_file = false;
if ($google_base_export_type == 1 && $google_base_ftp_login && $google_base_ftp_password) {
$fp = fopen($google_base_save_path . $google_base_filename, "w+");
$orders_currency = get_setting_value($settings, "orders_currency", 0);
$html_template = get_setting_value($block, "html_template", "block_user_orders.html");
$t->set_file("block_body", $html_template);
$t->set_var("user_orders_href", get_custom_friendly_url("user_orders.php"));
$t->set_var("user_order_href", get_custom_friendly_url("user_order.php"));
$t->set_var("user_home_href", get_custom_friendly_url("user_home.php"));
$t->set_var("user_order_payment_href", get_custom_friendly_url("user_order_payment.php"));
$t->set_var("user_invoice_pdf_href", get_custom_friendly_url("user_invoice_pdf.php"));
$t->set_var("user_invoice_html_href", get_custom_friendly_url("user_invoice_html.php"));
$s = new VA_Sorter($settings["templates_dir"], "sorter_img.html", get_custom_friendly_url("user_orders.php"));
$s->set_default_sorting(1, "desc");
$s->set_sorter(ORDER_NUMBER_COLUMN, "sorter_id", "1", "order_id");
$s->set_sorter(ORDER_ADDED_COLUMN, "sorter_date", "2", "order_placed_date");
$s->set_sorter(STATUS_MSG, "sorter_status", "3", "order_status");
$s->set_sorter(ORDER_TOTAL_COLUMN, "sorter_total", "4", "order_total");
$n = new VA_Navigator($settings["templates_dir"], "navigator.html", get_custom_friendly_url("user_orders.php"));
// set up variables for navigator
$sql = " SELECT COUNT(*) FROM " . $table_prefix . "orders o ";
$sql .= " WHERE o.user_id=" . $db->tosql(get_session("session_user_id"), INTEGER);
if (isset($site_id)) {
$sql .= " AND o.site_id=" . $db->tosql($site_id, INTEGER, true, false);
} else {
$sql .= " AND o.site_id=1";
}
$db->query($sql);
$db->next_record();
$total_records = $db->f(0);
$records_per_page = 25;
$pages_number = 5;
$page_number = $n->set_navigator("navigator", "page", SIMPLE, $pages_number, $records_per_page, $total_records, false);
$db->RecordsPerPage = $records_per_page;
$reviews_href = get_custom_friendly_url("articles_reviews.php") . "?category_id=" . urlencode($category_id) . "&article_id=" . urlencode($article_id);
$t->set_var("rp_url", urlencode($rp));
$t->set_var("rp", htmlspecialchars($rp));
$t->set_var("reviews_href", $reviews_href);
$details_fields = ",," . $details_fields . ",,";
$article_fields = array("author_name", "author_email", "author_url", "link_url", "download_url", "short_description", "full_description", "keywords", "notes");
if (!VA_Articles::check_exists($article_id)) {
$t->set_var("article_item", "");
$t->set_var("NO_ARTICLE_MSG", NO_ARTICLE_MSG);
$t->parse("no_article_item", false);
$block_parsed = true;
$t->parse("block_body", false);
return;
}
if (!VA_Articles::check_permissions($article_id, false, VIEW_ITEMS_PERM)) {
header("Location: " . get_custom_friendly_url("user_login.php") . "?type_error=2");
exit;
}
$is_OG_image_set = false;
//Customization by Vital - Open Graph image
// retrieve info for article
$sql = " SELECT article_id, friendly_url, article_title, article_date, date_end, ";
$sql .= " author_name, author_email, author_url, link_url, download_url, ";
$sql .= " short_description, is_html, full_description, ";
$sql .= " image_small, image_small_alt, image_large, image_large_alt, stream_video, stream_video_width, stream_video_height, stream_video_preview, ";
$sql .= " meta_title, meta_keywords, meta_description, ";
$sql .= " total_views, total_votes, total_points, allowed_rate, ";
$sql .= " keywords, notes, is_remote_rss, details_remote_url ";
$sql .= " FROM " . $table_prefix . "articles a ";
$sql .= " WHERE article_id= " . $db->tosql($article_id, INTEGER);
$db->query($sql);
$articles_top_categories = VA_Articles_Categories::find_all("c.category_id", array("c.category_name", "c.friendly_url"), array("where" => " c.parent_category_id=0 ", "order" => " ORDER BY c.category_order, c.category_name"));
if ($articles_top_categories) {
foreach ($articles_top_categories as $article_top_category_id => $articles_top_category) {
$show_categories = get_setting_value($sitemap_settings, "site_map_articles_categories_" . $article_top_category_id);
$show_items = get_setting_value($sitemap_settings, "site_map_articles_" . $article_top_category_id);
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;
function get_forced_friendly_url($script_url, &$db)
{
global $table_prefix, $settings;
$friendly_urls = get_setting_value($settings, "friendly_urls", 0);
$friendly_extension = get_setting_value($settings, "friendly_extension", "");
if (!$friendly_urls) {
return $script_url;
}
$friendly = get_custom_friendly_url($script_url);
if ($friendly != $script_url) {
return $friendly;
}
$parsed_url = parse_url($script_url);
$script_name = $parsed_url["path"];
if (isset($parsed_url["query"])) {
parse_str($parsed_url["query"], $script_vars);
} else {
return get_custom_friendly_url($script_name);
}
$friendly = "";
switch ($script_name) {
case "products.php":
if (isset($script_vars["category_id"])) {
$sql = " SELECT friendly_url FROM " . $table_prefix . "categories ";
$sql .= " WHERE category_id=" . $db->tosql($script_vars["category_id"], INTEGER);
$db->query($sql);
if ($db->next_record()) {
unset($script_vars["category_id"]);
$friendly = $db->f("friendly_url") . $friendly_extension;
}
} elseif (isset($script_vars["manf"])) {
$sql = " SELECT friendly_url FROM " . $table_prefix . "manufacturers ";
$sql .= " WHERE manufacturer_id=" . $db->tosql($script_vars["manf"], INTEGER);
$db->query($sql);
if ($db->next_record()) {
unset($script_vars["manf"]);
$friendly = $db->f("friendly_url") . $friendly_extension;
}
} else {
$friendly = get_custom_friendly_url("products.php");
}
break;
case "product_details.php":
if (isset($script_vars["item_id"])) {
$sql = " SELECT friendly_url FROM " . $table_prefix . "items ";
$sql .= " WHERE item_id=" . $db->tosql($script_vars["item_id"], INTEGER);
$db->query($sql);
if ($db->next_record()) {
unset($script_vars["item_id"]);
$friendly = $db->f("friendly_url") . $friendly_extension;
}
} else {
$friendly = get_custom_friendly_url("product_details.php");
}
break;
}
if ($friendly) {
$friendly_vars = "";
if ($script_vars) {
foreach ($script_vars as $key => $val) {
$friendly_vars .= $friendly_vars ? "&" : "?";
$friendly_vars .= $key . "=" . urlencode($val);
}
}
return $friendly . $friendly_vars;
} else {
return $script_url;
}
}
$a_title = get_translation($db->f("a_title"));
$t->set_var("cart_item_id", $db->f("cart_item_id"));
$t->set_var("date_added", va_date($datetime_show_format, $date_added));
$t->set_var("item_id", get_translation($item_id));
$t->set_var("a_title", htmlspecialchars($a_title));
$t->set_var("item_name", get_translation($db->f("item_name")));
$t->set_var("type_name", get_translation($db->f("type_name")));
$t->set_var("price", currency_format($price));
$t->set_var("quantity", $quantity);
$t->set_var("quantity_bought", $quantity_bought);
$t->set_var("cart_url", $cart_url->get_url());
$t->set_var("delete_url", $delete_url->get_url());
if ($friendly_urls && strlen($friendly_url)) {
$t->set_var("product_details_url", htmlspecialchars($friendly_url . $friendly_extension));
} else {
$product_link = get_custom_friendly_url("product_details.php") . "?item_id=" . $item_id;
$t->set_var("product_details_url", htmlspecialchars($product_link));
}
$small_image = $db->f($image_field);
$small_image_alt = get_translation($db->f($image_field_alt));
if (!strlen($small_image)) {
$image_exists = false;
$small_image = $product_no_image;
} elseif (!image_exists($small_image)) {
$image_exists = false;
$small_image = $product_no_image;
} else {
$image_exists = true;
}
if (strlen($small_image)) {
if (preg_match("/^http(s)?:\\/\\//", $small_image)) {
$search_category_id = get_param("search_category_id");
if (strlen($search_category_id)) {
$category_id = $search_category_id;
} elseif (!strlen($category_id)) {
$category_id = 0;
}
if ($category_id) {
if (VA_Categories::check_exists($category_id)) {
if (!VA_Categories::check_permissions($category_id, VIEW_CATEGORIES_ITEMS_PERM)) {
$site_url = get_setting_value($settings, "site_url", "");
$secure_url = get_setting_value($settings, "secure_url", "");
$secure_user_login = get_setting_value($settings, "secure_user_login", 0);
if ($secure_user_login) {
$user_login_url = $secure_url . get_custom_friendly_url("user_login.php");
} else {
$user_login_url = $site_url . get_custom_friendly_url("user_login.php");
}
$return_page = get_request_uri();
header("Location: " . $user_login_url . "?return_page=" . urlencode($return_page) . "&type_error=2&ssl=" . intval($is_ssl));
exit;
}
} else {
echo NO_RECORDS_MSG;
exit;
}
}
$manf = get_param("manf");
$list_template = "";
$current_category = "";
set_session("category_id", $current_category);
//Customization by Vital
$sub_menus[$submenu_id]["menu_path"] = $db->f("submenu_path");
$sub_menus[$submenu_id]["submenu_style_name"] = $db->f("submenu_style_name");
$sub_menus[$submenu_id]["match_type"] = $db->f("match_type");
$sub_menus[$parent_menu_id]["subs"][] = $submenu_id;
}
}
set_session("session_last_menu_id", $active_menu_id);
$submenu_style_name = "";
if (isset($menus[$active_menu_id])) {
$submenu_style_name = $menus[$active_menu_id]["submenu_style_name"];
}
if (!$submenu_style_name) {
$submenu_style_name = "secondary";
}
set_menus($sub_menus, 0, 0, $active_submenu_id, $top_menu_type, "secondary_", $submenu_style_name);
}
$t->set_var("index_href", get_custom_friendly_url("index.php"));
$t->set_var("products_href", get_custom_friendly_url("products.php"));
$t->set_var("basket_href", get_custom_friendly_url("basket.php"));
$t->set_var("user_profile_href", get_custom_friendly_url("user_profile.php"));
$t->set_var("admin_href", "admin.php");
$t->set_var("help_href", get_custom_friendly_url("page.php") . "?page=help");
$t->set_var("about_href", get_custom_friendly_url("page.php") . "?page=about");
if (!isset($header_title)) {
$header_title = "";
}
$t->set_var("header_title", $header_title);
$block_parsed = true;
$t->parse("block_body", false);
// clear previous block body content
$t->set_var("block_body", get_currency_message($t->get_var("block_body"), $currency));
}
if ($is_ajax) {
// json_encode for PHP4
if (sizeof($categories) > 0) {
echo "{";
foreach ($categories as $category_id => $category_name) {
echo '"' . $category_id . '":';
echo '"' . str_replace('"', '\\"', $category_name) . '",';
}
echo "}";
}
exit;
} else {
$html_template = get_setting_value($block, "html_template", "block_categories_chained_menu.html");
$t->set_file("block_body", $html_template);
$t->set_var("products_href", get_custom_friendly_url("products.php"));
foreach ($categories as $category_id => $category_name) {
$t->set_var("category_id", $category_id);
$t->set_var("category_name", htmlspecialchars($category_name));
$t->parse("category_option");
}
$block_parsed = true;
$t->parse("block_body", false);
}
} else {
// list type
$html_template = get_setting_value($block, "html_template", "block_categories_list.html");
$t->set_file("block_body", $html_template);
$t->set_var("categories_rows", "");
$t->set_var("categories", "");
$active_category_path = "0";
if ($fast_checkout_postcode_required == 1) {
$t->set_var("postcode_required", "*");
}
$t->parse("fast_checkout_postcode_textbox", false);
} else {
$t->set_var("fast_checkout_postcode_value", htmlspecialchars($user_details["postal_code"]));
$t->parse("fast_checkout_postcode_hidden", false);
}
// get order info url
$site_url = get_setting_value($settings, "site_url", "");
$secure_url = get_setting_value($settings, "secure_url", "");
$secure_order_profile = get_setting_value($settings, "secure_order_profile", 0);
if ($secure_order_profile) {
$order_info_url = $secure_url . get_custom_friendly_url("order_info.php");
} else {
$order_info_url = $site_url . get_custom_friendly_url("order_info.php");
}
// parse fast checkout options
foreach ($fast_checkouts as $payment_id => $fast_checkout) {
$fast_checkout_src = $fast_checkout["src"];
$t->set_var("fast_payment_id", $payment_id);
$t->set_var("fast_checkout_alt", $fast_checkout["alt"]);
$t->set_var("fast_checkout_image", "");
$t->set_var("fast_checkout_button", "");
$t->set_var("fast_checkout_width", "");
$t->set_var("fast_checkout_height", "");
if (strlen($fast_checkout_src)) {
// check if image src require some replacements
if (preg_match("/\\{[\\w\\d\\_\\-]+\\}/i", $fast_checkout_src)) {
$sql = " SELECT parameter_name, parameter_source ";
$sql .= " FROM " . $table_prefix . "payment_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;
$product_link .= strlen($details_query) ? "&" : "?";
$product_link .= "item_id=";
$reviews_link = get_custom_friendly_url("reviews.php") . $details_query;
$reviews_link .= strlen($details_query) ? "&" : "?";
$reviews_link .= "item_id=";
$t->set_var("rnd", $random_value);
$t->set_var("rp_url", urlencode($rp));
$t->set_var("rp", htmlspecialchars($rp));
$t->set_var("total_records", $total_records);
if ($total_records) {
$order_columns = $s->order_columns;
if ($order_columns) {
$group_by = $order_columns;
} else {
if ($db_type == "postgre") {
$group_by = "i.item_id, i.is_sales, i.sales_price, i.properties_price, i.price";
} else {
$group_by = "i.item_id";
if ($form_params) {
$payment_url .= strpos($payment_url, "?") ? "&" : "?";
$payment_url .= $form_params;
}
}
}
if (!$user_id) {
// set cookies with user info for non-registered users
$cookie_order_info = "";
for ($i = 0; $i < sizeof($parameters); $i++) {
$cookie_order_info .= $parameters[$i] . "=" . $r->get_value($parameters[$i]) . "|";
$cookie_order_info .= "delivery_" . $parameters[$i] . "=" . $r->get_value("delivery_" . $parameters[$i]) . "|";
}
setcookie("cookie_order_info", $cookie_order_info, va_timestamp() + 3600 * 24 * 366);
}
if ($payment_url == "credit_card_info.php" || $payment_url == get_custom_friendly_url("credit_card_info.php")) {
$payment_url .= "?order_id=" . urlencode($order_id) . "&vc=" . urlencode($vc);
}
if ($secure_payments && !preg_match("/^http\\:\\/\\//", $payment_url) && !preg_match("/^https\\:\\/\\//", $payment_url)) {
$payment_url = $secure_url . $payment_url;
}
//Customization by Vital
if (strpos($payment_url, "paypal") !== false) {
$t->set_var("dialog", true);
$t->set_var("dialog_url", $payment_url);
} else {
header("Location: " . $payment_url);
//original line
exit;
//original line
}
$t->set_file("block_body", $html_template);
}
$site_url = get_setting_value($settings, "site_url", "");
$secure_url = get_setting_value($settings, "secure_url", "");
$secure_user_login = get_setting_value($settings, "secure_user_login", 0);
if ($secure_user_login && !get_session("session_user_id")) {
// make secure login if user is not logged in
$user_login_url = $secure_url . get_custom_friendly_url("user_login.php");
$forgot_password_url = $secure_url . get_custom_friendly_url("forgot_password.php");
$login_form_url = $secure_url . $current_page;
} else {
$user_login_url = $site_url . get_custom_friendly_url("user_login.php");
$forgot_password_url = $site_url . get_custom_friendly_url("forgot_password.php");
$login_form_url = $site_url . $current_page;
}
$user_home_url = $site_url . get_custom_friendly_url("user_home.php");
$query_string = transfer_params("", true);
$return_page = get_param("return_page");
if (!$return_page) {
if ($is_ssl) {
$return_page = $secure_url . $current_page . $query_string;
} else {
$return_page = $site_url . $current_page . $query_string;
}
$return_page .= "#block_login_" . $pb_id;
}
$t->set_var("user_home_href", $user_home_url);
$t->set_var("forgot_password_href", $forgot_password_url);
$t->set_var("login_form_url", $login_form_url);
$t->set_var("return_page", htmlspecialchars($return_page));
$login_action = get_param("login_action");
$login = get_cookie("cookie_user_login");
$password = get_cookie("cookie_user_password");
if (strlen($login) && strlen($password)) {
$cookie_login = true;
} else {
$cookie_login = false;
$login = "";
$password = "";
}
$ssl = get_param("ssl");
$remember_me = get_param("remember_me");
$operation = get_param("operation");
$errors = "";
if (strlen($operation) || $cookie_login && !get_session("session_user_id")) {
if ($operation == "cancel") {
header("Location: " . $site_url . get_custom_friendly_url("index.php"));
exit;
} elseif ($operation == "logout") {
user_logout();
} else {
if (!$cookie_login) {
$login = get_param("login");
$password = get_param("password");
if (!strlen($login)) {
$error_message = str_replace("{field_name}", LOGIN_FIELD, REQUIRED_MESSAGE);
$errors .= $error_message . "<br>";
}
if (!strlen($password)) {
$error_message = str_replace("{field_name}", PASSWORD_FIELD, REQUIRED_MESSAGE);
$errors .= $error_message . "<br>";
}
//$t->parse("not_rated", false);
}
}
// parse tabs
$tab = get_param("tab");
if (!strlen($tab) && count($tabs) > 0) {
$tab_keys = array_keys($tabs);
$tab = $tab_keys[0];
}
$t->set_var("tab", htmlspecialchars($tab));
if ($use_tabs) {
if ($friendly_urls && $friendly_url) {
$tab_transfer_query = transfer_params(array("item_id"), false);
$tab_href = $friendly_url . $friendly_extension . $tab_transfer_query;
} else {
$tab_href = get_custom_friendly_url("product_details.php") . $transfer_query;
}
if (strrpos($tab_href, "?")) {
$tab_href .= "&tab=";
} else {
$tab_href .= "?tab=";
}
foreach ($tabs as $tab_name => $tab_title) {
if ($tab == $tab_name) {
$tab_style = "tabActive";
$data_style = "display: block;";
} else {
$tab_style = "tab";
$data_style = "display: none;";
}
$t->set_var("tab_id", $tab_name . "_tab");
$tree_url = $friendly_url . $friendly_extension . $query_string;
} else {
$ps_parameters["item_id"] = $item_id;
$query_string = get_query_string($ps_parameters, "", "", false);
$tree_url = get_custom_friendly_url("product_details.php") . $query_string;
}
$tree_title = $item_name;
if ($erase_tags) {
$tree_title = strip_tags($tree_title);
}
$breadcrumbs_tree_array[] = array($tree_url, $tree_title);
}
}
if (isset($is_reviews) && $is_reviews) {
$query_string = get_query_string($ps_parameters, "", "", false);
$tree_url = get_custom_friendly_url("reviews.php") . $query_string;
$tree_title = REVIEWS_MSG;
if ($erase_tags) {
$tree_title = strip_tags($tree_title);
}
$breadcrumbs_tree_array[] = array($tree_url, $tree_title);
}
$ic = count($breadcrumbs_tree_array) - 1;
for ($i = 0; $i < $ic; $i++) {
$t->set_var("tree_url", htmlspecialchars($breadcrumbs_tree_array[$i][0]));
$t->set_var("tree_title", htmlspecialchars($breadcrumbs_tree_array[$i][1]));
$t->set_var("tree_class", "");
$t->parse("tree", true);
}
if ($ic >= 0) {
$t->set_var("tree_url", htmlspecialchars($breadcrumbs_tree_array[$ic][0]));
case "SUBSCRIPTION":
// add subscription to the cart
$sc_subscription_id = get_param("subscription_id");
$sc_group_id = get_param("group_id");
/* start of adding item to the cart */
$subscription_added = add_subscription(0, $sc_subscription_id, $sc_subscription_name, $sc_group_id);
/* end of adding item to the cart */
if ($subscription_added) {
$rp = get_param("rp");
if (isset($settings["redirect_to_cart"])) {
if ($settings["redirect_to_cart"] == 1) {
$cart_page = strlen($rp) ? get_custom_friendly_url("basket.php") . "?rp=" . urlencode($rp) : get_custom_friendly_url("basket.php");
header("Location: " . $cart_page);
exit;
} elseif ($settings["redirect_to_cart"] == 2) {
header("Location: " . get_custom_friendly_url("checkout.php"));
exit;
}
}
}
break;
case "RM":
// remove the item from the cart
$shopping_cart = get_session("shopping_cart");
if (is_array($shopping_cart)) {
$cart_id = get_param("cart_id");
$cart_subscription_type_id = isset($shopping_cart[$cart_id]["SUBSCRIPTION_TYPE_ID"]) ? $shopping_cart[$cart_id]["SUBSCRIPTION_TYPE_ID"] : "";
$new_user_type = get_session("session_new_user");
unset($shopping_cart[$cart_id]);
if ($cart_subscription_type_id && $new_user_type == "expired") {
// in case user delete his account subscription then we need to remove his new user data
if (!$r->parameter_exists("email")) {
$r->add_textbox("email", TEXT);
}
$r->set_value("email", $r->get_value("login"));
}
if ($db_type == "postgre") {
$user_id = get_db_value(" SELECT NEXTVAL('seq_" . $table_prefix . "users') ");
$r->change_property("user_id", USE_IN_INSERT, true);
$r->set_value("user_id", $user_id);
}
$registration_date = va_time();
$r->set_value("registration_date", $registration_date);
$r->set_value("registration_ip", $user_ip);
$r->set_value("last_visit_date", $registration_date);
$r->set_value("last_visit_ip", $user_ip);
$r->set_value("last_visit_page", get_custom_friendly_url("user_profile.php"));
if ($is_subscription) {
$expiry_date = va_time();
// set expiry_date and suspend_date as yesterday
$expiry_date_ts = mktime(0, 0, 0, $expiry_date[MONTH], $expiry_date[DAY] - 1, $expiry_date[YEAR]);
$r->set_value("expiry_date", $expiry_date_ts);
$r->set_value("suspend_date", $expiry_date_ts);
}
$password_encrypt = get_setting_value($settings, "password_encrypt", 0);
$plain_password = $r->get_value("password");
set_session("session_plain_password", $plain_password);
if ($password_encrypt == 1) {
$r->set_value("password", md5($plain_password));
}
if ($r->insert_record()) {
if ($db_type == "mysql") {
// TODO: check if block_key could be used for $top_category_id
$records_per_page = get_setting_value($vars, "articles_products_cats_recs", 5);
$related_columns_param = "articles_products_cats_cols";
} else {
$block_parsed = true;
return;
}
$html_template = get_setting_value($block, "html_template", "block_related_products.html");
$t->set_file("block_body", $html_template);
$t->set_var("product_details_href", "product_details.php");
if ($friendly_urls && $page_friendly_url) {
$pass_parameters = get_transfer_params($page_friendly_params);
$main_page = $page_friendly_url . $friendly_extension;
} 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;
$r->add_where("user_id", INTEGER);
$r->add_textbox("modified_date", DATETIME);
$r->add_textbox("current_password", TEXT, CURRENT_PASS_FIELD);
$r->change_property("current_password", USE_IN_UPDATE, false);
$r->change_property("current_password", REQUIRED, true);
$r->add_textbox("password", TEXT, NEW_PASS_FIELD);
$r->change_property("password", REQUIRED, true);
$r->change_property("password", MIN_LENGTH, 5);
$r->add_textbox("confirm", TEXT, CONFIRM_PASS_FIELD);
$r->change_property("confirm", USE_IN_UPDATE, false);
$r->change_property("password", MATCHED, "confirm");
$action = get_param("action");
$user_id = get_session("session_user_id");
$site_url = get_setting_value($settings, "site_url", "");
$secure_user_profile = get_setting_value($settings, "secure_user_profile", 0);
$return_page = $site_url . get_custom_friendly_url("user_home.php");
$errors = "";
$r->get_form_values();
if (strlen($action)) {
if ($action == "cancel") {
header("Location: " . $return_page);
exit;
}
$r->validate();
$password_encrypt = get_setting_value($settings, "password_encrypt", 0);
if (!$r->is_empty("current_password")) {
$current_password = $r->get_value("current_password");
if ($password_encrypt == 1) {
$password_match = md5($current_password);
} else {
$password_match = $current_password;
