-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `smmarca1_demohub`
--

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `admin_id` int(11) NOT NULL,
  `admin_type` enum('3','2') NOT NULL DEFAULT '2',
  `admin_name` varchar(255) DEFAULT NULL,
  `admin_email` text DEFAULT NULL,
  `username` varchar(225) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `telephone` varchar(50) DEFAULT NULL,
  `register_date` datetime NOT NULL,
  `login_date` datetime DEFAULT NULL,
  `login_ip` varchar(225) DEFAULT NULL,
  `client_type` enum('1','2') NOT NULL DEFAULT '2' COMMENT '2 -> ON, 1 -> OFF',
  `access` varchar(999) NOT NULL,
  `mode` varchar(225) NOT NULL,
  `two_factor` enum('0','1') NOT NULL DEFAULT '0',
  `two_factor_secret_key` varchar(100) DEFAULT NULL,
  `ip_type` int(11) NOT NULL,
  `ip` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`admin_id`, `admin_type`, `admin_name`, `admin_email`, `username`, `password`, `telephone`, `register_date`, `login_date`, `login_ip`, `client_type`, `access`, `mode`, `two_factor`, `two_factor_secret_key`, `ip_type`, `ip`) VALUES
(1, '3', NULL, NULL, 'admin', '$2y$10$7ZX/DhsEkJ1opbPpRr6OpOhYfGmz0rY8o3I2MtXKfvqwGsWDdeTaO', '', '2025-01-01 10:19:05', '2024-11-29 20:16:23', '36.255.80.220', '2', '{\"admin_access\":1,\"users\":1,\"services\":1,\"update-prices\":1,\"bulk\":1,\"bulkc\":1,\"synced-logs\":1,\"orders\":1,\"subscriptions\":1,\"dripfeed\":1,\"tasks\":1,\"payments\":1,\"tickets\":1,\"guard_logs\":1,\"provider_logs\":1,\"additionals\":1,\"referral\":1,\"broadcast\":1,\"logs\":1,\"reports\":1,\"videop\":1,\"coupon\":1,\"child-panels\":1,\"updates\":1,\"appearance\":1,\"themes\":1,\"new_year\":1,\"pages\":1,\"news\":1,\"meta\":1,\"blog\":1,\"menu\":1,\"inte\":1,\"language\":1,\"whatsapp-telegram\":1,\"files\":1,\"settings\":1,\"general_settings\":1,\"providers\":1,\"payments_settings\":1,\"bank_accounts\":1,\"modules\":1,\"subject\":1,\"payments_bonus\":1,\"currency-manager\":1,\"alert_settings\":1,\"site_count\":1,\"manager\":1,\"signform\":1,\"ticket\":1,\"feedback\":1,\"super_admin\":1}', 'dark', '0', 'GCIVACCRMZZGXYG6', 0, '114.******7.42');

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

--
-- Table structure for table `admin_constants`
--

