Mafia Empire Posted February 3, 2008 Share Posted February 3, 2008 newb back then :mrgreen: Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted February 3, 2008 Share Posted February 3, 2008 Re: Money,crystals cap grrrrr here is some of the sqls Quote Link to comment Share on other sites More sharing options...
Will Posted February 4, 2008 Share Posted February 4, 2008 Re: Money,crystals cap That won't work, an INT value is still limited to 2147483647 Quote Link to comment Share on other sites More sharing options...
YoungGold Posted February 4, 2008 Share Posted February 4, 2008 Re: Money,crystals cap you must change the value to BIG INT Quote Link to comment Share on other sites More sharing options...
Will Posted February 4, 2008 Share Posted February 4, 2008 Re: Money,crystals cap And DO NOT Change the users stats to INT. They are currently Decimals as your stats have decimals. Running these queries will mess up your game. Quote Link to comment Share on other sites More sharing options...
iseeyou94056 Posted February 4, 2008 Share Posted February 4, 2008 Re: Money,crystals cap And DO NOT Change the users stats to INT. They are currently Decimals as your stats have decimals. Running these queries will mess up your game. i was about to say that Quote Link to comment Share on other sites More sharing options...
Godhand Posted February 4, 2008 Share Posted February 4, 2008 Re: Money,crystals cap haha you haven't hit that 2.xx bill cap then. And for fixing that up for a while heres You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. That should last you a good while. While your at it fixing up the bank, sending money, etc change You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. into You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
Criminal Posted February 4, 2008 Share Posted February 4, 2008 Re: Money,crystals cap You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. ALTER TABLE `users` CHANGE `money` `money` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `crystals` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `bankmoney` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `cybermoney` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' ALTER TABLE `userstats` CHANGE `strength` `strength` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `IQ` `IQ` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `agility` `agility` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `guard` `guard` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `labour` `labour` bigint( 92 )NOT NULL DEFAULT '0' This will work mine one because the one with , at the end doest work so i tryed taking , and it worked then open staff_users.php v2 find (INT) And replace with (Float) thanks Quote Link to comment Share on other sites More sharing options...
Godhand Posted February 4, 2008 Share Posted February 4, 2008 Re: Money,crystals cap No problem. Other pages you have to edit is bank.php, cyberbank.php, etc. Quote Link to comment Share on other sites More sharing options...
Will Posted February 4, 2008 Share Posted February 4, 2008 Re: Money,crystals cap :x What did I say about the userstats; it is a DECIMAL!!!! they can be made bigger than an INT by changing the first value. Changing them to anything other than a decimal will mess up the stats. Quote Link to comment Share on other sites More sharing options...
Godhand Posted February 4, 2008 Share Posted February 4, 2008 Re: Money,crystals cap and using $gain=round(gymformulahere) wouldn't prevent it from getting jacked up? And honestly decimals for money? Seriously now.... Quote Link to comment Share on other sites More sharing options...
Will Posted February 4, 2008 Share Posted February 4, 2008 Re: Money,crystals cap I was talking about the userstats they use decimal places. This particularly affects new users where they are earning less than 1 a train. Quote Link to comment Share on other sites More sharing options...
Godhand Posted February 4, 2008 Share Posted February 4, 2008 Re: Money,crystals cap Well then he can deal with changing the formula so they get 1 stat or more per train. And as far as rounding is though it would avoid it anyways. I know that training in base formulas you get more then 1 stat per full energy train. Quote Link to comment Share on other sites More sharing options...
Ragnar Posted February 8, 2008 Share Posted February 8, 2008 Re: Money,crystals cap How do you get rid of the decimal places in userstats? It makes it look ugly!! aka...90210.113222434154. When you start an account, with the lowest property, unless you change it to have even less will, it gives you 10 stat per train. Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted February 8, 2008 Share Posted February 8, 2008 Re: Money,crystals cap wat do i need to edit for bank like change and all that Quote Link to comment Share on other sites More sharing options...
zbirc3 Posted February 8, 2008 Share Posted February 8, 2008 Re: Money,crystals cap SOMEONE HELP! I USED THIS AND THEN I HAD TO REPLACE IT AND NOW ALL THE USERS ARE GONE IN THE USERSTATS AREA! meaning it will show a query error in all places where it will show stats, e.g: index.php ANYONE! CAN YOU HELP ME FIX PLZ!? Quote Link to comment Share on other sites More sharing options...
Godhand Posted February 9, 2008 Share Posted February 9, 2008 Re: Money,crystals cap How to get stats to come out clean in the gym: find the formula for your gain. add after =beforetherest round( then your formula) simple. And Zbirc post the sql u did to change it back. Quote Link to comment Share on other sites More sharing options...
jeeppimp Posted February 27, 2008 Share Posted February 27, 2008 Re: Money,crystals cap Question! that seem too work ok but, the only thing, I can't get the prices of my houses above 2.1bill. what should I edit to fix this? Quote Link to comment Share on other sites More sharing options...
jeeppimp Posted February 27, 2008 Share Posted February 27, 2008 Re: Money,crystals cap Figured it out, ALTER TABLE `houses` CHANGE `hPRICE` `hPRICE` BIGINT( 21 ) NOT NULL DEFAULT '0' staff_house.php edit int to float done.... Quote Link to comment Share on other sites More sharing options...
webster2001 Posted February 28, 2008 Share Posted February 28, 2008 Re: Money,crystals cap You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. ALTER TABLE `users` CHANGE `money` `money` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `crystals` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `bankmoney` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `cybermoney` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' ALTER TABLE `userstats` CHANGE `strength` `strength` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `IQ` `IQ` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `agility` `agility` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `guard` `guard` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `labour` `labour` bigint( 92 )NOT NULL DEFAULT '0' This will work mine one because the one with , at the end doest work so i tryed taking , and it worked then open staff_users.php v2 find (INT) And replace with (Float) thanks Error SQL query: ALTER TABLE `users` CHANGE `money` `money` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `crystals` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `bankmoney` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `cybermoney` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHANGE `crystals` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `bankmone' at line 3 I get this when i put that in. How can i sort it? I use v1.1 codes. Quote Link to comment Share on other sites More sharing options...
Halo Posted March 6, 2008 Share Posted March 6, 2008 Re: Money,crystals cap You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. ALTER TABLE `users` CHANGE `money` `money` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `crystals` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `bankmoney` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `cybermoney` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' ALTER TABLE `userstats` CHANGE `strength` `strength` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `IQ` `IQ` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `agility` `agility` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `guard` `guard` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `labour` `labour` bigint( 92 )NOT NULL DEFAULT '0' [/code] Never ever do that with the user stats. To do userstats you just need to replace a few numbers these are the original numbers: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Just rename the first part of the code from 10 to 92 You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. It really works i was testing it and my stats went up to: Stats Info: Strength: 99,214,223,234,200,011,344,822,808,748,263,406,361,903,104 [Ranked: 1] Agility: 99,214,742,342,300,009,209,442,067,094,969,171,025,330,176 [Ranked: 1] Guard: 99,214,234,234,199,994,435,209,344,265,839,831,941,120 [Ranked: 1] Labour: 99,214,723,423,399,996,459,476,023,615,915,747,704,832 [Ranked: 1] IQ: 99,214,742,342,300,002,710,256,860,846,722,727,804,928 [Ranked: 1] Total stats: 198,726,609,276,499,937,337,431,600,879,931,034,014,056,448 [Ranked: 1] LOL THATS A LOT +1 Please! Quote Link to comment Share on other sites More sharing options...
tittlemouse Posted March 6, 2008 Share Posted March 6, 2008 Re: Money,crystals cap how can i edit it in my staff panel on v2 so i can add more than 2,147,483,647 Quote Link to comment Share on other sites More sharing options...
Godhand Posted March 7, 2008 Share Posted March 7, 2008 Re: Money,crystals cap changing (int) into (float) Quote Link to comment Share on other sites More sharing options...
curious4moreknowledge Posted March 13, 2008 Share Posted March 13, 2008 Re: Money,crystals cap Here is the fix for userstats table to change the cap. You do not have to change to BIGINT, you only need to change the variable (11,4) to a higher number. (11) is the total number of place holders, (#,4) or (#,6) is the decimal places in the number. So if you have a cap of “ 9,999,999.9999” you have used up all 11 places. Make the number higher as eg; (20,4) and you have “9,999,999,999,999,999.9999” cap. 20 places 4 decimal places. Simple fix that doesn’t screw up your stats table. :-D ALTER TABLE `userstats` CHANGE `strength` `strength` decimal(50,4) NOT NULL default '0.0000', CHANGE `agility` `agility` decimal(50,4) NOT NULL default '0.0000', CHANGE `guard` `guard` decimal(50,4) NOT NULL default '0.0000', CHANGE `labour` `labour` decimal(50,4) NOT NULL default '0.0000', CHANGE `IQ` `IQ` decimal(50,6) NOT NULL default '0.000000', Quote Link to comment Share on other sites More sharing options...
redsnake420 Posted March 17, 2008 Share Posted March 17, 2008 Re: Money,crystals cap i know i sound like a n00b for asking this but where do i change the cap for sending money and bank money so people can send more then 2.1bill at a time 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.