-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 18, 2023 at 05:44 PM
-- Server version: 10.5.19-MariaDB-cll-lve
-- PHP Version: 8.1.16

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `bigsmmx2_smmdb`
--

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

--
-- 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` text 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
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_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`) VALUES
(1, '3', 'arfan islam', 'smmshopstore@gmail.com', 'admin', 'admin', '', '2021-09-08 10:19:05', '2023-09-19 02:34:16', '103.16.25.23', '2', '{\"admin_access\":\"1\",\"users\":\"1\",\"orders\":\"1\",\"subscriptions\":\"1\",\"dripfeed\":\"1\",\"services\":\"1\",\"payments\":\"1\",\"tickets\":\"1\",\"reports\":\"1\",\"general_settings\":\"1\",\"pages\":\"1\",\"payments_settings\":\"1\",\"bank_accounts\":\"1\",\"payments_bonus\":\"1\",\"alert_settings\":\"1\",\"providers\":\"1\",\"themes\":\"1\",\"child-panels\":\"1\",\"language\":\"1\",\"meta\":\"1\",\"twice\":\"1\",\"files\":\"1\",\"coupon\":\"1\",\"admins\":\"1\",\"update-prices\":\"1\",\"bulk\":\"1\",\"bulkc\":\"1\",\"synced-logs\":\"1\",\"refill\":\"1\",\"referral\":\"1\",\"broadcast\":\"1\",\"logs\":\"1\",\"videop\":\"1\",\"updates\":\"1\",\"menu\":\"1\",\"inte\":\"1\",\"currency\":\"1\",\"news\":\"1\",\"blog\":\"1\",\"modules\":\"1\",\"subject\":\"1\",\"super_admin\":\"1\",\"tasks\":\"1\",\"decoration\":\"1\",\"currency-manager\":\"1\"}', 'dark');

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

--
-- 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 `bank_accounts`
--

