Post counts: Higher

[Glock]

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

[E]

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

[Glock]

I don't know how.

[Neo]

Run this query

PHP Code:

ALTER TABLE `user` CHANGE `posts` `posts` SMALLINT(50) UNSIGNED DEFAULT '0' NOT NULL 


that should do it.

[Glock]

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

[Glock]

Anyone know how to return it to normal?

[Logician]

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?

[Glock]

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

[Issvar]

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:

ALTER TABLE `user` CHANGE `posts` `posts` INT UNSIGNED DEFAULT '0' NOT NULL

The code to reset it is correct.

[Neo]

*looks at old post* WTF