Virgin topics "hackette"

01-16-02: Updated description and hack. There's no need to fix it if you've already installed it, but I realized that I had placed a couple of mySQL queries in the wrong order which might or mightn't have influence over search performance.

I've been searching through the forum but I haven't found any released version of this hack so far so I thought I'd give it a shot.

What this hack does is that it searches for posts that haven't been answered yet, something which may be very useful for those who run help forums. I've reused quite a lot of code from other vB search features, so you can maintain flood control and prevent forums being displayed to users who have no right to view them. Another pro is the fact that you get the results displayed with the same templates as the other, custom, searches.

Just download the attached file and follow the instructions and you'll have it running in notime.

If you feel like it you can change the $days variable. I have it set to thirty days by default because it felt good. Decrease it if you have busy forums and increase it if only the cat pops in for a visit every now and then.

Fully functional (so far so good) version can be found here. I'll try to provide as much support as my schedule allows, but please don't count on it since I forget easily.

Good luck! (Oh, and if you've installed please give me a thumbs down/thumbs up so that I can know if it works or not. Someday I'd like to release it in the "real" hack forum, you know. )

[Tim Wheatley]

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.

[shadow_old]

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

[akaler]

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?

[Thomas P]

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

[JulianD]

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

[Thomas P]

You're welcome

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

cu,
-Tom

[Joshua Clinard]

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

[Schorsch]

thanks!! works great
good work elin

[Kriek]

08-08-02 at 02:45 PM Joshua Clinard said this in Post #17
Is there a way that I can exclude certain forums from this hack

Open search.php and find

PHP Code:

$wheresql="1=1".$forumsql.$replysql.$datesql;
 $wheresql.=" AND thread.open<>10"; 


Then add the following below it

PHP Code:

$wheresql.=" AND forumid!=91"; 


Where forumid equals 91 threads will be excluded.

Simple comparison operator

[KeithMcL]

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