[encoded data, 146046 characters]&quot; height=&quot;400px&quot; width=&quot;300px&quot;&gt;&lt;/p&gt;');
INSERT INTO `paymentmethods` (`methodId`, `methodName`, `methodLogo`, `methodVisibleName`, `methodCallback`, `methodMin`, `methodMax`, `methodFee`, `methodBonusPercentage`, `methodBonusStartAmount`, `methodCurrency`, `methodStatus`, `methodExtras`, `methodPosition`, `methodInstructions`) VALUES
(100, 'Manual One', 'img/payments/manual.svg', 'Manual One', '', 1, 1, 0, 0, 0, '', '0', '', 2, ''),
(101, 'Manual Two', 'img/payments/manual.svg', 'Manual Two', '', 1, 1, 0, 0, 0, '', '0', '', 3, ''),
(102, 'Manual Three', 'img/payments/manual.svg', 'Manual Three', '', 1, 1, 0, 0, 0, '', '0', '', 4, ''),
(103, 'Manual Four', 'img/payments/manual.svg', 'Manual Four', '', 1, 1, 0, 0, 0, '', '0', '', 2, ''),
(104, 'Manual Five', 'img/payments/manual.svg', 'Manual Five', '', 1, 1, 0, 0, 0, '', '0', '', 18, ''),
(105, 'Manual Six', 'img/payments/manual.svg', 'Manual Six', '', 1, 1, 0, 0, 0, '', '0', '', 19, ''),
(106, 'Manual Seven', 'img/payments/manual.svg', 'Manual Seven', '', 1, 1, 0, 0, 0, '', '0', '', 20, ''),
(107, 'Manual Eight', 'img/payments/manual.svg', 'Manual Eight', '', 1, 1, 0, 0, 0, '', '0', '', 21, ''),
(108, 'Manual Nine', 'img/payments/manual.svg', 'Manual Nine', '', 1, 1, 0, 0, 0, '', '0', '', 22, ''),
(109, 'Manual Ten', 'img/payments/manual.svg', 'Manual Ten', '', 1, 1, 0, 0, 0, '', '0', '', 23, '');

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `payment_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `client_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `payment_amount` decimal(15,4) NOT NULL,
  `payment_privatecode` double DEFAULT NULL,
  `payment_method` int(11) NOT NULL,
  `payment_status` enum('1','2','3') NOT NULL DEFAULT '1',
  `payment_delivery` enum('1','2') NOT NULL DEFAULT '1',
  `payment_note` varchar(255) NOT NULL DEFAULT 'No',
  `payment_mode` enum('Manual','Automatic') NOT NULL DEFAULT 'Automatic',
  `payment_create_date` datetime NOT NULL,
  `payment_update_date` datetime NOT NULL,
  `payment_ip` varchar(225) NOT NULL,
  `payment_extra` text NOT NULL,
  `payment_bank` int(11) NOT NULL,
  `t_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`payment_id`, `client_id`, `client_balance`, `payment_amount`, `payment_privatecode`, `payment_method`, `payment_status`, `payment_delivery`, `payment_note`, `payment_mode`, `payment_create_date`, `payment_update_date`, `payment_ip`, `payment_extra`, `payment_bank`, `t_id`) VALUES
(1, 1, 0.00, 300.0000, NULL, 1, '3', '2', 'No', 'Manual', '2024-05-26 13:42:35', '0000-00-00 00:00:00', '47.11.128.174', '', 0, NULL),
(2, 1, 299.94, 1.0000, NULL, 22, '3', '2', 'No', 'Automatic', '2024-05-26 16:25:19', '0000-00-00 00:00:00', '47.11.128.191', '414792487323', 0, NULL);

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

--
-- Table structure for table `referral`
--

CREATE TABLE `referral` (
  `referral_id` int(11) NOT NULL,
  `referral_client_id` int(11) NOT NULL,
  `referral_clicks` double NOT NULL DEFAULT 0,
  `referral_sign_up` double NOT NULL DEFAULT 0,
  `referral_totalFunds_byReffered` double NOT NULL DEFAULT 0,
  `referral_earned_commision` double DEFAULT 0,
  `referral_requested_commision` varchar(225) DEFAULT '0',
  `referral_total_commision` double DEFAULT 0,
  `referral_status` enum('1','2') NOT NULL DEFAULT '1',
  `referral_code` text NOT NULL,
  `referral_rejected_commision` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `referral`
--

INSERT INTO `referral` (`referral_id`, `referral_client_id`, `referral_clicks`, `referral_sign_up`, `referral_totalFunds_byReffered`, `referral_earned_commision`, `referral_requested_commision`, `referral_total_commision`, `referral_status`, `referral_code`, `referral_rejected_commision`) VALUES
(1, 1, 0, 0, 0, 0, '0', 0, '1', 'c8cba9', 0),
(2, 2, 0, 0, 0, 0, '0', 0, '1', 'a81ae6', 0);

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

--
-- Table structure for table `referral_payouts`
--

CREATE TABLE `referral_payouts` (
  `r_p_id` int(11) NOT NULL,
  `r_p_code` text NOT NULL,
  `r_p_status` enum('1','2','3','4','0') NOT NULL DEFAULT '0',
  `r_p_amount_requested` double NOT NULL,
  `r_p_requested_at` datetime NOT NULL,
  `r_p_updated_at` datetime NOT NULL,
  `client_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `serviceapi_alert`
--

CREATE TABLE `serviceapi_alert` (
  `id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `serviceapi_alert` text NOT NULL,
  `servicealert_extra` text NOT NULL,
  `servicealert_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `service_id` int(11) NOT NULL,
  `service_api` int(11) NOT NULL DEFAULT 0,
  `api_service` int(11) NOT NULL DEFAULT 0,
  `api_servicetype` enum('1','2') NOT NULL DEFAULT '2',
  `api_detail` text NOT NULL,
  `category_id` int(11) NOT NULL,
  `service_line` double NOT NULL,
  `service_type` enum('1','2') NOT NULL DEFAULT '2',
  `service_package` enum('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17') NOT NULL,
  `service_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `service_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `service_price` varchar(225) NOT NULL,
  `service_min` double NOT NULL,
  `service_max` double NOT NULL,
  `service_dripfeed` enum('1','2') NOT NULL DEFAULT '1',
  `service_autotime` double NOT NULL DEFAULT 0,
  `service_autopost` double NOT NULL DEFAULT 0,
  `service_speed` enum('1','2','3','4') NOT NULL,
  `want_username` enum('1','2') NOT NULL DEFAULT '1',
  `service_secret` enum('1','2') NOT NULL DEFAULT '2',
  `price_type` enum('normal','percent','amount') NOT NULL DEFAULT 'normal',
  `price_cal` text DEFAULT NULL,
  `instagram_second` enum('1','2') NOT NULL DEFAULT '2',
  `start_count` enum('none','instagram_follower','instagram_photo','') NOT NULL,
  `instagram_private` enum('1','2') NOT NULL,
  `name_lang` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `description_lang` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `time_lang` varchar(225) NOT NULL DEFAULT 'Not enough data',
  `time` varchar(225) NOT NULL DEFAULT 'Not enough data',
  `cancelbutton` enum('1','2') NOT NULL DEFAULT '2' COMMENT '1 -> ON, 2 -> OFF',
  `show_refill` enum('true','false') NOT NULL DEFAULT 'false',
  `service_profit` varchar(225) NOT NULL,
  `refill_days` varchar(225) NOT NULL DEFAULT '30',
  `refill_hours` varchar(225) NOT NULL DEFAULT '24',
  `avg_days` int(11) NOT NULL,
  `avg_hours` int(11) NOT NULL,
  `avg_minutes` int(11) NOT NULL,
  `avg_many` int(11) NOT NULL,
  `price_profit` int(11) NOT NULL,
  `service_overflow` int(11) NOT NULL DEFAULT 0,
  `service_sync` enum('0','1') NOT NULL DEFAULT '1',
  `service_deleted` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`service_id`, `service_api`, `api_service`, `api_servicetype`, `api_detail`, `category_id`, `service_line`, `service_type`, `service_package`, `service_name`, `service_description`, `service_price`, `service_min`, `service_max`, `service_dripfeed`, `service_autotime`, `service_autopost`, `service_speed`, `want_username`, `service_secret`, `price_type`, `price_cal`, `instagram_second`, `start_count`, `instagram_private`, `name_lang`, `description_lang`, `time_lang`, `time`, `cancelbutton`, `show_refill`, `service_profit`, `refill_days`, `refill_hours`, `avg_days`, `avg_hours`, `avg_minutes`, `avg_many`, `price_profit`, `service_overflow`, `service_sync`, `service_deleted`) VALUES
