public function autoExecutePayments()
 {
     //Status 2 orders are confirmed orders ready to collect payment.
     //This status change automatically whenever the payment is approved by the customer
     $db = new clsDBdbConnection();
     $sql = "select id from orders where status_id = 2";
     $db->query($sql);
     $payments = new Payments();
     while ($db->next_record()) {
         $orderid = (int) $db->f("id");
         $payments->executePayment($orderid);
     }
     $db->close();
     return true;
 }