Where to add query for added postbit info?

[toucan42]

So here's the situation:

I am creating a game on my forum that uses the actual structure of the forum as part of the game. Players of the game will belong to a secondary user group. If you are a member of that secondary usergroup then you can "hide" among your posts. Other players are "seeking" you.

I need to accomplish two things:

Players who have not been found can change where they are hiding so I wanted to offer that secondary usergroup a "hide" button. no big deal. clicking this button will record the post id and user id in a new table.

Players who are viewing a thread may happen across a post containing another player who is hidden. There will be a button for them to "find" the hidden player. clicking this button will record the user id of the person who has found them.

At the end of a game we will tally who had the most "finds" and who lasted the longest.

My question is where is the best place to run the query for deciding if someone is "hidden" on the thread.