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

After you altered the post count field, have you altered post count numbers for some users too? For example, if you increased your post count to 2000000 (=it is a 7 digit number), you can NOT return back to original 5 digit field since now you have some post counts which wouldnt fit these fields. That was what I meant.

I have a negative post count on my site. :D

http://www.ls1.com/forums/member.php...fo&userid=4112

if he managed to have this post count by himself, he is deserved to be banned for sure.. :D

It pays to be the administrator. :D Negative post count and a custom title that says Banned. :D It gets the newbies every time. :banana: