IP : 3.147.103.73Hostname : 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/
whmcs/
../
joomla4/
../
cscart/
./
../
vtiger72/
../
subrion/
subrion.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 `[[dbprefix]]email_templates` --
CREATE TABLE `[[dbprefix]]email_templates` ( `name` varchar(60) NOT NULL, `active` tinyint(1) unsigned NOT NULL DEFAULT '1', `divider` tinyint(1) unsigned NOT NULL DEFAULT '0', `order` smallint(5) unsigned NOT NULL, `module` varchar(40) NOT NULL, `variables` varchar(300) NOT NULL, `subject_en` varchar(255) NOT NULL, `body_en` text NOT NULL, PRIMARY KEY (`name`), KEY `ACTIVE` (`active`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
-- -- Dumping data for table `[[dbprefix]]email_templates` --
INSERT INTO `[[dbprefix]]email_templates` VALUES ('member_templates', 1, 1, 10, '', '', '', ''), ('member_approved', 1, 0, 20, '', 'fullname|User', 'Member was approved at {$siteName}', '<p>Dear {$fullname},</p>\r\n<p>Your membership was approved in {$siteName}. Now you can log in.</p>'), ('member_disapproved', 1, 0, 30, '', 'fullname|User', 'Member was disapproved at {$siteName}', '<p>Dear {$fullname},</p>\r\n<p>Your membership was disapproved in {$siteName}.</p>'), ('member_registration', 1, 0, 40, '', 'fullname|User,email|Email,username|Username,password|Password,link|Confirmation link', 'Thanks for registration at {$siteName}', '<p>Dear {$fullname},</p> <p>Thanks for your registration at <a href="{$siteUrl}" target="_blank">{$siteUrl}</a>. Here is information you should use in order to login:</p> <p>Your username: {$username}<br /> Your password: {$password}</p> <p>To activate your account, please, <a href="{$link}" target="_blank">follow this link</a>. <br /> You may change your password later by editing your personal attributes in your member area.</p>'), ('member_registration_social', 1, 0, 50, '', 'fullname|User,email|Email,username|Username,password|Password,link|Confirmation link,provider|Social provider used to register', 'Thanks for registration at {$siteName}', '<p>Dear {$fullname},</p> <p>Thanks for your registration at <a href="{$siteUrl}" target="_blank">{$siteUrl}</a> via {$provider}. Here is information you should use in order to login:</p> <p>Your email: {$email}</p> <p>You may change your password later by editing your personal attributes in your member area.</p>'), ('member_registration_notification', 1, 0, 60, '', 'fullname|User,email|Email,password|Password', 'Member has been created {$siteName}', '<p>Greetings {$fullname},</p> <p>Administrator has just created an account for you at {$siteUrl}. Here is information you should use in order to login:</p> <p>Your email: <b>{$email}</b><br /> Your password: <b>{$password}</b></p>'), ('member_registration_admin', 1, 0, 70, '', 'id|ID,fullname|User,username|Username,email|User email', 'New member registered at {$siteName}', '<p>Greetings,</p><p>New member registered at {$siteUrl}. Detailed information is below:</p> <p>ID: <b>{$id}</b><br>Name: <b>{$fullname}</b> ({$username})<br>Email: <b>{$email}</b></p>'), ('member_removal', 1, 0, 80, '', 'fullname|User', 'Member deleted at {$siteName}', '<p>Dear {$fullname},</p>\r\n<p>Your membership was removed from {$siteUrl}.</p>'), ('password_restoration', 1, 0, 90, '', 'fullname|User,email|Email,code|Restoration code', 'Password restoration request at {$siteName}', '<p>Dear {$fullname},</p>\r\n<p>Please follow this link if you wish to change the password at {$siteName}:<br />\r\n<a href="{$url}">{$url}</a>\r\n</p>\r\n<p>\r\nOr use confirmation code on page: <a href="{$siteUrl}forgot/?code">{$siteUrl}forgot/?code</a><br />\r\nE-mail: {$email}<br />\r\nCode: {$code}\r\n</p>'), ('password_changement', 1, 0, 100, '', 'fullname|User,username|Username,password|New password', 'Password change request at {$siteName}', '<p>Dear {$fullname},</p>\r\n\r\n<p>You requested a password change in {$siteName}. Now you should use the following credentials to log in as member:</p>\r\n\r\n<p>Username: {$username}<br />\r\nPassword: {$password}</p>'), ('financial_templates', 1, 1, 110, '', '', '', ''), ('plan_activated', 1, 0, 120, '', 'plan|Plan name,cost|Plan''s cost,duration|Plan''s duration,unit|Duration unit,fullname|User,currency|Currency code', 'Plan activated at {$siteName}', '<p>Dear {$fullname},</p>\r\n<p>Your listing has been activated.</p>\r\n\r\n<ul>\r\n <li><b>Plan:</b> {$plan}</li>\r\n <li><b>Cost:</b> {$currency} {$cost}</li>\r\n <li><b>Duration:</b> {$duration} {$unit}(s)</li>\r\n</ul>'), ('plan_expired', 1, 0, 130, '', 'plan|Plan name,cost|Plan''s cost,duration|Plan''s duration,unit|Duration unit,fullname|User,currency|Currency code', 'Plan expired at {$siteName}', '<p>Dear {$fullname},</p>\r\n<p>Your paid listing submission expired.</p>\r\n\r\n<ul>\r\n <li><b>Plan:</b> {$plan}</li>\r\n <li><b>Cost:</b> {$currency} {$cost}</li>\r\n <li><b>Duration:</b> {$duration} {$unit}(s)</li>\r\n</ul>\r\n\r\n<p>It may always be renewed through the site.</p>'), ('transaction_paid', 1, 0, 140, '', 'email|Email,username|Username,fullname|Fullname,operation|Operation name,amount|Amount,reference_id|Reference ID,currency|Currency,item|Item,item_id|Item ID,date_created|Creation Date,date_paid|Payment Date', 'Payment received at {$siteName}', '<p>Dear {$fullname},</p>\r\n<p>Your payment has been successfully received.</p>\r\n\r\n<p>Order Number: <strong>{$reference_id}</strong></p>\r\n\r\n<p>Payment details are below:</p>\r\n\r\n<ul>\r\n <li><b>Operation:</b> {$operation}</li>\r\n <li><b>Amount:</b> {$currency} {$amount}</li>\r\n <li><b>Item:</b> {$item} #{$item_id}</li>\r\n <li><b>Date:</b> {$date_paid}</li>\r\n</ul>\r\n\r\n<p>All your transactions could always be seen on the <a href="{$siteUrl}profile/funds/" target="_blank">Funds</a> page.</p>'), ('transaction_paid_admin', 1, 0, 150, '', 'username|User,amount|Amount of transaction,operation|Operation name,currency|Currency', 'Payment completed at {$siteName}', '<p>Dear Administrator,</p>\r\n<p>A payment has been completed on your site. Here is the information on the payment:</p><ul><li><b>Username:</b> {$username}</li><li><b>Amount:</b>{$currency} {$amount}</li><li><b>Operation:</b> {$operation}</li></ul>'), ('invoice_created', 1, 0, 160, '', 'invoice|Invoice ID,gateway|Gateway,date|Invoice creation date,fullname|User,amount|Amount,currency|Currency', 'Customer Invoice', '<p>Dear {$fullname},</p>\r\n<p>This is a notice that an invoice has been generated on {$date}</p>\r\n\r\n<p>Your payment method is: {$gateway}</p>\r\n\r\n<p>Invoice #{$invoice},<br>\r\nAmount Due: {$currency} {$amount}\r\n</p>\r\n\r\n<p>All your invoices could always be seen on the <a href="{$siteUrl}profile/funds/" target="_blank">Funds</a> page.</p>');
-- -- Table structure for table `[[dbprefix]]payment_plans` --
CREATE TABLE `[[dbprefix]]payment_plans` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `cost` decimal(10,2) unsigned NOT NULL, `item` varchar(50) DEFAULT NULL, `data` text, `duration` int(10) unsigned NOT NULL COMMENT 'Duration of cycle in units', `unit` enum('hour','day','week','month','year') DEFAULT NULL COMMENT 'Unit of measure', `order` tinyint(3) unsigned NOT NULL, `status` enum('inactive','active') NOT NULL DEFAULT 'inactive', `email` varchar(128) NOT NULL, `usergroup` smallint(5) unsigned NOT NULL, `recurring` tinyint(1) unsigned NOT NULL COMMENT 'Is this plan recurring?', `cycles` smallint(5) NOT NULL DEFAULT '0' COMMENT 'Number of recurring cycles', `expiration_status` varchar(15) NOT NULL COMMENT 'Status which will be applied on plan expiration', `type` enum('fee','subscription') NOT NULL DEFAULT 'subscription', `listings_limit` int(7) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- -- Table structure for table `[[dbprefix]]views_log` --
CREATE TABLE `[[dbprefix]]views_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `item` char(16) NOT NULL, `item_id` int(11) unsigned NOT NULL, `ip` bigint(12) NOT NULL, `date` date NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQUE` (`item`,`item_id`,`ip`,`date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- -- Triggers `[[dbprefix]]members` -- DROP TRIGGER IF EXISTS `del_hybridauth_data`; DELIMITER // CREATE TRIGGER `del_hybridauth_data` AFTER DELETE ON `[[dbprefix]]members` FOR EACH ROW DELETE FROM `[[dbprefix]]members_auth_providers` WHERE `[[dbprefix]]members_auth_providers`.`member_id` = OLD.`id` // DELIMITER ; /*!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 */;