Is there any way to Mass Delete Inactive user who using USD only with PhpMyadmin ?

[serverbd]

Is there any way to Mass Delete Inactive user who using Currency USD only with PhpMyadmin ?

[pRieStaKos]

What about accounting history ?

[developer _WHM_CS]

On 9/20/2021 at 6:18 PM, serverbd said:

Is there any way to Mass Delete Inactive user who using Currency USD only with PhpMyadmin ?

Hello

it is better use Local API
 

Please go to PhpMyadmin and open tblcurrencies  

use currency id to following code  ( the currency  from tblcurrencies )

<?php
require_once 'init.php';
use whmcs\Capsule as DB;

$clients  =  DB::table('tblclients')->where('status','Inactive')->where('currency','the curency from tblcurrencies')->get();

foreach ($clients as $client){
   $command = 'DeleteClient';
   $postData = array(
      'clientid' => $client->id,
      'deleteusers' => false,// Delete any users not associated with any other client. recommended change to true
      'deletetransactions' => true, // Delete all transactions on this account. recommended change to true
   );

   $results = localAPI($command, $postData);
   print_r($results);


}