(1, 2, 1227, '2', '{\"min\":\"2000\",\"max\":\"1000000\",\"rate\":\"25.2400\",\"currency\":\"INR\"}', 1, 1, '2', '1', ' Instagram Followers | 25 + Post | 500k/ day | Lifetime | 0-15 minutes ', '🌟 Service Description 🌟\r\n\r\n→ Start time: ⏱️ 12 - 6 AM\r\n→ Location: 🌍 Mixed, Global\r\n→ Link: 🔗 Profile Link\r\n→ Quality: 100% old accounts\r\n→ Speed : 100K/day\r\n👁️‍🗨️ Drop Rate: Usually 0% - 5% 💧\r\n📅 Refill: Lifetime\r\n\r\n🔍 Important: Processing for page / profiles, completed for personal profiles without fees. ℹ️\r\n\r\n✨ About Service: Cheapest real users followers.\r\n🚨 Note: During updates, delays may occur. Abuse is not tolerated. ℹ️\r\n⚠️ Reminder: Avoid placing multiple orders until the previous one is completed.\r\n\r\n🌈🎨🌟 Let\\\'s Make Your Profile Shine! 🌟🎨🌈', '37.86', 2000, 1000000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\" Instagram Followers | 25 + Post | 500k\\/ day | Lifetime | 0-15 minutes \"}', '{\"en\":\"\\ud83c\\udf1f Service Description \\ud83c\\udf1f\\r\\n\\r\\n\\u2192 Start time: \\u23f1\\ufe0f 12 - 6 AM\\r\\n\\u2192 Location: \\ud83c\\udf0d Mixed, Global\\r\\n\\u2192 Link: \\ud83d\\udd17 Profile Link\\r\\n\\u2192 Quality: 100% old accounts\\r\\n\\u2192 Speed : 100K\\/day\\r\\n\\ud83d\\udc41\\ufe0f\\u200d\\ud83d\\udde8\\ufe0f Drop Rate: Usually 0% - 5% \\ud83d\\udca7\\r\\n\\ud83d\\udcc5 Refill: Lifetime\\r\\n\\r\\n\\ud83d\\udd0d Important: Processing for page \\/ profiles, completed for personal profiles without fees. \\u2139\\ufe0f\\r\\n\\r\\n\\u2728 About Service: Cheapest real users followers.\\r\\n\\ud83d\\udea8 Note: During updates, delays may occur. Abuse is not tolerated. \\u2139\\ufe0f\\r\\n\\u26a0\\ufe0f Reminder: Avoid placing multiple orders until the previous one is completed.\\r\\n\\r\\n\\ud83c\\udf08\\ud83c\\udfa8\\ud83c\\udf1f Let\\\\\'s Make Your Profile Shine! \\ud83c\\udf1f\\ud83c\\udfa8\\ud83c\\udf08\"}', '{\"en\":\"53 minutes\"}', '53 minutes', '2', 'false', '', '30', '24', 0, 0, 0, 0, 50, 0, '1', '0'),
(2, 2, 1228, '2', '{\"min\":\"10\",\"max\":\"100000\",\"rate\":\"23.5100\",\"currency\":\"INR\"}', 1, 2, '2', '1', 'Instagram Followers HIGH QUALITY | 20k / Day | 365 Days | 0-5% Drop ♻️', '🌟 Service Description 🌟\r\n\r\n→ Start time: ⏱️ 0-1  Hrs\r\n→ Location: 🌍 Mixed, Global\r\n→ Link: 🔗 Profile Link\r\n→ Quality: Mix & old accounts\r\n→ Speed : 50K/day\r\n👁️‍🗨️ Drop Rate: Usually 0% - 10% 💧\r\n📅 Refill: 365 Days\r\n\r\n🔍 Important: Processing for page / profiles, completed for personal profiles without fees. ℹ️\r\n\r\n✨ About Service: Cheapest real users followers.\r\n🚨 Note: During updates, delays may occur. Abuse is not tolerated. ℹ️\r\n⚠️ Reminder: Avoid placing multiple orders until the previous one is completed.\r\n\r\n🌈🎨🌟 Let\\\'s Make Your Profile Shine! 🌟🎨🌈', '35.265', 10, 100000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Instagram Followers HIGH QUALITY | 20k \\/ Day | 365 Days | 0-5% Drop \\u267b\\ufe0f\"}', '{\"en\":\"\\ud83c\\udf1f Service Description \\ud83c\\udf1f\\r\\n\\r\\n\\u2192 Start time: \\u23f1\\ufe0f 0-1  Hrs\\r\\n\\u2192 Location: \\ud83c\\udf0d Mixed, Global\\r\\n\\u2192 Link: \\ud83d\\udd17 Profile Link\\r\\n\\u2192 Quality: Mix & old accounts\\r\\n\\u2192 Speed : 50K\\/day\\r\\n\\ud83d\\udc41\\ufe0f\\u200d\\ud83d\\udde8\\ufe0f Drop Rate: Usually 0% - 10% \\ud83d\\udca7\\r\\n\\ud83d\\udcc5 Refill: 365 Days\\r\\n\\r\\n\\ud83d\\udd0d Important: Processing for page \\/ profiles, completed for personal profiles without fees. \\u2139\\ufe0f\\r\\n\\r\\n\\u2728 About Service: Cheapest real users followers.\\r\\n\\ud83d\\udea8 Note: During updates, delays may occur. Abuse is not tolerated. \\u2139\\ufe0f\\r\\n\\u26a0\\ufe0f Reminder: Avoid placing multiple orders until the previous one is completed.\\r\\n\\r\\n\\ud83c\\udf08\\ud83c\\udfa8\\ud83c\\udf1f Let\\\\\'s Make Your Profile Shine! \\ud83c\\udf1f\\ud83c\\udfa8\\ud83c\\udf08\"}', '{\"en\":\"10 minutes\"}', '10 minutes', '2', 'false', '', '30', '24', 0, 0, 0, 0, 50, 0, '1', '0'),
(3, 2, 1229, '2', '{\"min\":\"10\",\"max\":\"500000\",\"rate\":\"23.5800\",\"currency\":\"INR\"}', 1, 3, '2', '1', 'Instagram Real Followers | Speed 50k /Day | Lifetime | 0 %  Drop | 15+Posts Old A/c ⏩', '🌟 Service Description 🌟\r\n\r\n→ Start time: ⏱️ 0-1  Hrs\r\n→ Location: 🌍 Mixed, Global\r\n→ Link: 🔗 Profile Link\r\n→ Quality: 100% old accounts\r\n→ Speed : 5-10K/day\r\n👁️‍🗨️ Drop Rate: Usually 0% - 5% 💧\r\n📅 Refill: Lifetime\r\n\r\n🔍 Important: Processing for page / profiles, completed for personal profiles without fees. ℹ️\r\n\r\n✨ About Service: Cheapest real users followers.\r\n🚨 Note: During updates, delays may occur. Abuse is not tolerated. ℹ️\r\n⚠️ Reminder: Avoid placing multiple orders until the previous one is completed.\r\n\r\n🌈🎨🌟 Let\\\'s Make Your Profile Shine! 🌟🎨🌈', '35.37', 10, 500000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Instagram Real Followers | Speed 50k \\/Day | Lifetime | 0 %  Drop | 15+Posts Old A\\/c \\u23e9\"}', '{\"en\":\"\\ud83c\\udf1f Service Description \\ud83c\\udf1f\\r\\n\\r\\n\\u2192 Start time: \\u23f1\\ufe0f 0-1  Hrs\\r\\n\\u2192 Location: \\ud83c\\udf0d Mixed, Global\\r\\n\\u2192 Link: \\ud83d\\udd17 Profile Link\\r\\n\\u2192 Quality: 100% old accounts\\r\\n\\u2192 Speed : 5-10K\\/day\\r\\n\\ud83d\\udc41\\ufe0f\\u200d\\ud83d\\udde8\\ufe0f Drop Rate: Usually 0% - 5% \\ud83d\\udca7\\r\\n\\ud83d\\udcc5 Refill: Lifetime\\r\\n\\r\\n\\ud83d\\udd0d Important: Processing for page \\/ profiles, completed for personal profiles without fees. \\u2139\\ufe0f\\r\\n\\r\\n\\u2728 About Service: Cheapest real users followers.\\r\\n\\ud83d\\udea8 Note: During updates, delays may occur. Abuse is not tolerated. \\u2139\\ufe0f\\r\\n\\u26a0\\ufe0f Reminder: Avoid placing multiple orders until the previous one is completed.\\r\\n\\r\\n\\ud83c\\udf08\\ud83c\\udfa8\\ud83c\\udf1f Let\\\\\'s Make Your Profile Shine! \\ud83c\\udf1f\\ud83c\\udfa8\\ud83c\\udf08\"}', '{\"en\":\"52 minutes\"}', '52 minutes', '2', 'false', '', '30', '24', 0, 0, 0, 0, 50, 0, '1', '0'),
(4, 2, 1230, '2', '{\"min\":\"10\",\"max\":\"20000\",\"rate\":\"24.0900\",\"currency\":\"INR\"}', 1, 4, '2', '1', 'Instagram Followers | No Drop | 150k / Day | 90 days Refill ', 'start 5 minutes\r\nnon drop\r\n150k/day\r\nuse profile link\r\nrefill lifetime', '36.135', 10, 20000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Instagram Followers | No Drop | 150k \\/ Day | 90 days Refill \"}', '{\"en\":\"start 5 minutes\\r\\nnon drop\\r\\n150k\\/day\\r\\nuse profile link\\r\\nrefill lifetime\"}', '{\"en\":\"1 hour 2 minutes\"}', '1 hour 2 minutes', '2', 'false', '', '30', '24', 0, 0, 0, 0, 50, 0, '1', '0'),
(5, 2, 1231, '2', '{\"min\":\"10\",\"max\":\"500000\",\"rate\":\"30.9400\",\"currency\":\"INR\"}', 1, 5, '2', '1', 'Instagram followers | 200k/day | Non drop | 15+ Post | Lifetime  Refill ✅', '🌟 Service Description 🌟\r\n\r\n→ Start time: ⏱️ 0-1  Hrs\r\n→ Location: 🌍 Mixed, Global\r\n→ Link: 🔗 Profile Link\r\n→ Quality: 100% old accounts\r\n→ Speed : 100K/day\r\n👁️‍🗨️ Drop Rate: Usually 0% - 5% 💧\r\n📅 Refill: Lifetime\r\n\r\n🔍 Important: Processing for page / profiles, completed for personal profiles without fees. ℹ️\r\n\r\n✨ About Service: Cheapest real users followers.\r\n🚨 Note: During updates, delays may occur. Abuse is not tolerated. ℹ️\r\n⚠️ Reminder: Avoid placing multiple orders until the previous one is completed.\r\n\r\n🌈🎨🌟 Let\\\'s Make Your Profile Shine! 🌟🎨🌈', '46.41', 10, 500000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Instagram followers | 200k\\/day | Non drop | 15+ Post | Lifetime  Refill \\u2705\"}', '{\"en\":\"\\ud83c\\udf1f Service Description \\ud83c\\udf1f\\r\\n\\r\\n\\u2192 Start time: \\u23f1\\ufe0f 0-1  Hrs\\r\\n\\u2192 Location: \\ud83c\\udf0d Mixed, Global\\r\\n\\u2192 Link: \\ud83d\\udd17 Profile Link\\r\\n\\u2192 Quality: 100% old accounts\\r\\n\\u2192 Speed : 100K\\/day\\r\\n\\ud83d\\udc41\\ufe0f\\u200d\\ud83d\\udde8\\ufe0f Drop Rate: Usually 0% - 5% \\ud83d\\udca7\\r\\n\\ud83d\\udcc5 Refill: Lifetime\\r\\n\\r\\n\\ud83d\\udd0d Important: Processing for page \\/ profiles, completed for personal profiles without fees. \\u2139\\ufe0f\\r\\n\\r\\n\\u2728 About Service: Cheapest real users followers.\\r\\n\\ud83d\\udea8 Note: During updates, delays may occur. Abuse is not tolerated. \\u2139\\ufe0f\\r\\n\\u26a0\\ufe0f Reminder: Avoid placing multiple orders until the previous one is completed.\\r\\n\\r\\n\\ud83c\\udf08\\ud83c\\udfa8\\ud83c\\udf1f Let\\\\\'s Make Your Profile Shine! \\ud83c\\udf1f\\ud83c\\udfa8\\ud83c\\udf08\"}', '{\"en\":\"1 hour 5 minutes\"}', '1 hour 5 minutes', '2', 'false', '', '30', '24', 0, 0, 0, 0, 50, 0, '1', '0'),
(6, 2, 1232, '2', '{\"min\":\"1000\",\"max\":\"300000\",\"rate\":\"23.7200\",\"currency\":\"INR\"}', 1, 6, '2', '1', 'Instagram Followers | HQ | 50K/day | 365 days', '🌟 Service Description 🌟\r\n\r\n→ Start time: ⏱️ 0-1  Hrs\r\n→ Location: 🌍 Mixed, Global\r\n→ Link: 🔗 Profile Link\r\n→ Quality: Mix & old accounts\r\n→ Speed : 50K/day\r\n👁️‍🗨️ Drop Rate: Usually 0% - 5% 💧\r\n📅 Refill:  Lifetime\r\n\r\n🔍 Important: Processing for page / profiles, completed for personal profiles without fees. ℹ️\r\n\r\n✨ About Service: Cheapest real users followers.\r\n🚨 Note: During updates, delays may occur. Abuse is not tolerated. ℹ️\r\n⚠️ Reminder: Avoid placing multiple orders until the previous one is completed.\r\n\r\n🌈🎨🌟 Let\\\'s Make Your Profile Shine! 🌟🎨🌈', '35.58', 1000, 300000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Instagram Followers | HQ | 50K\\/day | 365 days\"}', '{\"en\":\"\\ud83c\\udf1f Service Description \\ud83c\\udf1f\\r\\n\\r\\n\\u2192 Start time: \\u23f1\\ufe0f 0-1  Hrs\\r\\n\\u2192 Location: \\ud83c\\udf0d Mixed, Global\\r\\n\\u2192 Link: \\ud83d\\udd17 Profile Link\\r\\n\\u2192 Quality: Mix & old accounts\\r\\n\\u2192 Speed : 50K\\/day\\r\\n\\ud83d\\udc41\\ufe0f\\u200d\\ud83d\\udde8\\ufe0f Drop Rate: Usually 0% - 5% \\ud83d\\udca7\\r\\n\\ud83d\\udcc5 Refill:  Lifetime\\r\\n\\r\\n\\ud83d\\udd0d Important: Processing for page \\/ profiles, completed for personal profiles without fees. \\u2139\\ufe0f\\r\\n\\r\\n\\u2728 About Service: Cheapest real users followers.\\r\\n\\ud83d\\udea8 Note: During updates, delays may occur. Abuse is not tolerated. \\u2139\\ufe0f\\r\\n\\u26a0\\ufe0f Reminder: Avoid placing multiple orders until the previous one is completed.\\r\\n\\r\\n\\ud83c\\udf08\\ud83c\\udfa8\\ud83c\\udf1f Let\\\\\'s Make Your Profile Shine! \\ud83c\\udf1f\\ud83c\\udfa8\\ud83c\\udf08\"}', '{\"en\":\"2 minutes\"}', '2 minutes', '2', 'false', '', '30', '24', 0, 0, 0, 0, 50, 0, '1', '0'),
(7, 2, 1233, '2', '{\"min\":\"50\",\"max\":\"100000\",\"rate\":\"22.8600\",\"currency\":\"INR\"}', 1, 7, '2', '1', 'Instagram Followers | No Refill |  15+ Post | Old accounts  | Fast speed ', '🌟 Service Description 🌟\r\n\r\n→ Start time: ⏱️ 0-1  Hrs\r\n→ Location: 🌍 Mixed, Global\r\n→ Link: 🔗 Profile Link\r\n→ Quality: 100% old accounts\r\n→ Speed : 20K/day\r\n👁️‍🗨️ Drop Rate: Usually 0% - 5% 💧\r\n📅 Refill: No\r\n\r\n🔍 Important: Processing for page / profiles, completed for personal profiles without fees. ℹ️\r\n\r\n✨ About Service: Cheapest real users followers.\r\n🚨 Note: During updates, delays may occur. Abuse is not tolerated. ℹ️\r\n⚠️ Reminder: Avoid placing multiple orders until the previous one is completed.\r\n\r\n🌈🎨🌟 Let\\\'s Make Your Profile Shine! 🌟🎨🌈', '34.29', 50, 100000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Instagram Followers | No Refill |  15+ Post | Old accounts  | Fast speed \"}', '{\"en\":\"\\ud83c\\udf1f Service Description \\ud83c\\udf1f\\r\\n\\r\\n\\u2192 Start time: \\u23f1\\ufe0f 0-1  Hrs\\r\\n\\u2192 Location: \\ud83c\\udf0d Mixed, Global\\r\\n\\u2192 Link: \\ud83d\\udd17 Profile Link\\r\\n\\u2192 Quality: 100% old accounts\\r\\n\\u2192 Speed : 20K\\/day\\r\\n\\ud83d\\udc41\\ufe0f\\u200d\\ud83d\\udde8\\ufe0f Drop Rate: Usually 0% - 5% \\ud83d\\udca7\\r\\n\\ud83d\\udcc5 Refill: No\\r\\n\\r\\n\\ud83d\\udd0d Important: Processing for page \\/ profiles, completed for personal profiles without fees. \\u2139\\ufe0f\\r\\n\\r\\n\\u2728 About Service: Cheapest real users followers.\\r\\n\\ud83d\\udea8 Note: During updates, delays may occur. Abuse is not tolerated. \\u2139\\ufe0f\\r\\n\\u26a0\\ufe0f Reminder: Avoid placing multiple orders until the previous one is completed.\\r\\n\\r\\n\\ud83c\\udf08\\ud83c\\udfa8\\ud83c\\udf1f Let\\\\\'s Make Your Profile Shine! \\ud83c\\udf1f\\ud83c\\udfa8\\ud83c\\udf08\"}', '{\"en\":\"1 hour 27 minutes\"}', '1 hour 27 minutes', '2', 'false', '', '30', '24', 0, 0, 0, 0, 50, 0, '1', '0'),
(8, 2, 1234, '2', '{\"min\":\"100\",\"max\":\"100000000\",\"rate\":\"2.6100\",\"currency\":\"INR\"}', 2, 8, '2', '1', 'Instagram Video Views | Max 500K | All Link ❤️', '', '3.915', 100, 100000000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Instagram Video Views | Max 500K | All Link \\u2764\\ufe0f\"}', '{\"en\":\"\"}', '{\"en\":\"54 minutes\"}', '54 minutes', '2', 'false', '', '30', '24', 0, 0, 0, 0, 50, 0, '1', '0'),
(9, 2, 1235, '2', '{\"min\":\"100\",\"max\":\"200000\",\"rate\":\"1.2000\",\"currency\":\"INR\"}', 2, 9, '2', '1', 'Instagram Video Views| 10M/day | SuperFast', '', '1.8', 100, 200000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Instagram Video Views| 10M\\/day | SuperFast\"}', '{\"en\":\"\"}', '{\"en\":\"27 minutes\"}', '27 minutes', '2', 'false', '', '30', '24', 0, 0, 0, 0, 50, 0, '1', '0'),
(10, 2, 1236, '2', '{\"min\":\"100\",\"max\":\"250000\",\"rate\":\"7.3600\",\"currency\":\"INR\"}', 2, 10, '2', '1', 'Instagram Video Views {All Links Max 500M} 0-1 Minutes', '', '11.04', 100, 250000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Instagram Video Views {All Links Max 500M} 0-1 Minutes\"}', '{\"en\":\"\"}', '{\"en\":\"19 minutes\"}', '19 minutes', '2', 'false', '', '30', '24', 0, 0, 0, 0, 50, 0, '1', '0'),
(11, 2, 1237, '2', '{\"min\":\"100\",\"max\":\"100000000\",\"rate\":\"3.4400\",\"currency\":\"INR\"}', 2, 11, '2', '1', 'Instagram Video Views {All Links Max 500M} 0-1 Minutes', '', '5.16', 100, 100000000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Instagram Video Views {All Links Max 500M} 0-1 Minutes\"}', '{\"en\":\"\"}', '{\"en\":\"1 hour 13 minutes\"}', '1 hour 13 minutes', '2', 'false', '', '30', '24', 0, 0, 0, 0, 50, 0, '1', '0'),
(12, 2, 1238, '2', '{\"min\":\"40\",\"max\":\"2147483647\",\"rate\":0.83130000000000003890221478286548517644405364990234375,\"currency\":\"INR\"}', 2, 12, '2', '1', 'Instagram Views TV | MAX 250M | FAST | INSTANT | AFTER UPDATE ', '', '1.24695', 40, 2147483647, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Instagram Views TV | MAX 250M | FAST | INSTANT | AFTER UPDATE \"}', '{\"en\":\"\"}', '{\"en\":\"1 hour 5 minutes\"}', '1 hour 5 minutes', '2', 'false', '', '30', '24', 0, 0, 0, 0, 50, 0, '1', '0');

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

--
-- Table structure for table `service_api`
--

CREATE TABLE `service_api` (
  `id` int(11) NOT NULL,
  `api_name` varchar(225) NOT NULL,
  `api_url` text NOT NULL,
  `api_key` varchar(225) NOT NULL,
  `api_type` int(11) NOT NULL,
  `api_limit` double NOT NULL DEFAULT 0,
  `currency` varchar(200) DEFAULT NULL,
  `api_alert` enum('1','2') NOT NULL DEFAULT '2' COMMENT '2 -> Gönder, 1 -> Gönderildi',
  `status` enum('1','2') NOT NULL DEFAULT '2',
  `api_sync` enum('0','1') NOT NULL DEFAULT '1',
  `api_login_credentials` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `service_api`
--

INSERT INTO `service_api` (`id`, `api_name`, `api_url`, `api_key`, `api_type`, `api_limit`, `currency`, `api_alert`, `status`, `api_sync`, `api_login_credentials`) VALUES
(2, 'supersmmpanel.online', 'https://supersmmpanel.online/api/v2', 'cae55e709ba16ad74064621199f5e22f', 1, 0, 'INR', '1', '1', '1', '{\"username\":\"\",\"password\":\"\"}');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `site_seo` text NOT NULL,
  `site_title` text DEFAULT NULL,
  `site_description` text DEFAULT NULL,
  `site_keywords` text DEFAULT NULL,
  `site_logo` text DEFAULT NULL,
  `site_name` text DEFAULT NULL,
  `site_currency` varchar(2555) NOT NULL DEFAULT 'try',
  `site_base_currency` varchar(20) DEFAULT NULL,
  `site_currency_converter` tinyint(1) NOT NULL DEFAULT 0,
  `site_update_rates_automatically` int(11) NOT NULL DEFAULT 0,
  `last_updated_currency_rates` datetime DEFAULT NULL,
  `favicon` text DEFAULT NULL,
  `site_language` varchar(225) NOT NULL DEFAULT 'tr',
  `site_theme` text NOT NULL,
  `site_theme_alt` text DEFAULT NULL,
  `recaptcha` enum('1','2') NOT NULL DEFAULT '1',
  `recaptcha_key` text DEFAULT NULL,
  `recaptcha_secret` text DEFAULT NULL,
  `custom_header` text DEFAULT NULL,
  `custom_footer` text DEFAULT NULL,
  `ticket_system` enum('1','2') NOT NULL DEFAULT '2',
  `register_page` enum('1','2') NOT NULL DEFAULT '2',
  `service_speed` enum('1','2') NOT NULL,
  `service_list` enum('1','2') NOT NULL,
  `dolar_charge` double NOT NULL,
  `euro_charge` double NOT NULL,
  `smtp_user` text NOT NULL,
  `smtp_pass` text NOT NULL,
  `smtp_server` text NOT NULL,
  `smtp_port` varchar(225) NOT NULL,
  `smtp_protocol` enum('0','ssl','tls') NOT NULL,
  `alert_type` enum('1','2','3') NOT NULL,
  `alert_apimail` enum('1','2') NOT NULL,
  `alert_newmanuelservice` enum('1','2') NOT NULL,
  `alert_newticket` enum('1','2') NOT NULL,
  `alert_apibalance` enum('1','2') NOT NULL,
  `alert_serviceapialert` enum('1','2') NOT NULL,
  `sms_provider` varchar(225) NOT NULL,
  `sms_title` varchar(225) NOT NULL,
  `sms_user` varchar(225) NOT NULL,
  `sms_pass` varchar(225) NOT NULL,
  `sms_validate` enum('0','1') NOT NULL DEFAULT '0' COMMENT '1 -> OK, 0 -> NO',
  `admin_mail` varchar(225) NOT NULL,
  `admin_telephone` varchar(225) NOT NULL,
  `resetpass_page` enum('1','2') NOT NULL,
  `resetpass_sms` enum('1','2') NOT NULL,
  `resetpass_email` enum('1','2') NOT NULL,
  `site_maintenance` enum('1','2') NOT NULL DEFAULT '2',
  `servis_siralama` varchar(255) NOT NULL,
  `bronz_statu` int(11) NOT NULL,
  `silver_statu` int(11) NOT NULL,
  `gold_statu` int(11) NOT NULL,
  `bayi_statu` int(11) NOT NULL,
  `child_panel_nameservers` varchar(255) NOT NULL DEFAULT '{"ns1":"ns1.scriptlux.com","ns2":"ns2.scriptlux.com"}',
  `childpanel_price` double DEFAULT NULL,
  `snow_effect` enum('1','2') NOT NULL DEFAULT '2',
  `snow_colour` text NOT NULL,
  `promotion` enum('1','2') DEFAULT '2',
  `referral_commision` double NOT NULL,
  `referral_payout` double NOT NULL,
  `referral_status` enum('1','2') NOT NULL DEFAULT '1',
  `childpanel_selling` enum('1','2') NOT NULL DEFAULT '1' COMMENT '1 -> OFF , 2 -> ON',
  `tickets_per_user` double NOT NULL DEFAULT 5,
  `name_fileds` enum('1','2') NOT NULL DEFAULT '1' COMMENT '1 -> ON, 2 -> NO',
  `skype_feilds` enum('1','2') NOT NULL DEFAULT '1' COMMENT '1 -> ON, 2 -> NO',
  `otp_login` enum('1','2','0') NOT NULL DEFAULT '0',
  `auto_deactivate_payment` enum('1','2') NOT NULL DEFAULT '1',
  `service_avg_time` enum('1','0') NOT NULL DEFAULT '0',
  `alert_orderfail` enum('1','2') NOT NULL DEFAULT '2',
  `alert_welcomemail` enum('1','2') NOT NULL DEFAULT '2',
  `freebalance` enum('1','2') NOT NULL DEFAULT '1',
  `freeamount` double DEFAULT 0,
  `alert_newmessage` enum('1','2') NOT NULL DEFAULT '1',
  `email_confirmation` enum('1','2') NOT NULL DEFAULT '2',
  `resend_max` int(11) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT '1',
  `fundstransfer_fees` varchar(10) NOT NULL,
  `permissions` text DEFAULT NULL,
  `fake_order_service_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `fake_order_min` int(11) DEFAULT NULL,
  `fake_order_max` int(11) DEFAULT NULL,
  `panel_orders` int(11) DEFAULT NULL,
  `panel_orders_pattern` varchar(255) NOT NULL DEFAULT '{"panel_orders_prefix":"","panel_orders_suffix":""}',
  `downloaded_category_icons` tinyint(1) NOT NULL DEFAULT 0,
  `summary_card_background_color` varchar(100) DEFAULT 'theme_colour',
  `google_login` varchar(100) NOT NULL DEFAULT '{"purchased":"1","status":"1"}',
  `services_average_time` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `site_seo`, `site_title`, `site_description`, `site_keywords`, `site_logo`, `site_name`, `site_currency`, `site_base_currency`, `site_currency_converter`, `site_update_rates_automatically`, `last_updated_currency_rates`, `favicon`, `site_language`, `site_theme`, `site_theme_alt`, `recaptcha`, `recaptcha_key`, `recaptcha_secret`, `custom_header`, `custom_footer`, `ticket_system`, `register_page`, `service_speed`, `service_list`, `dolar_charge`, `euro_charge`, `smtp_user`, `smtp_pass`, `smtp_server`, `smtp_port`, `smtp_protocol`, `alert_type`, `alert_apimail`, `alert_newmanuelservice`, `alert_newticket`, `alert_apibalance`, `alert_serviceapialert`, `sms_provider`, `sms_title`, `sms_user`, `sms_pass`, `sms_validate`, `admin_mail`, `admin_telephone`, `resetpass_page`, `resetpass_sms`, `resetpass_email`, `site_maintenance`, `servis_siralama`, `bronz_statu`, `silver_statu`, `gold_statu`, `bayi_statu`, `child_panel_nameservers`, `childpanel_price`, `snow_effect`, `snow_colour`, `promotion`, `referral_commision`, `referral_payout`, `referral_status`, `childpanel_selling`, `tickets_per_user`, `name_fileds`, `skype_feilds`, `otp_login`, `auto_deactivate_payment`, `service_avg_time`, `alert_orderfail`, `alert_welcomemail`, `freebalance`, `freeamount`, `alert_newmessage`, `email_confirmation`, `resend_max`, `status`, `fundstransfer_fees`, `permissions`, `fake_order_service_enabled`, `fake_order_min`, `fake_order_max`, `panel_orders`, `panel_orders_pattern`, `downloaded_category_icons`, `summary_card_background_color`, `google_login`, `services_average_time`) VALUES
(1, 'Main Smm panel service provider in india ', 'Main Smm panel service provider in india ', 'Main Smm panel service provider in india, smm panel,smmpanel,SMM Panel India,SMM Panel Paytm,SMM Panel Cheap India,SMM Reseller Panel,SMM Reseller Panel India,Cheap SMM Panel,cheapest SMM panel,cheap SMM panel india,Cheapest SMM Reseller Panel,Cheapest SMM Panel Paytm,Cheapest SMM Panel Paytm,indian smm panel,IndianSMM Reseller Panel,Best SMM panel,Best SMM Panel India,Top SMM Panel', 'Main Smm panel service provider in india, Best and Cheap SMM Panel for Instagram, Tiktok, Facebook, Youtube and Twitter. Buy IG Reels views and Followers, Buy Instagram Likes, Views and Comments, Buy TikTok Likes and Followers, Buy Facebook Likes and Comments, Buy Youtube Likes, Views and Subscribers.', '', 'SUPERSMMPANEL', '', 'INR', 1, 1, '2024-05-26 16:25:15', '', 'en', 'united', 'cyan', '1', '6Le7cugpAAAAANjOyBLTmmC-Ba5Q4CjhqGUcNoCO', '6Le7cugpAAAAAEHatBukZ3Nquwr09TMT4nIXYoAY', '', '', '1', '2', '1', '2', 0, 0, '', '', '', '', '0', '2', '2', '2', '2', '2', '2', 'bizimsms', '', '', '', '1', '', '', '2', '1', '2', '2', 'asc', 500, 2500, 10000, 15000, '{\"ns1\":\"ns1.scriptlux.com\",\"ns2\":\"ns2.scriptlux.com\"}', 100, '2', '', '2', 10, 10, '2', '2', 9999999999, '2', '2', '0', '1', '1', '2', '2', '1', 2, '2', '2', 2, '0', '3', '{\"admin access\":{\"admin_access\":{\"name\":\"Admin Access\",\"value\":\"admin_access\"}},\"pages\":{\"users\":{\"name\":\"Users\",\"value\":\"users\"},\"services\":{\"name\":\"Services\",\"value\":\"services\"},\"update-prices\":{\"name\":\"Update Prices\",\"value\":\"update-prices\"},\"bulk\":{\"name\":\"Bulk Services Editor\",\"value\":\"bulk\"},\"bulkc\":{\"name\":\"Bulk Category Editor\",\"value\":\"services\"},\"synced-logs\":{\"name\":\"Seller Sync Logs\",\"value\":\"synced-logs\"},\"orders\":{\"name\":\"Orders\",\"value\":\"orders\"},\"subscriptions\":{\"name\":\"Subscriptions\",\"value\":\"subscriptions\"},\"dripfeed\":{\"name\":\"Dripfeed\",\"value\":\"dripfeed\"},\"tasks\":{\"name\":\"Order Refill and Cancel Tasks\",\"value\":\"tasks\"},\"payments\":{\"name\":\"Payments\",\"value\":\"payments\"},\"tickets\":{\"name\":\"Tickets\",\"value\":\"tickets\"}},\"additionals\":{\"additionals\":{\"name\":\"Additionals\",\"value\":\"additionals\"},\"referral\":{\"name\":\"Affiliates\",\"value\":\"referral\"},\"broadcast\":{\"name\":\"Broadcasts\",\"value\":\"broadcast\"},\"logs\":{\"name\":\"Panel Logs\",\"value\":\"logs\"},\"reports\":{\"name\":\"Reports\",\"value\":\"reports\"},\"videop\":{\"name\":\"Promotion\",\"value\":\"videop\"},\"coupon\":{\"name\":\"Coupons\",\"value\":\"coupon\"},\"child-panels\":{\"name\":\"Child Panels\",\"value\":\"child-panels\"},\"updates\":{\"name\":\"Updates\",\"value\":\"updates\"}},\"appearance\":{\"appearance\":{\"name\":\"Appearance\",\"value\":\"appearance\"},\"themes\":{\"name\":\"Themes\",\"value\":\"themes\"},\"new_year\":{\"name\":\"New Year\",\"value\":\"new_year\"},\"pages\":{\"name\":\"Pages\",\"value\":\"pages\"},\"news\":{\"name\":\"Announcements\",\"value\":\"news\"},\"meta\":{\"name\":\"Meta (SEO) Settings\",\"value\":\"meta\"},\"blog\":{\"name\":\"Blogs\",\"value\":\"blog\"},\"menu\":{\"name\":\"Menu\",\"value\":\"menu\"},\"inte\":{\"name\":\"Integrations\",\"value\":\"inte\"},\"language\":{\"name\":\"Languages\",\"value\":\"language\"},\"files\":{\"name\":\"Uploaded Images\",\"value\":\"files\"}},\"settings\":{\"settings\":{\"name\":\"Settings\",\"value\":\"settings\"},\"general_settings\":{\"name\":\"General Settings\",\"value\":\"general_settings\"},\"providers\":{\"name\":\"Sellers\",\"value\":\"providers\"},\"payments_settings\":{\"name\":\"Payment Methods\",\"value\":\"payments_settings\"},\"bank_accounts\":{\"name\":\"Bank Accounts\",\"value\":\"bank_accounts\"},\"modules\":{\"name\":\"Modules\",\"value\":\"modules\"},\"subject\":{\"name\":\"Support Settings\",\"value\":\"subject\"},\"payments_bonus\":{\"name\":\"Payment Bonuses\",\"value\":\"payments_bonus\"},\"currency-manager\":{\"name\":\"Site Currency Manager\",\"value\":\"currency-manager\"},\"alert_settings\":{\"name\":\"Notification Settings\",\"value\":\"alert_settings\"},\"site_count\":{\"name\":\"Fake Orders\",\"value\":\"site_count\"},\"manager\":{\"name\":\"Manager\",\"value\":\"manager\"}}}', 0, 1, 3, 1, '{\"panel_orders_prefix\":\"\",\"panel_orders_suffix\":\"\"}', 0, 'theme_colour', '{\"purchased\":\"1\",\"status\":\"1\"}', 1);

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

--
-- Table structure for table `sync_logs`
--

CREATE TABLE `sync_logs` (
  `id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `action` varchar(225) NOT NULL,
  `date` datetime NOT NULL,
  `description` varchar(225) NOT NULL,
  `api_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `sync_logs`
--

INSERT INTO `sync_logs` (`id`, `service_id`, `action`, `date`, `description`, `api_id`) VALUES
(1, 1, 'SERVICE PRICE UPDATED', '2024-05-26 15:24:35', 'Service rate changed from <b>₹ 38.18</b> to <b>₹ 37.86</b>', 2),
(2, 2, 'SERVICE PRICE UPDATED', '2024-05-26 15:24:35', 'Service rate changed from <b>₹ 35.55</b> to <b>₹ 35.27</b>', 2),
(3, 3, 'SERVICE PRICE UPDATED', '2024-05-26 15:24:35', 'Service rate changed from <b>₹ 35.66</b> to <b>₹ 35.37</b>', 2),
(4, 4, 'SERVICE PRICE UPDATED', '2024-05-26 15:24:35', 'Service rate changed from <b>₹ 36.42</b> to <b>₹ 36.14</b>', 2),
(5, 5, 'SERVICE PRICE UPDATED', '2024-05-26 15:24:35', 'Service rate changed from <b>₹ 46.77</b> to <b>₹ 46.41</b>', 2),
(6, 6, 'SERVICE PRICE UPDATED', '2024-05-26 15:24:35', 'Service rate changed from <b>₹ 35.87</b> to <b>₹ 35.58</b>', 2),
(7, 7, 'SERVICE PRICE UPDATED', '2024-05-26 15:24:35', 'Service rate changed from <b>₹ 34.56</b> to <b>₹ 34.29</b>', 2),
(8, 8, 'SERVICE PRICE UPDATED', '2024-05-26 15:24:35', 'Service rate changed from <b>₹ 3.95</b> to <b>₹ 3.92</b>', 2),
(9, 9, 'SERVICE PRICE UPDATED', '2024-05-26 15:24:35', 'Service rate changed from <b>₹ 1.82</b> to <b>₹ 1.80</b>', 2),
(10, 10, 'SERVICE PRICE UPDATED', '2024-05-26 15:24:35', 'Service rate changed from <b>₹ 11.13</b> to <b>₹ 11.04</b>', 2),
(11, 11, 'SERVICE PRICE UPDATED', '2024-05-26 15:24:35', 'Service rate changed from <b>₹ 5.21</b> to <b>₹ 5.16</b>', 2),
(12, 12, 'SERVICE PRICE UPDATED', '2024-05-26 15:24:35', 'Service rate changed from <b>₹ 1.26</b> to <b>₹ 1.25</b>', 2);

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `task_id` int(11) NOT NULL,
  `client_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `task_api` int(11) DEFAULT NULL,
  `task_type` varchar(225) DEFAULT NULL,
  `task_status` varchar(225) DEFAULT 'pending',
  `task_response` text DEFAULT NULL,
  `task_created_at` datetime DEFAULT NULL,
  `task_updated_at` datetime DEFAULT NULL,
  `task_by` text DEFAULT NULL,
  `check_refill_status` int(11) DEFAULT NULL,
  `refill_orderid` varchar(225) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` int(11) NOT NULL,
  `theme_name` text NOT NULL,
  `theme_dirname` text NOT NULL,
  `theme_extras` text NOT NULL,
  `last_modified` datetime NOT NULL,
  `newpage` text NOT NULL,
  `colour` enum('1','2') NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `theme_name`, `theme_dirname`, `theme_extras`, `last_modified`, `newpage`, `colour`) VALUES
(1, 'Simplify', 'Simplify', '', '2022-11-16 09:28:01', '{% include \'header.twig\' %}\r\n	<br><br><br>\r\n	\r\n	<div class=\"container-fluid container-fluid-spacious\">\r\n		<div class=\"row\">\r\n			<div class=\"col-md-12\">\r\n			{% if contentText %}\r\n{{ contentText }}\r\n{% endif %}\r\n				{% if contentText2 %}\r\n{{ contentText2 }}\r\n{% endif %}\r\n				\r\n			</div>\r\n		</div>\r\n	</div>\r\n   \r\n      \r\n        \r\n   ', '2'),
(4, 'Eternity', 'Eternity', '', '2023-11-21 09:29:47', '', '2'),
(2, 'Pitchy', 'pitchy', '{\"stylesheets\":[\"public/pitchy/bootstrap.css\",\"public/pitchy/black.css\",\"https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css\",\"public/datepicker/css/bootstrap-datepicker3.min.css\"],\"scripts\":[\"https://code.jquery.com/jquery-3.3.1.min.js\",\"public/pitchy/js/script.js\",\"public/pitchy/js/snowfall.min.js\",\"public/pitchy/js/bundle.js\",\"public/pitchy/js/main.js\",\"public/ajax.js\",\"public/datepicker/js/bootstrap-datepicker.min.js\"]}', '2022-11-21 09:29:47', '', '2'),
(5, 'X Blur', 'xblur', '', '2023-11-07 09:29:47', '', '1'),
(3, 'united', 'united', '', '2022-11-16 09:28:01', '', '2');

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

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `ticket_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `subject` varchar(225) NOT NULL,
  `time` datetime NOT NULL,
  `lastupdate_time` datetime NOT NULL,
  `client_new` enum('1','2') NOT NULL DEFAULT '2',
  `status` enum('pending','answered','closed') NOT NULL DEFAULT 'pending',
  `support_new` enum('1','2') NOT NULL DEFAULT '1',
  `canmessage` enum('1','2') NOT NULL DEFAULT '2'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `ticket_reply`
--

CREATE TABLE `ticket_reply` (
  `id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `time` datetime NOT NULL,
  `support` enum('1','2') NOT NULL DEFAULT '1',
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `readed` enum('1','2') NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `ticket_subjects`
--

CREATE TABLE `ticket_subjects` (
  `subject_id` int(11) NOT NULL,
  `subject` varchar(225) NOT NULL,
  `content` text DEFAULT NULL,
  `auto_reply` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `ticket_subjects`
--

INSERT INTO `ticket_subjects` (`subject_id`, `subject`, `content`, `auto_reply`) VALUES
(1, 'Order', '', '0'),
(2, 'Payment', '', '0'),
(4, 'Complaint & Suggestion', '', '0'),
(6, 'Others', 'You will be answered within minutes', '1');

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

--
-- Table structure for table `units_per_page`
--

CREATE TABLE `units_per_page` (
  `id` int(11) NOT NULL,
  `unit` int(11) NOT NULL,
  `page` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `units_per_page`
--

INSERT INTO `units_per_page` (`id`, `unit`, `page`) VALUES
(1, 50, 'clients'),
(2, 50, 'orders'),
(3, 50, 'payments'),
(4, 50, 'refill'),
(5, 50, 'bulk'),
(6, 8, 'services');

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

--
-- Table structure for table `updates`
--

CREATE TABLE `updates` (
  `u_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `action` varchar(225) NOT NULL,
  `date` datetime NOT NULL,
  `description` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'Not enough data'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`admin_id`);

--
-- Indexes for table `admin_constants`
--
ALTER TABLE `admin_constants`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `article`
--
ALTER TABLE `article`
  ADD PRIMARY KEY (`id`),
  ADD KEY `title` (`title`);

--
-- Indexes for table `bank_accounts`
--
ALTER TABLE `bank_accounts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bulkedit`
--
ALTER TABLE `bulkedit`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `childpanels`
--
ALTER TABLE `childpanels`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`client_id`);

--
-- Indexes for table `clients_category`
--
ALTER TABLE `clients_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `clients_price`
--
ALTER TABLE `clients_price`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `clients_service`
--
ALTER TABLE `clients_service`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `client_report`
--
ALTER TABLE `client_report`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `currencies`
--
ALTER TABLE `currencies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `decoration`
--
ALTER TABLE `decoration`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `earn`
--
ALTER TABLE `earn`
  ADD PRIMARY KEY (`earn_id`);

--
-- Indexes for table `files`
--
ALTER TABLE `files`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `General_options`
--
ALTER TABLE `General_options`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `integrations`
--
ALTER TABLE `integrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kuponlar`
--
ALTER TABLE `kuponlar`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kupon_kullananlar`
--
ALTER TABLE `kupon_kullananlar`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `Mailforms`
--
ALTER TABLE `Mailforms`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications_popup`
--
ALTER TABLE `notifications_popup`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`order_id`),
  ADD KEY `order_id` (`order_id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`page_id`);

--
-- Indexes for table `panel_categories`
--
ALTER TABLE `panel_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `panel_info`
--
ALTER TABLE `panel_info`
  ADD PRIMARY KEY (`panel_id`);

--
-- Indexes for table `paymentmethods`
--
ALTER TABLE `paymentmethods`
  ADD PRIMARY KEY (`methodId`),
  ADD KEY `methodId` (`methodId`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`payment_id`);

--
-- Indexes for table `referral`
--
ALTER TABLE `referral`
  ADD PRIMARY KEY (`referral_id`);

--
-- Indexes for table `referral_payouts`
--
ALTER TABLE `referral_payouts`
  ADD PRIMARY KEY (`r_p_id`);

--
-- Indexes for table `serviceapi_alert`
--
ALTER TABLE `serviceapi_alert`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`service_id`);

--
-- Indexes for table `service_api`
--
ALTER TABLE `service_api`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sync_logs`
--
ALTER TABLE `sync_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`task_id`);

--
-- Indexes for table `themes`
--
ALTER TABLE `themes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tickets`
--
ALTER TABLE `tickets`
  ADD PRIMARY KEY (`ticket_id`);

--
-- Indexes for table `ticket_reply`
--
ALTER TABLE `ticket_reply`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ticket_subjects`
--
ALTER TABLE `ticket_subjects`
  ADD PRIMARY KEY (`subject_id`);

--
-- Indexes for table `units_per_page`
--
ALTER TABLE `units_per_page`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `updates`
--
ALTER TABLE `updates`
  ADD PRIMARY KEY (`u_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `article`
--
ALTER TABLE `article`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bank_accounts`
--
ALTER TABLE `bank_accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bulkedit`
--
ALTER TABLE `bulkedit`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `childpanels`
--
ALTER TABLE `childpanels`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `clients`
--
ALTER TABLE `clients`
  MODIFY `client_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `clients_category`
--
ALTER TABLE `clients_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `clients_price`
--
ALTER TABLE `clients_price`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `clients_service`
--
ALTER TABLE `clients_service`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `client_report`
--
ALTER TABLE `client_report`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `currencies`
--
ALTER TABLE `currencies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `earn`
--
ALTER TABLE `earn`
  MODIFY `earn_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `files`
--
ALTER TABLE `files`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `General_options`
--
ALTER TABLE `General_options`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `integrations`
--
ALTER TABLE `integrations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `kuponlar`
--
ALTER TABLE `kuponlar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `kupon_kullananlar`
--
ALTER TABLE `kupon_kullananlar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `Mailforms`
--
ALTER TABLE `Mailforms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications_popup`
--
ALTER TABLE `notifications_popup`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=913;

--
-- AUTO_INCREMENT for table `panel_categories`
--
ALTER TABLE `panel_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `panel_info`
--
ALTER TABLE `panel_info`
  MODIFY `panel_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `paymentmethods`
--
ALTER TABLE `paymentmethods`
  MODIFY `methodId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `payment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `referral`
--
ALTER TABLE `referral`
  MODIFY `referral_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `referral_payouts`
--
ALTER TABLE `referral_payouts`
  MODIFY `r_p_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `serviceapi_alert`
--
ALTER TABLE `serviceapi_alert`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53367;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `service_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `service_api`
--
ALTER TABLE `service_api`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sync_logs`
--
ALTER TABLE `sync_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `task_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `themes`
--
ALTER TABLE `themes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tickets`
--
ALTER TABLE `tickets`
  MODIFY `ticket_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ticket_reply`
--
ALTER TABLE `ticket_reply`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ticket_subjects`
--
ALTER TABLE `ticket_subjects`
  MODIFY `subject_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `units_per_page`
--
ALTER TABLE `units_per_page`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `updates`
--
ALTER TABLE `updates`
  MODIFY `u_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

