INSERT IGNORE INTO `users` (`id`, `plan_id`, `refid`, `level_id`, `type`, `firstname`, `lastname`, `email`, `username`, `password`, `phone`, `twaddress`, `address1`, `address2`, `ucity`, `ucountry`, `state`, `uzip`, `avatar`, `online`, `unique_url`, `bitly_unique_url`, `updated_at`, `google_id`, `facebook_id`, `twitter_id`, `umode`, `PhoneNumber`, `Addressone`, `Addresstwo`, `City`, `Country`, `StateProvince`, `Zip`, `f_link`, `t_link`, `l_link`, `products_wishlist`, `product_commission`, `affiliate_commission`, `product_commission_paid`, `affiliate_commission_paid`, `product_total_click`, `product_total_sale`, `affiliate_total_click`, `sale_commission`, `sale_commission_paid`, `status`, `reg_approved`, `is_vendor`, `store_meta`, `store_slug`, `store_name`, `store_contact_us_map`, `store_address`, `store_email`, `store_contact_number`, `store_terms_condition`, `value`, `last_ping`, `install_location_details`, `token`, `created_at`, `device_type`, `device_token`, `groups`, `verification_id`, `primary_payment_method`, `s3_bucket_name`, `s3_region`) VALUES
(1, -1, 0, 0, 'admin', 'Admin', 'Admin', 'admin@gmail.com', 'admin', '7479305b3e914c467c0cb2eba57b352b58e1ff37', '', '', '', '', '', '', '', '', NULL, '1', '', '', '2021-01-01 16:15:31', '', '', '', '', '+1 201-555-0123', '', '', 'Test City', '13', NULL, '123456', '', '', '', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '2022-07-17 11:05:43', '', NULL, '2021-01-01 16:15:31', 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT IGNORE INTO `setting` (`setting_id`, `setting_key`, `setting_value`, `setting_type`, `setting_status`, `setting_ipaddress`, `setting_is_default`, `language_id`) VALUES
(1, 'front_template', 'custom_12', 'login', 1, '::1', 0, 1),
(2, 'top_affiliate', '1', 'userdashboard', 1, '::1', 0, 1),
(3, 'wallet_min_amount', '200', 'site', 1, '::1', 0, 1),
(4, 'wallet_min_message', '<p>The minimum limit is: 100</p>', 'site', 1, '::1', 0, 1),
(5, 'name', 'Affiliate Script', 'site', 1, '::1', 0, 1),
(6, 'maintenance_mode', '0', 'site', 1, '::1', 0, 1),
(7, 'store_maintenance_mode', '0', 'site', 1, '::1', 0, 1),
(8, 'notify_email', 'admin@gmail.com', 'site', 1, '::1', 0, 1),
(9, 'session_timeout', '', 'site', 1, '::1', 0, 1),
(10, 'footer', 'Copyright © 2025 Affiliate Script @ Company Name', 'site', 1, '::1', 0, 1),
(11, 'time_zone', 'Africa/Abidjan', 'site', 1, '::1', 0, 1),
(12, 'meta_description', '', 'site', 1, '::1', 0, 1),
(13, 'meta_keywords', '', 'site', 1, '::1', 0, 1),
(14, 'meta_author', '', 'site', 1, '::1', 0, 1),
(15, 'google_analytics', '', 'site', 1, '::1', 0, 1),
(16, 'faceboook_pixel', '', 'site', 1, '::1', 0, 1),
(17, 'fbmessager_script', '', 'site', 1, '::1', 0, 1),
(18, 'global_script', '', 'site', 1, '::1', 0, 1),
(19, 'global_script_status', '[]', 'site', 1, '::1', 0, 1),
(20, 'mail_type', 'php_mailer', 'email', 1, '::1', 0, 1),
(21, 'from_email', 'admin@gmail.com', 'email', 1, '::1', 0, 1),
(22, 'from_name', 'ADMIN SUPPORT', 'email', 1, '::1', 0, 1),
(23, 'smtp_hostname', '', 'email', 1, '::1', 0, 1),
(24, 'smtp_username', '', 'email', 1, '::1', 0, 1),
(25, 'smtp_password', '', 'email', 1, '::1', 0, 1),
(26, 'smtp_port', '', 'email', 1, '::1', 0, 1),
(27, 'smtp_crypto', '', 'email', 1, '::1', 0, 1),
(28, 'registration_status', '1', 'store', 1, '::1', 0, 1),
(29, 'registration_approval', '0', 'store', 1, '::1', 0, 1),
(30, 'language_status', '1', 'store', 1, '::1', 0, 1),
(31, 'affiliate_cookie', '30', 'store', 1, '::1', 0, 1),
(32, 'default_action_status', '0', 'referlevel', 1, '::1', 0, 1),
(33, 'default_external_order_status', '0', 'referlevel', 1, '::1', 0, 1),
(34, 'heading', 'Affiliate Script Terms', 'tnc', 1, '::1', 0, 1),
(35, 'content', '<p>Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms Affiliate Script Terms</p>', 'tnc', 1, '::1', 0, 1),
(36, 'sitekey', '', 'googlerecaptcha', 1, '::1', 0, 1),
(37, 'secretkey', '', 'googlerecaptcha', 1, '::1', 0, 1),
(38, 'admin_login', '0', 'googlerecaptcha', 1, '::1', 0, 1),
(39, 'affiliate_login', '0', 'googlerecaptcha', 1, '::1', 0, 1),
(40, 'affiliate_register', '0', 'googlerecaptcha', 1, '::1', 0, 1),
(41, 'client_login', '0', 'googlerecaptcha', 1, '::1', 0, 1),
(42, 'client_register', '0', 'googlerecaptcha', 1, '::1', 0, 1),
(43, 'heading', 'Affiliate Script Home Page', 'loginclient', 1, '::1', 0, 1),
(44, 'content', 'Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo Home content demo                                                           ', 'loginclient', 1, '::1', 0, 1),
(45, 'about_content', 'About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content DemoAbout Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo About Content Demo', 'loginclient', 1, '::1', 0, 1),
(46, 'heading_color', '', 'loginclient', 1, '::1', 0, 1),
(47, 'input_text_color', '', 'loginclient', 1, '::1', 0, 1),
(48, 'input_bg_color', '', 'loginclient', 1, '::1', 0, 1),
(49, 'input_label_color', '', 'loginclient', 1, '::1', 0, 1),
(50, 'bg_left', '', 'loginclient', 1, '::1', 0, 1),
(51, 'bg_right', '', 'loginclient', 1, '::1', 0, 1),
(52, 'footer_bf', '', 'loginclient', 1, '::1', 0, 1),
(53, 'footer_color', '', 'loginclient', 1, '::1', 0, 1),
(54, 'btn_sendmail_bg', '', 'loginclient', 1, '::1', 0, 1),
(55, 'btn_sendmail_color', '', 'loginclient', 1, '::1', 0, 1),
(56, 'btn_backlogin_bg', '', 'loginclient', 1, '::1', 0, 1),
(57, 'btn_backlogin_color', '', 'loginclient', 1, '::1', 0, 1),
(58, 'btn_forgotlink_bg', '', 'loginclient', 1, '::1', 0, 1),
(59, 'btn_forgotlink_color', '', 'loginclient', 1, '::1', 0, 1),
(60, 'btn_signin_bg', '', 'loginclient', 1, '::1', 0, 1),
(61, 'btn_signin_color', '', 'loginclient', 1, '::1', 0, 1),
(62, 'btn_signup_bg', '', 'loginclient', 1, '::1', 0, 1),
(63, 'btn_signup_color', '', 'loginclient', 1, '::1', 0, 1),
(64, 'btn_registersubmit_bg', '', 'loginclient', 1, '::1', 0, 1),
(65, 'btn_registersubmit_color', '', 'loginclient', 1, '::1', 0, 1),
(66, 'status', '1', 'store', 1, '::1', 0, 1),
(67, 'status', '1', 'referlevel', 1, '::1', 0, 1),
(68, 'registration_builder', '[{\"type\":\"header\",\"label\":\"Firstname\"},{\"type\":\"header\",\"label\":\"Lastname\"},{\"type\":\"header\",\"label\":\"Email\"},{\"type\":\"text\",\"label\":\"Mobile Phone\",\"placeholder\":\"Enter your mobile number\",\"className\":\"form-control\",\"name\":\"text-1621449816785\",\"mobile_validation\":\"true\"},{\"type\":\"header\",\"label\":\"Username\"},{\"type\":\"header\",\"label\":\"Password\"},{\"type\":\"header\",\"label\":\"Confirm_password\"}]', 'registration_builder', 1, '::1', 0, 1),
(69, 'admin_sound_status', '1', 'live_dashboard', 1, '::1', 0, 1),
(70, 'admin_action_status', '1', 'live_dashboard', 1, '::1', 0, 1),
(71, 'admin_integration_order_status', '1', 'live_dashboard', 1, '::1', 0, 1),
(72, 'admin_affiliate_register_status', '1', 'live_dashboard', 1, '::1', 0, 1),
(73, 'admin_local_store_order_status', '1', 'live_dashboard', 1, '::1', 0, 1),
(74, 'admin_data_load_interval', '15', 'live_dashboard', 1, '::1', 0, 1),
(75, 'admin_integration_logs', '1', 'live_log', 1, '::1', 0, 1),
(76, 'admin_integration_orders', '1', 'live_log', 1, '::1', 0, 1),
(77, 'admin_newuser', '1', 'live_log', 1, '::1', 0, 1),
(78, 'levels', '20', 'referlevel', 1, '::1', 0, 1),
(79, 'sale_type', 'percentage', 'referlevel', 1, '::1', 0, 1),
(80, 'disabled_for', '[]', 'referlevel', 1, '::1', 0, 1),
(81, 'commition', '', 'referlevel_1', 1, '::1', 0, 1),
(82, 'sale_commition', '', 'referlevel_1', 1, '::1', 0, 1),
(83, 'ex_commition', '', 'referlevel_1', 1, '::1', 0, 1),
(84, 'ex_action_commition', '', 'referlevel_1', 1, '::1', 0, 1),
(85, 'commition', '', 'referlevel_2', 1, '::1', 0, 1),
(86, 'sale_commition', '', 'referlevel_2', 1, '::1', 0, 1),
(87, 'ex_commition', '', 'referlevel_2', 1, '::1', 0, 1),
(88, 'ex_action_commition', '', 'referlevel_2', 1, '::1', 0, 1),
(89, 'commition', '', 'referlevel_3', 1, '::1', 0, 1),
(90, 'sale_commition', '', 'referlevel_3', 1, '::1', 0, 1),
(91, 'ex_commition', '', 'referlevel_3', 1, '::1', 0, 1),
(92, 'ex_action_commition', '', 'referlevel_3', 1, '::1', 0, 1),
(93, 'commition', '', 'referlevel_4', 1, '::1', 0, 1),
(94, 'sale_commition', '', 'referlevel_4', 1, '::1', 0, 1),
(95, 'ex_commition', '', 'referlevel_4', 1, '::1', 0, 1),
(96, 'ex_action_commition', '', 'referlevel_4', 1, '::1', 0, 1),
(97, 'commition', '', 'referlevel_5', 1, '::1', 0, 1),
(98, 'sale_commition', '', 'referlevel_5', 1, '::1', 0, 1),
(99, 'ex_commition', '', 'referlevel_5', 1, '::1', 0, 1),
(100, 'ex_action_commition', '', 'referlevel_5', 1, '::1', 0, 1),
(101, 'commition', '', 'referlevel_6', 1, '::1', 0, 1),
(102, 'sale_commition', '', 'referlevel_6', 1, '::1', 0, 1),
(103, 'ex_commition', '', 'referlevel_6', 1, '::1', 0, 1),
(104, 'ex_action_commition', '', 'referlevel_6', 1, '::1', 0, 1),
(105, 'commition', '', 'referlevel_7', 1, '::1', 0, 1),
(106, 'sale_commition', '', 'referlevel_7', 1, '::1', 0, 1),
(107, 'ex_commition', '', 'referlevel_7', 1, '::1', 0, 1),
(108, 'ex_action_commition', '', 'referlevel_7', 1, '::1', 0, 1),
(109, 'commition', '', 'referlevel_8', 1, '::1', 0, 1),
(110, 'sale_commition', '', 'referlevel_8', 1, '::1', 0, 1),
(111, 'ex_commition', '', 'referlevel_8', 1, '::1', 0, 1),
(112, 'ex_action_commition', '', 'referlevel_8', 1, '::1', 0, 1),
(113, 'commition', '', 'referlevel_9', 1, '::1', 0, 1),
(114, 'sale_commition', '', 'referlevel_9', 1, '::1', 0, 1),
(115, 'ex_commition', '', 'referlevel_9', 1, '::1', 0, 1),
(116, 'ex_action_commition', '', 'referlevel_9', 1, '::1', 0, 1),
(117, 'commition', '', 'referlevel_10', 1, '::1', 0, 1),
(118, 'sale_commition', '', 'referlevel_10', 1, '::1', 0, 1),
(119, 'ex_commition', '', 'referlevel_10', 1, '::1', 0, 1),
(120, 'ex_action_commition', '', 'referlevel_10', 1, '::1', 0, 1),
(121, 'marketvendorstatus', '1', 'market_vendor', 1, '::1', 0, 1),
(122, 'commission_type', '', 'market_vendor', 1, '::1', 0, 1),
(123, 'commission_sale', '', 'market_vendor', 1, '::1', 0, 1),
(124, 'sale_status', '0', 'market_vendor', 1, '::1', 0, 1),
(125, 'click_allow', 'single', 'market_vendor', 1, '::1', 0, 1),
(126, 'commission_number_of_click', '', 'market_vendor', 1, '::1', 0, 1),
(127, 'commission_click_commission', '', 'market_vendor', 1, '::1', 0, 1),
(128, 'click_status', '0', 'market_vendor', 1, '::1', 0, 1),
(129, 'storestatus', '1', 'vendor', 1, '::1', 0, 1),
(130, 'admin_click_count', '', 'vendor', 1, '::1', 0, 1),
(131, 'admin_click_amount', '0.00', 'vendor', 1, '::1', 0, 1),
(132, 'admin_sale_commission_type', 'percentage', 'vendor', 1, '::1', 0, 1),
(133, 'admin_commission_value', '', 'vendor', 1, '::1', 0, 1),
(134, 'is_install', '1', 'withdrawalpayment_bank_transfer', 1, '::1', 0, 1),
(135, 'is_install', '1', 'withdrawalpayment_paypal', 1, '::1', 0, 1),
(136, 'status', '1', 'withdrawalpayment_bank_transfer', 1, '::1', 0, 1),
(137, 'status', '1', 'withdrawalpayment_paypal', 1, '::1', 0, 1),
(138, 'ClientID', '', 'withdrawalpayment_paypal', 1, '::1', 0, 1),
(139, 'ClientSecret', '', 'withdrawalpayment_paypal', 1, '::1', 0, 1),
(140, 'denied_status_id', '0', 'withdrawalpayment_paypal', 1, '::1', 0, 1),
(141, 'pending_status_id', '0', 'withdrawalpayment_paypal', 1, '::1', 0, 1),
(142, 'processing_status_id', '0', 'withdrawalpayment_paypal', 1, '::1', 0, 1),
(143, 'success_status_id', '0', 'withdrawalpayment_paypal', 1, '::1', 0, 1),
(144, 'canceled_status_id', '0', 'withdrawalpayment_paypal', 1, '::1', 0, 1),
(145, 'is_install', '1', 'membershippayment_bank_transfer', 1, '::1', 0, 1),
(146, 'is_install', '1', 'membershippayment_paypal', 1, '::1', 0, 1),
(147, 'is_install', '1', 'membershippayment_stripe_payment', 1, '::1', 0, 1),
(148, 'status', '1', 'membershippayment_bank_transfer', 1, '::1', 0, 1),
(149, 'bank_details', '', 'membershippayment_bank_transfer', 1, '::1', 0, 1),
(150, 'status', '1', 'membershippayment_paypal', 1, '::1', 0, 1),
(151, 'api_username', '', 'membershippayment_paypal', 1, '::1', 0, 1),
(152, 'api_password', '', 'membershippayment_paypal', 1, '::1', 0, 1),
(153, 'api_signature', '', 'membershippayment_paypal', 1, '::1', 0, 1),
(154, 'payment_currency', 'USD', 'membershippayment_paypal', 1, '::1', 0, 1),
(155, 'denied_status_id', '0', 'membershippayment_paypal', 1, '::1', 0, 1),
(156, 'pending_status_id', '0', 'membershippayment_paypal', 1, '::1', 0, 1),
(157, 'processing_status_id', '0', 'membershippayment_paypal', 1, '::1', 0, 1),
(158, 'success_status_id', '0', 'membershippayment_paypal', 1, '::1', 0, 1),
(159, 'canceled_status_id', '0', 'membershippayment_paypal', 1, '::1', 0, 1),
(160, 'status', '1', 'membershippayment_stripe_payment', 1, '::1', 0, 1),
(161, 'environment', '0', 'membershippayment_stripe_payment', 1, '::1', 0, 1),
(162, 'test_public_key', '', 'membershippayment_stripe_payment', 1, '::1', 0, 1),
(163, 'test_secret_key', '', 'membershippayment_stripe_payment', 1, '::1', 0, 1),
(164, 'live_public_key', '', 'membershippayment_stripe_payment', 1, '::1', 0, 1),
(165, 'live_secret_key', '', 'membershippayment_stripe_payment', 1, '::1', 0, 1),
(166, 'order_success_status', '0', 'membershippayment_stripe_payment', 1, '::1', 0, 1),
(167, 'order_failed_status', '0', 'membershippayment_stripe_payment', 1, '::1', 0, 1),
(168, 'status', '1', 'storepayment_bank_transfer', 1, '::1', 0, 1),
(169, 'status', '1', 'storepayment_cod', 1, '::1', 0, 1),
(170, 'shipping_in_limited', '0', 'shipping_setting', 1, '::1', 0, 1),
(171, 'shipping_error_message', 'Our store shipping service does not support your country!', 'shipping_setting', 1, '::1', 0, 1),
(172, 'cost', '[]', 'shipping_setting', 1, '::1', 0, 1),
(173, 'name', 'Affiliate Script Store', 'store', 1, '::1', 0, 1),
(174, 'menu_on_front', '1', 'store', 1, '::1', 0, 1),
(175, 'menu_on_front_blank', '1', 'store', 1, '::1', 0, 1),
(176, 'theme', '0', 'store', 1, '::1', 0, 1),
(177, 'google_analytics', '', 'store', 1, '::1', 0, 1),
(178, 'footer', 'Copyright © 2024 Affiliate Script Store @ Store Name', 'store', 1, '::1', 0, 1),
(179, 'contact_us_map', '', 'store', 1, '::1', 0, 1),
(180, 'address', '', 'store', 1, '::1', 0, 1),
(181, 'email', '', 'store', 1, '::1', 0, 1),
(182, 'contact_number', '', 'store', 1, '::1', 0, 1),
(183, 'is_variation_filter', '1', 'store', 1, '::1', 0, 1),
(184, 'homepage_banner', '{\"title\":\"\",\"content\":\"\",\"button_text\":\"\",\"button_link\":\"\"}', 'store', 1, '::1', 0, 1),
(185, 'homepage_bottom_section', '{\"content\":\"\"}', 'store', 1, '::1', 0, 1),
(186, 'about_content', '', 'store', 1, '::1', 0, 1),
(187, 'contact_content', '', 'store', 1, '::1', 0, 1),
(188, 'policy_content', '', 'store', 1, '::1', 0, 1),
(189, 'homepage_slider', '[]', 'store', 1, '::1', 0, 1),
(190, 'homepage_features', '[]', 'store', 1, '::1', 0, 1),
(191, 'bs_cards', '[]', 'store', 1, '::1', 0, 1),
(192, 'social_links', '[]', 'store', 1, '::1', 0, 1),
(193, 'custom_page', '[]', 'store', 1, '::1', 0, 1),
(194, 'per_task', 'null', 'store', 1, '::1', 0, 1),
(195, 'footer_menu', '[]', 'store', 1, '::1', 0, 1),
(196, 'recaptcha', '', 'formsetting', 1, '::1', 0, 1),
(197, 'product_commission_type', '', 'formsetting', 1, '::1', 0, 1),
(198, 'product_commission', '', 'formsetting', 1, '::1', 0, 1),
(199, 'product_ppc', '', 'formsetting', 1, '::1', 0, 1),
(200, 'product_noofpercommission', '', 'formsetting', 1, '::1', 0, 1),
(201, 'form_recursion', '', 'formsetting', 1, '::1', 0, 1),
(202, 'recursion_custom_time', '0', 'formsetting', 1, '::1', 0, 1),
(203, 'recursion_endtime', NULL, 'formsetting', 1, '::1', 0, 1),
(204, 'click_allow', 'single', 'productsetting', 1, '::1', 0, 1),
(205, 'product_commission_type', '', 'productsetting', 1, '::1', 0, 1),
(206, 'product_commission', '', 'productsetting', 1, '::1', 0, 1),
(207, 'product_ppc', '', 'productsetting', 1, '::1', 0, 1),
(208, 'product_noofpercommission', '', 'productsetting', 1, '::1', 0, 1),
(209, 'product_recursion', '', 'productsetting', 1, '::1', 0, 1),
(210, 'recursion_custom_time', '0', 'productsetting', 1, '::1', 0, 1),
(211, 'recursion_endtime', NULL, 'productsetting', 1, '::1', 0, 1),
(212, 'status', '1', 'order_comment', 1, '::1', 0, 1),
(213, 'title', '{\"1\":\"Add Important Comments\"}', 'order_comment', 1, '::1', 0, 1),
(214, 'status', '1', 'membership', 1, '::1', 0, 1),
(215, 'custom_logo_size', '0', 'site', 1, '::1', 0, 1),
(216, 'log_custom_height', '', 'site', 1, '::1', 0, 1),
(217, 'log_custom_width', '', 'site', 1, '::1', 0, 1),
(218, 'affiliate_tracking_place', '0', 'site', 1, '::1', 0, 1),
(219, 'block_click_across_browser', '1', 'site', 1, '::1', 0, 1),
(220, 'hide_currency_from', '', 'site', 1, '::1', 0, 1),
(221, 'unsubscribed_page_title', 'Welcome To Our Unsubscribed Page', 'email', 1, '::1', 0, 1),
(222, 'unsubscribed_page_message', 'We are sorry you go but we respect your decision! You are now unsubscribed from our list.\r\nyou always can enable it back from your user profile page. Thank you', 'email', 1, '::1', 0, 1),
(223, 'vendor_min_deposit', '500', 'site', 1, '::1', 0, 1),
(225, 'status', '1', 'depositpayment_bank_transfer', 1, '::1', 1, 1),
(226, 'proof', '0', 'depositpayment_bank_transfer', 1, '::1', 0, 1),
(227, 'bank_names', '[\"Bank Transfer Details\"]', 'depositpayment_bank_transfer', 1, '::1', 0, 1),
(228, 'bank_details', 'Bank Transfer Details\r\nBank Transfer Details\r\nBank Transfer Details\r\nBank Transfer Details', 'depositpayment_bank_transfer', 1, '::1', 0, 1),
(229, 'additional_bank_details', '[]', 'depositpayment_bank_transfer', 1, '::1', 0, 1),
(230, 'autoacceptlocalstore', '0', 'referlevel', 1, '::1', 0, 1),
(231, 'autoacceptexternalstore', '0', 'referlevel', 1, '::1', 0, 1),
(232, 'autoacceptaction', '0', 'referlevel', 1, '::1', 0, 1),
(233, 'show_sponser', '', 'referlevel', 1, '::1', 0, 1),
(234, 'sponser_name', 'System Admin', 'referlevel', 1, '::1', 0, 1),
(235, 'reg_comission_type', 'disabled', 'referlevel', 1, '::1', 0, 1),
(236, 'reg_comission_custom_amt', '0', 'referlevel', 1, '::1', 0, 1),
(237, 'reg_commission', '', 'referlevel_1', 1, '::1', 0, 1),
(238, 'reg_commission', '', 'referlevel_2', 1, '::1', 0, 1),
(239, 'reg_commission', '', 'referlevel_3', 1, '::1', 0, 1),
(240, 'reg_commission', '', 'referlevel_4', 1, '::1', 0, 1),
(241, 'reg_commission', '', 'referlevel_5', 1, '::1', 0, 1),
(242, 'reg_commission', '', 'referlevel_6', 1, '::1', 0, 1),
(243, 'reg_commission', '', 'referlevel_7', 1, '::1', 0, 1),
(244, 'reg_commission', '', 'referlevel_8', 1, '::1', 0, 1),
(245, 'reg_commission', '', 'referlevel_9', 1, '::1', 0, 1),
(246, 'reg_commission', '', 'referlevel_10', 1, '::1', 0, 1),
(247, 'reg_commission', '', 'referlevel_11', 1, '::1', 0, 1),
(248, 'sale_commition', '', 'referlevel_11', 1, '::1', 0, 1),
(249, 'commition', '', 'referlevel_11', 1, '::1', 0, 1),
(250, 'ex_commition', '', 'referlevel_11', 1, '::1', 0, 1),
(251, 'ex_action_commition', '', 'referlevel_11', 1, '::1', 0, 1),
(252, 'reg_commission', '', 'referlevel_12', 1, '::1', 0, 1),
(253, 'sale_commition', '', 'referlevel_12', 1, '::1', 0, 1),
(254, 'commition', '', 'referlevel_12', 1, '::1', 0, 1),
(255, 'ex_commition', '', 'referlevel_12', 1, '::1', 0, 1),
(256, 'ex_action_commition', '', 'referlevel_12', 1, '::1', 0, 1),
(257, 'reg_commission', '', 'referlevel_13', 1, '::1', 0, 1),
(258, 'sale_commition', '', 'referlevel_13', 1, '::1', 0, 1),
(259, 'commition', '', 'referlevel_13', 1, '::1', 0, 1),
(260, 'ex_commition', '', 'referlevel_13', 1, '::1', 0, 1),
(261, 'ex_action_commition', '', 'referlevel_13', 1, '::1', 0, 1),
(262, 'reg_commission', '', 'referlevel_14', 1, '::1', 0, 1),
(263, 'sale_commition', '', 'referlevel_14', 1, '::1', 0, 1),
(264, 'commition', '', 'referlevel_14', 1, '::1', 0, 1),
(265, 'ex_commition', '', 'referlevel_14', 1, '::1', 0, 1),
(266, 'ex_action_commition', '', 'referlevel_14', 1, '::1', 0, 1),
(267, 'reg_commission', '', 'referlevel_15', 1, '::1', 0, 1),
(268, 'sale_commition', '', 'referlevel_15', 1, '::1', 0, 1),
(269, 'commition', '', 'referlevel_15', 1, '::1', 0, 1),
(270, 'ex_commition', '', 'referlevel_15', 1, '::1', 0, 1),
(271, 'ex_action_commition', '', 'referlevel_15', 1, '::1', 0, 1),
(272, 'reg_commission', '', 'referlevel_16', 1, '::1', 0, 1),
(273, 'sale_commition', '', 'referlevel_16', 1, '::1', 0, 1),
(274, 'commition', '', 'referlevel_16', 1, '::1', 0, 1),
(275, 'ex_commition', '', 'referlevel_16', 1, '::1', 0, 1),
(276, 'ex_action_commition', '', 'referlevel_16', 1, '::1', 0, 1),
(277, 'reg_commission', '', 'referlevel_17', 1, '::1', 0, 1),
(278, 'sale_commition', '', 'referlevel_17', 1, '::1', 0, 1),
(279, 'commition', '', 'referlevel_17', 1, '::1', 0, 1),
(280, 'ex_commition', '', 'referlevel_17', 1, '::1', 0, 1),
(281, 'ex_action_commition', '', 'referlevel_17', 1, '::1', 0, 1),
(282, 'reg_commission', '', 'referlevel_18', 1, '::1', 0, 1),
(283, 'sale_commition', '', 'referlevel_18', 1, '::1', 0, 1),
(284, 'commition', '', 'referlevel_18', 1, '::1', 0, 1),
(285, 'ex_commition', '', 'referlevel_18', 1, '::1', 0, 1),
(286, 'ex_action_commition', '', 'referlevel_18', 1, '::1', 0, 1),
(287, 'reg_commission', '', 'referlevel_19', 1, '::1', 0, 1),
(288, 'sale_commition', '', 'referlevel_19', 1, '::1', 0, 1),
(289, 'commition', '', 'referlevel_19', 1, '::1', 0, 1),
(290, 'ex_commition', '', 'referlevel_19', 1, '::1', 0, 1),
(291, 'ex_action_commition', '', 'referlevel_19', 1, '::1', 0, 1),
(292, 'reg_commission', '', 'referlevel_20', 1, '::1', 0, 1),
(293, 'sale_commition', '', 'referlevel_20', 1, '::1', 0, 1),
(294, 'commition', '', 'referlevel_20', 1, '::1', 0, 1),
(295, 'ex_commition', '', 'referlevel_20', 1, '::1', 0, 1),
(296, 'ex_action_commition', '', 'referlevel_20', 1, '::1', 0, 1),
(297, 'tax_status', '0', 'tax_setting', 1, '::1', 0, 1),
(298, 'common_tax_percentage', '', 'tax_setting', 1, '::1', 0, 1),
(299, 'cost', '[]', 'tax_setting', 1, '::1', 0, 1),
(300, 'top_tags_limit', '10', 'store', 1, '::1', 0, 1),
(301, 'notificationbefore', '10', 'membership', 1, '::1', 0, 1),
(302, 'default_plan_id', '1', 'membership', 1, '::1', 0, 1),
(303, 'depositstatus', '1', 'vendor', 1, '::1', 0, 1),
(304, 'status', '1', 'award_level', 1, '::1', 0, 1),
(305, 'marketaddnewprogram', '0', 'market_vendor', 1, '::1', 0, 1),
(306, 'marketaddnewcampaign', '0', 'market_vendor', 1, '::1', 0, 1),
(307, 'marketaddnewstoreproduct', '0', 'market_vendor', 1, '::1', 0, 1),
(308, 'marketvendorexternalordercampaign', '0', 'market_vendor', 1, '::1', 0, 1),
(309, 'marketvendoractionscampaign', '0', 'market_vendor', 1, '::1', 0, 1),
(310, 'marketvendorclickcampaign', '0', 'market_vendor', 1, '::1', 0, 1),
(311, 'is_install', '1', 'payment_gateway_bank_transfer', 1, '::1', 0, 1),
(312, 'is_install', '1', 'payment_gateway_cod', 1, '::1', 0, 1),
(313, 'is_install', '1', 'payment_gateway_flutterwave', 1, '::1', 0, 1),
(314, 'is_install', '1', 'payment_gateway_paypal', 1, '::1', 0, 1),
(315, 'is_install', '1', 'payment_gateway_paypalstandard', 1, '::1', 0, 1),
(316, 'is_install', '1', 'payment_gateway_paystack', 1, '::1', 0, 1),
(317, 'is_install', '1', 'payment_gateway_razorpay', 1, '::1', 0, 1),
(318, 'is_install', '1', 'payment_gateway_yappy', 1, '::1', 0, 1),
(319, 'is_install', '1', 'payment_gateway_skrill', 1, '::1', 0, 1),
(320, 'is_install', '1', 'payment_gateway_stripe', 1, '::1', 0, 1),
(321, 'is_install', '1', 'payment_gateway_xendit', 1, '::1', 0, 1),
(322, 'is_install', '1', 'payment_gateway_yookassa', 1, '::1', 0, 1),
(323, 'user_session_timeout', '', 'site', 1, '::1', 0, 1),
(324, 'admin-side-logo', '', 'site', 1, '::1', 0, 1),
(325, 'front-side-themes-logo', '', 'site', 1, '::1', 0, 1),
(326, 'front_custom_logo_size', '0', 'site', 1, '::1', 0, 1),
(327, 'front_log_custom_height', '', 'site', 1, '::1', 0, 1),
(328, 'front_log_custom_width', '', 'site', 1, '::1', 0, 1),
(329, 'favicon', '', 'site', 1, '::1', 0, 1),
(330, 'status', '1', 'payment_gateway_store_bank_transfer', 1, '::1', 1, 1),
(331, 'status', '1', 'payment_gateway_store_cod', 1, '::1', 0, 1),
(332, 'status', '1', 'payment_gateway_store_flutterwave', 1, '::1', 0, 1),
(333, 'status', '1', 'payment_gateway_store_paypal', 1, '::1', 0, 1),
(334, 'status', '1', 'payment_gateway_store_paypalstandard', 1, '::1', 0, 1),
(335, 'status', '1', 'payment_gateway_store_paystack', 1, '::1', 0, 1),
(336, 'status', '1', 'payment_gateway_store_razorpay', 1, '::1', 0, 1),
(337, 'status', '1', 'payment_gateway_store_skrill', 1, '::1', 0, 1),
(338, 'status', '1', 'payment_gateway_store_stripe', 1, '::1', 0, 1),
(339, 'status', '1', 'payment_gateway_store_xendit', 1, '::1', 0, 1),
(340, 'status', '1', 'payment_gateway_store_yappy', 1, '::1', 0, 1),
(341, 'status', '1', 'payment_gateway_store_yookassa', 1, '::1', 0, 1),
(342, 'status', '1', 'payment_gateway_deposit_yookassa', 1, '::1', 0, 1),
(343, 'status', '1', 'payment_gateway_deposit_yappy', 1, '::1', 0, 1),
(344, 'status', '1', 'payment_gateway_membership_yappy', 1, '::1', 0, 1),
(345, 'status', '1', 'payment_gateway_membership_yookassa', 1, '::1', 0, 1),
(346, 'status', '1', 'payment_gateway_membership_xendit', 1, '::1', 0, 1),
(347, 'status', '1', 'payment_gateway_deposit_xendit', 1, '::1', 0, 1),
(348, 'status', '1', 'payment_gateway_membership_stripe', 1, '::1', 0, 1),
(349, 'status', '1', 'payment_gateway_deposit_stripe', 1, '::1', 0, 1),
(350, 'status', '1', 'payment_gateway_deposit_skrill', 1, '::1', 0, 1),
(351, 'status', '1', 'payment_gateway_membership_skrill', 1, '::1', 0, 1),
(352, 'status', '1', 'payment_gateway_membership_razorpay', 1, '::1', 0, 1),
(353, 'status', '1', 'payment_gateway_deposit_razorpay', 1, '::1', 0, 1),
(354, 'status', '1', 'payment_gateway_deposit_paystack', 1, '::1', 0, 1),
(355, 'status', '1', 'payment_gateway_membership_paystack', 1, '::1', 0, 1),
(356, 'status', '1', 'payment_gateway_membership_paypalstandard', 1, '::1', 0, 1),
(357, 'status', '1', 'payment_gateway_deposit_paypalstandard', 1, '::1', 0, 1),
(358, 'status', '1', 'payment_gateway_deposit_paypal', 1, '::1', 0, 1),
(359, 'status', '1', 'payment_gateway_membership_paypal', 1, '::1', 0, 1),
(360, 'status', '1', 'payment_gateway_membership_flutterwave', 1, '::1', 0, 1),
(361, 'status', '1', 'payment_gateway_deposit_flutterwave', 1, '::1', 0, 1),
(362, 'status', '1', 'payment_gateway_deposit_cod', 1, '::1', 0, 1),
(363, 'status', '1', 'payment_gateway_membership_cod', 1, '::1', 0, 1),
(364, 'status', '1', 'payment_gateway_membership_bank_transfer', 1, '::1', 1, 1),
(365, 'status', '1', 'payment_gateway_deposit_bank_transfer', 1, '::1', 1, 1),
(366, 'admin_side_bar_color', '#ffffff', 'theme', 1, '::1', 0, 1),
(367, 'admin_side_bar_scroll_color', '#007bff', 'theme', 1, '::1', 0, 1),
(368, 'admin_side_bar_text_color', '#686868', 'theme', 1, '::1', 0, 1),
(369, 'admin_side_bar_text_hover_color', '#007bff', 'theme', 1, '::1', 0, 1),
(370, 'admin_top_bar_color', '#ffffff', 'theme', 1, '::1', 0, 1),
(371, 'admin_footer_color', '#f2f3f5', 'theme', 1, '::1', 0, 1),
(372, 'admin_logo_color', '#007bff', 'theme', 1, '::1', 0, 1),
(373, 'user_side_bar_color', '#ffffff', 'theme', 1, '::1', 0, 1),
(374, 'user_side_bar_text_color', '#3f567a', 'theme', 1, '::1', 0, 1),
(375, 'user_side_bar_clock_text_color', '#085445', 'theme', 1, '::1', 0, 1),
(376, 'user_side_bar_text_hover_color', '#5ec394', 'theme', 1, '::1', 0, 1),
(377, 'user_top_bar_color', '#ffffff', 'theme', 1, '::1', 0, 1),
(378, 'user_footer_color', '#ffffff', 'theme', 1, '::1', 0, 1),
(380, 'user_side_font', 'sans-serif', 'site', 1, '::1', 0, 1),
(381, 'front_side_font', 'sans-serif', 'site', 1, '::1', 0, 1),
(382, 'cart_store_side_font', 'Jost', 'site', 1, '::1', 0, 1),
(383, 'sales_store_side_font', 'PT Sans', 'site', 1, '::1', 0, 1),
(384, 'notification_sound', 'notify2.mp3', 'site', 1, '::1', 0, 1),
(385, 'admin_url', 'admin', 'security', 1, '::1', 0, 1),
(386, 'front_url', '', 'security', 1, '::1', 0, 1),
(387, 'status', '1', 'payment_gateway_store_toyyibpay', 1, '::1', 0, 1),
(388, 'status', '1', 'payment_gateway_deposit_toyyibpay', 1, '::1', 0, 1),
(389, 'status', '1', 'payment_gateway_membership_toyyibpay', 1, '::1', 0, 1),
(390, 'withdrawal_proof', '0', 'withdrawalpayment_bank_transfer', 1, '::1', 0, 1),
(391, 'classified_banner_title', '', 'store', 1, '::1', 0, 1),
(392, 'classified_banner_subtitle', '', 'store', 1, '::1', 0, 1),
(393, 'store_mode', 'cart', 'store', 1, '', 0, 1),
(394, 'admin_button_color', '#3d5674', 'theme', 1, '::1', 0, 1),
(395, 'admin_button_hover_color', '#007bff', 'theme', 1, '::1', 0, 1),
(396, 'user_button_color', '#0d6efd', 'theme', 1, '::1', 0, 1),
(397, 'user_button_hover_color', '#0b5ed7', 'theme', 1, '::1', 0, 1),
(398, 'contact_us_page', '1', 'userdashboard', 1, '', 0, 1),
(399, 'tickets_page', '1', 'userdashboard', 1, '', 0, 1),
(400, 'invitation_link_id', '1', 'userdashboard', 1, '', 0, 1),
(401, 'admin_login_box_background_color', '#7a90a8', 'theme', 1, '::1', 0, 1),
(402, 'admin_login_background_option', '0', 'theme', 1, '::1', 0, 1),
(403, 'admin_login_background_color', '#5e7590', 'theme', 1, '::1', 0, 1),
(404, 'admin-login-background-image', '', 'theme', 1, '::1', 0, 1),
(405, 'show_popup', 'enable', 'welcome', 1, '::1', 0, 1),
(406, 'heading', 'Popup Welcome Title', 'welcome', 1, '::1', 0, 1),
(407, 'video_link', '', 'welcome', 1, '::1', 0, 1),
(408, 'content', 'Popup Welcome Content\r\nPopup Welcome Content\r\nPopup Welcome Content', 'welcome', 1, '::1', 0, 1),
(409, 'mail_send_option', 'enable', 'email', 1, '::1', 0, 1),
(410, 'tickets_filter_status', '', 'site', 1, '::1', 0, 1),
(411, 'default_affiliate_plan_id', '1', 'membership', 1, '::1', 0, 1),
(412, 'default_vendor_plan_id', '2', 'membership', 1, '::1', 0, 1),
(413, 'wallet_auto_withdrawal', '1', 'site', 1, '::1', 0, 1),
(414, 'wallet_auto_withdrawal_days', '45', 'site', 1, '::1', 0, 1),
(415, 'wallet_auto_withdrawal_limit', '1000', 'site', 1, '::1', 0, 1),
(416, 'wallet_min_message_new', 'The minimum limit is', 'site', 1, '::1', 0, 1),
(417, 'wallet_max_amount', '500', 'site', 1, '::1', 0, 1),
(418, 'vendormlmmodule', '1', 'market_vendor', 1, '::1', 0, 1),
(419, 'cookies_consent_mesag', 'We use cookies to improve your browsing experience. By continuing to use our site, you agree to our use of cookies.', 'site', 1, '::1', 0, 1),
(420, 'logo', '', 'store', 1, '::1', 0, 1),
(421, 'store_custom_logo_size', '0', 'store', 1, '::1', 0, 1),
(422, 'store_logo_custom_width', '', 'store', 1, '::1', 0, 1),
(423, 'store_logo_custom_height', '', 'store', 1, '::1', 0, 1),
(424, 'cartimage', '', 'store', 1, '::1', 0, 1),
(425, 'favicon', '', 'store', 1, '::1', 0, 1),
(426, 'hbanimage', '', 'store', 1, '::1', 0, 1),
(427, 'enable_shorten_numbers', '1', 'site', 1, '', 0, 1),
(428, 'cookies_menu', '1', 'site', 1, '', 0, 1),
(429, 'cookies_consent', '1', 'site', 1, '', 0, 1),
(430, 'markettools_status', '1', 'market_tools', 1, '::1', 0, 1),
(431, 'status', '1', 'market_tools', 1, '::1', 0, 1),
(432, 'marketvendorpanelmode', '0', 'market_vendor', 1, '', 0, 1),
(433, 'is_install', '1', 'payment_gateway_toyyibpay', 1, '::1', 0, 1),
(434, 'enable_localhost_protection', '1', 'site', 1, '::1', 0, 1),
(435, 'enable_action_control', '1', 'site', 1, '::1', 0, 1),
(436, 'enable_click_control', '1', 'site', 1, '::1', 0, 1),
(437, 'ai_helper_enabled', '1', 'ai_helper', 1, '', 0, 1),
(441, 'admin_dropdown_text', '#212529', 'theme', 1, '::1', 0, 1),
(442, 'admin_dropdown_hover_bg', '#e3f2fd', 'theme', 1, '::1', 0, 1),
(443, 'admin_dropdown_hover_text', '#1976d2', 'theme', 1, '::1', 0, 1),
(444, 'admin_horizontal_dropdown_bg', '#34495e', 'theme', 1, '::1', 0, 1),
(445, 'admin_horizontal_dropdown_text', '#ffffff', 'theme', 1, '::1', 0, 1),
(446, 'admin_horizontal_dropdown_hover_bg', '#e3f2fd', 'theme', 1, '::1', 0, 1),
(447, 'admin_horizontal_dropdown_hover_text', '#ffffff', 'theme', 1, '::1', 0, 1),
(452, 'admin_topbar_bg', '#34495e', 'theme', 1, '::1', 0, 1),
(453, 'admin_topbar_text', '#ffffff', 'theme', 1, '::1', 0, 1),
(454, 'admin_dropdown_bg', '#ffffff', 'theme', 1, '::1', 0, 1),
(455, 'admin_menu_bg', '#667eea', 'theme', 1, '::1', 0, 1),
(456, 'admin_menu_text', '#ffffff', 'theme', 1, '::1', 0, 1),
(457, 'admin_menu_active', '#ffffff', 'theme', 1, '::1', 0, 1),
(458, 'admin_menu_hover', '#ffffff', 'theme', 1, '::1', 0, 1),
(459, 'admin_dropdown_scrollbar', '#666666', 'theme', 1, '::1', 0, 1),
(460, 'admin_footer_bg', '#1a252f', 'theme', 1, '::1', 0, 1),
(461, 'admin_footer_text', '#ffffff', 'theme', 1, '::1', 0, 1),
(462, 'admin_side_font', 'PT Sans', 'site', 1, '::1', 0, 1),
(463, 'user_top_navbar_bg', '#0d6efd', 'theme', 1, '::1', 0, 1),
(464, 'user_top_navbar_text', '#ffffff', 'theme', 1, '::1', 0, 1),
(465, 'user_top_navbar_button_bg', '#ffffff', 'theme', 1, '::1', 0, 1),
(466, 'user_top_navbar_button_text', '#212529', 'theme', 1, '::1', 0, 1),
(467, 'user_horizontal_menu_bg', '#212529', 'theme', 1, '::1', 0, 1),
(468, 'user_horizontal_menu_text', '#ffffff', 'theme', 1, '::1', 0, 1),
(469, 'user_horizontal_menu_hover_bg', '#0b5ed7', 'theme', 1, '::1', 0, 1),
(470, 'user_horizontal_menu_hover_text', '#ffffff', 'theme', 1, '::1', 0, 1),
(471, 'user_dropdown_bg', '#ffffff', 'theme', 1, '::1', 0, 1),
(472, 'user_dropdown_text', '#212529', 'theme', 1, '::1', 0, 1),
(473, 'user_footer_bg', '#f8f9fa', 'theme', 1, '::1', 0, 1),
(474, 'user_footer_text', '#6c757d', 'theme', 1, '::1', 0, 1),
(475, 'messenger_button_position', 'bottom-right', 'site', 1, '::1', 0, 1),
(476, 'messenger_icon_style', 'icon1', 'site', 1, '::1', 0, 1),
(477, 'telegram_enable', '0', 'site', 1, '::1', 0, 1),
(478, 'frequency_unit_clicks', 'minutes', 'site', 1, '::1', 0, 1),
(479, 'frequency_unit_actions', 'minutes', 'site', 1, '::1', 0, 1),
(480, 'fbmessager_status', '[]', 'site', 1, '::1', 0, 1),
(481, 'telegram_event_user_register', '0', 'site', 1, '::1', 0, 1),
(482, 'telegram_event_new_external_order', '0', 'site', 1, '::1', 0, 1),
(483, 'telegram_event_new_store_order', '0', 'site', 1, '::1', 0, 1),
(484, 'otp_admin_max_attempts', '3', 'security', 1, '::1', 0, 1),
(485, 'otp_admin_cooldown_seconds', '180', 'security', 1, '::1', 0, 1),
(486, 'ai_provider', 'openai', 'ai_helper', 1, '::1', 0, 1),
(487, 'openai_model', 'gpt-3.5-turbo', 'ai_helper', 1, '::1', 0, 1),
(488, 'claude_model', 'claude-3-haiku-20240307', 'ai_helper', 1, '::1', 0, 1),
(489, 'gemini_model', 'gemini-pro', 'ai_helper', 1, '::1', 0, 1),
(490, 'daily_limit_per_user', '50', 'ai_helper', 1, '::1', 0, 1),
(491, 'monthly_limit_per_user', '1000', 'ai_helper', 1, '::1', 0, 1),
(492, 'cost_per_request', '0.02', 'ai_helper', 1, '::1', 0, 1),
(493, 'basic_plan_daily_limit', '10', 'ai_helper', 1, '::1', 0, 1),
(494, 'premium_plan_daily_limit', '100', 'ai_helper', 1, '::1', 0, 1),
(495, 'version', 'v2', 'googlerecaptcha', 1, '::1', 0, 1);

INSERT IGNORE INTO `membership_plans` (`id`, `name`, `type`, `billing_period`, `price`, `special`, `custom_period`, `have_trail`, `free_trail`, `total_day`, `bonus`, `commission_sale_status`, `level_id`, `status`, `user_type`, `campaign`, `product`, `description`, `plan_icon`, `label_text`, `label_background`, `label_color`, `sort_order`, `updated_at`, `created_at`) VALUES
(1, 'Affiliate Plan', 'paid', 'monthly', 5, 3, 0, 0, 0, 30, 1, 0, 0, 1, 1, NULL, NULL, '<p>Affiliate Plan</p><p>Affiliate Plan</p><p>Affiliate Plan<br></p>', NULL, 'Affiliate Plan', '#0000FF', '#FFFDF5', 0, '2023-02-14 10:49:00', '2023-02-14 10:49:00'),
(2, 'Vendor Plan', 'paid', 'monthly', 10, 7, 0, 0, 0, 30, 2, 0, 0, 1, 2, 5, 5, '<p>Vendor Plan</p><p>Vendor Plan</p><p>Vendor Plan</p><p>Vendor Plan<br></p>', NULL, 'Vendor Plan', '#0000FF', '#F8FFE3', 0, '2023-02-14 10:51:00', '2023-02-14 10:51:00');

INSERT IGNORE INTO `categories` (`id`, `name`, `slug`, `description`, `image`, `background_image`, `color`, `parent_id`, `tag`, `created_at`) VALUES
(1, 'General', 'testrrr-10', '<p>General</p>', '', '', '#FFFFFF', 0, 1, '2022-07-16 12:13:44');

INSERT IGNORE INTO `integration_category` (`id`, `parent_id`, `name`, `created_at`) VALUES
(1, 0, 'General', '2022-07-17 11:03:43');

INSERT IGNORE INTO `tickets_subject` (`id`, `subject`, `user_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 'General', 1, '1', '2022-07-15 20:13:12', NULL);

INSERT IGNORE INTO `theme_pages` (`page_id`, `theme_id`, `page_name`, `slug`, `parent_id`, `top_banner_title`, `top_banner_sub_title`, `page_content_title`, `page_content`, `link_footer_section`, `is_header_menu`, `is_header_dropdown`, `position`, `page_type`, `page_banner_image`, `created`, `status`, `language_id`) VALUES
(1, 0, 'Home', '/', 0, '', '', '', '', '', 1, 0, 1, 'fixed', NULL, '2021-03-15 05:34:48', 1, 1),
(2, 0, 'Faq', 'faq', 0, '', '', '', '', '', 1, 0, 2, 'fixed', NULL, '2021-03-15 05:40:51', 1, 1),
(3, 0, 'Terms', 'terms-of-use', NULL, '', '', '', '', '', 1, 0, 3, 'fixed', NULL, '2021-03-15 05:46:09', 1, 1),
(4, 0, 'Contact', 'contact', NULL, '', '', '', '', '', 1, 0, 4, 'fixed', NULL, '2021-03-15 05:48:16', 1, 1);

INSERT IGNORE INTO `mail_templates` (`id`, `unique_id`, `name`, `subject`, `text`, `admin_subject`, `client_subject`, `client_text`, `admin_text`, `shortcode`) VALUES
(1, '', 'User Registration', 'User Registration Successfully', '<p>Dear [[firstname]],</p>\r\n\r\n<p>Your new affiliate user account has been created welcome to the [[website_name]]</p>\r\n\r\n<p>your account details:</p>\r\n\r\n<p>================</p>\r\n\r\n<p>[[firstname]]</p>\r\n\r\n<p>[[username]]</p>\r\n\r\n<p>[[email]]</p>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', 'Admin : New affiliate user Register', NULL, NULL, '<p>Dear Admin,</p>\r\n\r\n<p>&nbsp;New affiliate user Register on your site&nbsp;[[website_name]]</p>\r\n\r\n<p>Affiliate details:</p>\r\n\r\n<p>============</p>\r\n\r\n<p>[[firstname]]</p>\r\n\r\n<p>[[username]]</p>\r\n\r\n<p>[[email]]</p>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', 'firstname,lastname,email,username,website_name,website_logo'),
(2, '', 'Client Registration', 'New Client Register Under you', '<p>Dear [[firstname]],</p>\r\n\r\n<p>New client account has been created under you</p>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', 'Admin : New Client Register', 'Dear [[firstname]], Welcome To Our Store', '<p>Dear [[firstname]],</p>\r\n\r\n<p>welcome to the [[website_name]]</p>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', '<p>Dear Admin,</p>\r\n\r\n<p>New client has been registered on your store</p>\r\n\r\n<p>[[firstname]] ,&nbsp;[[lastname]]&nbsp;</p>\r\n\r\n<p>[[email]] | [[username]]</p>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', 'firstname,lastname,email,username,website_name,website_logo'),
(3, '', 'Forget Password', 'User Forget Password', '<p>Dear [[firstname]],</p>\r\n\r\n<p>You recently request to reset your password from your [[website_name]] account click the below link to reset password</p>\r\n\r\n<p>[[reset_link]]</p>\r\n\r\n<p>If you did not request a password rest, please ignore this email or reply us know.</p>\r\n\r\n<p>[[website_name]]</p>\r\n\r\n<p>If you did not request a password rest, please ignore this email or reply us know.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Thanks<br />\r\n[[website_name]]</p>\r\n', 'Admin : Forget Password', 'Client : Forget Password', '<p>Dear [[firstname]],</p>\r\n\r\n<p>You recently request to reset your password from your [[website_name]] account click the below link to reset password</p>\r\n\r\n<p>[[reset_link]]</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>If you did not request a password rest, please ignore this email or reply us know.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Thanks<br />\r\n[[website_name]]</p>\r\n', '<p>Dear [[firstname]],</p>\r\n\r\n<p>You recently request to reset your password from your [[website_name]] account click the below link to reset password</p>\r\n\r\n<p>[[reset_link]]</p>\r\n\r\n<p>If you did not request a password rest, please ignore this email or reply us know.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Thanks<br />\r\n[[website_name]]</p>\r\n', 'reset_link,firstname,lastname,email,username,website_name,website_logo'),
(4, '', 'Send Wallet withdrawal Request', 'Send Wallet Withdrawal Request', '<p>Dear [[name]],</p>\r\n\r\n<p>Your withdrawal request is accept successfully and procced shortly</p>\r\n\r\n<p>Amount : [[amount]]</p>\r\n\r\n<p>Thanks<br />\r\n[[website_name]]</p>\r\n', 'Admin : Send Wallet Withdrawal Request', '', '', '<p>Dear [[name]],</p>\r\n\r\n<p>Your withdrawal request is accept successfully and procced shortly</p>\r\n\r\n<p>Amount : [[amount]]</p>\r\n\r\n<p>Thanks<br />\r\n[[website_name]]</p>\r\n', 'amount,comment,name,user_email,commission_type,website_name,website_logo'),
(5, '', 'withdrawal request status change', 'Your withdrawal request status change', '<p>Dear [[name]],</p>\r\n\r\n<p>Your withdrawal request status has been change to : <strong>[[new_status]]</strong></p>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', 'Admin side', '', '', '<p>Dear [[name]],</p>\r\n\r\n<p>Withdrawal request status has been change to : <strong>[[new_status]]</strong></p>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', 'amount,comment,name,user_email,commission_type,website_name,website_logo,new_status'),
(6, '', 'Store Contact Us', '', '', 'Admin : Store Contact Us', 'We will contact to you shortly ..!', '<p>&nbsp;</p>\r\n\r\n<p><strong>Name </strong>: [[name]]</p>\r\n\r\n<p><strong>Email </strong>: [[email]]</p>\r\n\r\n<p><strong>Phone </strong>: [[phone]]</p>\r\n\r\n<p><strong>Message</strong> :</p>\r\n\r\n<p>[[message]]</p>\r\n\r\n<p>&nbsp;</p>\r\n', '<p>Hey Admin <strong>[[name]] </strong>trying to contact you.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Name </strong>: [[name]]</p>\r\n\r\n<p><strong>Email </strong>: [[email]]</p>\r\n\r\n<p><strong>Phone </strong>: [[phone]]</p>\r\n\r\n<p><strong>Message</strong> :</p>\r\n\r\n<p>[[message]]</p>\r\n\r\n<p>&nbsp;</p>\r\n', 'name,email,phone,message,website_name,website_logo'),
(7, '', 'Order Status Has Been Change', 'Your Order Status Has Been Change', '<p>Hello<strong>&nbsp;[[firstname]] [[lastname]]</strong></p>\r\n\r\n<p>Your Order Status Has Been Change to <strong>[[status]]</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>[[comment]]</p>\r\n\r\n<p><br />\r\norder Id :<strong> [[order_id]]</strong></p>\r\n', 'Admin : Your Order Status Has Been Change', 'Client: Your Order Status Has Been Change', '<p>Hello<strong>&nbsp;[[firstname]] [[lastname]]</strong></p>\r\n\r\n<p>Your Order Status Has Been Change to <strong>[[status]]</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>[[comment]]</p>\r\n\r\n<p><br />\r\norder Id :<strong> [[order_id]]</strong></p>\r\n', '<p>Hello<strong>&nbsp;[[firstname]] [[lastname]]</strong></p>\r\n\r\n<p>Your Order Status Has Been Change to <strong>[[status]]</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>[[comment]]</p>\r\n\r\n<p><br />\r\norder Id :<strong> [[order_id]]</strong></p>\r\n', 'order_id,status,order_link,product_name,product_description,commission_type,PhoneNumber,firstname,lastname,commission,total,currency_code,txn_id,website_name,website_logo,comment'),
(8, '', 'New Order', 'Affiliate: New Order Commission From [[firstname]] [[lastname]]', '<p>Hello Affiliate,</p>\r\n\r\n<p>you got new order Commission from sale thats done under [[firstname]] [[lastname]]</p>\r\n\r\n<p>Commission: [[commission]] -&nbsp;[[commission_type]]</p>\r\n\r\n<p><strong>Commission for product_name :&nbsp;</strong>[[product_name]]&nbsp;[[variation_details]]</p>\r\n\r\n<p><strong>product_description</strong> : [[product_description]]</p>\r\n', 'Admin : New Order [[order_id]] has been successfully placed.', 'Client : New Order [[order_id]] has been successfully placed.', '<p>Dear Client,</p>\r\n\r\n<p>New Order <strong>[[order_id]] </strong>has been successfully placed on your site [[website_name]] .</p>\r\n\r\n<p><strong>Order Status</strong> : [[status]]<br />\r\n<strong>Total Amount</strong> : [[total]]<br />\r\n<strong>Transaction ID</strong> : [[txn_id]]</p>\r\n\r\n<p>[[order_link]]</p>\r\n', '<p>Dear Admin,</p>\r\n\r\n<p>New Order <strong>[[order_id]] </strong>has been successfully placed on your site [[website_name]] .</p>\r\n\r\n<p><strong>Order Status</strong> : [[status]]<br />\r\n<strong>Total Amount</strong> : [[total]]<br />\r\n<strong>Transaction ID</strong> : [[txn_id]]</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>[[order_link]]</p>\r\n', 'order_id,status,order_link,product_name,variation_details,product_description,commission_type,PhoneNumber,firstname,lastname,commission,total,currency_code,txn_id,website_name,website_logo,order_id'),
(10, '', 'get market click notification', 'Get market click notification', '<p>Dear [[name]],</p>\r\n\r\n<p>[[firstname]] [[lastname]] got commition from market [[affiliateads_type]] click</p>\r\n\r\n<p>Commition : [[affiliate_commission]]</p>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', 'Admin : Get market click notification', '', '', '<p>Dear [[name]],</p>\r\n\r\n<p>[[firstname]] [[lastname]] got commition from market [[affiliateads_type]] click</p>\r\n\r\n<p>Commition : [[affiliate_commission]]</p>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', 'affiliateads_type,affiliate_commission,firstname,lastname,email,username,website_name,website_logo'),
(11, '', 'External Website New Order', 'External Website New Order [[external_website_name]]', '<p>Hey&nbsp;[[username]]</p>\r\n\r\n<p>You have got&nbsp;[[commission]] from [[external_website_name]]</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Thanks&nbsp;</strong></p>\r\n\r\n<p>[[website_name]]</p>\r\n', 'External Website New Order [[external_website_name]]', '', '', '<p>Hey New Order Placed at&nbsp;[[external_website_name]]</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>User </strong>:&nbsp;[[username]]</p>\r\n\r\n<p><strong>Website </strong>:&nbsp;[[external_website_name]]</p>\r\n\r\n<p><strong>commission </strong>: [[commission]]</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Thanks&nbsp;</strong></p>\r\n\r\n<p>[[website_name]]</p>\r\n', 'external_website_name,commission,username,website_name,website_logo,product_ids,total,currency,commission_type,script_name'),
(12, '', 'wallet status change to in wallet', '[[amount]] credited in your wallet', '<p>Dear [[name]],</p>\r\n\r\n<p>[[comment]]</p>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', '', '', '', '', 'amount,comment,name,user_email,website_name,website_logo,new_status'),
(13, '', 'User Registration From Integration', 'User Registration Successfully', '<p>Dear [[firstname]],</p>\r\n\r\n<p>Your new affiliate user account has been created welcome to the [[website_name]]</p>\r\n\r\n<p>your account details:</p>\r\n\r\n<p>================</p>\r\n\r\n<p>[[firstname]]</p>\r\n\r\n<p>[[username]]</p>\r\n\r\n<p>[[email]]</p>\r\n\r\n<h2>password is :&nbsp;<strong>[[password]]</strong></h2>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', 'Admin : New affiliate user Register From Integration', '', '', '<p>Dear Admin,</p>\r\n\r\n<p>&nbsp;New affiliate user Register on your site&nbsp;[[website_name]]</p>\r\n\r\n<p>Affiliate details:</p>\r\n\r\n<p>============</p>\r\n\r\n<p>[[firstname]]</p>\r\n\r\n<p>[[username]]</p>\r\n\r\n<p>[[email]]</p>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', 'firstname,lastname,email,username,password,website_name,website_logo'),
(36, 'new_order_for_vendor', 'Vendor Got New Order', 'Vendor: You have new order from [[firstname]] [[lastname]]', '<p>Hello Vendor,</p>\r\n                    <p>you got new order from [[firstname]] [[lastname]]</p>\r\n                    <p>Commission: [[vendor_commission]] </p>\r\n                    <p>Order Status: [[status]] </p>\r\n                    <p><strong>Commission for product_name :&nbsp;</strong>[[product_name]]</p>\r\n                    [[website_name]]<br />\r\n                            Support Team</p>\r\n                ', '', '', '', '', 'vendor_firstname,vendor_lastname,vendor_commission,order_id,status,order_link,product_name,PhoneNumber,firstname,lastname,commission,total,currency_code,txn_id,website_name,website_logo,order_id'),
(37, 'vendor_form_status_1', 'Vendor Form Status Change To Approved', 'Form Status Change To Approved', '<p>Dear, [[username]]</p>\r\n                                <p>Form Status Change to Approved</p>\r\n                                <p>Name [[title]]</p>\r\n                                <p><br />\r\n                            [[website_name]]<br />\r\n                            Support Team</p>\r\n                        ', '', '', '', '', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,title'),
(38, 'vendor_create_product', 'Vendor Create new product', '', '', 'New Product Created By Vendor', '', '', '<p>Dear Admin,</p>\r\n                                <p>New Product has been created</p>\r\n                                <p>Name [[product_name]]</p>\r\n                                <p>Username [[username]]</p>\r\n                                <p><br />\r\n                            [[website_name]]<br />\r\n                            Support Team</p>\r\n                        ', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,product_name,product_short_description,product_price,product_sku,product_id'),
(39, 'vendor_product_status_1', 'Vendor Product Status Change To Approved', 'Product Status Change To Approved', '<p>Dear, [[username]]</p>\r\n                                <p>Product Status Change to Approved</p>\r\n                                <p>Name [[product_name]]</p>\r\n                                <p><br />\r\n                            [[website_name]]<br />\r\n                            Support Team</p>\r\n                        ', '', '', '', '', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,product_name,product_short_description,product_price,product_sku,product_id'),
(40, 'vendor_create_form', 'Vendor Create new product', '', '', 'New Form Created By Vendor', '', '', '<p>Dear Admin,</p>\r\n                                <p>New Form has been created</p>\r\n                                <p>Name [[title]]</p>\r\n                                <p>Username [[username]]</p>\r\n                                <p><br />\r\n                            [[website_name]]<br />\r\n                            Support Team</p>\r\n                        ', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,title'),
(41, 'vendor_form_status_0', 'Vendor Form Status Change To In Review', 'Form Status Change To In Review', '<p>Dear,</p>\r\n                                <p>Form Status Change to In Review</p>\r\n                                <p>Name [[title]]</p>\r\n                                <p><br />\r\n                            [[website_name]]<br />\r\n                            Support Team</p>\r\n                        ', 'Form Status Change To In Review', '', '', '<p>Dear,</p>\r\n                                <p>Form Status Change to In Review</p>\r\n                                <p>Name [[title]]</p>\r\n                                <p><br />\r\n                            [[website_name]]<br />\r\n                            Support Team</p>\r\n                        ', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,title'),
(42, 'vendor_form_status_2', 'Vendor Form Status Change To Denied', 'Form Status Change To Denied', '<p>Dear, [[username]]</p>\r\n                                <p>Form Status Change to Denied</p>\r\n                                <p>Name [[title]]</p>\r\n                                <p><br />\r\n                            [[website_name]]<br />\r\n                            Support Team</p>\r\n                        ', '', '', '', '', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,title'),
(43, 'vendor_order_status_complete', 'Vendor Order Status Has Been Change', 'Vendor: New Order Commission From [[firstname]] [[lastname]]', '<p>Hello Vendor,</p>\r\n                    <p>you got new order Sale Commission from sale thats done under [[firstname]] [[lastname]]</p>\r\n                    <p>Commission: [[vendor_commission]] </p>\r\n                    <p><strong>Commission for product_name :&nbsp;</strong>[[product_name]]</p>\r\n                    [[website_name]]<br />\r\n                            Support Team</p>\r\n                ', '', '', '', '', 'vendor_firstname,vendor_lastname,vendor_commission,order_id,status,order_link,product_name,commission_type,PhoneNumber,firstname,lastname,commission,total,currency_code,txn_id,website_name,website_logo,order_id'),
(45, 'vendor_create_program', 'Vendor Create new product', '', '', 'New Program Created By Vendor : [[name]]', '', '', '<p>Dear Admin,</p>\r\n                    <p>New Program has been created</p>\r\n                    <p>Name [[name]]</p>\r\n                    <p>Username [[username]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,name'),
(46, 'vendor_program_status_2', 'Vendor Program Status Change To Denied', 'Program Status Change To Denied', '<p>Dear,</p>\r\n                    <p>Program Status Change to Denied</p>\r\n                    <p>Name [[name]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'Program Status Change To Denied', '', '', '<p>Dear,</p>\r\n                    <p>Program Status Change to Denied</p>\r\n                    <p>Name [[name]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,name'),
(47, 'vendor_program_status_3', 'Vendor Program Status Change To Ask To Edit', 'Program Status Change To Ask To Edit', '<p>Dear,</p>\r\n                    <p>Program Status Change to Ask To Edit</p>\r\n                    <p>Name [[name]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'Program Status Change To Ask To Edit', '', '', '<p>Dear,</p>\r\n                    <p>Program Status Change to Ask To Edit</p>\r\n                    <p>Name [[name]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,name'),
(48, 'vendor_program_status_0', 'Vendor Program Status Change To In Review', 'Program Status Change To In Review', '<p>Dear,</p>\r\n                    <p>Program Status Change to In Review</p>\r\n                    <p>Name [[name]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'Program Status Change To In Review', '', '', '<p>Dear,</p>\r\n                    <p>Program Status Change to In Review</p>\r\n                    <p>Name [[name]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,name'),
(49, 'vendor_program_status_1', 'Vendor Program Status Change To Approved', 'Program Status Change To Approved', '<p>Dear,</p>\r\n                    <p>Program Status Change to Approved</p>\r\n                    <p>Name [[name]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'Program Status Change To Approved', '', '', '<p>Dear,</p>\r\n                    <p>Program Status Change to Approved</p>\r\n                    <p>Name [[name]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,name'),
(51, 'vendor_create_ads', 'Vendor Create Ads (Banner, Text, Link, Video)', '', '', 'New Ads ([[type]]) Created By Vendor', '', '', '<p>Dear Admin,</p>\r\n                    <p>New Ads - [[type]] has been created</p>\r\n                    <p>Name [[name]]</p>\r\n                    <p>Username [[username]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,name,type,tool_type'),
(52, 'vendor_ads_status_1', 'Vendor Ads (Banner, Text, Link, Video) Status Change To Approved', 'Ads ([[type]]) Status Change To Approved', '<p>Dear</p>\r\n                    <p>Ads - [[type]] Status Change to Approved </p>\r\n                    <p>Name [[name]]</p>\r\n                    <p>Username [[username]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'Ads ([[type]]) Status Change To Approved', '', '', '<p>Dear</p>\r\n                    <p>Ads - [[type]] Status Change to Approved </p>\r\n                    <p>Name [[name]]</p>\r\n                    <p>Username [[username]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,name,type,tool_type'),
(53, 'vendor_ads_status_0', 'Vendor Ads (Banner, Text, Link, Video) Status Change To In Review', 'Ads ([[type]]) Status Change To In Review', '<p>Dear</p>\r\n                    <p>Ads - [[type]] Status Change to In Review </p>\r\n                    <p>Name [[name]]</p>\r\n                    <p>Username [[username]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'Ads ([[type]]) Status Change To In Review', '', '', '<p>Dear</p>\r\n                    <p>Ads - [[type]] Status Change to In Review </p>\r\n                    <p>Name [[name]]</p>\r\n                    <p>Username [[username]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,name,type,tool_type'),
(54, 'vendor_ads_status_3', 'Vendor Ads (Banner, Text, Link, Video) Status Change To Ask To Edit', 'Ads ([[type]]) Status Change To Ask To Edit', '<p>Dear</p>\r\n                    <p>Ads - [[type]] Status Change to Ask To Edit</p>\r\n                    <p>Name [[name]]</p>\r\n                    <p>Username [[username]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'Ads ([[type]]) Status Change To Ask To Edit', '', '', '<p>Dear</p>\r\n                    <p>Ads - [[type]] Status Change to Ask To Edit</p>\r\n                    <p>Name [[name]]</p>\r\n                    <p>Username [[username]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', 'admin_last_message,vendor_last_message,firstname,lastname,email,username,website_name,website_logo,name,type,tool_type'),
(55, 'order_on_vendor_program', 'New Order in Vendor Program', 'New Order Create In Your Program', '<p>Dear Vendor,</p>\r\n                    <p>New Order Created under your Program</p>\r\n                    <p><b>Website</b> : [[external_website_name]]</p>\r\n                    <p><b>Total</b> : [[total]]</p>\r\n                    <p><br />\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', '', '', '', '', 'external_website_name,commission,username,website_name,website_logo,product_ids,total,currency,commission_type,script_name'),
(57, 'withdrwal_status_change', 'Withdrawal Request Status Changed', 'Withdrawal Request Status Changed', '<p>Dear,</p>\r\n                <p>Your Withdrawal Request #([[request_id]]) Status has been change to <b><i>[[status]]</i></b></p>\r\n\r\n                    <p>Comment: [[comment]] </p>\r\n                [[website_name]]<br />\r\n                Support Team</p>\r\n            ', '', NULL, NULL, '', 'comment,status,request_id,firstname,lastname,email,username,website_name,website_logo,name'),
(59, 'send_register_mail_api', 'User Registration (API)', 'Your Account Created Successfully On [[website_name]]', '<p>Welcome to [[website_name]]</p>\r\n\r\n<p>Dear [[firstname]],</p>\r\n\r\n<p>Thanks for signing up [[website_name]].</p>\r\n\r\n<p>Your&nbsp;Login&nbsp;credentials:</p>\r\n\r\n<p>Username:&nbsp;<strong>[[username]]</strong><br />\r\nPassword:&nbsp;<strong>*******</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><a href=\"[[website_url]]\">Login To [[website_name]]</a></p>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', 'User Registration Successfully', NULL, NULL, '<p>Dear Admin,</p>\r\n\r\n<p>New affiliate user Register on your site&nbsp;[[website_name]]</p>\r\n\r\n<p>Affiliate details:</p>\r\n\r\n<p>============</p>\r\n\r\n<p>[[firstname]]</p>\r\n\r\n<p>[[username]]</p>\r\n\r\n<p>[[email]]</p>\r\n\r\n<p><br />\r\n[[website_name]]<br />\r\nSupport Team</p>\r\n', 'firstname,lastname,email,username,website_url,website_name,website_logo,name'),
(63, 'subscription_status_change', 'Subscription Status Changed', 'Subscription Status Changed', '<p>Dear [[firstname]],</p>\r\n                <p>Your subscription status has been changed to [[status_text]]</p>\r\n                <p>Comment: [[comment]] </p>\r\n                [[website_name]]<br />\r\n                Support Team</p>', '', NULL, NULL, '', 'comment,planname,price,expire_at,started_at,status_text,firstname,lastname,email,username,website_url,website_name,website_logo,name'),
(64, 'subscription_buy', 'Subscription Buy', 'Subscription Buy', '<h2>Thanks for your order</h2>\r\n\r\n<p>Welcome to Prime. As a Prime member, enjoy these great benefits. If you have any questions, call us any time at or simply reply to this email.</p>\r\n', 'New Subscription Buy From [[firstname]] [[lastname]]', NULL, NULL, '<h2>Thanks for your order</h2>\r\n\r\n<p>Welcome to Prime. As a Prime member, enjoy these great benefits. If you have any questions, call us any time at or simply reply to this email.</p>\r\n', 'planname,price,expire_at,started_at,firstname,lastname,email,username,website_url,website_name,website_logo,name'),
(65, 'subscription_expire_notification', 'Subscription Expire Notification', 'Your Subscription Will Be Expired Soon.', '<p>customText</p>\r\n', NULL, NULL, NULL, NULL, 'planname,price,expire_at,started_at,firstname,lastname,email,username,website_url,website_name,website_logo,name'),
(66, 'wallet_noti_on_hold_wallet', 'Wallet Status Change To On Hold', '[[amount]] is put on hold in your wallet', '<p>Dear [[name]],</p>\n        <p>Transactions #[[id]] status changed to [[new_status]]. amount is [[amount]]</p>\n        <p><br />\n        [[website_name]]<br />\n        Support Team</p>\n', '', NULL, NULL, NULL, 'amount,id,name,new_status,user_email,website_name,website_logo,name'),
(67, 'new_user_request', 'New User Request', 'User Registration Successfull', '<p>Dear [[firstname]] [[lastname]],</p>\r\n\r\n<p>User account has been registered successfully on [[website_name]], please wait while system admin apporve&nbsp;your request.<br />\r\nWe will inform you once account has been approved, Thank You.</p>\r\n\r\n<p>Support Team<br />\r\n[[website_name]]</p>\r\n', 'New User Registration - Approval Pending', NULL, NULL, '<p>Dear Admin,</p>\r\n\r\n<p>New user has been registered on [[website_name]], apporval is pending yet!</p>\r\n\r\n<p>User Details</p>\r\n\r\n<p>Name : [[firstname]][[lastname]]<br />\r\nEmail :&nbsp;[[email]]<br />\r\nUsername : [[username]]<br />\r\nSupport Team<br />\r\n[[website_name]]</p>', 'firstname,lastname,email,username,website_name,website_logo'),
(68, 'new_user_approved', 'New User Request Approved', 'User Account Approved', '<p>Dear [[firstname]] [[lastname]],</p>\r\n\r\n<p>Your new user account registration request is accepted by admin, you can login and use services.</p>\r\n\r\n<p>[[website_name]]<br />\r\nSupport Team</p>\r\n', 'User Account Approved', NULL, NULL, '<p>Dear Admin,</p>\r\n\r\n<p>You have approced registration request of user having</p>\r\n\r\n<p>Name : [[firstname]]&nbsp;[[lastname]]</p>\r\n\r\n<p>Email : [[email]]</p>\r\n\r\n<p>Username : [[username]]</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Support Team</p>\r\n\r\n<p>[[website_name]]</p>\r\n', 'firstname,lastname,email,username,website_name,website_logo'),
(69, 'new_user_declined', 'New User Request Declined', 'User Account Declined', '<p>Dear [[firstname]] [[lastname]],</p>\r\n\r\n<p>Your new user account registration request is declined by admin, for more information please contact supprt team</p>\r\n\r\n<p>[[website_name]]<br />\r\nSupport Team</p>\r\n', 'User Account Declined', NULL, NULL, '<p>Dear Admin,</p>\r\n\r\n<p>You have declined registration request of user having</p>\r\n\r\n<p>Name : [[firstname]]&nbsp;[[lastname]]</p>\r\n\r\n<p>Email : [[email]]</p>\r\n\r\n<p>Username : [[username]]</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Support Team</p>\r\n\r\n<p>[[website_name]]</p>\r\n', 'firstname,lastname,email,username,website_name,website_logo'),
(70, 'new_vendor_deposit_request', 'New Vendor Deposit Request', 'New Deposit Request Added', '<p>Dear [[firstname]] [[lastname]],</p>\r\n\r\n<p>Your deposit request of amount [[amount]] is added, if your balance not updated please contact support team</p>\r\n\r\n<p>[[website_name]]<br /> \r\n Support Team</p>', 'New Deposit Request Added', '', '', '<p>Dear Admin,</p>\r\n\r\n<p>You have new deposit request of amount [[amount]] from vendor having</p>\r\n\r\n<p>Name : [[firstname]]&nbsp;[[lastname]]</p>\r\n\r\n<p>Email : [[email]]</p>\r\n\r\n<p>Username : [[username]]</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Support Team</p>\r\n\r\n<p>[[website_name]]</p>', 'status,amount,firstname,lastname,email,username,website_name,website_logo'),
(71, 'vendor_deposit_request_updated', 'Deposit Request Updated', 'Deposit Request Updated', '<p>Dear [[firstname]] [[lastname]],</p>\r\n\r\n<p>Your deposit request of amount [[amount]] is updated to [[status]], if have any queries please contact support team</p>\r\n\r\n<p>[[website_name]]<br /> \r\n Support Team</p>', 'Deposit Request Updated', '', '', '<p>Dear Admin,</p>\r\n\r\n<p>You have changed status of deposit request to [[status]] from vendor having</p>\r\n\r\n<p>Name : [[firstname]]&nbsp;[[lastname]]</p>\r\n\r\n<p>Email : [[email]]</p>\r\n\r\n<p>Username : [[username]]</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Support Team</p>\r\n\r\n<p>[[website_name]]</p>', 'status,amount,firstname,lastname,email,username,website_name,website_logo'),
(72, 'user_level_changed', 'Change user level', 'Your user level changed', '<p>Dear,</p><p>Your level changed from [[from_level]] to [[to_level]]</p>                     <p><br>                 [[website_name]]<br>                 Support Team</p>             ', '', '', '', '', 'from_level,to_level,website_name'),
(73, 'ticket_created_email', 'Ticket Created Email', 'New ticket #[[ticket_id]] has been created', '<p>Dear [[firstname]],&nbsp;</p><p><br></p><p>Your ticket has been created successfully on the system. Please note down below the ticket number for future reference.</p><p><br></p><p>Ticket ID:</p><p><span style=\"font-size: 1rem;\">[[ticket_id]]</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">Ticket Status:</span><br></p><p><span style=\"font-size: 1rem;\">[[ticket_status]]</span><br></p><p><br></p><p><br></p><p>Subject :</p><p><span style=\"font-size: 1rem;\">[[ticket_subject]]</span><br></p><p><br></p><p><br></p><p>Message:</p><p><span style=\"font-size: 1rem;\">[[ticket_body]]</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">We will contact you very soon.</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">Thank You</span><br></p><p><span style=\"font-size: 1rem;\">Support Team</span><br></p>', 'New user ticket #[[ticket_id]] has been created', '', '', '<p>Dear Admin, </p><p><br></p><p>The user has created a new ticket on your site [[website_name]]. <br></p><p><br></p><p>Username:</p><p><span style=\"font-size: 1rem;\">[[username]]</span><br></p><p><br></p><p>Email:</p><p><span style=\"font-size: 1rem;\">[[email]]</span><br></p><p><br></p><p>Name:</p><p><span style=\"font-size: 1rem;\">[[firstname]] [[lastname]]</span><br></p><p><br></p><p>Ticket ID:</p><p><span style=\"font-size: 1rem;\">[[ticket_id]]</span><br></p><p><br></p><p>Ticket Status:</p><p><span style=\"font-size: 1rem;\">[[ticket_status]]</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">Subject :</span><br></p><p><span style=\"font-size: 1rem;\">[[ticket_subject]]</span><br></p><p><br></p><p><br></p><p>Message:</p><p><span style=\"font-size: 1rem;\">[[ticket_body]]</span><br></p><p><br></p><p><br></p><p>Thank You</p><p><span style=\"font-size: 1rem;\">[[website_name]]</span><br></p><p><br></p>', 'ticket_id,ticket_status,ticket_subject,ticket_body,ticket_datetime,firstname,lastname,email,username,website_name,website_logo'),
(74, 'ticket_reply_email', 'Ticket Replied Email', 'You have a new reply on ticket #[[ticket_id]]', '<p>Dear [[firstname]], </p><p><br></p><p>You have a reply from the support team on your ticket #[[ticket_id]]</p><p><br></p><p>Ticket ID:</p><p><span style=\"font-size: 1rem;\">[[ticket_id]]</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">Ticket Status:</span><br></p><p><span style=\"font-size: 1rem;\">[[ticket_status]]</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">Subject :</span><br></p><p><span style=\"font-size: 1rem;\">[[ticket_subject]]</span><br></p><p><br></p><p>Message from the support team<br></p><p><span style=\"font-size: 1rem;\">[[ticket_reply_message]]</span></p><p><span style=\"font-size: 1rem;\"><br></span></p><p><span style=\"font-size: 1rem;\">Time</span></p><p><span style=\"font-size: 1rem;\">[[reply_datetime]]</span></p><p><span style=\"font-size: 1rem;\"><br></span></p><p><span style=\"font-size: 1rem;\">Thank You</span><br></p>', 'User added a new reply on ticket #[[ticket_id]]', '', '', '<p>Dear Admin, </p><p><br></p><p>User added a new reply on ticket #[[ticket_id]]</p><p><br></p><p>Username:</p><p><span style=\"font-size: 1rem;\">[[username]]</span><br></p><p><br></p><p>Email:</p><p><span style=\"font-size: 1rem;\">[[email]]</span><br></p><p><br></p><p>Name:</p><p><span style=\"font-size: 1rem;\">[[firstname]] [[lastname]]</span></p><p><br></p><p>Ticket ID:</p><p><span style=\"font-size: 1rem;\">[[ticket_id]]</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">Ticket Status:</span><br></p><p><span style=\"font-size: 1rem;\">[[ticket_status]]</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">Subject :</span><br></p><p><span style=\"font-size: 1rem;\">[[ticket_subject]]</span><br></p><p><br></p><p>Message from user<br></p><p><span style=\"font-size: 1rem;\">[[ticket_reply_message]]</span></p><p><span style=\"font-size: 1rem;\"><br></span></p><p><span style=\"font-size: 1rem;\">Time</span></p><p><span style=\"font-size: 1rem;\">[[reply_datetime]]</span></p><p><span style=\"font-size: 1rem;\"><br></span></p><p><span style=\"font-size: 1rem;\">Thank You</span></p>', 'ticket_id,ticket_status,ticket_subject,ticket_body,ticket_reply_message,reply_datetime,firstname,lastname,email,username,website_name,website_logo'),
(75, 'ticket_status_email', 'Ticket Status Change Email', 'Ticket #[[ticket_id]] status has been updated', '<p>Dear [[firstname]],&nbsp;</p><p><br></p><p>The status of a ticket having id [[ticket_id]] has been updated, please log in to [[website_name]] to see full details of the ticket.</p><p><br></p><p>Ticket ID:</p><p><span style=\"font-size: 1rem;\">[[ticket_id]]</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">Ticket Status:</span><br></p><p><span style=\"font-size: 1rem;\">[[ticket_status]]</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">Subject :</span><br></p><p><span style=\"font-size: 1rem;\">[[ticket_subject]]</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">Thank You</span></p><p><span style=\"font-size: 1rem;\">Support Team<br></span><br></p>', 'Ticket #[[ticket_id]] status has been updated', '', '', '<p>Dear Admin,&nbsp;</p><p><br></p><p>The status of the ticket having id [[ticket_id]] has been updated.</p><p><br></p><p>Username:</p><p><span style=\"font-size: 1rem;\">[[username]]</span><br></p><p><br></p><p>Email:</p><p><span style=\"font-size: 1rem;\">[[email]]</span><br></p><p><br></p><p>Name:</p><p><span style=\"font-size: 1rem;\">[[firstname]] [[lastname]]</span></p><p><span style=\"font-size: 1rem;\"><br></span></p><p>Ticket ID:</p><p><span style=\"font-size: 1rem;\">[[ticket_id]]</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">Ticket Status:</span><br></p><p><span style=\"font-size: 1rem;\">[[ticket_status]]</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">Subject :</span><br></p><p><span style=\"font-size: 1rem;\">[[ticket_subject]]</span><br></p><p><br></p><p><span style=\"font-size: 1rem;\">Thank You</span></p><p><span style=\"font-size: 1rem;\">Support Team<br></span></p>', 'ticket_id,ticket_status,ticket_subject,ticket_body,firstname,lastname,email,username,website_name,website_logo');