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 ]

DROP TABLE `tblreselleraccountsetup` ;
INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('SupportModule', '');
CREATE TABLE IF NOT EXISTS `tblcontacts` (`id` INT( 1 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,`userid` INT( 1 ) NOT NULL ,`firstname` TEXT COLLATE utf8_unicode_ci NOT NULL ,`lastname` TEXT COLLATE utf8_unicode_ci NOT NULL ,`companyname` TEXT COLLATE utf8_unicode_ci NOT NULL ,`email` TEXT COLLATE utf8_unicode_ci NOT NULL ,`address1` TEXT COLLATE utf8_unicode_ci NOT NULL ,`address2` TEXT COLLATE utf8_unicode_ci NOT NULL ,`city` TEXT COLLATE utf8_unicode_ci NOT NULL ,`state` TEXT COLLATE utf8_unicode_ci NOT NULL ,`postcode` TEXT COLLATE utf8_unicode_ci NOT NULL ,`country` TEXT COLLATE utf8_unicode_ci NOT NULL ,`phonenumber` TEXT COLLATE utf8_unicode_ci NOT NULL ,`domainemails` INT( 1 ) NOT NULL ,`generalemails` INT( 1 ) NOT NULL ,`invoiceemails` INT( 1 ) NOT NULL ,`productemails` INT( 1 ) NOT NULL ,`supportemails` INT( 1 ) NOT NULL ) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('AddFundsEnabled', '');
INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('AddFundsMinimum', '10');
INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('AddFundsMaximum', '100');
INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('AddFundsMaximumBalance', '300');
ALTER TABLE `tbldomains` ADD `type` ENUM( 'Register', 'Transfer' ) NOT NULL AFTER `orderid` ;
UPDATE `tbldomains` INNER JOIN tblorders ON tblorders.id=tbldomains.orderid SET tbldomains.type=tblorders.domaintype;
ALTER TABLE `tblorders` DROP `hostingid`, DROP `domainids`, DROP `addonids`, DROP `upgradeids`, DROP `domaintype`;
ALTER TABLE `tblorders` ADD `contactid` INT( 1 ) NOT NULL AFTER `userid` ;
ALTER TABLE `tblticketdepartments` ADD `clientsonly` TEXT NOT NULL AFTER `email` ;
DELETE FROM tblconfiguration WHERE setting='AllowTicketsRegisteredClientsOnly';
ALTER TABLE `tblclients` ADD `billingcid` INT( 1 ) NOT NULL AFTER `notes` ;
INSERT INTO tblconfiguration (`setting` ,`value` )VALUES ('OrderDaysGrace', '0');
ALTER TABLE `tblinvoices` DROP `randomstring` ;