[mccode] Money,crystals cap

[Danny696]

But you shouldnt be getting 'quads' Thats just pointless unless the items for sale are in the 'quads'

[Shakeynath]

Well Danny.. I play a game with its in its Quads(1,000,000,000,000,000) and I find it enjoyable.. Its makes you want more, and its challengeing for the user. :)

Exactly mate, Its more enjoyful because you have more things too reach and that

[NarutoPRG.com]

Exactly mate, Its more enjoyful because you have more things too reach and that

Indeed. Many other games still use the 2.1B on their game, that I find it quite annoying. Why? Takes around 3 years to get the full 2.1B unless you donate like mate. On the game I play(CW) you can easily get that, and great items are on the game, and you can buy that. And there is much more.

The game economy needs to be updated weekly because of this.. But worth it. :)

[Shakeynath]

Is there a way too higher this cap then ? Because i try all the other SQL'S on here but always get mysql error

[Dominion]

you need to make them bigint rather then int

[Shakeynath]

My user stats are decimals not int ?

[Dominion]

`money` `money` int(11) NOT NULL DEFAULT '0',

`crystals` `crystals` int(11) NOT NULL DEFAULT '0',

`bankmoney` `bankmoney` int(11) NOT NULL DEFAULT '0',

 

they are int's ... as for your userstats not sure why the would be that high money ok but you have over 2 bill in stats ?

[Shakeynath]

All i want is my stats too be more than 2 bill

[Shakeynath]

I have changed the int to bigint for crystals, money and bank money but the limit is still at $2147483647

[Danny696]

You didnt change the limit did you -.-

[Shakeynath]

Limit ?

I change the type to bigint and left the value as 11

DO YOU HAVE TO CHANGE ANYTHING IN STAFF_USERS ??

[rulerofzu]

See

http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html

[Shakeynath]

See

http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html

Theres no need to show me this, I havn't questioned on anything about bigint working or not lol

Ive changed it too bigint on the DB but its still showing 2147483647

DO I HAVE TO EDIT STAFF_USERS ASWELL ?

[rulerofzu]

Ah yeah sorry reading up on what your trying to do isnt required is it. :P

[Shakeynath]

So what do i need to edit in staff_users mate ?

[Shakeynath]

Ive changed int too big int and also changed the value too a higher number, But still the same. This is annoying :cursing: Lmaoooo

[NarutoPRG.com]

Add my MSN mate, and open TV. I'll see what I can do. :)

[Shakeynath]

Thankyou ever so much :) Ive added you mate

[Shakeynath]

It allows me too have over the cap if i edit money in the databse but when i credit users through staff panel it goes back too the 2,147,483,647 price ?? Do i have too change int into something else on staff_users ?

$_POST['money']=(int) $_POST['money'];

$_POST['bankmoney']=(int) $_POST['bankmoney'];

$_POST['cybermoney']=(int) $_POST['cybermoney'];

$_POST['crystals']=(int) $_POST['crystals'];