Jump to content
MakeWebGames

Users stats reset to 2,147,483,647


Homicidal
 Share

Recommended Posts

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..

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...