CREATE TABLE `bank_accounts` (
  `id` int(11) NOT NULL,
  `bank_name` varchar(225) NOT NULL,
  `bank_sube` varchar(225) NOT NULL,
  `bank_hesap` varchar(225) NOT NULL,
  `bank_iban` text NOT NULL,
  `bank_alici` varchar(225) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `categories` (
  `category_id` int(11) NOT NULL,
  `category_name` text NOT NULL,
  `category_line` double NOT NULL,
  `category_type` enum('1','2') CHARACTER SET utf8 COLLATE utf8_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 utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

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

CREATE TABLE `childpanels` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `domain` varchar(191) NOT NULL,
  `currency` varchar(191) NOT NULL,
  `child_username` varchar(191) NOT NULL,
  `child_password` varchar(191) NOT NULL,
  `charge` double NOT NULL,
  `status` enum('Pending','Active','Frozen','Suspended') NOT NULL DEFAULT 'Pending',
  `renewal_date` date NOT NULL,
  `date_created` datetime NOT NULL,
  `dreampanel_id` int(11) NOT NULL,
  `keyc` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `childpanels`
--

INSERT INTO `childpanels` (`id`, `client_id`, `domain`, `currency`, `child_username`, `child_password`, `charge`, `status`, `renewal_date`, `date_created`, `dreampanel_id`, `keyc`) VALUES
(1, 2, 'asdasdasd.com', 'USD', 'qweqwe123', 'qweqwe123', 1, 'Pending', '2022-05-27', '2022-04-27 19:56:50', 0, 'b1fbedd6f1266a8990bf648919068680'),
(2, 1, 'dasdasd', 'USD', 'abdosapry114', 'qweqwe123', 1, 'Pending', '2022-05-29', '2022-04-29 00:04:15', 0, 'b1fbedd6f1266a8990bf648919068680'),
(3, 1, 'asdasdasdsd', 'USD', 'abdosapry114', 'qweqwe123', 1, 'Pending', '2022-05-29', '2022-04-29 00:05:26', 0, 'b1fbedd6f1266a8990bf648919068680'),
(4, 1, 'sfsdfsdfsd', 'USD', 'erer', 'qweqwe123', 1, 'Pending', '2022-06-06', '2022-05-06 20:39:16', 0, 'b1fbedd6f1266a8990bf648919068680');

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

--
-- 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,
  `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,
  `currency` varchar(225) NOT NULL DEFAULT '1',
  `passwordreset_token` varchar(225) NOT NULL,
  `coustm_rate` int(11) NOT NULL,
  `broadcast_id` text NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `clients` (`client_id`, `name`, `email`, `username`, `admin_type`, `password`, `telephone`, `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`, `coustm_rate`, `broadcast_id`) VALUES
(223, '', 'raja23@gmail.com', 'Raja', '2', '25f9e794323b453885f5181f1b624d0b', '', 0.0000, 0.0000, '2', NULL, '2023-06-24 22:43:25', NULL, NULL, '166fe405403e15b3b238aa779b18549d', '1', '2', '2', NULL, 'en', 0, 'INR', 'e9b67f', NULL, '2', 0, '1', '', 0, '0'),
(222, '', 'brawlstarsmod07@gmail.com', 'Mukhammadazim', '2', '6ec68e7145eaea0bbcdb534f477b2eab', '', 0.0000, 0.0000, '2', NULL, '2023-06-24 14:02:07', NULL, NULL, '4eaed907f7a878478b804a2990c5eed4', '1', '2', '2', NULL, 'en', 0, 'INR', '4ef143', NULL, '2', 0, '1', '', 0, '0'),
(220, '', 'crazyswagshooter13@gmail.com', 'Swag', '2', '25d55ad283aa400af464c76d713c07ad', '', 186.1638, 23.8362, '2', NULL, '2023-06-23 00:26:13', '2023-06-23 23:18:14', '110.224.138.137', 'da04aadba8559223db05c3210588abb0', '1', '2', '2', NULL, 'en', 0, 'INR', 'e75239', NULL, '2', 0, '1', '', 0, '0'),
(218, '', 'sukuff8@gmail.com', 'suryahh15', '2', 'e3c3612814dae58848458eb11b7b7e63', '', 0.0000, 0.0000, '2', NULL, '2023-06-21 21:41:23', NULL, NULL, '03a33fb6a3abeac3e81b28fb6e9096de', '1', '2', '2', NULL, 'en', 0, 'INR', '695276', NULL, '2', 0, '1', '', 0, '0'),
(219, '', 'booksmmahed@gmail.com', 'ahedsmm', '2', '11c1aca16ffdf724c79857ce7abe2f8d', '', 0.0000, 0.0000, '2', NULL, '2023-06-22 13:43:55', NULL, NULL, '8be1c49ed11e728cca576898368d4df9', '1', '2', '2', NULL, 'en', 0, 'INR', 'b5f9f2', NULL, '2', 0, '1', '', 0, '0'),
(217, NULL, 'ranjanrohan475@gmail.com', 'Rohanranjan', '2', 'cbbd9243af1c1775b2edda031423550d', NULL, 0.0000, 0.0000, '2', 0, '2023-06-21 22:01:10', NULL, NULL, '0aaa6b986f5f34146267f04bacd73748', '2', '2', '2', 'null', 'en', 0, 'INR', '', NULL, '2', 0, '1', '', 0, '0'),
(224, '', 'polashmunshi01@gmail.com', 'arfan10', '2', '1bbd886460827015e5d605ed44252251', '', 0.0000, 0.0000, '2', NULL, '2023-09-14 17:37:34', '2023-09-18 01:37:04', '103.16.25.22', '6fedd57e5bcb5f34224cc088d3ead963', '1', '2', '2', NULL, 'en', 0, 'USD', '92a8b8', NULL, '2', 0, '1', '', 0, '0'),
(225, '', 'polashmunsh1@gmail.com', 'arfan11', '2', '1bbd886460827015e5d605ed44252251', '', 0.0000, 0.0000, '2', NULL, '2023-09-19 02:30:14', '2023-09-19 02:35:36', '103.16.25.23', '289ce625f80521ff332636cddedf11aa', '1', '2', '2', NULL, 'en', 0, 'USD', 'd28787', NULL, '2', 0, '1', '', 0, '0'),
(226, '', 'indrazit2666@gmail.com', 'mrindrw', '2', '52bfba5a112cdad32dcd0ea063b707df', '', 0.0000, 0.0000, '2', NULL, '2023-09-19 02:31:40', NULL, NULL, '76ad2002970fd59fe57c1a1dd8b0c854', '1', '2', '2', NULL, 'en', 0, 'USD', '9fca1c', NULL, '2', 0, '1', '', 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=utf8 COLLATE=utf8_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=utf8 COLLATE=utf8_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=utf8 COLLATE=utf8_general_ci;

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

--
-- 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=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `client_report` (`id`, `client_id`, `action`, `report_ip`, `report_date`) VALUES
(1370, 191, '\r\n    User registered.', '103.226.89.86', '2023-06-07 17:33:55'),
(1369, 33, 'Member logged in.', '122.177.171.68', '2023-06-07 01:43:48'),
(1368, 190, '\r\n    User registered.', '103.226.89.86', '2023-06-05 21:16:36'),
(1367, 189, 'Member logged in.', '27.62.93.108', '2023-06-05 17:51:35'),
(1366, 189, '\r\n    User registered.', '27.62.93.108', '2023-06-05 17:46:52'),
(1365, 188, '\r\n    User registered.', '106.196.21.33', '2023-06-05 17:01:15'),
(1364, 33, 'Member logged in.', '182.69.100.75', '2023-06-05 16:12:21'),
(1363, 33, 'Member logged in.', '182.69.100.75', '2023-06-05 16:00:26'),
(1362, 33, 'Member logged in.', '182.69.100.75', '2023-06-05 15:48:15'),
(1371, 190, 'Member logged in.', '103.226.89.86', '2023-06-09 02:32:56'),
(1372, 192, '\r\n    User registered.', '106.196.96.103', '2023-06-09 08:47:37'),
(1373, 193, '\r\n    User registered.', '49.43.97.171', '2023-06-09 10:02:26'),
(1374, 193, 'Member logged in.', '152.58.104.190', '2023-06-09 10:14:45'),
(1375, 194, '\r\n    User registered.', '103.173.124.221', '2023-06-09 11:41:18'),
(1376, 195, '\r\n    User registered.', '27.61.126.236', '2023-06-09 15:29:34'),
(1377, 195, 'Member logged in.', '27.61.126.236', '2023-06-09 15:30:00'),
(1378, 196, '\r\n    User registered.', '152.58.138.208', '2023-06-09 16:06:00'),
(1379, 197, '\r\n    User registered.', '91.90.218.208', '2023-06-09 17:05:09'),
(1380, 198, '\r\n    User registered.', '185.213.230.72', '2023-06-09 17:26:25'),
(1381, 199, '\r\n    User registered.', '103.16.25.20', '2023-06-09 20:10:50'),
(1382, 196, '0.144612 New Order #2002011.', '103.173.124.189', '2023-06-10 07:42:54'),
(1383, 199, 'Member logged in.', '103.16.25.20', '2023-06-10 22:48:24'),
(1384, 200, '\r\n    User registered.', '152.58.222.124', '2023-06-11 00:27:24'),
(1385, 201, '\r\n    User registered.', '157.35.8.70', '2023-06-11 00:47:17'),
(1386, 200, 'Member logged in.', '152.58.222.208', '2023-06-11 00:58:53'),
(1387, 202, '\r\n    User registered.', '103.103.35.200', '2023-06-11 20:28:35'),
(1388, 199, 'API Key changed', '103.16.25.20', '2023-06-11 21:52:02'),
(1389, 203, '\r\n    User registered.', '157.46.111.73', '2023-06-12 19:55:27'),
(1390, 200, 'Member logged in.', '104.28.159.62', '2023-06-12 22:11:42'),
(1391, 204, '\r\n    User registered.', '49.36.120.72', '2023-06-13 21:50:46'),
(1392, 205, '\r\n    User registered.', '106.206.246.99', '2023-06-13 22:51:10'),
(1393, 206, '\r\n    User registered.', '106.204.237.141', '2023-06-14 16:11:14'),
(1394, 190, 'Member logged in.', '103.226.89.86', '2023-06-14 17:18:29'),
(1395, 207, '\r\n    User registered.', '42.105.176.237', '2023-06-14 20:18:37'),
(1396, 196, '1.8337 New Order #2002012.', '42.105.176.118', '2023-06-14 20:21:27'),
(1397, 208, '\r\n    User registered.', '152.58.188.77', '2023-06-14 23:09:07'),
(1398, 209, '\r\n    User registered.', '152.58.187.14', '2023-06-15 17:33:48'),
(1399, 210, '\r\n    User registered.', '196.74.132.129', '2023-06-16 03:33:27'),
(1400, 201, 'Member logged in.', '157.35.0.67', '2023-06-16 12:55:22'),
(1401, 211, '\r\n    User registered.', '103.110.39.122', '2023-06-16 17:06:16'),
(1402, 212, '\r\n    User registered.', '111.223.30.162', '2023-06-16 19:15:12'),
(1403, 213, '\r\n    User registered.', '152.58.233.3', '2023-06-17 11:18:09'),
(1404, 201, 'Member logged in.', '157.42.2.0', '2023-06-17 18:03:46'),
(1405, 212, '3.806 New Order #2002013.', '223.189.231.115', '2023-06-17 21:30:16'),
(1406, 201, 'Member logged in.', '157.42.1.2', '2023-06-18 10:31:44'),
(1407, 214, '\r\n    User registered.', '111.223.30.252', '2023-06-18 11:22:32'),
(1408, 214, '3.806 New Order #2002014.', '111.223.30.252', '2023-06-18 11:24:20'),
(1409, 212, '3.806 New Order #2002015.', '223.189.231.106', '2023-06-18 11:56:52'),
(1410, 212, '3.806 New Order #2002888899.', '106.221.55.125', '2023-06-18 16:40:46'),
(1411, 212, '3.806 New Order #2002888900.', '106.221.55.125', '2023-06-18 16:40:47'),
(1412, 216, '\r\n    User registered.', '82.137.203.0', '2023-06-20 16:44:44'),
(1413, 216, 'New support ticket created#33', '82.137.203.0', '2023-06-20 16:45:02'),
(1414, 216, 'Support request <strong>Automatic</strong> answered as. ID:33', '82.137.203.0', '2023-06-20 16:45:02'),
(1415, 215, 'New support ticket created#34', '103.173.124.205', '2023-06-21 12:11:20'),
(1416, 216, 'New support ticket created#35', '82.137.203.0', '2023-06-21 17:00:44'),
(1417, 216, 'Support request <strong>Automatic</strong> answered as. ID:35', '82.137.203.0', '2023-06-21 17:00:44'),
(1418, 215, 'API Key changed', '103.173.124.205', '2023-06-21 17:53:23'),
(1419, 218, '\r\n    User registered.', '59.92.161.25', '2023-06-21 21:41:23'),
(1420, 219, '\r\n    User registered.', '82.137.203.0', '2023-06-22 13:43:55'),
(1421, 219, 'New support ticket created#36', '82.137.203.0', '2023-06-22 13:44:17'),
(1422, 219, 'Support request <strong>Automatic</strong> answered as. ID:36', '82.137.203.0', '2023-06-22 13:44:17'),
(1423, 219, 'Support request answered#36', '82.137.203.0', '2023-06-22 13:44:43'),
(1424, 220, '\r\n    User registered.', '157.35.45.147', '2023-06-23 00:26:13'),
(1425, 220, 'Member logged in.', '110.226.89.198', '2023-06-23 10:48:01'),
(1426, 220, 'Member logged in.', '110.224.138.137', '2023-06-23 23:18:14'),
(1427, 220, 'New ₹ 10 payment has been made with Paytm Business and Final balance\nis 10 ', '110.224.138.137', '2023-06-23 23:20:31'),
(1428, 220, '9.8989947694484 New Order #2002888906.', '110.224.138.137', '2023-06-23 23:37:21'),
(1429, 220, '0.094827040611632 New Order #2002888907.', '223.235.181.53', '2023-06-24 03:04:08'),
(1430, 221, '\r\n    User registered.', '103.173.124.198', '2023-06-24 08:55:10'),
(1431, 221, 'API Key changed', '103.173.124.198', '2023-06-24 09:03:15'),
(1432, 219, 'New support ticket created#37', '82.137.203.0', '2023-06-24 13:14:51'),
(1433, 219, 'Support request <strong>Automatic</strong> answered as. ID:37', '82.137.203.0', '2023-06-24 13:14:51'),
(1434, 222, '\r\n    User registered.', '91.90.218.208', '2023-06-24 14:02:07'),
(1435, 223, '\r\n    User registered.', '27.60.242.132', '2023-06-24 22:43:25'),
(1436, 219, 'New support ticket created#38', '82.137.203.0', '2023-06-25 16:30:32'),
(1437, 219, 'Support request <strong>Automatic</strong> answered as. ID:38', '82.137.203.0', '2023-06-25 16:30:32'),
(1438, 220, '1.7303 New Order #2002888908.', '103.173.124.234', '2023-08-27 23:34:35'),
(1439, 220, '1.7303 New Order #2002888909.', '103.173.124.234', '2023-08-27 23:34:38'),
(1440, 220, '3.4606 New Order #2002888910.', '103.173.124.234', '2023-08-27 23:34:59'),
(1441, 220, '3.4606 New Order #2002888911.', '103.173.124.234', '2023-08-27 23:35:55'),
(1442, 220, '3.4606 New Order #2002888912.', '103.173.124.234', '2023-08-27 23:36:51'),
(1443, 224, '\r\n    User registered.', '103.16.25.22', '2023-09-14 17:37:34'),
(1444, 224, 'Member logged in.', '103.16.25.22', '2023-09-14 17:42:49'),
(1445, 224, 'Member logged in.', '103.16.25.22', '2023-09-17 18:42:37'),
(1446, 224, 'Member logged in.', '103.16.25.22', '2023-09-18 01:02:04'),
(1447, 224, 'Member logged in.', '103.16.25.22', '2023-09-18 01:22:41'),
(1448, 224, 'Member logged in.', '103.16.25.22', '2023-09-18 01:37:04'),
(1449, 225, '\r\n    User registered.', '103.16.25.23', '2023-09-19 02:30:14'),
(1450, 226, '\r\n    User registered.', '118.179.101.65', '2023-09-19 02:31:40'),
(1451, 225, 'Member  in.', '103.16.25.23', '2023-09-19 02:35:36');

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

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

CREATE TABLE `currencies` (
  `id` int(100) 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, 'Indian Rupee', 'INR', '₹', 'left', 1, 1, 1, 'fb62a4f7c4747614699e835de53e6a479f64d07f'),
(2, 'U.S. Dollar', 'USD', '$', 'left', 0.0121831063983, 82.080872259271, 1, '53cd2b56cdafa88052802f5edf4c817fef84aee4');

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

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `id` int(11) NOT NULL,
  `symbol` text DEFAULT NULL,
  `value` double DEFAULT NULL,
  `name` varchar(225) NOT NULL,
  `status` enum('1','2') NOT NULL DEFAULT '1',
  `default` enum('2','1') NOT NULL DEFAULT '2',
  `nouse` enum('1','2') NOT NULL DEFAULT '2'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` (`id`, `symbol`, `value`, `name`, `status`, `default`, `nouse`) VALUES
(1, '$', 1, 'USD', '1', '1', '1'),
(7, '฿', 36.33, 'Baht', '1', '2', '2'),
(8, '₹', 79, 'INR', '1', '2', '2');

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

--
-- 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');

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

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

CREATE TABLE `decoration` (
  `id` int(11) NOT NULL,
  `snow_effect` int(3) NOT NULL,
  `snow_colour` text NOT NULL,
  `diwali_lights` int(3) NOT NULL,
  `video_link` text NOT NULL,
  `christmas_deco` varchar(5000) NOT NULL,
  `action_link` text NOT NULL,
  `pop_noti` int(2) NOT NULL,
  `pop_title` text NOT NULL,
  `pop_desc` text NOT NULL,
  `action_text` varchar(10) NOT NULL,
  `action_button` int(2) NOT NULL,
  `snow_fall` varchar(500) DEFAULT NULL,
  `garlands` text DEFAULT NULL,
  `fire_works` text DEFAULT NULL,
  `toys` text DEFAULT NULL,
  `snowflakes` int(10) NOT NULL,
  `snow_speed` int(20) 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(20) NOT NULL,
  `toy_quantity` int(50) NOT NULL,
  `toy_speed` int(10) 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=utf8 COLLATE=utf8_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, '#22ec4b', 0, '', '\n<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>\n<!-- developed by Raj Patel-->\n      \n<!-- developed by Raj Patel-->  \n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/libs/jquery/1.12.4/jquery.min.js\">\n          </script>\n    \n<!-- developed by Raj Patel-->\n        \n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/flpbonhmkq9tsp29.js\">\n          </script>\n    \n        \n<!-- developed by Raj Patel-->\n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/a4kdpfesx15uh7ae.js\">\n          </script>\n    \n<!-- developed by Raj Patel-->\n        \n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/596z6ya3isgxcipy.js\">\n          </script>\n    \n        \n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/39j8e9yrxs283d1x.js\">\n          </script>\n    \n        \n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/33srijdbqcgk6lsz.js\">\n          </script>\n    \n<!-- developed by Raj Patel-->\n<!-- developed by Raj Patel-->\n        \n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/52pp7z/wxbh27w4jdzpslxn.js\">\n          </script>\n    \n<!-- developed by Raj Patel-->\n<!-- developed by Raj Patel-->\n        \n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/52pp7z/angedasgma230hxr.js\">\n          </script>\n    \n        \n<!-- developed by Raj Patel-->\n<!-- developed by Raj Patel-->\n    <script type=\"text/javascript\" >\n       window.modules.layouts = {\"theme_id\":1,\"auth\":0,\"live\":true};     </script>\n    \n        \n    <script type=\"text/javascript\" >\n       window.modules.signin = [];     </script>\n    \n<!-- developed by Raj Patel-->\n<!-- developed by Raj Patel-->\n<!-- developed by Raj Patel-->\n        \n    <script type=\"text/javascript\" >\n       document.addEventListener(\'DOMContentLoaded\', function() { \nvar 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\"', '', 0, '', '', '', 0, NULL, NULL, NULL, NULL, 50, 10, 'apple', 'style3', '1.02', 'slow', 80, 100, 6, 'infinite', '1', '1', '', '', '', '', '', '', '', '1', '1', 'dukesmm.com', '1');

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

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

CREATE TABLE `earn` (
  `earn_id` int(255) NOT NULL,
  `client_id` int(255) 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

INSERT INTO `files` (`id`, `name`, `link`, `date`) VALUES
(79, NULL, 'https://get.thescripthub.in/img/files/f69c7c1d64f0313b835f9faabd7c6d86.png', '2023-06-07 01:51:11'),
(80, NULL, 'https://get.thescripthub.in/img/files/c06dc11effc5e5040b7e76748d4257d3.png', '2023-06-07 01:52:13'),
(81, NULL, 'https://get.thescripthub.in/img/files/f7952d2012808eb4c134597f0687e806.png', '2023-06-07 02:09:40'),
(82, NULL, 'https://get.thescripthub.in/img/files/6d6444ba303f695dd08c4def75379230.png', '2023-06-07 17:57:33'),
(83, NULL, 'https://get.thescripthub.in/img/files/5551aadc36118558f0139b8da763f30d.png', '2023-06-07 17:57:49'),
(84, NULL, 'https://hqsmmpanel.online/img/files/d9acde7d4ab5d01b88dc47c945b6dddd.png', '2023-06-14 20:23:42'),
(85, NULL, 'https://widesmm.com/img/files/aca5b2b12c1b69f926b020849c48b4e5jpeg', '2023-06-21 17:15:04');

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

--
-- 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=utf8 COLLATE=utf8_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, '', '2', 'Active', 1024, 20, '2', '', '', '2');

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

--
-- 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=utf8 COLLATE=utf8_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, 2),
(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),
(13, 'Google reCAPTCHA v2', 'It uses an advanced risk analysis engine and adaptive challenges to prevent malware from engaging in abusive activities on your website.', '/img/integrations/reCAPTCHA.svg', '', 1, 1),
(14, 'Whatsapp', 'Whatsapp is for Personal Support of your Users', '/img/integrations/whatsapp.svg', '<script async src=\'https://d2mpatx37cqexb.cloudfront.net/delightchat-whatsapp-widget/embeds/embed.min.js\'></script>\r\n        <script>\r\n          var wa_btnSetting = {\"btnColor\":\"#00ff00\",\"ctaText\":\"Need help ? \",\"cornerRadius\":40,\"marginBottom\":\"20\",\"marginLeft\":20,\"marginRight\":20,\"btnPosition\":\"right\",\"whatsAppNumber\":\"+8801819763012\",\"welcomeMessage\":\"Hello Sir I\'m from widesmm and i need help. \",\"zIndex\":999999,\"btnColorScheme\":\"light\"};\r\n          window.onload = () => {\r\n            _waEmbed(wa_btnSetting);\r\n          };\r\n        </script>\r\n      ', 1, 2);

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

--
-- Table structure for table `kuponlar`
--

CREATE TABLE `kuponlar` (
  `id` int(11) NOT NULL,
  `kuponadi` varchar(255) NOT NULL,
  `adet` int(11) NOT NULL,
  `tutar` double NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `kuponlar`
--

INSERT INTO `kuponlar` (`id`, `kuponadi`, `adet`, `tutar`) VALUES
(3, 'NEW5', 10, 5);

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

--
-- Table structure for table `kupon_kullananlar`
--

CREATE TABLE `kupon_kullananlar` (
  `id` int(11) NOT NULL,
  `uye_id` int(11) NOT NULL,
  `kuponadi` varchar(255) NOT NULL,
  `tutar` double NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- 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=utf8 COLLATE=utf8_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'),
(4, 'arabic', 'ar', '1', '0');

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

--
-- 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `menus` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `menu_line` double NOT NULL,
  `type` enum('1','2') CHARACTER SET utf8 COLLATE utf8_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 utf8 COLLATE utf8_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_line`, `type`, `slug`, `icon`, `menu_status`, `visible`, `active`, `tiptext`) VALUES
(1, 'New Order', 1, '2', '/', 'fa fa-shopping-bag', '1', 'Internal', 'neworder', ''),
(2, 'Mass Order', 2, '2', '/massorder', 'fas fa-cart-plus', '1', 'Internal', 'massorder', 'Shown only if Mass Order system enabled for use'),
(3, 'Orders ', 3, '2', '/orders', 'fas fa-server', '1', 'Internal', 'orders', ''),
(4, 'Refill', 4, '2', '/refill', 'fas fa-recycle', '1', 'Internal', 'refill', 'Shown only if user have at least one refill task'),
(5, 'Login', 1, '2', '/', 'fas fa-address-card', '1', 'External', 'login', ''),
(6, 'Services', 5, '2', '/services', 'fas fa-file-alt', '1', 'Internal', 'services', ''),
(7, 'Add Funds', 6, '2', '/addfunds', 'fab fa-cc-amazon-pay', '1', 'Internal', 'addfunds', ''),
(8, 'Api', 9, '2', '/api', 'fal fa-plug', '1', 'Internal', 'api', ''),
(9, 'Tickets ', 8, '2', '/tickets', 'fas fa-headset', '1', 'Internal', 'tickets', ''),
(10, 'Child Panels', 10, '2', '/child-panels', 'fas fa-child', '1', 'Internal', 'child-panels', 'Shown only if child panels selling enabled'),
(11, 'Refer & Earn', 11, '2', '/refer', 'fas fa-bezier-curve', '1', 'Internal', 'refer', 'Shown only if affiliate system enabled for use'),
(13, 'Terms', 12, '2', '/terms', 'fas fa-exclamation-triangle', '1', 'Internal', 'terms', ''),
(14, 'Signup ', 2, '2', '/signup', 'fas fa-arrow-right', '1', 'External', 'signup', 'Shown only if Signup system enabled for use'),
(15, 'Api', 4, '2', '/api', 'fal fa-plug', '1', 'External', 'api', ''),
(17, 'Daily Updates', 13, '2', '/updates', 'fas fa-bell', '1', 'Internal', '', 'Shown only if Updates System enabled'),
(18, 'Terms', 3, '2', '/terms', 'fas fa-exclamation-triangle', '1', 'External', 'terms', ''),
(21, 'Blogs', 14, '1', '/blog', 'fas fa-grip-vertical', '2', 'Internal', 'blog', ''),
(24, 'Services', 14, '2', '/services', 'fas fa-file-shift', '1', 'External', 'services', ''),
(28, 'Transfer Funds ', 14, '2', '/transferfunds', 'fas fa-grip-vertical', '1', 'Internal', 'Transfer Funds ', '');

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

--
-- 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_content` varchar(225) NOT NULL,
  `news_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_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=utf8 COLLATE=utf8_general_ci;

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

--
-- 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
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_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`) VALUES
(2002888906, 220, 2232, 11373129, '-', '{\"order\":11373129}', 28, 4463, 0.10439, 82.750063, 9.7946047694484, 365, '', 9.8989947694484, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://instagram.com/swag_smmstore?igshid=MzNlNGNkZWQ4Mg==', 0, 0, 0, '2023-06-23 23:37:21', 'inprogress', 'active', '', 0, 0, 0, 0, 0, '1970-01-01', '2023-09-14 17:17:04', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0),
(2002888907, 220, 2260, 11375807, '-', '{\"order\":11375807}', 28, 2477, 0.001, NULL, 0.093827040611632, 250, '', 0.094827040611632, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://instagram.com/stories/crazy_swagshooter/3131345896453746629?igshid=MTc4MmM1YmI2Ng==', 0, 0, 0, '2023-06-24 03:04:08', 'pending', 'active', '', 0, 0, 0, 0, 0, '1970-01-01', '2023-09-14 17:17:07', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0),
(2002888908, 220, 2232, 0, 'null', 'null', 28, 4463, 0, NULL, 1.7303, 50, '', 1.7303, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.instagram.com/reel/Ck5uqjtrtMV/?igshid=YmMyMTA2M2Y=', 0, 0, 0, '2023-08-27 23:34:35', 'pending', 'active', '', 0, 0, 0, 0, 0, '1970-01-01', '2023-09-14 17:17:09', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0),
(2002888909, 220, 2232, 0, '{\"error\":\"Invalid API key\"}', '{\"error\":\"Invalid API key\"}', 28, 4463, 0, NULL, 1.7303, 50, '', 1.7303, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.instagram.com/reel/Ck5uqjtrtMV/?igshid=YmMyMTA2M2Y=', 0, 0, 0, '2023-08-27 23:34:38', 'pending', 'active', '', 0, 0, 0, 0, 0, '1970-01-01', '2023-09-14 17:17:11', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0),
(2002888910, 220, 2232, 0, '{\"error\":\"Invalid API key\"}', '{\"error\":\"Invalid API key\"}', 28, 4463, 0, NULL, 3.4606, 100, '', 3.4606, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.instagram.com/reel/Ck5uqjtrtMV/?igshid=YmMyMTA2M2Y=', 0, 0, 0, '2023-08-27 23:34:59', 'pending', 'active', '', 0, 0, 0, 0, 0, '1970-01-01', '2023-09-14 17:17:13', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0),
(2002888911, 220, 2232, 0, '{\"error\":\"Invalid API key\"}', '{\"error\":\"Invalid API key\"}', 28, 4463, 0, NULL, 3.4606, 100, '', 3.4606, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.instagram.com/reel/Ck5uqjtrtMV/?igshid=YmMyMTA2M2Y=', 0, 0, 0, '2023-08-27 23:35:54', 'pending', 'active', '', 0, 0, 0, 0, 0, '1970-01-01', '2023-09-14 17:17:14', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 0),
(2002888912, 220, 2232, 0, '{\"error\":\"Invalid API key\"}', '{\"error\":\"Invalid API key\"}', 28, 4463, 0, NULL, 3.4606, 100, '', 3.4606, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.instagram.com/reel/Ck5uqjtrtMV/?igshid=YmMyMTA2M2Y=', 0, 0, 0, '2023-08-27 23:36:51', 'pending', 'active', '', 0, 0, 0, 0, 0, '1970-01-01', '2023-09-14 17:17:16', 'site', 'Pending', '1', '1', '1', 'true', 0, '1', 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=utf8 COLLATE=utf8_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
(2, 'Add funds', 'addfunds', '', '1', '1', '', '', '', '2022-02-07 08:23:09', '2', ''),
(787, 'Login', 'auth', '', '1', '1', '', '', '', '2023-06-05 04:02:50', '2', ''),
(9, 'New Order', 'neworder', '', '1', '1', '', '', '', '2023-09-19 03:03:48', '2', ''),
(14, 'Terms', 'terms', '', '1', '1', '', '', '', '2022-02-07 08:41:16', '2', ''),
(789, 'Mass Order', 'massorder', '', '1', '1', '', '', '', '2022-02-07 08:43:06', '2', ''),
(790, 'Orders', 'orders', '', '1', '1', '', '', '', '2022-02-07 08:53:20', '2', ''),
(791, 'Services', 'services', '', '1', '1', '', '', '', '2022-01-26 07:22:09', '2', ''),
(792, 'Tickets', 'tickets', '', '1', '1', '', '', '', '2022-01-26 07:22:09', '2', ''),
(793, 'API', 'api', '', '1', '1', '', '', '', '2022-01-24 07:21:07', '2', ''),
(794, 'Signup', 'signup', '', '1', '1', '', '', '', '2022-01-24 07:21:07', '2', ''),
(795, 'Blog', 'blog', '', '1', '1', '', '', '', '2022-01-24 07:21:07', '2', ''),
(909, 'success', 'success', '', '1', '1', '', '', '', '0000-00-00 00:00:00', '1', '');

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

--
-- 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=utf8 COLLATE=utf8_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=utf8 COLLATE=utf8_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', 1451, 1451, '2022-01-24 10:58:08', 'b1fbedd6f1266a8990bf648919068680', '2025-02-23 10:58:08', 'Main');

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

--
-- 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('Manuel','Otomatik','Auto') NOT NULL DEFAULT 'Otomatik',
  `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=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `payments_bonus`
--

CREATE TABLE `payments_bonus` (
  `bonus_id` int(11) NOT NULL,
  `bonus_method` int(11) NOT NULL,
  `bonus_from` double NOT NULL,
  `bonus_amount` double NOT NULL,
  `bonus_type` enum('1','2') NOT NULL DEFAULT '2'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `payments_bonus`
--

INSERT INTO `payments_bonus` (`bonus_id`, `bonus_method`, `bonus_from`, `bonus_amount`, `bonus_type`) VALUES
(2, 14, 5000, 5, '2');

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

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` int(11) NOT NULL,
  `method_name` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `method_get` varchar(225) NOT NULL,
  `method_min` double NOT NULL,
  `method_max` double NOT NULL,
  `method_type` enum('1','2') NOT NULL DEFAULT '2' COMMENT '2 -> ON, 1 -> OFF	',
  `method_extras` text NOT NULL,
  `method_line` double NOT NULL,
  `nouse` enum('1','2') NOT NULL DEFAULT '2'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `method_name`, `method_get`, `method_min`, `method_max`, `method_type`, `method_extras`, `method_line`, `nouse`) VALUES
(1, 'Paypal', 'paypal', 10, 10000, '1', '{\"method_type\":\"1\",\"name\":\"Paypal ( USD ) ( International Payments ) [ 10% Charge ]\",\"min\":\"10\",\"max\":\"10000\",\"client_id\":\"AR3wtI3dxA0qU2dme-kQdC6csRL4whF8SNWzJ2jilchyZvQsBJ7URF4UqktveDp67guIenYYX-e0zuCz\",\"client_secret\":\"EMFtatHjrBMf9EYcec0WZqKwGwO2aum03w62b9tZZWPB2G__WoFuBMkMu0z97NR8ooRJNXR0FqrtagrD\",\"fee\":\"0\"}', 7, '2'),
(2, 'Stripe', 'stripe', 1, 100, '1', '{\"method_type\":\"2\",\"name\":\"Credit card\\/ Debit cards \\/Meeza cards\\/Mobile Wallets (5%BONUS FROM 10$)(Ramdan Offer)\",\"min\":\"1\",\"max\":\"100\",\"stripe_publishable_key\":\"pk_live_51HiUnRLjkQAtcIW0F983imoO8qhftSSMSj7oB9xTjGHB51su6vnuDmGNs5l2NNZz1XE1Ogf1svxqjtdasRYr3atk00wEAHHKNT\",\"stripe_secret_key\":\"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\",\"stripe_webhooks_secret\":\"whsec_gSvhMz0eOIOTk5S9uzzzDgpHeclOmiDe\",\"fee\":\"10\",\"currency\":\"USD\"}', 3, '2'),
(3, 'Shopier', 'shopier', 5, 0, '1', '{\"method_type\":\"1\",\"name\":\"Kredi \\/ Banka Kart\\u0131 ile \\u00d6de\",\"min\":\"5\",\"max\":\"0\",\"apiKey\":\"\",\"apiSecret\":\"\",\"website_index\":\"1\",\"processing_fee\":\"1\",\"fee\":\"10\",\"currency\":\"USD\"}', 12, '2'),
(5, 'Paywant', 'paywant', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Paywant\",\"min\":\"1\",\"max\":\"0\",\"apiKey\":\"\",\"apiSecret\":\"\",\"fee\":\"0\",\"currency\":\"USD\",\"commissionType\":\"2\",\"payment_type\":[\"1\",\"2\",\"3\"]}', 13, '2'),
(7, 'PayTR', 'paytr', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Paytr\",\"min\":\"1\",\"max\":\"0\",\"merchant_id\":\"\",\"merchant_key\":\"\",\"merchant_salt\":\"\",\"fee\":\"0\",\"currency\":\"USD\"}', 14, '2'),
(8, 'Coinpayments', 'coinpayments', 10, 0, '1', '{\"method_type\":\"2\",\"name\":\"CoinPayments ( Cryptocurrency )\",\"min\":\"10\",\"max\":\"0\",\"coinpayments_public_key\":\"5a6f3154ddf28c2017df7ad00ce5c1f2b872822beb1ed32f52e0009a2425ecfd\",\"coinpayments_private_key\":\"da16CB5D8Ce6d90eD7181b5907F2103739ef0D5dbF591Ddf22d8f93649170E2F\",\"coinpayments_currency\":\"BTC\",\"merchant_id\":\"db74662404abc41263c87ed221718ce3\",\"ipn_secret\":\"5566\",\"fee\":\"0\",\"currency\":\"USD\"}', 31, '2'),
(9, '2checkout', '2checkout', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"2checkout\",\"min\":\"1\",\"max\":\"0\",\"seller_id\":\"\",\"private_key\":\"\",\"fee\":\"1\",\"currency\":\"USD\"}', 2, '2'),
(10, 'Payoneer', 'payoneer', 1, 0, '1', '{\"method_type\":\"2\",\"name\":\"Payoneer\",\"email\":\"fazilakbulut@outlook.com\"}', 1, '2'),
(11, 'Mollie', 'mollie', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Mollie\",\"min\":\"1\",\"max\":\"0\",\"live_api_key\":\"\",\"fee\":\"0\",\"currency\":\"USD\"}', 15, '2'),
(12, 'PayTM', 'paytm', 10, 100000, '1', '{\"method_type\":\"2\",\"name\":\"PayTM ( INR )( UPI \\/ NET BANKING \\/ DEBIT \\/ CREDIT CARD)\",\"min\":\"10\",\"max\":\"100000\",\"merchant_key\":\"a4E7wiLw74QGQM&F\",\"merchant_mid\":\"OLVzml48473547814393\",\"merchant_website\":\"DEFAULT\",\"fee\":\"0\",\"currency\":\"INR\"}', 9, '2'),
(13, 'Instamojo', 'instamojo', 0, 0, '1', '{\"method_type\":\"2\",\"name\":\"Instamojo\",\"min\":\"0\",\"max\":\"0\",\"api_key\":\"a2bdf5035c16ad6db389caeb5ceb5273\",\"live_auth_token_key\":\"81ef2affdc5ecfde9b88b13e1cd67cd8\",\"fee\":\"0\",\"currency\":\"INR\"}', 16, '2'),
(14, 'Paytm Business', 'paytmqr', 1, 100000, '2', '{\"method_type\":\"2\",\"name\":\"PAYTM BUSINESS QR\",\"min\":\"1\",\"max\":\"100000\",\"merchant_key\":\"https:\\/\\/i.imgur.com\\/30jPzuQ.png\",\"merchant_mid\":\"nDBuOG92335510034982\",\"merchant_website\":\"DEFAULT\",\"fee\":\"0\"}', 10, '2'),
(15, 'Razorpay', 'razorpay', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Razorpay\",\"min\":\"1\",\"max\":\"0\",\"api_key\":\"0\",\"api_secret_key\":\"0\",\"fee\":\"0\",\"currency\":\"INR\"}', 17, '2'),
(16, 'Iyzico', 'iyzico', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Iyzico\",\"min\":\"1\",\"max\":\"0\",\"api_key\":\"0\",\"api_secret_key\":\"0\",\"fee\":\"0\",\"currency\":\"USD\"}', 18, '2'),
(17, 'Authorize.net', 'authorize-net', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Authorize.net\",\"min\":\"1\",\"max\":\"0\",\"api_login_id\":\"0\",\"secret_transaction_key\":\"0\",\"fee\":\"0\",\"currency\":\"USD\"}', 19, '2'),
(20, 'Ravepay', 'ravepay', 1, 10, '1', '{\"method_type\":\"2\",\"name\":\"Ravepay\",\"min\":\"1\",\"max\":\"10\",\"public_api_key\":\"0\",\"secret_api_key\":\"0\",\"fee\":\"0\",\"currency\":\"USD\"}', 21, '2'),
(21, 'Pagseguro', 'pagseguro', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Pagseguro\",\"min\":\"1\",\"max\":\"0\",\"email_id\":\"0\",\"live_production_token\":\"0\",\"fee\":\"0\",\"currency\":\"USD\"}', 22, '2'),
(22, 'Cashmaal', 'Cashmaal', 10, 10000, '1', '{\"method_type\":\"1\",\"name\":\"CashMaal (USD)(JAZZCASH)(EASYPAISA)\",\"min\":\"10\",\"max\":\"10000\",\"web_id\":\"5396\",\"fee\":\"0\",\"currency\":\"USD\"}', 32, '2'),
(25, 'Refer & earn', 'refer', 0, 0, '1', '{\"method_type\":\"2\",\"name\":\"Do Not Use\",\"min\":\"1\",\"max\":\"10000\",\"merchant_key\":\"P#n%aKfB3&DRAMqH\",\"merchant_mid\":\"DBWvgX98800736620578\",\"merchant_website\":\"DEFAULT\",\"fee\":\"0\",\"currency\":\"\"}', 25, '1'),
(26, 'payumoney', 'payumoney', 1, 100000, '1', '{\"method_type\":\"1\",\"name\":\"Payumoney\",\"min\":\"1\",\"max\":\"100000\",\"merchant_key\":\"enpCDi\",\"salt_key\":\"1KUjnA24bfjWaE3MwTXejb3utYYapfqb\",\"fee\":\"5\",\"currency\":\"INR\"}', 20, '2'),
(30, 'Freebalance', 'Freebalance', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Freebalance\",\"min\":\"1\",\"max\":\"0\",\"merchant_id\":\"\",\"merchant_key\":\"\",\"merchant_salt\":\"\",\"fee\":\"0\"}', 30, '1'),
(31, 'Perfect Money', 'perfectmoney', 0.1, 10000, '1', '{\"method_type\":\"2\",\"name\":\"Perfect Money\",\"min\":\"0.10\",\"max\":\"10000\",\"passphrase\":\"r19Np500wEcWiEBiTaOXxovit\",\"usd\":\"U41872434\",\"merchant_website\":\"It\'s your \",\"fee\":\"0\"}', 8, '2'),
(32, 'Coinbase', 'Coinbase', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Coinbase ( Cryptocurrency )\",\"min\":\"1\",\"max\":\"0\",\"api_key\":\"\",\"webhook_api\":\"\",\"fee\":\"0\"}', 23, '2'),
(33, 'Webmoney', 'Webmoney', 1, 1, '1', '{\"method_type\":\"2\",\"name\":\"Webmoney\",\"min\":\"1\",\"max\":\"1\",\"wmid\":\"\",\"purse\":\"\",\"fee\":\"0\"}', 24, '2'),
(34, 'UnitPay', 'UnityPay', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"UnitPay\",\"min\":\"1\",\"max\":\"0\",\"secret_key\":\"\",\"reg_email\":\"\",\"fee\":\"0\"}', 25, '2'),
(35, 'Payeer', 'payeer', 10, 0, '1', '{\"method_type\":\"2\",\"name\":\"Payeer\",\"min\":\"1\",\"max\":\"100000\",\"account\":\"P1059667343\",\"client_secret\":\"tQCaSXyX94pRgpOt\",\"user_id\":\"1654044737\",\"user_pass\":\"tQCaSXyX94pRgpOt\",\"m_shop\":\"1652134607\"}', 5, '2'),
(36, '<b>FundsSystem</b>', 'funds', 1, 0, '1', '{}', 26, '2'),
(37, 'opay', 'opay', 1, 1000, '1', '{\"method_type\":\"2\",\"is_demo\":\"1\",\"name\":\"opay - Visa - Mastercard - Mobile Wallets\",\"min\":\"1\",\"max\":\"1000\",\"merchant_id\":\"281822041448063\",\"secret_key\":\"OPAYPRV16499350091410.788976381970694\",\"public_key\":\"OPAYPUB16499350091410.6534196662876502\",\"dollar_rate\":\"18.5\"}', 6, '2'),
(39, 'Phonepe', 'phonepe', 1, 10000, '1', '{\"method_type\":\"2\",\"name\":\"Phone Pe\",\"min\":\"1\",\"max\":\"10000\",\"phonepe_qr_link\":\"https:\\/\\/i.ibb.co\\/jzStZvZ\\/photo-2022-12-23-17-10-12.jpg\",\"email\":\"amitbhatijsm@gmail.com\",\"pass\":\"fgjhjghfjg\"}', 11, '2');

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

--
-- Table structure for table `payment_methodsold`
--

CREATE TABLE `payment_methodsold` (
  `id` int(11) NOT NULL,
  `method_name` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `method_get` varchar(225) NOT NULL,
  `method_min` double NOT NULL,
  `method_max` double NOT NULL,
  `method_type` enum('1','2') NOT NULL DEFAULT '2' COMMENT '2 -> ON, 1 -> OFF	',
  `method_extras` text NOT NULL,
  `method_line` double NOT NULL,
  `nouse` enum('1','2') NOT NULL DEFAULT '2'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `payment_methodsold`
--

INSERT INTO `payment_methodsold` (`id`, `method_name`, `method_get`, `method_min`, `method_max`, `method_type`, `method_extras`, `method_line`, `nouse`) VALUES
(1, 'Paypal', 'paypal', 10, 10000, '2', '{\"method_type\":\"2\",\"name\":\"Paypal ( USD ) ( International Payments ) [ 10% Charge ]\",\"min\":\"10\",\"max\":\"10000\",\"client_id\":\"AWWRCH4eG0dDMY_84cDXJVKVsBGSzJpnezbgAB4Qm49cTQ2dJwZWMaWzNAbUv4ojUunW-pgicoYTMA0l\",\"client_secret\":\"EMiHDg3EejaX_ns8h3ybEkgBcm_mbFfPoK_EeNyW_UGX_LJlKxa3lpW9nDf7-gRrQMV1kyUWS1J48NxC\",\"fee\":\"10\"}', 3, '2'),
(2, 'Stripe', 'stripe', 1, 100, '1', '{\"method_type\":\"2\",\"name\":\"Stripe\",\"min\":\"1\",\"max\":\"100\",\"stripe_publishable_key\":\"pk_live_51HiUnRLjkQAtcIW0F983imoO8qhftSSMSj7oB9xTjGHB51su6vnuDmGNs5l2NNZz1XE1Ogf1svxqjtdasRYr3atk00wEAHHKNT\",\"stripe_secret_key\":\"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\",\"stripe_webhooks_secret\":\"whsec_gSvhMz0eOIOTk5S9uzzzDgpHeclOmiDe\",\"fee\":\"10\",\"currency\":\"USD\"}', 4, '2'),
(3, 'Shopier', 'shopier', 5, 0, '1', '{\"method_type\":\"1\",\"name\":\"Kredi \\/ Banka Kart\\u0131 ile \\u00d6de\",\"min\":\"5\",\"max\":\"0\",\"apiKey\":\"\",\"apiSecret\":\"\",\"website_index\":\"1\",\"processing_fee\":\"1\",\"fee\":\"10\",\"currency\":\"USD\"}', 5, '2'),
(5, 'Paywant', 'paywant', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Paywant\",\"min\":\"1\",\"max\":\"0\",\"apiKey\":\"\",\"apiSecret\":\"\",\"fee\":\"0\",\"currency\":\"USD\",\"commissionType\":\"2\",\"payment_type\":[\"1\",\"2\",\"3\"]}', 6, '2'),
(7, 'PayTR', 'paytr', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Paytr\",\"min\":\"1\",\"max\":\"0\",\"merchant_id\":\"\",\"merchant_key\":\"\",\"merchant_salt\":\"\",\"fee\":\"0\",\"currency\":\"USD\"}', 7, '2'),
(8, 'Coinpayments', 'coinpayments', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Coinpayments\",\"min\":\"1\",\"max\":\"0\",\"coinpayments_public_key\":\"\",\"coinpayments_private_key\":\"\",\"coinpayments_currency\":\"LTCT\",\"merchant_id\":\"\",\"ipn_secret\":\"\",\"fee\":\"0\",\"currency\":\"USD\"}', 8, '2'),
(9, '2checkout', '2checkout', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"2checkout\",\"min\":\"1\",\"max\":\"0\",\"seller_id\":\"\",\"private_key\":\"\",\"fee\":\"1\",\"currency\":\"USD\"}', 9, '2'),
(10, 'Payoneer', 'payoneer', 1, 0, '1', '{\"method_type\":\"2\",\"name\":\"Payoneer\",\"email\":\"fazilakbulut@outlook.com\"}', 10, '2'),
(11, 'Mollie', 'mollie', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Mollie\",\"min\":\"1\",\"max\":\"0\",\"live_api_key\":\"\",\"fee\":\"0\",\"currency\":\"USD\"}', 11, '2'),
(12, 'PayTM', 'paytm', 10, 100000, '2', '{\"method_type\":\"2\",\"name\":\"PayTM ( INR )( UPI \\/ NET BANKING \\/ DEBIT \\/ CREDIT CARD)\",\"min\":\"10\",\"max\":\"100000\",\"merchant_key\":\"IR6iRT5L0tOxBte4\",\"merchant_mid\":\"gVkWqH50536759745964\",\"merchant_website\":\"DEFAULT\",\"fee\":\"0\",\"currency\":\"\"}', 2, '2'),
(13, 'Instamojo', 'instamojo', 0, 0, '1', '{\"method_type\":\"2\",\"name\":\"Instamojo\",\"min\":\"0\",\"max\":\"0\",\"api_key\":\"a2bdf5035c16ad6db389caeb5ceb5273\",\"live_auth_token_key\":\"81ef2affdc5ecfde9b88b13e1cd67cd8\",\"fee\":\"0\",\"currency\":\"INR\"}', 12, '2'),
(14, 'Paytm Business', 'paytmqr', 10, 1000000, '2', '{\"method_type\":\"2\",\"name\":\"PayTM QR (5% Bonus From 2000rs)\",\"min\":\"10\",\"max\":\"1000000\",\"merchant_key\":\"https:\\/\\/i.imgur.com\\/mlAI1qX.png\",\"merchant_mid\":\"HYJEZD46937702834501\",\"merchant_website\":\"DEFAULT\",\"fee\":\"0\"}', 1, '2'),
(15, 'Razorpay', 'razorpay', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Razorpay\",\"min\":\"1\",\"max\":\"0\",\"api_key\":\"0\",\"api_secret_key\":\"0\",\"fee\":\"0\",\"currency\":\"INR\"}', 13, '2'),
(16, 'Iyzico', 'iyzico', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Iyzico\",\"min\":\"1\",\"max\":\"0\",\"api_key\":\"0\",\"api_secret_key\":\"0\",\"fee\":\"0\",\"currency\":\"USD\"}', 14, '2'),
(17, 'Authorize.net', 'authorize-net', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Authorize.net\",\"min\":\"1\",\"max\":\"0\",\"api_login_id\":\"0\",\"secret_transaction_key\":\"0\",\"fee\":\"0\",\"currency\":\"USD\"}', 15, '2'),
(20, 'Ravepay', 'ravepay', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Ravepay\",\"min\":\"1\",\"max\":\"0\",\"public_api_key\":\"0\",\"secret_api_key\":\"0\",\"fee\":\"0\",\"currency\":\"USD\"}', 17, '2'),
(21, 'Pagseguro', 'pagseguro', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Pagseguro\",\"min\":\"1\",\"max\":\"0\",\"email_id\":\"0\",\"live_production_token\":\"0\",\"fee\":\"0\",\"currency\":\"USD\"}', 18, '2'),
(22, 'Cashmaal', 'Cashmaal', 1, 10000, '2', '{\"method_type\":\"2\",\"name\":\"CashMaal (USD)(JAZZCASH)(EASYPAISA)\",\"min\":\"1\",\"max\":\"10000\",\"web_id\":\"5396\",\"fee\":\"0\",\"currency\":\"USD\"}', 19, '2'),
(25, 'Refer & earn', 'refer', 0, 0, '1', '{\"method_type\":\"2\",\"name\":\"Do Not Use\",\"min\":\"1\",\"max\":\"10000\",\"merchant_key\":\"P#n%aKfB3&DRAMqH\",\"merchant_mid\":\"DBWvgX98800736620578\",\"merchant_website\":\"DEFAULT\",\"fee\":\"0\",\"currency\":\"\"}', 25, '1'),
(26, 'payumoney', 'payumoney', 10, 0, '1', '{\"method_type\":\"2\",\"name\":\"Payumoney\",\"min\":\"10\",\"max\":\"0\",\"merchant_key\":\"Mv4ctvrc\",\"salt_key\":\"pWUvDRU8CT\",\"fee\":\"10\",\"currency\":\"INR\"}', 16, '2'),
(30, 'Freebalance', 'Freebalance', 1, 0, '1', '{\"method_type\":\"1\",\"name\":\"Freebalance\",\"min\":\"1\",\"max\":\"0\",\"merchant_id\":\"\",\"merchant_key\":\"\",\"merchant_salt\":\"\",\"fee\":\"0\"}', 30, '1');

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

--
-- 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=utf8 COLLATE=utf8_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', 'dc749b', 0),
(2, 2, 0, 0, 0, 0, '0', 0, '1', '5a80a3', 0),
(3, 3, 0, 0, 0, 0, '0', 0, '1', '192c2e', 0),
(4, 4, 0, 0, 0, 0, '0', 0, '1', 'd7eeeb', 0),
(5, 5, 0, 0, 0, 0, '0', 0, '1', 'cd2cce', 0),
(6, 6, 0, 0, 0, 0, '0', 0, '1', '90ae05', 0),
(7, 7, 0, 0, 0, 0, '0', 0, '1', 'fbca1d', 0),
(8, 8, 0, 0, 0, 0, '0', 0, '1', '58963a', 0),
(9, 9, 0, 0, 0, 0, '0', 0, '1', '323577', 0),
(10, 10, 0, 0, 0, 0, '0', 0, '1', '4bd0f4', 0),
(11, 11, 0, 0, 0, 0, '0', 0, '1', 'c77dcf', 0),
(12, 12, 0, 0, 0, 0, '0', 0, '1', 'af57ed', 0),
(13, 13, 0, 0, 0, 0, '0', 0, '1', '6e0836', 0),
(14, 14, 0, 0, 0, 0, '0', 0, '1', '7a0e8e', 0),
(15, 15, 0, 0, 0, 0, '0', 0, '1', '6707bf', 0),
(16, 16, 0, 0, 0, 0, '0', 0, '1', 'ae4335', 0),
(17, 17, 0, 0, 0, 0, '0', 0, '1', '13f820', 0),
(18, 18, 0, 0, 0, 0, '0', 0, '1', '836149', 0),
(19, 19, 0, 0, 0, 0, '0', 0, '1', 'ac98dd', 0),
(20, 20, 0, 0, 0, 0, '0', 0, '1', '8eb9ed', 0),
(21, 21, 0, 0, 0, 0, '0', 0, '1', '3b3d00', 0),
(22, 22, 0, 0, 0, 0, '0', 0, '1', '4073ff', 0),
(23, 23, 0, 0, 0, 0, '0', 0, '1', 'e7beae', 0),
(24, 24, 0, 0, 0, 0, '0', 0, '1', '124544', 0),
(25, 25, 0, 0, 0, 0, '0', 0, '1', 'bd77a5', 0),
(26, 26, 0, 0, 0, 0, '0', 0, '1', 'ab3548', 0),
(27, 27, 0, 0, 0, 0, '0', 0, '1', 'af125f', 0),
(28, 28, 0, 0, 0, 0, '0', 0, '1', '87d4fe', 0),
(29, 29, 0, 0, 0, 0, '0', 0, '1', 'f6ce2a', 0),
(30, 30, 0, 0, 0, 0, '0', 0, '1', 'b882fb', 0),
(31, 31, 0, 0, 0, 0, '0', 0, '1', '9e7bab', 0),
(32, 32, 0, 0, 0, 0, '0', 0, '1', 'b3f87e', 0),
(33, 33, 0, 0, 0, 0, '0', 0, '1', '955e27', 0),
(34, 34, 0, 0, 0, 0, '0', 0, '1', 'e873e3', 0),
(35, 35, 0, 0, 0, 0, '0', 0, '1', 'd533d2', 0),
(36, 36, 0, 0, 0, 0, '0', 0, '1', '4d94e4', 0),
(37, 37, 0, 0, 0, 0, '0', 0, '1', '4bd044', 0),
(38, 38, 0, 0, 0, 0, '0', 0, '1', 'b6a67b', 0),
(39, 39, 0, 0, 0, 0, '0', 0, '1', '9f020b', 0),
(40, 40, 0, 0, 0, 0, '0', 0, '1', 'b75865', 0),
(41, 41, 0, 0, 0, 0, '0', 0, '1', '47c31a', 0),
(42, 42, 0, 0, 0, 0, '0', 0, '1', '624ef4', 0),
(43, 43, 0, 0, 0, 0, '0', 0, '1', '2e8831', 0),
(44, 44, 0, 0, 0, 0, '0', 0, '1', 'bfce19', 0),
(45, 45, 0, 0, 0, 0, '0', 0, '1', 'a9ce17', 0),
(46, 46, 0, 0, 0, 0, '0', 0, '1', 'b9e72a', 0),
(47, 47, 0, 0, 0, 0, '0', 0, '1', 'beb979', 0),
(48, 48, 0, 0, 0, 0, '0', 0, '1', '394dd8', 0),
(49, 49, 0, 0, 0, 0, '0', 0, '1', 'adb9d2', 0),
(50, 50, 0, 0, 0, 0, '0', 0, '1', '993ae5', 0),
(51, 51, 0, 0, 0, 0, '0', 0, '1', 'fd8505', 0),
(52, 52, 0, 0, 0, 0, '0', 0, '1', '747560', 0),
(53, 53, 0, 0, 0, 0, '0', 0, '1', 'c168e6', 0),
(54, 54, 0, 0, 0, 0, '0', 0, '1', 'dcd735', 0),
(55, 55, 0, 0, 0, 0, '0', 0, '1', 'f0c71f', 0),
(56, 56, 0, 0, 0, 0, '0', 0, '1', 'e5cce8', 0),
(57, 57, 0, 0, 0, 0, '0', 0, '1', '2e7f59', 0),
(58, 58, 0, 0, 0, 0, '0', 0, '1', 'b6d5cb', 0),
(59, 59, 0, 0, 0, 0, '0', 0, '1', '8fba45', 0),
(60, 60, 0, 0, 0, 0, '0', 0, '1', 'bf6bb6', 0),
(61, 61, 0, 0, 0, 0, '0', 0, '1', 'fc387b', 0),
(62, 2, 0, 0, 0, 0, '0', 0, '1', '32c6c2', 0),
(63, 3, 0, 0, 0, 0, '0', 0, '1', 'ec61d3', 0),
(64, 4, 0, 0, 0, 0, '0', 0, '1', '63a1a5', 0),
(65, 5, 0, 0, 0, 0, '0', 0, '1', '1d2029', 0),
(66, 6, 0, 0, 0, 0, '0', 0, '1', '100689', 0),
(67, 7, 0, 0, 0, 0, '0', 0, '1', '8eb50b', 0),
(68, 8, 0, 0, 0, 0, '0', 0, '1', '0ad621', 0),
(69, 9, 0, 0, 0, 0, '0', 0, '1', 'ad6c7c', 0),
(70, 10, 0, 0, 0, 0, '0', 0, '1', 'ba5dcf', 0),
(71, 11, 0, 0, 0, 0, '0', 0, '1', '10816e', 0),
(72, 12, 0, 0, 0, 0, '0', 0, '1', 'e9bc32', 0),
(73, 13, 0, 0, 0, 0, '0', 0, '1', 'f86632', 0),
(74, 14, 0, 0, 0, 0, '0', 0, '1', 'fdded9', 0),
(75, 15, 0, 0, 0, 0, '0', 0, '1', '437361', 0),
(76, 16, 0, 0, 0, 0, '0', 0, '1', '145a42', 0),
(77, 17, 0, 0, 0, 0, '0', 0, '1', 'fd98fe', 0),
(78, 18, 0, 0, 0, 0, '0', 0, '1', '5127d0', 0),
(79, 19, 0, 0, 0, 0, '0', 0, '1', '0c42a1', 0),
(80, 20, 0, 0, 0, 0, '0', 0, '1', 'a02e9f', 0),
(81, 21, 0, 0, 0, 0, '0', 0, '1', '37f85a', 0),
(82, 22, 0, 0, 0, 0, '0', 0, '1', 'acd2f0', 0),
(83, 23, 0, 0, 0, 0, '0', 0, '1', '79dcdf', 0),
(84, 24, 0, 0, 0, 0, '0', 0, '1', '09152b', 0),
(85, 25, 0, 0, 0, 0, '0', 0, '1', 'be7ac9', 0),
(86, 26, 0, 0, 0, 0, '0', 0, '1', 'c019a3', 0),
(87, 27, 0, 0, 0, 0, '0', 0, '1', 'b21fd2', 0),
(88, 28, 0, 0, 0, 0, '0', 0, '1', '6a50f8', 0),
(89, 29, 0, 0, 0, 0, '0', 0, '1', 'dc6c75', 0),
(90, 30, 0, 0, 0, 0, '0', 0, '1', '1f6ca5', 0),
(91, 31, 0, 0, 0, 0, '0', 0, '1', '1eed13', 0),
(92, 32, 0, 0, 0, 0, '0', 0, '1', '7bc665', 0),
(93, 33, 0, 0, 0, 0, '0', 0, '1', '46bab6', 0),
(94, 34, 0, 0, 0, 0, '0', 0, '1', '6d0510', 0),
(95, 35, 0, 0, 0, 0, '0', 0, '1', 'dfc41a', 0),
(96, 36, 0, 0, 0, 0, '0', 0, '1', '1efb96', 0),
(97, 37, 0, 0, 0, 0, '0', 0, '1', '88999f', 0),
(98, 38, 0, 0, 0, 0, '0', 0, '1', '85775b', 0),
(99, 39, 0, 0, 0, 0, '0', 0, '1', 'f13837', 0),
(100, 40, 0, 0, 0, 0, '0', 0, '1', '5a8855', 0),
(101, 41, 0, 0, 0, 0, '0', 0, '1', 'cc3586', 0),
(102, 42, 0, 0, 0, 0, '0', 0, '1', '14051a', 0),
(103, 43, 0, 0, 0, 0, '0', 0, '1', 'b7e060', 0),
(104, 44, 0, 0, 0, 0, '0', 0, '1', 'b18fe6', 0),
(105, 45, 0, 0, 0, 0, '0', 0, '1', '71eec4', 0),
(106, 46, 0, 0, 0, 0, '0', 0, '1', 'f9c12e', 0),
(107, 47, 0, 0, 0, 0, '0', 0, '1', '8a60bb', 0),
(108, 48, 0, 0, 0, 0, '0', 0, '1', '005206', 0),
(109, 49, 0, 0, 0, 0, '0', 0, '1', 'e58c4c', 0),
(110, 50, 0, 0, 0, 0, '0', 0, '1', '4e93b5', 0),
(111, 51, 0, 0, 0, 0, '0', 0, '1', 'e7e461', 0),
(112, 52, 0, 0, 0, 0, '0', 0, '1', '121d2e', 0),
(113, 53, 0, 0, 0, 0, '0', 0, '1', '5d6fd8', 0),
(114, 54, 0, 0, 0, 0, '0', 0, '1', '195291', 0),
(115, 55, 0, 0, 0, 0, '0', 0, '1', 'ae3880', 0),
(116, 56, 0, 0, 0, 0, '0', 0, '1', 'd99416', 0),
(117, 57, 0, 0, 0, 0, '0', 0, '1', '595957', 0),
(118, 58, 0, 0, 0, 0, '0', 0, '1', 'bb9f23', 0),
(119, 59, 0, 0, 0, 0, '0', 0, '1', '184db6', 0),
(120, 60, 0, 0, 0, 0, '0', 0, '1', 'cbe5af', 0),
(121, 61, 0, 0, 0, 0, '0', 0, '1', 'f9b615', 0),
(122, 62, 0, 0, 0, 0, '0', 0, '1', '1b99c8', 0),
(123, 63, 0, 0, 0, 0, '0', 0, '1', '97c775', 0),
(124, 64, 0, 0, 0, 0, '0', 0, '1', '416897', 0),
(125, 65, 0, 0, 0, 0, '0', 0, '1', '349b00', 0),
(126, 66, 0, 0, 0, 0, '0', 0, '1', '7da376', 0),
(127, 67, 0, 0, 0, 0, '0', 0, '1', '7d88c3', 0),
(128, 68, 0, 0, 0, 0, '0', 0, '1', '562f20', 0),
(129, 69, 0, 0, 0, 0, '0', 0, '1', '30748c', 0),
(130, 70, 0, 0, 0, 0, '0', 0, '1', '5dd57b', 0),
(131, 71, 0, 0, 0, 0, '0', 0, '1', '721453', 0),
(132, 72, 0, 0, 0, 0, '0', 0, '1', 'dd683b', 0),
(133, 73, 0, 0, 0, 0, '0', 0, '1', 'f4e205', 0),
(134, 74, 0, 0, 0, 0, '0', 0, '1', 'f548b0', 0),
(135, 75, 0, 0, 0, 0, '0', 0, '1', '555e90', 0),
(136, 76, 0, 0, 0, 0, '0', 0, '1', '34d943', 0),
(137, 77, 0, 0, 0, 0, '0', 0, '1', '72b69c', 0),
(138, 78, 0, 0, 0, 0, '0', 0, '1', '55a8f2', 0),
(139, 79, 0, 0, 0, 0, '0', 0, '1', '6dde1f', 0),
(140, 80, 0, 0, 0, 0, '0', 0, '1', '2cd979', 0),
(141, 81, 0, 0, 0, 0, '0', 0, '1', '86d5ad', 0),
(142, 82, 0, 0, 0, 0, '0', 0, '1', 'd2a96c', 0),
(143, 83, 0, 0, 0, 0, '0', 0, '1', '89ebc9', 0),
(144, 84, 0, 0, 0, 0, '0', 0, '1', 'c5df42', 0),
(145, 85, 0, 0, 0, 0, '0', 0, '1', '023c48', 0),
(146, 86, 0, 0, 0, 0, '0', 0, '1', '848823', 0),
(147, 87, 0, 0, 0, 0, '0', 0, '1', '76e5f1', 0),
(148, 88, 0, 0, 0, 0, '0', 0, '1', 'cf4fe5', 0),
(149, 89, 0, 0, 0, 0, '0', 0, '1', 'ec2774', 0),
(150, 90, 0, 0, 0, 0, '0', 0, '1', '2d06af', 0),
(151, 91, 0, 0, 0, 0, '0', 0, '1', '647fbb', 0),
(152, 92, 0, 0, 0, 0, '0', 0, '1', 'e2f4ae', 0),
(153, 93, 0, 0, 0, 0, '0', 0, '1', 'bef666', 0),
(154, 94, 0, 0, 0, 0, '0', 0, '1', '7e9f85', 0),
(155, 95, 0, 0, 0, 0, '0', 0, '1', '95f7e7', 0),
(156, 96, 0, 0, 0, 0, '0', 0, '1', 'f6c5c2', 0),
(157, 97, 0, 0, 0, 0, '0', 0, '1', 'cc7676', 0),
(158, 98, 0, 0, 0, 0, '0', 0, '1', '7e6fdd', 0),
(159, 99, 0, 0, 0, 0, '0', 0, '1', 'c78cac', 0),
(160, 100, 0, 0, 0, 0, '0', 0, '1', '88e5a9', 0),
(161, 101, 0, 0, 0, 0, '0', 0, '1', '62a30b', 0),
(162, 102, 0, 0, 0, 0, '0', 0, '1', '6af8a0', 0),
(163, 103, 0, 0, 0, 0, '0', 0, '1', '022adf', 0),
(164, 104, 0, 0, 0, 0, '0', 0, '1', '306268', 0),
(165, 105, 0, 0, 0, 0, '0', 0, '1', 'e7fc9f', 0),
(166, 106, 0, 0, 0, 0, '0', 0, '1', 'a002e3', 0),
(167, 107, 0, 0, 0, 0, '0', 0, '1', '8d976e', 0),
(168, 108, 0, 0, 0, 0, '0', 0, '1', 'ad0bf0', 0),
(169, 109, 0, 0, 0, 0, '0', 0, '1', '5df12d', 0),
(170, 110, 0, 0, 0, 0, '0', 0, '1', '6c0457', 0),
(171, 111, 0, 0, 0, 0, '0', 0, '1', 'd80261', 0),
(172, 112, 0, 0, 0, 0, '0', 0, '1', '18136a', 0),
(173, 113, 0, 0, 0, 0, '0', 0, '1', '96821c', 0),
(174, 114, 0, 0, 0, 0, '0', 0, '1', '54ab1c', 0),
(175, 115, 0, 0, 0, 0, '0', 0, '1', 'f3ead1', 0),
(176, 116, 0, 0, 0, 0, '0', 0, '1', '79d500', 0),
(177, 117, 0, 0, 0, 0, '0', 0, '1', 'adfa93', 0),
(178, 118, 0, 0, 0, 0, '0', 0, '1', '04c6d0', 0),
(179, 119, 0, 0, 0, 0, '0', 0, '1', 'fc7149', 0),
(180, 120, 0, 0, 0, 0, '0', 0, '1', '7c2d07', 0),
(181, 121, 0, 0, 0, 0, '0', 0, '1', 'c77034', 0),
(182, 122, 0, 0, 0, 0, '0', 0, '1', '2f415a', 0),
(183, 1001, 0, 0, 0, 0, '0', 0, '1', 'c0469a', 0),
(184, 1002, 0, 0, 0, 0, '0', 0, '1', 'a1cb46', 0),
(185, 1003, 0, 0, 0, 0, '0', 0, '1', '72b211', 0),
(186, 1004, 0, 0, 0, 0, '0', 0, '1', '06fb67', 0),
(187, 1005, 0, 0, 0, 0, '0', 0, '1', 'de54fd', 0),
(188, 1006, 0, 0, 0, 0, '0', 0, '1', '39506f', 0),
(189, 1007, 0, 0, 0, 0, '0', 0, '1', '4555ce', 0),
(190, 1008, 0, 0, 0, 0, '0', 0, '1', '85d8d1', 0),
(191, 1009, 0, 0, 0, 0, '0', 0, '1', 'faf4cd', 0),
(192, 1010, 0, 0, 0, 0, '0', 0, '1', 'c89cfa', 0),
(193, 1011, 0, 0, 0, 0, '0', 0, '1', '248a27', 0),
(194, 1012, 0, 0, 0, 0, '0', 0, '1', '2ee28d', 0),
(195, 1013, 0, 0, 0, 0, '0', 0, '1', 'f5573b', 0),
(196, 1014, 0, 0, 0, 0, '0', 0, '1', '8fbe3a', 0),
(197, 1015, 0, 0, 0, 0, '0', 0, '1', '23253d', 0),
(198, 1016, 0, 0, 0, 0, '0', 0, '1', '4f2891', 0),
(199, 1017, 0, 0, 0, 0, '0', 0, '1', 'fc7210', 0),
(200, 1018, 0, 0, 0, 0, '0', 0, '1', '86c163', 0),
(201, 1019, 0, 0, 0, 0, '0', 0, '1', '1459aa', 0),
(202, 1020, 0, 0, 0, 0, '0', 0, '1', '2d83e6', 0),
(203, 1021, 0, 0, 0, 0, '0', 0, '1', 'e56c4e', 0),
(204, 143, 0, 0, 0, 0, '0', 0, '1', 'dc183d', 0),
(205, 144, 0, 0, 0, 0, '0', 0, '1', '08e330', 0),
(206, 145, 0, 0, 0, 0, '0', 0, '1', '9bf399', 0),
(207, 146, 0, 0, 0, 0, '0', 0, '1', 'd79c97', 0),
(208, 147, 0, 0, 0, 0, '0', 0, '1', 'a9432a', 0),
(209, 148, 0, 0, 0, 0, '0', 0, '1', 'fcca62', 0),
(210, 149, 0, 0, 0, 0, '0', 0, '1', '3e9358', 0),
(211, 150, 0, 0, 0, 0, '0', 0, '1', '2c2efe', 0),
(212, 151, 0, 0, 0, 0, '0', 0, '1', '544f2c', 0),
(213, 152, 0, 0, 0, 0, '0', 0, '1', '276a48', 0),
(214, 153, 0, 0, 0, 0, '0', 0, '1', '32f8be', 0),
(215, 154, 0, 0, 0, 0, '0', 0, '1', '70976c', 0),
(216, 155, 0, 0, 0, 0, '0', 0, '1', 'aac08f', 0),
(217, 156, 0, 0, 0, 0, '0', 0, '1', 'fae6c2', 0),
(218, 157, 0, 0, 0, 0, '0', 0, '1', 'f506d7', 0),
(219, 158, 0, 0, 0, 0, '0', 0, '1', '629eec', 0),
(220, 159, 0, 0, 0, 0, '0', 0, '1', '618aac', 0),
(221, 160, 0, 0, 0, 0, '0', 0, '1', '31047e', 0),
(222, 161, 0, 0, 0, 0, '0', 0, '1', 'e6b399', 0),
(223, 162, 0, 0, 0, 0, '0', 0, '1', '4827e5', 0),
(224, 163, 0, 0, 0, 0, '0', 0, '1', '1dffb1', 0),
(225, 164, 0, 0, 0, 0, '0', 0, '1', 'da40e1', 0),
(226, 165, 0, 0, 0, 0, '0', 0, '1', '073ed2', 0),
(227, 166, 0, 0, 0, 0, '0', 0, '1', 'eb3b8e', 0),
(228, 167, 0, 0, 0, 0, '0', 0, '1', 'ca35b7', 0),
(229, 168, 0, 0, 0, 0, '0', 0, '1', 'cd846b', 0),
(230, 169, 0, 0, 0, 0, '0', 0, '1', '68b4ae', 0),
(231, 170, 0, 0, 0, 0, '0', 0, '1', 'ddecba', 0),
(232, 171, 0, 0, 0, 0, '0', 0, '1', '396aa5', 0),
(233, 172, 0, 0, 0, 0, '0', 0, '1', '7a54bd', 0),
(234, 173, 0, 0, 0, 0, '0', 0, '1', '479d14', 0),
(235, 174, 0, 0, 0, 0, '0', 0, '1', 'e396f2', 0),
(236, 175, 0, 0, 0, 0, '0', 0, '1', '588642', 0),
(237, 176, 0, 0, 0, 0, '0', 0, '1', '1eb6d3', 0),
(238, 177, 0, 0, 0, 0, '0', 0, '1', '136ff4', 0),
(239, 178, 0, 0, 0, 0, '0', 0, '1', '7647da', 0),
(240, 179, 0, 0, 0, 0, '0', 0, '1', 'f3a7b1', 0),
(241, 180, 0, 0, 0, 0, '0', 0, '1', '676500', 0),
(242, 181, 0, 0, 0, 0, '0', 0, '1', '3fc16e', 0),
(243, 182, 0, 0, 0, 0, '0', 0, '1', '311daf', 0),
(244, 183, 0, 0, 0, 0, '0', 0, '1', '67ae19', 0),
(245, 184, 0, 0, 0, 0, '0', 0, '1', '5dd1a7', 0),
(246, 185, 0, 0, 0, 0, '0', 0, '1', '41c2cc', 0),
(247, 186, 0, 0, 0, 0, '0', 0, '1', '27cc7b', 0),
(248, 187, 0, 0, 0, 0, '0', 0, '1', '528c08', 0),
(249, 188, 0, 0, 0, 0, '0', 0, '1', '105a8f', 0),
(250, 189, 0, 0, 0, 0, '0', 0, '1', '01cd1f', 0),
(251, 190, 0, 0, 0, 0, '0', 0, '1', 'b3bc59', 0),
(252, 191, 0, 0, 0, 0, '0', 0, '1', 'db366a', 0),
(253, 192, 0, 0, 0, 0, '0', 0, '1', 'bb69ad', 0),
(254, 193, 0, 0, 0, 0, '0', 0, '1', '5f3da6', 0),
(255, 194, 0, 0, 0, 0, '0', 0, '1', 'bd2616', 0),
(256, 0, 0, 1, 0, 0, '0', 0, '1', '7061cd', 0),
(257, 195, 0, 0, 0, 0, '0', 0, '1', 'de0a7b', 0),
(258, 196, 0, 0, 0, 0, '0', 0, '1', '718a93', 0),
(259, 197, 0, 0, 0, 0, '0', 0, '1', 'ce84e7', 0),
(260, 198, 0, 0, 0, 0, '0', 0, '1', '39b49b', 0),
(261, 199, 0, 0, 0, 0, '0', 0, '1', '22347f', 0),
(262, 200, 0, 0, 0, 0, '0', 0, '1', '7f1fb5', 0),
(263, 201, 0, 0, 0, 0, '0', 0, '1', 'b8db5b', 0),
(264, 202, 0, 0, 0, 0, '0', 0, '1', '9a63eb', 0),
(265, 203, 0, 0, 0, 0, '0', 0, '1', '06dd23', 0),
(266, 204, 0, 0, 0, 0, '0', 0, '1', '9a15b1', 0),
(267, 205, 0, 0, 0, 0, '0', 0, '1', '1b5b84', 0),
(268, 206, 0, 0, 0, 0, '0', 0, '1', '2966e4', 0),
(269, 207, 0, 0, 0, 0, '0', 0, '1', '92dd43', 0),
(270, 208, 0, 0, 0, 0, '0', 0, '1', '0726bb', 0),
(271, 209, 0, 0, 0, 0, '0', 0, '1', '4cbc28', 0),
(272, 210, 0, 0, 0, 0, '0', 0, '1', '2ee9f4', 0),
(273, 211, 0, 0, 0, 0, '0', 0, '1', 'afa7b9', 0),
(274, 212, 0, 0, 0, 0, '0', 0, '1', 'bbc9be', 0),
(275, 213, 0, 0, 0, 0, '0', 0, '1', '7624d6', 0),
(276, 214, 0, 0, 0, 0, '0', 0, '1', '5448bd', 0),
(277, 216, 0, 0, 0, 0, '0', 0, '1', 'a649be', 0),
(278, 218, 0, 0, 0, 0, '0', 0, '1', '695276', 0),
(279, 219, 0, 0, 0, 0, '0', 0, '1', 'b5f9f2', 0),
(280, 220, 0, 0, 0, 0, '0', 0, '1', 'e75239', 0),
(281, 221, 0, 0, 0, 0, '0', 0, '1', '1b24dd', 0),
(282, 222, 0, 0, 0, 0, '0', 0, '1', '4ef143', 0),
(283, 223, 0, 0, 0, 0, '0', 0, '1', 'e9b67f', 0),
(284, 224, 0, 0, 0, 0, '0', 0, '1', '92a8b8', 0),
(285, 225, 0, 0, 0, 0, '0', 0, '1', 'd28787', 0),
(286, 226, 0, 0, 0, 0, '0', 0, '1', '9fca1c', 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=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `refill_status`
--

CREATE TABLE `refill_status` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `refill_apiid` int(11) DEFAULT NULL,
  `order_url` text NOT NULL,
  `creation_date` datetime DEFAULT NULL,
  `ending_date` date DEFAULT NULL,
  `service_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `refill_status` enum('Pending','Refilling','Completed','Rejected','Error') DEFAULT 'Pending',
  `order_apiid` int(11) DEFAULT 0,
  `refill_response` text DEFAULT NULL,
  `refill_where` enum('site','api') DEFAULT 'site'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_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=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `serviceapi_alert`
--

INSERT INTO `serviceapi_alert` (`id`, `service_id`, `serviceapi_alert`, `servicealert_extra`, `servicealert_date`) VALUES
(53363, 27, '#27Number of service maximum amount has been changed.', '{\"old\":\"2500\",\"new\":\"2000\"}', '2022-12-31 18:30:54'),
(53364, 74, '#74Re-activated by number service provider.', '{\"old\":\"Inactive on Provider\",\"new\":\"Active on Provider\"}', '2022-12-31 18:32:37'),
(53365, 75, '#75Re-activated by number service provider.', '{\"old\":\"Inactive on Provider\",\"new\":\"Active on Provider\"}', '2022-12-31 18:32:39'),
(53366, 76, '#76Re-activated by number service provider.', '{\"old\":\"Inactive on Provider\",\"new\":\"Active on Provider\"}', '2022-12-31 18:32:40');

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

--
-- 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` text 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` varchar(225) DEFAULT 'en',
  `description_lang` text 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
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- 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` enum('INR','USD') 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'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_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`) VALUES
(28, 'smmwiz.com', 'https://smmwiz.com/api/v2', '2dbc6bb4521bb2f61502d983ba14adb7', 1, 0, 'USD', '1', '1'),
(29, 'smmwings.com', 'https://smmwings.com/api/v2', 'Xyz', 0, 0, 'INR', '2', '2');

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

--
-- 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(10) 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,
  `ns1` varchar(191) DEFAULT NULL,
  `ns2` varchar(191) DEFAULT NULL,
  `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',
  `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',
  `csymbol` text NOT NULL,
  `inr_symbol` text NOT NULL,
  `inr_value` double NOT NULL DEFAULT 0,
  `usd_symbol` text NOT NULL,
  `inr_convert` double NOT NULL DEFAULT 0,
  `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,
  `orders` int(255) NOT NULL,
  `orders_id` 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,
  `downloaded_category_icons` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_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`, `ns1`, `ns2`, `childpanel_price`, `snow_effect`, `snow_colour`, `promotion`, `referral_commision`, `referral_payout`, `referral_status`, `childpanel_selling`, `tickets_per_user`, `name_fileds`, `skype_feilds`, `csymbol`, `inr_symbol`, `inr_value`, `usd_symbol`, `inr_convert`, `otp_login`, `auto_deactivate_payment`, `service_avg_time`, `alert_orderfail`, `alert_welcomemail`, `freebalance`, `freeamount`, `alert_newmessage`, `email_confirmation`, `resend_max`, `orders`, `orders_id`, `status`, `fundstransfer_fees`, `permissions`, `fake_order_service_enabled`, `fake_order_min`, `fake_order_max`, `panel_orders`, `downloaded_category_icons`) VALUES
(1, 'smmbiral.com', 'smmbiral', '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.\r\n\r\n', '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', 'public/images/1651cf0d2f737d7adeab84d339dbabd3.png', 'SMM Panel', 'USD', 'USD', 1, 0, '2023-06-21 17:20:57', 'public/images/7c33876368ece2e1b804a2d191df26be063e42d9.png', 'en', 'Simplify-resellerboost', 'Orange', '1', '6LegoTMjAAAAADYk7cwkkNHxFWjagJy3tb9SEIgw', '6LegoTMjAAAAAO3G1lX0hbGgmrSYc7cVL3AdwN_I', '', '', '1', '2', '1', '2', 82.750063, 0, '', '', '', '587', 'tls', '2', '2', '2', '2', '2', '2', 'bizimsms', '', '', '', '1', '', '', '2', '2', '2', '2', 'asc', 1000, 2500, 10000, 15000, 'ns1.smmbiral.com', 'ns2.smmbiral.com', 10, '2', '', '2', 10, 10, '2', '2', 9999999999, '2', '2', '$', '₹', 86.5, '$', 0.01, '0', '1', '1', '2', '2', '1', 0, '2', '2', 2, 191530, 0, '0', '5', '{\"pages\":{\"clients\":{\"name\":\"Clients\",\"value\":\"clients\"},\"Admin\":{\"name\":\"Admin\",\"value\":\"admin_access\"},\"orders\":{\"name\":\"Orders\",\"value\":\"orders\"},\"subscriptions\":{\"name\":\"Subscriptions\",\"value\":\"subscriptions\"},\"dripfeed\":{\"name\":\"Dripfeed\",\"value\":\"dripfeed\"},\"services\":{\"name\":\"Services\",\"value\":\"services\"},\"payments\":{\"name\":\"Payments\",\"value\":\"payments\"},\"support\":{\"name\":\"Support\",\"value\":\"support\"},\"broadcast\":{\"name\":\"Broadcast\",\"value\":\"broadcast\"},\"tasks\":{\"name\":\"Tasks\",\"value\":\"tasks\"},\"statistics\":{\"name\":\"Statistics\",\"value\":\"statistics\"},\"referral\":{\"name\":\"Referral\",\"value\":\"referral\"},\"child\":{\"name\":\"Child\",\"value\":\"child\"},\"user_logs\":{\"name\":\"User Logs\",\"value\":\"user_logs\"},\"admin_logs\":{\"name\":\"Admin Logs\",\"value\":\"admin_logs\"},\"service_logs\":{\"name\":\"Service Logs\",\"value\":\"service_logs\"}},\"appearance\":{\"appearance\":{\"name\":\"Appearance\",\"value\":\"appearance\"},\"pages\":{\"name\":\"Pages\",\"value\":\"pages\"},\"annoucements\":{\"name\":\"Announcements\",\"value\":\"announcements\"},\"languages\":{\"name\":\"Languages\",\"value\":\"languages\"},\"themes\":{\"name\":\"Themes\",\"value\":\"themes\"},\"blogs\":{\"name\":\"Blogs\",\"value\":\"blogs\"},\"menu\":{\"name\":\"Menu\",\"value\":\"menus\"},\"files\":{\"name\":\"Files\",\"value\":\"files\"}},\"settings\":{\"general\":{\"name\":\"General\",\"value\":\"general\"},\"providers\":{\"name\":\"Providers\",\"value\":\"providers\"},\"methods\":{\"name\":\"Payment Methods\",\"value\":\"methods\"},\"modules\":{\"name\":\"Modules\",\"value\":\"modules\"},\"integrations\":{\"name\":\"Integrations\",\"value\":\"integrations\"},\"bonuses\":{\"name\":\"Bonuses\",\"value\":\"bonuses\"},\"coupons\":{\"name\":\"Coupons\",\"value\":\"coupons\"},\"notifications\":{\"name\":\"Notifications\",\"value\":\"notifications\"},\"currency\":{\"name\":\"Currency\",\"value\":\"currency\"},\"subjects\":{\"name\":\"Tickets Subjects\",\"value\":\"subjects\"}}}', 0, 10, 100, 0, 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=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `sync_logs` (`id`, `service_id`, `action`, `date`, `description`, `api_id`) VALUES
(1, 88, 'SERVICE REMOVED BY THE SELLER', '2023-01-10 16:40:14', 'Service marked <b>INACTIVE</b>', 20),
(2, 89, 'SERVICE REMOVED BY THE SELLER', '2023-01-10 16:40:14', 'Service marked <b>INACTIVE</b>', 20),
(3, 95, 'SERVICE REMOVED BY THE SELLER', '2023-01-10 16:40:14', 'Service marked <b>INACTIVE</b>', 20),
(4, 88, 'SERVICE PRICE UPDATED', '2023-01-10 18:55:08', 'Service rate changed from <b>₹ 0.363</b> to <b>₹ 2.531</b>', 20),
(5, 88, 'SERVICE ADDED BY THE SELLER', '2023-01-10 18:55:08', 'Service marked <b>ACTIVE</b>', 20),
(6, 89, 'SERVICE PRICE UPDATED', '2023-01-10 18:55:08', 'Service rate changed from <b>₹ 0.363</b> to <b>₹ 2.621</b>', 20),
(7, 89, 'SERVICE MAXIMUM QUANTITY UPDATED', '2023-01-10 18:55:08', 'Service maximum quantity changed from <b>100000</b> to <b>100000000</b>', 20),
(8, 89, 'SERVICE ADDED BY THE SELLER', '2023-01-10 18:55:08', 'Service marked <b>ACTIVE</b>', 20),
(9, 95, 'SERVICE PRICE UPDATED', '2023-01-10 18:55:08', 'Service rate changed from <b>₹ 0.8168</b> to <b>₹ 6.237</b>', 20),
(10, 95, 'SERVICE MAXIMUM QUANTITY UPDATED', '2023-01-10 18:55:08', 'Service maximum quantity changed from <b>100000</b> to <b>100000000</b>', 20),
(11, 95, 'SERVICE ADDED BY THE SELLER', '2023-01-10 18:55:08', 'Service marked <b>ACTIVE</b>', 20),
(12, 73, 'SERVICE PRICE UPDATED', '2023-01-10 21:55:07', 'Service rate changed from <b>₹ 30.004</b> to <b>₹ 29.559</b>', 20),
(13, 88, 'SERVICE ADDED BY THE SELLER', '2023-01-10 23:30:35', 'Service marked <b>ACTIVE</b>', 20),
(14, 79, 'SERVICE PRICE UPDATED', '2023-01-11 01:45:26', 'Service rate changed from <b>₹ 61.827</b> to <b>₹ 60.655</b>', 20),
(15, 69, 'SERVICE PRICE UPDATED', '2023-01-11 12:35:12', 'Service rate changed from <b>₹ 0.2728</b> to <b>₹ 0.3597</b>', 20),
(16, 85, 'SERVICE PRICE UPDATED', '2023-01-11 12:35:12', 'Service rate changed from <b>₹ 0.2728</b> to <b>₹ 0.3597</b>', 20),
(17, 125, 'SERVICE PRICE UPDATED', '2023-01-11 15:20:09', 'Service rate changed from <b>₹ 26.378</b> to <b>₹ 29.689</b>', 17),
(18, 1, 'SERVICE PRICE UPDATED', '2023-01-11 15:25:03', 'Service rate changed from <b>₹ 22.154</b> to <b>₹ 21.384</b>', 8),
(19, 1, 'SERVICE MINIMUM QUANTITY UPDATED', '2023-01-11 15:25:03', 'Service minimum quantity changed from <b>50</b> to <b>20</b>', 8),
(20, 1, 'SERVICE MAXIMUM QUANTITY UPDATED', '2023-01-11 15:25:03', 'Service maximum quantity changed from <b>5000</b> to <b>300000</b>', 8),
(21, 98, 'SERVICE PRICE UPDATED', '2023-01-11 17:20:15', 'Service rate changed from <b>₹ 23.061</b> to <b>₹ 25.421</b>', 21),
(22, 98, 'SERVICE MAXIMUM QUANTITY UPDATED', '2023-01-11 17:20:15', 'Service maximum quantity changed from <b>250000</b> to <b>1000000</b>', 21),
(23, 99, 'SERVICE PRICE UPDATED', '2023-01-11 17:20:15', 'Service rate changed from <b>₹ 25.954</b> to <b>₹ 28.608</b>', 21),
(24, 101, 'SERVICE PRICE UPDATED', '2023-01-11 17:20:15', 'Service rate changed from <b>₹ 29.178</b> to <b>₹ 32.205</b>', 21),
(25, 1, 'SERVICE PRICE UPDATED', '2023-01-11 21:10:09', 'Service rate changed from <b>₹ 21.384</b> to <b>₹ 21.395</b>', 8),
(26, 123, 'SERVICE PRICE UPDATED', '2023-01-12 01:20:08', 'Service rate changed from <b>₹ 2.31</b> to <b>₹ 2.068</b>', 17),
(27, 123, 'SERVICE MINIMUM QUANTITY UPDATED', '2023-01-12 01:20:08', 'Service minimum quantity changed from <b>50</b> to <b>10</b>', 17),
(28, 123, 'SERVICE MAXIMUM QUANTITY UPDATED', '2023-01-12 01:20:08', 'Service maximum quantity changed from <b>10000</b> to <b>100000</b>', 17),
(29, 9, 'SERVICE PRICE UPDATED', '2023-01-12 02:15:03', 'Service rate changed from <b>₹ 22.264</b> to <b>₹ 23.705</b>', 8),
(30, 16, 'SERVICE PRICE UPDATED', '2023-01-12 02:15:03', 'Service rate changed from <b>₹ 20.526</b> to <b>₹ 24.244</b>', 8),
(31, 70, 'SERVICE PRICE UPDATED', '2023-01-12 18:00:14', 'Service rate changed from <b>₹ 23.913</b> to <b>₹ 24.695</b>', 20),
(32, 10, 'SERVICE PRICE UPDATED', '2023-01-12 19:25:03', 'Service rate changed from <b>₹ 39.556</b> to <b>₹ 39.061</b>', 8),
(33, 18, 'SERVICE PRICE UPDATED', '2023-01-12 19:25:03', 'Service rate changed from <b>₹ 39.897</b> to <b>₹ 39.391</b>', 8),
(34, 2, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 14.839</b> to <b>₹ 14.641</b>', 8),
(35, 3, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 30.184</b> to <b>₹ 29.843</b>', 8),
(36, 4, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 19.921</b> to <b>₹ 19.657</b>', 8),
(37, 5, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 19.778</b> to <b>₹ 19.558</b>', 8),
(38, 6, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 20.295</b> to <b>₹ 20.064</b>', 8),
(39, 7, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 20.823</b> to <b>₹ 20.581</b>', 8),
(40, 8, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 35.387</b> to <b>₹ 34.991</b>', 8),
(41, 9, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 23.705</b> to <b>₹ 23.584</b>', 8),
(42, 11, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 38.016</b> to <b>₹ 37.587</b>', 8),
(43, 12, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 28.083</b> to <b>₹ 27.72</b>', 8),
(44, 13, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 32.439</b> to <b>₹ 32.021</b>', 8),
(45, 14, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 30.866</b> to <b>₹ 30.47</b>', 8),
(46, 15, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 36.003</b> to <b>₹ 35.596</b>', 8),
(47, 16, 'SERVICE PRICE UPDATED', '2023-01-12 19:30:09', 'Service rate changed from <b>₹ 24.244</b> to <b>₹ 24.123</b>', 8),
(48, 4, 'SERVICE PRICE UPDATED', '2023-01-12 19:55:04', 'Service rate changed from <b>₹ 19.657</b> to <b>₹ 21.659</b>', 8),
(49, 7, 'SERVICE PRICE UPDATED', '2023-01-12 19:55:04', 'Service rate changed from <b>₹ 20.581</b> to <b>₹ 22.649</b>', 8),
(50, 9, 'SERVICE PRICE UPDATED', '2023-01-12 19:55:04', 'Service rate changed from <b>₹ 23.584</b> to <b>₹ 26.851</b>', 8),
(51, 16, 'SERVICE PRICE UPDATED', '2023-01-12 19:55:04', 'Service rate changed from <b>₹ 24.123</b> to <b>₹ 27.06</b>', 8),
(52, 120, 'SERVICE PRICE UPDATED', '2023-01-12 20:35:08', 'Service rate changed from <b>₹ 25.685</b> to <b>₹ 29.04</b>', 17),
(53, 133, 'SERVICE PRICE UPDATED', '2023-01-13 21:45:07', 'Service rate changed from <b>₹ 23.265</b> to <b>₹ 29.073</b>', 17);

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

--
-- 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(255) 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(10) DEFAULT NULL,
  `refill_orderid` varchar(225) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_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',
  `site_theme_alt` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `themes` (`id`, `theme_name`, `theme_dirname`, `theme_extras`, `last_modified`, `newpage`, `colour`, `site_theme_alt`) VALUES
(309, 'Simplify-resellerboost', 'Simplify-resellerboost', '{\"stylesheets\":[\"public/pro/panel/1607327652/bootstrap.css\",\"public/pro/pro/panel/style.css\",\"https:\\/\\/stackpath.bootstrapcdn.com\\/font-awesome\\/4.7.0\\/css\\/font-awesome.min.css\"],\"scripts\":[\"public/pro/script.js\",\"public/ajax.js\"]}', '2022-11-16 09:28:01', '{% include \'header.twig\' %}\r\n\r\n	<br><br><br>\r\n\r\n	\r\n\r\n	<div class=\"container-fluid container-fluid-spacious\">\r\n\r\n		<div class=\"row\">\r\n\r\n			<div class=\"col-md-12\">\r\n\r\n			{% if contentText %}\r\n\r\n{{ contentText }}\r\n\r\n{% endif %}\r\n\r\n				{% if contentText2 %}\r\n\r\n{{ contentText2 }}\r\n\r\n{% endif %}\r\n\r\n				\r\n\r\n			</div>\r\n\r\n		</div>\r\n\r\n	</div>\r\n\r\n   \r\n\r\n      \r\n\r\n        \r\n\r\n   ', '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=utf8 COLLATE=utf8_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=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ticket_reply`
--

INSERT INTO `ticket_reply` (`id`, `ticket_id`, `client_id`, `time`, `support`, `message`, `readed`) VALUES
(1, 1, 0, '2022-04-24 18:26:55', '1', 'dfdsfsdfsdfsdf', '1'),
(2, 1, 0, '2022-04-24 20:29:18', '2', 'يبسيبسيبيب', '1'),
(3, 1, 0, '2022-04-24 20:29:29', '1', 'سيبسيبسيب', '1'),
(4, 2, 0, '2022-04-26 01:48:34', '1', 'سيبسيبسيبسيبسيب', '1'),
(5, 2, 0, '2022-04-26 01:51:04', '2', 'asdasdasd', '1'),
(6, 2, 0, '2022-04-26 03:30:50', '1', 'dfgdfgdfgdfg', '1'),
(7, 2, 0, '2022-04-26 03:30:55', '1', 'fgdfgdfgdfg', '1'),
(8, 2, 0, '2022-04-26 03:31:32', '1', 'dfgdfgdfg', '1'),
(9, 2, 0, '2022-04-26 03:32:38', '1', 'fgdfgdfg', '1'),
(10, 3, 0, '2022-04-26 14:49:38', '1', 'اريد طريقة دفع', '1'),
(11, 3, 0, '2022-04-27 16:23:42', '2', 'hi gfgfgfgfg', '1'),
(12, 4, 0, '2022-04-27 17:50:25', '1', 'asdasdasdasdasdasd', '1'),
(13, 4, 0, '2022-04-27 17:50:39', '2', 'asdasdasdasd', '1'),
(14, 4, 0, '2022-04-27 17:56:06', '1', 'sdfsdfsdfsdf', '1'),
(15, 4, 0, '2022-04-27 17:56:17', '2', 'asdasdasdasd', '1'),
(16, 5, 0, '2022-04-27 18:33:19', '1', 'adasdasdasdsd', '1'),
(17, 5, 0, '2022-04-27 18:33:29', '2', 'asdasdasd', '1'),
(18, 5, 0, '2022-04-27 18:34:37', '2', 'asdasdasdasdasd', '1'),
(19, 5, 0, '2022-04-27 18:35:38', '1', 'sdfsdfsdfsdf', '1'),
(20, 5, 0, '2022-04-27 18:35:57', '2', 'sadasdasdasd', '1'),
(21, 6, 0, '2022-04-28 14:47:13', '1', 'hi', '1'),
(22, 6, 0, '2022-04-28 14:47:13', '2', 'You will be answered within minutes', '1'),
(23, 7, 0, '2022-04-28 16:41:52', '1', 'vxcvxcvxcv', '1'),
(24, 6, 0, '2022-04-28 16:45:04', '1', 'asdasdsadsd', '1'),
(25, 8, 0, '2022-05-06 16:04:16', '1', 'hi\n\n', '1'),
(26, 8, 0, '2022-05-06 16:07:57', '2', 'hi2', '1'),
(27, 8, 0, '2022-05-06 16:47:52', '1', 'dasdasd', '1'),
(28, 8, 0, '2022-05-06 16:48:50', '1', 'sdfsdfsdf', '1'),
(29, 8, 0, '2022-05-06 17:06:36', '1', 'dfsdfsdf', '1'),
(30, 8, 0, '2022-05-06 17:06:45', '1', 'sdfsdfsdf', '1'),
(31, 8, 0, '2022-05-06 17:08:12', '1', 'zdfsfsdf', '1'),
(32, 8, 0, '2022-05-06 17:08:14', '1', 'sdfsdfs', '1'),
(33, 8, 0, '2022-05-06 17:08:16', '1', 'sdfsdfsdf', '1'),
(34, 8, 0, '2022-05-06 17:08:18', '1', 'sdfdsf', '1'),
(35, 8, 0, '2022-05-06 17:08:20', '1', 'sdfsdf', '1'),
(36, 8, 0, '2022-05-06 17:08:22', '1', 'sdfsdf', '1'),
(37, 8, 0, '2022-05-06 17:08:24', '1', 'sdfsdf', '1'),
(38, 8, 0, '2022-05-06 17:08:26', '1', 'sdfsdf', '1'),
(39, 8, 0, '2022-05-06 17:08:29', '1', 'sdfsdf', '1'),
(40, 8, 0, '2022-05-06 17:08:32', '1', 'sdfsdf', '1'),
(41, 8, 0, '2022-05-06 20:28:10', '1', 'fdsfsdf', '1'),
(42, 9, 0, '2022-11-15 22:59:45', '1', 'Hi, please forward to admin :)\n\n\n\nWe saw your SMM panel and wanted to offer your services directly from the provider.\n\n\n\nEXCLUSIVE Instagram Services:\n\n\n\n? Instagram Mass DM  $2.2 per 1,000\n\n? Instagram Mass Mentions $1.4 per 1,000\n\n? Instagram Mass Comments $1.4 per 1,000\n\n? Instagram Mass Stories Mentions $1.4 per 1,000\n\n\n\nContact us for more details:\n\nTelegram: t.me/bulk_grow\n\nWebsite: bulkgrow.top', '1'),
(43, 9, 0, '2022-11-15 22:59:45', '2', 'You will be answered within minutes', '1'),
(44, 9, 0, '2022-11-15 23:13:25', '2', 'kon ho ', '1'),
(45, 10, 0, '2022-11-20 10:23:26', '1', 'Hi', '1'),
(46, 11, 0, '2022-11-20 10:23:26', '1', 'Hi', '1'),
(47, 10, 0, '2022-11-20 17:52:26', '2', 'hello', '1'),
(48, 11, 0, '2022-11-20 17:52:49', '2', '?', '1'),
(49, 12, 0, '2022-11-22 14:32:02', '1', 'Hey there i am script developer can u share this script with our team', '1'),
(50, 12, 0, '2022-11-22 20:56:35', '2', 'no brother ', '1'),
(51, 13, 0, '2022-11-24 16:16:45', '1', 'Ggbb', '1'),
(52, 13, 0, '2022-11-24 19:56:52', '2', 'Kya hua', '1'),
(53, 14, 0, '2022-11-24 20:27:05', '1', 'hello', '1'),
(54, 14, 0, '2022-11-24 20:27:05', '2', 'You will be answered within minutes', '1'),
(55, 15, 0, '2022-11-24 20:27:14', '1', 'Hkhkgkfk', '1'),
(56, 16, 0, '2022-11-24 20:28:21', '1', 'Hi', '1'),
(57, 16, 0, '2022-11-24 20:28:28', '1', 'Hh', '1'),
(58, 17, 0, '2022-11-24 22:14:54', '1', 'I want to buy this script \n\nMy WhatsApp no. 9430599406', '1'),
(59, 17, 0, '2022-11-25 17:44:45', '2', 'only rental deta hu', '1'),
(60, 18, 0, '2022-11-25 18:00:54', '1', 'Ye script chaahiye brother batao ', '1'),
(61, 18, 0, '2022-11-25 18:00:54', '2', 'You will be answered within minutes', '1'),
(62, 18, 0, '2022-11-25 18:28:31', '2', 'Rental deta hu only ', '1'),
(63, 15, 0, '2022-11-25 18:28:51', '2', 'hello', '1'),
(64, 19, 0, '2022-11-28 01:34:01', '1', 'Bensnsnw', '1'),
(65, 19, 0, '2022-11-28 01:34:05', '1', 'Kememememem', '1'),
(66, 19, 0, '2022-11-28 01:34:09', '1', 'Kekekekmdnzmw f', '1'),
(67, 19, 0, '2022-11-28 09:29:35', '2', 'kya hua', '1'),
(68, 20, 0, '2022-12-04 01:48:17', '1', 'I want to contact the admin', '1'),
(69, 20, 0, '2022-12-04 01:48:17', '2', 'You will be answered within minutes', '1'),
(70, 20, 0, '2022-12-04 11:15:28', '2', 'my WhatsApp no +919992226568', '1'),
(71, 21, 0, '2022-12-08 22:48:51', '1', 'Rental? Free??', '1'),
(72, 21, 0, '2022-12-08 22:48:51', '2', 'You will be answered within minutes', '1'),
(73, 21, 0, '2022-12-09 00:01:28', '2', 'no paid rental 400Rs per month ', '1'),
(74, 22, 0, '2022-12-10 04:50:19', '1', 'just demo panel or panel where you actually sell things?', '1'),
(75, 22, 0, '2022-12-10 04:50:19', '2', 'You will be answered within minutes', '1'),
(76, 23, 0, '2022-12-15 15:04:23', '1', 'Hello sir', '1'),
(77, 24, 0, '2022-12-15 15:04:35', '1', 'Hii', '1'),
(78, 25, 0, '2022-12-15 15:31:09', '1', 'Hii', '1'),
(79, 25, 0, '2022-12-15 15:41:20', '2', 'hello', '1'),
(80, 23, 0, '2022-12-15 15:41:39', '2', 'hi sir', '1'),
(81, 26, 0, '2022-12-17 20:49:06', '1', 'Hi', '1'),
(82, 26, 0, '2022-12-17 20:49:10', '1', 'Hi', '1'),
(83, 27, 0, '2022-12-17 20:50:48', '1', 'Hi', '1'),
(84, 27, 0, '2022-12-17 20:50:53', '1', 'Hi', '1'),
(85, 28, 0, '2022-12-17 21:28:39', '1', 'Hii,\n\nI want to use your child panel but i want a whatsapp support please massage me 8950712064', '1'),
(86, 28, 0, '2022-12-17 21:28:39', '2', 'You will be answered within minutes', '1'),
(87, 29, 0, '2022-12-18 18:44:32', '1', 'Hi ,i want to buy child pannel.', '1'),
(88, 29, 0, '2022-12-18 18:44:32', '2', 'You will be answered within minutes', '1'),
(89, 30, 0, '2022-12-18 20:57:35', '1', 'Hi', '1'),
(90, 30, 0, '2022-12-18 20:57:38', '1', 'Hi', '1'),
(91, 31, 0, '2022-12-18 20:57:48', '1', 'Hi', '1'),
(92, 31, 0, '2022-12-18 20:57:52', '1', 'Gh', '1'),
(93, 31, 0, '2022-12-18 23:30:08', '1', 'Hi', '1'),
(94, 32, 0, '2022-12-18 23:32:44', '1', 'hello', '1'),
(95, 32, 0, '2022-12-18 23:32:47', '1', 'hi', '1'),
(96, 32, 0, '2022-12-18 23:33:18', '2', 'bolo beta', '1'),
(97, 30, 0, '2022-12-19 17:37:26', '2', 'hello baby', '1'),
(98, 30, 0, '2022-12-19 21:30:48', '1', 'Hi', '1'),
(99, 30, 0, '2022-12-19 21:32:16', '2', 'Jrlo', '1'),
(100, 31, 0, '2022-12-20 10:55:10', '2', 'Himk', '1'),
(101, 31, 0, '2022-12-20 10:55:22', '1', 'Hii', '1'),
(102, 31, 0, '2022-12-20 10:56:30', '2', 'Hrloo', '1'),
(103, 33, 0, '2023-06-20 16:45:02', '1', ' We are distinguished by real services\r\n\r\nwe are the provider cancel speed any time\r\n\r\nFor Tik Tok, if you can bring in 100 requests per day, you choose the right price for you\r\n\r\n6848-TikTok Verified Comments | 1 Comment With Blue Tick 0.30$\r\n\r\n6860-TikTok Verified Comments | 1 custom Comment With Blue Tick 0.35$\r\n\r\n6849-TikTok Verified Comments | 2 Comment With Blue Tick 0.60$\r\n\r\n6850-TikTok Verified Comments | 2 custom Comment With Blue Tick 0.65$\r\n\r\n6853-TikTok Verified Comments | 1 Comment With Blue Tick ✅ [Arab Influencer 🇦🇪] 0.79$\r\n\r\n6854-TikTok Verified Comments | 2 Comment With Blue Tick ✅ [Arab Influencer 🇦🇪] 1.53$\r\n\r\n\r\n6338-Instagram Verified Comment | 1 Comment ( Blue Tick ) 0.15$\r\n\r\n6339-Instagram Verified Comment | 2 Comment ( Blue Tick ) 0.58$\r\n\r\n6340-Instagram Verified Comment | 3 Comments ( Blue Tick ) 0.87$\r\n\r\n7063-Instagram Verified Comment | 4 Comments ( Blue Tick ) 1.17$\r\n\r\n7064-Instagram Verified Comment | 5 Comments ( Blue Tick ) 1.45$\r\n\r\n6829-Instagram Verified Comment | 1 Comment + 1 like ( Arabic account ) 0.80$\r\n\r\n7086-Instagram Verified Comment | 1 Comment ( Brazilian account ) 0.80$\r\n\r\n7087-Instagram Verified Comment | 1 Comment ( French account ) 0.80$\r\n\r\n7088-Instagram Verified Comment | 1 Comment ( Italian account ) 0.80$\r\n\r\n7553-Instagram Verified Comment | 1 Comment ( Indian account )\r\n\r\n7526-Instagram Verified Comment 250$\r\n\r\n\r\n\r\n7506-Instagram Verified likes | 1 likes ( Blue Tick )\r\n\r\n7507-Instagram Verified likes | 2 likes ( Blue Tick )\r\n\r\n7508-Instagram Verified likes | 3 likes ( Blue Tick )\r\n\r\n7509-Instagram Verified likes | 4 likes ( Blue Tick )\r\n\r\n7510-Instagram Verified likes | 1 likes ( Brazilian account )\r\n\r\n7511-Instagram Verified likes | 1 likes ( French account )\r\n\r\n7512-Instagram Verified likes | 1 likes ( Italian account )\r\n\r\n7554-Instagram Verified likes | 1 likes ( Indian account )\r\n\r\n7525-Instagram Verified likes 250$\r\n\r\n Payoneer\r\n Payeer\r\n Perfect Money (USD)\r\n USDT | BTC | BTC Cash | ETH | LTC\r\n Credit Card  | Visa| Master |American |Express\r\n\r\n\r\nhttps://markenetspanel.com\r\nWhatsapp: ⁦+1 (208) 715-5047⁩\r\nSkype: mof12288', '1'),
(104, 33, 0, '2023-06-20 16:45:02', '2', 'You will be answered within minutes', '1'),
(105, 34, 0, '2023-06-21 12:11:20', '1', 'Hello', '1'),
(106, 35, 0, '2023-06-21 17:00:44', '1', 'BEST OWN TOP SELLING SERVICES WITH GUARANTEE⭐️\r\n\r\nPRICE FOR RESELLER:\r\n\r\nYOUTUBE STABLE VIEWS\r\n\r\nID497 ⭐️🔥 YouTube Views | Traffic source: External + Direct | Start 0-10 Minutes | Speed ~800-1500 per Day | + Bonus Likes | ✅ Lifetime Guarantee – 0.38\r\n\r\nID490 ⭐️ YouTube Views | Traffic source: Mixed | Start 0-20 Min | Speed ~2000-3000 per Day | Non Drop |✅ Lifetime Guarantee – 0.58\r\n\r\nID488 ⭐️⚡️ YouTube Views (best server after update) | Traffic source: External | Start 0-10 Minutes | Speed ~4000-6000 per Day | Non Drop |✅ Lifetime Guarantee - 0.86\r\n\r\nID486 ⭐️⚡️ YouTube Views (don&amp;#39;t work on Russian Videos) | Traffic source: Suggested | Geo: Almost from Russia,CIS | Instant start | Speed ~20K-50K per Day | Non Drop | ✅ Lifetime Guarantee – 0.89\r\n\r\nID515 ⭐️⚡️ YouTube Views | Traffic source: External | Start 0-10 Minutes | Speed ~10000 per Day | Non Drop |✅ Lifetime Guarantee – 1.20\r\n\r\nID516 ⭐️⚡️ YouTube Views | Traffic source: External | Geo: Almost from Russia,CIS | Start 2-10 Minutes | Speed ~10K-20K per Day | Non Drop | ✅ 90 Days Guarantee with Refill Button and Lifetime Manual Guarantee – 1.15\r\n\r\nTELEGRAM STABLE SERVICES\r\n\r\nID493 ⭐️⚡️ Telegram Followers (Work for Public &amp; Private Link) | Geo: Worldwide | Start 5-30 Min | Speed ~20K-30K per Day | Low Drop after 30 Day is possible | Cancel Button: Available |✅ 30 \r\nDays Guarantee – 0.63\r\n\r\nID500 ⭐️⚡️ Telegram Followers (Work for Public &amp; Private Link, without moderation) | Geo: Worldwide | Start 5-30 Min | Speed ~20K-30K per Day | Low Drop after 30 Day is possible | Cancel Button: Available |✅ 30 Days Guarantee – 0.66\r\n\r\nID499 ⭐️⚡️ Telegram Followers | Geo: Worlwide | Start 0-20 Min | Speed ~30K-40K per Day | Low Drops after 30 days are possible | Cancel Button: Disabled | ✅ 30 Days Guarantee – 0.67\r\n\r\nID496 ⭐️⚡️ Telegram Followers (Work for Public &amp; Private Link) | Geo: Worldwide | Start 0-15 Min | Speed ~20K-40K per Day | Low Drop after 40 Days is possible | Cancel Button: Available |✅ 40 Days Guarantee – 0.82\r\n\r\nID513 ⭐️⚡️ Telegram Followers (Work for Public &amp; Private Links, without moderation) | Geo: Worldwide | Start 0-10 Min | Speed ~50K-60K per Day | Non Drop ~40 Days | Cancel Button: Available | ✅ 30 Days Guarantee - 0.82\r\n\r\nID487 ⭐️ Telegram Followers | Geo: Worldwide | Start 0-20 Min | Speed ~5K per Day | Non Drop | Cancel Button: Disabled | ✅ 30 Days Guarantee – 0.82\r\n\r\nID369 ⭐️⚡️ Telegram Followers | Geo: Mostly Indian | Start 0-30 Min | Speed ~30K-40K per Day | Non Drop | Cancel Button: Available | ✅ 30 Days Guarantee – 0.88\r\n\r\nID498 ⭐️⚡️ Telegram Followers (Work for Public &amp; Private Links) | Geo: Worldwide | Start 0-20 Min | Speed ~50K per Day | Non Drop | Cancel Button: Disabled | ✅ 30 Days Guarantee – 1.00\r\n\r\nYOUTUBE SUBS\r\n\r\nID442 ⭐️🔥 Cheapest YouTube Subscribers | Speed ~100-300 per Day | Non Drop or Low Drop | ✅ 30 Days Guarantee - 3.52\r\n\r\nID149 ⭐️⚡️ YouTube Subscribers | Speed ~2000-5000 per Day | Non Drop | ✅ 30 Days Guarantee – 6.6\r\n\r\nInstagram\r\n\r\nID494 ⭐️🔥⚡️ Instagram Likes (Cheapest Price) | Profiles are with avatars | Geo: Worldwide | Start 0-15 Min | Speed ~10K-20K per Day | Non Drop or Low Drop | Cancel Button: Available | ✅ 30 Days Guarantee – 0.029\r\n\r\nID517 ⭐️⚡️ Instagram Followers | Geo: Worldwide | Start 0-10 Min | All profiles are with avatars and posts | High Speed ~20K per Day | Non Drop | Cancel Button: Available | ✅ 365 Days Guarantee with Refill Button – 0.30\r\n\r\nTIKTOK\r\n\r\nID469 ⭐️🔥⚡️ TikTok Followers | All profiles are with avatars and videos | Geo: Worldwide | Instant Start | Speed ~2K-4K per Day | Non Drop | Cancel Button: Disabled | ✅ 30 Days Guarantee – 1.61\r\n\r\n\r\nID168 ⭐️🔥⚡️ TikTok Followers | All profiles are with avatars and videos | Geo: Worldwide | Instant Start | Speed ~3K-8K per Day | Non Drop | Cancel Button: Disabled | ✅ 30 Days Guarantee – 2.25\r\n\r\nhttps://prosmm-store.com\r\n\r\nContacts:\r\n\r\nTelegram: https://t.me/ProstyleLogo\r\nEmail: prosmm-store@mail.ru\r\n\r\nCooperation:', '1'),
(107, 35, 0, '2023-06-21 17:00:44', '2', 'You will be answered within minutes', '1'),
(108, 36, 0, '2023-06-22 13:44:17', '1', 'BEST OWN TOP SELLING SERVICES WITH GUARANTEE⭐️\r\n\r\nPRICE FOR RESELLER:\r\n\r\nYOUTUBE STABLE VIEWS\r\n\r\nID497 ⭐️🔥 YouTube Views | Traffic source: External + Direct | Start 0-10 Minutes | Speed ~800-1500 per Day | + Bonus Likes | ✅ Lifetime Guarantee – 0.38\r\n\r\nID490 ⭐️ YouTube Views | Traffic source: Mixed | Start 0-20 Min | Speed ~2000-3000 per Day | Non Drop |✅ Lifetime Guarantee – 0.58\r\n\r\nID488 ⭐️⚡️ YouTube Views (best server after update) | Traffic source: External | Start 0-10 Minutes | Speed ~4000-6000 per Day | Non Drop |✅ Lifetime Guarantee - 0.86\r\n\r\nID486 ⭐️⚡️ YouTube Views (don&amp;#39;t work on Russian Videos) | Traffic source: Suggested | Geo: Almost from Russia,CIS | Instant start | Speed ~20K-50K per Day | Non Drop | ✅ Lifetime Guarantee – 0.89\r\n\r\nID515 ⭐️⚡️ YouTube Views | Traffic source: External | Start 0-10 Minutes | Speed ~10000 per Day | Non Drop |✅ Lifetime Guarantee – 1.20\r\n\r\nID516 ⭐️⚡️ YouTube Views | Traffic source: External | Geo: Almost from Russia,CIS | Start 2-10 Minutes | Speed ~10K-20K per Day | Non Drop | ✅ 90 Days Guarantee with Refill Button and Lifetime Manual Guarantee – 1.15', '1'),
(113, 38, 0, '2023-06-25 16:30:32', '1', 'I am a real provider of Tiktok. I want to get rid of intermediary APIs. It will be good for me to give direct service to everyone and give cheap. My Tiktok services are really good,\r\n\r\nI can send 100k for free. to all the links you want, my site is from 2017 i am a real provider.\r\n\r\n☎ Contact&amp;nbsp;me&amp;nbsp;:\r\n☎whatsapp: https://api.whatsapp.com/send?phone=905412016361\r\n☎telegram: https://t.me/sametkabalak\r\n☎skype: live:.cid.f10bd140ddc9842f', '1'),
(114, 38, 0, '2023-06-25 16:30:32', '2', 'You will be answered within minutes', '1'),
(111, 37, 0, '2023-06-24 13:14:51', '1', 'Ytreseller.com | World Cheapest Youtube Provider\r\n\r\nYoutube Watch Time Working After Update\r\n\r\n171 - Youtube Watch Time | 15 Minutes Video | Speed 500 H/Day | 30 Days Refill - 1.10$\r\n\r\n172 - Youtube Watch Time | 30 Minutes Video | Speed 500 H/Day | 30 Days Refill - 2.20$\r\n\r\n174 - Youtube Watch Time | 45 Minutes Video | Speed: 500 H/Day | 30 Days Refill - 3.30$\r\n\r\n175 - Youtube Watch Time | 60 Minutes Video | Speed: 500 H/Day | 30 Days Refill - 4.40$\r\n\r\n150 - Youtube Subscribers | Max 10K | Speed 200-300/Day | 30 Days Refill - 3$\r\n\r\n67 - Youtube Subscribe | Max 50K | Speed 1000-2000/Day | 30 Days Refill | Start : 0-1 Hour - 3.50$\r\n\r\n135 - Youtube View + 2-5% Likes | Max 1M | Speed 2K/Day | 30 Days Refill | Cancel Button ⛔ - 0.55$\r\n\r\n136 - Youtube Views | Max 1M | Speed 5-10K/Day | Lifetime Guarantee | Cancel Button ⛔ - 0.70$\r\n\r\n137 - Youtube Views | Max 1M | Speed 60K/Day | Lifetime Guarantee | Cancel Button ⛔ - 0.85$\r\n\r\n138 - Youtube Shorts + 2-5% Likes | Max 10M | Speed 10K/Day | Lifetime Guarantee | Cancel Button ⛔ - 0.70$\r\n\r\nWebsite : https://ytreseller.com\r\n\r\nWhat&amp;#39;sapp : wa.me/+19708411248\r\n\r\nSkype : live:.cid.cc97f1b5e7c7962b', '1');

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

--
-- 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=utf8 COLLATE=utf8_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'),
(7, 'Querrey', '', '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=utf8 COLLATE=utf8_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, 5, '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=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `updates`
--

INSERT INTO `updates` (`u_id`, `service_id`, `action`, `date`, `description`) VALUES
(1, 95, 'Activated', '2023-01-10 23:52:33', ''),
(2, 89, 'Activated', '2023-01-10 23:52:48', ''),
(3, 491, 'Refill Deactivated', '2023-06-10 07:42:32', 'Refill Button has been Deativated'),
(4, 491, 'Cancel Deactivated', '2023-06-10 07:42:32', 'Cancel Button has been Deativated'),
(5, 491, 'Price Increased', '2023-06-10 07:42:32', 'Price changed from  to 14.4612'),
(6, 491, 'Minimum Increased', '2023-06-10 07:42:32', 'Minimum amount changed from  to 10'),
(7, 491, 'Maximum Increased', '2023-06-10 07:42:32', 'Maximum amount changed from  to 20000'),
(8, 1221, 'Refill Activated', '2023-06-17 21:29:08', 'Refill Button has been activated'),
(9, 1221, 'Cancel Deactivated', '2023-06-17 21:29:08', 'Cancel Button has been Deativated'),
(10, 1221, 'Price Increased', '2023-06-17 21:29:08', 'Price changed from  to 38.06'),
(11, 1221, 'Minimum Increased', '2023-06-17 21:29:08', 'Minimum amount changed from  to 100'),
(12, 1221, 'Maximum Increased', '2023-06-17 21:29:08', 'Maximum amount changed from  to 250000');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`admin_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 `currency`
--
ALTER TABLE `currency`
  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`) USING BTREE;

--
-- 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 `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`payment_id`);

--
-- Indexes for table `payments_bonus`
--
ALTER TABLE `payments_bonus`
  ADD PRIMARY KEY (`bonus_id`);

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

--
-- Indexes for table `payment_methodsold`
--
ALTER TABLE `payment_methodsold`
  ADD PRIMARY KEY (`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 `refill_status`
--
ALTER TABLE `refill_status`
  ADD PRIMARY KEY (`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=873;

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

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

--
-- 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=3;

--
-- 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=1452;

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

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

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

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

--
-- 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=4;

--
-- 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=5;

--
-- 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=29;

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

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

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

--
-- 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 `payments`
--
ALTER TABLE `payments`
  MODIFY `payment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=133;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `refill_status`
--
ALTER TABLE `refill_status`
  MODIFY `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=2624;

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

--
-- 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=54;

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

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

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

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

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

--
-- 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, AUTO_INCREMENT=13;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
