Search posts and froums

[Boofo]

Can someone please tell me how to make the following query only allow searches show up for forums the user who is searching has access to? Right now it shows the word they searched for, and when they click on the word, if they do NOT have access to that forum, it shows the error message that there weren't any instances of the word found, even though it still shows in the list. Is there any way not to even have the word listed for those who can not view the forum?

PHP Code:

 $lastsearches = $db->query_read("  
 SELECT search.searchid, search.orderedids, search.dateline, search.query, search.userid, user.username, user.userid, user.usergroupid  
 FROM " . TABLE_PREFIX . "search,  
 " . TABLE_PREFIX . "user  
 WHERE search.query != ''  
 AND user.userid = search.userid  
 AND user.usergroupid NOT IN (5, 6, 7)  
 ORDER BY search.searchid DESC 
 LIMIT 0, 15 
"); 


[Marco van Herwaarden]

I don't really get your question. The list of words, is the words the user entered on the searchline, what got this to do with the forums? And i think the orderedids already contain a list of the threads found with the permissions considered.

What are you trying to do?

[Boofo]

I am porting my Last 15 searches hack from 3.0 to 3.5.

Right now it handles the permissions fine as the user can not get into a forum that they aren't supposed to. But the word they searched for WILL show up in the Last 15 Searches listing even though it is in a forum they can't access. I wouold like it to not show up in the listing for any forum that they don't have access to so they can't somehow stumble onto something that they really shouldn't.

And also, it shows the threads it is in instead of the individual posts. I would like to see it just display the posts.

[Marco van Herwaarden]

It will just show the words used to search, doesn't matter if they are found or not i think.

I think you have set the search options to show as threads instead of posts then.

[Boofo]

Originally Posted by MarcoH64

It will just show the words used to search, doesn't matter if they are found or not i think.

I think you have set the search options to show as threads instead of posts then.

How do I get it to not show the word then?

How do I set it to shows posts?

[Marco van Herwaarden]

Do you anywhere query the post or the thread table then?

Edit: I have feeling we are both talking about complete different things, maybe i should just go sleep.

[Boofo]

The query I am using is in the first post.

[Marco van Herwaarden]

Well that query is not retrieving any thread/post/forum info, si i am really lost on what you mean now.

[Boofo]

No, because it is using the search table.

[Marco van Herwaarden]

Yes and the search table will only give you id's, no forums or threads, so you will have to process them later.