Sign in to follow this
Followers
0
-
Similar Content
-
By Hardik Lamichhane
Hello,
please help me to edit my sidebar item "Open Ticket" link
Im using latest version of whmcs, i need the hook to change the url of that item.
Screenshot is shown below.
Thanks in advance.
-
By WHMCS Josh
An unfortunate trait of the internet is spam and automated bots disseminating that spam. As a business operator on the internet, you may also receive orders submitted in bulk by automated bots. There can be situations where you need to delete lots of clients with the same first name.
This small script leverages the local API to cleanly delete all clients who match the specified term.
This script is provided as-is, without warranty, and in the understanding for the potential to permanently and irreversibly delete data. Before running this script, please make a database backup:
<?php /** * Delete spam clients where the firstname contains 5666Q.COM * using advanced database interaction and the DeleteClient API * * @link https://developers.whmcs.com/advanced/db-interaction/ * @link https://developers.whmcs.com/api-reference/deleteclient/ * * @author WHMCS Limited <development@whmcs.com> * @copyright Copyright (c) WHMCS Limited 2005-2018 * @license https://www.whmcs.com/eula/ WHMCS Eula */ require 'init.php'; use WHMCS\Database\Capsule; // Replace ADMIN_USERNAME with your admin username $adminUsername = 'ADMIN_USERNAME'; echo '<pre>'; // Loop through all clients where firstname contains 5666Q.COM foreach (Capsule::table('tblclients')->where('firstname', 'like', '%5666Q.COM%')->get() as $client) { // Delete the client with DeleteClient API $results = localAPI('DeleteClient', ['clientid' => $client->id], $adminUsername); // Check for errors if ($results['result'] == 'success') { echo "Deleted Client ID: " . $client->id; } else { echo "Error deleting Client ID: " . $client->id; } } echo '</pre>';
Begin by entering your adminstrator's username on line 19:
$adminUsername = 'ADMIN_USERNAME'; Upload the script to your WHMCS directory, and visit in your browser.
The script will search through all the clients matching the criteria specified in this line:
'firstname', 'like', '%5666Q.COM%' It will then properly and permanently delete matching clients and associated records.
The last step is to show which clients are deleted, and if a problem was occurred.
The file should then be deleted from your server.
At the time of writing this post, this script was tested on the latest stable release of WHMCS 7.5.1 and should work with any that fall under Active Support as per the LTS schedule here: https://docs.whmcs.com/Long_Term_Support#WHMCS_Version_.26_LTS_Schedule
If you have any feedback, questions, or concerns that I did not cover in this post, please feel free to reach out!
delete_spam_clients.php
-
By shanejen
Hi
Could someone help me with the sidebar removal during checkout/configuration and domain search ECT. I've managed to remove them with hooks and CSS, but I want the remaining content to fill the page and not be set to the right. There's too many out of date posts regarding this on here, and the WHMCS documentation is too vague. I'm using twenty-one template.
TIA
-
By Dsbush
So,I have an issue where some of my product groups in my sidebar are doubling up. I want to get rid of the doubles. What would be the best course of action that is not too complicated.
-
By mindofmedia
Hello,
Like every year where are adjusting our pricing on the local index.
But because we still have a few clients that uses our old product gamma we still need to updates these pricing also. While that's fine for the active clients, I can't seems to delete the products that aren't active anymore on any client besides that are cancelled or terminated.
So that product is still in the clients database (as cancelled or terminated) and most of the times the customer isn't even a customer anymore. Because of that I can't remove the products from Whmcs. I can hide them, retire them that is all fine but they still are in the admin product list (not in dropdown, the actual list where you can see all your products in the admin area).
So I was wondering, what if I delete all the terminated and cancelled products from the customers client profile.
But I'm not really sure about that, so I would like to know your opinion. What do you do?
I think in EU (or BE for that fact), we can't delete the customer profile data, invoices, etc for 10 years (maybe a hard copy of the invoices is fine, don't know). But I don't think that applies on their products (since the actually webhosting is already long gone of course). And if we want we can still see the history on their invoices.
So what do you do when a customer (or you) cancels (or terminates), what do you do with their profile, history, products, tickets, invoices, etc? Do you delete it, keep it, keep if for a few months, years, decades?
-
-
Recently Browsing 0 members
No registered users viewing this page.
