nbr1chinchilla Posted March 25, 2007 Share 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 Link to comment Share on other sites More sharing options...
CraigF Posted March 25, 2007 Share Posted March 25, 2007 Re: item market cap billion!?! thats a bit much? Quote Link to comment Share on other sites More sharing options...
nbr1chinchilla Posted March 25, 2007 Author Share 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 Link to comment Share on other sites More sharing options...
chris3010 Posted March 13, 2009 Share 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 Link to comment Share on other sites More sharing options...
POG1 Posted March 13, 2009 Share 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 Link to comment Share on other sites More sharing options...
Lithium Posted March 13, 2009 Share 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 Link to comment Share on other sites More sharing options...
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.