WordPress.org
Get WordPress

Plugin Directory

Changeset 174194


Ignore:
Timestamp:
11/16/2009 03:06:27 PM (16 years ago)
Author:
sulaeman
Message:

fix search

Location:
user-link-feed
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • user-link-feed/tags/1.1.0/user-link-feed-class.php

    r174188 r174194  
    8787            case 'new':
    8888                $n_feed = $wpdb->get_var('SELECT count(meta_key) as n_new_feed FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"0\";%" LIMIT 1');
    89                 $feeds = $wpdb->get_results('SELECT meta_id, meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"0\";%" ORDER BY meta_key DESC LIMIT ' . (($current_page - 1) * $max_feeds_per_page) . ', ' . $max_feeds_per_page, ARRAY_A);
     89                $feeds = $wpdb->get_results('SELECT meta_id, meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"0\";%" ORDER BY meta_id DESC LIMIT ' . (($current_page - 1) * $max_feeds_per_page) . ', ' . $max_feeds_per_page, ARRAY_A);
    9090            break;
    9191            case 'approved':
    92                 $n_feed = $wpdb->get_var('SELECT count(meta_key) as n_new_feed FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";i:1;%" LIMIT 1');
    93                 $feeds = $wpdb->get_results('SELECT meta_id, meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";i:1;%" ORDER BY meta_key DESC LIMIT ' . (($current_page - 1) * $max_feeds_per_page) . ', ' . $max_feeds_per_page, ARRAY_A);
     92                $n_feed = $wpdb->get_var('SELECT count(meta_key) as n_new_feed FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"1\";%" LIMIT 1');
     93                $feeds = $wpdb->get_results('SELECT meta_id, meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"1\";%" ORDER BY meta_id DESC LIMIT ' . (($current_page - 1) * $max_feeds_per_page) . ', ' . $max_feeds_per_page, ARRAY_A);
    9494            break;
    9595            default:
    9696                $n_feed = $n_all_feed;
    97                 $feeds = $wpdb->get_results('SELECT meta_id, meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" ORDER BY meta_key DESC LIMIT ' . (($current_page - 1) * $max_feeds_per_page) . ', ' . $max_feeds_per_page, ARRAY_A);
     97                $feeds = $wpdb->get_results('SELECT meta_id, meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" ORDER BY meta_id DESC LIMIT ' . (($current_page - 1) * $max_feeds_per_page) . ', ' . $max_feeds_per_page, ARRAY_A);
    9898            break;
    9999        }
    … …  
    199199        $curr_feed_page = (isset($paged) && $paged > 0) ? $paged : 1;
    200200       
    201         $n_feed = $wpdb->get_var('SELECT count(meta_key) as n_new_feed FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";i:1%" LIMIT 1');
    202         $feeds = $wpdb->get_results('SELECT meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";i:1%" ORDER BY meta_key DESC LIMIT ' . (($curr_feed_page - 1) * $max_feed_per_page) . ', ' . $max_feed_per_page, ARRAY_A);
     201        $n_feed = $wpdb->get_var('SELECT count(meta_key) as n_new_feed FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"1\";%" LIMIT 1');
     202        $feeds = $wpdb->get_results('SELECT meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"1\";%" ORDER BY meta_id DESC LIMIT ' . (($curr_feed_page - 1) * $max_feed_per_page) . ', ' . $max_feed_per_page, ARRAY_A);
    203203       
    204204        if ($use_pagination)
    … …  
    219219       
    220220        ob_start();
    221        
    222221        require ULF_DIR . '/display/' . $template;
    223        
    224222        $output = ob_get_contents();
    225223        ob_end_clean();

  • user-link-feed/trunk/user-link-feed-class.php

    r174186 r174194  
    8787            case 'new':
    8888                $n_feed = $wpdb->get_var('SELECT count(meta_key) as n_new_feed FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"0\";%" LIMIT 1');
    89                 $feeds = $wpdb->get_results('SELECT meta_id, meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"0\";%" ORDER BY meta_key DESC LIMIT ' . (($current_page - 1) * $max_feeds_per_page) . ', ' . $max_feeds_per_page, ARRAY_A);
     89                $feeds = $wpdb->get_results('SELECT meta_id, meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"0\";%" ORDER BY meta_id DESC LIMIT ' . (($current_page - 1) * $max_feeds_per_page) . ', ' . $max_feeds_per_page, ARRAY_A);
    9090            break;
    9191            case 'approved':
    92                 $n_feed = $wpdb->get_var('SELECT count(meta_key) as n_new_feed FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";i:1;%" LIMIT 1');
    93                 $feeds = $wpdb->get_results('SELECT meta_id, meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";i:1;%" ORDER BY meta_key DESC LIMIT ' . (($current_page - 1) * $max_feeds_per_page) . ', ' . $max_feeds_per_page, ARRAY_A);
     92                $n_feed = $wpdb->get_var('SELECT count(meta_key) as n_new_feed FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"1\";%" LIMIT 1');
     93                $feeds = $wpdb->get_results('SELECT meta_id, meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"1\";%" ORDER BY meta_id DESC LIMIT ' . (($current_page - 1) * $max_feeds_per_page) . ', ' . $max_feeds_per_page, ARRAY_A);
    9494            break;
    9595            default:
    9696                $n_feed = $n_all_feed;
    97                 $feeds = $wpdb->get_results('SELECT meta_id, meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" ORDER BY meta_key DESC LIMIT ' . (($current_page - 1) * $max_feeds_per_page) . ', ' . $max_feeds_per_page, ARRAY_A);
     97                $feeds = $wpdb->get_results('SELECT meta_id, meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" ORDER BY meta_id DESC LIMIT ' . (($current_page - 1) * $max_feeds_per_page) . ', ' . $max_feeds_per_page, ARRAY_A);
    9898            break;
    9999        }
    … …  
    199199        $curr_feed_page = (isset($paged) && $paged > 0) ? $paged : 1;
    200200       
    201         $n_feed = $wpdb->get_var('SELECT count(meta_key) as n_new_feed FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";i:1%" LIMIT 1');
    202         $feeds = $wpdb->get_results('SELECT meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";i:1%" ORDER BY meta_key DESC LIMIT ' . (($curr_feed_page - 1) * $max_feed_per_page) . ', ' . $max_feed_per_page, ARRAY_A);
     201        $n_feed = $wpdb->get_var('SELECT count(meta_key) as n_new_feed FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"1\";%" LIMIT 1');
     202        $feeds = $wpdb->get_results('SELECT meta_key, meta_value FROM ' . $wpdb->postmeta . ' WHERE meta_key = "ulf" AND meta_value LIKE "%\"approved\";s:1:\"1\";%" ORDER BY meta_id DESC LIMIT ' . (($curr_feed_page - 1) * $max_feed_per_page) . ', ' . $max_feed_per_page, ARRAY_A);
    203203       
    204204        if ($use_pagination)
    … …  
    219219       
    220220        ob_start();
    221        
    222221        require ULF_DIR . '/display/' . $template;
    223        
    224222        $output = ob_get_contents();
    225223        ob_end_clean();
Note: See TracChangeset for help on using the changeset viewer.