-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 28, 2023 at 12:56 PM
-- Server version: 10.6.15-MariaDB
-- 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: `pukukkyr_adlinkfly`
--

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

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

CREATE TABLE `admins` (
  `admin_id` int(11) NOT NULL,
  `username` varchar(225) DEFAULT NULL,
  `password` text NOT 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` enum('{"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","proxy":"1","kuponlar":"1","admins":"1"}') DEFAULT '{"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","proxy":"1","kuponlar":"1","admins":"1"}',
  `dream_id` int(11) NOT NULL,
  `mode` varchar(225) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `admins` (`admin_id`, `username`, `password`, `register_date`, `login_date`, `login_ip`, `client_type`, `access`, `dream_id`, `mode`) VALUES
(1, 'admin', 'admin', '0000-00-00 00:00:00', '2023-12-28 11:50:03', '114.130.188.235', '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\",\"proxy\":\"1\",\"kuponlar\":\"1\",\"admins\":\"1\"}', 0, 'sun');

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

--
-- 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=utf8mb3 COLLATE=utf8mb3_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 `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 utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '2',
  `category_secret` enum('1','2') NOT NULL DEFAULT '2',
  `category_icon` text NOT NULL,
  `is_refill` enum('1','2') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '1'
) 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=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

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

CREATE TABLE `clients` (
  `client_id` int(11) NOT NULL,
  `name` varchar(225) DEFAULT NULL,
  `email` varchar(225) NOT NULL,
  `username` varchar(225) DEFAULT NULL,
  `admin_type` enum('1','2') NOT NULL DEFAULT '2',
  `password` text NOT NULL,
  `telephone` varchar(225) DEFAULT NULL,
  `balance` decimal(21,7) NOT NULL,
  `balance_type` enum('1','2') NOT NULL DEFAULT '2',
  `debit_limit` double DEFAULT NULL,
  `spent` decimal(21,7) NOT 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` enum('INR','USD') NOT NULL DEFAULT 'INR',
  `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,
  `verified` enum('Yes','No') NOT NULL DEFAULT 'No',
  `coustm_rate` double NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `clients` (`client_id`, `name`, `email`, `username`, `admin_type`, `password`, `telephone`, `balance`, `balance_type`, `debit_limit`, `spent`, `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`, `verified`, `coustm_rate`) VALUES
(70, 'Sohan Mahmoud', 'profelartech@gmail.com', 'sohan121', '2', 'a175601034c5104791cfc8c3fd909d21', '', 0.0000000, '2', NULL, 0.0000000, '2023-12-28 12:20:05', NULL, NULL, '3a7b5b1b4d88975207b3c5ee1113a3e3', '1', '2', '2', NULL, 'en', 0, 'INR', 'b5ecbe', NULL, '2', 0, '2', '', 'No', 0);

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `client_report` (`id`, `client_id`, `action`, `report_ip`, `report_date`) VALUES
(356, 50, 'New 0.01  payment has been made with Paytm Business and Final balance \r\n                        is 0.01 ', '49.15.82.119', '2022-08-02 07:31:04'),
(355, 50, 'New 0.01  payment has been made with Paytm Business and Final balance \r\n                        is 0.01 ', '42.107.204.42', '2022-08-02 01:24:52'),
(354, 50, 'Member logged in.', '42.107.197.106', '2022-08-02 01:08:31'),
(353, 50, 'Member logged in.', '42.107.197.106', '2022-08-02 01:00:04'),
(357, 53, '\r\n    User registered.', '49.36.209.82', '2022-08-09 16:33:45'),
(358, 53, 'Member logged in.', '49.36.209.82', '2022-08-09 16:39:29'),
(359, 54, '\r\n    User registered.', '49.36.209.82', '2022-08-09 21:18:05'),
(360, 55, '\r\n    User registered.', '132.154.102.126', '2022-08-09 21:41:57'),
(361, 53, 'Member logged in.', '49.36.209.82', '2022-08-09 23:03:04'),
(362, 53, 'Member logged in.', '49.36.209.82', '2022-08-09 23:06:40'),
(363, 53, 'Member logged in.', '49.36.209.82', '2022-08-10 01:28:45'),
(364, 53, '0.01 New Order #33.', '49.36.209.82', '2022-08-10 01:42:06'),
(365, 53, '0.01 New Order #34.', '49.36.209.82', '2022-08-10 01:44:00'),
(366, 53, '9.98 New Order #35.', '49.36.209.82', '2022-08-10 01:44:37'),
(367, 56, '\r\n    User registered.', '103.161.56.102', '2022-08-10 16:10:41'),
(368, 56, 'Member logged in.', '103.161.56.102', '2022-08-10 16:15:33'),
(369, 55, 'Member logged in.', '132.154.106.97', '2022-08-10 16:44:15'),
(370, 55, '10 New Order #36.', '132.154.106.97', '2022-08-10 16:45:52'),
(371, 55, '4.56 New Order #37.', '132.154.106.97', '2022-08-10 16:46:07'),
(372, 55, '5.66 New Order #38.', '132.154.106.97', '2022-08-10 16:46:27'),
(373, 57, '\r\n    User registered.', '27.97.160.255', '2022-08-10 18:44:43'),
(374, 58, '\r\n    User registered.', '117.234.97.177', '2022-08-10 20:30:05'),
(375, 59, '\r\n    User registered.', '47.31.98.139', '2022-08-10 20:31:17'),
(376, 60, '\r\n    User registered.', '117.102.54.80', '2022-08-10 21:57:02'),
(377, 53, '0.0012 New Order #39.', '157.34.145.165', '2022-08-10 22:56:50'),
(378, 61, '\r\n    User registered.', '223.230.147.248', '2022-08-11 11:19:24'),
(379, 62, '\r\n    User registered.', '157.35.7.214', '2022-08-11 12:21:43'),
(380, 60, 'Member logged in.', '185.165.241.101', '2022-08-11 20:02:25'),
(381, 63, '\r\n    User registered.', '223.238.91.32', '2022-08-11 20:09:19'),
(382, 60, 'Member logged in.', '185.165.241.101', '2022-08-11 20:16:02'),
(383, 60, 'Member logged in.', '185.165.241.101', '2022-08-11 20:31:43'),
(384, 64, '\r\n    User registered.', '42.108.197.101', '2022-08-11 20:51:16'),
(385, 53, 'Member logged in.', '49.36.211.132', '2022-08-11 21:02:30'),
(386, 64, 'Member logged in.', '103.240.79.68', '2022-08-11 21:51:31'),
(387, 55, 'Member logged in.', '132.154.102.128', '2022-08-12 07:37:16'),
(388, 58, 'Member logged in.', '117.234.124.138', '2022-08-12 08:51:48'),
(389, 55, 'Member logged in.', '132.154.109.202', '2022-08-12 20:58:56'),
(390, 65, '\r\n    User registered.', '171.79.153.192', '2022-08-12 21:18:09'),
(391, 66, '\r\n    User registered.', '42.105.103.136', '2022-08-13 09:00:27'),
(392, 67, '\r\n    User registered.', '157.49.178.166', '2022-08-13 16:53:45'),
(393, 68, '\r\n    User registered.', '117.234.163.193', '2022-08-14 08:50:28'),
(394, 68, 'Member logged in.', '117.234.163.193', '2022-08-14 09:51:12'),
(395, 69, '\r\n    User registered.', '223.226.161.113', '2022-08-14 09:52:10'),
(396, 70, '\r\n    User registered.', '114.130.188.40', '2023-12-28 12:20:05');

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

--
-- 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=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `currency` (`id`, `symbol`, `value`, `name`, `status`, `default`, `nouse`) VALUES
(1, '₹', 1, 'INR', '1', '2', '1'),
(2, '$', 0.01265822784, 'USD', '1', '1', '2');

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

--
-- 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=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `decoration` (`id`, `snow_effect`, `snow_colour`, `diwali_lights`, `video_link`, `christmas_deco`, `action_link`, `pop_noti`, `pop_title`, `pop_desc`, `action_text`, `action_button`, `snow_fall`, `garlands`, `fire_works`, `toys`, `snowflakes`, `snow_speed`, `gar_shape`, `gar_style`, `fire_size`, `fire_speed`, `toy_size`, `toy_quantity`, `toy_speed`, `toy_launch`, `toy_a`, `toy_b`, `toy_c`, `toy_d`, `toy_e`, `toy_f`, `toy_g`, `toy_h`, `toy_i`, `toy_j`, `toy_k`, `psw_license`, `toy_l`) VALUES
(1, 0, 'rsj', 0, '', ' <!-- developed by PSW-->\r\n\r\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>\r\n<!-- developed by Raj Patel-->\r\n      \r\n<!-- developed by Raj Patel-->  \r\n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/libs/jquery/1.12.4/jquery.min.js\">\r\n          </script>\r\n    \r\n<!-- developed by Raj Patel-->\r\n        \r\n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/flpbonhmkq9tsp29.js\">\r\n          </script>\r\n    \r\n        \r\n<!-- developed by Raj Patel-->\r\n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/a4kdpfesx15uh7ae.js\">\r\n          </script>\r\n    \r\n<!-- developed by Raj Patel-->\r\n        \r\n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/596z6ya3isgxcipy.js\">\r\n          </script>\r\n    \r\n        \r\n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/39j8e9yrxs283d1x.js\">\r\n          </script>\r\n    \r\n        \r\n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/global/33srijdbqcgk6lsz.js\">\r\n          </script>\r\n    \r\n<!-- developed by Raj Patel-->\r\n<!-- developed by Raj Patel-->\r\n        \r\n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/52pp7z/wxbh27w4jdzpslxn.js\">\r\n          </script>\r\n    \r\n<!-- developed by Raj Patel-->\r\n<!-- developed by Raj Patel-->\r\n        \r\n    <script type=\"text/javascript\" src=\"https://cdn.mypanel.link/52pp7z/angedasgma230hxr.js\">\r\n          </script>\r\n    \r\n        \r\n<!-- developed by Raj Patel-->\r\n<!-- developed by Raj Patel-->\r\n    <script type=\"text/javascript\" >\r\n       window.modules.layouts = {\"theme_id\":1,\"auth\":0,\"live\":true};     </script>\r\n    \r\n        \r\n    <script type=\"text/javascript\" >\r\n       window.modules.signin = [];     </script>\r\n    \r\n<!-- developed by Raj Patel-->\r\n<!-- developed by Raj Patel-->\r\n<!-- developed by Raj Patel-->\r\n        \r\n    <script type=\"text/javascript\" >\r\n       document.addEventListener(\'DOMContentLoaded\', function() { \r\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, 'true', 'true', 'true', 'true', 20, 3, 'pear', 'style1', '0.97', 'slow', 30, 20, 3, 'infinite', '', '1', '', '1', '1', '', '1', '', '', '', '1', 'perfectsmmworld.com', '');

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

--
-- 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=utf8mb3 COLLATE=utf8mb3_general_ci;

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

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

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

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

INSERT INTO `General_options` (`id`, `coupon_status`, `updates_show`, `panel_status`, `panel_orders`, `panel_thismonthorders`, `massorder`, `balance_format`, `currency_format`, `ticket_system`) VALUES
(1, '', '2', 'Active', 1024, 20, '2', '', '3', '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=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `integrations` (`id`, `name`, `description`, `icon_url`, `code`, `visibility`, `status`) VALUES
(1, 'Beamer', 'Announce updates and get feedback with in-app notification center, widgets and changelog', '/img/integrations/Beamer.svg', '', 1, 1),
(2, 'Getsitecontrol', 'It helps you prevent website visitors from leaving your website without taking any action.', '/img/integrations/Getsitecontrol.svg', '', 1, 1),
(3, 'Google Analytics', 'Statistics and basic analytical tools for search engine optimization (SEO) and marketing purposes', '/img/integrations/Google%20Analytics.svg', '', 1, 1),
(4, 'Google Tag manager', 'Manage all your website tags without editing the code using simple tag management solutions', '/img/integrations/Google%20Tag%20manager.svg', '', 1, 1),
(5, 'JivoChat', 'All-in-one business messenger to talk to customers: live chat, phone, email and social', '/img/integrations/JivoChat.svg', '', 1, 1),
(6, 'Onesignal', 'Leader in customer engagement, empowers mobile push, web push, email, in-app messages', '/img/integrations/Onesignal.svg', '', 1, 1),
(7, 'Push alert', 'Increase reach, revenue, retarget users with Push Notifications on desktop and mobile', '/img/integrations/Push%20alert.svg', '', 1, 1),
(8, 'Smartsupp', 'Live chat, email inbox and Facebook Messenger in one customer messaging platform', '/img/integrations/Smartsupp.svg', '', 1, 1),
(9, 'Tawk.to', 'Track and chat with visitors on your website, mobile app or a free customizable page', '/img/integrations/Tawk.to.svg', 'Hii friends ', 3, 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', '<!-- GetButton.io widget -->\r\n<script type=\"text/javascript\">\r\n    (function () {\r\n        var options = {\r\n            whatsapp: \"+1(800) 123-45-67\", // WhatsApp number\r\n            call_to_action: \"Message us\", // Call to action\r\n            button_color: \"#FF6550\", // Color of button\r\n            position: \"right\", // Position may be \'right\' or \'left\'\r\n        };\r\n        var proto = document.location.protocol, host = \"getbutton.io\", url = proto + \"//static.\" + host;\r\n        var s = document.createElement(\'script\'); s.type = \'text/javascript\'; s.async = true; s.src = url + \'/widget-send-button/js/init.js\';\r\n        s.onload = function () { WhWidgetSendButton.init(host, proto, options); };\r\n        var x = document.getElementsByTagName(\'script\')[0]; x.parentNode.insertBefore(s, x);\r\n    })();\r\n</script>\r\n<!-- /GetButton.io widget -->', 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, 2),
(14, 'SEO Ayarlamaları', 'Search Engine Optimization (SEO) is the name given to all the work done to make websites perform better in search engines.', '/img/integrations/Seo settings.png', '', 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;

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

--
-- 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=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `languages` (`id`, `language_name`, `language_code`, `language_type`, `default_language`) VALUES
(2, 'English', 'en', '2', '1'),
(3, 'Bangla', 'bn', '2', '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=utf8mb3 COLLATE=utf8mb3_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 utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '2',
  `slug` varchar(225) NOT NULL DEFAULT '2',
  `icon` varchar(225) DEFAULT NULL,
  `menu_status` enum('1','2') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '1',
  `visible` enum('Internal','External') NOT NULL DEFAULT 'Internal',
  `active` varchar(225) NOT NULL,
  `tiptext` varchar(225) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

INSERT INTO `menus` (`id`, `name`, `menu_line`, `type`, `slug`, `icon`, `menu_status`, `visible`, `active`, `tiptext`) VALUES
(2, 'Mass Order', 3, '2', '/massorder', 'fa fa-amazon', '1', 'Internal', 'massorder', 'Shown only if Mass Order system enabled for use'),
(3, 'Orders ', 2, '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', '/login', 'fas fa-address-card', '1', 'External', 'login', ''),
(6, 'Services', 5, '2', '/services', 'fas fa-cogs', '1', 'Internal', 'services', ''),
(7, 'Add Funds', 6, '2', '/addfunds', 'fas fa-money-check', '1', 'Internal', 'addfunds', ''),
(8, 'Api', 8, '2', '/api', 'fas fa-code', '1', 'Internal', 'api', ''),
(9, 'Tickets ', 7, '2', '/tickets', 'fas fa-headset', '1', 'Internal', 'tickets', ''),
(10, 'Child Panels', 11, '2', '/child-panels', 'fas fa-child', '1', 'Internal', 'child-panels', 'Shown only if child panels selling enabled'),
(11, 'Refer & Earn', 9, '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', 'fas fa-code', '1', 'External', 'api', ''),
(17, 'Updates', 13, '2', '/terms', '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, '2', '/blog', 'fas fa-grip-vertical', '1', 'Internal', 'blog', ''),
(26, 'Services', 16, '2', '/services', 'fas fa-clipboard-list', '1', 'External', 'serviceUSD', ''),
(28, 'New Order', 1, '2', '/', 'fas fa-cart-arrow-down', '1', 'Internal', '', '');

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

--
-- 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=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `news_icon`, `news_title`, `news_content`, `news_date`) VALUES
(9, 'youtube', 'youtube services ', 'slow due to update', '2022-08-01 00:03:15'),
(11, 'youtube', 'Kitty', 'Hai ', '2022-08-01 17:42:05'),
(13, 'General Announcement', 'Ok', 'Test', '2022-08-01 17:44:11'),
(15, 'Star', 'Check ', 'Checking ', '2022-08-11 20:19:22'),
(16, 'Star', 'Check ', 'Checking ', '2022-08-11 20:19:22');

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

--
-- 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,
  `action_link` text NOT NULL,
  `isAllPage` enum('0','1') NOT NULL DEFAULT '0',
  `isAllUser` enum('1','0') NOT NULL DEFAULT '0',
  `expiry_date` date NOT NULL,
  `status` enum('1','2','0') NOT NULL DEFAULT '1',
  `allPages` varchar(225) NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `image_file` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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,
  `psw_license` text NOT NULL,
  `avg_done` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `orders` (`order_id`, `client_id`, `service_id`, `api_orderid`, `order_error`, `order_detail`, `order_api`, `api_serviceid`, `api_charge`, `api_currencycharge`, `order_profit`, `order_quantity`, `order_extras`, `order_charge`, `dripfeed`, `dripfeed_id`, `subscriptions_id`, `subscriptions_type`, `dripfeed_totalcharges`, `dripfeed_runs`, `dripfeed_delivery`, `dripfeed_interval`, `dripfeed_totalquantity`, `dripfeed_status`, `order_url`, `order_start`, `order_finish`, `order_remains`, `order_create`, `order_status`, `subscriptions_status`, `subscriptions_username`, `subscriptions_posts`, `subscriptions_delivery`, `subscriptions_delay`, `subscriptions_min`, `subscriptions_max`, `subscriptions_expiry`, `last_check`, `order_where`, `refill_status`, `is_refill`, `refill`, `cancelbutton`, `show_refill`, `api_refillid`, `psw_license`, `avg_done`) VALUES
(33, 53, 213, 0, '-', NULL, 0, 0, 0, 1, 0.01, 1, '', 0.01, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.youtube.com/channel/UCNzm_bum_SFUj7Eqo9dqJWw', 0, 0, 0, '2022-08-10 01:42:06', 'pending', 'active', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2022-08-10 01:42:06', 'site', 'Pending', '1', '1', '1', 'true', 0, '', '1'),
(34, 53, 213, 0, '-', NULL, 0, 0, 0, 1, 0.01, 1, '', 0.01, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.instagram.com/piyush_17op', 0, 0, 0, '2022-08-10 01:44:00', 'pending', 'active', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2022-08-10 01:44:00', 'site', 'Pending', '1', '1', '1', 'true', 0, '', '1'),
(35, 53, 213, 0, '-', NULL, 0, 0, 0, 1, 9.98, 998, '', 9.98, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.instagram.com/piyush_17op', 0, 0, 0, '2022-08-10 01:44:37', 'pending', 'active', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2022-08-10 01:44:37', 'site', 'Pending', '1', '1', '1', 'true', 0, '', '1'),
(36, 55, 213, 0, '-', NULL, 0, 0, 0, 1, 10, 1000, '', 10, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'https://www.instagram.com/reel/CXQ8-wtji-O/?igshid=YmMyMTA2M2Y=', 0, 0, 0, '2022-08-10 16:45:52', 'pending', 'active', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2022-08-10 16:45:52', 'site', 'Pending', '1', '1', '1', 'true', 0, '', '1'),
(37, 55, 213, 0, '-', NULL, 0, 0, 0, 1, 4.56, 456, '', 4.56, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'Ka1234', 0, 0, 0, '2022-08-10 16:46:07', 'pending', 'active', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2022-08-10 16:46:07', 'site', 'Pending', '1', '1', '1', 'true', 0, '', '1'),
(38, 55, 213, 0, '-', NULL, 0, 0, 0, 1, 5.66, 566, '', 5.66, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'Ka1234', 0, 0, 0, '2022-08-10 16:46:27', 'pending', 'active', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2022-08-10 16:46:27', 'site', 'Pending', '1', '1', '1', 'true', 0, '', '1'),
(39, 53, 215, 0, '-', NULL, 0, 0, 0, 1, 0.0012, 10, '', 0.0012, '1', 0, 0, '1', NULL, NULL, 0, NULL, NULL, 'active', 'Testu. Com', 0, 0, 0, '2022-08-10 22:56:50', 'pending', 'active', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2022-08-10 22:56:50', 'site', 'Pending', '1', '1', '1', 'true', 0, '', '1');

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

--
-- 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
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `pages` (`page_id`, `page_name`, `page_get`, `page_content`, `page_status`, `active`, `seo_title`, `seo_keywords`, `seo_description`, `last_modified`) VALUES
(2, 'Add funds', 'addfunds', '', '1', '1', '', '', '', '0000-00-00 00:00:00'),
(3, 'Affiliates', 'refer', '', '1', '1', '', '', '', '0000-00-00 00:00:00'),
(4, 'Api', 'api', '', '1', '1', '', '', '', '0000-00-00 00:00:00'),
(5, 'Blog', 'blog', '', '1', '1', '', '', '', '0000-00-00 00:00:00'),
(6, 'Login', 'auth', '', '1', '1', '', '', '', '0000-00-00 00:00:00'),
(7, 'Child Panels', 'child-panels', '', '1', '1', '', '', '', '0000-00-00 00:00:00'),
(8, 'Mass Order', 'massorder', '', '1', '1', '', '', '', '0000-00-00 00:00:00'),
(9, 'New Order', 'neworder', '<p><br></p>', '1', '1', '', '', '', '2022-04-22 12:40:53'),
(782, 'Orders', 'Orders', '', '1', '1', '', '', '', '0000-00-00 00:00:00'),
(11, 'Refill', 'refill', '', '1', '1', '', '', '', '0000-00-00 00:00:00'),
(12, 'Services', 'services', '', '1', '1', '', '', '', '0000-00-00 00:00:00'),
(13, 'Sign Up', 'signup', '', '1', '1', '', '', '', '0000-00-00 00:00:00'),
(14, 'Terms', 'terms', '', '1', '1', '', '', '', '0000-00-00 00:00:00'),
(783, 'Transection ', 'transectionlist', '', '1', '1', '', '', '', '0000-00-00 00:00:00');

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

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

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

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

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

CREATE TABLE `payments` (
  `payment_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `client_balance` double NOT NULL DEFAULT 0,
  `payment_amount` double 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` text NOT NULL,
  `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=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `payments` (`payment_id`, `client_id`, `client_balance`, `payment_amount`, `payment_privatecode`, `payment_method`, `payment_status`, `payment_delivery`, `payment_note`, `payment_mode`, `payment_create_date`, `payment_update_date`, `payment_ip`, `payment_extra`, `payment_bank`, `t_id`) VALUES
(121, 50, 0, 0.01, NULL, 14, '3', '2', '', 'Auto', '2022-08-02 07:31:03', '0000-00-00 00:00:00', '49.15.82.119', '202208020124210054', 0, NULL),
(122, 53, 0, 10, NULL, 1, '3', '2', '', 'Manuel', '2022-08-10 01:35:11', '2022-08-10 01:35:11', '', '', 0, NULL),
(123, 53, 0, 10, NULL, 1, '3', '2', '', 'Manuel', '2022-08-10 01:51:18', '2022-08-10 01:51:18', '', '', 0, NULL),
(124, 53, 0, 20, NULL, 26, '1', '1', '', 'Auto', '2022-08-10 01:56:33', '0000-00-00 00:00:00', '49.36.209.82', '229aa3e61e3eaf7a00b0', 0, NULL),
(125, 56, 0, 50, NULL, 12, '3', '2', '41742', 'Manuel', '2022-08-10 16:12:08', '2022-08-10 16:12:08', '', '', 0, NULL),
(126, 55, 0, 20, NULL, 1, '3', '2', '', 'Manuel', '2022-08-10 16:44:02', '2022-08-10 16:44:02', '', '', 0, NULL),
(127, 55, 20, 50, NULL, 1, '3', '2', '', 'Manuel', '2022-08-10 16:44:32', '2022-08-10 16:44:32', '', '', 0, NULL),
(128, 64, 0, 500, NULL, 12, '1', '1', '', 'Auto', '2022-08-11 23:31:34', '0000-00-00 00:00:00', '42.108.197.101', '36a1694bce9815b7e38a9dad05ad42e0', 0, NULL);

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

--
-- 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=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- 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=utf8mb3 COLLATE=utf8mb3_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, 100, '2', '{\"method_type\":\"1\",\"name\":\"Paypal\",\"min\":\"10\",\"max\":\"100\",\"business_email\":\"\",\"fee\":\"15\",\"currency\":\"USD\"}', 5, '2'),
(2, 'Stripe', 'stripe', 1, 100, '2', '{\"method_type\":\"2\",\"name\":\"Stripe\",\"min\":\"1\",\"max\":\"100\",\"stripe_publishable_key\":\"\",\"stripe_secret_key\":\"\",\"stripe_webhooks_secret\":\"\",\"fee\":\"10\",\"currency\":\"USD\"}', 19, '2'),
(3, 'Shopier', 'shopier', 5, 0, '2', '{\"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\"}', 6, '2'),
(5, 'Paywant', 'paywant', 1, 0, '2', '{\"method_type\":\"1\",\"name\":\"Paywant\",\"min\":\"1\",\"max\":\"0\",\"apiKey\":\"\",\"apiSecret\":\"\",\"fee\":\"0\",\"currency\":\"USD\",\"commissionType\":\"2\",\"payment_type\":[\"1\",\"2\",\"3\"]}', 7, '2'),
(7, 'PayTR', 'paytr', 1, 0, '2', '{\"method_type\":\"1\",\"name\":\"Paytr\",\"min\":\"1\",\"max\":\"0\",\"merchant_id\":\"\",\"merchant_key\":\"\",\"merchant_salt\":\"\",\"fee\":\"0\",\"currency\":\"USD\"}', 8, '2'),
(8, 'Coinpayments', 'coinpayments', 1, 0, '2', '{\"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\"}', 9, '2'),
(9, '2checkout', '2checkout', 1, 0, '2', '{\"method_type\":\"1\",\"name\":\"2checkout\",\"min\":\"1\",\"max\":\"0\",\"seller_id\":\"\",\"private_key\":\"\",\"fee\":\"1\",\"currency\":\"USD\"}', 10, '2'),
(10, 'Payoneer', 'payoneer', 0, 0, '2', '{\"method_type\":\"2\",\"name\":\"Payoneer\",\"email\":\"\"}', 11, '2'),
(11, 'Mollie', 'mollie', 1, 0, '2', '{\"method_type\":\"1\",\"name\":\"Mollie\",\"min\":\"1\",\"max\":\"0\",\"live_api_key\":\"\",\"fee\":\"0\",\"currency\":\"USD\"}', 12, '2'),
(12, 'PayTM', 'paytm', 1, 10000, '2', '{\"method_type\":\"2\",\"name\":\"PayTM\",\"min\":\"1\",\"max\":\"10000\",\"merchant_key\":\"\",\"merchant_mid\":\"\",\"merchant_website\":\"DEFAULT\",\"fee\":\"0\",\"currency\":\"\"}', 1, '2'),
(13, 'Instamojo', 'instamojo', 0, 0, '2', '{\"method_type\":\"2\",\"name\":\"Instamojo\",\"min\":\"0\",\"max\":\"0\",\"api_key\":\"\",\"live_auth_token_key\":\"\",\"fee\":\"0\",\"currency\":\"INR\"}', 13, '2'),
(14, 'Paytm Business', 'paytmqr', 1, 1000000, '2', '{\"method_type\":\"2\",\"name\":\"Paytm Business\",\"min\":\"1\",\"max\":\"1000000\",\"merchant_key\":\"https:\\/\\/malayalismm.in\\/fsp\\/paytmqr.png\",\"merchant_mid\":\"AcXucL71777785194944\",\"merchant_website\":\"\",\"fee\":\"\"}', 3, '2'),
(15, 'Razorpay', 'razorpay', 0.01, 10000, '2', '{\"method_type\":\"2\",\"name\":\"Razorpay\",\"min\":\"0.01\",\"max\":\"10000\",\"api_key\":\"\",\"api_secret_key\":\"\",\"fee\":\"0\",\"currency\":\"INR\"}', 4, '2'),
(16, 'Iyzico', 'iyzico', 1, 0, '2', '{\"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, '2', '{\"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, '2', '{\"method_type\":\"1\",\"name\":\"Ravepay\",\"min\":\"1\",\"max\":\"0\",\"public_api_key\":\"0\",\"secret_api_key\":\"0\",\"fee\":\"0\",\"currency\":\"USD\"}', 16, '2'),
(21, 'Pagseguro', 'pagseguro', 1, 0, '2', '{\"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', 0, 100, '2', '{\"method_type\":\"2\",\"name\":\"Cashmaal\",\"min\":\"0\",\"max\":\"100\",\"web_id\":\"\",\"fee\":\"0\",\"currency\":\"USD\"}', 17, '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', 0.01, 1000000, '2', '{\"method_type\":\"2\",\"name\":\"Payumoney \",\"min\":\"0.01\",\"max\":\"1000000\",\"merchant_key\":\"\",\"salt\":\"\",\"fee\":\"10\",\"currency\":\"\"}', 2, '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'),
(99, 'Payumoney For Inr DEVELOPED BY PSW', 'payumoney', 0.01, 1000000, '2', '{\"method_type\":\"2\",\"name\":\"Payumoney \",\"min\":\"0.01\",\"max\":\"1000000\",\"merchant_key\":\"\",\"salt\":\"\",\"fee\":\"10\",\"currency\":\"\"}', 20, '2');

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

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

CREATE TABLE `psw-admins` (
  `psw-admin_id` int(11) NOT NULL,
  `username` varchar(225) DEFAULT NULL,
  `password` text NOT 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` enum('{"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","proxy":"1","kuponlar":"1","admins":"1"}') DEFAULT '{"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","proxy":"1","kuponlar":"1","admins":"1"}',
  `dream_id` int(11) NOT NULL,
  `mode` varchar(225) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `psw-admins` (`psw-admin_id`, `username`, `password`, `register_date`, `login_date`, `login_ip`, `client_type`, `access`, `dream_id`, `mode`) VALUES
(1, 'samad', 'samad', '0000-00-00 00:00:00', '2022-04-22 06:08:15', '27.63.16.28', '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\",\"proxy\":\"1\",\"kuponlar\":\"1\",\"admins\":\"1\"}', 0, 'sun');

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

--
-- Table structure for table `psw_paymentmethod`
--

CREATE TABLE `psw_paymentmethod` (
  `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=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `psw_paymentmethod`
--

INSERT INTO `psw_paymentmethod` (`id`, `method_name`, `method_get`, `method_min`, `method_max`, `method_type`, `method_extras`, `method_line`, `nouse`) VALUES
(1, 'Payumoney For Inr DEVELOPED BY PSW', 'payumoney', 0.01, 10, '1', '{\"method_type\":\"1\",\"name\":\"Payumoney \",\"min\":\"0.01\",\"max\":\"1000000\",\"merchant_key\":\"9G585p\",\"salt\":\"kdIKldPstvQIDB2uO0SgptbtTHCUfPLX\",\"fee\":\"10\",\"currency\":\"\"}', 20, '2');

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

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

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

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

INSERT INTO `referral` (`referral_id`, `referral_client_id`, `referral_clicks`, `referral_sign_up`, `referral_totalFunds_byReffered`, `referral_earned_commision`, `referral_requested_commision`, `referral_total_commision`, `referral_status`, `referral_code`, `referral_rejected_commision`) VALUES
(1, 1, 0, 0, 0, 0, '0', 0, '1', 'fbc28e', 0),
(2, 2, 0, 0, 0, 0, '0', 0, '1', 'cb5bb3', 0),
(3, 3, 0, 0, 0, 0, '0', 0, '1', '8efaf4', 0),
(4, 4, 0, 0, 0, 0, '0', 0, '1', '7403fb', 0),
(5, 5, 0, 0, 0, 0, '0', 0, '1', '7db34a', 0),
(6, 6, 0, 0, 0, 0, '0', 0, '1', '43945e', 0),
(7, 7, 0, 0, 0, 0, '0', 0, '1', 'bc51a7', 0),
(8, 8, 0, 0, 0, 0, '0', 0, '1', '995a2f', 0),
(9, 9, 0, 0, 0, 0, '0', 0, '1', 'ef67e1', 0),
(10, 10, 0, 0, 0, 0, '0', 0, '1', '7e9a38', 0),
(11, 11, 0, 0, 0, 0, '0', 0, '1', '0b6fe6', 0),
(12, 12, 0, 0, 0, 0, '0', 0, '1', 'f09a2f', 0),
(13, 13, 0, 0, 0, 0, '0', 0, '1', '254819', 0),
(14, 14, 0, 0, 0, 0, '0', 0, '1', '474a38', 0),
(15, 15, 0, 0, 0, 0, '0', 0, '1', 'ea23f6', 0),
(16, 16, 0, 0, 0, 0, '0', 0, '1', '9a6bce', 0),
(17, 17, 0, 0, 0, 0, '0', 0, '1', 'fa5d77', 0),
(18, 18, 0, 0, 0, 0, '0', 0, '1', '814c24', 0),
(19, 19, 0, 0, 0, 0, '0', 0, '1', '222aa1', 0),
(20, 20, 0, 0, 0, 0, '0', 0, '1', '9f9930', 0),
(21, 21, 0, 0, 0, 0, '0', 0, '1', 'b6d564', 0),
(22, 22, 0, 0, 0, 0, '0', 0, '1', 'cf466b', 0),
(23, 23, 0, 0, 0, 0, '0', 0, '1', '4e47ca', 0),
(24, 24, 0, 0, 0, 0, '0', 0, '1', 'eb8db0', 0),
(25, 25, 0, 0, 0, 0, '0', 0, '1', '1c4351', 0),
(26, 26, 0, 0, 0, 0, '0', 0, '1', '1c3736', 0),
(27, 27, 0, 0, 0, 0, '0', 0, '1', 'ff35c6', 0),
(28, 28, 0, 0, 0, 0, '0', 0, '1', '935800', 0),
(29, 29, 0, 0, 0, 0, '0', 0, '1', 'c43cb5', 0),
(30, 30, 0, 0, 0, 0, '0', 0, '1', '0da900', 0),
(31, 31, 0, 0, 0, 0, '0', 0, '1', '63702e', 0),
(32, 32, 0, 0, 0, 0, '0', 0, '1', '7c37e2', 0),
(33, 33, 0, 0, 0, 0, '0', 0, '1', '987967', 0),
(34, 34, 0, 0, 0, 0, '0', 0, '1', 'ae8488', 0),
(35, 35, 0, 0, 0, 0, '0', 0, '1', 'b8a1de', 0),
(36, 36, 0, 0, 0, 0, '0', 0, '1', '1d0dec', 0),
(37, 37, 0, 0, 0, 0, '0', 0, '1', '0434da', 0),
(38, 38, 0, 0, 0, 0, '0', 0, '1', 'fd8b99', 0),
(39, 39, 0, 0, 0, 0, '0', 0, '1', 'd0bb39', 0),
(40, 40, 0, 0, 0, 0, '0', 0, '1', '3f05ba', 0),
(41, 41, 0, 0, 0, 0, '0', 0, '1', '4a8dfa', 0),
(42, 42, 0, 0, 0, 0, '0', 0, '1', '0f7795', 0),
(43, 43, 0, 0, 0, 0, '0', 0, '1', '50ec88', 0),
(44, 44, 0, 0, 0, 0, '0', 0, '1', '55b43b', 0),
(45, 45, 0, 0, 0, 0, '0', 0, '1', 'd06a04', 0),
(46, 46, 0, 0, 0, 0, '0', 0, '1', 'cab81f', 0),
(47, 47, 0, 0, 0, 0, '0', 0, '1', 'b76225', 0),
(48, 48, 0, 0, 0, 0, '0', 0, '1', '977613', 0),
(49, 49, 0, 0, 0, 0, '0', 0, '1', '74e66e', 0),
(50, 50, 0, 0, 0, 0, '0', 0, '1', '480622', 0),
(51, 51, 0, 0, 0, 0, '0', 0, '1', '792bc6', 0),
(52, 52, 0, 0, 0, 0, '0', 0, '1', '77df82', 0),
(53, 53, 0, 0, 0, 0, '0', 0, '1', 'b59be8', 0),
(54, 54, 0, 0, 0, 0, '0', 0, '1', 'e1afd9', 0),
(55, 55, 0, 0, 0, 0, '0', 0, '1', '9d0f13', 0),
(56, 56, 0, 0, 0, 0, '0', 0, '1', 'a58a4b', 0),
(57, 57, 0, 0, 0, 0, '0', 0, '1', '7fc6d9', 0),
(58, 58, 0, 0, 0, 0, '0', 0, '1', '280fd1', 0),
(59, 59, 0, 0, 0, 0, '0', 0, '1', '6cbe2c', 0),
(60, 60, 0, 0, 0, 0, '0', 0, '1', 'bb367d', 0),
(61, 61, 0, 0, 0, 0, '0', 0, '1', '576dd7', 0),
(62, 62, 0, 0, 0, 0, '0', 0, '1', 'd69fb8', 0),
(63, 63, 0, 0, 0, 0, '0', 0, '1', 'd827a7', 0),
(64, 64, 0, 0, 0, 0, '0', 0, '1', '865413', 0),
(65, 65, 0, 0, 0, 0, '0', 0, '1', '265cea', 0),
(66, 66, 0, 0, 0, 0, '0', 0, '1', '0aa247', 0),
(67, 67, 0, 0, 0, 0, '0', 0, '1', 'd8a6eb', 0),
(68, 68, 0, 0, 0, 0, '0', 0, '1', 'b79992', 0),
(69, 69, 0, 0, 0, 0, '0', 0, '1', '41beac', 0),
(70, 70, 0, 0, 0, 0, '0', 0, '1', 'b5ecbe', 0);

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

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

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

--
-- Dumping data for table `referral_payouts`
--

INSERT INTO `referral_payouts` (`r_p_id`, `r_p_code`, `r_p_status`, `r_p_amount_requested`, `r_p_requested_at`, `r_p_updated_at`, `client_id`) VALUES
(1, 'fbc28e', '2', 0, '2022-04-17 21:34:05', '2022-04-19 11:34:34', 0);

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

--
-- 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=utf8mb3 COLLATE=utf8mb3_general_ci;

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

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

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

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

INSERT INTO `serviceapi_alert` (`id`, `service_id`, `serviceapi_alert`, `servicealert_extra`, `servicealert_date`) VALUES
(1, 24, '#24removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(2, 25, '#25removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(3, 22, '#22removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(4, 23, '#23removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(5, 21, '#21removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(6, 19, '#19removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(7, 20, '#20removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(8, 17, '#17removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(9, 18, '#18removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(10, 14, '#14removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(11, 15, '#15removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(12, 16, '#16removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(13, 13, '#13removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(14, 11, '#11removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(15, 12, '#12removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(16, 26, '#26removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(17, 27, '#27removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(18, 28, '#28removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(19, 29, '#29removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(20, 30, '#30removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(21, 31, '#31removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(22, 32, '#32removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(23, 33, '#33removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-22 21:14:32'),
(24, 34, '#34removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(25, 35, '#35removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(26, 36, '#36removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(27, 37, '#37removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(28, 38, '#38removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(29, 39, '#39removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(30, 40, '#40removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(31, 41, '#41removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(32, 42, '#42removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(33, 43, '#43removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(34, 44, '#44removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(35, 45, '#45removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(36, 46, '#46removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(37, 47, '#47removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(38, 48, '#48removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09'),
(39, 49, '#49removed by the number service provider.', '{\"old\":\"Active on Provider\",\"new\":\"Passive on Provider\"}', '2022-04-24 20:30:09');

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

--
-- 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
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- 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',
  `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',
  `psw_license` text NOT NULL,
  `licence_id` text NOT NULL,
  `psw_theme_color` text DEFAULT NULL,
  `resend_max` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `settings` (`id`, `site_seo`, `site_title`, `site_description`, `site_keywords`, `site_logo`, `site_name`, `site_currency`, `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`, `psw_license`, `licence_id`, `psw_theme_color`, `resend_max`) VALUES
(1, 'SMM panel', 'SMM panel', 'SMM panel', 'SMM panel', 'public/images/cfecdb276f634854f3ef915e2e980c31.png', 'Profelar Panel', 'USD', '', 'en', 'Eternity', 'ABHIJEET THEME COLOUR 3.0', '1', '', '', '', '', '1', '2', '1', '2', 1, 1, '', '121345', '', '465', 'ssl', '2', '2', '2', '2', '1', '2', 'bizimsms', 'Dream', '', '', '1', 'profelartech@gmail.com', '', '2', '2', '2', '2', 'asc', 0, 0, 0, 0, 'ns1.profelar.com', 'ns2.profelar.com', 2, '1', '#ffff', '2', 0, 0, '2', '2', 9999999999, '2', '2', '$', '₹', 74.87, '$', 0.013, '0', '1', '1', '2', '2', '1', 0.02, '2', '2', 'thesmm.xyz', '', 'PSW THEME COLOUR 3.0', 3);

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

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

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

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

--
-- 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
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `themes` (`id`, `theme_name`, `theme_dirname`, `theme_extras`, `last_modified`, `newpage`) VALUES
(2, 'Theme 1', '0C8t2cUp9wzh2tWfUWiDhRzHlRjKBeyWA7rG', '  {\"stylesheets\":[\"public/Eternity/bootstrap.css\",\"https:\\/\\/stackpath.bootstrapcdn.com\\/font-awesome\\/4.7.0\\/css\\/font-awesome.min.css\",\"public\\/datepicker\\/css\\/bootstrap-datepicker3.min.css\"],\"scripts\":[\"https:\\/\\/code.jquery.com\\/jquery-3.3.1.min.js\",\"public/Eternity/js/script.js\",\"public/Eternity/js/snowfall.min.js\",\"public/Eternity/js/bundle.js\",\"public/Eternity/js/main.js\",\"public/ajax.js\",\"public\\/datepicker\\/js\\/bootstrap-datepicker.min.js\"]}', '2022-04-23 10:22:48', ''),
(258, 'Theme 2', 'Eternity', '  {\"stylesheets\":[\"public/Eternity/bootstrap.css\",\"https:\\/\\/stackpath.bootstrapcdn.com\\/font-awesome\\/4.7.0\\/css\\/font-awesome.min.css\",\"public\\/datepicker\\/css\\/bootstrap-datepicker3.min.css\"],\"scripts\":[\"https:\\/\\/code.jquery.com\\/jquery-3.3.1.min.js\",\"public/Eternity/js/script.js\",\"public/Eternity/js/snowfall.min.js\",\"public/Eternity/js/bundle.js\",\"public/Eternity/js/main.js\",\"public/ajax.js\",\"public\\/datepicker\\/js\\/bootstrap-datepicker.min.js\"]}', '2022-08-10 11:09:18', '');

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

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

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

--
-- Dumping data for table `tickets`
--

INSERT INTO `tickets` (`ticket_id`, `client_id`, `subject`, `time`, `lastupdate_time`, `client_new`, `status`, `support_new`, `canmessage`) VALUES
(1, 1, 'Order : 21', '2022-04-20 09:22:42', '2022-04-21 17:24:31', '1', 'answered', '1', '2'),
(3, 37, 'Order : 778666', '2022-07-05 10:35:55', '2022-07-28 23:05:59', '1', 'answered', '2', '2');

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

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

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

--
-- 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-20 09:22:42', '1', 'Order ID: 21 Request: Speed-up , Message : ghuyikjhg', '1'),
(2, 1, 0, '2022-04-21 17:24:31', '2', 'We have Sended You message to further support team. We\'re hardly working to solve you issues please be calm and wait for support team reply', '1'),
(3, 2, 1, '2022-04-22 00:38:50', '2', 'hello admin \r\n\r\ni want to buy this on rental \r\n\r\nmobile no. 6396765619\r\n\r\ncontact back soon please', '1'),
(4, 3, 0, '2022-07-05 10:35:55', '1', 'Order ID: 778666 Request: Speed-up , Message : Nsnbshshshhzh', '1'),
(5, 3, 0, '2022-07-28 23:05:59', '2', 'Ok done', '1');

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

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

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

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

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

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

--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `updates` (`u_id`, `service_id`, `action`, `date`, `description`) VALUES
(21, 136, 'Minimum Increased', '2022-08-01 21:51:30', 'Minimum amount changed from 50 to 100'),
(22, 132, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(23, 133, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(24, 172, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(25, 136, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(26, 137, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(27, 138, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(28, 139, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(29, 134, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(30, 135, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(31, 141, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(32, 142, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(33, 140, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(34, 143, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(35, 144, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(36, 150, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(37, 147, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(38, 153, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(39, 154, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(40, 151, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(41, 152, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(42, 149, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(43, 146, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(44, 148, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(45, 145, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(46, 155, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(47, 160, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(48, 161, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(49, 162, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(50, 156, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(51, 159, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(52, 157, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(53, 158, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(54, 164, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(55, 163, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(56, 165, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(57, 170, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(58, 171, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(59, 167, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(60, 168, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(61, 169, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled'),
(62, 166, 'Disabled', '2022-08-02 00:49:51', 'Refill Button has been disabled');

--
-- 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 `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 `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 `General_options`
--
ALTER TABLE `General_options`
  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_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 `psw-admins`
--
ALTER TABLE `psw-admins`
  ADD PRIMARY KEY (`psw-admin_id`);

--
-- Indexes for table `psw_paymentmethod`
--
ALTER TABLE `psw_paymentmethod`
  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 `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 `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=2;

--
-- 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 for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- 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 for table `themes`
--
ALTER TABLE `themes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=259;

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

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

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

--
-- AUTO_INCREMENT for table `updates`
--
ALTER TABLE `updates`
  MODIFY `u_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;
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 */;