You can disable searching of a forum for all usergroups in the forum permissions area of the admin cp - incase anyone needs to because of usenet. :)

any way to exclude usenet forums for just this search?

something like:

where forumid !=

how would i go about putting it in this query?

edit: that was stupid make this your query to exclude a forum:

$replysql =" AND ((thread.replycount=0) OR (thread.replycount=1 AND thread.lastposter=thread.postusername)) AND forumid !=#";

where # is the number of your usenetforum

Thanks for this hack!!! This should be made a full release. It's awesome!!

Say... This seems like a good hack to add in mysql indexes in to speed it up.

I'm no expert, though.

Anyone know how to go about it?

It seems like one should be added for replycount under thread.

And, for chen's addition, indexes should be added for lastposter and postuser name, both also under thread.

The -only- thing I know about indexes, though, is going to into 'thread' in my vb database with phpmyadmin, then clicking 'index' for each replycount, lastposter, and posterusername. Would that be correct? Or would I do something else?

Hi,
this is a great hack, I really was on the search for something like this...
Thanks a bunch,
-Tom

Well, Thanks Thomas, I saw your post on vB.com... I was looking for this one a few weeks ago. But I'm lazy so I didn't search the forums...

thanks to elin too for this little hack :p

You're welcome :)

Kuddos to eline for this hack, I suggest to move this thread to the Full Releases.

cu,
-Tom

Is there a way that I can exclude certain forums from this hack, such as forums that do not allow replies?

thanks!! works great :)
good work elin https://vborg.vbsupport.ru/external/2011/01/19.gif

Open search.php and find
Then add the following below it
Where forumid equals 91 threads will be excluded.

Simple comparison operator ;)

What about excluding multiple forums? Also, how easy would it be to have this as index.php?action=unaswered instead of search.php?action=unaswered