Max stats/Money ?

[lukeybabe]

1.

Hi Guys Luke Here, One Of My Users Got These Stats:

---------------------------------

Strength: 9999999.9999

Agility: 9999999.9999

Guard: 9999999.9999

--------------------------------

So he mailed me saying they couldnt go up so i geuss he hit the max how would i make it so they can go up more ?

2.

And The Max Cash Is :

-------------------------------

2147483647

-------------------------------

How would i make it so it could go higher ?

[lukeybabe]

UPDATE:

Ive found out how to do the money one so really its just the stats

Best Regards,

Luke

[kryptonite]

Max stats/Money ?

ok go to phpmyadmin and to the table userstats on the left then in structure change strength agility and gaurd to DECIMAL (13,4) 13= numbers before decimal point and 4= numbers after that will get more stats for you !=]

[Nicholas]

ALTER TABLE `userstats` CHANGE `strength` `strength` DECIMAL( 50, 4 ) NOT NULL DEFAULT '0.0000';

ALTER TABLE `userstats` CHANGE `strength` `agility` DECIMAL( 50, 4 ) NOT NULL DEFAULT '0.0000';

ALTER TABLE `userstats` CHANGE `strength` `guard` DECIMAL( 50, 4 ) NOT NULL DEFAULT '0.0000';

ALTER TABLE `userstats` CHANGE `strength` `labour` DECIMAL( 50, 4 ) NOT NULL DEFAULT '0.0000';

ALTER TABLE `userstats` CHANGE `strength` `IQ` DECIMAL( 50, 4 ) NOT NULL DEFAULT '0.0000';

or just run this sql and your max for stats be this

100,000,000,000,000,000,000

lol.

[Danny696]

A player shouldnt have that much money/stats, thats bad

[Nicholas]

i know lol. i put it up for a joke lol, but it still makes it so you dont have to worry about players complaining that they cant go any higher in stats for rest your life lol.

[Zero-Affect]

max decimal is 64 right?

so why 50?

BIGINT is a solution for money/crystals, but if your users are that high in money/crystals then i'd consider a economy retrieval. Then look at what went wrong

[Nicholas]

max decimal is 64 right?

so why 50?

BIGINT is a solution for money/crystals, but if your users are that high in money/crystals then i'd consider a economy retrieval. Then look at what went wrong

no idea what the max is, but who cares as long as players dont have to worry about reaching the max stats in their life time, its fine lol.

how can a player reach 100,000,000,000,000,000,000 in stats? lol. its kinda impossible.

also what do you mean by economy retrieval? get the players to send you most of the money they have and then change the bank interests each day or something? lol.

and lower the money gained in streets and etc... lol.

[wolfe]

Money gain, interest, etc should all be adjusted before the game is officially open. Testing isnt just for finding security leaks, but it should be tested to see how the game runs, the kind of gains a player will make, etc.

[Zero-Affect]

You currently have

42,533,130,180,623,130,624 Eight in the Privateer Bank.

That's on a game i play and i never cheated also im nowhere near the richest...

[wolfe]

Yikes. As a new player coming into an economy like that i would stop playing. Thats horrible.

[Maniak]

I'm having the same problem with mine. I have change it on PHPMyAdmin, but the max is still 2,147,483,647 for all of the "Stats", Money and also the Bank. Can anyone tell me how to change that number? I have tried for a few hours now, and I cannot seem to find out how to do it. Thanks.

[Nicholas]

to make it so money, crystals, bank money, and blah blah max isnt 2,147,483,647 try running this SQL

ALTER TABLE `users` CHANGE `money` `money` BIGINT( 21 ) NOT NULL DEFAULT '0';

ALTER TABLE `users` CHANGE `crystals` `crystals` BIGINT( 21 ) NOT NULL DEFAULT '0';

ALTER TABLE `users` CHANGE `bankmoney` `bankmoney` BIGINT( 21 ) NOT NULL DEFAULT '0';

ALTER TABLE `users` CHANGE `cybermoney` `cybermoney` BIGINT( 21 ) NOT NULL DEFAULT '0';