IP : 18.223.210.181Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
mw/
../
fork/
../
presta178/
../
magento2/
../
domainmod/
domainmod.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Table structure for table `api_registrars` --
CREATE TABLE `api_registrars` ( `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `req_account_username` tinyint(1) NOT NULL DEFAULT '0', `req_account_password` tinyint(1) NOT NULL DEFAULT '0', `req_account_id` tinyint(1) NOT NULL DEFAULT '0', `req_reseller_id` tinyint(1) NOT NULL DEFAULT '0', `req_api_app_name` tinyint(1) NOT NULL DEFAULT '0', `req_api_key` tinyint(1) NOT NULL DEFAULT '0', `req_api_secret` tinyint(1) NOT NULL DEFAULT '0', `req_ip_address` tinyint(1) NOT NULL DEFAULT '0', `lists_domains` tinyint(1) NOT NULL DEFAULT '0', `ret_expiry_date` tinyint(1) NOT NULL DEFAULT '0', `ret_dns_servers` tinyint(1) NOT NULL DEFAULT '0', `ret_privacy_status` tinyint(1) NOT NULL DEFAULT '0', `ret_autorenewal_status` tinyint(1) NOT NULL DEFAULT '0', `notes` longtext COLLATE utf8_unicode_ci NOT NULL, `insert_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00', `update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=19 ;
-- -- Dumping data for table `api_registrars` --
INSERT INTO `api_registrars` VALUES (1, 'Above.com', 0, 0, 0, 0, 0, 1, 0, 0, 1, 1, 1, 1, 1, '', '[[regtime]]', '1970-01-01 00:00:00'), (2, 'DNSimple', 0, 0, 0, 0, 0, 1, 0, 0, 1, 1, 1, 1, 1, '', '[[regtime]]', '1970-01-01 00:00:00'), (3, 'DreamHost', 0, 0, 0, 0, 0, 1, 0, 0, 1, 1, 1, 0, 1, 'DreamHost does not currently allow the WHOIS privacy status of a domain to be retrieved via their API, so all domains added to the Domain Queue from a DreamHost account will have their WHOIS privacy status set to No by default.', '[[regtime]]', '1970-01-01 00:00:00'), (4, 'Dynadot', 0, 0, 0, 0, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', '[[regtime]]', '1970-01-01 00:00:00'), (5, 'eNom', 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', '[[regtime]]', '1970-01-01 00:00:00'), (6, 'Fabulous', 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', '[[regtime]]', '1970-01-01 00:00:00'), (7, 'Freenom', 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 'Freenom currently only gives API access to reseller accounts.', '[[regtime]]', '1970-01-01 00:00:00'), (8, 'Gandi', 0, 0, 0, 0, 0, 1, 0, 0, 1, 1, 1, 0, 1, 'Gandi does not currently allow the WHOIS privacy status of a domain to be retrieved via their API, so all domains added to the Domain Queue from a Gandi account will have their WHOIS privacy status set to No by default.', '[[regtime]]', '1970-01-01 00:00:00'), (9, 'GoDaddy', 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 1, 1, 1, 'When retrieving your list of domains from GoDaddy, the current limit is 1,000 domains. If you have more than this you should export the full list of domains from GoDaddy and paste it into the <strong>Domains to add</strong> field when adding domains via the Domain Queue.', '[[regtime]]', '1970-01-01 00:00:00'), (10, 'Internet.bs', 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 1, 1, 1, '', '[[regtime]]', '1970-01-01 00:00:00'), (11, 'Name.com', 1, 0, 0, 0, 0, 1, 0, 0, 1, 1, 1, 1, 1, '', '[[regtime]]', '1970-01-01 00:00:00'), (12, 'NameBright', 1, 0, 0, 0, 1, 0, 1, 0, 1, 1, 1, 1, 1, '', '[[regtime]]', '1970-01-01 00:00:00'), (13, 'Namecheap', 1, 0, 0, 0, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', '[[regtime]]', '1970-01-01 00:00:00'), (14, 'NameSilo', 0, 0, 0, 0, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'NameSilo''s domains have 6 possible statuses: Active, Expired (grace period), Expired (restore period), Expired (pending delete), Inactive, and Pending Outbound Transfer<BR><BR>When retrieving your list of domains via the API, <STRONG>Inactive</STRONG> domains are not returned.<BR><BR>When retrieving the details of a specific domain via the API, <STRONG>Inactive</STRONG> and <STRONG>Expired (pending delete)</STRONG> domains will not return any data.', '[[regtime]]', '1970-01-01 00:00:00'), (15, 'OpenSRS', 1, 0, 0, 0, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', '[[regtime]]', '1970-01-01 00:00:00'), (16, 'Porkbun', 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 1, 1, 1, 'When retrieving your list of domains from Porkbun, the current limit is 1,000 domains. If you have more than this you should export the full list of domains from Porkbun and paste it into the <strong>Domains to add</strong> field when adding domains via the Domain Queue.', '[[regtime]]', '1970-01-01 00:00:00'), (17, 'ResellerClub', 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 1, 1, 0, 'ResellerClub does not allow users to retrieve a list of their domains via the API, nor do they return the Auto Renewal status when retrieving the details of a domain. All domains imported via the API will have their Auto Renewal status set to No by default.', '[[regtime]]', '1970-01-01 00:00:00'), (18, 'Cloudflare', 1, 0, 1, 0, 0, 1, 0, 0, 1, 1, 1, 1, 1, '', '[[regtime]]', '1970-01-01 00:00:00');
CREATE TABLE `scheduler` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `slug` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `description` longtext COLLATE utf8_unicode_ci NOT NULL, `interval` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Daily', `expression` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0 7 * * *', `last_run` datetime NOT NULL DEFAULT '1970-01-01 00:00:00', `last_duration` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `next_run` datetime NOT NULL DEFAULT '1970-01-01 00:00:00', `sort_order` int(4) NOT NULL DEFAULT '1', `is_running` tinyint(1) NOT NULL DEFAULT '0', `active` tinyint(1) NOT NULL DEFAULT '1', `insert_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00', `update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;
-- -- Dumping data for table `scheduler` --
INSERT INTO `scheduler` VALUES (1, 'Domain Queue Processing', 'domain-queue', 'Retrieves information for domains in the queue and adds them to DomainMOD.', 'Every 5 Minutes', '*/5 * * * *', '1970-01-01 00:00:00', '', '[[regtime]]', 10, 0, 1, '[[regtime]]', '1970-01-01 00:00:00'), (2, 'Send Expiration Email', 'expiration-email', 'Sends an email out to everyone who''s subscribed, letting them know of upcoming Domain & SSL Certificate expirations.<BR><BR>Users can subscribe via their User Profile.<BR><BR>Administrators can set the FROM email address and the number of days in the future to display in the email via System Settings.', 'Daily', '0 0 * * *', '1970-01-01 00:00:00', '', '[[next_run]] 07:00:00', 20, 0, 1, '[[regtime]]', '1970-01-01 00:00:00'), (3, 'Update Conversion Rates', 'update-conversion-rates', 'Retrieves the current currency conversion rates and updates the entire system, which keeps all of the financial information in DomainMOD accurate and up-to-date.<BR><BR>Users can set their default currency via their User Profile.', 'Daily', '0 0 * * *', '1970-01-01 00:00:00', '', '[[next_run]] 07:00:00', 40, 0, 1, '[[regtime]]', '1970-01-01 00:00:00'), (4, 'System Cleanup', 'cleanup', '<em>Domains:</em> Converts all domain entries to lowercase.<BR><BR> <em>TLDs:</em> Updates all TLD entries in the database to ensure their accuracy.<BR><BR> <em>Segments:</em> Compares the Segment data to the domain database and records the status of each domain. This keeps the Segment filtering data up-to-date and running smoothly.<BR><BR><em>Fees:</em> Cross-references the Domain, SSL Certificate, and fee tables, making sure that everything is accurate. It also deletes all unused fees.', 'Daily', '0 0 * * *', '1970-01-01 00:00:00', '', '[[next_run]] 07:00:00', 60, 0, 1, '[[regtime]]', '1970-01-01 00:00:00'), (5, 'Check For New Version', 'check-new-version', 'Checks to see if there is a newer version of DomainMOD available to download.', 'Daily', '0 0 * * *', '1970-01-01 00:00:00', '', '[[next_run]] 07:00:00', 80, 0, 1, '[[regtime]]', '1970-01-01 00:00:00'), (6, 'Data Warehouse Build', 'data-warehouse-build', 'Rebuilds the Data Warehouse so that you have the most up-to-date information available.', 'Daily', '0 0 * * *', '1970-01-01 00:00:00', '', '[[next_run]] 07:00:00', 100, 0, 1, '[[regtime]]', '1970-01-01 00:00:00');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;