示例#1
0
 } else {
     $from_where = "FROM links, sub_statuses WHERE id = {$site_id} AND status='{$status}' AND date > date_sub(now(), interval 7 day) AND link_id = link";
 }
 // Check if it's search
 if ($_REQUEST['q']) {
     $order_field = 'link_date';
     // Because sub_statuses is not used
     if ($search) {
         $from_where = "FROM links WHERE {$search} ";
     } else {
         $from_where = "FROM links WHERE false ";
         // Force to return empty set
     }
     $title = $globals['site_name'] . ": " . htmlspecialchars(strip_tags($_REQUEST['q']));
 } elseif ($meta = check_integer('meta')) {
     $cat_list = SitesMgr::get_category_ids($meta);
     if (!$cat_list) {
         not_found();
     }
     $cat_list = implode(',', $cat_list);
     $from_where .= " AND category in ({$cat_list})";
     $meta_name = $db->get_var("SELECT category_name FROM categories WHERE category_id = {$meta} AND category_parent=0");
     $title .= " -{$meta_name}-";
 } elseif ($cat = check_integer('category')) {
     $from_where .= " AND category={$cat} ";
     $category_name = $db->get_var("SELECT category_name FROM categories WHERE category_id = {$cat} AND category_lang='{$dblang}'");
     $title .= " -{$category_name}-";
 } elseif ($uid = check_integer('personal')) {
     $categories = $db->get_col("SELECT pref_value FROM prefs WHERE pref_user_id = {$uid} and pref_key = 'category_" . SitesMgr::my_id() . "' ");
     $user_login = $db->get_var("select user_login from users where user_id={$uid}");
     $title .= " -{$user_login}-";