Simple MySQL vBulletin search from my main site

[mattclarke]

I'm trying to integrate my vBulletin forum into my main site's search engine and would like to write a MySQL query to locate posts containing a particular keyword. I'm using the following query:

PHP Code:

SELECT title, threadid FROM post WHERE title LIKE '$q' OR pagetext LIKE '$q' AND visible ='1'; 


This works, however, it also shows posts from my moderators forum which I do not wish to reveal to standard users. I've rummaged around in the database and in the source code but I can't figure out the correct query to use to prevent these being shown.

I'd be massively grateful if someone could please give me a pointer.

Many thanks,
Matt

[Andrew Green]

You have to also check against the forumid, which I believe is in the thread table.

[Eikinskjaldi]

Performing the search this way is server intensive, it actually has to look at the entire contents of text fields to do the match.

Assuming you have swapped to fulltext searching in admincp, vbulletin comes with fulltext indices which will greatly improve the efficiency of the search

select whatever from post where match(title, pagetext) against ('word')