Jump to content
MakeWebGames

item market cap


nbr1chinchilla
 Share

Recommended Posts

I have changed my table datatype to bigint(20).

I cannot add items to the item market for over the 2.147 billion. I have changed my log files to also have the bigint(20).

I cannot find in itemmarket.php where to change to a float, or is there another page this needs to be changed?

I have had success with banks, balances, etc.. and not having the cap.

Any help is greatly appreciated.

Link to comment
Share on other sites

  • 1 year later...

Re: item market cap

BIGINT[(M)] [uNSIGNED] [ZEROFILL]

A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615.

It should work. Try unsigned as well, it can go even larger

Link to comment
Share on other sites

Re: item market cap

 

BIGINT[(M)] [uNSIGNED] [ZEROFILL]

A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615.

It should work. Try unsigned as well, it can go even larger

Replying to a 2 year old post... and not looking at the recent post that was asking for help! good job! :)

@chris3010, the easy way... is an extra field on users setting the limit and on item market, each time they use it decrease the field value up to 0, and hourly reset the field to its value via cron

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