Split Latest Reputation Received into Two sections in UserCP

[tnedator]

I have members getting reputation and the comments associated with them and it shows up in the Latest Reputation received section of the User CP.

I have one add-on/hack I am using called Post Thanks, which automatically adds a reputation point when someone 'thanks' a post. It creates an auto generated comment that says "High Fived Post".

What I would like to do is to have two sections displaying reputation. The first one showing all reputation received where the comment isn't equal to "High Fived Pose"

And, the second set of reputation where the comment is equal to "High Fived Post".

The reason for this is that people give the High Fived Posts (Post Thanks hack) about 5 to 1 or more over the regular reputation, and it is pushing the comments that people want to read off of the page.

I greatly increased the number of reputations that are showing in the User CP as a temporary fix, but would like to split them as the long term solution.

Alternatively, I can stop having the Post Thanks hack give reputation (we don't actually track or display the reputation, but instead only have it so it will create a link to the post thanked in User CP / Latest Reputation Received). Then, I would need to create a custom query of all posts that have received the Post Thanks and list them in a new section in the User CP.

I can write the SQL query to generate the list of thanked posts, but I don't know how to paramaterize and pass it to a variable to actually be called from a template and only show the query results for the single user.