More money than 2,147,483,647 ?

[r14170]

The title says all.. can you tell me how to do it? .. im noob at php

[Zeggy]

Change the field type for money in the database from int to bigint.

[Danny696]

Why would you need more money? :)

[r14170]

@Zeggy - i cant find that thing 8|

@Danny969 - Just in case :D

[Danny696]

You should never need more than that ;)

[Equinox]

You should never need more than that ;)

 

Erm....why?

Maybe it's a game with a high economy ?

[r14170]

so please tell me exacly where it is or give me the mysql table coz i cant find this :pinch:

[Analog]

its in the users table...

[mysql]ALTER TABLE `users` CHANGE `money` `money` BIGINT NOT NULL DEFAULT '0'[/mysql]

[r14170]

same.. i added 9999999999 the result:

Name: r14170 Crystals: 0

Level: 1 Exp: 0%

Money: $2,147,483,647 HP: 100/100

Property: Default House

[Dominion]

look in your phpmyadmin under the users table if more money then 2,147,483,647 is in there then its showing it due to mcc using (int) on more or less every number so you can not enter more the 2,147,483,647 to -2,147,483,647 (its limit) you need to change all (int) to (float) (i think its float may be wrong O-o)

[r14170]

when its FLOAT the max money are 2,147,480,000 lol..

[Dominion]

<?php
$var1 = abs((float)99999999999999) ;
echo "$var1";
?>

 

would allow more then 2,147,483,647 ...

however mccodes use (int) not (float)

[Equinox]

<?php
$var1 = abs((float)99999999999999) ;
echo "$var1";
?>

 

would allow more then 2,147,483,647 ...

however mccodes use (int) not (float)

Just because in other occurrences of the (int) inside of McCodes, doesn't mean it won't work in this instance.

Unless ofcourse, the 'money' value is doing the same in a different file like globals

[r14170]

im fully noob i told ya.. where to add this

<?php

$var1 = abs((float)99999999999999) ;

echo "$var1";

?>

 

header?

:|

[Dominion]

yes i know it would not effect money unless it was on the money part O-o in banks for example when putting money in it is passed via the $_POST['deposit'] it is using something like

 

$_POST['deposit']=abs((int) $_POST['deposit']);

 

so no more then the int value can go in even if the database would save it (could be wrong)

 

you do not add that it was an example

[Zero-Affect]

weird i don't use int or float lol,

Changing the DB structure of money and then editing int to bigit is a good idea but if i recall don't you edit the value of that column also from 11?

Brain Storming: couldn't you just edit it to dec(65,0)?

[r14170]

i could but i dont know where is it..

[rulerofzu]

In that case id suggest you go learn what your doing and then come back.

[NarutoPRG.com]

I don't know wny people are suggesting more ideas to change it.. Like Zeggy said. Change the DB. Simple, sorted, no performance changes.

[VitalEnd]

simple...

Instead of all that code go into the db go into the users structor and click edit on the money change 11 to 58, this will allow a number so big icant even read it LOL

[r14170]

same..

[Shakeynath]

I changed my db field, And changed the type too bigint and left the value as 11. But it still shows Money: $2147483647

[Danny696]

Yeh, the value of 11 will only allow that from -2147483647 to +2147483647 change it to somehthing like 66

[Shakeynath]

Ive changed it too 66 and still nothing, Do i have too edit any files like staff_users ?

[r14170]

same for me..