👀 Choose SSD-powered VPS servers for increased speed, power, and security! Now 50% off- starting from only $3.19/mo.
This article provides a guide for how to bulk add Banned IPs in WHMCS.
WHMCS Banned IPs is the list of IPs which are unable create accounts/login. This is useful to prevent any user from signing up from problematic networks.
How to Bulk Add Banned IPs in WHMCS
To bulk add Banned IPs in WHMCS, follow the steps below:
- Login to cPanel server of your WHMCS.
- Navigate to phpMyAdmin.
- Select your WHMCS database.
- Click "SQL" to input query.
- Enter the following query:
Replace '192.168.1.1', '192.168.2.*' and '192.169.*.*' with your preferred values.INSERT INTO `tblbannedips` (`id`, `ip`, `reason`, `expires`) VALUES (NULL, '192.168.1.1', 'Network Abuse', '2099-12-31 23:59:00'), (NULL, '192.168.2.*', 'Network Abuse', '2099-12-31 23:59:00'), (NULL, '192.169.*.*', 'Network Abuse', '2099-12-31 23:59:00');
You can use this format to bulk add Banned IPs in WHMCS via SQL query.
