Updating a datafield in db when a user creates a post

[xpl0iter]

I am adding a field to user table in db. So everytime when the user makes a post, I would like to increment the number in that field. So how do I increment it when that person is making a post?
Is there some kind of hook or something like that so that I can execute this query?

 

[digitalpoint]

Wouldn't that ultimately just be the same as the user post count (which increments when they make a post)?

 

[xpl0iter]

Wouldn't that ultimately just be the same as the user post count (which increments when they make a post)?

Actually I would like to reset this every hour or so.
In that case having another field will be handy and would not cause any issues, to the original system!

 

[MOZ]

This should help:
http://xenforo.com/community/threads/what-events-to-choose-in-code-listener.41979/