Gecko [ emad.team ]

Name	Size	Permission	Date
install	[ DIR ]	drwxr-xr-x	2026-08-12 16:46
index.php	5.03 KB	-rw-r--r--	2024-09-28 11:59
upgrade321.sql	100 B	-rw-r--r--	2024-09-28 11:59
upgrade330.sql	2.79 KB	-rw-r--r--	2024-09-28 11:59
upgrade340.sql	5.64 KB	-rw-r--r--	2024-09-28 11:59
upgrade341.sql	1.17 KB	-rw-r--r--	2024-09-28 11:59
upgrade350.sql	2.08 KB	-rw-r--r--	2024-09-28 11:59
upgrade360.sql	5.36 KB	-rw-r--r--	2024-09-28 11:59
upgrade361.sql	1.03 KB	-rw-r--r--	2024-09-28 11:59
upgrade362.sql	14.13 KB	-rw-r--r--	2024-09-28 11:59
upgrade370.sql	4.12 KB	-rw-r--r--	2024-09-28 11:59
upgrade380.sql	4.59 KB	-rw-r--r--	2024-09-28 11:59
upgrade400.sql	5.75 KB	-rw-r--r--	2024-09-28 11:59
upgrade410.sql	3.93 KB	-rw-r--r--	2024-09-28 11:59
upgrade420.sql	2.59 KB	-rw-r--r--	2024-09-28 11:59
upgrade421.sql	347 B	-rw-r--r--	2024-09-28 11:59
upgrade430.sql	6.84 KB	-rw-r--r--	2024-09-28 11:59
upgrade431.sql	103 B	-rw-r--r--	2024-09-28 11:59
upgrade440.sql	1.06 KB	-rw-r--r--	2024-09-28 11:59
upgrade442.sql	84 B	-rw-r--r--	2024-09-28 11:59
upgrade450.sql	2.42 KB	-rw-r--r--	2024-09-28 11:59
upgrade452.sql	228 B	-rw-r--r--	2024-09-28 11:59
upgrade500.sql	4.53 KB	-rw-r--r--	2024-09-28 11:59
upgrade501.sql	1.04 KB	-rw-r--r--	2024-09-28 11:59
upgrade502.sql	200 B	-rw-r--r--	2024-09-28 11:59
upgrade503.sql	145 B	-rw-r--r--	2024-09-28 11:59
upgrade510.sql	7.25 KB	-rw-r--r--	2024-09-28 11:59
upgrade512.sql	112 B	-rw-r--r--	2024-09-28 11:59
upgrade520.sql	4.15 KB	-rw-r--r--	2024-09-28 11:59
upgrade521.sql	439 B	-rw-r--r--	2024-09-28 11:59
upgrade524.sql	556 B	-rw-r--r--	2024-09-28 11:59
upgrade530.sql	6.18 KB	-rw-r--r--	2024-09-28 11:59
upgrade533release1.sql	756 B	-rw-r--r--	2024-09-28 11:59
upgrade538release1.sql	147 B	-rw-r--r--	2024-09-28 11:59
upgrade539release1.sql	181 B	-rw-r--r--	2024-09-28 11:59
upgrade600alpha1.sql	11.13 KB	-rw-r--r--	2024-09-28 11:59
upgrade601release1.sql	309 B	-rw-r--r--	2024-09-28 11:59
upgrade610alpha1.sql	2.37 KB	-rw-r--r--	2024-09-28 11:59
upgrade620alpha1.sql	11 KB	-rw-r--r--	2024-09-28 11:59
upgrade622release1.sql	82 B	-rw-r--r--	2024-09-28 11:59
upgrade630alpha1.sql	4.95 KB	-rw-r--r--	2024-09-28 11:59
upgrade630rc1.sql	1.17 KB	-rw-r--r--	2024-09-28 11:59
upgrade700alpha1.sql	1.34 KB	-rw-r--r--	2024-09-28 11:59
upgrade700alpha5.sql	672 B	-rw-r--r--	2024-09-28 11:59
upgrade700beta2.sql	420 B	-rw-r--r--	2024-09-28 11:59
upgrade700rc1.sql	61 B	-rw-r--r--	2024-09-28 11:59
upgrade7100alpha1.sql	1.41 KB	-rw-r--r--	2024-09-28 11:59
upgrade7101release1.sql	486 B	-rw-r--r--	2024-09-28 11:59
upgrade710alpha1.sql	6.21 KB	-rw-r--r--	2024-09-28 11:59
upgrade710beta1.sql	8.23 KB	-rw-r--r--	2024-09-28 11:59
upgrade710rc1.sql	423 B	-rw-r--r--	2024-09-28 11:59
upgrade720alpha1.sql	7.49 KB	-rw-r--r--	2024-09-28 11:59
upgrade720beta3.sql	755 B	-rw-r--r--	2024-09-28 11:59
upgrade720release1.sql	3.02 KB	-rw-r--r--	2024-09-28 11:59
upgrade723release1.sql	585 B	-rw-r--r--	2024-09-28 11:59
upgrade730alpha1.sql	1.62 KB	-rw-r--r--	2024-09-28 11:59
upgrade730rc1.sql	147 B	-rw-r--r--	2024-09-28 11:59
upgrade740alpha1.sql	855 B	-rw-r--r--	2024-09-28 11:59
upgrade740beta1.sql	1.49 KB	-rw-r--r--	2024-09-28 11:59
upgrade740release1.sql	123 B	-rw-r--r--	2024-09-28 11:59
upgrade750alpha1.sql	6.67 KB	-rw-r--r--	2024-09-28 11:59
upgrade750rc1.sql	808 B	-rw-r--r--	2024-09-28 11:59
upgrade750release1.sql	666 B	-rw-r--r--	2024-09-28 11:59
upgrade751release1.sql	380 B	-rw-r--r--	2024-09-28 11:59
upgrade760alpha1.sql	1.64 KB	-rw-r--r--	2024-09-28 11:59
upgrade760release1.sql	213 B	-rw-r--r--	2024-09-28 11:59
upgrade761release1.sql	306 B	-rw-r--r--	2024-09-28 11:59
upgrade770alpha1.sql	4.79 KB	-rw-r--r--	2024-09-28 11:59
upgrade771release1.sql	424 B	-rw-r--r--	2024-09-28 11:59
upgrade780alpha1.sql	7.15 KB	-rw-r--r--	2024-09-28 11:59
upgrade780rc1.sql	796 B	-rw-r--r--	2024-09-28 11:59
upgrade780release1.sql	432 B	-rw-r--r--	2024-09-28 11:59
upgrade783release1.sql	276 B	-rw-r--r--	2024-09-28 11:59
upgrade790alpha1.sql	6.57 KB	-rw-r--r--	2024-09-28 11:59
upgrade792release1.sql	442 B	-rw-r--r--	2024-09-28 11:59
upgrade800alpha1.sql	13.37 KB	-rw-r--r--	2024-09-28 11:59
upgrade800rc1.sql	340 B	-rw-r--r--	2024-09-28 11:59
upgrade800rc2.sql	1.14 KB	-rw-r--r--	2024-09-28 11:59
upgrade800rc3.sql	203 B	-rw-r--r--	2024-09-28 11:59
upgrade810alpha1.sql	409 B	-rw-r--r--	2024-09-28 11:59
upgrade810rc1.sql	1.15 KB	-rw-r--r--	2024-09-28 11:59
upgrade810release1.sql	191 B	-rw-r--r--	2024-09-28 11:59
upgrade820alpha1.sql	3.43 KB	-rw-r--r--	2024-09-28 11:59
upgrade830alpha1.sql	4.63 KB	-rw-r--r--	2024-09-28 11:59
upgrade830release1.sql	1.25 KB	-rw-r--r--	2024-09-28 11:59
upgrade831release1.sql	1.4 KB	-rw-r--r--	2024-09-28 11:59
upgrade832release1.sql	679 B	-rw-r--r--	2024-09-28 11:59
upgrade840alpha1.sql	1.36 KB	-rw-r--r--	2024-09-28 11:59
upgrade850alpha1.sql	8.57 KB	-rw-r--r--	2024-09-28 11:59
upgrade850beta1.sql	446 B	-rw-r--r--	2024-09-28 11:59
upgrade860rc1.sql	1.66 KB	-rw-r--r--	2024-09-28 11:59
upgrade870beta2.sql	501 B	-rw-r--r--	2024-09-28 11:59
upgrade880beta1.sql	3.28 KB	-rw-r--r--	2024-09-28 11:59
upgrade880rc1.sql	1.11 KB	-rw-r--r--	2024-09-28 11:59
upgrade890beta1.sql	1.67 KB	-rw-r--r--	2024-09-28 11:59

