Finding posts directed at me (i.e., replies)

[CarCdr]

Our main purpose in using vBulletin is to track issues. Our users have come up with what I consider a reasonable request for a feature and I would like to implement it.

When they login, they want to see a list of N latest posts that were directed at them -- i.e., replies to messages they wrote.

If someone could suggest the proper MySQL search expression, I would add the feature to the search page.

The next step would be to more thoroughly introduce this notion of "replies". One would see the following kinds of links one could follow in a user welcome box:

JimmyDean
23 new posts
8 replies
4 messages

Thanks.

[CarCdr]

In looking at the "post" table, I see three fields that I would likely have to deal with:

parentid, username, userid

It would appear that parentid the the id of the post that was replied-to. Any caveats on the use of this field?

Is username for guests and serves as a copy of the poster in case userid becomes orphaned because of deregistraton?

Again, what I am trying to do is build a list of the N most recent "replies" -- posts that were entered by others in response to messages entered by the user.

TIA

[CarCdr]

Bumpity bump...

Could have sworn I saw a message on one of the vbulletin sites (there are too many :)) about tracking replies.