(Anti) Social Development

(Anti) Social Development

by

WordPress Plugin Search Reloaded – Tweaked by Stratos

TWEAK After Party (by pygment_shots)

A couple of months ago I wrote about the Search Reloaded WordPress plugin, which sorts search results by relevance rather than by date.

Recently, SDK commented and said that she would like it if Search Reloaded also searched the comments.

So, 2 weeks ago when Stratos agreed to create plugins for reasonable requests, I requested that Search Reloaded be “tweaked” so it can also search comments. And Stratos did just that. You can read about it on his website.

The plugin will search posts and comments and list all of the posts that contain the search term in either the post or the comments. When I first tried it, I was confused because I thought the comments and the posts would be listed out. Stratos, however, set me straight and told me that would be way too complicated.

To test it I needed to think of a term that would be in the comments but not in an article. I then remembered that a nasty commenter called my readers sycophants and that as joke I called a regular reader the same thing in another article. And I knew that was much too large of a word for me to ever use in an actual article. So, search on sycophants and you will get two results (well, maybe three now with this article). One result will be a post and two will be the posts that have comments containing that term. Cool, huh?

The Search Reloaded plugin, however, doesn’t have a GPL or General Public License , so Stratos couldn’t redo the plugin and redistribute it but instead provided the code that would need to be edited in the plugin file.

So, here’s what you do. You’re going to have to edit the plugin file. If you aren’t comfortable with that you can ask me or Stratos for assistance.

  1. Go to Plugins > Plugin Editor
  2. Make a copy of the text or have a copy of the plugin available in case things go awry
  3. Look for the following block of code. If you copy it into a text editor with line numbering it starts at line 111.
    $search_query = "
    SELECT
        posts.*,
        CASE
            WHEN posts.post_title REGEXP ‘$reg_one_present’
                THEN 1
                ELSE 0
            END AS keyword_in_title,
        MATCH ( posts.post_title, posts.post_content )
            AGAINST ( ‘" . addslashes($query_string) . "’ ) AS mysql_score
    FROM
        $wpdb->posts as posts
    WHERE
        posts.post_date_gmt <= ‘" . $now . "’"
        . ( ( defined(’sem_home_page_id’) && sem_home_page_id )
            ? "
        AND posts.ID <> " . intval(sem_home_page_id)
            : ""
            )
        . "
        AND posts.post_password = ”
        AND posts.post_status = ‘publish’
        AND ( posts.post_title REGEXP ‘$reg_one_present’ 
        OR posts.post_content REGEXP ‘$reg_one_present’ )
    GROUP BY
        posts.ID
    ORDER BY
        keyword_in_title DESC, mysql_score DESC, posts.post_date DESC
    LIMIT " . intval($offset) . ", ". intval($posts_per_page);
  4. And replace with …
    $search_query = "
    SELECT
        posts.*,
        CASE
            WHEN posts.post_title REGEXP ‘$reg_one_present’
                THEN 1
                ELSE 0
            END AS keyword_in_title,
        MATCH ( posts.post_title, posts.post_content )
            AGAINST ( ‘" . addslashes($query_string) . "’ ) AS mysql_score
    FROM
        $wpdb->posts as posts,
        $wpdb->comments as comments
    WHERE
        posts.post_date_gmt <= ‘" . $now . "’"
        . ( ( defined(’sem_home_page_id’) && sem_home_page_id )
            ? "
        AND posts.ID <> " . intval(sem_home_page_id)
            : ""
            )
        . "
        AND posts.post_password = ”
        AND posts.post_status = ‘publish’
        AND posts.ID = comments.comment_post_ID
        AND ( posts.post_title REGEXP ‘$reg_one_present’ 
        OR posts.post_content REGEXP ‘$reg_one_present’ 
        OR comments.comment_content REGEXP ‘$reg_one_present’)
    GROUP BY
        posts.ID
    ORDER BY
        keyword_in_title DESC, mysql_score DESC, posts.post_date DESC
    LIMIT " . intval($offset) . ", ". intval($posts_per_page);

    5. Now, I have totally stolen this code from Statos so please visit his site and check out the other WordPress plugins he has made.

    Stratos hasn’t posted his services page yet but if you are looking to hire someone to develop a custom plugin for you, his contact information is on his About page.

    photo credit: pygment_shots

It's Time!

Start your WordPress website project now!

Contact Me! >>



Keep Reading:
How to Select the Number of Posts, Pages or Comments Displayed in the WordPress Admin
Stick to a WordPress Posting Schedule ... Or Not?
10 Upcoming Features in WordPress 3.4
How to Include a Post on a WordPress Static Front Page with the Thesis Theme


Comments

  3. Vered - MomGrind says

    I’ve been trying to limit my use of plugins as much as I can. I think they often slow down the site and I also read they can pose a security risk. Would love to read a post by you that tackles this issue by the way, if you haven’t already written one.

  7. Kim Woodbridge says

    @Vered – Poorly coded plugins are definitely a security risk. There are some, however, that I can’t do without. That’s a great idea for an article :-)

    @Stratos – It’s always better to find a code solution. Unfortunately, many WordPress users don’t know how to edit the template files and are very dependent on plugins.

    @Raju – LOL :-)

    @Matt – Great idea. I visited and commented.

  12. Kim Woodbridge says

    @Natural – Search Reloaded uses a different search algorithm than the default WordPress search – sorts search results by relevance rather than by date. This tweak makes the plugin search the posts and the comments for the keyword rather than just the posts.

    @Sire – The plugin is also recommended by Joost de Valk at yoast.com I trust him completely when it comes to WordPress information.

  14. Kim Woodbridge says

    @Dee – I use search on certain sites – especially ones that have written a lot of articles about WordPress. In those types of articles, there can frequently be code variations and other useful information in the comments.

    But I think that the only person who really searches this site is me – when I am looking for an older article ;-)

  19. Elana says

    Thanks all. Just wanted to let you know that I disabled the Search Reloaded plugin and tried the default WP search, the chestnuts post was indeed found.

    It definitely seems to be something with the Search Reloaded tweaks…

  20. Chinese Girl says

    I was very disappointed by the default search code which makes very hard to find relevant results, this plugin can be a cure, for some sites which is frequently updated may be searching by date is also important, is there any way to give that option too for the reader?

    Chinese Girl´s last blog post – Train Shenyang-Xiliu 6666

      • stratosg says

        I tried on a test blog which is as good as not trying at all since it had no real data… From seeing it i believe it’s a very good alternative to all the search plugins… I think it’s a bit resource hungry (grumpy me :P ) but still, what’s the percentage of searches against any other request… I guess it’s just fine ;)

        stratosg´s last blog post – The theme change

Trackbacks

Comments are closed. Please contact me for specific questions or subscribe to my newsletter.

Contact

Email: kim.woodbridge@gmail.com
Twitter: kwbridge
Phone: 215-534-6557
Form: Contact Me

Sign Up!


Subscribe to the (Anti) Social Newsletter for WordPress Tutorials, Recommendations, Special Offers and More

Follow Me

Pin It on Pinterest

asd

Sign Up!

Subscribe to the (Anti) Social Newsletter for WordPress Tutorials, Recommendations, Special Offers and More

You have Successfully Subscribed!