Expanding the currency size

[Guest bigfoot6155]

Is there a way to edit the code on the currency page so that it will accept a 7 digit exchange rate. I noticed it goes from 1 to 999,999 but Turkish Lirasi is 1.35 million to the U.S. Dollar

[Guest bigfoot6155]

bump

[Guest vrakas]

Hi there,

suggestion i have just tryed and it works.

Under admin in the currency where the Decimal Places are put a number 6 and this at least will give you million sign.

Price: 99.000000 this was added a 99 to the price and this is the result.

Let me know if this works for you. :w00t:

[Guest bigfoot6155]

Thank you very much, I'll try it.

[Guest bigfoot6155]

Thanks for the idea but i need 7 digit spaces to the left of the decimal

[Guest]

Ok, in PHPMyAdmin, you'll need to execute this SQL query:

ALTER TABLE `CubeCart_currencies` CHANGE `value` `value` DECIMAL( 13, 5 ) NOT NULL DEFAULT '0.00000'

The problem is the limit of the database definition so we just have to change the default. No biggie.

[Guest bigfoot6155]

thank you, anything to do with my databases makes me nervous.

[Guest bigfoot6155]

It worked, thank you so much. Consider this topic closed.