Recent Posts by User Role

kejek

I've been looking at a few plugins, and trying to figure out how to create a "recent" posts section that would return any posts by certain users (specifically, a Moderator or Administrator role). Think a Dev Tracker like the World of Warcraft forums use.

I'm unsure how to go about this. Can I use "$DiscussionModel->Get"?

Thanks!

hgtonight

Shameless plug: check out LatestPostList for a working example of gnabbing discussions from the discussion model.

$DiscussionModel = new DiscussionModel();
$this->_LatestPosts = $DiscussionModel->Get(0, $Limit, 'all');

The third argument is used to pass sql where clauses. You could modify it to be something like:

$this->_LatestPosts = $DiscussionModel->Get(0, $Limit, array('all', 'InsertUserID' => 2));

This will return up to $Limit discussions started by user 2.

kejek

Yea, was what I was looking at originally. That works wonders, but then I need to filter it down by a specific role, and I wasn't seeing anything in there for that.

peregrine

use a conditional to check the role.

you can check various plugins to see how to select via role. cleanser, role signatures, etc.

hgtonight

@kejek I updated my previous post.

kejek

Interesting. So looking at the database side, I'd have to find a way to add a query statement that filters by roleID of 16 or 32 (admins and moderators). Getting closer, at least now I have an idea of a path to figure this out.

Thanks!

hgtonight

Actually, I had misread that you wanted the latest discussions of a specific role. I thought you wanted of a specific user.

To get the latest discussions started by a specific role, you can do something like this:

$UserModel = new UserModel();
$UsersWithRoles = $UserModel->GetByRole(16)->Result();
$UserIDs = array();
foreach($UsersWithRoles as $User) {
  array_push($UserIDs, $User->UserID);
}
$DiscussionModel = new DiscussionModel();
$this->_LatestPosts = $DiscussionModel->Get(0, $Limit, array('Announce' => 'all', 'InsertUserID' => $UserIDs));

The $Wheres field on the discussion model is really flexible. If you pass it an array as the value of a field ID, it will automatically OR it for you.

You of course don't have to do this via my plugin.

kejek

Awesome, thank you very much!

Last question - is there any sort of call like DiscussionModel() for comments?

Or at least a really good resource so I could figure these things?

Thanks again, its really helped me get this going!

kejek

Whoops, i found it! Thanks much for all your help guys!

CommentModel($userid, $limit, 0) works!

hgtonight

No problem, Welcome to the community!

Be sure to 'react' to posts you find valuable. (Off-topic, insightful, awesome, lol, etc.).

peregrine

how bout a promote. nice job.

hgtonight

@peregrine I don't know what I am supposed to use that for.

I am afraid to click it

peregrine

Be sure to 'react' to posts you find valuable. (Off-topic, insightful, awesome, lol, etc.).

I used to think "not reading documentation was the number one thing that is neglected by new members". But I could be wrong it is clicking on the reaction buttons to give us points. Remember every point is worth bonus dollars when trading them in for valuable gifts in the vanilla forum gift catalog.

peregrine

@hgtonight
@peregrine I don't know what I am supposed to use that for.

I gave you the promote! I wasn't asking for one - it puts the discussion in the "Best of" under categories.

But if it was tongue in cheek - why new users can't click on insightfuls - if was lol but not funny.

hgtonight

@peregrine said:
I used to think "not reading documentation was the number one thing that is neglected by new members". But I could be wrong it is clicking on the reaction buttons to give us points.

If you are talking about my signature, I like the way the whitespace looks in it right now.