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');
Hello!
I'm WHMCS admin user/developer already since v2.2 (somewhere in year 2006), did many template customization, hacks & hooks, provisioning modules and payment gateways (last was The Ethereum payment gateway & VPN account provisioning module for WHMCS 7.9).
I would love to update your module to work on the latest WHMCS ad PHP 7.3.
Looking forward working with you,
Junell
I am ready to start now.
I have 3+ years experience in web development. I am full stack developer.
Discuss more about the project and I will be starting project asap.
Thanks