Arson Posted April 15, 2007 Share Posted April 15, 2007 To get rid of the 2.147 bil cap in scripts such as the sendcash.php , locate at the top of the script $_GET['money']=abs((INT)$_GET['money']); and change it to $_GET['money']=abs(strip_tags(($_GET['money']))); That will make whatever they put in into an absolute number. It blocks the 2.20,E+102 exploit, and keeps them from putting negative numbers in the send cash field. Along with blocking any scripting that they may ever so 'cleverly' attempt to put in the form. Quote Link to comment Share on other sites More sharing options...
ignite Posted April 22, 2007 Share Posted April 22, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode So it stops sql injections on cash sending ? Quote Link to comment Share on other sites More sharing options...
vinyl Posted April 22, 2007 Share Posted April 22, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode this may be misleading to some as if money is INT(11) it's still gonna be capped at 2.14...bil being a function of the sql type & size -yes? Quote Link to comment Share on other sites More sharing options...
03laceys Posted April 30, 2007 Share Posted April 30, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode hi i would like to take of the cap on the game because i can only have a max priced house a player can only hold a max amount of cash and there stats they can only have as a max any help on witch files i need to help would be apricated Quote Link to comment Share on other sites More sharing options...
Broda Posted April 30, 2007 Share Posted April 30, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode hi i would like to take of the cap on the game because i can only have a max priced house a player can only hold a max amount of cash and there stats they can only have as a max any help on witch files i need to help would be apricated This guy's got it right this may be misleading to some as if money is INT(11) it's still gonna be capped at 2.14...bil being a function of the sql type & size -yes? Change the field to a bigint and you should be ok for a while. Quote Link to comment Share on other sites More sharing options...
03laceys Posted April 30, 2007 Share Posted April 30, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode hi i would like to take of the cap on the game because i can only have a max priced house a player can only hold a max amount of cash and there stats they can only have as a max any help on witch files i need to help would be apricated This guy's got it right this may be misleading to some as if money is INT(11) it's still gonna be capped at 2.14...bil being a function of the sql type & size -yes? Change the field to a bigint and you should be ok for a while. after reading this i am more lost lol has it got any relavence to my question lol soz was that an answer on how to do it im dumbs lol nah, if you can help me what files do i nead to edit ty? Quote Link to comment Share on other sites More sharing options...
Broda Posted April 30, 2007 Share Posted April 30, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode umm ok You need to modify your Database to allow a bigger number to go into that field. From your responses, this might be too hard for you to understand and do though :( Best idea: find someone you trust that knows what we're talking about to do it. ALTER TABLE tablename MODIFY columnname BIGINT NOT NULL; Quote Link to comment Share on other sites More sharing options...
oxidati0n Posted May 19, 2007 Share Posted May 19, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode to remove the 2.147 bil cap ALTER TABLE `users` ADD `money` BIGINT( 45 ) UNSIGNED NOT NULL ; unsigned means it's normal flow cash, no repeat in 2.147 rows if you get me. Quote Link to comment Share on other sites More sharing options...
stryker Posted May 20, 2007 Share Posted May 20, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode so unsigned makes it ad up normal? Quote Link to comment Share on other sites More sharing options...
Decepti0n Posted May 20, 2007 Share Posted May 20, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode Unsigned just restricts it to greater than 0, the limit would be 2.147bil * 2 Quote Link to comment Share on other sites More sharing options...
stryker Posted May 20, 2007 Share Posted May 20, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode oh ok i understand ty for the info Quote Link to comment Share on other sites More sharing options...
pspotential Posted May 31, 2007 Share Posted May 31, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode to remove the 2.147 bil cap ALTER TABLE `users` ADD `money` BIGINT( 45 ) UNSIGNED NOT NULL ; unsigned means it's normal flow cash, no repeat in 2.147 rows if you get me. i get this when i try to run it #1060 - Duplicate column name 'money' Quote Link to comment Share on other sites More sharing options...
pspotential Posted June 1, 2007 Share Posted June 1, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode BUMP plz sum1 reply Quote Link to comment Share on other sites More sharing options...
Redeye Posted June 10, 2007 Share Posted June 10, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode Goto PHP MyAdmin and goto the mySQL database which you games SQL is written in and goto table 'users'. Edit the type catagory of level, money, christals (and any other things you want to take the 2.1 bill cap off) from 'INT' to 'BIGINT' . :-D Quote Link to comment Share on other sites More sharing options...
Z?v?? Posted June 18, 2007 Share Posted June 18, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode int(11) to bigint(25) :wink: (Not sure if it should be quite as high as 25 but I don't think it would matter much) Quote Link to comment Share on other sites More sharing options...
Draco Posted June 18, 2007 Share Posted June 18, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode bigint Integer (whole number) -9,223,372,036,854,775,808 through 9,223,372,036,854,775,807 (with default attributes setting) Set the attributes to unsigned and it changes this to a range of 0 through 18,446,744,073,709,551,614 Quote Link to comment Share on other sites More sharing options...
deathknight90 Posted June 18, 2007 Share Posted June 18, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode first of all why do you guys allow so much money going into the players banks, hand etc. Its stupid. Cut the money down a bit. When you first join most games start with $200-$1000 cash. Then when players see another player 7 days old they have over 3 million. Why? Why? Why? Its stupid. Quote Link to comment Share on other sites More sharing options...
Draco Posted June 18, 2007 Share Posted June 18, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode first of all why do you guys allow so much money going into the players banks, hand etc. Its stupid. Cut the money down a bit. When you first join most games start with $200-$1000 cash. Then when players see another player 7 days old they have over 3 million. Why? Why? Why? Its stupid. Well I'm not a game owner so I can't really give you a reason why, but I can speculate that over time it does become necceasry to go beyond the 2.xx billion limit. Quote Link to comment Share on other sites More sharing options...
deathknight90 Posted June 18, 2007 Share Posted June 18, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode No its not , that is if you make it hard to earn money. Quote Link to comment Share on other sites More sharing options...
John99 Posted July 29, 2007 Share Posted July 29, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode Well this way i have done works fine for me in admin panel were it has edit , create user, credit users ect in the code some think like (int) replace that with (float) works fine and edit the money table and it should work works fine for me :-P Quote Link to comment Share on other sites More sharing options...
SaMz Posted August 5, 2007 Share Posted August 5, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode best thing is replace all int 11 to bigint 20 in the database sure will take time lmao Quote Link to comment Share on other sites More sharing options...
oxidati0n Posted August 6, 2007 Share Posted August 6, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode I know why there is a 2bil cap on MCC, because you shouldn't even get to 2billion. That is WAYYY to high in economy. Quote Link to comment Share on other sites More sharing options...
YoungGold Posted August 7, 2007 Share Posted August 7, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode well me im gonna have it at BIGINT incase that wierdest does happen but i would like it for money to be hard on my game. Quote Link to comment Share on other sites More sharing options...
Jesse60905 Posted August 7, 2007 Share Posted August 7, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode I play a game who will soon have to up their bigint amount again. The richest player has almost 1tril. It's getting to the point where it is not so weird for a player to pay 10mil+ for 1 crystal. Quote Link to comment Share on other sites More sharing options...
YoungGold Posted August 7, 2007 Share Posted August 7, 2007 Re: Getting Rid of the 2.147 bil cap in MCcode a autosignature is something that will always show in either a e-mail, mail, forum signature, ect ect 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.