tosql($category_id, INTEGER); $db->query($sql); if($db->next_record()) { $current_category = get_translation($db->f("category_name")); $page_friendly_url = $db->f("friendly_url"); $short_description = get_translation($db->f("short_description")); $full_description = get_translation($db->f("full_description")); $image_large = $db->f("image_large"); $image_large_alt = $db->f("image_large_alt"); $parent_category_id = $db->f("parent_category_id"); $category_path = $db->f("category_path"); if ($db->f("is_rss") and $db->f("rss_on_breadcrumb")){ $rss_on_breadcrumb = true; } else { $rss_on_breadcrumb = false; } // meta data $html_title = get_translation($db->f("meta_title")); $meta_description = get_translation($db->f("meta_description")); $meta_keywords = get_translation($db->f("meta_keywords")); if($parent_category_id == 0) { $top_id = $category_id; $top_name = $current_category; $list_template = $db->f("articles_list_template"); $articles_order_column = $db->f("articles_order_column"); $articles_order_direction = $db->f("articles_order_direction"); $list_fields = $db->f("article_list_fields"); } else { $categories_ids = explode(",", $category_path); $top_id = $categories_ids[1]; $sql = " SELECT category_name, articles_list_template, articles_order_column,articles_order_direction, article_list_fields "; $sql .= " FROM " . $table_prefix . "articles_categories "; $sql .= " WHERE category_id=" . $db->tosql($top_id, INTEGER); $db->query($sql); if ($db->next_record()) { $top_name = get_translation($db->f("category_name")); $list_template = $db->f("articles_list_template"); $articles_order_column = $db->f("articles_order_column"); $articles_order_direction = $db->f("articles_order_direction"); $list_fields = $db->f("article_list_fields"); } } if (!strlen($html_title)) { $html_title = $current_category; } if (!strlen($meta_description)) { if (strlen($short_description)) { $meta_description = $short_description; } else if (strlen($full_description)) { $meta_description = $full_description; } else { $meta_description = $top_name; } } } else { echo NO_RECORDS_MSG; exit; } if (strlen($articles_order_column)) { $articles_order = " ORDER BY a." . $articles_order_column . " " . $articles_order_direction; } else { $articles_order = " ORDER BY a.article_order "; } $page_name = "a_list_" . $top_id; $page_settings = va_page_settings($page_name, 0); $t = new VA_Template($settings["templates_dir"]); $t->set_file("main","articles.html"); $t->set_var("current_href", "articles.php"); include_once ("./header.php"); if(is_array($page_settings)) { foreach($page_settings as $setting_name => $setting_value) { if (preg_match("/^a_cats_(\d+)$/", $setting_name, $matches)) { articles_categories($setting_value, $matches[1], $top_name, "a_cats", $category_id); } else if (preg_match("/^a_subcats_(\d+)$/", $setting_name, $matches)) { articles_categories($setting_value, $matches[1], $top_name, "a_subcats", $category_id); } else if (preg_match("/^a_breadcrumb_(\d+)$/", $setting_name, $matches)) { articles_breadcrumb($setting_value, $matches[1], $rss_on_breadcrumb); } else if (preg_match("/^a_list_(\d+)$/", $setting_name, $matches)) { articles_list($setting_value, $matches[1], $list_fields, $articles_order, $current_category, $list_template, $page_friendly_url, $page_friendly_params); } else if (preg_match("/^a_cat_desc_(\d+)$/", $setting_name, $matches)) { articles_category($setting_value, $category_id, $current_category, $full_description, $image_large, $image_large_alt); } else if (preg_match("/^a_latest_(\d+)$/", $setting_name, $matches)) { articles_latest($setting_value, $matches[1], $top_name); } else if (preg_match("/^a_top_rated_(\d+)$/", $setting_name, $matches)) { articles_top_rated($setting_value, $matches[1], $top_name); } else if (preg_match("/^a_top_viewed_(\d+)$/", $setting_name, $matches)) { articles_top_viewed($setting_value, $matches[1], $top_name); } else if (preg_match("/^a_hot_(\d+)$/", $setting_name, $matches)) { articles_hot($setting_value, $matches[1], $top_name, $list_fields, $articles_order, $category_id, $page_friendly_url, $page_friendly_params); } else if (preg_match("/^a_content_(\d+)$/", $setting_name, $matches)) { articles_content($setting_value, $matches[1], $category_id, $current_category, $articles_order); } else if (preg_match("/^a_search_(\d+)$/", $setting_name, $matches)) { articles_search($setting_value, $matches[1], $top_name, $category_id); } else if ($setting_name == "cart_block") { include_once ("./block_cart.php"); small_cart($setting_value); } else if ($setting_name == "login_block") { login_form($setting_value); } else if ($setting_name == "subscribe_block") { include_once ("./block_subscribe.php"); subscribe_form($setting_value); } else if ($setting_name == "sms_test_block") { include_once ("./block_sms_test.php"); sms_test_form($setting_value); } else if ($setting_name == "poll_block") { poll_form($setting_value); } else if ($setting_name == "language_block") { include_once ("./block_language.php"); language_form($setting_value, $page_settings["language_selection"]); } else if ($setting_name == "currency_block") { include_once ("./block_currency.php"); currency_form($setting_value); } else if (preg_match("/^navigation_block_(\d+)$/", $setting_name, $matches)) { include_once("./block_navigation.php"); navigation_menu($setting_value, $matches[1]); } else if (preg_match("/^custom_block_/", $setting_name)) { custom_block($setting_value, substr($setting_name, 13)); } else if (preg_match("/^banners_group_/", $setting_name)) { banners_group($setting_value, substr($setting_name, 14)); } } } if(!get_setting_value($page_settings, "left_column_hide", 0)) { $t->set_var("left_column_width", get_setting_value($page_settings, "left_column_width", "20%")); $t->parse("left_column", false); } if(!get_setting_value($page_settings, "middle_column_hide", 0)) { $t->set_var("middle_column_width", get_setting_value($page_settings, "middle_column_width", "60%")); $t->parse("middle_column", false); } if(!get_setting_value($page_settings, "right_column_hide", 0)) { $t->set_var("right_column_width", get_setting_value($page_settings, "right_column_width", "20%")); $t->parse("right_column", false); } include_once ("./footer.php"); $t->set_var("current_category", $current_category); $t->set_var("html_title", $html_title); $t->set_var("meta_keywords", $meta_keywords); $t->set_var("meta_description", get_meta_desc($meta_description)); $t->pparse("main"); ?>