nbr1chinchilla Posted March 25, 2007 Posted March 25, 2007 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. Quote
CraigF Posted March 25, 2007 Posted March 25, 2007 Re: item market cap billion!?! thats a bit much? Quote
nbr1chinchilla Posted March 25, 2007 Author Posted March 25, 2007 Re: item market cap future planning here. i've ran into this problem in other games where there is a cap on adding items to the market and sending money. It appears i have them all worked out except this item market issue. Quote
chris3010 Posted March 13, 2009 Posted March 13, 2009 Re: item market cap How do you cap an item so someone can only take a certain amount of it in an hour? Quote
POG1 Posted March 13, 2009 Posted March 13, 2009 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 Quote
Lithium Posted March 13, 2009 Posted March 13, 2009 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 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.