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 ]

-- remove browser.php
DROP TABLE IF EXISTS `tblbrowserlinks`;
DELETE FROM `tbladminperms` WHERE `permid` = 48;

-- remove ClientDropdownFormat
DELETE FROM `tblconfiguration` WHERE setting = 'ClientDropdownFormat';

-- feedback_request to tblticketdepartments --
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tblticketdepartments' and column_name='feedback_request') = 0, 'ALTER TABLE tblticketdepartments ADD `feedback_request` tinyint(1) NOT NULL DEFAULT \'0\'', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- set feedback request for each department based on current setting --
UPDATE `tblticketdepartments` SET `feedback_request` = CASE WHEN (SELECT value from `tblconfiguration` WHERE setting = 'TicketFeedback' LIMIT 1) = 'on' THEN 1 ELSE 0 END;

-- remove TicketFeedback from tblconfiguration --
DELETE FROM `tblconfiguration` WHERE setting = 'TicketFeedback';

-- new field for tbldomainpricing
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tbldomainpricing' and column_name='group') = 0, 'ALTER TABLE tbldomainpricing ADD `group` VARCHAR(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT \'none\'', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;