how do you set negative integers?
 

I heard you have to make the integers signed, but I don't know how, in specific I'm trying to make the post count negative. Anyone know how?

You could try (untested, backup your database first!!!):
[sql]ALTER TABLE user CHANGE COLUMN post posts int(10) NOT NULL default 0;[/sql]

Alright, trying :)

EDIT: I got this :(

Oops the first one should have been posts also:
[sql]ALTER TABLE user CHANGE COLUMN posts posts int(10) NOT NULL default 0;[/sql]

trying :)

EDIT: okay, the query worked but when I set my post count to -1 it said post count 0 instead.

I've got to ask - why do you want negative post counts ?

Spammers, they don't deserve to be banned, but I don't think 0 is enough of a set back.

bump :)

What happens if you set it to.... say "-9"?
Do you still get "0"?

Can you determine of what kind your posts column in the DB is?

I tried this myself a week ago and worked perfectely....

Man, without your bump I would have totally missed this ;)

same thing if -9...

I can't find the posts column, what's it under?