Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/domains/gositeme.com/public_html/whmcs/resources/sql/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

ALTER TABLE `tblproducts` ADD `order` INT( 1 ) NOT NULL ;

INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('LateFeeType', 'Percentage');

CREATE TABLE IF NOT EXISTS `tblnotes` (
`id` INT( 1 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT( 10 ) UNSIGNED ZEROFILL NOT NULL ,
`adminid` INT( 1 ) NOT NULL ,
`created` DATETIME NOT NULL ,
`modified` DATETIME NOT NULL ,
`note` TEXT COLLATE utf8_unicode_ci NOT NULL
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `tblproductconfigoptionssub` ADD `setup` DECIMAL( 10, 2 ) NOT NULL AFTER `optionname` ;

ALTER TABLE `tblemailtemplates` ADD `copyto` TEXT NOT NULL ;
ALTER TABLE `tblemailtemplates` ADD `plaintext` INT( 1 ) NOT NULL ;

ALTER TABLE `tblinvoices` ADD `invoicenum` TEXT NOT NULL AFTER `id` ;

ALTER TABLE `tbldownloads` ADD `productdownload` TEXT NOT NULL ;
ALTER TABLE `tblproducts` ADD `downloads` TEXT NOT NULL AFTER `affiliatepayamount` ;

UPDATE tblconfiguration SET setting='SendFirstOverdueInvoiceReminder' WHERE setting='SendOverdueInvoiceReminders';
INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('SendSecondOverdueInvoiceReminder', '0');
INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('SendThirdOverdueInvoiceReminder', '0');

UPDATE tblemailtemplates SET name='First Invoice Overdue Notice' WHERE name='Invoice Overdue Notice';
UPDATE tblemailtemplates SET subject='First Invoice Overdue Notice' WHERE subject='Invoice Overdue Notice';

INSERT INTO `tblemailtemplates` (type,name,subject,message) VALUES ( 'invoice', 'Second Invoice Overdue Notice', 'Second Invoice Overdue Notice', '<p> Dear [CustomerName], </p> <p> This is the second billing notice that your invoice no. [InvoiceNo] which was generated on [InvoiceDate] is now overdue. </p> <p> Your payment method is: [PaymentMethod] </p> <p> Invoice: [InvoiceNo]<br /> Balance Due: [Balance]<br /> Due Date: [DueDate] </p> <p> You can login to your client area to view and pay the invoice at [InvoiceLink] </p> <p> Your login details are as follows: </p> <p> Email Address: [CustomerEmail]<br /> Password: [CAPassword] </p> <p> [Signature] </p>');
INSERT INTO `tblemailtemplates` (type,name,subject,message) VALUES ( 'invoice', 'Third Invoice Overdue Notice', 'Third Invoice Overdue Notice', '<p> Dear [CustomerName], </p> <p> This is the third and final billing notice that your invoice no. [InvoiceNo] which was generated on [InvoiceDate] is now overdue. Failure to make payment will result in account suspension.</p> <p> Your payment method is: [PaymentMethod] </p> <p> Invoice: [InvoiceNo]<br /> Balance Due: [Balance]<br /> Due Date: [DueDate] </p> <p> You can login to your client area to view and pay the invoice at [InvoiceLink] </p> <p> Your login details are as follows: </p> <p> Email Address: [CustomerEmail]<br /> Password: [CAPassword] </p> <p> [Signature] </p>');