ALTER TABLE `admins` ADD `remember_token` VARCHAR(255) NULL DEFAULT NULL AFTER `password`; ALTER TABLE `admin_password_resets` DROP COLUMN `updated_at`; ALTER TABLE `advertisements` CHANGE `crypto_id` `crypto_currency_id` INT(10) UNSIGNED NOT NULL; ALTER TABLE `advertisements` CHANGE `fiat_id` `fiat_currency_id` INT(10) UNSIGNED NOT NULL; ALTER TABLE `advertisements` ADD `fixed_price` DECIMAL(28,8) NOT NULL DEFAULT '0' AFTER `margin`; ALTER TABLE `advertisements` ADD `completed_trade` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `status`, ADD `total_min` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `completed_trade`; RENAME TABLE `limits` TO `ad_limits`; ALTER TABLE `chats` CHANGE `trade_request_id` `trade_id` INT(10) UNSIGNED NOT NULL; -- -- Table structure for table `commission_logs` -- CREATE TABLE `commission_logs` ( `id` bigint(20) UNSIGNED NOT NULL, `from_id` int(10) UNSIGNED DEFAULT NULL, `to_id` int(10) UNSIGNED DEFAULT NULL, `crypto_currency_id` int(10) UNSIGNED NOT NULL, `level` int(10) UNSIGNED DEFAULT NULL, `commission_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000, `post_balance` decimal(28,8) DEFAULT 0.00000000, `trx_amo` decimal(28,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Transacted Amount', `percent` decimal(11,2) NOT NULL DEFAULT 0.00, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `trx` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `commission_logs` -- ALTER TABLE `commission_logs` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `commission_logs` -- ALTER TABLE `commission_logs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; RENAME TABLE `cryptos` TO `crypto_currencies`; ALTER TABLE `crypto_currencies` CHANGE `dc_fixed` `deposit_charge_fixed` DECIMAL(28,8) NOT NULL; ALTER TABLE `crypto_currencies` CHANGE `dc_percent` `deposit_charge_percent` DECIMAL(5,2) NOT NULL; ALTER TABLE `crypto_currencies` CHANGE `wc_fixed` `withdraw_charge_fixed` DECIMAL(28,8) NOT NULL; ALTER TABLE `crypto_currencies` CHANGE `wc_percent` `withdraw_charge_percent` DECIMAL(5,2) NOT NULL; ALTER TABLE `crypto_currencies` CHANGE `image` `image` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL; RENAME TABLE `wallet_cryptos` TO `crypto_wallets`; ALTER TABLE `crypto_wallets` CHANGE `crypto_id` `crypto_currency_id` INT(10) UNSIGNED NOT NULL; ALTER TABLE `deposits` CHANGE `crypto_id` `crypto_currency_id` INT(10) UNSIGNED NOT NULL; -- -- Table structure for table `device_tokens` -- CREATE TABLE `device_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `token` text COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int(10) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `device_tokens` -- ALTER TABLE `device_tokens` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `device_tokens` -- ALTER TABLE `device_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; RENAME TABLE `email_logs` TO `notification_logs`; RENAME TABLE `email_sms_templates` TO `notification_templates`; RENAME TABLE `fiats` TO `fiat_currencies`; ALTER TABLE `fiat_currencies` CHANGE `code` `code` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL; ALTER TABLE `fiat_currencies` CHANGE `symbol` `symbol` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL; ALTER TABLE `fiat_gateways` CHANGE `slug` `slug` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL; ALTER TABLE `fiat_gateways` ADD `image` VARCHAR(255) NULL DEFAULT NULL AFTER `code`; -- -- Table structure for table `forms` -- CREATE TABLE `forms` ( `id` bigint(20) UNSIGNED NOT NULL, `act` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `form_data` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `forms` -- INSERT INTO `forms` (`id`, `act`, `form_data`, `created_at`, `updated_at`) VALUES (7, 'kyc', '[]', '2022-03-17 02:56:14', '2022-09-17 10:32:36'); -- -- Indexes for dumped tables -- -- -- Indexes for table `forms` -- ALTER TABLE `forms` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `forms` -- ALTER TABLE `forms` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; TRUNCATE TABLE frontends; -- -- Dumping data for table `frontends` -- INSERT INTO `frontends` (`id`, `data_keys`, `data_values`, `created_at`, `updated_at`) VALUES (1, 'seo.data', '{\"seo_image\":\"1\",\"keywords\":[\"admin\",\"blog\",\"aaaa\",\"ddd\",\"aaa\"],\"description\":\"Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit\",\"social_title\":\"Viserlab Limited\",\"social_description\":\"Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit ff\",\"image\":\"5fa397a629bee1604556710.jpg\"}', '2020-07-04 23:42:52', '2021-01-03 07:43:02'), (41, 'cookie.data', '{\"short_desc\":\"We may use cookies or any other tracking technologies when you visit our website, including any other media form, mobile website, or mobile application related or connected to help customize the Site and improve your experience.\",\"description\":\"

What information do we collect?<\\/h3>

We gather data from you when you register on our site, submit a request, buy any services, react to an overview, or round out a structure. At the point when requesting any assistance or enrolling on our site, as suitable, you might be approached to enter your: name, email address, or telephone number. You may, nonetheless, visit our site anonymously.<\\/p><\\/div>

How do we protect your information?<\\/h3>

All provided delicate\\/credit data is sent through Stripe.
After an exchange, your private data (credit cards, social security numbers, financials, and so on) won\'t be put away on our workers.<\\/p><\\/div>

Do we disclose any information to outside parties?<\\/h3>

We don\'t sell, exchange, or in any case move to outside gatherings by and by recognizable data. This does exclude confided in outsiders who help us in working our site, leading our business, or adjusting you, since those gatherings consent to keep this data private. We may likewise deliver your data when we accept discharge is suitable to follow the law, implement our site strategies, or ensure our own or others\' rights, property, or wellbeing.<\\/p><\\/div>

Children\'s Online Privacy Protection Act Compliance<\\/h3>

We are consistent with the prerequisites of COPPA (Children\'s Online Privacy Protection Act), we don\'t gather any data from anybody under 13 years old. Our site, items, and administrations are completely coordinated to individuals who are in any event 13 years of age or more established.<\\/p><\\/div>

Changes to our Privacy Policy<\\/h3>

If we decide to change our privacy policy, we will post those changes on this page.<\\/p><\\/div>

How long we retain your information?<\\/h3>

At the point when you register for our site, we cycle and keep your information we have about you however long you don\'t erase the record or withdraw yourself (subject to laws and guidelines).<\\/p><\\/div>

What we don\\u2019t do with your data<\\/h3>

We don\'t and will never share, unveil, sell, or in any case give your information to different organizations for the promoting of their items or administrations.<\\/p><\\/div>\",\"status\":1}', '2020-07-04 23:42:52', '2022-03-30 11:23:12'), (42, 'policy_pages.element', '{\"title\":\"Privacy Policy\",\"details\":\"

What information do we collect?<\\/h3>

We gather data from you when you register on our site, submit a request, buy any services, react to an overview, or round out a structure. At the point when requesting any assistance or enrolling on our site, as suitable, you might be approached to enter your: name, email address, or telephone number. You may, nonetheless, visit our site anonymously.<\\/p><\\/div>

How do we protect your information?<\\/h3>

All provided delicate\\/credit data is sent through Stripe.
After an exchange, your private data (credit cards, social security numbers, financials, and so on) won\'t be put away on our workers.<\\/p><\\/div>

Do we disclose any information to outside parties?<\\/h3>

We don\'t sell, exchange, or in any case move to outside gatherings by and by recognizable data. This does exclude confided in outsiders who help us in working our site, leading our business, or adjusting you, since those gatherings consent to keep this data private. We may likewise deliver your data when we accept discharge is suitable to follow the law, implement our site strategies, or ensure our own or others\' rights, property, or wellbeing.<\\/p><\\/div>

Children\'s Online Privacy Protection Act Compliance<\\/h3>

We are consistent with the prerequisites of COPPA (Children\'s Online Privacy Protection Act), we don\'t gather any data from anybody under 13 years old. Our site, items, and administrations are completely coordinated to individuals who are in any event 13 years of age or more established.<\\/p><\\/div>

Changes to our Privacy Policy<\\/h3>

If we decide to change our privacy policy, we will post those changes on this page.<\\/p><\\/div>

How long we retain your information?<\\/h3>

At the point when you register for our site, we cycle and keep your information we have about you however long you don\'t erase the record or withdraw yourself (subject to laws and guidelines).<\\/p><\\/div>

What we don\\u2019t do with your data<\\/h3>

We don\'t and will never share, unveil, sell, or in any case give your information to different organizations for the promoting of their items or administrations.<\\/p><\\/div>\"}', '2021-06-09 08:50:42', '2021-06-09 08:50:42'), (43, 'policy_pages.element', '{\"title\":\"Terms of Service\",\"details\":\"

We claim all authority to dismiss, end, or handicap any help with or without cause per administrator discretion. This is a Complete independent facilitating, on the off chance that you misuse our ticket or Livechat or emotionally supportive network by submitting solicitations or protests we will impair your record. The solitary time you should reach us about the seaward facilitating is if there is an issue with the worker. We have not many substance limitations and everything is as per laws and guidelines. Try not to join on the off chance that you intend to do anything contrary to the guidelines, we do check these things and we will know, don\'t burn through our own and your time by joining on the off chance that you figure you will have the option to sneak by us and break the terms.<\\/p><\\/div>

  • Configuration requests - If you have a fully managed dedicated server with us then we offer custom PHP\\/MySQL configurations, firewalls for dedicated IPs, DNS, and httpd configurations.<\\/li>
  • Software requests - Cpanel Extension Installation will be granted as long as it does not interfere with the security, stability, and performance of other users on the server.<\\/li>
  • Emergency Support - We do not provide emergency support \\/ Phone Support \\/ LiveChat Support. Support may take some hours sometimes.<\\/li>
  • Webmaster help - We do not offer any support for webmaster related issues and difficulty including coding, & installs, Error solving. if there is an issue where a library or configuration of the server then we can help you if it\'s possible from our end.<\\/li>
  • Backups - We keep backups but we are not responsible for data loss, you are fully responsible for all backups.<\\/li>
  • We Don\'t support any child porn or such material.<\\/li>
  • No spam-related sites or material, such as email lists, mass mail programs, and scripts, etc.<\\/li>
  • No harassing material that may cause people to retaliate against you.<\\/li>
  • No phishing pages.<\\/li>
  • You may not run any exploitation script from the server. reason can be terminated immediately.<\\/li>
  • If Anyone attempting to hack or exploit the server by using your script or hosting, we will terminate your account to keep safe other users.<\\/li>
  • Malicious Botnets are strictly forbidden.<\\/li>
  • Spam, mass mailing, or email marketing in any way are strictly forbidden here.<\\/li>
  • Malicious hacking materials, trojans, viruses, & malicious bots running or for download are forbidden.<\\/li>
  • Resource and cronjob abuse is forbidden and will result in suspension or termination.<\\/li>
  • Php\\/CGI proxies are strictly forbidden.<\\/li>
  • CGI-IRC is strictly forbidden.<\\/li>
  • No fake or disposal mailers, mass mailing, mail bombers, SMS bombers, etc.<\\/li>
  • NO CREDIT OR REFUND will be granted for interruptions of service, due to User Agreement violations.<\\/li><\\/ul><\\/div>

    Terms & Conditions for Users<\\/h3>

    Before getting to this site, you are consenting to be limited by these site Terms and Conditions of Use, every single appropriate law, and guidelines, and concur that you are answerable for consistency with any material neighborhood laws. If you disagree with any of these terms, you are restricted from utilizing or getting to this site.<\\/p><\\/div>

    Support<\\/h3>

    Whenever you have downloaded our item, you may get in touch with us for help through email and we will give a valiant effort to determine your issue. We will attempt to answer using the Email for more modest bug fixes, after which we will refresh the center bundle. Content help is offered to confirmed clients by Tickets as it were. Backing demands made by email and Livechat.<\\/p>

    On the off chance that your help requires extra adjustment of the System, at that point, you have two alternatives:<\\/p>

    • Hang tight for additional update discharge.<\\/li>
    • Or on the other hand, enlist a specialist (We offer customization for extra charges).<\\/li><\\/ul><\\/div>

      Ownership<\\/h3>

      You may not guarantee scholarly or selective possession of any of our items, altered or unmodified. All items are property, we created them. Our items are given \\\"with no guarantees\\\" without guarantee of any sort, either communicated or suggested. On no occasion will our juridical individual be subject to any harms including, however not restricted to, immediate, roundabout, extraordinary, accidental, or significant harms or different misfortunes emerging out of the utilization of or powerlessness to utilize our items.<\\/p><\\/div>

      Warranty<\\/h3>

      We don\'t offer any guarantee or assurance of these Services in any way. When our Services have been modified we can\'t ensure they will work with all outsider plugins, modules, or internet browsers. Program similarity ought to be tried against the show formats on the demo worker. If you don\'t mind guarantee that the programs you use will work with the component, as we can not ensure that our systems will work with all program mixes.<\\/p><\\/div>

      Unauthorized\\/Illegal Usage<\\/h3>

      You may not utilize our things for any illicit or unapproved reason or may you, in the utilization of the stage, disregard any laws in your locale (counting yet not restricted to copyright laws) just as the laws of your nation and International law. Specifically, it is disallowed to utilize the things on our foundation for pages that advance: brutality, illegal intimidation, hard sexual entertainment, bigotry, obscenity content or warez programming joins.

      You can\'t imitate, copy, duplicate, sell, exchange or adventure any of our segment, utilization of the offered on our things, or admittance to the administration without the express composed consent by us or item proprietor.

      Our Members are liable for all substance posted on the discussion and demo and movement that happens under your record.

      We hold the chance of hindering your participation account quickly if we will think about a particularly not allowed conduct.

      If you make a record on our site, you are liable for keeping up the security of your record, and you are completely answerable for all exercises that happen under the record and some other activities taken regarding the record. You should quickly inform us, of any unapproved employments of your record or some other penetrates of security.<\\/p><\\/div>

      Fiverr, Seoclerks Sellers Or Affiliates<\\/h3>

      We do NOT ensure full SEO campaign conveyance within 24 hours. We make no assurance for conveyance time by any means. We give our best assessment to orders during the putting in of requests, anyway, these are gauges. We won\'t be considered liable for loss of assets, negative surveys or you being prohibited for late conveyance. If you are selling on a site that requires time touchy outcomes, utilize Our SEO Services at your own risk.<\\/p><\\/div>

      Payment\\/Refund Policy<\\/h3>

      No refund or cash back will be made. After a deposit has been finished, it is extremely unlikely to invert it. You should utilize your equilibrium on requests our administrations, Hosting, SEO campaign. You concur that once you complete a deposit, you won\'t document a debate or a chargeback against us in any way, shape, or form.

      If you document a debate or chargeback against us after a deposit, we claim all authority to end every single future request, prohibit you from our site. False action, for example, utilizing unapproved or taken charge cards will prompt the end of your record. There are no special cases.<\\/p><\\/div>

      Free Balance \\/ Coupon Policy<\\/h3>

      We offer numerous approaches to get FREE Balance, Coupons and Deposit offers yet we generally reserve the privilege to audit it and deduct it from your record offset with any explanation we may it is a sort of misuse. If we choose to deduct a few or all of free Balance from your record balance, and your record balance becomes negative, at that point the record will naturally be suspended. If your record is suspended because of a negative Balance you can request to make a custom payment to settle your equilibrium to actuate your record.<\\/p><\\/div>\"}', '2021-06-09 08:51:18', '2021-06-09 08:51:18'), (44, 'maintenance.data', '{\"description\":\"

      What information do we collect?<\\/h3>

      We gather data from you when you register on our site, submit a request, buy any services, react to an overview, or round out a structure. At the point when requesting any assistance or enrolling on our site, as suitable, you might be approached to enter your: name, email address, or telephone number. You may, nonetheless, visit our site anonymously.<\\/p><\\/div>\"}', '2020-07-04 23:42:52', '2022-05-11 03:57:17'), (45, 'footer.content', '{\"has_image\":\"1\",\"footer_text\":\"Lorem ipsum dolor sit amet consectet adipisicing elit. Dignissimos, dolore. Sit amet consectet adipisicing elit\",\"image\":\"62b1a078224bf1655808120.jpg\"}', '2022-06-21 09:12:00', '2022-09-08 12:20:33'), (46, 'breadcrumb.content', '{\"has_image\":\"1\",\"image\":\"62b1a27b85b171655808635.jpg\"}', '2022-06-21 09:20:35', '2022-06-21 09:20:35'), (47, 'social_icon.element', '{\"title\":\"Instagram\",\"social_icon\":\"<\\/i>\",\"url\":\"https:\\/\\/instagram.com\"}', '2022-06-21 09:30:19', '2022-06-21 09:30:19'), (48, 'social_icon.element', '{\"title\":\"Linkedin\",\"social_icon\":\"<\\/i>\",\"url\":\"https:\\/\\/www.linkedin.com\\/\"}', '2022-06-21 09:30:44', '2022-06-21 09:30:44'), (49, 'social_icon.element', '{\"title\":\"Twitter\",\"social_icon\":\"<\\/i>\",\"url\":\"https:\\/\\/twitter.com\\/\"}', '2022-06-21 09:31:09', '2022-06-21 09:31:09'), (50, 'social_icon.element', '{\"title\":\"Facebook\",\"social_icon\":\"<\\/i>\",\"url\":\"https:\\/\\/www.facebook.com\\/\"}', '2022-06-21 09:31:39', '2022-06-21 09:31:40'), (51, 'login.content', '{\"has_image\":\"1\",\"heading\":\"Welcome Back!!\",\"sub_heading\":\"Login with Bitcoinvio helps you with trade bitcoin more easy and secure way throughout the world.\",\"image\":\"62b1aac1f09ce1655810753.jpg\"}', '2022-06-21 09:55:53', '2022-06-21 09:55:54'), (52, 'registration.content', '{\"has_image\":\"1\",\"heading\":\"Registration\",\"sub_heading\":\"Get Started Trade With Us. We hope for your happy trading!\",\"image\":\"62b1aae59c3cc1655810789.jpg\"}', '2022-06-21 09:56:29', '2022-06-21 09:56:29'), (54, 'advertisement.content', '{\"i_want_to\":\"What kind of advertisement do you wish to create? If you wish to sell bitcoins make sure you have bitcoins in your wallet.\",\"crypto_currency\":\"Which cryptocurrency do you wish to buy or sell?\",\"fiat_payment_method\":\"Which payment method will be used to pay the fiat currency?\",\"currency\":\"Which fiat currency needs exchange from cryptocurrency?\",\"price_type\":\"Select a type margin or fixed.\",\"margin\":\"The margin you want over the bitcoin market price. Use a negative value for buying or selling under the market price to attract more contacts. For more complex pricing edit the price equation directly.\",\"fixed_price\":\"If you want to sell or buy your coins in fixed price then use this.\",\"payment_window\":\"For Buyer: Within how many minutes do you promise to initiate the payment. For Seller: Within how many minutes you want to get paid.\",\"minimum_limit\":\"Minimum transaction limit in one trade.\",\"maximum_limit\":\"Maximum transaction limit in one trade.\",\"price_equation\":\"Maximum transaction limit in one trade.\",\"payment_details\":\"If necessary, please provide details on how to transfer money.\",\"terms_of_trades\":\"Provide the terms of trades for this advertisement.\"}', '2022-06-23 08:34:30', '2022-06-23 08:34:30'), (55, 'banner.content', '{\"has_image\":\"1\",\"heading\":\"Exchange your cryptocurrencies\",\"subheading\":\"LocalCoins is a p2p crypto exchange marketplace where people can trade crypto directly with each other.\",\"form_header\":\"Find Your Offers\",\"form_button_text\":\"Find Offers\",\"image\":\"62b6a521160da1656136993.jpg\",\"form_bg\":\"62b6a521903841656136993.png\"}', '2022-06-25 04:33:13', '2022-09-10 09:50:29'), (56, 'overview.element', '{\"details\":\"24\\/7 Support\",\"icon\":\"<\\/i>\"}', '2022-06-25 04:52:11', '2022-06-25 04:52:11'), (57, 'overview.element', '{\"details\":\"100% Secured\",\"icon\":\"<\\/i>\"}', '2022-06-25 04:52:24', '2022-06-25 04:52:24'), (58, 'overview.element', '{\"details\":\"Millions Happy Users\",\"icon\":\"<\\/i>\"}', '2022-06-25 04:52:43', '2022-06-25 04:52:43'), (59, 'overview.element', '{\"details\":\"Best Currency Exchange Platform\",\"icon\":\"<\\/i>\"}', '2022-06-25 04:53:00', '2022-06-25 04:53:00'), (60, 'buy.content', '{\"has_image\":\"1\",\"heading\":\"Buy Crypto Currencies\",\"sub_heading\":\"With a proven track record and a mature approach to the industry, we provide a reliable buying platform for cryptocurrencies.\",\"image\":\"62b6aaec00f131656138476.jpg\"}', '2022-06-25 04:57:55', '2022-06-25 04:57:56'), (61, 'sell.content', '{\"heading\":\"Sell Crypto Currency\",\"sub_heading\":\"With a proven track record and a mature approach to the industry, we provide a reliable selling platform for cryptocurrency.\"}', '2022-06-25 04:58:22', '2022-06-25 04:58:22'), (62, 'choose_us.content', '{\"has_image\":\"1\",\"heading\":\"Why People Choose Us\",\"sub_heading\":\"Earning the trust of our clients has always been our highest priority. We earn that trust through the best security in the business. Our platform provides world-class financial stability and the highest standards of legal compliance.\",\"image\":\"62b6ab3a55c691656138554.jpg\"}', '2022-06-25 04:59:14', '2022-06-25 04:59:14'), (63, 'choose_us.element', '{\"has_image\":\"1\",\"heading\":\"Easy Access\",\"details\":\"It\'s a most reliable site and easy to access. We maintain a very simple login process and easy configuration for all the users.\",\"image\":\"62b6ab4f5ed201656138575.png\"}', '2022-06-25 04:59:35', '2022-06-25 04:59:35'), (64, 'choose_us.element', '{\"has_image\":\"1\",\"heading\":\"Buy Bitcoin Online\",\"details\":\"The buying process is so simple with this site. Just log in to the account and buy any of the bitcoin package based on demand.\",\"image\":\"62b6aba84854d1656138664.png\"}', '2022-06-25 05:01:04', '2022-06-25 05:01:04'), (65, 'choose_us.element', '{\"has_image\":\"1\",\"heading\":\"Sell Bitcoin online\",\"details\":\"The selling process is also simple! Sell your Bitcoin at your chosen rate, and get paid in one of the numerous payment methods.\",\"image\":\"62b6abbdd734e1656138685.png\"}', '2022-06-25 05:01:25', '2022-06-25 05:01:25'), (66, 'choose_us.element', '{\"has_image\":\"1\",\"heading\":\"Earn extra income\",\"details\":\"Buy and Sell your Bitcoin at your chosen rate and it is a great opportunity for all the uses to get more profit from this site.\",\"image\":\"62b6abe6245c91656138726.png\"}', '2022-06-25 05:02:06', '2022-06-25 05:02:06'), (67, 'choose_us.element', '{\"has_image\":\"1\",\"heading\":\"High reliability\",\"details\":\"We are trusted by a huge number of people. We are working hard constantly to improve the level of our security system and minimize possible risks.\",\"image\":\"62b6abf67c9fb1656138742.png\"}', '2022-06-25 05:02:22', '2022-06-25 05:02:22'), (68, 'choose_us.element', '{\"has_image\":\"1\",\"heading\":\"Legal Company\",\"details\":\"Our company conducts absolutely legal activities. We are certified to operate this business, we are legal and safe.\",\"image\":\"62b6ac0a5f1451656138762.png\"}', '2022-06-25 05:02:42', '2022-06-25 05:02:42'), (69, 'offer.content', '{\"has_image\":\"1\",\"heading\":\"Welcome to the peer-to-peer finance revolution!\",\"sub_heading\":\"Trade cryptocurrency globally. Multiple payment methods. Free bitcoin wallet. And much more right here!\",\"button_text\":\"Get Started\",\"button_url\":\"register\",\"image\":\"62b6ac8a2fccb1656138890.jpg\"}', '2022-06-25 05:04:50', '2022-06-25 05:04:50'), (71, 'faq.content', '{\"heading\":\"Frequently Asked Questions.\",\"sub_heading\":\"We answer some of your Frequently Asked Questions regarding our platform. If you have a query that is not answered here, Please contact us via mail.\"}', '2022-06-25 05:11:05', '2022-06-25 05:11:05'), (72, 'faq.element', '{\"question\":\"Can I make money with Bitcoin ?\",\"answer\":\"You should never expect to get rich with Bitcoin or any emerging technology. It is always important to be wary of anything that sounds too good to be true or disobeys basic economic rules.\"}', '2022-06-25 05:11:20', '2022-06-25 05:11:20'), (73, 'faq.element', '{\"question\":\"What is Bitcoin ?\",\"answer\":\"Bitcoin is a consensus network that enables a new payment system and completely digital money. It is the first decentralized peer-to-peer payment network that is powered by its users with no central authority or middlemen. From a user perspective, Bitcoin is pretty much like cash for the Internet. Bitcoin can also be seen as the most prominent triple entry bookkeeping system in existence.\"}', '2022-06-25 05:11:35', '2022-06-25 05:11:35'), (74, 'faq.element', '{\"question\":\"How to sell bitcoin ?\",\"answer\":\"It\\u2019s now easy to sell Bitcoin as a BITCCA vendor. You have the freedom to set your own rates, and also the luxury of over 20 payment options to get paid for the Bitcoin you sell. As BITCCA is a peer-to-peer marketplace, you can sell your Bitcoin directly to over 3 million users worldwide.\"}', '2022-06-25 05:11:51', '2022-06-25 05:11:51'), (75, 'faq.element', '{\"question\":\"How to buy bitcoin ?\",\"answer\":\"It\\u2019s now easy to buy Bitcoin as a BITCCA vendor. You have the freedom to choose your own rates. As BITCCA is a peer-to-peer marketplace, you can buy your Bitcoin directly from over 3 million users worldwide.\"}', '2022-06-25 05:12:17', '2022-06-25 05:12:17'), (76, 'faq.element', '{\"question\":\"What is online money exchanging ?\",\"answer\":\"An online currency exchange, or electronic forex exchange, is an internet-based platform that facilitates the exchange of currencies between countries. Like their physical counterparts, online currency exchanges make money by charging a nominal fee and\\/or through the bid-ask spread in a currency.\"}', '2022-06-25 05:12:32', '2022-06-25 05:12:32'), (77, 'testimonial.content', '{\"has_image\":\"1\",\"heading\":\"What Our Client Say About Us\",\"sub_heading\":\"We have done some awesome works and we always care for our clients, lets see what\'s their opinion about us.\",\"image\":\"62b6ae9f2458b1656139423.jpg\"}', '2022-06-25 05:13:42', '2022-06-25 05:13:43'), (78, 'testimonial.element', '{\"has_image\":[\"1\"],\"author_name\":\"Lucee\",\"quote\":\"This is best for crypto exchange among other features. This is best for crypto exchange among other features.\",\"image\":\"62b6aee9d81741656139497.jpg\"}', '2022-06-25 05:14:57', '2022-06-25 05:14:57'), (79, 'testimonial.element', '{\"has_image\":[\"1\"],\"author_name\":\"Clark\",\"quote\":\"The website provides a variety of related services. This is best for crypto exchange among other features.\",\"image\":\"62b6aefd0f7c21656139517.jpg\"}', '2022-06-25 05:15:17', '2022-06-25 05:15:17'), (80, 'testimonial.element', '{\"has_image\":[\"1\"],\"author_name\":\"Mr. Pop\",\"quote\":\"BITCCA is a company and website dedicated to the bitcoin cash and bitcoin selling platform. The website provides a variety of related services.\",\"image\":\"62b6af0fb231a1656139535.jpg\"}', '2022-06-25 05:15:35', '2022-06-25 05:15:35'), (81, 'testimonial.element', '{\"has_image\":[\"1\"],\"author_name\":\"Mark\",\"quote\":\"Localcoins is the best website for selling bitcoin and making cash. They provide authentic services. This is best for the crypto exchange platforms.\",\"image\":\"62b6af24201491656139556.jpg\"}', '2022-06-25 05:15:56', '2022-06-25 05:15:56'), (82, 'testimonial.element', '{\"has_image\":[\"1\"],\"author_name\":\"Danniel\",\"quote\":\"I do business here for a long time. They give fast service and I feel trusted here. This is best for crypto exchange among other features.\",\"image\":\"62b6af34efd031656139572.jpg\"}', '2022-06-25 05:16:12', '2022-06-25 05:16:13'), (83, 'testimonial.element', '{\"has_image\":[\"1\"],\"author_name\":\"Hopper\",\"quote\":\"The website provides a variety of related services. This is best for crypto exchange among other features. This is best site for all\",\"image\":\"62b6af463df2d1656139590.jpg\"}', '2022-06-25 05:16:30', '2022-06-25 05:16:30'), (84, 'contact.element', '{\"icon\":\"<\\/i>\",\"heading\":\"Email Address\",\"details\":\"support@demoemail.com\"}', '2022-06-28 04:42:27', '2022-06-28 04:42:27'), (85, 'contact.element', '{\"icon\":\"<\\/i>\",\"heading\":\"Phone Number\",\"details\":\"+0123 456789\"}', '2022-06-28 04:42:43', '2022-06-28 04:42:43'), (86, 'contact.element', '{\"icon\":\"<\\/i>\",\"heading\":\"Office Address\",\"details\":\"College Road, Uttar Horin Singha, Gaibandha-5700\"}', '2022-06-28 04:43:05', '2022-06-28 04:43:05'), (87, 'contact.content', '{\"latitude\":\"25.793449\",\"longitude\":\"-80.139198\"}', '2022-06-28 04:43:55', '2022-06-28 04:43:55'), (90, 'kyc.content', '{\"kyc_required\":\"KYC means Know Your Customer and sometimes Know Your Client. KYC check is the mandatory process of identifying and verifying your identity to use our platform. In other words, we must make sure that our clients are genuinely who they claim to be. We may refuse you to use our platform or halt a business relationship if you fail to meet minimum KYC requirements.\",\"kyc_pending\":\"KYC means Know Your Customer and sometimes Know Your Client. KYC check is the mandatory process of identifying and verifying your identity to use our platform. In other words, we must make sure that our clients are genuinely who they claim to be. Your submitted KYC verification data is pending. Wait for the system response.\"}', '2022-07-07 03:21:25', '2022-07-07 03:25:06'); ALTER TABLE `general_settings` ADD `trade_charge` DECIMAL(5,2) NOT NULL DEFAULT '0' AFTER `merchant_id`; ALTER TABLE `general_settings` CHANGE `sms_api` `sms_body` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `general_settings` ADD `sms_from` VARCHAR(255) NULL DEFAULT NULL AFTER `sms_body`; ALTER TABLE `general_settings` DROP COLUMN `secondary_color`; ALTER TABLE `general_settings` ADD `push_notification_config` TEXT NULL DEFAULT NULL AFTER `sms_config`, ADD `global_shortcodes` TEXT NULL DEFAULT NULL AFTER `push_notification_config`, ADD `kv` TINYINT(1) NOT NULL DEFAULT '0' AFTER `global_shortcodes`; ALTER TABLE `general_settings` ADD `pn` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'push notification, 0 - dont send, 1 - send' AFTER `sn`; ALTER TABLE `general_settings` ADD `maintenance_mode` TINYINT(1) NOT NULL DEFAULT '0' AFTER `force_ssl`; ALTER TABLE `general_settings` CHANGE `last_cron` `fiat_cron` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `general_settings` ADD `crypto_cron` TIMESTAMP NULL DEFAULT NULL AFTER `fiat_cron`, ADD `deposit_commission` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `crypto_cron`, ADD `trade_commission` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `deposit_commission`; ALTER TABLE `general_settings` CHANGE `sys_version` `system_info` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `general_settings` CHANGE `sitename` `site_name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; UPDATE `pages` SET `slug` = '/' WHERE `pages`.`id` = 1; ALTER TABLE `languages` DROP COLUMN `icon`; ALTER TABLE `notification_logs` CHANGE `mail_sender` `sender` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `notification_logs` CHANGE `email_from` `sent_from` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `notification_logs` CHANGE `email_to` `sent_to` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `notification_logs` ADD `notification_type` VARCHAR(40) NULL DEFAULT NULL AFTER `message`; UPDATE `notification_logs` SET `notification_type`='email'; ALTER TABLE `notification_templates` ADD `push_notification_body` TEXT NULL DEFAULT NULL AFTER `sms_body`; ALTER TABLE `notification_templates` ADD `push_notification_status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1' AFTER `sms_status`; ALTER TABLE `notification_templates` CHANGE `act` `act` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `notification_templates` CHANGE `name` `name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `notification_templates` CHANGE `subj` `subj` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `notification_templates` CHANGE `shortcodes` `shortcodes` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; RENAME TABLE `windows` TO `payment_windows`; DROP TABLE subscribers; -- -- Table structure for table `referrals` -- CREATE TABLE `referrals` ( `id` bigint(20) UNSIGNED NOT NULL, `commission_type` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL, `level` int(10) UNSIGNED NOT NULL, `percent` decimal(12,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `referrals` -- ALTER TABLE `referrals` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `referrals` -- ALTER TABLE `referrals` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Table structure for table `reviews` -- CREATE TABLE `reviews` ( `id` bigint(20) UNSIGNED NOT NULL, `advertisement_id` int(10) UNSIGNED NOT NULL, `trade_id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `to_id` int(10) UNSIGNED NOT NULL, `type` tinyint(3) UNSIGNED NOT NULL, `feedback` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `reviews` -- ALTER TABLE `reviews` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `reviews` -- ALTER TABLE `reviews` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; RENAME TABLE `trade_requests` TO `trades`; ALTER TABLE `trades` ADD `trade_charge` DECIMAL(28,8) NOT NULL DEFAULT '0' AFTER `crypto_amount`; ALTER TABLE `trades` CHANGE `crypto_id` `crypto_currency_id` INT(10) UNSIGNED NOT NULL; ALTER TABLE `trades` CHANGE `fiat_id` `fiat_currency_id` INT(10) UNSIGNED NOT NULL; ALTER TABLE `trades` ADD `reported_by` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `details`; ALTER TABLE `trades` ADD `completed_at` TIMESTAMP NULL DEFAULT NULL AFTER `paid_at`, ADD `reviewed` TINYINT(1) NOT NULL DEFAULT '0' AFTER `completed_at`; ALTER TABLE `transactions` CHANGE `crypto_id` `crypto_currency_id` INT(10) UNSIGNED NULL DEFAULT NULL; ALTER TABLE `transactions` ADD `remark` VARCHAR(40) NULL DEFAULT NULL AFTER `details`; ALTER TABLE `users` ADD `kyc_data` TEXT NULL DEFAULT NULL AFTER `status`, ADD `kv` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0: KYC Unverified, 2: KYC pending, 1: KYC verified' AFTER `kyc_data`; ALTER TABLE `users` ADD `reg_step` TINYINT(1) NOT NULL DEFAULT '0' AFTER `sv`; ALTER TABLE `users` ADD `ban_reason` VARCHAR(255) NULL DEFAULT NULL AFTER `tsc`; ALTER TABLE `users` ADD `completed_trade` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `remember_token`; ALTER TABLE `users` ADD `total_min` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `completed_trade`; -- -- Table structure for table `user_notifications` -- CREATE TABLE `user_notifications` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int(10) NOT NULL, `read_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Unread : 0, Read : 1', `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `click_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `user_notifications` -- ALTER TABLE `user_notifications` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `user_notifications` -- ALTER TABLE `user_notifications` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `wallets` CHANGE `crypto_id` `crypto_currency_id` INT(10) UNSIGNED NOT NULL; ALTER TABLE `withdrawals` CHANGE `crypto_id` `crypto_currency_id` INT(10) UNSIGNED NOT NULL; TRUNCATE TABLE notification_templates; INSERT INTO `notification_templates` (`id`, `act`, `name`, `subj`, `email_body`, `sms_body`, `push_notification_body`, `shortcodes`, `email_status`, `sms_status`, `push_notification_status`, `created_at`, `updated_at`) VALUES (1, 'BAL_ADD', 'Balance - Added', 'Your account has been credited', '

      {{amount}} {{currency}} has been added to your account .

      Transaction Number : {{trx}}

      Your Current Balance is : {{post_balance}}  {{currency}} 

      Admin note: {{remark}}
      ', 'Your account is credited by {{amount}} {{currency}} and your current balance is {{post_balance}}{{currency}} \r\n\r\nTransaction: #{{trx}}\r\nAdmin note: {{remark}}', 'Your account is credited by {{amount}} {{currency}} and your current balance is {{post_balance}}{{currency}} \r\n\r\nTransaction: #{{trx}}\r\nAdmin note: {{remark}}', '{\"trx\":\"Transaction number for the action\",\"amount\":\"Amount inserted by the admin\",\"currency\":\"Base currency of the system\",\"remark\":\"Remark inserted by the admin\",\"post_balance\":\"Balance of the user after this transaction\"}', 1, 0, 1, '2021-11-03 12:00:00', '2022-09-04 09:43:30'), (2, 'BAL_SUB', 'Balance - Subtracted', 'Your account has been debited', '
      {{amount}} {{currency}} has been subtracted from your account .

      Transaction Number : {{trx}}

      Your Current Balance is : {{post_balance}}  {{currency}}

      Admin Note: {{remark}}
      ', '{{amount}} {{currency}} has been subtracted from your account and your current balance is {{post_balance}}{{currency}} \r\n\r\nTransaction: #{{trx}}\r\nAdmin Note: {{remark}}', '{{amount}} {{currency}} has been subtracted from your account and your current balance is {{post_balance}}{{currency}} \r\n\r\nTransaction: #{{trx}}\r\nAdmin Note: {{remark}}', '{\"trx\":\"Transaction number for the action\",\"amount\":\"Amount inserted by the admin\",\"currency\":\"Base currency of the system\",\"remark\":\"Remark inserted by the admin\",\"post_balance\":\"Balance of the user after fter this transaction\"}', 1, 1, 1, '2021-11-03 12:00:00', '2022-06-29 09:20:55'), (3, 'DEPOSIT_COMPLETE', 'Deposit - Automated - Successful', 'Deposit completed successfully', '
      Your deposit of {{amount}} {{currency}}  has been completed Successfully.

      Details of your Deposit :

      Amount : {{amount}} {{currency}}
      Charge: {{charge}} {{currency}}

      Payable : {{payable}} {{currency}}

      Transaction Number : {{trx}}

      Your current Balance is {{post_balance}} {{currency}}

      ', 'Your deposit of {{amount}} {{currency}} has been completed Successfully.\r\n\r\nDetails of your Deposit :\r\n\r\nAmount : {{amount}} {{currency}}\r\nCharge: {{charge}} {{currency}}\r\n\r\nPayable : {{payable}} {{currency}}\r\n\r\nTransaction Number : {{trx}}', 'Your deposit of {{amount}} {{currency}} has been completed Successfully.\r\n\r\nDetails of your Deposit :\r\n\r\nAmount : {{amount}} {{currency}}\r\nCharge: {{charge}} {{currency}}\r\n\r\nPayable : {{payable}} {{currency}}\r\n\r\nTransaction Number : {{trx}}', '{\"trx\":\"Transaction Number\",\"amount\":\"Request Amount By user\",\"charge\":\"Gateway Charge\",\"currency\":\"Crypto Currency\",\"payable\":\"Amount After Charge\", \"post_balance\":\"Users Balance After this operation\"}', 1, 1, 1, '2021-11-03 12:00:00', '2022-07-06 08:30:45'), (7, 'PASS_RESET_CODE', 'Password - Reset - Code', 'Password reset code sent', '
      We have received a request to reset the password for your account on {{time}} .
      Requested From IP: {{ip}} using {{browser}} on {{operating_system}} .


      Your account recovery code is:   {{code}}


      If you do not wish to reset your password, please disregard this message. 

      ', 'Your account recovery code is: {{code}}', 'Your account recovery code is: {{code}}', '{\"code\":\"Verification code for password reset\",\"ip\":\"IP address of the user\",\"browser\":\"Browser of the user\",\"operating_system\":\"Operating system of the user\",\"time\":\"Time of the request\"}', 1, 0, 1, '2021-11-03 12:00:00', '2022-03-20 20:47:05'), (8, 'PASS_RESET_DONE', 'Password - Reset - Confirmation', 'You have reset your password', '

      You have successfully reset your password.

      You changed from  IP: {{ip}} using {{browser}} on {{operating_system}}  on {{time}}


      If you did not change that, please contact us as soon as possible.

      ', 'Your password has been changed successfully', 'Your password has been changed successfully', '{\"ip\":\"IP address of the user\",\"browser\":\"Browser of the user\",\"operating_system\":\"Operating system of the user\",\"time\":\"Time of the request\"}', 1, 1, 1, '2021-11-03 12:00:00', '2022-04-05 03:46:35'), (9, 'ADMIN_SUPPORT_REPLY', 'Support - Reply', 'Reply support ticket', '

      A member from our support team has replied to the following ticket:


      [Ticket#{{ticket_id}}] {{ticket_subject}}

      Click here to reply:  {{link}}

      ----------------------------------------------

      Here is the reply :

      {{reply}}


      ', 'Your Ticket#{{ticket_id}} : {{ticket_subject}} has been replied.', 'Your Ticket#{{ticket_id}} : {{ticket_subject}} has been replied.', '{\"ticket_id\":\"ID of the support ticket\",\"ticket_subject\":\"Subject of the support ticket\",\"reply\":\"Reply made by the admin\",\"link\":\"URL to view the support ticket\"}', 1, 1, 1, '2021-11-03 12:00:00', '2022-03-20 20:47:51'), (10, 'EVER_CODE', 'Verification - Email', 'Please verify your email address', '
      Thanks For joining us.
      Please use the below code to verify your email address.

      Your email verification code is: {{code}}
      ', '---', NULL, '{\"code\":\"Email verification code\"}', 1, 0, 1, '2021-11-03 12:00:00', '2022-04-03 02:32:07'), (11, 'SVER_CODE', 'Verification - SMS', 'Verify your mobile number', '---', 'Your phone verification code is: {{code}}', NULL, '{\"code\":\"SMS Verification Code\"}', 0, 1, 1, '2021-11-03 12:00:00', '2022-03-20 19:24:37'), (12, 'WITHDRAW_APPROVE', 'Withdraw - Approved', 'Withdraw request has been processed and your money is sent', '
      Your withdraw request of {{amount}} {{currency}}  has been Processed Successfully.

      Details of your withdraw:

      Amount : {{amount}} {{currency}}
      Charge: {{charge}} {{currency}}

      You will get: {{payable}} {{currency}}

      Transaction Number : {{trx}}

      -----

      Details of Processed Payment :
      {{admin_details}}
      ', 'Admin Approve Your {{amount}} {{currency}} withdraw request. Transaction {{trx}}', 'Admin Approve Your {{amount}} {{currency}} withdraw request. Transaction {{trx}}', '{\"trx\":\"Transaction Number\",\"amount\":\"Request Amount By user\",\"charge\":\"Gateway Charge\",\"currency\":\"Crypto Currency\",\"payable\":\"Amount After Charge\", \"admin_details\":\"Details Provided By Admin\"}', 1, 1, 1, '2021-11-03 12:00:00', '2022-07-03 11:54:42'), (13, 'WITHDRAW_REJECT', 'Withdraw - Rejected', 'Withdraw request has been rejected and your money is refunded to your account', '
      Your withdraw request of {{amount}} {{currency}} has been Rejected.

      Details of your withdraw:

      Amount : {{amount}} {{currency}}
      Charge: {{charge}} {{currency}}

      You should get: {{payable}} {{currency}}

      Transaction Number : {{trx}}
      ----
      {{amount}} {{currency}} has been refunded to your account and your current Balance is {{post_balance}} {{currency}}

      -----

      Details of Rejection :
      {{admin_details}}






      ', 'Admin Rejected Your {{amount}} {{currency}} withdraw request. \r\n{{amount}} {{currency}} has been refunded to your account and your current Balance is {{post_balance}} {{currency}}\r\n\r\n Transaction {{trx}}\r\n\r\nDetails of Rejection :\r\n{{admin_details}}', 'Admin Rejected Your {{amount}} {{currency}} withdraw request. \r\n{{amount}} {{currency}} has been refunded to your account and your current Balance is {{post_balance}} {{currency}}\r\n\r\n Transaction {{trx}}\r\n\r\nDetails of Rejection :\r\n{{admin_details}}', '{\"trx\":\"Transaction number for the withdraw\",\"amount\":\"Amount requested by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the withdraw method\",\"method_currency\":\"Currency of the withdraw method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"post_balance\":\"Balance of the user after fter this action\",\"admin_details\":\"Rejection message by the admin\"}', 1, 1, 1, '2021-11-03 12:00:00', '2022-07-04 04:42:56'), (14, 'WITHDRAW_REQUEST', 'Withdraw - Requested', 'Withdraw request submitted successfully', '
      Your withdraw request of {{amount}} {{currency}}  has been submitted Successfully.

      Details of your withdraw:

      Amount : {{amount}} {{currency}}
      Charge: {{charge}} {{currency}}

      You will get: {{payable}} {{currency}}

      Transaction Number : {{trx}}

      Your current Balance is {{post_balance}} {{currency}}




      ', 'Your withdraw request of {{amount}} {{currency}} has been submitted Successfully.\r\n\r\nDetails of your withdraw:\r\n\r\nAmount : {{amount}} {{currency}}\r\nCharge: {{charge}} {{currency}}\r\n\r\nYou will get: {{payable}} {{currency}}\r\n\r\nTransaction Number : {{trx}}\r\n\r\nYour current Balance is {{post_balance}} {{currency}}', 'Your withdraw request of {{amount}} {{currency}} has been submitted Successfully.\r\n\r\nDetails of your withdraw:\r\n\r\nAmount : {{amount}} {{currency}}\r\nCharge: {{charge}} {{currency}}\r\n\r\nYou will get: {{payable}} {{currency}}\r\n\r\nTransaction Number : {{trx}}\r\n\r\nYour current Balance is {{post_balance}} {{currency}}', '{\"trx\":\"Transaction number for the withdraw\",\"amount\":\"Amount requested by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the withdraw method\",\"method_currency\":\"Currency of the withdraw method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"post_balance\":\"Balance of the user after fter this transaction\"}', 1, 1, 1, '2021-11-03 12:00:00', '2022-07-04 08:09:13'), (15, 'DEFAULT', 'Default Template', '{{subject}}', '{{message}}', '{{message}}', '{{message}}', '{\"subject\":\"Subject\",\"message\":\"Message\"}', 1, 1, 1, '2019-09-14 13:14:22', '2021-11-04 09:38:55'), (16, 'KYC_APPROVE', 'KYC Approved', 'KYC has been approved', NULL, NULL, NULL, '[]', 1, 1, 1, NULL, NULL), (17, 'KYC_REJECT', 'KYC Rejected Successfully', 'KYC has been rejected', NULL, NULL, NULL, '[]', 1, 1, 1, NULL, NULL), (18, 'NEW_TRADE', 'Trade Request - New', 'You have a new trade request', '
      You have a new trade request.

      Buyer :  {{buyer}}
      Seller : {{seller}}
      Amount : {{fiat_amount}} {{fiat_currency}}
      {{crypto_currency}} : {{crypto_amount}}
      Payment Window : {{window}} Minutes
      ', 'You have a new trade request.\r\n\r\nBuyer : {{buyer}}\r\nSeller : {{seller}}\r\nAmount : {{fiat_amount}} {{fiat_currency}}\r\n{{crypto_currency}} : {{crypto_amount}}\r\nPayment Window : {{window}} Minutes', 'You have a new trade request.\r\n\r\nBuyer : {{buyer}}\r\nSeller : {{seller}}\r\nAmount : {{fiat_amount}} {{fiat_currency}}\r\n{{crypto_currency}} : {{crypto_amount}}\r\nPayment Window : {{window}} Minutes', '{\"buyer\":\"Buyer Name\",\"seller\":\"Seller Name\",\"fiat_amount\":\"Amount In Fiat Currency\",\"fiat_currency\":\"Fiat Currency\",\"crypto_amount\":\"Amount In Crypto Currency\", \"crypto_currency\":\"Crypto Currency\",\"window\":\"Payment Window\"}', 1, 1, 1, NULL, '2022-06-25 10:23:12'), (19, 'TRADE_CANCELED', 'Trade Request - Canceled', 'Trade request is canceled', '
      Trade is canceled by {{name}}

      {{crypto_amount}} {{crypto_currency}} returned to the seller wallet.

      Trade Information :

      Buyer : {{buyer}}
      Seller : {{seller}}
      Amount : {{fiat_amount}} {{fiat_currency}}
      {{crypto_currency}} : {{crypto_amount}}
      Payment Window : {{window}} Minutes
      ', 'Trade is canceled by {{name}}.\r\n\r\n{{crypto_amount}} {{crypto_currency}} returned to the seller wallet.\r\n\r\nTrade Information :\r\n\r\nBuyer : {{buyer}}\r\nSeller : {{seller}}\r\nAmount : {{fiat_amount}} {{fiat_currency}}\r\n{{crypto_currency}} : {{crypto_amount}}\r\nPayment Window : {{window}} Minutes', 'Trade is canceled by {{name}}.\r\n\r\n{{crypto_amount}} {{crypto_currency}} returned to the seller wallet.\r\n\r\nTrade Information :\r\n\r\nBuyer : {{buyer}}\r\nSeller : {{seller}}\r\nAmount : {{fiat_amount}} {{fiat_currency}}\r\n{{crypto_currency}} : {{crypto_amount}}\r\nPayment Window : {{window}} Minutes', '{\"name\":\"Canceller Name\",\"buyer\":\"Buyer Name\",\"seller\":\"Seller Name\",\"fiat_amount\":\"Amount In Fiat Currency\",\"fiat_currency\":\"Fiat Currency\",\"crypto_amount\":\"Amount In Crypto Currency\", \"crypto_currency\":\"Crypto Currency\",\"window\":\"Payment Window\"}', 1, 1, 1, NULL, '2022-06-27 05:47:36'), (20, 'BUYER_PAID', 'Trade Request - Buyer Paid', 'Your buyer has already paid', '
      Your buyer has paid you {{fiat_amount}} {{fiat_currency}}

      Trade Information :

      Buyer : {{buyer}}
      Seller : {{seller}}
      Amount : {{fiat_amount}} {{fiat_currency}}
      {{crypto_currency}} : {{crypto_amount}}
      Payment Window : {{window}} Minutes

      If you got this amount then please release this trade.
      ', 'Your buyer has paid you {{fiat_amount}} {{fiat_currency}}.\r\n\r\nTrade Information :\r\n\r\nBuyer : {{buyer}}\r\nSeller : {{seller}}\r\nAmount : {{fiat_amount}} {{fiat_currency}}\r\n{{crypto_currency}} : {{crypto_amount}}\r\nPayment Window : {{window}} Minutes\r\n\r\nIf you got this then release this trade.', 'Your buyer has paid you {{fiat_amount}} {{fiat_currency}}.\r\n\r\nTrade Information :\r\n\r\nBuyer : {{buyer}}\r\nSeller : {{seller}}\r\nAmount : {{fiat_amount}} {{fiat_currency}}\r\n{{crypto_currency}} : {{crypto_amount}}\r\nPayment Window : {{window}} Minutes\r\n\r\nIf you got this then release this trade.', '{\"buyer\":\"Buyer Name\",\"seller\":\"Seller Name\",\"fiat_amount\":\"Amount In Fiat Currency\",\"fiat_currency\":\"Fiat Currency\",\"crypto_amount\":\"Amount In Crypto Currency\", \"crypto_currency\":\"Crypto Currency\",\"window\":\"Payment Window\"}', 1, 1, 1, NULL, '2022-06-27 05:57:09'), (21, 'TRADE_REPORTED', 'Trade Request - Reported', 'Trade request is reported', '
      Your trade request is reported by {{name}}

      Wait for the system response :

      Trade Information

      Buyer : {{buyer}}
      Seller : {{seller}}
      Amount : {{fiat_amount}} {{fiat_currency}}
      {{crypto_currency}} : {{crypto_amount}}
      Payment Window : {{window}} Minutes
      ', 'Your trade request is reported by {{name}} .\r\n\r\nWait for the system response. \r\n\r\nTrade Information :\r\n\r\nBuyer : {{buyer}}\r\nSeller : {{seller}}\r\nAmount : {{fiat_amount}} {{fiat_currency}}\r\n{{crypto_currency}} : {{crypto_amount}}\r\nPayment Window : {{window}} Minutes', 'Your trade request is reported by {{name}} .\r\n\r\nWait for the system response. \r\n\r\nTrade Information :\r\n\r\nBuyer : {{buyer}}\r\nSeller : {{seller}}\r\nAmount : {{fiat_amount}} {{fiat_currency}}\r\n{{crypto_currency}} : {{crypto_amount}}\r\nPayment Window : {{window}} Minutes', '{\"name\":\"Reporter Name\",\"buyer\":\"Buyer Name\",\"seller\":\"Seller Name\",\"fiat_amount\":\"Amount In Fiat Currency\",\"fiat_currency\":\"Fiat Currency\",\"crypto_amount\":\"Amount In Crypto Currency\", \"crypto_currency\":\"Crypto Currency\",\"window\":\"Payment Window\"}', 1, 1, 1, NULL, '2022-06-27 06:03:08'), (22, 'TRADE_COMPLETED', 'Trade Request - Completed', 'Trade request is completed', '
      Your trade request is completed.

      Buyer named {{name}} received {{crypto_amount}} {{crypto_currency}} successfully.

      Trade Information

      Buyer : {{buyer}}
      Seller : {{seller}}
      Amount : {{fiat_amount}} {{fiat_currency}}
      {{crypto_currency}} : {{crypto_amount}}
      Payment Window : {{window}} Minutes
      ', 'Trade request is completed.\r\n\r\nBuyer named {{name}} received {{crypto_amount}} {{crypto_currency}} successfully.\r\n\r\nTrade Information :\r\n\r\nBuyer : {{buyer}}\r\nSeller : {{seller}}\r\nAmount : {{fiat_amount}} {{fiat_currency}}\r\n{{crypto_currency}} : {{crypto_amount}}\r\nPayment Window : {{window}} Minutes', 'Trade request is completed.\r\n\r\nBuyer named {{name}} received {{crypto_amount}} {{crypto_currency}} successfully.\r\n\r\nTrade Information :\r\n\r\nBuyer : {{buyer}}\r\nSeller : {{seller}}\r\nAmount : {{fiat_amount}} {{fiat_currency}}\r\n{{crypto_currency}} : {{crypto_amount}}\r\nPayment Window : {{window}} Minutes', '{\"name\":\"Buyer Name\",\"buyer\":\"Buyer Name\",\"seller\":\"Seller Name\",\"fiat_amount\":\"Amount In Fiat Currency\",\"fiat_currency\":\"Fiat Currency\",\"crypto_amount\":\"Amount In Crypto Currency\", \"crypto_currency\":\"Crypto Currency\",\"window\":\"Payment Window\"}', 1, 1, 1, NULL, '2022-06-27 06:08:29'), (23, 'TRADE_SETTLED', 'Trade Request - Settled By System', 'Reported trade request is settled by system', '
      The reported trade request is already reviewed by the system.

      {{name}} received {{crypto_amount}} {{crypto_currency}}.

      Trade Information

      Buyer : {{buyer}}
      Seller : {{seller}}
      Amount : {{fiat_amount}} {{fiat_currency}}
      {{crypto_currency}} : {{crypto_amount}}
      Payment Window : {{window}} Minutes
      ', 'The reported trade request is already reviewed by the system.\r\n{{name}} received {{crypto_amount}} {{crypto_currency}}', 'The reported trade request is already reviewed by the system.\r\n{{name}} received {{crypto_amount}} {{crypto_currency}}', '{\"name\":\"Winner Name\",\"buyer\":\"Buyer Name\",\"seller\":\"Seller Name\",\"fiat_amount\":\"Amount In Fiat Currency\",\"fiat_currency\":\"Fiat Currency\",\"crypto_amount\":\"Amount In Crypto Currency\", \"crypto_currency\":\"Crypto Currency\",\"window\":\"Payment Window\"}', 1, 1, 1, NULL, '2022-06-29 06:02:09'), (24, 'TRADE_CHAT', 'Trade Conversation', 'You have a new message', '
      You have a new message from {{from_user}}.

      Trade Unique Id : {{trade_uid}}

      Message : {{message}}
      ', 'You have a new message from {{from_user}}.\r\n\r\nTrade Unique Id : {{trade_uid}}\r\n\r\nMessage : {{message}}', 'You have a new message from {{from_user}}.\r\n\r\nTrade Unique Id : {{trade_uid}}\r\n\r\nMessage : {{message}}', '{\"from_user\":\"New message from user\",\"message\":\"Message\",\"trade_uid\":\"Trade unique Id\"}', 1, 0, 1, '2021-11-03 12:00:00', '2022-09-04 13:05:03'); UPDATE `general_settings` SET `global_shortcodes` = ' {\r\n \"site_name\":\"Name of your site\"\r\n }' WHERE `general_settings`.`id` = 1; UPDATE `general_settings` SET `email_template` = '\r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
      \r\n \r\n \r\n \r\n \r\n
      \r\n \r\n \r\n \r\n \r\n \r\n
      \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
      This is a System Generated Email
      \r\n
      \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
      \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
      \r\n \r\n \"img\"\r\n \r\n
      Hello {{fullname}} ({{username}})
      \r\n \r\n \r\n \r\n \r\n
      \r\n
      {{message}}
      \r\n
      \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
      \r\n © 2021 {{site_name}} . All Rights Reserved. \r\n
      \r\n
      \r\n
      \r\n
      ' WHERE `general_settings`.`id` = 1; UPDATE `general_settings` SET `sms_from` = 'ViserAdmin' WHERE `general_settings`.`id` = 1; UPDATE `general_settings` SET `sms_config` = '{\"name\":\"nexmo\",\"clickatell\":{\"api_key\":\"----------------\"},\"infobip\":{\"username\":\"------------8888888\",\"password\":\"-----------------\"},\"message_bird\":{\"api_key\":\"-------------------\"},\"nexmo\":{\"api_key\":\"----------------------\",\"api_secret\":\"----------------------\"},\"sms_broadcast\":{\"username\":\"----------------------\",\"password\":\"-----------------------------\"},\"twilio\":{\"account_sid\":\"-----------------------\",\"auth_token\":\"---------------------------\",\"from\":\"----------------------\"},\"text_magic\":{\"username\":\"-----------------------\",\"apiv2_key\":\"-------------------------------\"},\"custom\":{\"method\":\"get\",\"url\":\"https:\\/\\/hostname\\/demo-api-v1\",\"headers\":{\"name\":[\"api_key\"],\"value\":[\"test_api 555\"]},\"body\":{\"name\":[\"from_number\"],\"value\":[\"5657545757\"]}}}' WHERE `general_settings`.`id` = 1; ALTER TABLE `notification_templates` ADD `has_pn` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1' AFTER `push_notification_status`; UPDATE `notification_templates` SET `has_pn` = '0', `push_notification_status` = '0' WHERE `notification_templates`.`act` = 'PASS_RESET_CODE'; UPDATE `notification_templates` SET `has_pn` = '0', `push_notification_status` = '0' WHERE `notification_templates`.`act` = 'PASS_RESET_DONE'; UPDATE `notification_templates` SET `has_pn` = '0', `push_notification_status` = '0' WHERE `notification_templates`.`act` = 'ADMIN_SUPPORT_REPLY'; UPDATE `extensions` SET `shortcode` = '{\"site_key\":{\"title\":\"Site Key\",\"value\":\"*********\"},\"secret_key\":{\"title\":\"Secret Key\",\"value\":\"**********\"}}' WHERE `extensions`.`id` = 2; ALTER TABLE `support_messages` CHANGE `supportticket_id` `support_ticket_id` INT(10) UNSIGNED NOT NULL DEFAULT '0'; UPDATE `users` SET `kv`= 1, `reg_step` = 1; UPDATE `extensions` SET `script` = '\r\n
      \r\n
      ' WHERE `extensions`.`id` = 2;