tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $category_id = $db->f("category_id"); set_get_param("category_id", $category_id); $page_name = "products.php"; } } // check product details page if (!$page_name) { $sql = " SELECT item_id FROM " . $table_prefix . "items "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $item_id = $db->f("item_id"); set_get_param("item_id", $item_id); $page_name = "product_details.php"; } } // check manufacturers page if (!$page_name) { $sql = " SELECT manufacturer_id FROM " . $table_prefix . "manufacturers "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $manufacturer_id= $db->f("manufacturer_id"); set_get_param("manf", $manufacturer_id); $page_name = "products.php"; } } // check user list page if (!$page_name) { $sql = " SELECT user_id FROM " . $table_prefix . "users "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $user_id = $db->f("user_id"); set_get_param("user", $user_id); $page_name = "user_list.php"; } } // check articles categories if (!$page_name) { $sql = " SELECT category_id FROM " . $table_prefix . "articles_categories "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $category_id = $db->f("category_id"); set_get_param("category_id", $category_id); $page_name = "articles.php"; } } // check article details page if (!$page_name) { $sql = " SELECT article_id FROM " . $table_prefix . "articles "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $article_id = $db->f("article_id"); set_get_param("article_id", $article_id); $page_name = "article.php"; } } // check forum categories if (!$page_name) { $sql = " SELECT category_id FROM " . $table_prefix . "forum_categories "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $category_id = $db->f("category_id"); set_get_param("category_id", $category_id); $page_name = "forums.php"; } } // check forum if (!$page_name) { $sql = " SELECT forum_id FROM " . $table_prefix . "forum_list "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $forum_id = $db->f("forum_id"); set_get_param("forum_id", $forum_id); $page_name = "forum.php"; } } // check forum topic if (!$page_name) { $sql = " SELECT thread_id FROM " . $table_prefix . "forum "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $thread_id = $db->f("thread_id"); set_get_param("thread_id", $thread_id); $page_name = "forum_topic.php"; } } // check ads categories if (!$page_name) { $sql = " SELECT category_id FROM " . $table_prefix . "ads_categories "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $category_id = $db->f("category_id"); set_get_param("category_id", $category_id); $page_name = "ads.php"; } } // check ads items if (!$page_name) { $sql = " SELECT item_id FROM " . $table_prefix . "ads_items "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $item_id = $db->f("item_id"); set_get_param("item_id", $item_id); $page_name = "ads_details.php"; } } // check custom page if (!$page_name) { $sql = " SELECT page_code FROM " . $table_prefix . "pages "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $page_code = $db->f("page_code"); set_get_param("page", $page_code); $page_name = "page.php"; } } // check manuals list if (!$page_name) { $sql = " SELECT manual_id FROM " . $table_prefix . "manuals_list "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $manual_id = $db->f("manual_id"); set_get_param("manual_id", $manual_id); $page_name = "manuals_articles.php"; } } // check manual article if (!$page_name) { $sql = " SELECT article_id FROM " . $table_prefix . "manuals_articles "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $article_id = $db->f("article_id"); set_get_param("article_id", $article_id); $page_name = "manuals_article_details.php"; } } // check manual categories if (!$page_name) { $sql = " SELECT category_id FROM " . $table_prefix . "manuals_categories "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $category_id = $db->f("category_id"); set_get_param("category_id", $category_id); $page_name = "manuals.php"; } } if (!$page_name) { $sql = " SELECT script_name FROM " . $table_prefix . "friendly_urls "; $sql .= " WHERE friendly_url=" . $db->tosql($friendly_url, TEXT); $db->query($sql); if ($db->next_record()) { $page_name = $db->f("script_name"); } } if ($page_name) { header("HTTP/1.0 200 OK"); header("Status: 200 OK"); include_once($page_name); return; } else { $is_friendly_url = false; header("HTTP/1.0 404 Not Found"); header("Status: 404 Not Found"); exit; } function set_get_param($param_name, $param_value) { global $HTTP_GET_VARS; if (isset($_GET)) { $_GET[$param_name] = $param_value; } else { $HTTP_GET_VARS[$param_name] = $param_value; } } ?>