Remember, doing this will reduce your very maximum post count to 32767.

Where is LongINT when you need it? :)

True, heh, if you have spamme- err active posters use this...
[sql]ALTER TABLE user CHANGE posts posts MEDIUMINT DEFAULT 0 NOT NULL;[/sql]

Which will do what? :)

If you don't have any users with more than 32,000 posts, use the first one. If you do, use the second one.

I don't have very many users with 32 posts let alone 32,000 posts. I think I'll be safe with the first one (for now, anyway.) :)

What would be very cool, is if somehow this hack could be tied into the posting timelimit. If a user posts more than XX seconds apart, then the post count increments, if less than XX seconds, then the post count decrements. We have some *very* prolific posters who tend to spam threads a lot, but we don't want to penalise regular users with a 90 second posting limit.

I'd like to install this hack, but I have one problem with it.
In my newreply.php, it says:

I can't seem to get it right when trying to change this one.