// /includes/hooks/Cancell_overdue_invoice.php
if (!defined("WHMCS"))
die("This file cannot be accessed directly");

function Cancell_overdue_invoice() {
full_query("UPDATE tblinvoices SET status = 'Cancelled' WHERE duedate <= date_sub(curdate(), INTERVAL 7 DAY) AND status = 'Unpaid';"); } add_hook("DailyCronJob",1,"Cancell_overdue_invoice"); ?>