tosql($category_id, INTEGER, true, false); $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_small = $db->f("image_small"); $image_small_alt = $db->f("image_small_alt"); $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"); $total_views = $db->f("total_views"); $is_remote_rss = $db->f("is_remote_rss"); $remote_rss_url = $db->f("remote_rss_url"); $remote_rss_date_updated = $db->f("remote_rss_date_updated", DATETIME); $remote_rss_refresh_rate = $db->f("remote_rss_refresh_rate"); $remote_rss_ttl = $db->f("remote_rss_ttl"); if ($db->f("is_rss") && $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; } elseif (strlen($full_description)) { $meta_description = $full_description; } else { $meta_description = $top_name; } } // check for remote RSS links if ($is_remote_rss == 1) { $articles_imported = articles_import_rss($is_remote_rss, $remote_rss_url, $remote_rss_date_updated, $remote_rss_refresh_rate, $remote_rss_ttl); } // update total views for articles categories $articles_cats_viewed = get_session("session_articles_cats_viewed"); if (!isset($articles_cats_viewed[$category_id])) { $sql = " UPDATE " . $table_prefix . "articles_categories SET total_views=" . $db->tosql(($total_views + 1), INTEGER); $sql .= " WHERE category_id=" . $db->tosql($category_id, INTEGER); $db->query($sql); $articles_cats_viewed[$category_id] = true; set_session("session_articles_cats_viewed", $articles_cats_viewed); } } else { echo NO_RECORDS_MSG; exit; } $page_name = "a_list_" . $top_id; $page_settings = va_page_settings($page_name, 0); $desc_image = get_setting_value($page_settings, "a_cat_desc_image_" . $top_id, 3); $desc_type = get_setting_value($page_settings, "a_cat_desc_type_" . $top_id, 2); $category_image = ""; $category_image_alt = ""; if ($desc_image == 3) { $category_image = $image_large; $category_image_alt = $image_large_alt; } elseif ($desc_image == 2) { $category_image = $image_small; $category_image_alt = $image_small_alt; } $category_description = ""; if ($desc_type == 2) { $category_description = $full_description; } elseif ($desc_type == 1) { $category_description = $short_description; } $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); } elseif (preg_match("/^a_subcats_(\d+)$/", $setting_name, $matches)) { articles_categories($setting_value, $matches[1], $top_name, "a_subcats", $category_id); } elseif (preg_match("/^a_breadcrumb_(\d+)$/", $setting_name, $matches)) { articles_breadcrumb($setting_value, $matches[1], $rss_on_breadcrumb); } elseif (preg_match("/^a_list_(\d+)$/", $setting_name, $matches)) { articles_list($setting_value, $matches[1], $list_fields, $articles_order_column, $articles_order_direction, $current_category, $list_template, $page_friendly_url, $page_friendly_params); } elseif (preg_match("/^a_cat_desc_(\d+)$/", $setting_name, $matches)) { articles_category($setting_value, $category_id, $current_category, $category_description, $category_image, $category_image_alt); } elseif (preg_match("/^a_latest_(\d+)$/", $setting_name, $matches)) { articles_latest($setting_value, $matches[1], $top_name); } elseif (preg_match("/^a_top_rated_(\d+)$/", $setting_name, $matches)) { articles_top_rated($setting_value, $matches[1], $top_name); } elseif (preg_match("/^a_top_viewed_(\d+)$/", $setting_name, $matches)) { articles_top_viewed($setting_value, $matches[1], $top_name); } elseif (preg_match("/^a_hot_(\d+)$/", $setting_name, $matches)) { articles_hot($setting_value, $matches[1], $top_name, $list_fields, $articles_order_column, $articles_order_direction, $category_id, $page_friendly_url, $page_friendly_params); } elseif (preg_match("/^a_content_(\d+)$/", $setting_name, $matches)) { articles_content($setting_value, $matches[1], $category_id, $current_category, $articles_order_column, $articles_order_direction); } elseif (preg_match("/^a_search_(\d+)$/", $setting_name, $matches)) { articles_search($setting_value, $matches[1], $top_name, $category_id); } elseif (preg_match("/^a_cat_item_related_(\d+)$/", $setting_name, $matches)) { include_once("./blocks/block_products_related.php"); related_products($setting_value, "articles_category_items_related", $page_friendly_url, $page_friendly_params); } elseif ($setting_name == "cart_block") { include_once("./blocks/block_cart.php"); small_cart($setting_value); } elseif ($setting_name == "login_block") { login_form($setting_value); } elseif ($setting_name == "subscribe_block") { include_once("./blocks/block_subscribe.php"); subscribe_form($setting_value); } elseif ($setting_name == "sms_test_block") { include_once("./blocks/block_sms_test.php"); sms_test_form($setting_value); } elseif ($setting_name == "poll_block") { poll_form($setting_value); } elseif ($setting_name == "language_block") { include_once("./blocks/block_language.php"); language_form($setting_value, $page_settings["language_selection"], "", $page_friendly_url, $page_friendly_params); } elseif ($setting_name == "currency_block") { include_once("./blocks/block_currency.php"); currency_form($setting_value); } elseif ($setting_name == "layouts_block") { include_once("./blocks/block_layouts.php"); layouts($setting_value, "", $page_friendly_url, $page_friendly_params); } elseif (preg_match("/^navigation_block_(\d+)$/", $setting_name, $matches)) { include_once("./blocks/block_navigation.php"); navigation_menu($setting_value, $matches[1]); } elseif (preg_match("/^custom_block_/", $setting_name)) { custom_block($setting_value, substr($setting_name, 13)); } elseif (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"); ?>