PDA

View Full Version : Post counts: Higher

Glock
07-12-2002, 04:00 AM
Is there a way to allow it to go into the millions, but it will still work normally for everyone?
E
07-12-2002, 04:24 AM
umm.. u could change the character max in ur MySQL table
Glock
07-12-2002, 04:25 AM
I don't know how.
Neo
07-12-2002, 05:50 AM
Run this query


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



that should do it.
Glock
07-12-2002, 05:51 AM
Ok, thanks I'll try it out. In case I want to go back what is the code for returning it to normal?
Glock
07-30-2002, 11:30 PM
Anyone know how to return it to normal?
Logician
07-31-2002, 11:09 AM
Although

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

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
07-31-2002, 09:46 PM
I'm not sure what you mean Logican...
Issvar
08-01-2002, 12:53 AM
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
08-01-2002, 03:32 AM
*looks at old post* WTF
Logician
08-01-2002, 05:20 AM
Originally posted by Glock
I'm not sure what you mean Logican...
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.
Zzed
08-01-2002, 06:32 AM
I have a negative post count on my site. :D

http://www.ls1.com/forums/member.php?action=getinfo&userid=4112
Logician
08-01-2002, 06:52 AM
Originally posted by Zzed
I have a negative post count on my site. :D

if he managed to have this post count by himself, he is deserved to be banned for sure.. :D
Zzed
08-01-2002, 05:01 PM
Originally posted by Logician

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: