New to the community? Start here

Some help with Sitewide Search based on Post-Indexer

Can I get some tips on the queries needed to create sitewide search on wp_site_posts table created by Post-Indexer ? Also I understand that for this to work i need to query the table, but then how do I translate that to viewable results on screen.

Thu, 9 Oct 2008 1:49:43
  • Klark
    • Site Builder, Child of Zeus

    ha I took the easy way out and just used Donncha’s Tags plugin instead :smiley:

    Technically, it’s the same thing, amirite.

    Now I just have to improve WordPress’ search. It sucks major balls ..the results are never relevant.

  • drmike
    • DEV MAN’s Mascot

    If you got the cash, our big mu install went with one of those google mini boxes for $11k for their searching solution.

    I’m still debating on our tag solution. Our installs are still using the outside blog with the sitewide rss feeding into it that I came up with. While I can understand the niceness of Donncha plugin, having the contents sit in a separate blog and away from being underneath the main blog, that’s a showstopper for us. That’s why I had planned on looking at Andrew’s solution some time soon.

    Thanks anyway,

    -drmike

  • andrea_r
    • The Incredible Code Injector

    @digibluez Read drmike posts again carefully. He said that one of *his* clients paid *GOOGLE* $11K for their search solution.

    He is in no way saying that this site *here* would charge that for redoing the WP search.

    Also, drmike, Donnacha’s tag plugin can be set up to use the main blog instead of a separate one. It just does that by default.

  • drmike
    • DEV MAN’s Mascot

    Actually Susan paid for one of these: Link. Our one and only co-located box.

    that sends all users to google instead of my pages

    That’s right. It’s an outside solution and you have to work with their parameters. If you’re using the domain mapping, you can’t include them. Those annoying end users of yours who constantly flip between public, private, and protected are going to be bugging you because their sites are or are not showing up when they want them to be. Plus Google doesn’t always hit every single page. With her own hosted box, we can tell it specifically which sites to include, how often to pay attention to meta settings, their own advertising instead of adsense, and you can make sure that all of the blogs get scanned fully. (Well, up to the 300k page limit of course.)

    If Google search works for you, great. It didn’t for her.

    edit: Andrea, how do you set it to use the main blog? Would love to know.

    reedit: From looking at the code, I would think going back after installing and resetting the site options ‘tags_blog_id’ to use ‘1’, the main blog.

    rereedit: Wouldn’t that throw those site wide posts in with the regular posts of the main blog though?

  • Klark
    • Site Builder, Child of Zeus

    drmike, the new version gives a checkbox to send all posts to the main blog. I don’t post anything to the mainblog. I have seperate blogs for site news and support, so it works out great. And since all the posts go to the main blog, you get Sitewide RSS, Archives, Search, Tags, Recent Posts and all with just one plugin and template tags.

  • drmike
    • DEV MAN’s Mascot

    Hmmm, most of our clients use the main blog quite a lot. One of the things I suggest to them for the larger installs is to do a daily post on who’s posting what of interest around their site. That’s instead of doing a “recent posts” list. Some do it, some don’t.

    Thanks though for the response.