smhnaji

Hello I've found the SQL query below but it was posted on 2010 and doesn't seem to work now. SELECT tblpricing.currency, tblpricing.msetupfee, tblpricing.qsetupfee, tblpricing.ssetupfee, tblpricing.asetupfee, tblpricing.bsetupfee, tblpricing.monthly, tblpricing.quarterly, tblpricing.semiannually, tblpricing.annually, tblpricing.biennially, (SELECT tblcurrencies.prefix FROM tblcurrencies WHERE id = tblpricing.currency) AS curprefix, (SELECT tblcurrencies.suffix FROM tblcurrencies WHERE id = tblpricing.currency) AS cursuffix, (SELECT tbldomainpricing.extension FROM tbldomainpricing WHERE id = tblpricing.relid) AS extension FROM tblpricing WHERE tblpricing.type= 'domainregister' AND !(SELECT tbldomainpricing.extension FROM tbldomainpricing WHERE id = tblpricing.relid) Our WHMCS is already 7.2 Would you please help with the new query that should show the following result for us?

Thank you very much dear Damo. At least I got the right way to insert manual clients' payments

I had two ways: 1. Going to the unpaid invoice and adding the payment for that invoice from the "Add Payment" tab. 2. Adding a new transaction by going to Billing menu and selecting Transaction List and after adding the transaction using Add Transaction tab. I should note that from the form, I filled the "Invoice ID(s)" field with the proper invoice id. I used the second way. Doesn't the way automatically update Next Due Date? Thank you

I know that if the user himself would pay the invoice, the service's Next Due Date would be updated, but he has payed the invoice not by the system and I have added the transaction and put the invoice id in the new transaction form, so the invoice has been marked as paid. I wanted to know if anything is wrong with me, or if should I care about updating the Next Due Date when a manual transaction is added to user by me. Isn't there anyway so that it automatically update the Next Due Date? Thank you

Hello and thank you for your reply, ok, I will open a ticket and ask them to do so. Thank you again

Hello Because of a DDOS attack, my server was down for about 24 hours. Now I want to add 2 days to any services (monthly, annually, shared hosting, reseller accounts) of the specific server (because of more user specification) I know that it's not currently supported and I should execute a special query in the database. Would you please tell me the exact query? Please don't advise unless you are 100% sure. Because it's not a testable and undoable action. Thank you very much for your help

Thank you very much for this great help

I have extended my hosts with an automated backup and added it as a configurable option. How can the client add the configurable option to the product for the next month/year? How can the client add the configurable option to the product for current remaining days until the next service due date? How can I myself add the configurable option in the admin area for the service until the next due date? Thank you

Would you please explain it? I don't really understand and don't see anything clear after googling. Thank you

Is that possible? If you want more detail, I should say: I know that promotions are really good. They force users to purchase a service. OK. That is good, but it might not be enough. We shouldn't ask users to just use promotions. Suppose that we find a way to put them into more discounted user groups (I don't know how, maybe by adding a module that selects more active user and puts them to more discounted user groups). OK? User groups only lets us discount by percentage. That is not really enough. Promotion codes are very more complex and very better to discount. Is there a way to think about user groups, as a promotion code? So we can have very more complex and hotter offers by their user groups. (And user automatically go to more discounted groups according to their registration date and/or total amount of their purchases) Isn't there a way to DEVELOP this ability? Thank you

Hello Some of my clients say that they receive invoice reminders and invoice overdue payments emails and have forwarded those wrong emails for me. But when I see sent emails in those clients' "Emails" tab (page http://site.com/admin/clientsemails.php?userid=XXX), the wrong emails are NOT listed. I've also seen that some invoice notifications have been sent that have WRONG INVOICE ID and WRONG PRICE! In fact that invoice was not belonged to that client! 1. Why such emails are sent? 2. The mpre important question is: Why are not they logged in the system? Not that I think that my host's cpanel's cron job has a problem: I've set to run ONCE everyday, but it is executed every 12 hours. Is the problem related to this issue? Thank you

Hello I've set a wrong password for DirectAdmin reseller username in WHMCS server configuration. So when I send a request to change a username in DirectAdmin server, I expect to see an error message (like cannot connect to DA server or...) but WHMCS messages that the account's password has been change successfully! Also when I want to create a user in DirectAdmin, WHMCS give successful message. Everything is OK with the cpanel reseller and WHMCS can connect and do proper changes as cpanel reseller as well. Any ideas?

Also Setup -> General Settings have been reverted to Default.

Hello I installed may 29's security patch just now (a min ago). I use WHMCS 5 the latest version. Tonight I saw that all my configuration has been lost (template has been changed to its initial state after a fresh install as it looks). My currency has reverted to default, client area and admin template have reverted back to default and I think there are some other changes... The servers look to be OK at http://site.com/admin/configservers.php Is that caused by that problem? Have I been hacked? Would you please tell me what should I do? Thank you

Hello I have two server for hosting defined for WHMCS: cPanel & DirectAdmin Invoice creations and payment reminders work as expected with no problem as configured exactly in the Automation settings for DirectAdmin Server (server 2), but they don't work on cPanel hosts. They only suspend cPanel hosts without any warning to the client or even creating an invoice! Where should I check if anything is wrong with my configuration? I haven't found anywhere to say that the Automation configuration work only on a special server's hosts.