[davidw]

If you want to show decimal places as in real currency, you need to make one alteration. Remember to do a backup of your table before doing this. I will not be held responsible for any problems. This works on my forums just fine.

Go in to phpmyadmin or however you alter your database and run this query
[sql]alter table " . TABLE_PREFIX . "user modify money decimal(15,2);[/sql]

If you are running iBank, you will need to run this query as well
[sql]alter table " . TABLE_PREFIX . "user modify bankmoney decimal(15,2);[/sql]

If you haven't installed this mod yet, this change to the installer should work

Find

PHP Code:

<installcode><![CDATA[
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD COLUMN money int(15) DEFAULT '0' NOT NULL");
    ]]></installcode> 


Replace with

PHP Code:

<installcode><![CDATA[
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD COLUMN money decimal(15,2) DEFAULT '0' NOT NULL");
    ]]></installcode>