Update this WHMCS module

Hi We have this module which is no longer updated by the inital developer, we require this to run on the newer versions of PHP as this appears to be a very old PHP version if (!defined("WHMCS")) die("This file cannot be accessed directly"); use Illuminate\Database\Capsule\Manager as Capsule; function whmcs_module_cancel_invoices($vars) { $query = "SELECT [login to view URL],[login to view URL] FROM tblinvoices a, tblinvoiceitems b WHERE b.invoiceid=[login to view URL] and b.type='Hosting' and a.status='Unpaid' AND [login to view URL] IN (SELECT id from tblhosting where domainstatus='Terminated' OR domainstatus='Cancelled')"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ $query2 = "UPDATE `tblinvoices` SET `status` = 'Cancelled' WHERE `id` = '".$row['id']."'"; $result2 = mysql_query($query2) or die(mysql_error()); logactivity(" Hooks Cancelled Invoice - Invoice ID: ".$row['id'], $row['userid']); } } add_hook('DailyCronJob', 100, 'auto_cancel_invoices');