Checking for post edits and signature changes
 

Is there any pre-made query out there that will let me check for post edits and signature changes?

What I am finding is that users create posts and then go back awhile later to add in a signature. I am also finding that some will create a signature after the fact for a link.

Since I check all users to see what site they have in their profile, to be sure it isn't a stupid spam link, it is more difficult when they post-edit their siggy.

Anything out there like that?

A pre-made one? Not that I know of. For the post edits, I think you can check the postedithistory table to see if the postid is in there. But, I don't think there is anything you can do regarding the signature - I'm pretty sure nothing is saved regarding edit history of the signatures.

If you are wanting to keep track of when a user edits their signature, I think you will have to write some code for that and it may include adding a column to the database for the edit date.