*** 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;