CREATE TABLE `admin_constants` (
  `id` int(11) NOT NULL,
  `brand_logo` varchar(255) DEFAULT NULL,
  `paidRent` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `admin_constants`
--

INSERT INTO `admin_constants` (`id`, `brand_logo`, `paidRent`) VALUES
(1, '', 1);

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

--
-- Table structure for table `admin_report`
--

CREATE TABLE `admin_report` (
  `id` int(11) NOT NULL,
  `admin_id` int(11) NOT NULL,
  `action` varchar(255) NOT NULL,
  `report_ip` varchar(45) NOT NULL,
  `report_date` datetime NOT NULL,
  `blocked_until` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `article`
--

CREATE TABLE `article` (
  `id` int(11) NOT NULL,
  `title` varchar(128) NOT NULL,
  `content` text NOT NULL,
  `published_at` datetime DEFAULT NULL,
  `image_file` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` int(11) NOT NULL,
  `title` varchar(128) NOT NULL,
  `content` text NOT NULL,
  `published_at` datetime NOT NULL,
  `image_file` varchar(200) DEFAULT NULL,
  `status` enum('1','2') NOT NULL DEFAULT '1',
  `blog_get` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `bulkedit`
--

CREATE TABLE `bulkedit` (
  `id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `category_id` int(11) NOT NULL,
  `category_name` text NOT NULL,
  `category_name_lang` longtext DEFAULT NULL,
  `category_line` double NOT NULL,
  `category_type` enum('1','2') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '2',
  `category_secret` enum('1','2') NOT NULL DEFAULT '2',
  `category_icon` text NOT NULL,
  `is_refill` enum('1','2') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '1',
  `category_deleted` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`category_id`, `category_name`, `category_name_lang`, `category_line`, `category_type`, `category_secret`, `category_icon`, `is_refill`, `category_deleted`) VALUES
(70, 'TikTok Save', NULL, 4, '2', '2', ' ', '', '0'),
(71, 'TikTok PakBattel Points', NULL, 5, '2', '2', ' ', '', '0'),
(72, 'YouTube Subscribers', NULL, 6, '2', '2', ' ', '', '0'),
(73, 'YouTube Views ', NULL, 7, '2', '2', ' ', '', '0'),
(74, 'YouTube like ', NULL, 8, '2', '2', ' ', '', '0'),
(75, 'Facebook page like', NULL, 9, '2', '2', ' ', '', '0'),
(76, 'Facebook page like+Followers', NULL, 10, '2', '2', ' ', '', '0'),
(77, 'Facebook page Followers', NULL, 11, '2', '2', ' ', '', '0'),
(78, 'Facebook videos views', NULL, 12, '2', '2', ' ', '', '0'),
(68, 'TikTok Comments', NULL, 2, '2', '2', ' ', '', '0'),
(69, 'TikTok Downlod', NULL, 3, '2', '2', ' ', '', '0'),
(65, 'TikTok Views ', NULL, -1, '2', '2', ' ', '', '0'),
(66, 'TikTok like ', NULL, 0, '2', '2', ' ', '', '0'),
(67, 'Tiik Tok Followers ', NULL, 1, '2', '2', ' ', '', '0');

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

--
-- Table structure for table `childpanels`
--

CREATE TABLE `childpanels` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `domain` varchar(191) NOT NULL,
  `child_panel_currency` varchar(191) NOT NULL,
  `child_panel_username` varchar(191) NOT NULL,
  `child_panel_password` varchar(191) NOT NULL,
  `charged_amount` float NOT NULL,
  `child_panel_status` enum('Pending','Active','Frozen','Suspended') NOT NULL DEFAULT 'Pending',
  `renewal_date` date NOT NULL,
  `created_on` datetime NOT NULL,
  `child_panel_uqid` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `client_id` int(11) NOT NULL,
  `name` varchar(225) DEFAULT NULL,
  `email` varchar(225) NOT NULL,
  `username` varchar(225) DEFAULT NULL,
  `admin_type` enum('1','2') NOT NULL DEFAULT '2',
  `password` text NOT NULL,
  `telephone` varchar(225) DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  `telegram` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `balance` decimal(21,4) NOT NULL DEFAULT 0.0000,
  `spent` decimal(21,4) NOT NULL DEFAULT 0.0000,
  `balance_type` enum('1','2') NOT NULL DEFAULT '2',
  `debit_limit` double DEFAULT NULL,
  `register_date` datetime NOT NULL,
  `login_date` datetime DEFAULT NULL,
  `login_ip` varchar(225) DEFAULT NULL,
  `apikey` text NOT NULL,
  `tel_type` enum('1','2') NOT NULL DEFAULT '1' COMMENT '2 -> ON, 1 -> OFF',
  `email_type` enum('1','2') NOT NULL DEFAULT '1' COMMENT '2 -> ON, 1 -> OFF',
  `client_type` enum('1','2') NOT NULL DEFAULT '2' COMMENT '2 -> ON, 1 -> OFF',
  `access` text DEFAULT NULL,
  `lang` varchar(255) NOT NULL DEFAULT 'tr',
  `timezone` double NOT NULL DEFAULT 0,
  `currency_type` varchar(10) DEFAULT NULL,
  `ref_code` text NOT NULL,
  `ref_by` text DEFAULT NULL,
  `change_email` enum('1','2') NOT NULL DEFAULT '2',
  `resend_max` int(11) NOT NULL DEFAULT 3,
  `currency` varchar(225) NOT NULL DEFAULT '1',
  `passwordreset_token` varchar(225) NOT NULL,
  `discount_percentage` int(11) NOT NULL,
  `broadcast_id` varchar(255) NOT NULL DEFAULT '0',
  `google_login_verified` tinyint(1) DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`client_id`, `name`, `email`, `username`, `admin_type`, `password`, `telephone`, `whatsapp`, `telegram`, `website`, `balance`, `spent`, `balance_type`, `debit_limit`, `register_date`, `login_date`, `login_ip`, `apikey`, `tel_type`, `email_type`, `client_type`, `access`, `lang`, `timezone`, `currency_type`, `ref_code`, `ref_by`, `change_email`, `resend_max`, `currency`, `passwordreset_token`, `discount_percentage`, `broadcast_id`, `google_login_verified`) VALUES
(1, 'sqq', 'smm@gmail.com', 'sqq00', '2', '25d55ad283aa400af464c76d713c07ad', '0909898978', '0909898978', 'smm', 'https://smm.com/', 5.7816, 0.2184, '2', 0, '2025-11-17 02:11:04', '2025-01-21 22:12:29', '103.147.162.143', 'a476fd3728ea22c5c57fd10dd1eac76c', '', '2', '2', 'null', 'en', 0, 'USD', '', NULL, '2', 3, '1', '', 0, '1', 1),
(2, 'md emon', 'mdemonsha022@gmail.com', 'mdemon90', '2', 'd138286df3ef582d33c2dac3fbd30256', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-17 21:28:24', '2025-01-17 21:28:24', '103.147.162.143', '55a35d8dc38791662283783eee28d18d', '1', '2', '2', NULL, 'en', 0, 'USD', '1a2e07', NULL, '2', 3, '1', '', 0, '0', 1),
(3, '', 'ysnkxdnihtf@yahoo.com', 'rKDMJsFPE', '2', 'b4364dfc4367d90904c39ed6e077d5c3', '5991518001', 'GQEzqSglhL', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-18 17:06:56', '2025-01-18 17:06:56', NULL, 'b674194976c975de2b0e23bf7fb5d0d0', '1', '2', '1', NULL, 'en', 0, 'USD', '36a1af', NULL, '2', 3, '1', '', 0, '0', 0),
(4, 'Tuhin Rana', 'onlineservay35@gmail.com', 'tuhinrana42', '2', 'f538143c6293e24b511cfb0de22a84f7', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-19 01:23:42', '2025-01-19 01:23:42', '59.152.14.113', '0f23618d50c120d8f7c68736bcde061c', '1', '2', '2', NULL, 'en', 0, 'USD', 'd702e9', NULL, '2', 3, '1', '', 0, '0', 1),
(5, '', 'zkdnfndbx@gmail.com', 'Shihab001', '2', 'e5e18ff5d57d49a4a303939b665ad4a4', '01739448890', '01706952669', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-19 11:01:07', '2025-01-19 11:01:07', NULL, '86b1f1e94c4373ed500a93f0c92224d0', '1', '2', '2', NULL, 'en', 0, 'USD', '08af67', NULL, '2', 3, '1', '', 0, '0', 0),
(6, '', 'imjoker0066@gmail.com', 'Priyo06', '2', '091827fec21718b4565862b4f29a10be', '01326877707', '01326877708', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-19 11:32:22', '2025-01-19 11:32:22', NULL, '236d2f97d529cf9c60e681f2145463fb', '1', '2', '2', NULL, 'en', 0, 'USD', '7834be', NULL, '2', 3, '1', '', 0, '0', 0),
(7, '', 'tamzidulislam18@gamil.com', 'tamzid', '2', 'ccb7310b08e256138227eedbf02e831f', 'Kspapakaj', 'Jksoajah', '', '', 0.1200, 0.0000, '2', NULL, '2025-01-19 11:55:35', '2025-01-19 11:55:35', NULL, '34445b9ce31dfd0fa9d1e9c05c1b794c', '1', '2', '2', NULL, 'en', 0, 'USD', 'dc4d35', NULL, '2', 3, '1', '', 0, '1', 0),
(8, '', 'babuofficial185@gmail.com', 'sabbir', '2', '520c8866b5d0ad9f3b173b82c6beb767', '01795184555', '01303193143', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-19 13:20:11', '2025-01-19 13:21:03', '103.106.242.98', '1ac7e08e4042b11ded054ac1d2ebb618', '1', '2', '2', NULL, 'en', 0, 'USD', '543833', NULL, '2', 3, '1', '', 0, '1', 0),
(9, '', 'ma1847509@gmail.com', 'Taizu75', '2', '6de4d85a7f7f91d8ddff290ea77730da', '01789931694', '01789931694', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-19 13:32:56', '2025-01-19 13:32:56', NULL, '1e18b4645002f697da4c4f028a89e9fa', '1', '2', '2', NULL, 'en', 0, 'USD', '4a220c', NULL, '2', 3, '1', '', 0, '1', 0),
(10, '', 'pmwxjbprihn@yahoo.com', 'gydrVRuDYNFbmm', '2', '16375f710dfec0d2354e5d41a30026f6', '4547113787', 'asJnObGHY', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-19 14:33:04', '2025-01-19 14:33:04', NULL, 'f7807ab2d0f7512291d2dcf729161f9d', '1', '2', '1', NULL, 'en', 0, 'USD', '464355', NULL, '2', 3, '1', '', 0, '0', 0),
(11, 'Nadi Islam', 'nadi54142@gmail.com', 'nadiislam61', '2', '0318c9f5d3612183691ac70a82be61cb', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-19 20:45:51', '2025-01-19 20:45:51', '103.107.135.149', '5eb76f142e1aaf23f6304ea15c4ce0c7', '1', '2', '2', NULL, 'en', 0, 'USD', '369240', NULL, '2', 3, '1', '', 0, '0', 1),
(12, '', 'onlinesercvay35@gmail.com', 'Tuhin', '2', 'b3f0ffa37d32fbb549451f5941377b46', '01307680513', '+8801307680512', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-20 12:29:48', '2025-01-20 12:29:48', NULL, 'baaa2dcf6ff9f08e664054e08d5ed991', '1', '2', '2', NULL, 'en', 0, 'USD', '396ae6', NULL, '2', 3, '1', '', 0, '0', 0),
(13, 'SR Khan', 'srk044176@gmail.com', 'srkhan28', '2', '7280d021d5812f4105b3823c965388c6', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-20 12:41:52', '2025-01-20 12:41:52', '114.130.188.236', '84dbf2c83164d7d03bf048d3ec23d595', '1', '2', '2', NULL, 'en', 0, 'USD', '25ac5c', NULL, '2', 3, '1', '', 0, '0', 1),
(14, 'md jihad', 'mdjijadjh@gmail.com', 'mdjihad18', '2', 'a92673e41a1b2568de319248f65a6df2', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-20 13:13:41', '2025-01-20 13:13:41', '37.111.237.27', 'dbbbe4a278d22fe54fee893bf8d069d2', '1', '2', '2', NULL, 'en', 0, 'USD', 'c8e75f', NULL, '2', 3, '1', '', 0, '0', 1),
(15, 'Maruf Ahmed Raj', 'marufahmedraj418@gmail.com', 'marufahmed raj24', '2', '09ec73bd070fab5353d88bd7df411374', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-20 13:17:41', '2025-01-20 13:17:41', '103.181.180.39', '030872ce972db64da17b34b413696d41', '1', '2', '2', NULL, 'en', 0, 'USD', '218e3f', NULL, '2', 3, '1', '', 0, '0', 1),
(16, 'Tuba Akter', '2024tubaakter2024@gmail.com', 'tubaakter34', '2', '67fb0cfcd88ee7a91fbad18e116d0c89', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-20 15:35:24', '2025-01-20 15:35:24', '59.152.5.231', '5f8d9a1828a5bab1b93f616f7992852f', '1', '2', '2', NULL, 'en', 0, 'USD', '2c8546', NULL, '2', 3, '1', '', 0, '0', 1),
(17, 'Imran Sha', 'shai62079@gmail.com', 'imransha40', '2', 'ed4e8516246fcc3c58aadc97b7d4c458', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-20 22:42:18', '2025-01-20 22:42:18', '103.147.162.143', '7d3ccb9c565826dbe6de0db716b0c485', '1', '2', '2', NULL, 'en', 0, 'USD', '80a34c', NULL, '2', 3, '1', '', 0, '1', 1),
(18, 'Ashik Islam', 'ashikislam5989@gmail.com', 'ashikislam14', '2', '183535055c2b3ecf7d07d010addf16ae', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-20 22:42:33', '2025-01-20 22:42:33', '103.147.162.143', 'd11b3808f152e22e840a52cca6f75d36', '1', '2', '2', NULL, 'en', 0, 'USD', '36af7b', NULL, '2', 3, '1', '', 0, '1', 1),
(19, 'Lore Literature', 'info.loreandliterature@gmail.com', 'loreliterature73', '2', 'cfafd38be4e547afdea47d56a7b277d0', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-20 22:55:21', '2025-01-20 22:55:21', '103.205.69.44', '25aa476daf082dabf9d7a205ece09d59', '1', '2', '2', NULL, 'en', 0, 'USD', 'ed46f5', NULL, '2', 3, '1', '', 0, '1', 1),
(20, 'MD Saddam Hosen', 'saddamdear68@gmail.com', 'mdsaddam hosen34', '2', 'ddc82b6b13aa19825a46a91176fbe22f', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-21 11:35:26', '2025-01-21 11:35:26', '42.0.7.227', 'e057927bda3f7bd70f2ec54effc0071e', '1', '2', '2', NULL, 'en', 0, 'USD', '177d6e', NULL, '2', 3, '1', '', 0, '1', 1),
(21, '', 'zekemalkova@gmail.com', 'zkmlkv', '2', '315eb115d98fcbad39ffc5edebd669c9', '09274605567', '', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-21 19:48:13', '2025-01-21 19:48:13', NULL, '7b986b22989490d481f24651ed8ec8a7', '1', '2', '2', NULL, 'en', 0, 'USD', '07e0dd', NULL, '2', 3, '1', '', 0, '0', 0),
(22, 'Amit Das', 'amit878730@gmail.com', 'amitdas97', '2', '72ddf52a46cfac6274fbc123b1f9c2cc', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-21 19:49:12', '2025-01-21 19:49:12', '152.58.171.177', '3cb83d3caf9d6a7988f8e74c19ef516b', '1', '2', '2', NULL, 'en', 0, 'INR', '1de246', NULL, '2', 3, '1', '', 0, '0', 1),
(23, '', 'fbduyhung@gmail.com', 'Duyhung2006', '2', '3f8756dc8ca22624329e2a77a41e2625', '84375360180', '', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-21 20:12:32', '2025-01-21 20:12:32', NULL, '37fae1d9039d9188aabf02d21fa0a773', '1', '2', '2', NULL, 'en', 0, 'USD', '5b709d', NULL, '2', 3, '1', '', 0, '0', 0),
(24, 'Anil sharma', 'sa6624782@gmail.com', 'anilsharma3', '2', 'c4d6ed760eea7e1ae3f05f1ad662d9e0', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-21 20:18:20', '2025-01-21 20:18:20', '152.59.84.17', 'd441e14e96c3a8540bb1ceaa45189393', '1', '2', '2', NULL, 'en', 0, 'INR', '7a2967', NULL, '2', 3, '1', '', 0, '0', 1),
(25, '', 'smmgon6e@gmail.com', 'smmgone2', '2', '25d55ad283aa400af464c76d713c07ad', '01864614704', '', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-21 20:51:33', '2025-01-21 20:51:33', '103.147.162.143', '8c8f67c61630248d78db9539c3e754ab', '1', '2', '2', NULL, 'en', 0, 'USD', '796511', NULL, '2', 3, '1', '', 0, '0', 0),
(26, '', 'michellebelen47@gmail.com', 'arzel', '2', '1b2de2499e5f93e00a5a90e79a9da4b1', '8282727292937', '', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-21 20:55:56', '2025-01-21 20:55:56', '175.176.8.11', '8bd6b5e539dddab3faed5f8bd4b7eadc', '1', '2', '2', NULL, 'en', 0, 'USD', 'c691c8', NULL, '2', 3, '1', '', 0, '0', 0),
(27, 'Islamic Life', 'mdseyam642@gmail.com', 'islamiclife20', '2', '5964dcfc9c6d0f8136a348c0ada28a5b', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-21 21:11:20', '2025-01-21 21:11:20', '103.147.162.143', '34fa75581cee1862a55b871720c22172', '1', '2', '2', NULL, 'en', 0, 'USD', '327013', NULL, '2', 3, '1', '', 0, '0', 1),
(28, 'Pozz Bong', 'pozzbong32@gmail.com', 'pozzbong59', '2', 'afb495c0fa7d57d99019f53ff26d7743', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-21 21:14:03', '2025-01-21 21:14:03', '103.90.149.72', '1de5e8a743d533d2edecc123d6e67f75', '1', '2', '2', NULL, 'en', 0, 'USD', '53bb4f', NULL, '2', 3, '1', '', 0, '0', 1),
(29, '', 'agentfreefire2020@gmail.com', 'Kowshik69', '2', '2fffb33201163fc50a3c4a472e347e4a', '01978784094', '', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-21 22:03:43', '2025-01-21 22:03:43', '103.167.208.139', '5a5b566ef5ac50b8e0525590f63b5a41', '1', '2', '2', NULL, 'en', 0, 'USD', '919ae9', NULL, '2', 3, '1', '', 0, '0', 0),
(30, '', 'mdfahimx69@gmail.com', 'hasandf54', '2', 'dcf10fffeeb66d5ea457e3f4123f51f3', '01647469834', '', '', '', 0.0069, 1.5731, '2', NULL, '2025-01-21 22:09:42', '2025-01-21 22:09:42', '58.145.186.131', '974138342b1d7c6e62a675c6d2c988c2', '1', '2', '2', NULL, 'en', 0, 'USD', 'e165e7', NULL, '2', 3, '1', '', 0, '1', 0),
(31, 'Freehack 3', 'freehackhan3@gmail.com', 'freehack327', '2', 'c24e6a60c527d749b96c035e44b60e31', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-21 23:16:13', '2025-01-21 23:16:13', '111.88.212.205', 'a9aa19558f39a95027bea7e6c0a56238', '1', '2', '2', NULL, 'en', 0, 'USD', '05a19d', NULL, '2', 3, '1', '', 0, '0', 1),
(32, '', 'hapyhu098@gmail.com', 'Test', '2', 'dd4b21e9ef71e1291183a46b913ae6f2', '+923282626753', '', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-21 23:28:06', '2025-01-21 23:28:06', '111.88.212.205', 'eb7f2999ccfd8b38c8abe72efccb26b1', '1', '2', '2', NULL, 'en', 0, 'USD', '7dfd91', NULL, '2', 3, '1', '', 0, '0', 0),
(33, 'Rex Gamer', 'fakegarl12@gmail.com', 'rexgamer60', '2', '4ea16715e2c637b8a8a29f5fb322edca', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-22 05:05:28', '2025-01-22 05:05:28', '103.112.150.125', 'f9d6abf1155f5f5bf19c5d7842f163ad', '1', '2', '2', NULL, 'en', 0, 'BDT', 'c23c57', NULL, '2', 3, '1', '', 0, '0', 1),
(34, 'HH X', 'hhx009@gmail.com', 'hhx42', '2', '9f7b0acfcd8bb4e3b2757852c27e2f80', '', NULL, NULL, NULL, 0.0000, 0.0000, '2', NULL, '2025-01-22 09:17:35', '2025-01-22 09:17:35', '223.123.8.174', '1b6c8c559c8435d4705e55830101c275', '1', '2', '2', NULL, 'en', 0, 'PKR', 'c34f34', NULL, '2', 3, '1', '', 0, '0', 1),
(35, '', 'mhdfaiz2204@gmail.com', 'Starfaiz', '2', '65c166143ac8f4c474c3b570477f8980', '6283878745917', '', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-22 10:50:00', '2025-01-22 10:50:00', '36.76.107.158', 'f9afd4d4ab43879f8bd99166a29cbd3b', '1', '2', '2', NULL, 'en', 0, 'USD', '923bdc', NULL, '2', 3, '1', '', 0, '0', 0),
(36, '', 'mrriot798@gmail.com', 'Wiowowo', '2', '1102555e2c507d376ba8886332c0eeab', '01740669380', '', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-22 14:35:25', '2025-01-22 14:35:25', '103.96.104.159', '811e35e9bcff9549e7b8ce214bded868', '1', '2', '2', NULL, 'en', 0, 'USD', '9ad650', NULL, '2', 3, '1', '', 0, '0', 0),
(37, '', 'hswnjksrjk2@gmail.com', 'Unlock', '2', '25d55ad283aa400af464c76d713c07ad', '1234567890', '', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-22 15:16:39', '2025-02-17 13:59:07', '203.215.167.45', 'cf3510015d2b5730bfc43fc82ed36fb1', '1', '2', '2', NULL, 'en', 0, 'PKR', 'a4a2e7', NULL, '2', 3, '1', '', 0, '0', 0),
(38, '', 'ip8658@gmail.com', 'Hshhs', '2', '25d55ad283aa400af464c76d713c07ad', '737363736362', '', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-24 15:08:05', '2025-01-24 15:08:05', '152.59.130.106', 'b5f26d81097144305bdff8e53959ce9b', '1', '2', '2', NULL, 'en', 0, 'USD', 'e300ac', NULL, '2', 3, '1', '', 0, '1', 0),
(39, '', 'monaseemraza251@gmail.com', 'Naseem1430', '2', '2f0011573c8e1ab918180d784e6c5100', '8303020723', '', '', '', 0.0000, 0.0000, '2', NULL, '2025-01-31 20:12:15', '2025-01-31 20:12:15', '152.58.128.51', 'b25f6ec19e30dc3d3948aa582af8b1b8', '1', '2', '2', NULL, 'en', 0, 'INR', '0598a6', NULL, '2', 3, '1', '', 0, '0', 0),
(40, '', 'imfectone@gmail.com', 'anshuman', '2', 'aabde52194f82228521f6f6ccb48fe67', '0000000990', '', '', '', 0.0000, 0.0000, '2', NULL, '2025-02-01 11:45:37', '2025-02-01 11:45:37', '103.48.197.5', '91bb3c731197d3bf464bac19b5e34c7a', '1', '2', '2', NULL, 'en', 0, 'USD', 'fa3d83', NULL, '2', 3, '1', '', 0, '0', 0),
(41, '', 'gh.abbasrj@gmail.com', 'Abbas5297', '2', 'd3b85817c32fc6bee6d32eabab602ffe', '03053132167', '', '', '', 0.0000, 0.0000, '2', NULL, '2025-02-04 09:45:14', '2025-02-04 21:36:23', '223.123.14.99', '4418ee81efa5dcdb74fa32e8f170a133', '1', '2', '2', NULL, 'en', 0, 'PKR', '41656d', NULL, '2', 3, '1', '', 0, '0', 0),
(42, '', 'ameezfarmood7@gmail.com', 'Ameez', '2', 'a6ad17126992f68cbb97f52f2e920a01', '923707702380', '', '', '', 0.1794, 0.0000, '2', NULL, '2025-02-17 14:03:11', '2025-02-17 14:03:11', '103.179.246.207', '4746149d8c43d9b1180be41b8873fb9f', '1', '2', '2', NULL, 'en', 0, 'PKR', 'f6ce3e', NULL, '2', 3, '1', '', 0, '0', 0),
(43, '', 'ahsan.taqweem777@gmail.com', 'ahsan', '2', 'f8eb3fa0cdbb6b0d4c692c11c6c0b0e3', '03145258932 ', '', '', '', 0.0179, 0.0000, '2', NULL, '2025-02-21 23:20:31', '2025-02-21 23:20:31', '203.215.167.45', '5e21c70e2e4d964654cda80f51eba23e', '1', '2', '2', NULL, 'en', 0, 'PKR', 'e9ffc4', NULL, '2', 3, '1', '', 0, '0', 0),
(44, '', 'masonglinisi3@gmail.com', 'GoSTKcrcPQPKGT', '2', 'c47d461685c1778d86923eda0d449f62', NULL, '', '', '', 0.0000, 0.0000, '2', NULL, '2025-02-22 08:10:28', '2025-02-22 08:10:28', '197.255.52.122', '21b1cdde5b4003d929ca68eb7c6679b7', '1', '2', '2', NULL, 'en', 0, 'USD', '2c9c7d', NULL, '2', 3, '1', '', 0, '0', 0),
(45, '', 'hamidrahman4040@gmail.com', 'Hamid', '2', '25d55ad283aa400af464c76d713c07ad', NULL, '', '', '', 0.0000, 0.0000, '2', NULL, '2025-02-22 16:36:40', '2025-02-22 16:36:40', '223.123.90.12', 'e48780b4c339807d33e9a57258b6594c', '1', '2', '2', NULL, 'en', 0, 'PKR', 'e4de27', NULL, '2', 3, '1', '', 0, '0', 0);

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

--
-- Table structure for table `clients_category`
--

CREATE TABLE `clients_category` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `clients_price`
--

CREATE TABLE `clients_price` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `service_price` double NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `clients_service`
--

CREATE TABLE `clients_service` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `clients_service`
--

INSERT INTO `clients_service` (`id`, `client_id`, `service_id`) VALUES
(4, 1, 381),
(3, 28, 381);

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

--
-- Table structure for table `client_report`
--

CREATE TABLE `client_report` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `action` text NOT NULL,
  `report_ip` varchar(225) NOT NULL,
  `report_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `client_report`
--

INSERT INTO `client_report` (`id`, `client_id`, `action`, `report_ip`, `report_date`) VALUES
(1, 1, 'Member logged in.', '103.147.162.143', '2025-01-17 18:23:37'),
(2, 1, 'API Key changed', '103.147.162.143', '2025-01-17 20:31:41'),
(3, 1, 'New support ticket created#1', '103.147.162.143', '2025-01-17 20:32:52'),
(4, 1, 'Member logged in.', '103.147.162.143', '2025-01-17 21:21:14'),
(5, 2, 'Signed up using Google', '103.147.162.143', '2025-01-17 21:28:24'),
(6, 1, 'Member logged in.', '103.147.162.143', '2025-01-17 21:30:02'),
(7, 1, 'Member logged in.', '103.147.162.143', '2025-01-18 09:02:03'),
(8, 1, '0.02464 New Order #1.', '103.147.162.143', '2025-01-18 09:16:06'),
(9, 1, '#1 Order number of has been completed.', '127.0.0.1', '2025-01-18 09:20:03'),
(10, 1, 'Member logged in.', '103.147.162.143', '2025-01-18 10:10:35'),
(11, 3, '\r\n    User registered.', '143.0.141.70', '2025-01-18 17:06:56'),
(12, 1, 'API Key changed', '103.147.162.143', '2025-01-18 21:03:15'),
(13, 1, 'Logged in using Google', '103.147.162.143', '2025-01-18 22:13:50'),
(14, 4, 'Signed up using Google', '59.152.14.113', '2025-01-19 01:23:42'),
(15, 5, '\r\n    User registered.', '182.48.70.31', '2025-01-19 11:01:07'),
(16, 6, '\r\n    User registered.', '103.120.222.151', '2025-01-19 11:32:22'),
(17, 7, '\r\n    User registered.', '58.145.184.213', '2025-01-19 11:55:35'),
(18, 8, '\r\n    User registered.', '103.120.202.185', '2025-01-19 13:20:11'),
(19, 8, 'Member logged in.', '103.106.242.98', '2025-01-19 13:21:03'),
(20, 9, '\r\n    User registered.', '202.134.10.130', '2025-01-19 13:32:56'),
(21, 10, '\r\n    User registered.', '115.79.217.131', '2025-01-19 14:33:04'),
(22, 1, 'Member logged in.', '103.147.162.143', '2025-01-19 18:39:01'),
(23, 1, 'Member logged in.', '103.147.162.143', '2025-01-19 19:35:07'),
(24, 11, 'Signed up using Google', '103.107.135.149', '2025-01-19 20:45:51'),
(25, 1, 'Member logged in.', '103.147.162.143', '2025-01-19 20:51:00'),
(26, 1, 'Member logged in.', '103.147.162.143', '2025-01-19 22:33:07'),
(27, 1, '0.066375 New Order #2.', '103.147.162.143', '2025-01-20 08:41:23'),
(28, 1, 'Member logged in.', '103.147.162.143', '2025-01-20 10:36:51'),
(29, 12, '\r\n    User registered.', '59.152.14.113', '2025-01-20 12:29:48'),
(30, 1, 'Member logged in.', '103.147.162.143', '2025-01-20 12:36:13'),
(31, 1, 'API Key changed', '103.147.162.143', '2025-01-20 12:37:03'),
(32, 13, 'Signed up using Google', '114.130.188.236', '2025-01-20 12:41:52'),
(33, 14, 'Signed up using Google', '37.111.237.27', '2025-01-20 13:13:41'),
(34, 15, 'Signed up using Google', '103.181.180.39', '2025-01-20 13:17:41'),
(35, 16, 'Signed up using Google', '59.152.5.231', '2025-01-20 15:35:24'),
(36, 1, 'Member logged in.', '103.147.162.143', '2025-01-20 18:19:14'),
(37, 1, 'Member logged in.', '103.147.162.143', '2025-01-20 21:47:40'),
(38, 1, 'Member logged in.', '103.147.162.143', '2025-01-20 21:49:27'),
(39, 1, 'Member logged in.', '103.147.162.143', '2025-01-20 22:16:30'),
(40, 1, 'Member logged in.', '103.147.162.143', '2025-01-20 22:36:50'),
(41, 17, 'Signed up using Google', '103.147.162.143', '2025-01-20 22:42:18'),
(42, 18, 'Signed up using Google', '103.147.162.143', '2025-01-20 22:42:33'),
(43, 1, 'Member logged in.', '103.147.162.143', '2025-01-20 22:43:52'),
(44, 19, 'Signed up using Google', '103.205.69.44', '2025-01-20 22:55:21'),
(45, 1, 'Member logged in.', '103.147.162.143', '2025-01-21 00:40:25'),
(46, 1, '0.0227696 New Order #3.', '103.147.162.143', '2025-01-21 08:56:34'),
(47, 1, '#2 Order numbered has been canceled and 0.066375 refunded Old balance:5.8862 / New balance:5.9526', '127.0.0.1', '2025-01-21 09:25:07'),
(48, 1, '#3 Order number of has been completed.', '127.0.0.1', '2025-01-21 10:40:03'),
(49, 20, 'Signed up using Google', '42.0.7.227', '2025-01-21 11:35:26'),
(50, 21, '\r\n    User registered.', '216.247.29.71', '2025-01-21 19:48:13'),
(51, 22, 'Signed up using Google', '152.58.171.177', '2025-01-21 19:49:12'),
(52, 21, 'API Key changed', '216.247.29.71', '2025-01-21 19:49:52'),
(53, 23, '\r\n    User registered.', '14.167.96.67', '2025-01-21 20:12:32'),
(54, 24, 'Signed up using Google', '152.59.84.17', '2025-01-21 20:18:20'),
(55, 25, '\r\n    User registered.', '103.147.162.143', '2025-01-21 20:51:33'),
(56, 26, '\r\n    User registered.', '175.176.8.11', '2025-01-21 20:55:56'),
(57, 27, 'Signed up using Google', '103.147.162.143', '2025-01-21 21:11:20'),
(58, 28, 'Signed up using Google', '103.90.149.72', '2025-01-21 21:14:03'),
(59, 1, 'Member logged in.', '103.147.162.143', '2025-01-21 21:19:16'),
(60, 27, 'Logged in using Google', '103.147.162.143', '2025-01-21 21:55:13'),
(61, 27, 'Logged in using Google', '103.147.162.143', '2025-01-21 22:01:23'),
(62, 29, '\r\n    User registered.', '103.167.208.139', '2025-01-21 22:03:43'),
(63, 27, 'Logged in using Google', '103.147.162.143', '2025-01-21 22:07:29'),
(64, 27, 'Logged in using Google', '103.147.162.143', '2025-01-21 22:09:18'),
(65, 30, '\r\n    User registered.', '58.145.186.131', '2025-01-21 22:09:42'),
(66, 2, 'Logged in using Google', '103.147.162.143', '2025-01-21 22:11:50'),
(67, 1, 'User Logged in.', '103.147.162.143', '2025-01-21 22:12:29'),
(68, 27, 'User Logged in using Google', '103.147.162.143', '2025-01-21 22:17:04'),
(69, 27, 'User Logged in using Google', '103.147.162.143', '2025-01-21 22:18:49'),
(70, 1, 'User Logged in using Google', '103.147.162.143', '2025-01-21 22:35:34'),
(71, 27, 'User Logged in using Google', '103.147.162.143', '2025-01-21 22:36:46'),
(72, 1, 'User Logged in using Google', '103.147.162.143', '2025-01-21 22:37:08'),
(73, 1, '0.0025 - New Order Placed , Order Id - #4.', '103.147.162.143', '2025-01-21 22:37:21'),
(74, 1, ' 0.0005 - New Order Placed, Order Id - #5.', '103.147.162.143', '2025-01-21 22:42:30'),
(75, 1, '0.0325 - New Order Placed , Order Id - #6.', '103.147.162.143', '2025-01-21 22:46:31'),
(76, 31, 'User Signed up using Google', '111.88.212.205', '2025-01-21 23:16:13'),
(77, 31, 'User Logged in using Google', '111.88.212.205', '2025-01-21 23:20:24'),
(78, 32, '\r\n    User registered.', '111.88.212.205', '2025-01-21 23:28:06'),
(79, 32, 'User Logged in using Google', '111.88.212.205', '2025-01-21 23:28:27'),
(80, 32, 'User Logged in using Google', '111.88.212.205', '2025-01-21 23:38:10'),
(81, 30, '1.57311 - New Order Placed , Order Id - #7.', '103.231.160.120', '2025-01-22 00:16:23'),
(82, 33, 'User Signed up using Google', '103.112.150.125', '2025-01-22 05:05:28'),
(83, 34, 'User Signed up using Google', '223.123.8.174', '2025-01-22 09:17:35'),
(84, 1, '0.171 - New Order Placed , Order Id - #8.', '103.147.162.143', '2025-01-22 09:28:21'),
(85, 35, '\r\n    User registered.', '36.76.107.158', '2025-01-22 10:50:00'),
(86, 1, '0.0005 - New Order Placed , Order Id - #9.', '103.147.162.143', '2025-01-22 11:24:23'),
(87, 1, '#8 Order number of has been completed.', '127.0.0.1', '2025-01-22 12:10:03'),
(88, 2, 'User Logged in using Google', '103.147.162.143', '2025-01-22 12:30:28'),
(89, 1, 'User Logged in using Google', '103.147.162.143', '2025-01-22 12:59:50'),
(90, 36, '\r\n    User registered.', '103.96.104.159', '2025-01-22 14:35:25'),
(91, 37, '\r\n    User registered.', '152.56.69.251', '2025-01-22 15:16:39'),
(92, 37, 'User Logged in.', '152.56.69.251', '2025-01-22 17:07:25'),
(93, 38, '\r\n    User registered.', '152.59.130.106', '2025-01-24 15:08:05'),
(94, 37, 'User Logged in.', '152.59.83.44', '2025-01-25 09:49:39'),
(95, 37, 'User Logged in.', '152.59.83.44', '2025-01-25 10:11:06'),
(96, 37, 'User Logged in.', '27.34.67.3', '2025-01-26 11:42:22'),
(97, 37, 'API Key changed', '38.255.149.45', '2025-01-26 11:44:39'),
(98, 37, 'User Logged in.', '152.59.82.72', '2025-01-31 13:09:50'),
(99, 37, 'User Logged in.', '152.59.82.72', '2025-01-31 13:24:58'),
(100, 39, '\r\n    User registered.', '152.58.128.51', '2025-01-31 20:12:15'),
(101, 40, '\r\n    User registered.', '103.48.197.5', '2025-02-01 11:45:37'),
(102, 41, '\r\n    User registered.', '154.80.62.138', '2025-02-04 09:45:14'),
(103, 41, 'User Logged in.', '39.63.32.92', '2025-02-04 14:40:59'),
(104, 41, 'User Logged in.', '223.123.14.99', '2025-02-04 21:12:44'),
(105, 41, 'User Logged in.', '223.123.14.99', '2025-02-04 21:36:23'),
(106, 37, 'User Logged in.', '203.215.167.45', '2025-02-17 13:59:07'),
(107, 42, '\r\n    User registered.', '103.179.246.207', '2025-02-17 14:03:11'),
(108, 43, '\r\n    User registered.', '203.215.167.45', '2025-02-21 23:20:31'),
(109, 44, '\r\n    User registered.', '197.255.52.122', '2025-02-22 08:10:28'),
(110, 45, '\r\n    User registered.', '223.123.90.12', '2025-02-22 16:36:40');

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

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` int(11) NOT NULL,
  `currency_name` varchar(50) NOT NULL,
  `currency_code` varchar(10) NOT NULL,
  `currency_symbol` varchar(10) DEFAULT NULL,
  `symbol_position` varchar(10) DEFAULT 'left',
  `currency_rate` double NOT NULL,
  `currency_inverse_rate` double NOT NULL,
  `is_enable` tinyint(1) NOT NULL DEFAULT 0,
  `currency_hash` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `currency_name`, `currency_code`, `currency_symbol`, `symbol_position`, `currency_rate`, `currency_inverse_rate`, `is_enable`, `currency_hash`) VALUES
(1, 'U.S. Dollar', 'USD', '$', 'left', 1, 1, 1, '1ca4e489244df4f85562f65a3ca0eed258cacaac'),
(2, 'Bangladeshi taka', 'BDT', '৳', 'right', 121.8057380727, 0.00820979385555, 1, 'b73510d169b467de8ded49cc7f484002fb3a627f'),
(4, 'Indian Rupee', 'INR', '₹', 'right', 86.518471133856, 0.011558225508318, 1, '4a0b04046ec8d37a7aa5e4def4a685ae13212485'),
(14, 'Pakistani Rupee', 'PKR', '₨', 'right', 278.65382577153, 0.0035886821120479, 1, 'bdfc84040bbedcd0cae9375f454c7475512a250d');

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

--
-- Table structure for table `custom_settings`
--

CREATE TABLE `custom_settings` (
  `id` int(11) NOT NULL,
  `snow_data` text NOT NULL,
  `snow_data_array` text NOT NULL,
  `snow_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '1 - inactive , 2 - active',
  `start_count_parser` text NOT NULL,
  `orders_count_increase` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `custom_settings`
--

INSERT INTO `custom_settings` (`id`, `snow_data`, `snow_data_array`, `snow_status`, `start_count_parser`, `orders_count_increase`) VALUES
(1, '\"snow\":{\"init\":false,\"options\":{\"particles\":{\"move\":{\"speed\":,\"bounce\":false,\"enable\":true,\"random\":false,\"attract\":{\"enable\":false,\"rotateX\":600,\"rotateY\":1200},\"out_mode\":\"out\",\"straight\":false,\"direction\":\"bottom\"},\"size\":{\"anim\":{\"sync\":false,\"speed\":40,\"enable\":false,\"size_min\":0.1},\"value\":10,\"random\":true},\"color\":{\"value\":\"#fff\"},\"number\":{\"value\":,\"density\":{\"enable\":true,\"value_area\":650}},\"opacity\":{\"anim\":{\"sync\":false,\"speed\":1,\"enable\":true,\"opacity_min\":0.9},\"value\":0.9,\"random\":true},\"line_linked\":{\"color\":\"#ffffff\",\"width\":1,\"enable\":false,\"opacity\":0.8,\"distance\":500}},\"interactivity\":{\"modes\":{\"bubble\":{\"size\":4,\"speed\":3,\"opacity\":1,\"distance\":400,\"duration\":0.3},\"repulse\":{\"speed\":3,\"distance\":200,\"duration\":0.4}},\"events\":{\"resize\":true,\"onclick\":{\"mode\":\"repulse\",\"enable\":true},\"onhover\":{\"mode\":\"bubble\",\"enable\":false}},\"detect_on\":\"window\"},\"retina_detect\":true}},\"toys\":{\"init\":false,\"options\":{\"count\":100,\"speed\":1,\"images\":[],\"maxSize\":30,\"launches\":\"1\"}},\"garland\":{\"init\":false,\"options\":{\"type\":\"\",\"style\":\"\"}},\"fireworks\":{\"init\":false,\"options\":{\"delay\":{\"max\":30,\"min\":30},\"friction\":,\"launches\":1,}}', '{\"snow_fall\":\"true\",\"snowflakes\":\"20\",\"snow_speed\":\"3\",\"garlands\":\"true\",\"gar_shape\":\"apple\",\"gar_style\":\"style1\",\"fire_works\":\"true\",\"fire_size\":\"0.95\",\"fire_speed\":\"slow\",\"toy_size\":\"80\",\"toy_quantity\":\"100\",\"toy_speed\":\"6\",\"toy_launch\":\"infinite\"}', '1', '{\"none\":\"Catch from supplier\",\"instagram_follower\":\"Instagram followers\",\"instagram_photo\":\"Instagram likes\",\"instagram_comments\":\"Instagram comments\",\"youtube_views\":\"Youtube views\",\"youtube_likes\":\"Youtube likes\",\"youtube_comments\":\"Youtube comments\",\"youtube_subscribers\":\"Youtube subscribers\"}', '0:0'),
(1, '\"snow\":{\"init\":false,\"options\":{\"particles\":{\"move\":{\"speed\":,\"bounce\":false,\"enable\":true,\"random\":false,\"attract\":{\"enable\":false,\"rotateX\":600,\"rotateY\":1200},\"out_mode\":\"out\",\"straight\":false,\"direction\":\"bottom\"},\"size\":{\"anim\":{\"sync\":false,\"speed\":40,\"enable\":false,\"size_min\":0.1},\"value\":10,\"random\":true},\"color\":{\"value\":\"#fff\"},\"number\":{\"value\":,\"density\":{\"enable\":true,\"value_area\":650}},\"opacity\":{\"anim\":{\"sync\":false,\"speed\":1,\"enable\":true,\"opacity_min\":0.9},\"value\":0.9,\"random\":true},\"line_linked\":{\"color\":\"#ffffff\",\"width\":1,\"enable\":false,\"opacity\":0.8,\"distance\":500}},\"interactivity\":{\"modes\":{\"bubble\":{\"size\":4,\"speed\":3,\"opacity\":1,\"distance\":400,\"duration\":0.3},\"repulse\":{\"speed\":3,\"distance\":200,\"duration\":0.4}},\"events\":{\"resize\":true,\"onclick\":{\"mode\":\"repulse\",\"enable\":true},\"onhover\":{\"mode\":\"bubble\",\"enable\":false}},\"detect_on\":\"window\"},\"retina_detect\":true}},\"toys\":{\"init\":false,\"options\":{\"count\":100,\"speed\":1,\"images\":[],\"maxSize\":30,\"launches\":\"1\"}},\"garland\":{\"init\":false,\"options\":{\"type\":\"\",\"style\":\"\"}},\"fireworks\":{\"init\":false,\"options\":{\"delay\":{\"max\":30,\"min\":30},\"friction\":,\"launches\":1,}}', '{\"snow_fall\":\"true\",\"snowflakes\":\"20\",\"snow_speed\":\"3\",\"garlands\":\"true\",\"gar_shape\":\"apple\",\"gar_style\":\"style1\",\"fire_works\":\"true\",\"fire_size\":\"0.95\",\"fire_speed\":\"slow\",\"toy_size\":\"80\",\"toy_quantity\":\"100\",\"toy_speed\":\"6\",\"toy_launch\":\"infinite\"}', '1', '{\"none\":\"Catch from supplier\",\"instagram_follower\":\"Instagram followers\",\"instagram_photo\":\"Instagram likes\",\"instagram_comments\":\"Instagram comments\",\"youtube_views\":\"Youtube views\",\"youtube_likes\":\"Youtube likes\",\"youtube_comments\":\"Youtube comments\",\"youtube_subscribers\":\"Youtube subscribers\"}', '0:0');

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

--
-- Table structure for table `decoration`
--

CREATE TABLE `decoration` (
  `id` int(11) NOT NULL,
  `snow_effect` int(11) NOT NULL,
  `snow_colour` text NOT NULL,
  `diwali_lights` int(11) NOT NULL,
  `video_link` text NOT NULL,
  `christmas_deco` varchar(5000) NOT NULL,
  `action_link` text NOT NULL,
  `pop_noti` int(11) NOT NULL,
  `pop_title` text NOT NULL,
  `pop_desc` text NOT NULL,
  `action_text` varchar(10) NOT NULL,
  `action_button` int(11) NOT NULL,
  `snow_fall` varchar(500) DEFAULT NULL,
  `garlands` text DEFAULT NULL,
  `fire_works` text DEFAULT NULL,
  `toys` text DEFAULT NULL,
  `snowflakes` int(11) NOT NULL,
  `snow_speed` int(11) NOT NULL,
  `gar_shape` text NOT NULL,
  `gar_style` text NOT NULL,
  `fire_size` varchar(100) NOT NULL,
  `fire_speed` text NOT NULL,
  `toy_size` int(11) NOT NULL,
  `toy_quantity` int(11) NOT NULL,
  `toy_speed` int(11) NOT NULL,
  `toy_launch` varchar(100) NOT NULL,
  `toy_a` varchar(50) NOT NULL,
  `toy_b` varchar(50) NOT NULL,
  `toy_c` varchar(50) NOT NULL,
  `toy_d` varchar(50) NOT NULL,
  `toy_e` varchar(50) NOT NULL,
  `toy_f` varchar(50) NOT NULL,
  `toy_g` varchar(50) NOT NULL,
  `toy_h` varchar(50) NOT NULL,
  `toy_i` varchar(50) NOT NULL,
  `toy_j` varchar(50) NOT NULL,
  `toy_k` varchar(50) NOT NULL,
  `psw_license` text NOT NULL,
  `toy_l` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `decoration`
--

INSERT INTO `decoration` (`id`, `snow_effect`, `snow_colour`, `diwali_lights`, `video_link`, `christmas_deco`, `action_link`, `pop_noti`, `pop_title`, `pop_desc`, `action_text`, `action_button`, `snow_fall`, `garlands`, `fire_works`, `toys`, `snowflakes`, `snow_speed`, `gar_shape`, `gar_style`, `fire_size`, `fire_speed`, `toy_size`, `toy_quantity`, `toy_speed`, `toy_launch`, `toy_a`, `toy_b`, `toy_c`, `toy_d`, `toy_e`, `toy_f`, `toy_g`, `toy_h`, `toy_i`, `toy_j`, `toy_k`, `psw_license`, `toy_l`) VALUES
(1, 0, '#ffffff', 0, '', ' <style>.particle-snow{position:fixed;top:0;left:0;width:100%;height:100%;z-index:1;pointer-events:none}.particle-snow canvas{position:fixed;top:0;left:0;width:100%;height:100%;pointer-events:none}.christmas-garland{text-align:center;white-space:nowrap;overflow:hidden;position:absolute;z-index:1;padding:0;pointer-events:none;width:100%;height:85px}.christmas-garland .christmas-garland__item{position:relative;width:28px;height:28px;border-radius:50%;display:inline-block;margin-left:20px}.christmas-garland .christmas-garland__item .shape{-webkit-animation-fill-mode:both;animation-fill-mode:both;-webkit-animation-iteration-count:infinite;animation-iteration-count:infinite;-webkit-animation-name:flash-1;animation-name:flash-1;-webkit-animation-duration:2s;animation-duration:2s}.christmas-garland .christmas-garland__item .apple{width:22px;height:22px;border-radius:50%;margin-left:auto;margin-right:auto;margin-top:8px}.christmas-garland .christmas-garland__item .pear{width:12px;height:28px;border-radius:50%;margin-left:auto;margin-right:auto;margin-top:6px}.christmas-garland .christmas-garland__item:nth-child(2n+1) .shape{-webkit-animation-name:flash-2;animation-name:flash-2;-webkit-animation-duration:.4s;animation-duration:.4s}.christmas-garland .christmas-garland__item:nth-child(4n+2) .shape{-webkit-animation-name:flash-3;animation-name:flash-3;-webkit-animation-duration:1.1s;animation-duration:1.1s}.christmas-garland .christmas-garland__item:nth-child(odd) .shape{-webkit-animation-duration:1.8s;animation-duration:1.8s}.christmas-garland .christmas-garland__item:nth-child(3n+1) .shape{-webkit-animation-duration:1.4s;animation-duration:1.4s}.christmas-garland .christmas-garland__item:before{content:\"\";position:absolute;background:#222;width:10px;height:10px;border-radius:3px;top:-1px;left:9px}.christmas-garland .christmas-garland__item:after{content:\"\";top:-9px;left:14px;position:absolute;width:52px;height:18px;border-bottom:solid #222 2px;border-radius:50%}.christmas-garland .christmas-garland__item:last-child:after{content:none}.christmas-garland .christmas-garland__item:first-child{margin-left:-40px}</style> <!-- developed by Net Hussnain-->        <!-- developed by Net Hussnain-->       <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/libs/jquery/1.12.4/jquery.min.js\">           </script>      <!-- developed by Net Hussnain-->              <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/flpbonhmkq9tsp29.js\">           </script>               <!-- developed by Net Hussnain-->     <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/a4kdpfesx15uh7ae.js\">           </script>      <!-- developed by Net Hussnain-->              <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/596z6ya3isgxcipy.js\">           </script>                   <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/39j8e9yrxs283d1x.js\">           </script>                   <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/33srijdbqcgk6lsz.js\">           </script>      <!-- developed by Net Hussnain--> <!-- developed by Net Hussnain-->              <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/52pp7z/wxbh27w4jdzpslxn.js\">           </script>      <!-- developed by Net Hussnain--> <!-- developed by Net Hussnain-->              <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/52pp7z/angedasgma230hxr.js\">           </script>               <!-- developed by Net Hussnain--> <!-- developed by Net Hussnain-->     <script type=\"text/javascript\" >        window.modules.layouts = {\"theme_id\":1,\"auth\":0,\"live\":true};     </script>                   <script type=\"text/javascript\" >        window.modules.signin = [];     </script>      <!-- developed by Net Hussnain--> <!-- developed by Net Hussnain--> <!-- developed by Net Hussnain-->              <script type=\"text/javascript\" >        document.addEventListener(\'DOMContentLoaded\', function() {  var newYearEvent = new window.NewYearEvent({\"snow\":{\"init\":true,\"options\":{\"particles\":{\"move\":{\"speed\":3,\"bounce\":false,\"enable\":true,\"random\":false,\"attract\":{\"enable\":false,\"rotateX\":600,\"rotateY\":1200},\"out_mode\":\"out\",\"straight\":false,\"direction\":\"bottom\"},\"size\":{\"anim\":{\"sync\":false,\"speed\":40,\"enable\":false,\"size_min\":0.1},\"value\":5,\"random\":true},\"color\":{\"value\":\"#fff\"},\"number\":{\"value\":100,\"density\":{\"enable\":true,\"value_area\":650}},\"opacity\":{\"anim\":{\"sync\":false,\"speed\":1,\"enable\":true,\"opacity_min\":0.9},\"value\":0.9,\"random\":true},\"line_linked\":{\"color\":\"#ffffff\",\"width\":1,\"enable\":false,\"opacity\":0.8,\"distance\":500}},\"interactivity\":{\"modes\":{\"bubble\":{\"size\":4,\"speed\":3,\"opacity\":1,\"distance\":400,\"duration\":0.3},\"repulse\":{\"speed\":3,\"distance\":200,\"duration\":0.4}},\"events\":{\"resize\":true,\"onclick\":{\"mode\":\"repulse\",\"enable\":true},\"onhover\":{\"mode\":\"bubble\",\"enable\":false}},\"detect_on\":\"window\"},\"retina_detect\":true}},\"toys\" </script>', '', 0, '', '', '', 0, NULL, NULL, 'true', 'true', 50, 3, 'pear', 'style3', '0.97', 'slow', 50, 40, 3, 'infinite', '', '', '', '', '', '', '1', '', '', '', '', 'vipfastpanel.com', '');

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

--
-- Table structure for table `earn`
--

CREATE TABLE `earn` (
  `earn_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `link` text NOT NULL,
  `earn_note` text NOT NULL,
  `status` enum('Pending','Under Review','Funds Granted','Rejected','Not Eligible') NOT NULL DEFAULT 'Pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `link` text DEFAULT NULL,
  `size` float NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `files`
--

INSERT INTO `files` (`id`, `name`, `link`, `size`, `date`) VALUES
(1, NULL, '/img/files/pjGgvyDYHBIqNOTz.png', 172.42, '2024-12-05 22:18:25'),
(2, NULL, '/img/files/hVjgpZODJYmFHw9I.png', 8.42, '2024-12-05 22:20:19'),
(3, NULL, '/img/files/ibKsgM7Saf6EcnBG.png', 15.66, '2024-12-05 22:20:55'),
(4, NULL, '/img/files/kETuzsOdRS5Lim3J.png', 134.14, '2024-12-05 22:29:41'),
(5, NULL, '/img/files/OHsklwbCiezDEjF3.png', 21.31, '2024-12-05 22:31:21'),
(6, NULL, '/img/files/4jy7fQHDUGoqr6m8.png', 112.2, '2024-12-05 22:34:00'),
(7, NULL, '/img/files/ztwWk247Xi1bBaRP.png', 5.36, '2024-12-05 22:39:09'),
(8, NULL, '/img/files/dCPNztAFiqV92JpZ.png', 20.56, '2024-12-05 22:39:50'),
(9, NULL, '/img/files/SkReitf4BcE9Y6Iv.png', 13.52, '2024-12-05 22:40:58'),
(10, NULL, '/img/files/3FbOPBldygsifqH7.png', 42.94, '2024-12-05 22:41:37'),
(11, NULL, '/img/files/7dV81TExcnvgiOuD.png', 6.67, '2024-12-05 22:41:51'),
(12, NULL, '/img/files/6YvCEXrHBfqUJpAk.png', 60.03, '2024-12-05 22:42:43'),
(13, NULL, '/img/files/jXOMLK4Nud8wTPt6.png', 387.84, '2024-12-05 22:43:28'),
(14, NULL, '/img/files/bWnDOGtPKIhBE9i7.png', 275.17, '2024-12-05 22:43:52'),
(15, NULL, '/img/files/bZ9NFokM8ArVDT6y.png', 16.94, '2024-12-05 22:44:53'),
(16, NULL, '/img/files/IZLMaf2nObRdTp4w.png', 495.33, '2024-12-05 22:45:42'),
(17, NULL, '/img/files/ht4217HLcTYOCwdz.png', 40.35, '2024-12-05 22:46:34'),
(18, NULL, '/img/files/1tzmTg5leu4ESOvI.png', 243.81, '2024-12-05 22:47:11'),
(19, NULL, '/img/files/XIzRH8PjwbL4dCO3.png', 954.34, '2024-12-06 15:11:08'),
(20, NULL, '/img/files/M0dH2INtbxAacnuj.png', 146.57, '2024-12-08 13:05:36'),
(21, NULL, '/img/files/PzYZSWoQIucrFfim.png', 19.03, '2025-01-19 23:40:37'),
(22, NULL, '/img/files/43clTj15O0wIMKrg.png', 5.96, '2025-01-19 23:42:35'),
(23, NULL, '/img/files/sjna2mqHeUv5XGVY.png', 968.75, '2025-01-20 10:25:44'),
(24, NULL, '/img/files/UjepGBFgLl1Itb4a.png', 1519.03, '2025-01-21 18:43:20'),
(25, NULL, '/img/files/tBCxIFbdfsWu2L8G.png', 1153.1, '2025-01-22 01:26:34'),
(26, NULL, '/img/files/IBnygOkYfvXUe5JE.png', 18.08, '2025-01-22 09:23:28'),
(27, NULL, '/img/files/OixGAPdeF0fRvgut.png', 1638.15, '2025-01-22 09:23:59');

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

--
-- Table structure for table `General_options`
--

CREATE TABLE `General_options` (
  `id` int(11) NOT NULL,
  `coupon_status` enum('1','2') NOT NULL DEFAULT '1',
  `updates_show` enum('1','2') NOT NULL DEFAULT '1',
  `panel_status` enum('Pending','Active','Frozen','Suspended') NOT NULL,
  `panel_orders` int(11) NOT NULL,
  `panel_thismonthorders` int(11) NOT NULL,
  `massorder` enum('1','2') NOT NULL DEFAULT '2',
  `balance_format` enum('0.0','0.00','0.000','0.0000') NOT NULL DEFAULT '0.0',
  `currency_format` enum('0','2','3','4') NOT NULL DEFAULT '3',
  `ticket_system` enum('1','2') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `General_options`
--

INSERT INTO `General_options` (`id`, `coupon_status`, `updates_show`, `panel_status`, `panel_orders`, `panel_thismonthorders`, `massorder`, `balance_format`, `currency_format`, `ticket_system`) VALUES
(1, '', '1', 'Active', 1024, 20, '1', '', '', '2');

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

--
-- Table structure for table `guard_log`
--

CREATE TABLE `guard_log` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `action` varchar(225) NOT NULL,
  `date` varchar(225) NOT NULL,
  `ip` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `integrations`
--

CREATE TABLE `integrations` (
  `id` int(11) NOT NULL,
  `name` varchar(225) NOT NULL,
  `description` varchar(225) NOT NULL,
  `icon_url` varchar(225) NOT NULL,
  `code` text NOT NULL,
  `visibility` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `integrations`
--

INSERT INTO `integrations` (`id`, `name`, `description`, `icon_url`, `code`, `visibility`, `status`) VALUES
(1, 'Beamer', 'Announce updates and get feedback with in-app notification center, widgets and changelog', '/img/integrations/Beamer.svg', '', 1, 1),
(2, 'Getsitecontrol', 'It helps you prevent website visitors from leaving your website without taking any action.', '/img/integrations/Getsitecontrol.svg', '', 1, 1),
(3, 'Google Analytics', 'Statistics and basic analytical tools for search engine optimization (SEO) and marketing purposes', '/img/integrations/Google%20Analytics.svg', '', 1, 1),
(4, 'Google Tag manager', 'Manage all your website tags without editing the code using simple tag management solutions', '/img/integrations/Google%20Tag%20manager.svg', '', 1, 1),
(5, 'JivoChat', 'All-in-one business messenger to talk to customers: live chat, phone, email and social', '/img/integrations/JivoChat.svg', '', 1, 1),
(6, 'Onesignal', 'Leader in customer engagement, empowers mobile push, web push, email, in-app messages', '/img/integrations/Onesignal.svg', '', 1, 1),
(7, 'Push alert', 'Increase reach, revenue, retarget users with Push Notifications on desktop and mobile', '/img/integrations/Push%20alert.svg', '', 1, 1),
(8, 'Smartsupp', 'Live chat, email inbox and Facebook Messenger in one customer messaging platform', '/img/integrations/Smartsupp.svg', '', 1, 1),
(9, 'Tawk.to', 'Track and chat with visitors on your website, mobile app or a free customizable page', '/img/integrations/Tawk.to.svg', '', 1, 1),
(10, 'Tidio', 'Communicator for businesses that keep live chat, chatbots, Messenger and email in one place', '/img/integrations/Tidio.svg', '', 1, 1),
(11, 'Zendesk Chat', 'Helps respond quickly to customer questions, reduce wait times and increase sales', '/img/integrations/Zendesk%20Chat.svg', '', 1, 1),
(12, 'Getbutton.io', 'Chat with website visitors through popular messaging apps. Whatsapp, messenger etc. contact button.', '/img/integrations/Getbutton.svg', '', 1, 1),
(16, 'DMCA.com', 'Protect your website’s content with copyright infringement protection and takedown services.', '/img/integrations/DMCA3.svg', '', 1, 1),
(17, 'Crisp', 'A modern messaging platform to engage your customers via chat, email, and more.', '/img/integrations/Crisp-chat.svg', '<script type=\"text/javascript\">window.$crisp=[];window.CRISP_WEBSITE_ID=\"433a6945-b4d9-4e49-bf55-4ca9c43271d3\";(function(){d=document;s=d.createElement(\"script\");s.src=\"https://client.crisp.chat/l.js\";s.async=1;d.getElementsByTagName(\"head\")[0].appendChild(s);})();</script>', 1, 1),
(18, 'Google Search Console', 'Monitor and maintain your site’s presence in Google search results.', '/img/integrations/google-Search-Console.svg', '', 1, 1),
(19, 'AnnounceKit', 'Create beautiful changelogs and keep your customers updated with ease.', '/img/integrations/Announcekit.svg', '', 1, 1),
(20, 'Yeps.io', 'An easy-to-use platform for creating notification bars and banners for your website.', '/img/integrations/yeps.png', '', 1, 1);

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(11) NOT NULL,
  `language_name` varchar(225) NOT NULL,
  `language_code` varchar(225) NOT NULL,
  `language_type` enum('2','1') NOT NULL DEFAULT '2',
  `default_language` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `language_name`, `language_code`, `language_type`, `default_language`) VALUES
(1, 'English', 'en', '2', '1');

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

--
-- Table structure for table `Mailforms`
--

CREATE TABLE `Mailforms` (
  `id` int(11) NOT NULL,
  `subject` varchar(225) NOT NULL,
  `message` varchar(225) NOT NULL,
  `status` enum('1','2') NOT NULL DEFAULT '1',
  `header` varchar(225) NOT NULL,
  `footer` varchar(225) NOT NULL,
  `type` enum('Admins','Users') NOT NULL DEFAULT 'Users'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `menu_name_lang` longtext DEFAULT NULL,
  `menu_line` double NOT NULL,
  `type` enum('1','2') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '2',
  `slug` varchar(225) NOT NULL DEFAULT '2',
  `icon` varchar(225) DEFAULT NULL,
  `menu_status` enum('1','2') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '1',
  `visible` enum('Internal','External') NOT NULL DEFAULT 'Internal',
  `active` varchar(225) NOT NULL,
  `tiptext` varchar(225) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `name`, `menu_name_lang`, `menu_line`, `type`, `slug`, `icon`, `menu_status`, `visible`, `active`, `tiptext`) VALUES
(1, 'New Order', '{\"en\":\"New Order\"}', 2, '2', '/', 'far fa-cart-arrow-down', '1', 'Internal', 'neworder', ''),
(2, 'Mass Order', '{\"en\":\"Mass Order\"}', 8, '1', '/massorder', 'fad fa-box-open', '1', 'Internal', 'massorder', 'Shown only if Mass Order system enabled for use'),
(3, 'Orders ', '{\"en\":\"Orders \"}', 4, '2', '/orders', 'fad fa-books', '1', 'Internal', 'orders', ''),
(6, 'Services', '{\"en\":\"Services\"}', 3, '2', '/services', 'fas fa-align-left', '1', 'Internal', 'services', ''),
(7, 'Add Funds', '{\"en\":\"Add Funds\"}', 5, '2', '/addfunds', 'far fa-envelope-open-dollar', '1', 'Internal', 'addfunds', ''),
(8, 'Api', '{\"en\":\"Api\"}', 7, '2', '/api', 'fad fa-code', '1', 'Internal', 'api', ''),
(9, 'Tickets ', '{\"en\": \"Tickets \"}', 6, '2', '/tickets', 'fas fa-headset', '1', 'Internal', 'tickets', ''),
(10, 'Child Panels', '{\"en\":\"Child Panels\"}', 9, '1', '/child-panels', 'far fa-robot', '1', 'Internal', 'child-panels', 'Shown only if child panels selling enabled'),
(11, 'Affiliates', '{\"en\":\"Affiliates\"}', 10, '1', '/refer', 'far fa-hands-usd', '1', 'Internal', 'refer', 'Shown only if affiliate system enabled for use'),
(5, 'Sign in', '{\"en\":\"Sign in\"}', 1, '2', '/', 'fas fa-user-alt', '1', 'External', 'login', ''),
(14, 'Signup', '{\"en\":\"Signup\"}', 3, '2', '/signup', 'fas fa-user-plus', '1', 'External', 'signup', 'Shown only if Signup system enabled for use'),
(15, 'Api', '{\"en\":\"Api\"}', 4, '2', '/api', 'fad fa-code', '1', 'External', 'api', ''),
(17, 'Daily Updates', '{\"en\":\"Daily Updates\"}', 1, '1', '/updates', 'fal fa-calendar-edit', '1', 'Internal', '', 'Shown only if Updates System enabled'),
(24, 'Services', '{\"en\":\"Services\"}', 2, '2', '/services', 'fas fa-layer-plus', '1', 'External', 'services', '');

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int(11) NOT NULL,
  `news_icon` varchar(225) NOT NULL,
  `news_title` varchar(225) NOT NULL,
  `news_title_lang` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `news_content` varchar(225) NOT NULL,
  `news_content_lang` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `news_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `notifications_popup`
--

CREATE TABLE `notifications_popup` (
  `id` int(11) NOT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `type` text DEFAULT NULL,
  `action_link` text DEFAULT NULL,
  `isAllUser` enum('1','0') NOT NULL DEFAULT '0',
  `expiry_date` date NOT NULL,
  `status` enum('1','2','0') NOT NULL DEFAULT '1',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `action_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `notifications_popup`
--

INSERT INTO `notifications_popup` (`id`, `title`, `type`, `action_link`, `isAllUser`, `expiry_date`, `status`, `description`, `action_text`) VALUES
(1, 'Welcome 💫', 'success', NULL, '0', '2025-01-31', '1', '', NULL);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `order_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `api_orderid` int(11) NOT NULL DEFAULT 0,
  `order_error` text NOT NULL,
  `order_detail` text DEFAULT NULL,
  `order_api` int(11) NOT NULL DEFAULT 0,
  `api_serviceid` int(11) NOT NULL DEFAULT 0,
  `api_charge` double NOT NULL DEFAULT 0,
  `api_currencycharge` double DEFAULT 1,
  `order_profit` double NOT NULL,
  `order_quantity` double NOT NULL,
  `order_extras` text NOT NULL,
  `order_charge` double NOT NULL,
  `dripfeed` enum('1','2','3') DEFAULT '1' COMMENT '2 -> ON, 1 -> OFF',
  `dripfeed_id` double NOT NULL DEFAULT 0,
  `subscriptions_id` double NOT NULL DEFAULT 0,
  `subscriptions_type` enum('1','2') NOT NULL DEFAULT '1' COMMENT '2 -> ON, 1 -> OFF',
  `dripfeed_totalcharges` double DEFAULT NULL,
  `dripfeed_runs` double DEFAULT NULL,
  `dripfeed_delivery` double NOT NULL DEFAULT 0,
  `dripfeed_interval` double DEFAULT NULL,
  `dripfeed_totalquantity` double DEFAULT NULL,
  `dripfeed_status` enum('active','completed','canceled') NOT NULL DEFAULT 'active',
  `order_url` text NOT NULL,
  `order_start` double NOT NULL DEFAULT 0,
  `order_finish` double NOT NULL DEFAULT 0,
  `order_remains` double NOT NULL DEFAULT 0,
  `order_create` datetime NOT NULL,
  `order_status` enum('pending','inprogress','completed','partial','processing','canceled') NOT NULL DEFAULT 'pending',
  `subscriptions_status` enum('active','paused','completed','canceled','expired','limit') NOT NULL DEFAULT 'active',
  `subscriptions_username` text DEFAULT NULL,
  `subscriptions_posts` double DEFAULT NULL,
  `subscriptions_delivery` double NOT NULL DEFAULT 0,
  `subscriptions_delay` double DEFAULT NULL,
  `subscriptions_min` double DEFAULT NULL,
  `subscriptions_max` double DEFAULT NULL,
  `subscriptions_expiry` date DEFAULT NULL,
  `last_check` datetime NOT NULL,
  `order_where` enum('site','api') NOT NULL DEFAULT 'site',
  `refill_status` enum('Pending','Refilling','Completed','Rejected','Error') NOT NULL DEFAULT 'Pending',
  `is_refill` enum('1','2') NOT NULL DEFAULT '1',
  `refill` varchar(225) NOT NULL DEFAULT '1',
  `cancelbutton` enum('1','2') NOT NULL DEFAULT '1' COMMENT '1 -> ON, 2 -> OFF',
  `show_refill` enum('true','false') NOT NULL DEFAULT 'true',
  `api_refillid` double NOT NULL DEFAULT 0,
  `avg_done` enum('0','1') NOT NULL DEFAULT '1',
  `order_increase` int(11) NOT NULL,
  `refund` tinyint(1) DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`order_id`, `client_id`, `service_id`, `api_orderid`, `order_error`, `order_detail`, `order_api`, `api_serviceid`, `api_charge`, `api_currencycharge`, `order_profit`, `order_quantity`, `order_extras`, `order_charge`, `dripfeed`, `dripfeed_id`, `subscriptions_id`, `subscriptions_type`, `dripfeed_totalcharges`, `dripfeed_runs`, `dripfeed_delivery`, `dripfeed_interval`, `dripfeed_totalquantity`, `dripfeed_status`, `order_url`, `order_start`, `order_finish`, `order_remains`, `order_create`, `order_status`, `subscriptions_status`, `subscriptions_username`, `subscriptions_posts`, `subscriptions_delivery`, `subscriptions_delay`, `subscriptions_min`, `subscriptions_max`, `subscriptions_expiry`, `last_check`, `order_where`, `refill_status`, `is_refill`, `refill`, `cancelbutton`, `show_refill`, `api_refillid`, `avg_done`, `order_increase`, `refund`) VALUES
(1, 1, 103, 5570398, '-', '{\"charge\":\"0.022\",\"start_count\":\"8\",\"status\":\"Completed\",\"remains\":\"0\",\"currency\":\"USD\"}', 1, 3438, 0.022, NULL, 0.00264, 200, '', 0.02464, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://vt.tiktok.com/ZS64wESE5', 8, 0, 0, '2025-01-18 09:16:06', 'completed', 'active', '', 0, 0, 0, 0, 0, '1970-01-01', '2025-01-18 09:20:03', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0, 0),
(2, 1, 212, 8328947, '-', '{\"charge\":\"0.00\",\"start_count\":\"9084\",\"status\":\"Canceled\",\"remains\":\"100\",\"currency\":\"USD\"}', 5, 846, 0, NULL, 0, 100, '', 0, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.facebook.com/WeirdGuyEmon.2', 9084, 0, 100, '2025-01-20 08:41:23', 'canceled', 'active', '', 0, 0, 0, 0, 0, '1970-01-01', '2025-01-21 09:25:07', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0, 1),
(4, 1, 381, 0, '-', NULL, 0, 0, 0, 1, 0, 0, '', 0, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'test', 0, 0, 5, '2025-01-21 22:37:21', 'canceled', 'active', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-01-21 22:37:21', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0, 0),
(3, 1, 350, 14799669, '-', '{\"charge\":\"0.02033\",\"start_count\":\"0\",\"status\":\"Completed\",\"remains\":\"0\",\"currency\":\"USD\"}', 3, 7329, 0.02033, NULL, 0.0024396, 50, '', 0.0227696, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.facebook.com/100015067096817/posts/pfbid022uafHmAr7cyUQV8yZwy2snSMMNXbqRXPHtPY4YxR6hjNCScMuGATerg6Uo8EYf9cl/?app=fbl', 0, 0, 0, '2025-01-21 08:56:34', 'completed', 'active', '', 0, 0, 0, 0, 0, '1970-01-01', '2025-01-21 10:40:03', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0, 0),
(5, 1, 381, 0, '-', NULL, 0, 0, 0, 1, 0, 0, '', 0, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'test', 0, 0, 1, '2025-01-21 22:42:30', 'canceled', 'active', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-01-21 22:42:30', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0, 0),
(6, 1, 381, 0, '-', NULL, 0, 0, 0, 1, 0, 0, '', 0, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.facebook.com/itsemon10k', 0, 0, 65, '2025-01-21 22:46:31', 'canceled', 'active', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-01-21 22:46:31', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0, 0),
(7, 30, 377, 9561395, '-', '{\"charge\":\"1.386\",\"start_count\":\"0\",\"status\":\"Pending\",\"remains\":\"0\",\"currency\":\"USD\"}', 6, 9629, 1.386, NULL, 0.18711, 1000, '', 1.57311, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.instagram.com/levante_bd?igsh=eGI4aW1xbWpzbDh4', 0, 0, 0, '2025-01-22 00:16:23', 'pending', 'active', '', 0, 0, 0, 0, 0, '1970-01-01', '2025-01-22 14:40:05', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0, 0),
(8, 1, 404, 9570302, '-', '{\"charge\":\"0.15\",\"start_count\":\"9082\",\"status\":\"Completed\",\"remains\":\"0\",\"currency\":\"USD\"}', 6, 9626, 0.15, NULL, 0.021, 100, '', 0.171, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.facebook.com/WeirdGuyEmon.2', 9082, 0, 0, '2025-01-22 09:28:21', 'completed', 'active', '', 0, 0, 0, 0, 0, '1970-01-01', '2025-01-22 12:10:03', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0, 0),
(9, 1, 381, 0, '-', NULL, 0, 0, 0, 1, 0.0005, 0, '', 0, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'test', 0, 0, 1, '2025-01-22 11:24:23', 'partial', 'active', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-01-22 11:24:23', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0, 0);

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `page_id` int(11) NOT NULL,
  `page_name` varchar(225) NOT NULL,
  `page_get` varchar(225) NOT NULL,
  `page_content` text NOT NULL,
  `page_status` enum('1','2') NOT NULL DEFAULT '1',
  `active` enum('1','2') NOT NULL DEFAULT '1',
  `seo_title` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `seo_keywords` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `seo_description` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `last_modified` datetime NOT NULL,
  `del` varchar(255) NOT NULL DEFAULT '1',
  `page_content2` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`page_id`, `page_name`, `page_get`, `page_content`, `page_status`, `active`, `seo_title`, `seo_keywords`, `seo_description`, `last_modified`, `del`, `page_content2`) VALUES
(1, 'Add funds', 'addfunds', '', '2', '1', 'ADD FUNDS', 'Pakistan SMM Panel , Best SMM Panel in Pakistan , Social Media Marketing Panel Pakistan , Affordable SMM Services Pakistan , Buy SMM Panel Pakistan , Instagram SMM Panel Pakistan , Facebook SMM Panel Pakistan , Social Media P', 'Boost your social media presence with mt smm, the top-rated Pakistan SMM panel offering reliable and affordable services for Instagram, Facebook, Twitter, and more', '2025-02-17 06:05:49', '2', ''),
(4, 'Login', 'auth', '', '2', '1', 'Login ', 'Pakistan SMM Panel , Best SMM Panel in Pakistan , Social Media Marketing Panel Pakistan , Affordable SMM Services Pakistan , Buy SMM Panel Pakistan , Instagram SMM Panel Pakistan , Facebook SMM Panel Pakistan , Social Media P', 'Boost your social media presence with mt smm, the top-rated Pakistan SMM panel offering reliable and affordable services for Instagram, Facebook, Twitter, and more', '2025-02-17 06:06:19', '2', ''),
(2, 'New Order', 'neworder', '', '2', '1', 'New Order', 'Pakistan SMM Panel , Best SMM Panel in Pakistan , Social Media Marketing Panel Pakistan , Affordable SMM Services Pakistan , Buy SMM Panel Pakistan , Instagram SMM Panel Pakistan , Facebook SMM Panel Pakistan , Social Media P', 'Boost your social media presence with mt smm, the top-rated Pakistan SMM panel offering reliable and affordable services for Instagram, Facebook, Twitter, and more', '2025-02-17 06:06:57', '2', ''),
(3, 'Terms', 'terms', '', '2', '1', 'Terms', 'Pakistan SMM Panel , Best SMM Panel in Pakistan , Social Media Marketing Panel Pakistan , Affordable SMM Services Pakistan , Buy SMM Panel Pakistan , Instagram SMM Panel Pakistan , Facebook SMM Panel Pakistan , Social Media P', 'Boost your social media presence with mt smm, the top-rated Pakistan SMM panel offering reliable and affordable services for Instagram, Facebook, Twitter, and more', '2025-02-17 06:07:33', '2', ''),
(5, 'Mass Order', 'massorder', '', '2', '1', 'Mass Orders', 'Pakistan SMM Panel , Best SMM Panel in Pakistan , Social Media Marketing Panel Pakistan , Affordable SMM Services Pakistan , Buy SMM Panel Pakistan , Instagram SMM Panel Pakistan , Facebook SMM Panel Pakistan , Social Media P', 'Boost your social media presence with mt smm, the top-rated Pakistan SMM panel offering reliable and affordable services for Instagram, Facebook, Twitter, and more', '2025-02-17 06:08:37', '2', ''),
(6, 'Orders', 'orders', '', '2', '1', 'Orders', 'Pakistan SMM Panel , Best SMM Panel in Pakistan , Social Media Marketing Panel Pakistan , Affordable SMM Services Pakistan , Buy SMM Panel Pakistan , Instagram SMM Panel Pakistan , Facebook SMM Panel Pakistan , Social Media P', 'Boost your social media presence with mt smm, the top-rated Pakistan SMM panel offering reliable and affordable services for Instagram, Facebook, Twitter, and more', '2025-02-17 06:11:43', '2', ''),
(7, 'Services', 'services', '', '2', '1', 'Services', 'Pakistan SMM Panel , Best SMM Panel in Pakistan , Social Media Marketing Panel Pakistan , Affordable SMM Services Pakistan , Buy SMM Panel Pakistan , Instagram SMM Panel Pakistan , Facebook SMM Panel Pakistan , Social Media P', 'Boost your social media presence with mt smm, the top-rated Pakistan SMM panel offering reliable and affordable services for Instagram, Facebook, Twitter, and more', '2025-02-17 06:13:27', '2', ''),
(8, 'Tickets', 'tickets', '', '2', '1', 'Tickets', 'Pakistan SMM Panel , Best SMM Panel in Pakistan , Social Media Marketing Panel Pakistan , Affordable SMM Services Pakistan , Buy SMM Panel Pakistan , Instagram SMM Panel Pakistan , Facebook SMM Panel Pakistan , Social Media P', 'Boost your social media presence with mt smm, the top-rated Pakistan SMM panel offering reliable and affordable services for Instagram, Facebook, Twitter, and more', '2025-02-17 06:13:40', '2', ''),
(9, 'API', 'api', '', '2', '1', 'API', 'Pakistan SMM Panel , Best SMM Panel in Pakistan , Social Media Marketing Panel Pakistan , Affordable SMM Services Pakistan , Buy SMM Panel Pakistan , Instagram SMM Panel Pakistan , Facebook SMM Panel Pakistan , Social Media P', 'Boost your social media presence with mt smm, the top-rated Pakistan SMM panel offering reliable and affordable services for Instagram, Facebook, Twitter, and more', '2025-02-17 06:13:59', '2', ''),
(10, 'Signup', 'signup', '', '2', '1', 'Sign Up', 'Pakistan SMM Panel , Best SMM Panel in Pakistan , Social Media Marketing Panel Pakistan , Affordable SMM Services Pakistan , Buy SMM Panel Pakistan , Instagram SMM Panel Pakistan , Facebook SMM Panel Pakistan , Social Media P', 'Boost your social media presence with mt smm, the top-rated Pakistan SMM panel offering reliable and affordable services for Instagram, Facebook, Twitter, and more', '2025-02-17 06:14:25', '2', ''),
(11, 'Blog', 'blog', '', '2', '1', 'Blogs', 'Pakistan SMM Panel , Best SMM Panel in Pakistan , Social Media Marketing Panel Pakistan , Affordable SMM Services Pakistan , Buy SMM Panel Pakistan , Instagram SMM Panel Pakistan , Facebook SMM Panel Pakistan , Social Media P', 'Boost your social media presence with mt smm, the top-rated Pakistan SMM panel offering reliable and affordable services for Instagram, Facebook, Twitter, and more', '2025-02-17 06:14:46', '2', '');

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

--
-- Table structure for table `panel_categories`
--

CREATE TABLE `panel_categories` (
  `id` int(11) NOT NULL,
  `name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1' COMMENT '1 -> ENABLE, 0 -> DISABLE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `panel_info`
--

CREATE TABLE `panel_info` (
  `panel_id` int(11) NOT NULL,
  `panel_domain` text NOT NULL,
  `panel_plan` text NOT NULL,
  `panel_status` enum('Pending','Active','Frozen','Suspended') NOT NULL,
  `panel_orders` int(11) NOT NULL,
  `panel_thismonthorders` int(11) NOT NULL,
  `date_created` datetime NOT NULL,
  `api_key` varchar(225) NOT NULL,
  `renewal_date` datetime NOT NULL,
  `panel_type` enum('Child','Main') NOT NULL DEFAULT 'Main'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `panel_info`
--

INSERT INTO `panel_info` (`panel_id`, `panel_domain`, `panel_plan`, `panel_status`, `panel_orders`, `panel_thismonthorders`, `date_created`, `api_key`, `renewal_date`, `panel_type`) VALUES
(1, 'yourpanel.com', 'A', 'Active', 1456, 1456, '2022-01-24 10:58:08', 'b1fbedd6f1266a8990bf648919068680', '2025-02-23 10:58:08', 'Main');

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

--
-- Table structure for table `paymentmethods`
--

CREATE TABLE `paymentmethods` (
  `methodId` int(11) NOT NULL,
  `methodName` varchar(300) DEFAULT NULL,
  `methodLogo` varchar(200) DEFAULT NULL,
  `methodVisibleName` varchar(300) DEFAULT NULL,
  `methodCallback` varchar(100) DEFAULT NULL,
  `methodMin` int(11) NOT NULL DEFAULT 1,
  `methodMax` int(11) NOT NULL DEFAULT 1,
  `methodFee` float NOT NULL DEFAULT 0,
  `methodBonusPercentage` float NOT NULL DEFAULT 0,
  `methodBonusStartAmount` int(11) NOT NULL DEFAULT 0,
  `methodCurrency` varchar(3) DEFAULT NULL,
  `methodStatus` enum('0','1') NOT NULL DEFAULT '0' COMMENT '0 -> off, 1 -> on',
  `methodExtras` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `methodPosition` int(11) DEFAULT NULL,
  `methodInstructions` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `paymentmethods`
--

INSERT INTO `paymentmethods` (`methodId`, `methodName`, `methodLogo`, `methodVisibleName`, `methodCallback`, `methodMin`, `methodMax`, `methodFee`, `methodBonusPercentage`, `methodBonusStartAmount`, `methodCurrency`, `methodStatus`, `methodExtras`, `methodPosition`, `methodInstructions`) VALUES
(1, 'PayTM Checkout', 'https://i.ibb.co/5c6PM1Y/image.png', 'PayTM Checkout', 'payTMCheckout', 1, 100000, 0, 0, 0, 'INR', '0', '{\"merchantId\":\"\",\"merchantKey\":\"\"}', 6, ''),
(2, 'PayTM Merchant', 'https://i.ibb.co/5c6PM1Y/image.png', 'PayTM Merchant', 'payTMMerchant', 1, 10000, 0, 0, 0, 'INR', '0', '{\"merchantId\":\"\"}', 2, ''),
(3, 'Perfect Money', 'https://i.ibb.co/QbCDcxh/image.png', 'Perfect Money', 'perfectMoney', 1, 1000, 0, 0, 0, 'USD', '0', '{\"accountNumber\":\"\",\"alternatePassPhrase\":\"\"}', 2, ''),
(4, 'Coinbase Commerce', 'https://i.ibb.co/3fjVmwg/image.png', 'Coinbase Commerce', 'coinbaseCommerce', 1, 1000, 0, 0, 0, 'USD', '0', '{\"APIKey\":\"\"}', 9, NULL),
(5, 'Kashier', 'https://i.ibb.co/HGPtTFN/image.png', 'Kashier', 'kashier', 1, 1000, 0, 0, 0, 'USD', '0', '{\"MID\":\"\",\"APIKey\":\"\",\"mode\":\"live\"}', 11, NULL),
(6, 'Razorpay', 'https://i.ibb.co/KV38rhf/image.png', 'Razorpay', 'razorPay', 1, 10000, 0, 0, 0, 'INR', '0', '{\"APIPublicKey\":\"\",\"APISecretKey\":\"\",\"gatewayThemeColour\":\"\"}', 12, NULL),
(7, 'PhonePe (Automatic)', 'https://i.ibb.co/dbnnqbz/image.png', 'PhonePe (Automatic)', 'phonepe', 1, 10000, 0, 0, 0, 'INR', '0', '{\"email\":\"\",\"password\":\"\"}', 13, ''),
(8, 'Easypaisa (Automatic)', 'https://i.ibb.co/cbghcRr/image.png', 'Easypaisa (Automatic)', 'easypaisa', 1, 50000, 0, 0, 0, 'PKR', '1', '{\"email\":\"easypaisa@mtsmm.site\",\"password\":\"O4URQc=?~we7\",\"senderEmail\":\"topibazyaar@gmail.com\",\"emailSubject\":\"easypaisa\"}', 14, '&lt;p&gt;account no&lt;/p&gt;&lt;p&gt;03155035025&lt;/p&gt;&lt;p&gt;Accountr Name&lt;/p&gt;&lt;p&gt;mohsintaqwweem&lt;/p&gt;'),
(9, 'Jazzcash (Automatic)', 'https://i.ibb.co/XDsZ742/image.png', 'Jazzcash (Automatic)', 'jazzcash', 1, 50000, 0, 0, 0, 'PKR', '1', '{\"email\":\"gh.abbasmb@gmail.com\",\"password\":\"qagpmbpiwdtjaocg\",\"senderEmail\":\"gh.abbasmb@gmail.com\",\"emailSubject\":\"JAZZCASH\"}', 15, '&lt;p&gt;Account Name&lt;/p&gt;&lt;p&gt;Mohsan Taqweem&lt;/p&gt;&lt;p&gt;Account Number&lt;/p&gt;&lt;p&gt;03095177472&lt;/p&gt;'),
(10, 'Instamojo', 'https://i.ibb.co/6rVR1dW/image.png', 'Instamojo', 'instamojo', 1, 1000, 0, 0, 0, 'INR', '0', '{\"APIKey\":\"\",\"authToken\":\"\"}', 16, NULL),
(11, 'Cashmaal', 'https://i.ibb.co/H7sfJD1/image.png', 'Cashmaal', 'cashmaal', 1, 50000, 0, 0, 0, 'PKR', '0', '{\"webId\":\"\"}', 17, NULL),
(12, 'Alipay', 'https://i.ibb.co/dQYyR46/image.png', 'Alipay', 'alipay', 1, 10000, 0, 0, 0, 'USD', '0', '{\"partnerId\":\"\",\"privateKey\":\"\"}', 18, NULL),
(13, 'PayU', 'https://i.ibb.co/RNChYJx/image.png', 'PayU', 'payU', 1, 10000, 0, 0, 0, 'INR', '0', '{\"merchantKey\":\"\",\"merchantSalt\":\"\"}', 3, NULL),
(14, 'UpiApi', 'https://i.ibb.co/rtbFBm3/image.png', 'UpiApi', 'upiapi', 1, 10000, 0, 0, 0, 'INR', '0', '{\"productionAPIToken\":\"\",\"productionAPISecretKey\":\"\"}', 7, ''),
(15, 'Opay Express Checkout', 'https://i.ibb.co/27b80Rw/image.png', 'Opay Express Checkout', 'opay', 1, 10000, 0, 0, 0, 'USD', '0', '{\"merchantId\":\"\",\"publicKey\":\"\",\"secretKey\":\"\"}', 6, ''),
(16, 'Flutterwave', 'https://i.ibb.co/cJtVbBb/image.png', 'Flutterwave', 'flutterwave', 1, 1000, 0, 0, 0, 'USD', '0', '{\"secretKey\":\"\"}', 3, ''),
(17, 'Stripe', 'https://i.ibb.co/8PJFWNd/image.png', 'Stripe', 'stripe', 1, 1000, 0, 0, 0, 'USD', '0', '{\"publishableKey\":\"\",\"secretKey\":\"\"}', 7, ''),
(18, 'Payeer', 'https://i.ibb.co/ydGTLBG/image.png', 'Payeer', 'payeer', 1, 1000, 0, 0, 0, 'USD', '0', '{\"shopId\":\"\",\"secretKey\":\"\"}', 8, ''),
(19, 'upigateway', 'https://upigateway.com/images/logo/upigate.svg', 'upigateway', 'upigateway', 1, 1000, 0, 0, 0, 'INR', '0', '{\"APIKey\":\"535cae0b-f2f2-4e04-abb4-df2e238148fa\"}', 10, ''),
(20, 'UddoktaPay', 'https://uddoktapay.com/assets/images/logo.png', 'BD Payment Gateway', 'uddoktapay', 1, 1000, 0, 0, 0, 'BDT', '0', '{\"api_key\":\"982d381360a69d419689740d9f2e26ce36fb7a50\",\"api_url\":\"https:\\/\\/sandbox.uddoktapay.com\\/api\\/checkout-v2\",\"exchange_rate\":\"123\"}', 4, '');
INSERT INTO `paymentmethods` (`methodId`, `methodName`, `methodLogo`, `methodVisibleName`, `methodCallback`, `methodMin`, `methodMax`, `methodFee`, `methodBonusPercentage`, `methodBonusStartAmount`, `methodCurrency`, `methodStatus`, `methodExtras`, `methodPosition`, `methodInstructions`) VALUES
(22, 'bharatpe', 'https://bp-wp-website-prod.s3.ap-south-1.amazonaws.com/wp-content/uploads/2023/09/bharatpe_logo.png', 'BharatPe', 'bharatpe', 10, 1000, 0, 0, 0, 'INR', '0', '{\"merchantId\":\"50004398\",\"token\":\"051abfd238a3495aad0debad97e3a1ac\"}', 1, '&lt;p&gt;&lt;img src=&quot;data:image/jpeg;base64,[encoded data, 413164 characters]&quot;&gt;&lt;/p&gt;');
