othellotech

If it shows an IP address in the ticket then it came from the form, not from email, so blocking the mail will do nothing - you'll need to firewall off the spammers IP ranges

You don't need to start again, clearing (trunc) the orders, invoices, hosting, domains, accounts tables and use sql (or whmcs config) to set what the next id/numbers should be - this is simpler than trying to pull selective data over. As to tidying users - yes. delete from tblusers_clients where there is no matching tblclients.id to client_id then delete from tblusers where there is no matching tblusers.id to auth_user_id

In WHMCS take advantage of the due and expiry dates being possibly different values :) Set the "next due" to be the month-end of the previous month that they expire in ie If domain actually expires 13/Feb, set next-due to 31/Jan so it processes with the January payment

How does IP Address relate to an INVOICE (which can have an infinite number of services/domains/etc on it ?

There is a renewals field on the tblorders, if that's filled in it's a domain renewal 🙂 Although I think you're using "renewal" to mean more than just domains - the recurring / next invoice for servcies etc - in which case, you'd really only know by checking if it's the 1st invoice for that id i.e. (tblhosting/tbldomains/tblupgrades/etc).orderid=tblorders.id

Yes, use "OR" 🙂 for example {if $variable eq "specific-thing" || $variable|strstr:"other" || $variable eq "just-one-more"}Do Something{/if}

>How has this never come up as a common problem? Because WHMCS doesn't talk to *registries* or gTLDs, it talks to *registrars* who already handle the autoreew/autodelete for you 🙂 However there are plenty of issues with whmcs default handling of domain lifecycle, especially for cctlds

>When would that query and invoice run? January or December? It wouldn't matter, just use today+1Y (or today+1Y+1d is 28th feb) - any domain coming up for renewal within the year will be on that, and any new registrations or gtld domains moved in will have dates of next year, so pickedup on the next years' run > What happens in case someone does not want to renew some domains? They mark them as do not renew / turn off autorenew in the client area as normal and WHMCS takes them off the invoice automatically.

That's a standard feature - you just set the due-date to be the same on them all 🙂

on the client summary page, tick the box next to each domain click "invoice now" (or whatever your version calls it) no need to change dates

delete the line item from the invoice cancel the invoice delete the cancelled invoice change the due-date back 1 day on the product change the due -date to it's original date on the product change the billingperiod and tick the recalc on save on the product and save on the client summary page click generate due invoices (or wait for the cron if doing multiple)

Sounds like you have something in your theme/modules/etc that is "calling out" to somewhere you've firewalled off.

Settings, Automation and untick the boxes 🙂

The (mostly correct) existing fields are defined in /resources/domains/dist.additionalfields.php you can add a /resources/domains/additionalfields.php to have your own