WHMCS 9.0 Invoice Mutation

Insert the following line in configuration.php.

 $allow_adminarea_invoice_mutation = true;

WHMCS Manual Cron Run

 /usr/local/bin/php -q /home/username/public_html/whmcs/crons/cron.php all --force -vvv

See Custom Cron...

Linux command to find user who failed to login from pop/imap

 journalctl -u dovecot -g "auth failed"

grep -i "auth failed" /var/log/mail.log | grep -E "imap|pop"

journalctl -u dovecot -g "auth failed" | grep -oE "user=<.*?>" | sort | uniq -c

grep "auth failed" /var/log/maillog | awk '{print $NF}' | sort | uniq -c | sort -nr

grep "auth failed" /var/log/maillog | grep "@example.com" | head

grep "auth failed" /var/log/maillog | \

grep -oE '[A-Za-z0-9._%+-]+@example\.com' | \

sort | uniq -c | sort -nr

grep "auth failed" /var/log/maillog | \

awk '/@example\.com/ {print $NF}' | \

sort | uniq -c | sort -nr

Replace old IP with New one in Direct Admin

./ipswap.sh Old_IP  New_IP

for example:

 ./ipswap.sh 35.224.2.88 104.197.113.37

SQL to delete all WooCommerce products except those with "draft" status

 -- Disable foreign key checks (important for InnoDB)

SET

    FOREIGN_KEY_CHECKS = 0;

    -- Delete product meta

DELETE

    pm

FROM

    wp_postmeta pm

JOIN wp_posts p ON

    pm.post_id = p.ID

WHERE

    p.post_type = 'product' AND p.post_status != 'draft';

    -- Delete term relationships

DELETE

    tr

FROM

    wp_term_relationships tr

JOIN wp_posts p ON

    tr.object_id = p.ID

WHERE

    p.post_type = 'product' AND p.post_status != 'draft';

    -- Delete the products

DELETE

FROM

    wp_posts

WHERE

    post_type = 'product' AND post_status != 'draft';

    -- Enable foreign key checks again

SET

    FOREIGN_KEY_CHECKS = 1;

Restrict Access to PHPMyAdmin with DirectAdmin

cd /usr/local/directadmin/

./directadmin set one_click_pma_login 1 restart

cd custombuild

./build update

./build set phpmyadmin_public no

./build phpmyadmin

How not to fill filtered out cells when dragging down from another sheet

Steps:

1. Apply your filter in Sheet1.

2. Select the range where you want to paste the formula (e.g., A2:A100) but only visible cells will be selected.

   • Select the range.

   • Press F5 or Ctrl+G → Click Special… → Choose Visible cells only → OK.

3. Type your formula (e.g.):

   =INDEX(Sheet2!A:A, ROW()-1)

4. Press Ctrl+Enter (instead of just Enter).