Money help please

[s4man1]

How is it possible so that the money goes above the $2,147,483,647 cap.

What do i need to change to do this

Many thanks

[bineye]

Try increasing the value in your database table, from INT to BIGINT

[s4man1]

Still no joy

[rulerofzu]

bineye is correct you need to increase the value in the database.

http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

[bineye]

You will be able to hold more cash/points/whatever, but I'm unsure as to why you can only move in 2,147,483,647 intervals.

Question for more advanced users:

Is it because of lines like

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

for example, because of the "int" check?

I'm unsure :s

[rulerofzu]

Your looking at PHP integers there bineye

http://php.net/manual/en/language.types.integer.php

See the reference to 32bit and 64bit

Having not used 32bit for awhile now then IDK would changing the mysql table to bigint go over 2147483647 probably not. Its a limit of the OS and software.

[bineye]

Thanks for that link! Just saw changing the "int" up there to "float" solved it.

[s4man1]

Thankyou for all your help i have managed to sort it now thanks