Users stats reset to 2,147,483,647

[Homicidal]

I have users that have passed the cap of 2,147,483,647 and then they train some more and then it resets them back to 2,147,483,647 and it's starting to upset them because they have worked there ass off to get their stats up.

Does anyone know how I can fix this and stop it from happening..

[ignite]

Re: Users stats reset to 2,147,483,647

I think you change the the user stats table from big int (11) to something else

[sfekt`]

Re: Users stats reset to 2,147,483,647

 

I think you change the the user stats table from big int (11) to something else

Change all the fields in userstats from int(11) to bigint(20)

[oxidati0n]

Re: Users stats reset to 2,147,483,647

bigint(40) doesnt work, It goes up in the capped value of 2,147,483,647 each

say if you post 5,000,000,000 in default it goes to 2,147,483,647 so you post 5,000,000,000 again it'll just add another 2,147,483,647

to prevent this add UNSIGNED in the table. ;)

ALTER TABLE `users` ADD `example` BIGINT( 40 ) UNSIGNED NOT NULL ;

thats a example at above.

[Silver]

Re: Users stats reset to 2,147,483,647

i use

decimal(25,4)

increases all stats to 10 sextrillion each.

[stryker]

Re: Users stats reset to 2,147,483,647

thats also what i use

[hamster01]

Re: Users stats reset to 2,147,483,647

Why would you use bigint??

Why have to rase it at all?

[stryker]

Re: Users stats reset to 2,147,483,647

cause thats the max int 11 will output so you need like int 15 or higher or switch to another table type

[hamster01]

Re: Users stats reset to 2,147,483,647

 

cause thats the max int 11 will output so you need like int 15 or higher or switch to another table type

Never go higher that int(11), Rather goto decimal ;)