Cara menghapus semua klien/user WHMCS (reset database)

Panduan cara menghapus semua klien/user WHMCS atau reset database. Tutorial ini akan menghapus:

  • Semua klien (aktif/nonaktif)
  • Data klien:
    • Order klien
    • Pending order
    • Invoice
    • dan lain-lain yang berkaitan dengan data klien

Ini adalah solusi jika WHMCS Anda terkena spam.

  1. Masuk ke phpMyAdmin
  2. Klik Database WHMCS yang digunakan
  3. Klik tab SQL
  4. Paste perintah ini dan klik tombol Go
TRUNCATE `mod_invoicedata` ;
TRUNCATE `tblaccounts` ;
TRUNCATE `tblactivitylog` ;
TRUNCATE `tblaffiliates` ;
TRUNCATE `tblaffiliatesaccounts` ;
TRUNCATE `tblaffiliateshistory` ;
TRUNCATE `tblaffiliatespending` ;
TRUNCATE `tblaffiliateswithdrawals` ;
TRUNCATE `tblbankaccounts`;
TRUNCATE `tblbillableitems` ;
TRUNCATE `tblcancelrequests` ;
TRUNCATE `tblclients` ;
TRUNCATE `tblclientsfiles` ;
TRUNCATE `tblcontacts` ;
TRUNCATE `tblcredit` ;
TRUNCATE `tblcreditcards`;
TRUNCATE `tblcustomfieldsvalues` ;
TRUNCATE `tbldomains` ;
TRUNCATE `tbldomainsadditionalfields` ;
TRUNCATE `tblemails` ;
TRUNCATE `tblhosting` ;
TRUNCATE `tblhostingaddons` ;
TRUNCATE `tblhostingconfigoptions` ;
TRUNCATE `tblinvoiceitems` ;
TRUNCATE `tblinvoices` ;
TRUNCATE `tblnotes` ;
TRUNCATE `tblorders` ;
TRUNCATE `tblpaymethods`;
TRUNCATE `tblquotes` ;
TRUNCATE `tblquoteitems` ;
TRUNCATE `tblsslorders` ;
TRUNCATE `tblticketlog` ;
TRUNCATE `tblticketnotes` ;
TRUNCATE `tblticketreplies` ;
TRUNCATE `tbltickets` ;
TRUNCATE `tblupgrades` ;

Selesai.

Kendala SPAM pada WHMCS? Kontak kami melalui WA.

Share for thank

Donate rate

Leave a Reply

Your email address will not be published. Required fields are marked *