xCausxn Posted August 12, 2013 Share Posted August 12, 2013 Hello, I play a game called EVE ONLINE and sell webhosting / website installations aswell as teamspeak 3 servers. Due to the price of these ingame they cost over 100 million in the currency. However when i type this amount in it reverts to 99999999.99 . How can i remove this? i know its not how whmcs is meant to operate but can someone please point me in the right direction? Thanks James 0 Quote Link to comment Share on other sites More sharing options...
xCausxn Posted August 12, 2013 Author Share Posted August 12, 2013 Anyone know a way to do this? 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted August 15, 2013 Share Posted August 15, 2013 It's because WHMCS uses decimal(10,2) type for pricing in database so the maximum amount supported is 99999999.99 (8 integers, 2 decimals). You can't handle 100000000.00 number unless you decide to alter columns with decimal(11,2). 0 Quote Link to comment Share on other sites More sharing options...
xCausxn Posted August 16, 2013 Author Share Posted August 16, 2013 Thank you very much i did that Also would you know a way of setting a default currency per product? also a way to only have one currency on a product 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted August 16, 2013 Share Posted August 16, 2013 Let me understand. You have multiple currencies in your WHMCS but you want to assign a specific currency to some products. Is it correct? 0 Quote Link to comment Share on other sites More sharing options...
xCausxn Posted August 16, 2013 Author Share Posted August 16, 2013 Yes that correct. Say Product A i want to have Currency 1 and Currency 2. Whereas Product B i only want Currency 1. That kinda thing. 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted August 16, 2013 Share Posted August 16, 2013 In this moment i can only think about a solution based on template customization where you prevent users from being able to change currency when specific condition are met. If you know how to use PHP/Smarty it's quite easy. 0 Quote Link to comment Share on other sites More sharing options...
xCausxn Posted August 16, 2013 Author Share Posted August 16, 2013 Can anybody help me out with this Would be a great help. Thanks for your support though Kian 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted August 16, 2013 Share Posted August 16, 2013 For sure in the Marketplace you'll find someone http://forum.whmcs.com/forumdisplay.php?49-Marketplace 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.