querycheck

[mich_f]

add_hook('PreCronJob', 1, function() {

    $table = "gateway_mollie";
    $fields = "invoiceid";
    $where = array("status"=>'open');
    $result = select_query($table,$fields,$where);
    $data = mysql_fetch_array($result);
    
      $invoiceid = $data['invoiceid'];
        foreach($invoiceid as $key => $invoice ){

 
      
        $CONFIG = acumulus_connect_getConfig();
   
        

         $token   = Capsule::table('mod_acumulus_connect')->where('id', $invoice)->value('token');
        
            $client  = acumulus_connect_getclient($invoiceid, $CONFIG);
        
        
            $res = acumulus_connect_getPaymentStatus($CONFIG, $invoiceid, $client, $token);
        
        
           if(strtolower($res['paymentstatus']) == 'paid' or $res['paymentstatus'] == '1' ){
             $table = "gateway_mollie";
            $update = array("status"=>"paid");
            $where = array("invoiceid"=>"$invoice");
             
            update_query($table,$update,$where);
        }}
        
    
        });
 

[pRieStaKos]

https://developers.whmcs.com/advanced/db-interaction/