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 `tblclients` ADD `defaultgateway` TEXT NOT NULL AFTER `currency` ;

ALTER TABLE `tbltickets`  ADD `contactid` INT(10) NOT NULL AFTER `userid`;
ALTER TABLE `tblticketreplies`  ADD `contactid` INT(10) NOT NULL AFTER `userid`;

ALTER TABLE `tbldownloads`  ADD `hidden` TEXT NOT NULL AFTER `clientsonly`;

ALTER TABLE `tblorders` ADD `orderdata` TEXT NOT NULL AFTER `promovalue` ;

INSERT INTO `tbladminperms` (`roleid`, `permid`) VALUES ('2', '71'), ('2', '73'), ('1', '104'), ('2', '104'), ('1', '105'), ('2', '105'), ('3', '105'), ('1', '106'), ('1', '107'), ('1', '108'), ('1', '109'), ('1', '110'), ('2', '110'), ('1', '111'), ('1', '112'), ('1', '113'), ('1', '114'), ('1', '115'), ('1', '116'), ('1', '117'), ('1', '118'), ('1', '119'), ('1', '120'), ('2', '120');

UPDATE `tbladmins` SET template='blend' WHERE template='simple';
ALTER TABLE `tblclients`  ADD `bankname` TEXT NOT NULL AFTER `issuenumber`,  ADD `banktype` TEXT NOT NULL AFTER `bankname`,  ADD `bankcode` BLOB NOT NULL AFTER `banktype`,  ADD `bankacct` BLOB NOT NULL AFTER `bankcode`;