Post counts: Higher
 

Is there a way to allow it to go into the millions, but it will still work normally for everyone?

umm.. u could change the character max in ur MySQL table

I don't know how.

Run this query


that should do it.

Ok, thanks I'll try it out. In case I want to go back what is the code for returning it to normal?

Anyone know how to return it to normal?

Although
[sql]
ALTER TABLE `user` CHANGE `posts` `posts` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL
[/sql]
is the SQL command which will revert it back to original, you cant return back if you populated your fields with high numbers. How can you restrict the field back to 5 chars again, if you have high numbers already put in there?

I'm not sure what you mean Logican...

SMALLINT is supposed to allow only upto 65535, so if you want to have higher numbers you need to use a different type of column, like INT, which allows upto 4 billion, so use the following mysql query to change the type:
The code to reset it is correct.

*looks at old post* WTF