$admin_downloadable_export_url = new VA_URL("admin_export.php", false);
$admin_downloadable_export_url->add_parameter("table", CONSTANT, "items_files");
$admin_downloadable_export_url->add_parameter("id", REQUEST, "id");
$admin_downloadable_export_url->add_parameter("ids", REQUEST, "ids");
$admin_downloadable_export_url->add_parameter("category_id", REQUEST, "category_id");
$admin_downloadable_export_url->add_parameter("s", REQUEST, "s");
$admin_downloadable_export_url->add_parameter("sl", REQUEST, "sl");
$admin_downloadable_export_url->add_parameter("ss", REQUEST, "ss");
$admin_downloadable_export_url->add_parameter("ap", REQUEST, "ap");
$t->set_var("admin_downloadable_export_url", $admin_downloadable_export_url->get_url());
$t->parse("products_other_links", false);
}
} else {
if ($table == "orders") {
$admin_orders_url = new VA_URL("admin_orders.php", false);
$admin_orders_url->add_parameter("ids", REQUEST, "ids");
$admin_orders_url->add_parameter("page", REQUEST, "page");
$admin_orders_url->add_parameter("s_on", REQUEST, "s_on");
$admin_orders_url->add_parameter("s_ne", REQUEST, "s_ne");
$admin_orders_url->add_parameter("s_kw", REQUEST, "s_kw");
//Customization by Vital
$admin_orders_url->add_parameter("s_coupon", REQUEST, "s_coupon");
$admin_orders_url->add_parameter("s_sku", REQUEST, "s_sku");
$admin_orders_url->add_parameter("s_category", REQUEST, "s_category");
//END customization
$admin_orders_url->add_parameter("s_sd", REQUEST, "s_sd");
$admin_orders_url->add_parameter("s_ed", REQUEST, "s_ed");
$admin_orders_url->add_parameter("s_os", REQUEST, "s_os");
$admin_orders_url->add_parameter("s_ci", REQUEST, "s_ci");
$admin_orders_url->add_parameter("s_si", REQUEST, "s_si");
$admin_orders_url->add_parameter("s_ex", REQUEST, "s_ex");
$user_login_url = $secure_url . get_custom_friendly_url("user_login.php");
$forgot_password_url = $secure_url . get_custom_friendly_url("forgot_password.php");
} 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");
}
if ($secure_user_profile) {
$user_profile_url = $secure_url . get_custom_friendly_url("user_profile.php");
} else {
$user_profile_url = $site_url . get_custom_friendly_url("user_profile.php");
}
$user_home_url = $site_url . get_custom_friendly_url("user_home.php");
$return_page = get_param("return_page");
if (!$is_ssl && $secure_user_login && $secure_redirect && preg_match("/^https/i", $secure_url)) {
$ulu = new VA_URL($user_login_url, false);
$ulu->add_parameter("return_page", REQUEST, "return_page");
$ulu->add_parameter("type_error", REQUEST, "type_error");
header("Location: " . $ulu->get_url());
exit;
}
//Customization by Vital - login redirection
if (!strlen($return_page) && isset($_SERVER['HTTP_REFERER']) && (strpos($_SERVER['HTTP_REFERER'], $site_url) !== false || strpos($_SERVER['HTTP_REFERER'], $secure_url) !== false)) {
$return_page = $_SERVER['HTTP_REFERER'];
}
//END customization - - login redirection
if (!strlen($return_page)) {
$return_page = $user_home_url;
}
$t->set_var("login_desc", $login_desc);
$t->set_var("user_login_href", $user_login_url);
$t->set_var("user_home_href", get_custom_friendly_url("user_home.php"));
$sql .= " FROM ((" . $table_prefix . "saved_items si ";
$sql .= " LEFT JOIN " . $table_prefix . "saved_types st ON st.type_id=si.type_id) ";
$sql .= " LEFT JOIN " . $table_prefix . "items i ON i.item_id=si.item_id) ";
$sql .= " WHERE si.user_id=" . $db->tosql($_COOKIE['wishlist_user_id'], INTEGER);
$sql .= " AND si.cart_id=0 ";
$sql .= $s->order_by;
$db->query($sql);
if ($db->next_record()) {
$t->parse("sorters", false);
$t->set_var("no_records", "");
$t->set_var("wishlist_message", "<p>Here is a list of the items you have selected.</p>Your wishlist is saved on this browser on this computer only. If you want to see your wishlist from another computer please <a href=\"./user_login.php?return_page=" . urlencode($site_url . get_custom_friendly_url('user_wishlist.php')) . "\">login to save it</a>.<br /><br />");
$cart_url = new VA_URL("user_wishlist.php", false);
$cart_url->add_parameter("cart_item_id", DB, "cart_item_id");
$cart_url->add_parameter("operation", CONSTANT, "add");
$delete_url = new VA_URL("user_wishlist.php", false);
$delete_url->add_parameter("cart_item_id", DB, "cart_item_id");
$delete_url->add_parameter("operation", CONSTANT, "delete");
do {
$cart_item_id = $db->f("cart_item_id");
$item_id = $db->f("item_id");
$price = $db->f("price");
$quantity = $db->f("quantity");
$quantity_bought = $db->f("quantity_bought");
$item_name = $db->f("item_name");
$type_name = $db->f("type_name");
$friendly_url = $db->f("friendly_url");
$date_added = $db->f("date_added", DATETIME);
$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));
}
if (isset($permissions["remove_orders"]) && $permissions["remove_orders"] == 1) {
$t->parse("remove_orders_button", false);
}
}
if (strlen($orders_errors)) {
$t->set_var("errors_list", $orders_errors);
$t->parse("orders_errors", false);
}
if (strlen($recurring_success)) {
$t->set_var("messages_list", $recurring_success);
$t->parse("orders_messages", false);
}
if (strlen($where) && $total_records > 0) {
$admin_export_filtered_url = new VA_URL("admin_export.php", true);
$admin_export_filtered_url->add_parameter("table", CONSTANT, "orders");
$admin_export_filtered_url->add_parameter("type", CONSTANT, "filtered");
$t->set_var("admin_export_filtered_url", $admin_export_filtered_url->get_url());
$t->set_var("total_filtered", $total_records);
$t->parse("export_filtered", false);
}
if (isset($permissions["create_orders"]) && $permissions["create_orders"] == 1) {
$t->parse("generate_recurring", false);
}
$sql = " SELECT exported_order_id FROM " . $table_prefix . "admins ";
$sql .= " WHERE admin_id=" . $db->tosql(get_session("session_admin_id"), INTEGER);
$exported_order_id = intval(get_db_value($sql));
$sql = " SELECT COUNT(*) FROM " . $table_prefix . "orders ";
$sql .= " WHERE order_id>" . $db->tosql($exported_order_id, INTEGER);
$total_new = get_db_value($sql);
if ($total_new > 0) {
$is_next_record = $db->next_record();
$is_new_top = $top_category_id != $db->f("top_category_id");
if ($categories_type == 2) {
if (intval($shown_sub_categories) >= $catalog_sub_number || $shown_sub_categories == 0) {
if ($sub_category_id && (!$allowed_sub_categories_ids || !in_array($sub_category_id, $allowed_sub_categories_ids))) {
$t->set_var("restricted_sub_class", " restrictedSubCategory");
$t->sparse("restricted_sub_image", false);
} else {
$t->set_var("restricted_sub_class", "");
$t->set_var("restricted_sub_image", "");
}
if ($friendly_urls && $sub_friendly_url) {
$list_url->remove_parameter("category_id");
$t->set_var("list_url", htmlspecialchars($list_url->get_url($sub_friendly_url . $friendly_extension)));
} else {
$list_url->add_parameter("category_id", CONSTANT, $sub_category_id);
$t->set_var("list_url", htmlspecialchars($list_url->get_url($list_page)));
}
if ($category_id == $sub_category_id) {
$t->set_var("class_sub_selected", "selectedsubCategory");
} else {
$t->set_var("class_sub_selected", "subCategory");
}
if ($is_next_record && !$is_new_top) {
$t->parse("catalog_sub_separator", false);
} else {
$t->set_var("catalog_sub_separator", "");
}
$t->parse("catalog_sub", true);
} elseif ($shown_sub_categories + 1 == $catalog_sub_number) {
if ($friendly_urls && $top_friendly_url) {