Rename

-- Create affiliates hits table.
CREATE TABLE IF NOT EXISTS `tblaffiliates_hits` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `affiliate_id` int(10) unsigned NOT NULL DEFAULT 0,
  `referrer_id` int(10) unsigned NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `affiliate_id` (`affiliate_id`,`referrer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- Create affiliates referrers table.
CREATE TABLE IF NOT EXISTS `tblaffiliates_referrers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `affiliate_id` int(10) unsigned NOT NULL DEFAULT 0,
  `referrer` varchar(500) NOT NULL DEFAULT '',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `affiliate_id` (`affiliate_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- Create marketing consent table.
CREATE TABLE IF NOT EXISTS `tblmarketing_consent` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned NOT NULL DEFAULT 0,
  `opt_in` tinyint(1) NOT NULL DEFAULT 0,
  `admin` tinyint(1) NOT NULL DEFAULT 0,
  `ip_address` varchar(32) NOT NULL DEFAULT '',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- Update permissable addon status values
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tblhostingaddons' and column_name='status' and column_type="enum('Pending','Active','Suspended','Terminated','Cancelled','Fraud','Completed')") = 0, "ALTER TABLE `tblhostingaddons` CHANGE `status` `status` ENUM('Pending','Active','Suspended','Terminated','Cancelled','Fraud','Completed') NOT NULL DEFAULT 'Pending'",'DO 0;');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- Fix state spelling
UPDATE `tblclients` SET `state`='Chhattisgarh' WHERE `state`='Chattisgarh';
UPDATE `tblcontacts` SET `state`='Chhattisgarh' WHERE `state`='Chattisgarh';
UPDATE `tblquotes` SET `state`='Chhattisgarh' WHERE `state`='Chattisgarh';
UPDATE `tbltax` SET `state`='Chhattisgarh' WHERE `state`='Chattisgarh';

-- Add the updated_at column to tbltickets
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tbltickets' and column_name='updated_at') = 0, 'alter table tbltickets add `updated_at` timestamp NOT NULL DEFAULT \'0000-00-00 00:00:00\'', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- Add View MarketConnect Balance permission to existing roles.
INSERT INTO `tbladminperms` (`roleid`, `permid`) VALUES ('1', '145'), ('2', '145');

-- Add email marketing opt in default message
set @query = if ((select count(*) from `tblconfiguration` where `setting` = 'EmailMarketingOptInMessage') = 0, "INSERT INTO `tblconfiguration` (`setting`, `value`, `created_at`, `updated_at`) VALUES ('EmailMarketingOptInMessage', 'We would like to send you occasional news, information and special offers by email. To join our mailing list, check below. You can unsubscribe at any time.', now(), now());",'DO 0;');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- Add the grace_period column to tbldomainpricing
-- grace period can be overridden to '0' so -1 is default
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tbldomainpricing' and column_name='grace_period') = 0, 'alter table tbldomainpricing add `grace_period` INT(1) NOT NULL DEFAULT \'-1\';', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- created_at to tbldomainpricing --
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tbldomainpricing' and column_name='created_at') = 0, 'ALTER TABLE `tbldomainpricing` ADD COLUMN `created_at` timestamp NOT NULL DEFAULT \'0000-00-00 00:00:00\';', 'DO 0;');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- updated_at to tbldomainpricing --
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tbldomainpricing' and column_name='updated_at') = 0, 'ALTER TABLE `tbldomainpricing` ADD COLUMN `updated_at` timestamp NOT NULL DEFAULT \'0000-00-00 00:00:00\';', 'DO 0;');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- Add the redemption_grace_period column to tbldomainpricing
-- redemption grace period can be overridden to '0' so -1 is default
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tbldomainpricing' and column_name='redemption_grace_period') = 0, 'alter table tbldomainpricing add `redemption_grace_period` INT(1) NOT NULL DEFAULT \'-1\' AFTER `grace_period`;', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- Add new DomainExpirationFeeHandling setting to tblconfiguration
set @query = if ((select count(*) from `tblconfiguration` where `setting` = 'DomainExpirationFeeHandling') = 0, "INSERT INTO `tblconfiguration` (`setting`, `value`, `created_at`, `updated_at`) VALUES ('DomainExpirationFeeHandling', 'existing', now(), now());",'DO 0;');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- Add new statuses to tbldomains
ALTER TABLE `tbldomains` CHANGE `status` `status` ENUM('Pending','Pending Transfer','Active','Grace','Redemption','Expired','Cancelled','Fraud','Transferred Away') NOT NULL DEFAULT 'Pending';

-- Add the grace_period_fee column to tbldomainpricing
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tbldomainpricing' and column_name='grace_period_fee') = 0, 'alter table tbldomainpricing add `grace_period_fee` DECIMAL(10,2) NOT NULL DEFAULT \'0.00\' AFTER `grace_period`;', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- Add the redemption_grace_period_fee column to tbldomainpricing
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tbldomainpricing' and column_name='redemption_grace_period_fee') = 0, 'alter table tbldomainpricing add `redemption_grace_period_fee` DECIMAL(10,2) NOT NULL DEFAULT \'-1.00\' AFTER `redemption_grace_period`;', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;