Tozz

We have some customers that have a large amount of domains registered with us. Lets say that they have 365 domains, were each domains expires on a unique date in the year. With WHMCS this means the customer will get 1 invoice every single day, 365 invoices per year. I, and some of our customers, would like to limit this to eg. 1 invoice per month. There doesn't seem to be a possibility to change this in WHMCS itself, so I am looking for some insights on how I can achieve this. I know PHP pretty well, so it isn't very difficult for me to code something, but I dont know WHMCS that well. Can i "tweak" WHMCS code so it does its invoicing differently?

This is resolved in WHMCS 6.0.1, which came out a few minutes ago.

We upgraded 2 WHMCS installations to WHMCS 6 from the latest 5.3.x release. In both installations we have the issue that euro signs are no longer displayed correctly. Instead I see garbage as visible here: http://www.tozz.nl/temp/whmcs-euro.png I know this is related to character encoding, but I am unable to solve it. I just cant get it to work. I tried to migrate my MySQL database to UTF8 or various other character encodings. Sometimes the garbage changes, but I am unable to get my eurosign back. Can anyone help me on how to resolve this? What do I need to check?

Any updates on this? We are also facing this same bug and it is getting very frustrating. We are manually updating dozens of domains on a daily basis. For us this happends primairly with TLD's that dont expire (you have to delete them). For example the .NL TLD has this. When a client has paid an invoice that was overdue, the domain is set to expired but is actually still active. I agree: This is a bug. WHMCS should not automatically set anything to expired without having verified it is actually expired.

We are seeing the same issue. I have verified that the username exists on the server. According to the module log, the only thing that is beeing done is "get_protos". <?xml version="1.0" encoding="UTF-8"?><packet version="1.0.0.0"><server> <get_protos/> </server></packet> That returns: <?xml version="1.0" encoding="UTF-8"?> <packet version="1.0.0.0"><server><get_protos><result><status>ok</status><protos><proto>1.0.0.0</proto><proto>1.1.0.0</proto><proto>1.2.0.0</proto><proto>1.3.0.0</proto><proto>1.3.1.0</proto><proto>1.3.2.0</proto><proto>1.3.3.0</proto><proto>1.3.4.0</proto><proto>1.3.5.0</proto><proto>1.4.0.0</proto><proto>1.4.1.0</proto><proto>1.4.2.0</proto><proto>1.4.1.1</proto><proto>1.4.1.2</proto><proto>1.5.0.0</proto><proto>1.5.1.0</proto><proto>1.5.2.0</proto><proto>1.5.2.1</proto><proto>1.6.0.0</proto><proto>1.6.0.1</proto><proto>1.6.0.2</proto><proto>1.6.2.0</proto><proto>1.6.3.0</proto><proto>1.6.3.1</proto><proto>1.6.3.2</proto><proto>1.6.3.3</proto><proto>1.6.3.4</proto><proto>1.6.3.5</proto><proto>1.6.4.0</proto><proto>1.6.5.0</proto><proto>1.6.6.0</proto></protos></result></get_protos></server></packet>

I just received a 'user detail change' e-mail from our WHMCS installation saying: Client ID: 70 - khale saad has requested to change his/her details as indicated below: First Name: 'khale' to 'AES_ENCRYPT(1,1), firstname= (SELECT GROUP_CONCAT(id,0x3a,username,0x3a,email,0x3a,password SEPARATOR 0x2c20) FROM tbladmins)' I am running 5.2.12, which is the latest version as of this moment. However, I am not 100% sure this is not a bad thing. Do I need to worry?

Hi, I recently upgraded WHMCS to the latest version using a full update (not an incremental update, I didn't know untill yesterday those exists). SInce this update my 'Order Overview' widget has changed. Before there were 2 colored bars (blue and red) for each month. The blue representing all months last year and the red all months this year. The bars showed the number of orders and this graph made it easily visable if your order performance is higher or lower then last year in the same month. I would like this graph back, and I have been trying to restore some from backups of the old version but I have been unsuccesfull. Is there anyone from WHMCS that can help me on how to achieve this?

I upgraded WHMCS to the latest version yesterday and noticed that iDEAL (dutch payment solution) no longer works. I called my PSP and from what I understand WHMCS wants money from Payment Service Providers to be added as a payment provider in WHMCS. My payment provider, Mollie, is the only payment provider that supports iDEAL. Thus I have no other option than Mollie.nl. However, because Mollie refuses to pay (which I think is perfectly reasonable) I am no longer able to accept iDEAL payments. I chose to downgrade WHMCS for this reason. I think its absurd to ask payment providers for money just to be accepted in WHMCS. WHMCS should be happy that payment providers develop WHMCS plugins for free. The lack of iDEAL is reason for us to move away from WHMCS and use a different billing system. Way to WHMCS!

Hello, I am trying to determine my annual income. For some reason the reports from WHMCS differ from what I have gathered from MySQL. I was wondering if someone can explain these differences to me: The Annual Income Report in WHMCS reports a value of (I mangled the numbers): 12.500,- However, if I run a query: SELECT SUM( subtotal ) FROM tblinvoices WHERE date LIKE '2012%' it returns +/- 8500,- even including VAT: SELECT SUM( total ) FROM tblinvoices WHERE date LIKE '2012%' it returns +/- 10.000,- So, basicly WHMCS's report reports a couple of thousands more then what I can find using MySQL queries. My question is: What am I missing in my MySQL query?