Possible to display only posts by specific user group?

[Sal Collaziano]

Is it possible to display the posts (on the front page of my vBAdvanced enhanced site) from ONLY specific usergroups or users?

Thanks in advance...

[Sal Collaziano]

Maybe somebody knows of a mod/hack that can do it? Basically, I want to have posts from all my forums make it to the front page - however, I only want posts from a specific user or usergroup...

[bobster65]

Originally Posted by Sal Collaziano

Is it possible to display the posts (on the front page of my vBAdvanced enhanced site) from ONLY specific usergroups or users?

Thanks in advance...

You could modify the recentthreads.php file to do this. You would just need to modify the where clause in the main query. There are a bunch of people here that could do it for ya.

[Sal Collaziano]

Thank you.. If it's something that can be done by editing a file, I can do that - but I'd need to know how. If it's a database query, I can do that too - but I'd need to know the query...

[Brian]

You could add a new plugin to the 'vba_cmps_module_recthreads_start' location with the following code:

$vba_threads_condition .= ' AND user.usergroupid IN(X, Y, Z)';
$rthread_join .= ' LEFT JOIN ' . TABLE_PREFIX . 'user AS user ON (thread.postuserid = user.userid)';

Replace X, Y, Z with the usergroupid(s). Note that will only work if the member has the selected group as their primary usergroup.

[Sal Collaziano]

Hi Brian,

Thank you. I tried the following:

$vba_threads_condition .= ' AND user.usergroupid IN(11)';
$rthread_join .= ' LEFT JOIN ' . TABLE_PREFIX . 'user AS user ON (thread.postuserid = user.userid)';

I'd like for usergroup 11 to be the only group where topics appear on the front page.. Unfortunately, other usergroups' topics are still making it... Any ideas?

Thanks again...

[Brian]

Did you make sure to add the new plugin to the 'vba_cmps_module_recthreads_start' hook location, and make sure to mark it as 'Active'?

[Sal Collaziano]

Originally Posted by Brian

Did you make sure to add the new plugin to the 'vba_cmps_module_recthreads_start' hook location, and make sure to mark it as 'Active'?

If all this is done on the same 'edit' page, than yes.. Is there somewhere else I needed to touch on this?

Thank you...

[Sal Collaziano]

Don't give up on me now! Anyone else have any ideas? I guess this is a unique request.. I figured maybe more people would have wanted this functionality in the past. The thing is, I want to be able to have topics from all my forums on my vBa front page - but I don't want just anybody getting there...

Thanks in advance...

[Brian]

Try going back to your Plugin Manager in the Admin CP, find the plugin you just added, make sure that the checkbox next to it is checked, and then click the 'Save Active Status' button at the bottom.

[Sal Collaziano]

No luck.. Are you sure this would work? If so, maybe I've just got something set incorrectly.. Could I pay you for your time for personal support?

[Brian]

Yes, that code will work... It is the Recent Threads module that you're trying to apply this to, right?

[Sal Collaziano]

Oh, maybe that's it! My fault! Sorry! It's the "news" module!

So how would the code look for that?

[Sal Collaziano]

What I tried this morning was just change the module this was applied to, to "vba_cmps_module_news_start" but I was still able to post a topic with an account outside usergroup id11..

Would the code be any different to allow only one usergroup to get those front page 'news' posts?

The Execution Order is "5". Could that mean anything?

[Brian]

Originally Posted by Sal Collaziano

Oh, maybe that's it! My fault! Sorry! It's the "news" module!

So how would the code look for that?

That would be the problem then. I saw "recent threads" somewhere in this thread, so assumed that's the module you were trying to do this with. For the news module, you would need to look in the modules/news.php file for this code:

PHP Code:

WHERE thread.threadid IN(" . implode(',', $newstids) . ") 


And repalce with this:

PHP Code:

WHERE thread.threadid IN(" . implode(',', $newstids) . ")
  AND user.usergroupid IN(11) 


[Sal Collaziano]

Okay. I think I'm getting closer now.. The only issue is - the new code took out the news and recent post columns altogether.. I have the usergroup set correctly.. There's one primary member of usergroup #11..

I removed the plugin to see if that would clear things up to no avail.. I'm sorry about all these questions and bumps in the road - but I know this can work...

Any ideas?

Thanks again...

[Sal Collaziano]

Okay, wait.. I think the user just needs to post new topics... On the other hand, I'm not sure what's wrong with the 'recent posts' area...

[Sal Collaziano]

Okay. It just took a little tweaking.. Everything's working perfectly.. Thank you for your help, Brian!

[wotws]

how can we do it for a user?

[Brian]

Change this:

PHP Code:

AND user.usergroupid IN(11) 


To this:

PHP Code:

AND post.userid IN(X, Y, Z) 


(change X, Y, Z to the userid(s) you want to include)