-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 01, 2026 at 10:30 PM
-- Server version: 10.11.18-MariaDB-cll-lve
-- PHP Version: 8.4.24

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: `zoroking_mirza`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id_admin` varchar(500) NOT NULL,
  `username` varchar(1000) NOT NULL,
  `password` varchar(1000) NOT NULL,
  `rule` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id_admin`, `username`, `password`, `rule`) VALUES
('6185717419', 'root', 'f3bbd0767c', 'administrator'),
('96352304', '96352304', '$2y$12$GYk1oB96AXLsjm12imz9a.jXiImNFNXZZrnYPiZT17ZJNZoY6xpEK', 'administrator');

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

--
-- Table structure for table `affiliates`
--

CREATE TABLE `affiliates` (
  `description` text DEFAULT NULL,
  `status_commission` varchar(200) DEFAULT NULL,
  `Discount` varchar(200) DEFAULT NULL,
  `price_Discount` varchar(200) DEFAULT NULL,
  `porsant_one_buy` varchar(100) DEFAULT NULL,
  `id_media` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `affiliates`
--

INSERT INTO `affiliates` (`description`, `status_commission`, `Discount`, `price_Discount`, `porsant_one_buy`, `id_media`) VALUES
('🚀 دنبال یک VPN سریع، پایدار و مطمئن هستی؟\n\n✅ اتصال پرسرعت و بدون قطعی\n✅ مناسب تلگرام، اینستاگرام، یوتیوب و همه سایت‌ها\n✅ نصب و راه‌اندازی آسان\n✅ پشتیبانی و تمدید سریع\n✅ قیمت مناسب\n\nاگر به یک VPN باکیفیت نیاز داری، از طریق لینک زیر وارد ربات شو و سرویس موردنظرت رو در کمتر از چند دقیقه دریافت کن.\n\n🔗 https://t.me/vpn_market10_bot?start=96352304', 'oncommission', 'onDiscountaffiliates', '10000', 'off_buy_porsant', 'AgACAgQAAyEFAASFv1VlAAIjVGpZTsEPdldJ6-wxSpwDVHcPrDYKAAJ_DmsbqwW4Uh2YPxpcnPtKAQADAgADeQADPQQ');

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

--
-- Table structure for table `app`
--

CREATE TABLE `app` (
  `id` int(6) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `link` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app`
--

INSERT INTO `app` (`id`, `name`, `link`) VALUES
(1, 'Hiddify Next', 'https://github.com/hiddify/hiddify-app/releases/download/v4.1.1/Hiddify-Android-universal.apk'),
(2, 'V2ray', 'https://github.com/2dust/v2rayNG/releases/download/2.2.5/v2rayNG_2.2.5-fdroid_universal.apk');

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

--
-- Table structure for table `botsaz`
--

CREATE TABLE `botsaz` (
  `id` int(6) UNSIGNED NOT NULL,
  `id_user` varchar(200) NOT NULL,
  `bot_token` varchar(200) NOT NULL,
  `admin_ids` text NOT NULL,
  `username` varchar(200) NOT NULL,
  `setting` text DEFAULT NULL,
  `hide_panel` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`hide_panel`)),
  `time` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `botsaz`
--

INSERT INTO `botsaz` (`id`, `id_user`, `bot_token`, `admin_ids`, `username`, `setting`, `hide_panel`, `time`) VALUES
(1, '7363268220', '8650797003:AAGefX_CAvQlitY3ba4e7f01l1KQeT3WeSI', '[\"7363268220\"]', 'vpn_market2_bot', '{\"minpricetime\":4000,\"pricetime\":4000,\"minpricevolume\":4000,\"pricevolume\":4000,\"support_username\":\"@support\",\"Channel_Report\":0,\"cart_info\":\"\\u062c\\u0647\\u062a \\u067e\\u0631\\u062f\\u0627\\u062e\\u062a \\u0645\\u0628\\u0644\\u063a \\u0631\\u0627 \\u0628\\u0647 \\u0634\\u0645\\u0627\\u0631\\u0647 \\u06a9\\u0627\\u0631\\u062a \\u0632\\u06cc\\u0631 \\u0648\\u0627\\u0631\\u06cc\\u0632 \\u0646\\u0645\\u0627\\u06cc\\u06cc\\u062f\",\"show_product\":true}', '{}', '2026/07/14 21:08:49');

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

--
-- Table structure for table `cancel_service`
--

CREATE TABLE `cancel_service` (
  `id` int(6) UNSIGNED NOT NULL,
  `id_user` varchar(500) NOT NULL,
  `username` varchar(1000) NOT NULL,
  `description` text NOT NULL,
  `status` varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `card_number`
--

CREATE TABLE `card_number` (
  `cardnumber` varchar(500) NOT NULL,
  `namecard` varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `card_number`
--

INSERT INTO `card_number` (`cardnumber`, `namecard`) VALUES
('6219861820707627', 'زمان پژوهش نیا');

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(6) UNSIGNED NOT NULL,
  `remark` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `remark`) VALUES
(11, 'یکماهه'),
(12, 'یک ماهه'),
(13, 'دوماهه'),
(14, 'سه ماهه'),
(15, 'نامحدود');

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

--
-- Table structure for table `channels`
--

CREATE TABLE `channels` (
  `remark` varchar(200) NOT NULL,
  `linkjoin` varchar(200) NOT NULL,
  `link` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `channels`
--

INSERT INTO `channels` (`remark`, `linkjoin`, `link`) VALUES
('کانال بهترین بازی', 'https://t.me/bestgame_tel', '@bestgame_tel');

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

--
-- Table structure for table `departman`
--

CREATE TABLE `departman` (
  `id` int(6) UNSIGNED NOT NULL,
  `idsupport` varchar(200) NOT NULL,
  `name_departman` varchar(600) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `departman`
--

INSERT INTO `departman` (`id`, `idsupport`, `name_departman`) VALUES
(1, '96352304', '☎️ بخش عمومی');

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

--
-- Table structure for table `Discount`
--

CREATE TABLE `Discount` (
  `id` int(6) UNSIGNED NOT NULL,
  `code` varchar(2000) DEFAULT NULL,
  `price` varchar(200) DEFAULT NULL,
  `limituse` varchar(200) DEFAULT NULL,
  `limitused` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `DiscountSell`
--

CREATE TABLE `DiscountSell` (
  `id` int(6) UNSIGNED NOT NULL,
  `codeDiscount` varchar(1000) NOT NULL,
  `price` varchar(200) NOT NULL,
  `limitDiscount` varchar(500) NOT NULL,
  `agent` varchar(500) NOT NULL,
  `usefirst` varchar(100) NOT NULL,
  `useuser` varchar(100) NOT NULL,
  `code_product` varchar(100) NOT NULL,
  `code_panel` varchar(100) NOT NULL,
  `time` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `usedDiscount` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `Giftcodeconsumed`
--

CREATE TABLE `Giftcodeconsumed` (
  `id` int(6) UNSIGNED NOT NULL,
  `code` varchar(2000) DEFAULT NULL,
  `id_user` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `help`
--

CREATE TABLE `help` (
  `id` int(6) UNSIGNED NOT NULL,
  `name_os` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `Media_os` varchar(5000) NOT NULL,
  `type_Media_os` varchar(500) NOT NULL,
  `category` text NOT NULL,
  `Description_os` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `help`
--

INSERT INTO `help` (`id`, `name_os`, `Media_os`, `type_Media_os`, `category`, `Description_os`) VALUES
(1, '🔗 اتصال به برنامه Hiddify', '', '', 'اتصال', 'بعد از دانلود و نصب نرم افزار hiddify next و بعد از خرید اشتراک یک لینک برای شما ارسال میشود روی لینک کلیک کرده و صفحه وب برای شما باز میشود در وسط صفحه باز شده یک دکمه گرد و بزرگ به نام اتصال هست اون دکمه وسط صفحه وب را بزنید به صورت اتوماتیک اشتراک خریداری شده به نرم افزار وارد میشود و شما فقط کافی است داخل نرم افزار دکمه کانکت رو بزنید و از سرعت و پایداری فیلتر لذت ببرید');

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

--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `id_invoice` varchar(200) NOT NULL,
  `id_user` varchar(200) DEFAULT NULL,
  `username` varchar(200) DEFAULT NULL,
  `Service_location` varchar(200) DEFAULT NULL,
  `time_sell` varchar(200) DEFAULT NULL,
  `name_product` varchar(200) DEFAULT NULL,
  `price_product` varchar(200) DEFAULT NULL,
  `Volume` varchar(200) DEFAULT NULL,
  `Service_time` varchar(200) DEFAULT NULL,
  `uuid` text DEFAULT NULL,
  `note` varchar(500) DEFAULT NULL,
  `user_info` text DEFAULT NULL,
  `bottype` varchar(200) DEFAULT NULL,
  `refral` varchar(100) DEFAULT NULL,
  `time_cron` varchar(100) DEFAULT NULL,
  `notifctions` text NOT NULL,
  `Status` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoice`
--

INSERT INTO `invoice` (`id_invoice`, `id_user`, `username`, `Service_location`, `time_sell`, `name_product`, `price_product`, `Volume`, `Service_time`, `uuid`, `note`, `user_info`, `bottype`, `refral`, `time_cron`, `notifctions`, `Status`) VALUES
('0df50ad3', '6790946158', '9101522_oiuyghjklp_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1785039443', 'سرویس تست', '0', '200', '1', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('34abbafc', '6185717419', '6185717419_34abbafc', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1783563918', 'سرویس تست', '0', '1', '100', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('3590da0e', '8896300877', 'zoroking2026_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1787781839', '⚙️ سرویس دلخواه', '526000', '70', '120', NULL, 'Hamid', NULL, NULL, '0', NULL, '{\"volume\":false,\"time\":false}', 'unpaid'),
('3abe9c62', '8636394298', '8697188_bot_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1787861518', 'سرویس تست', '0', '200', '1', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('3fd8eff3', '96352304', 'king_service2_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1785344736', 'سرویس تست', '0', '200', '1', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('53675343', '800295915', 'mohsen_tm_07_101', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1783988815', '10 گیگ', '70000', '10', '30', NULL, NULL, NULL, NULL, '0', NULL, '{\"volume\":false,\"time\":false}', 'active'),
('5bb4c5f5', '7904332946', '3437888_nima_bingo_2026_1_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1784673667', 'سرویس تست', '0', '200', '1', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('65b1ec3e', '308896062', 'mrd1606_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1788134490', 'سرویس تست', '0', '200', '1', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('6b01cdac', '5638605104', '6058627_bot_101', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1783960698', '10 گیگ', '70000', '10', '30', NULL, NULL, NULL, NULL, '0', NULL, '{\"volume\":false,\"time\":false}', 'active'),
('6fc54431', '6185717419', '6185717419_6fc54431', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1783565129', 'سرویس تست', '0', '1', '100', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('794b7681', '385721417', '7586835_hosseinbazmara_101', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1786559683', '10 گیگ', '70000', '10', '30', NULL, 'حسین', NULL, NULL, '0', NULL, '{\"volume\":false,\"time\":false}', 'active'),
('7cde682b', '800295915', '3850979_mohsen_tm_07_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1783889405', 'سرویس تست', '0', '200', '12', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('7de31ede', '5974770955', 'asal_scorpion_13_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1787078112', 'سرویس تست', '0', '200', '1', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('9360d3c4', '385721417', 'hosseinbazmara_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1786556620', 'سرویس تست', '0', '200', '1', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('93f23d5f', '5638605104', 'bot_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1783884047', 'سرویس تست', '0', '200', '12', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('98aa441d', '510244832', 'mojtaba7459_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1786598434', 'سرویس تست', '0', '200', '1', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('a46deba4', '1348937029', 'hsntbkh_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1788104567', 'سرویس تست', '0', '200', '1', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('a650245c', '7405148607', '1202941_bot_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1786739768', 'سرویس تست', '0', '200', '1', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('aec4e773', '8451031002', 'dr_king_mokhi_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1784296980', 'سرویس تست', '0', '200', '12', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('b1085882', '385721417', 'hosseinbazmara_101', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1786558281', '10 گیگ', '70000', '10', '30', NULL, 'حسین', NULL, NULL, '0', NULL, '{\"volume\":false,\"time\":false}', 'unpaid'),
('c78f8819', '6279576671', 'qaws098_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1784144579', 'سرویس تست', '0', '200', '12', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('c7fc6523', '6185717419', 'peterj1982_100', 'Hiddify', '1783556926', 'سرویس تست', '0', '1', '24', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'Unsuccessful'),
('cd100b51', '6824090864', '4788186_bot_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1785268896', '10 گیگ', '70000', '10', '30', NULL, 'Mori', NULL, NULL, '0', NULL, '{\"volume\":false,\"time\":false}', 'active'),
('cf4b6422', '5974770955', 'asal_scorpion_13_101', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1787080283', '⚙️ سرویس دلخواه', '100000', '13', '30', NULL, 'عارف صباغ', NULL, NULL, '0', NULL, '{\"volume\":false,\"time\":false}', 'active'),
('e0c5a5ff', '510244832', 'mojtaba7459_101', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1786652984', '10 گیگ', '70000', '10', '30', NULL, 'مجتبی', NULL, NULL, '96352304', NULL, '{\"volume\":false,\"time\":false}', 'unpaid'),
('e6516df5', '1876420099', 'ali_8faa_100', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1788160126', 'سرویس تست', '0', '200', '1', NULL, NULL, NULL, NULL, NULL, NULL, '{\"volume\":false,\"time\":false}', 'active'),
('ff106ef3', '5638605104', 'bot_102', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '1787409898', '20 گیگ', '140000', '20', '30', NULL, 'علی فاتحی', NULL, NULL, '0', NULL, '{\"volume\":false,\"time\":false}', 'active');

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

--
-- Table structure for table `logs_api`
--

CREATE TABLE `logs_api` (
  `id` int(6) UNSIGNED NOT NULL,
  `header` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`header`)),
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`data`)),
  `ip` varchar(200) NOT NULL,
  `time` varchar(200) NOT NULL,
  `actions` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `manualsell`
--

CREATE TABLE `manualsell` (
  `id` int(6) UNSIGNED NOT NULL,
  `codepanel` varchar(100) NOT NULL,
  `codeproduct` varchar(100) NOT NULL,
  `namerecord` varchar(200) NOT NULL,
  `username` varchar(500) DEFAULT NULL,
  `contentrecord` text NOT NULL,
  `status` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `marzban_panel`
--

CREATE TABLE `marzban_panel` (
  `id` int(6) UNSIGNED NOT NULL,
  `code_panel` varchar(200) DEFAULT NULL,
  `name_panel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `status` varchar(500) DEFAULT NULL,
  `url_panel` varchar(2000) DEFAULT NULL,
  `username_panel` varchar(200) DEFAULT NULL,
  `password_panel` varchar(200) DEFAULT NULL,
  `agent` varchar(200) DEFAULT NULL,
  `sublink` varchar(500) DEFAULT NULL,
  `config` varchar(500) DEFAULT NULL,
  `MethodUsername` varchar(700) DEFAULT NULL,
  `TestAccount` varchar(100) DEFAULT NULL,
  `limit_panel` varchar(100) DEFAULT NULL,
  `namecustom` varchar(100) DEFAULT NULL,
  `Methodextend` varchar(100) DEFAULT NULL,
  `conecton` varchar(100) DEFAULT NULL,
  `linksubx` varchar(1000) DEFAULT NULL,
  `inboundid` varchar(100) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `inboundstatus` varchar(100) DEFAULT NULL,
  `inbound_deactive` varchar(100) DEFAULT NULL,
  `time_usertest` varchar(100) DEFAULT NULL,
  `val_usertest` varchar(100) DEFAULT NULL,
  `secret_code` varchar(200) DEFAULT NULL,
  `priceChangeloc` varchar(200) DEFAULT NULL,
  `priceextravolume` varchar(500) DEFAULT NULL,
  `pricecustomvolume` varchar(500) DEFAULT NULL,
  `pricecustomtime` varchar(500) DEFAULT NULL,
  `priceextratime` varchar(500) DEFAULT NULL,
  `mainvolume` varchar(500) DEFAULT NULL,
  `maxvolume` varchar(500) DEFAULT NULL,
  `maintime` varchar(500) DEFAULT NULL,
  `maxtime` varchar(500) DEFAULT NULL,
  `status_extend` varchar(100) DEFAULT NULL,
  `datelogin` text DEFAULT NULL,
  `proxies` text DEFAULT NULL,
  `inbounds` text DEFAULT NULL,
  `subvip` varchar(60) DEFAULT NULL,
  `changeloc` varchar(60) DEFAULT NULL,
  `on_hold_test` varchar(60) NOT NULL,
  `version_panel` varchar(60) NOT NULL,
  `customvolume` text DEFAULT NULL,
  `hide_user` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marzban_panel`
--

INSERT INTO `marzban_panel` (`id`, `code_panel`, `name_panel`, `status`, `url_panel`, `username_panel`, `password_panel`, `agent`, `sublink`, `config`, `MethodUsername`, `TestAccount`, `limit_panel`, `namecustom`, `Methodextend`, `conecton`, `linksubx`, `inboundid`, `type`, `inboundstatus`, `inbound_deactive`, `time_usertest`, `val_usertest`, `secret_code`, `priceChangeloc`, `priceextravolume`, `pricecustomvolume`, `pricecustomtime`, `priceextratime`, `mainvolume`, `maxvolume`, `maintime`, `maxtime`, `status_extend`, `datelogin`, `proxies`, `inbounds`, `subvip`, `changeloc`, `on_hold_test`, `version_panel`, `customvolume`, `hide_user`) VALUES
(2, 'f4ff', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', 'active', 'https://z.zamanking.top/SIcMoJed5ui', 'null', 'null', 'all', 'onsublink', 'offconfig', 'نام کاربری + عدد به ترتیب', 'ONTestAccount', 'unlimited', 'Bot', 'اضافه شدن زمان و حجم به ماه بعد', 'offconecton', 'https://z.zamanking.top/W88BIuiLl6SQPKMeG4oV5kHVw', '1', 'hiddify', 'offinbounddisable', '1', '1', '200', '6a630fc9-f161-42d8-b8ad-bb01b26163e1', '30000', '{\"f\":\"7000\",\"n\":\"5000\",\"n2\":\"4000\"}', '{\"f\":\"7000\",\"n\":\"5000\",\"n2\":\"4000\"}', '{\"f\":\"300\",\"n\":\"300\",\"n2\":\"300\"}', '{\"f\":\"300\",\"n\":\"300\",\"n2\":\"300\"}', '{\"f\":\"10\",\"n\":\"10\",\"n2\":\"10\"}', '{\"f\":\"1000\",\"n\":\"1000\",\"n2\":\"1000\"}', '{\"f\":\"30\",\"n\":\"30\",\"n2\":\"30\"}', '{\"f\":\"365\",\"n\":\"1000\",\"n2\":\"1000\"}', 'on_extend', NULL, NULL, NULL, 'offsubvip', 'onchangeloc', '1', '0', '{\"f\":\"1\",\"n\":\"1\",\"n2\":\"1\"}', NULL),
(4, 'edab', 'اختصاصی 🇮🇷 🇩🇪 🇺🇲 🇹🇷 🇦🇪 🇨🇦', 'active', 'https://panel.marzban.cfd', 'Zamanking', 'EA3d7rk9mS&97G', 'all', 'onsublink', 'offconfig', 'نام کاربری دلخواه + عدد رندوم', 'OFFTestAccount', 'unlimited', 'none', 'ریست حجم و زمان', 'offconecton', 'https://a-l.fl-sub.site:2096', '1', 'marzban', 'offinbounddisable', '1', '1', '100', NULL, '30000', '{\"f\":\"10000\",\"n\":\"5000\",\"n2\":\"5000\"}', '{\"f\":\"10000\",\"n\":\"5000\",\"n2\":\"5000\"}', '{\"f\":\"300\",\"n\":\"300\",\"n2\":\"300\"}', '{\"f\":\"300\",\"n\":\"300\",\"n2\":\"300\"}', '{\"f\":\"10\",\"n\":\"1\",\"n2\":\"1\"}', '{\"f\":\"100\",\"n\":\"1000\",\"n2\":\"1000\"}', '{\"f\":\"30\",\"n\":\"1\",\"n2\":\"1\"}', '{\"f\":\"365\",\"n\":\"1000\",\"n2\":\"1000\"}', 'on_extend', '{\"time\":\"2026\\/08\\/28 00:46:16\",\"access_token\":\"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiJaYW1hbmtpbmciLCJhY2Nlc3MiOiJhZG1pbiIsImlhdCI6MTc4Nzg2NTM3NiwiYWlkIjoxMzQxLCJleHAiOjE3ODc5NTE3NzZ9.lyYoUEWucn-JxpkGPJAuhSSTChmmX7RgV_EoRz576iQ\"}', '{\"vmess\":{},\"vless\":{},\"trojan\":{},\"shadowsocks\":{\"method\":\"chacha20-ietf-poly1305\"},\"wireguard\":{\"private_key\":\"2EpDd5Ncbj8+R+AOh1Zxf7SOkrdPvHeOXTyPK+0hXn8=\",\"public_key\":\"FHjr35xgjX0cvBOy+IhFAosmrEbj3kzKjp04oTE5HE4=\",\"peer_ips\":[]},\"hysteria\":{\"auth\":\"d3a740ff-293d-4e0c-8bd2-0a402301523a\"}}', '[2]', 'offsubvip', 'onchangeloc', '1', '1', '{\"f\":\"0\",\"n\":\"1\",\"n2\":\"1\"}', NULL);

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

--
-- Table structure for table `Payment_report`
--

CREATE TABLE `Payment_report` (
  `id` int(6) UNSIGNED NOT NULL,
  `id_user` varchar(200) DEFAULT NULL,
  `id_order` varchar(2000) DEFAULT NULL,
  `time` varchar(200) DEFAULT NULL,
  `at_updated` varchar(200) DEFAULT NULL,
  `price` varchar(200) DEFAULT NULL,
  `dec_not_confirmed` text DEFAULT NULL,
  `Payment_Method` varchar(400) DEFAULT NULL,
  `payment_Status` varchar(100) DEFAULT NULL,
  `bottype` varchar(300) DEFAULT NULL,
  `message_id` int(11) DEFAULT NULL,
  `id_invoice` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Payment_report`
--

INSERT INTO `Payment_report` (`id`, `id_user`, `id_order`, `time`, `at_updated`, `price`, `dec_not_confirmed`, `Payment_Method`, `payment_Status`, `bottype`, `message_id`, `id_invoice`) VALUES
(1, '96352304', '723a7b8846', '2026/07/09 06:49:14', NULL, '100000', NULL, 'cart to cart', 'Unpaid', NULL, 1307, '0|0'),
(2, '6185717419', '9933e88966', '2026/07/10 04:51:26', NULL, '1500000', NULL, 'add balance by admin', 'paid', NULL, NULL, NULL),
(3, '6185717419', '73b9334da6', '2026/07/11 19:51:01', NULL, '1500000', NULL, 'low balance by admin', 'paid', NULL, NULL, NULL),
(4, '6812221987', 'a620dac7d8', '2026/07/12 07:29:49', NULL, '1500000', NULL, 'add balance by admin', 'paid', NULL, NULL, NULL),
(5, '800295915', '6cb52ae4b3', '2026/07/13 00:17:16', NULL, '100000', NULL, 'cart to cart', 'Unpaid', NULL, 2452, '0|0'),
(6, '5638605104', 'bcf3a0bc6c', '2026/07/13 17:12:04', '2026/07/13 18:47:57', '100000', NULL, 'cart to cart', 'paid', NULL, 2477, '0|0'),
(7, '800295915', 'c252b71a92', '2026/07/13 19:58:06', NULL, '100000', NULL, 'add balance by admin', 'paid', NULL, NULL, NULL),
(8, '96352304', '0e7aa8378f', '2026/07/27 22:18:12', NULL, '100000', NULL, 'cart to cart', 'Unpaid', NULL, 3675, '0|0'),
(9, '6824090864', '190f2cf187', '2026/07/28 23:24:57', '2026/07/28 23:28:26', '100000', NULL, 'cart to cart', 'paid', NULL, 3870, '0|0'),
(10, '800295915', '7920db98b4', '2026/07/29 15:14:51', '2026/07/29 15:15:56', '100000', NULL, 'cart to cart', 'paid', NULL, 4661, '0|0'),
(11, '800295915', 'bd1782b87d', '2026/08/11 02:23:03', '2026/08/11 02:24:13', '100000', NULL, 'cart to cart', 'paid', NULL, 4989, '0|0'),
(12, '385721417', '7ecf8bb5ac', '2026/08/12 21:46:13', '2026/08/12 21:48:06', '100000', NULL, 'cart to cart', 'paid', NULL, 5057, '0|0'),
(13, '5974770955', 'c6be26239e', '2026/08/18 22:41:29', '2026/08/18 22:44:29', '100000', NULL, 'cart to cart', 'paid', NULL, 5306, 'getconfigafterpay|asal_scorpion_13_101'),
(14, '5638605104', '6b7890caec', '2026/08/22 18:15:00', '2026/08/22 18:17:54', '110000', NULL, 'cart to cart', 'paid', NULL, 5371, 'getconfigafterpay|bot_102'),
(15, '8896300877', '5174ee8649', '2026/08/27 01:34:13', NULL, '526000', NULL, 'cart to cart', 'Unpaid', NULL, 5531, 'getconfigafterpay|zoroking2026_100'),
(16, '8636394298', '77a97be07a', '2026/08/27 22:27:47', NULL, '350000', NULL, 'add balance by admin', 'paid', NULL, NULL, NULL);

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

--
-- Table structure for table `PaySetting`
--

CREATE TABLE `PaySetting` (
  `NamePay` varchar(500) NOT NULL,
  `ValuePay` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `PaySetting`
--

INSERT INTO `PaySetting` (`NamePay`, `ValuePay`) VALUES
('apiiranpay', '0'),
('apinowpayment', '0'),
('apiternado', '0'),
('autoconfirmcart', 'offauto'),
('cardnumber', '603700000000'),
('CartDirect', '@king_service2'),
('Cartstatus', 'oncard'),
('Cartstatuspv', 'offcardpv'),
('cashbacknowpayment', '0'),
('chashbackaqaypardokht', '0'),
('chashbackcart', '0'),
('chashbackiranpay1', '0'),
('chashbackiranpay2', '0'),
('chashbackiranpay3', '0'),
('chashbackperfect', '0'),
('chashbackplisio', '0'),
('chashbackstar', '0'),
('chashbackzarinpal', '0'),
('checkpaycartfirst', 'offpayverify'),
('digistatus', 'offdigi'),
('Exception_auto_cart', '{}'),
('helpaqayepardakht', '2'),
('helpcart', '2'),
('helpiranpay1', '2'),
('helpiranpay2', '2'),
('helpiranpay3', '2'),
('helpnowpayment', '2'),
('helpofflinearze', '2'),
('helpperfectmony', '2'),
('helpplisio', '2'),
('helpstar', '2'),
('helpzarinpal', '2'),
('marchent_floypay', '0'),
('marchent_tronseller', '0'),
('maxbalance', '{\"f\":\"1000000\",\"n\":\"1000000\",\"n2\":\"1000000\"}'),
('maxbalanceaqayepardakht', '1000000'),
('maxbalancecart', '1000000'),
('maxbalancedigitaltron', '1000000'),
('maxbalanceiranpay', '1000000'),
('maxbalanceiranpay1', '1000000'),
('maxbalanceiranpay2', '1000000'),
('maxbalancenowpayment', '1000000'),
('maxbalancepaynotverify', '1000000'),
('maxbalanceperfect', '1000000'),
('maxbalanceplisio', '1000000'),
('maxbalancestar', '1000000'),
('maxbalancezarinpal', '1000000'),
('merchant_id_aqayepardakht', '0'),
('merchant_zarinpal', '0'),
('minbalance', '{\"f\":\"100000\",\"n\":\"20000\",\"n2\":\"20000\"}'),
('minbalanceaqayepardakht', '20000'),
('minbalancecart', '100000'),
('minbalancedigitaltron', '20000'),
('minbalanceiranpay', '20000'),
('minbalanceiranpay1', '20000'),
('minbalanceiranpay2', '20000'),
('minbalancenowpayment', '20000'),
('minbalancepaynotverify', '20000'),
('minbalanceperfect', '20000'),
('minbalanceplisio', '20000'),
('minbalancestar', '20000'),
('minbalancezarinpal', '20000'),
('namecard', 'تنظیم نشده'),
('nowpaymentstatus', 'offnowpayment'),
('statusaqayepardakht', 'offaqayepardakht'),
('statusiranpay3', 'offiranpay3'),
('statusnowpayment', '0'),
('statusstar', '0'),
('statusSwapWallet', 'offSwapinoBot'),
('statustarnado', 'offternado'),
('urlpaymenttron', 'https://tronseller.storeddownloader.fun/api/GetOrderToken'),
('walletaddress', '0'),
('zarinpalstatus', 'offzarinpal');

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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id` int(6) UNSIGNED NOT NULL,
  `code_product` varchar(200) DEFAULT NULL,
  `name_product` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `price_product` varchar(2000) DEFAULT NULL,
  `Volume_constraint` varchar(2000) DEFAULT NULL,
  `Location` varchar(200) DEFAULT NULL,
  `Service_time` varchar(200) DEFAULT NULL,
  `agent` varchar(100) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `data_limit_reset` varchar(200) DEFAULT NULL,
  `one_buy_status` varchar(20) NOT NULL,
  `inbounds` text DEFAULT NULL,
  `proxies` text DEFAULT NULL,
  `category` varchar(400) DEFAULT NULL,
  `hide_panel` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`id`, `code_product`, `name_product`, `price_product`, `Volume_constraint`, `Location`, `Service_time`, `agent`, `note`, `data_limit_reset`, `one_buy_status`, `inbounds`, `proxies`, `category`, `hide_panel`) VALUES
(1, '62ef', '10 گیگ', '70000', '10', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '30', 'f', 'پینگ پایین و سرعت بالا مخصوص وبگردی و ترید و یوتیوب و اینستاگرام', 'no_reset', '0', NULL, NULL, 'یکماهه', '{}'),
(2, '2ca4', '20 گیگ', '140000', '20', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '30', 'f', 'پینگ پایین و سرعت بالا مخصوص وبگردی و ترید و یوتیوب و اینستاگرام', 'no_reset', '0', NULL, NULL, 'یکماهه', '{}'),
(3, '21a7', '30 گیگ', '210000', '30', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '30', 'f', 'پینگ پایین و سرعت بالا مخصوص وبگردی و ترید و یوتیوب و اینستاگرام', 'no_reset', '0', NULL, NULL, 'یکماهه', '{}'),
(4, 'bc9b', '10گیگ', '80000', '10', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '60', 'f', 'پینگ پایین و سرعت بالا مخصوص وبگردی و ترید و یوتیوب و اینستاگرام', 'no_reset', '0', NULL, NULL, 'دوماهه', '{}'),
(5, '3787', '20گیگ', '160000', '20', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '60', 'f', 'پینگ پایین و سرعت بالا مخصوص وبگردی و ترید و یوتیوب و اینستاگرام', 'no_reset', '0', NULL, NULL, 'دوماهه', '{}'),
(6, 'b665', '30گیگ', '240000', '30', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '60', 'f', 'پینگ پایین و سرعت بالا مخصوص وبگردی و ترید و یوتیوب و اینستاگرام', 'no_reset', '0', NULL, NULL, 'دوماهه', '{}'),
(7, '67e1', '10_گیگ', '90000', '10', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '90', 'f', 'پینگ پایین و سرعت بالا مخصوص وبگردی و ترید و یوتیوب و اینستاگرام', 'no_reset', '0', NULL, NULL, 'سه ماهه', '{}'),
(8, 'f977', '20_گیگ', '180000', '20', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '90', 'f', 'پینگ پایین و سرعت بالا مخصوص وبگردی و ترید و یوتیوب و اینستاگرام', 'no_reset', '0', NULL, NULL, 'سه ماهه', '{}'),
(9, '024d', '30_گیگ', '270000', '30', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '90', 'f', 'پینگ پایین و سرعت بالا مخصوص وبگردی و ترید و یوتیوب و اینستاگرام', 'no_reset', '0', NULL, NULL, 'سه ماهه', '{}'),
(10, 'd27c', '10-گیگ', '100000', '10', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '99999', 'f', 'پینگ پایین و سرعت بالا مخصوص وبگردی و ترید و یوتیوب و اینستاگرام', 'no_reset', '0', NULL, NULL, 'نامحدود', '{}'),
(11, '89c2', '20-گیگ', '200000', '20', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '99999', 'f', 'پینگ پایین و سرعت بالا مخصوص وبگردی و ترید و یوتیوب و اینستاگرام', 'no_reset', '0', NULL, NULL, 'نامحدود', '{}'),
(12, 'c602', '30-گیگ', '300000', '30', 'اقتصادی 🇩🇪 🇲🇫 🇬🇧', '99999', 'f', 'پینگ پایین و سرعت بالا مخصوص وبگردی و ترید و یوتیوب و اینستاگرام', 'no_reset', '0', NULL, NULL, 'نامحدود', '{}'),
(13, '37e3', '10 GB', '100000', '10', 'اختصاصی 🇮🇷 🇩🇪 🇺🇲 🇹🇷 🇦🇪 🇨🇦', '30', 'f', 'تانل شده و دارای لوکیشنهای تانل ایران المان . امریکا . دبی . ترکیه', 'no_reset', '0', NULL, NULL, 'یک ماهه', '{}');

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

--
-- Table structure for table `reagent_report`
--

CREATE TABLE `reagent_report` (
  `id` int(6) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `get_gift` tinyint(1) NOT NULL,
  `time` varchar(50) NOT NULL,
  `reagent` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `reagent_report`
--

INSERT INTO `reagent_report` (`id`, `user_id`, `get_gift`, `time`, `reagent`) VALUES
(1, 6185717419, 1, '2026/07/15 00:44:00', '96352304'),
(2, 5530105789, 0, '2026/07/16 19:07:46', '96352304'),
(3, 8479970028, 0, '2026/07/16 20:47:07', '96352304'),
(4, 8451031002, 0, '2026/07/19 22:31:31', '96352304'),
(5, 510244832, 0, '2026/08/13 08:49:06', '96352304'),
(6, 8636394298, 0, '2026/08/27 21:39:45', '96352304');

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

--
-- Table structure for table `Requestagent`
--

CREATE TABLE `Requestagent` (
  `id` varchar(500) NOT NULL,
  `username` varchar(500) NOT NULL,
  `time` varchar(500) NOT NULL,
  `Description` varchar(500) NOT NULL,
  `status` varchar(500) NOT NULL,
  `type` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Requestagent`
--

INSERT INTO `Requestagent` (`id`, `username`, `time`, `Description`, `status`, `type`) VALUES
('6812221987', 'Hajiesmaeily', '1783844347', 'ایمان', 'accept', 'n2');

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

--
-- Table structure for table `service_other`
--

CREATE TABLE `service_other` (
  `id` int(6) UNSIGNED NOT NULL,
  `id_user` varchar(500) NOT NULL,
  `username` varchar(1000) NOT NULL,
  `value` varchar(1000) NOT NULL,
  `time` varchar(200) NOT NULL,
  `price` varchar(200) NOT NULL,
  `type` varchar(1000) NOT NULL,
  `status` varchar(200) NOT NULL,
  `output` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `service_other`
--

INSERT INTO `service_other` (`id`, `id_user`, `username`, `value`, `time`, `price`, `type`, `status`, `output`) VALUES
(1, '800295915', 'mohsen_tm_07_101', '{\"volumebuy\":\"10\",\"Service_time\":\"30\",\"oldvolume\":10737418240,\"oldtime\":1786566600,\"code_product\":\"62ef\",\"id_order\":\"33c9\"}', '2026/07/29 15:14:13', '70000', 'extend_user', 'unpaid', ''),
(2, '800295915', 'mohsen_tm_07_101', '{\"volumebuy\":\"10\",\"Service_time\":\"30\",\"oldvolume\":10737418240,\"oldtime\":1786566600,\"code_product\":\"62ef\",\"id_order\":\"04e7\"}', '2026/07/29 15:16:47', '70000', 'extend_user', 'unpaid', ''),
(3, '800295915', 'mohsen_tm_07_101', '{\"volumebuy\":\"10\",\"Service_time\":\"30\",\"oldvolume\":10737418240,\"oldtime\":1786566600,\"code_product\":\"62ef\",\"id_order\":\"3002\"}', '2026/07/29 15:31:35', '70000', 'extend_user', 'paid', '{\"status\":true,\"data\":{\"added_by_uuid\":\"6a630fc9-f161-42d8-b8ad-bb01b26163e1\",\"comment\":\"800295915 | Mohsen_tm_07 | buy\",\"current_usage_GB\":10.015408439561725,\"ed25519_private_key\":\"-----BEGIN OPENSSH PRIVATE KEY-----\\nb3BlbnNzaC1rZXktdjEAAAAABG5vbmUAAAAEbm9uZQAAAAAAAAABAAAAMwAAAAtzc2gtZWQyNTUx\\nOQAAACAutk5OrmV+Tu8VmV9IjUPLYALBw8+95vjwa+FAY7VTpAAAAIg8ufWPPLn1jwAAAAtzc2gt\\nZWQyNTUxOQAAACAutk5OrmV+Tu8VmV9IjUPLYALBw8+95vjwa+FAY7VTpAAAAEDxQgyQ01J+k7CR\\nVkrOMjR9aZ+35dn7WED3hvwwRAyqsS62Tk6uZX5O7xWZX0iNQ8tgAsHDz73m+PBr4UBjtVOkAAAA\\nAAECAwQF\\n-----END OPENSSH PRIVATE KEY-----\\n\",\"ed25519_public_key\":\"ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIC62Tk6uZX5O7xWZX0iNQ8tgAsHDz73m+PBr4UBjtVOk\",\"enable\":true,\"id\":564,\"is_active\":true,\"lang\":\"fa\",\"last_online\":\"2026-07-29 15:15:01\",\"last_reset_time\":\"2026-07-11 00:00:00\",\"mode\":\"no_reset\",\"name\":\"mohsen_tm_07_101\",\"package_days\":44,\"start_date\":null,\"telegram_id\":null,\"usage_limit_GB\":20,\"uuid\":\"a50c8e21-e7a7-46df-9e09-f13fac3db684\",\"wg_pk\":\"cEDto3LmmOU+QQ8y1Li9h39FhhvIMw3G0jhle8\\/xxHA=\",\"wg_psk\":\"DsMgK0UjJDcndaa+2fkx4duIkLY8w\\/aNfHMQIXB8NQI=\",\"wg_pub\":\"UyMlh0dFceUqR0A0zp8iNsY6r15qXyOT7J91TGJv5XE=\"}}'),
(4, '800295915', 'mohsen_tm_07_101', '{\"volumebuy\":\"20\",\"Service_time\":\"30\",\"oldvolume\":21474836480,\"oldtime\":1789072200,\"code_product\":\"2ca4\",\"id_order\":\"5626\"}', '2026/08/11 02:22:17', '140000', 'extend_user', 'unpaid', ''),
(5, '800295915', 'mohsen_tm_07_101', '{\"volumebuy\":\"20\",\"Service_time\":\"30\",\"oldvolume\":21474836480,\"oldtime\":1789072200,\"code_product\":\"2ca4\",\"id_order\":\"f25b\"}', '2026/08/11 12:57:07', '140000', 'extend_user', 'paid', '{\"status\":true,\"data\":{\"added_by_uuid\":\"6a630fc9-f161-42d8-b8ad-bb01b26163e1\",\"comment\":\"800295915 | Mohsen_tm_07 | buy\",\"current_usage_GB\":20.01200204435736,\"ed25519_private_key\":\"-----BEGIN OPENSSH PRIVATE KEY-----\\nb3BlbnNzaC1rZXktdjEAAAAABG5vbmUAAAAEbm9uZQAAAAAAAAABAAAAMwAAAAtzc2gtZWQyNTUx\\nOQAAACAutk5OrmV+Tu8VmV9IjUPLYALBw8+95vjwa+FAY7VTpAAAAIg8ufWPPLn1jwAAAAtzc2gt\\nZWQyNTUxOQAAACAutk5OrmV+Tu8VmV9IjUPLYALBw8+95vjwa+FAY7VTpAAAAEDxQgyQ01J+k7CR\\nVkrOMjR9aZ+35dn7WED3hvwwRAyqsS62Tk6uZX5O7xWZX0iNQ8tgAsHDz73m+PBr4UBjtVOkAAAA\\nAAECAwQF\\n-----END OPENSSH PRIVATE KEY-----\\n\",\"ed25519_public_key\":\"ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIC62Tk6uZX5O7xWZX0iNQ8tgAsHDz73m+PBr4UBjtVOk\",\"enable\":true,\"id\":564,\"is_active\":true,\"lang\":\"fa\",\"last_online\":\"2026-08-10 21:20:01\",\"last_reset_time\":\"2026-07-11 00:00:00\",\"mode\":\"no_reset\",\"name\":\"mohsen_tm_07_101\",\"package_days\":60,\"start_date\":null,\"telegram_id\":null,\"usage_limit_GB\":40,\"uuid\":\"a50c8e21-e7a7-46df-9e09-f13fac3db684\",\"wg_pk\":\"cEDto3LmmOU+QQ8y1Li9h39FhhvIMw3G0jhle8\\/xxHA=\",\"wg_psk\":\"DsMgK0UjJDcndaa+2fkx4duIkLY8w\\/aNfHMQIXB8NQI=\",\"wg_pub\":\"UyMlh0dFceUqR0A0zp8iNsY6r15qXyOT7J91TGJv5XE=\"}}');

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

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `Bot_Status` varchar(200) DEFAULT NULL,
  `roll_Status` varchar(200) DEFAULT NULL,
  `get_number` varchar(200) DEFAULT NULL,
  `iran_number` varchar(200) DEFAULT NULL,
  `NotUser` varchar(200) DEFAULT NULL,
  `Channel_Report` varchar(600) DEFAULT NULL,
  `limit_usertest_all` varchar(600) DEFAULT NULL,
  `affiliatesstatus` varchar(600) DEFAULT NULL,
  `affiliatespercentage` varchar(600) DEFAULT NULL,
  `removedayc` varchar(600) DEFAULT NULL,
  `showcard` varchar(200) DEFAULT NULL,
  `numbercount` varchar(600) DEFAULT NULL,
  `statusnewuser` varchar(600) DEFAULT NULL,
  `statusagentrequest` varchar(600) DEFAULT NULL,
  `statuscategory` varchar(200) DEFAULT NULL,
  `statusterffh` varchar(200) DEFAULT NULL,
  `volumewarn` varchar(200) DEFAULT NULL,
  `inlinebtnmain` varchar(200) DEFAULT NULL,
  `verifystart` varchar(200) DEFAULT NULL,
  `id_support` varchar(200) DEFAULT NULL,
  `statusnamecustom` varchar(100) DEFAULT NULL,
  `statuscategorygenral` varchar(100) DEFAULT NULL,
  `statussupportpv` varchar(100) DEFAULT NULL,
  `agentreqprice` varchar(100) DEFAULT NULL,
  `bulkbuy` varchar(100) DEFAULT NULL,
  `on_hold_day` varchar(100) DEFAULT NULL,
  `cronvolumere` varchar(100) DEFAULT NULL,
  `verifybucodeuser` varchar(100) DEFAULT NULL,
  `scorestatus` varchar(100) DEFAULT NULL,
  `Lottery_prize` text DEFAULT NULL,
  `wheelـluck` varchar(45) DEFAULT NULL,
  `wheelـluck_price` varchar(45) DEFAULT NULL,
  `btn_status_extned` varchar(45) DEFAULT NULL,
  `daywarn` varchar(45) DEFAULT NULL,
  `categoryhelp` varchar(45) DEFAULT NULL,
  `linkappstatus` varchar(45) DEFAULT NULL,
  `wheelagent` varchar(45) DEFAULT NULL,
  `Lotteryagent` varchar(45) DEFAULT NULL,
  `statusfirstwheel` varchar(45) DEFAULT NULL,
  `statuslimitchangeloc` varchar(45) DEFAULT NULL,
  `Debtsettlement` varchar(45) DEFAULT NULL,
  `Dice` varchar(45) DEFAULT NULL,
  `keyboardmain` text NOT NULL,
  `statusnoteforf` varchar(45) NOT NULL,
  `statuscopycart` varchar(45) NOT NULL,
  `timeauto_not_verify` varchar(20) NOT NULL,
  `status_keyboard_config` varchar(20) DEFAULT NULL,
  `cron_status` text NOT NULL,
  `text_edit` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`text_edit`)),
  `limitnumber` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`Bot_Status`, `roll_Status`, `get_number`, `iran_number`, `NotUser`, `Channel_Report`, `limit_usertest_all`, `affiliatesstatus`, `affiliatespercentage`, `removedayc`, `showcard`, `numbercount`, `statusnewuser`, `statusagentrequest`, `statuscategory`, `statusterffh`, `volumewarn`, `inlinebtnmain`, `verifystart`, `id_support`, `statusnamecustom`, `statuscategorygenral`, `statussupportpv`, `agentreqprice`, `bulkbuy`, `on_hold_day`, `cronvolumere`, `verifybucodeuser`, `scorestatus`, `Lottery_prize`, `wheelـluck`, `wheelـluck_price`, `btn_status_extned`, `daywarn`, `categoryhelp`, `linkappstatus`, `wheelagent`, `Lotteryagent`, `statusfirstwheel`, `statuslimitchangeloc`, `Debtsettlement`, `Dice`, `keyboardmain`, `statusnoteforf`, `statuscopycart`, `timeauto_not_verify`, `status_keyboard_config`, `cron_status`, `text_edit`, `limitnumber`) VALUES
('botstatuson', 'rolleon', 'onAuthenticationphone', 'onAuthenticationiran', 'onnotuser', '-1004336885092', '1', 'onaffiliates', '5', '0', '1', '0', 'offnewuser', 'onrequestagent', 'offcategory', NULL, '1', 'offinline', 'offverify', '@king_service2', 'onnamecustom', 'oncategorys', 'onpvsupport', '1500000', 'onbulk', '4', '5', 'onverify', '0', '{\"one\":\"0\",\"tow\":\"0\",\"theree\":\"0\"}', '1', '5000', NULL, '2', '1', '1', '1', '0', '1', '1', '1', '1', '{\"keyboard\":[[{\"text\":\"text_sell\"},{\"text\":\"text_extend\"}],[{\"text\":\"text_usertest\"},{\"text\":\"text_wheel_luck\"}],[{\"text\":\"text_Purchased_services\"},{\"text\":\"accountwallet\"}],[{\"text\":\"text_affiliates\"},{\"text\":\"text_Tariff_list\"}],[{\"text\":\"text_support\"},{\"text\":\"text_help\"}]]}', '1', '1', '1', '1', '{\"day\":true,\"volume\":true,\"remove\":false,\"remove_volume\":false,\"test\":false,\"on_hold\":false,\"uptime_node\":false,\"uptime_panel\":true}', '{\"fa\":{\"textbot\":{\"tariffListDesc\":\"❗توجه      ❗ توجه\\n\\n🏦 تعرفه اشتراکها ربات\\n\\n💵 🥉 قیمت هر گیگ کاربر عادی 7.000 تومان\\n\\n💵🥈قیمت هر گیگ نماینده عادی 5.000 تومان\\n\\n💵 🥇 قیمت هرگیگ نماینده ویژه 4.000 تومان\\n\\n🏢 قیمت درخواست نمایندگی عادی 1.500.000 تومان\\n\\n🏢 قیمت درخواست نمایندگی ویژه \\n2.000.000 تومان\",\"affiliates\":\"👥 زیر مجموعه گیری\",\"faqDesc\":\"💡 سوالات متداول ⁉️\\n\\n1️⃣ فیلترشکن شما آیپی ثابته؟ میتونم برای صرافی های ارز دیجیتال استفاده کنم؟\\n\\n✅ بله کاملا دارای لوکیشن ثابت و ip ثابت میباشد.\\n\\n2️⃣ اگه قبل از منقضی شدن اکانت، تمدیدش کنم روزهای باقی مانده می سوزد؟\\n\\n✅ خیر، روزهای باقیمونده اکانت موقع تمدید حساب میشن و اگه مثلا 5 روز قبل از منقضی شدن اکانت 1 ماهه خودتون اون رو تمدید کنید 5 روز باقیمونده + 30 روز تمدید میشه.\\n\\n3️⃣ اگه به یک اکانت بیشتر از حد مجاز متصل شیم چه اتفاقی میافته؟\\n\\n✅ در این صورت حجم سرویس شما زود تمام خواهد شد.\\n\\n4️⃣ فیلترشکن شما از چه نوعیه؟\\n\\n✅ فیلترشکن های ما v2ray است و پروتکل‌های مختلفی رو ساپورت میکنیم تا حتی تو دورانی که اینترنت اختلال داره بدون مشکل و افت سرعت بتونید از سرویستون استفاده کنید.\\n\\n5️⃣ فیلترشکن از کدوم کشور است؟\\n\\n✅ سرور فیلترشکن ما از کشور  آلمان و فرانسه است\\n\\n6️⃣ چطور باید از این فیلترشکن استفاده کنم؟\\n\\n✅ برای آموزش استفاده از برنامه، روی دکمه «📚 آموزش» بزنید.\\n\\n7️⃣ فیلترشکن وصل نمیشه، چیکار کنم؟\\n\\n✅ به همراه یک عکس از پیغام خطایی که میگیرید به پشتیبانی مراجعه کنید.\\n\\n8️⃣ فیلترشکن شما تضمینی هست که همیشه مواقع متصل بشه؟\\n\\n✅ به دلیل قابل پیش‌بینی نبودن وضعیت نت کشور، امکان دادن تضمین نیست فقط می‌تونیم تضمین کنیم که تمام تلاشمون رو برای ارائه سرویس هر چه بهتر انجام بدیم.\\n\\n9️⃣ امکان بازگشت وجه دارید؟\\n\\n✅ امکان بازگشت وجه در صورت حل نشدن مشکل از سمت ما وجود دارد.\\n\\n💡 در صورتی که جواب سوالتون رو نگرفتید میتونید به «پشتیبانی» مراجعه کنید.\"}}}', '{\"free\":0,\"all\":1}');

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

--
-- Table structure for table `shopSetting`
--

CREATE TABLE `shopSetting` (
  `Namevalue` varchar(500) NOT NULL,
  `value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shopSetting`
--

INSERT INTO `shopSetting` (`Namevalue`, `value`) VALUES
('backserviecstatus', 'off'),
('chashbackextend', '0'),
('chashbackextend_agent', '{\"n\":0,\"n2\":0}'),
('configshow', 'onconfig'),
('customtimepricef', '4000'),
('customtimepricen', '4000'),
('customtimepricen2', '4000'),
('customvolmef', '4000'),
('customvolmen', '4000'),
('customvolmen2', '4000'),
('minbalancebuybulk', '500000'),
('statuschangeservice', 'offstatus'),
('statusdirectpabuy', 'ondirectbuy'),
('statusdisorder', 'ondisorder'),
('statusextra', 'onextra'),
('statusshowprice', 'onshowprice'),
('statustimeextra', 'ontimeextraa');

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

--
-- Table structure for table `support_message`
--

CREATE TABLE `support_message` (
  `id` int(6) UNSIGNED NOT NULL,
  `Tracking` varchar(100) NOT NULL,
  `idsupport` varchar(100) NOT NULL,
  `iduser` varchar(100) NOT NULL,
  `name_departman` varchar(600) NOT NULL,
  `text` text NOT NULL,
  `result` text NOT NULL,
  `time` varchar(200) NOT NULL,
  `status` enum('Answered','Pending','Unseen','Customerresponse','close') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `topicid`
--

CREATE TABLE `topicid` (
  `report` varchar(500) NOT NULL,
  `idreport` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `topicid`
--

INSERT INTO `topicid` (`report`, `idreport`) VALUES
('backupfile', '21'),
('buyreport', '12'),
('errorreport', '16'),
('otherreport', '15'),
('otherservice', '13'),
('paymentreport', '17'),
('porsantreport', '18'),
('reportcron', '20'),
('reportnight', '19'),
('reporttest', '14');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` varchar(500) NOT NULL,
  `limit_usertest` int(100) NOT NULL,
  `roll_Status` tinyint(1) NOT NULL,
  `username` varchar(500) NOT NULL,
  `Processing_value` text NOT NULL,
  `Processing_value_one` text NOT NULL,
  `Processing_value_tow` text NOT NULL,
  `Processing_value_four` text NOT NULL,
  `step` varchar(500) NOT NULL,
  `description_blocking` text DEFAULT NULL,
  `number` varchar(300) NOT NULL,
  `Balance` int(255) NOT NULL,
  `User_Status` varchar(500) NOT NULL,
  `pagenumber` int(10) NOT NULL,
  `message_count` varchar(100) NOT NULL,
  `last_message_time` varchar(100) NOT NULL,
  `agent` varchar(100) NOT NULL,
  `affiliatescount` varchar(100) NOT NULL,
  `affiliates` varchar(100) NOT NULL,
  `namecustom` varchar(300) NOT NULL,
  `number_username` varchar(300) NOT NULL,
  `register` varchar(100) NOT NULL,
  `verify` varchar(100) NOT NULL,
  `cardpayment` varchar(100) NOT NULL,
  `codeInvitation` varchar(100) DEFAULT NULL,
  `pricediscount` varchar(100) DEFAULT '0',
  `hide_mini_app_instruction` varchar(20) DEFAULT '0',
  `maxbuyagent` varchar(100) DEFAULT '0',
  `joinchannel` varchar(100) DEFAULT '0',
  `checkstatus` varchar(50) DEFAULT '0',
  `bottype` text DEFAULT NULL,
  `score` int(255) DEFAULT 0,
  `limitchangeloc` varchar(50) DEFAULT '0',
  `status_cron` varchar(20) DEFAULT '1',
  `expire` varchar(100) DEFAULT NULL,
  `token` varchar(100) DEFAULT NULL,
  `lang` varchar(5) DEFAULT 'fa'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `limit_usertest`, `roll_Status`, `username`, `Processing_value`, `Processing_value_one`, `Processing_value_tow`, `Processing_value_four`, `step`, `description_blocking`, `number`, `Balance`, `User_Status`, `pagenumber`, `message_count`, `last_message_time`, `agent`, `affiliatescount`, `affiliates`, `namecustom`, `number_username`, `register`, `verify`, `cardpayment`, `codeInvitation`, `pricediscount`, `hide_mini_app_instruction`, `maxbuyagent`, `joinchannel`, `checkstatus`, `bottype`, `score`, `limitchangeloc`, `status_cron`, `expire`, `token`, `lang`) VALUES
('110383030', 1, 1, 'ykxykdyodoyx', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '1', '1784362909', 'f', '0', '0', 'none', '100', '1784362848', '1', '1', '2023121d614e', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('114993749', 1, 1, 'sayah_m_1990', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '1', '1783878771', 'f', '0', '0', 'none', '100', '1783878334', '1', '1', 'f2d9f1925fda', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('1348937029', 0, 1, 'Hsntbkh', '{\"nameconfig\":\"\\u0644\\u062f\\u0628\",\"name_panel\":\"\\u0627\\u0642\\u062a\\u0635\\u0627\\u062f\\u06cc \\ud83c\\udde9\\ud83c\\uddea \\ud83c\\uddf2\\ud83c\\uddeb \\ud83c\\uddec\\ud83c\\udde7\"}', '0', '0', '0', 'home', NULL, '989381539441', 0, 'Active', 1, '4', '1788118057', 'f', '0', '0', 'none', '101', '1788061210', '1', '1', 'cd6e9123e48b', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('1793987182', 1, 1, 'Ali_fatehi_org', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '1', '1783878777', 'f', '0', '0', 'none', '100', '1783817034', '1', '1', 'd4586c5a5bb8', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('180695954', 1, 1, 'Eh3an111', '', '', '', '', 'get_number', NULL, 'none', 0, 'Active', 1, '1', '1786735422', 'f', '0', '0', 'none', '100', '1786735326', '1', '1', 'bff1180f2640', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('1876420099', 0, 1, 'Ali_8fAA', '', '', '', '', 'home', NULL, '989198350479', 0, 'Active', 1, '8', '1788160083', 'f', '0', '0', 'none', '101', '1788160083', '1', '1', '78c87c45dcda', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('2145474169', 1, 1, 'eze1363', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '1', '1787174381', 'f', '0', '0', 'none', '100', '1787174318', '1', '1', 'df3e4724b5af', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('225313906', 1, 1, 'ReZa_8309', '', '', '', '', 'get_number', NULL, 'none', 0, 'Active', 1, '6', '1784559275', 'f', '0', '0', 'none', '100', '1784559274', '1', '1', '8bc13ff65924', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('308896062', 0, 1, 'mrd1606', '', '', '', '', 'home', NULL, '989155801606', 0, 'Active', 1, '6', '1788134457', 'f', '0', '0', 'none', '101', '1788134457', '1', '1', '8bb3f67089a0', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('353092814', 1, 1, 'amin_ziyaei7169', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '2', '1784051995', 'f', '0', '0', 'none', '100', '1784051995', '1', '1', '8b4cee6bb832', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('385721417', 0, 1, 'Hosseinbazmara', '{\"nameconfig\":\"\\u062d\\u0633\\u06cc\\u0646\",\"name_panel\":\"\\u0645\\u0648\\u0644\\u062a\\u06cc \\u0644\\u0648\\u06a9\\u06cc\\u0634\\u0646 \\ud83c\\uddf2\\ud83c\\uddeb \\u0641\\u0631\\u0627\\u0646\\u0633\\u0647 \\ud83c\\udde9\\ud83c\\uddea \\u0622\\u0644\\u0645\\u0627\\u0646\"}', '62ef', '7586835_hosseinbazmara_101', 'none', 'home', NULL, '989150734277', 30000, 'Active', 1, '1', '1786560114', 'f', '0', '0', 'none', '102', '1786556553', '1', '1', '83b966d45724', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('391871984', 1, 1, 'Shahram_moeini', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '2', '1784097059', 'f', '0', '0', 'none', '100', '1784096990', '1', '1', '8fcbeb4b6b83', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('439251807', 1, 1, 'Shopifytrend1', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '3', '1784091060', 'f', '0', '0', 'none', '100', '1784091060', '1', '1', 'dd9eb4daab07', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('459366484', 1, 0, 'Farhad0325', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '1', '1784050058', 'f', '0', '0', 'none', '100', '1784050058', '1', '1', '11a1921a57f8', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('5071926394', 1, 1, 'sajadbabai', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '2', '1784278960', 'f', '0', '0', 'none', '100', '1784278960', '1', '1', '7e2767b16025', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('510244832', 0, 1, 'Mojtaba7459', '0', '0', '0', '0', 'statusnamecustom', NULL, '989158852017', 0, 'Active', 1, '2', '1786653026', 'f', '0', '96352304', 'none', '101', '1786598345', '1', '1', 'ad2d42dc3554', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('5406561903', 1, 0, 'RezaSoleimanpour0546', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '1', '1784060066', 'f', '0', '0', 'none', '100', '1784060066', '0', '1', 'b789cdcc1f07', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('5530105789', 1, 1, 'NOT_USERNAME', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '1', '1784216431', 'f', '0', '96352304', 'none', '100', '1784216266', '1', '1', '5b3de5ec4479', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('5542399128', 1, 1, 'Software447', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '2', '1784061088', 'f', '0', '0', 'none', '100', '1784042598', '1', '1', '5c6339c39dc3', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('5638605104', 1, 1, 'NOT_USERNAME', '0', 'none', 'none', 'none', 'home', NULL, '989337853784', 0, 'Active', 1, '1', '1787410072', 'f', '0', '0', 'none', '103', '1783817101', '1', '1', 'e2b183feeb6b', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('5725694835', 1, 1, 'NOT_USERNAME', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '1', '1788139278', 'f', '0', '0', 'none', '100', '1788139209', '1', '1', '7919d6422c81', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('5897784795', 1, 1, 'Amiriiiish', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '1', '1783591108', 'f', '0', '0', 'none', '100', '1783554976', '1', '1', '544c88b01ffb', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('5974770955', 0, 1, 'Asal_Scorpion_13', '0', 'none', 'none', 'none', 'home', NULL, '989365814294', 0, 'Active', 1, '2', '1787080429', 'f', '0', '0', 'none', '102', '1787077908', '1', '1', '8697c4bc1d8c', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('6016243903', 1, 1, 'Er3244', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '2', '1788123239', 'f', '0', '0', 'none', '100', '1788123239', '1', '1', '9e3876ed1e08', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('6090350536', 1, 1, 'Mhmd_mfr', '0', '0', '0', '0', 'home', NULL, '989362211318', 0, 'Active', 1, '2', '1785262218', 'f', '0', '0', 'none', '100', '1785262151', '1', '1', 'a41f3b6c07b1', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('6185717419', 1, 1, 'peterj1982', '0', '0', '0', '0', 'home', NULL, '989391478149', 2500, 'Active', 2, '1', '1784867401', 'f', '0', '96352304', 'none', '100', '1783556456', '1', '1', '9cb9b4f5c54d', '0', '1', '0', 'active', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('627333288', 1, 1, 'NOT_USERNAME', '0', '0', '0', '0', 'get_number', NULL, 'none', 0, 'Active', 1, '1', '1786232591', 'f', '0', '0', 'none', '100', '1786232529', '1', '1', 'a86302bc5307', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('6279576671', 1, 1, 'Qaws098', '0', '0', '0', '0', 'home', NULL, '989356937228', 0, 'Active', 1, '1', '1784144635', 'f', '0', '0', 'none', '101', '1784144111', '1', '1', 'c60c736c64c9', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('6601842270', 1, 1, 'Saeid_rezaei72', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '5', '1784927508', 'f', '0', '0', 'none', '100', '1784927508', '1', '1', '430be06535e0', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('664573685', 1, 1, 'inkesame1', '', '', '', '', 'get_number', NULL, 'none', 0, 'Active', 1, '6', '1785039370', 'f', '0', '0', 'none', '100', '1785039370', '1', '1', 'd3e27c196831', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('6779291451', 1, 1, 'NOT_USERNAME', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '2', '1786817897', 'f', '0', '0', 'none', '100', '1786817897', '1', '1', '7f0b2249d20b', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('6790946158', 0, 1, 'oiuyghjklp', '', '', '', '', 'statusnamecustom', NULL, '989339417939', 0, 'Active', 1, '3', '1785039482', 'f', '0', '0', 'none', '101', '1785039418', '1', '1', '482af3c54a03', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('6812221987', 1, 1, 'Hajiesmaeily', '{\"nameconfig\":\"\\u0627\\u06cc\\u0645\\u0627\\u0646\",\"name_panel\":\"\\ud83c\\uddf2\\ud83c\\uddeb France \\ud83c\\uddf2\\ud83c\\uddeb\"}', '0', '0', '0', 'statusnamecustom', NULL, 'confrim number by admin', 0, 'Active', 1, '4', '1784231448', 'n2', '0', '0', 'none', '100', '1783800592', '1', '1', '3efcd77c2137', '0', '0', '0', '0', '0', NULL, 0, '0', '1', '1815414724', NULL, 'fa'),
('6824090864', 1, 1, 'NOT_USERNAME', '{\"nameconfig\":\"Mori\",\"name_panel\":\"\\u0645\\u0648\\u0644\\u062a\\u06cc \\u0644\\u0648\\u06a9\\u06cc\\u0634\\u0646 \\ud83c\\uddf2\\ud83c\\uddeb \\u0641\\u0631\\u0627\\u0646\\u0633\\u0647 \\ud83c\\udde9\\ud83c\\uddea \\u0622\\u0644\\u0645\\u0627\\u0646\"}', '62ef', '4788186_bot_100', 'none', 'home', NULL, '989363348994', 30000, 'Active', 1, '1', '1785269011', 'f', '0', '0', 'none', '101', '1785268227', '1', '1', '262fb0707418', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('7363268220', 1, 1, 'hdhshsdk', '0', '0', '0', '0', 'home', NULL, '989963480097', 0, 'Active', 1, '1', '1784038082', 'n', '0', '0', 'none', '100', '1783950095', '1', '1', '423295dda546', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('7405148607', 0, 1, 'NOT_USERNAME', '0', '0', '0', '0', 'home', NULL, '989386238631', 0, 'Active', 1, '2', '1786739760', 'f', '0', '0', 'none', '101', '1786738848', '1', '1', '99b6ce80151b', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('776469659', 1, 1, 'ho899', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '2', '1784170226', 'f', '0', '0', 'none', '100', '1784062217', '1', '1', '39125b509990', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('7783664864', 1, 1, 'NOT_USERNAME', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '2', '1787931427', 'f', '0', '0', 'none', '100', '1787931427', '1', '1', '9099d2632765', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('7904332946', 0, 1, 'Nima_bingo_2026_1', '', '', '', '', 'home', NULL, '989903342874', 0, 'Active', 1, '7', '1784673645', 'f', '0', '0', 'none', '101', '1784673645', '1', '1', 'a3162052350a', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('800295915', 1, 1, 'Mohsen_tm_07', '{\"id_invoice\":\"53675343\",\"time\":\"30\",\"data_limit\":\"20\",\"price_product\":\"140000\",\"code_product\":\"2ca4\"}', 'none', 'none', 'none', 'home', NULL, '989152313073', 20000, 'Active', 1, '3', '1786440412', 'f', '0', '0', 'none', '102', '1783807446', '1', '1', 'c7f676e586e6', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('8058248266', 1, 0, 'nnnixo', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '1', '1784722707', 'f', '0', '0', 'none', '100', '1784722707', '1', '1', '017195f40dc6', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('8404360634', 1, 1, 'TANDRAX08', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '2', '1783554805', 'f', '0', '0', 'none', '100', '1783554805', '1', '1', '3fd07dd8d9e8', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('8419117410', 1, 1, 'NOT_USERNAME', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '2', '1787112664', 'f', '0', '0', 'none', '100', '1787112664', '1', '1', 'ac8e017f79fb', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('8451031002', 1, 1, 'Dr_king_mokhi', '{\"nameconfig\":\"King\",\"name_panel\":\"\\ud83c\\uddf2\\ud83c\\uddeb France \\ud83c\\uddf2\\ud83c\\uddeb\"}', '', '', '', 'home', NULL, '989133968660', 0, 'Active', 1, '1', '1784487691', 'f', '0', '96352304', 'none', '101', '1784296963', '1', '1', '0b70d5716fbf', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('8479970028', 1, 0, 'modena_gallery11', '', '', '', '', 'none', NULL, 'confrim number by admin', 0, 'Active', 1, '1', '1784222342', 'f', '0', '96352304', 'none', '100', '1784222226', '1', '1', '28e41f96ee48', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('8636394298', 0, 1, 'NOT_USERNAME', '0', '0', '0', '0', 'home', NULL, '989115297848', 350000, 'Active', 1, '2', '1787861584', 'f', '0', '96352304', 'none', '101', '1787854185', '1', '1', '9cde934be9d1', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('8896300877', 1, 1, 'zoroking2026', '0', '0', '0', '0', 'home', NULL, '989905286628', 0, 'Active', 1, '2', '1787781957', 'f', '0', '0', 'none', '100', '1784929608', '1', '1', '01995a15fc60', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('955371254', 1, 0, 'Amirmj7777', '', '', '', '', 'none', NULL, 'none', 0, 'Active', 1, '1', '1784055733', 'f', '0', '0', 'none', '100', '1784055733', '0', '1', 'bef7406a3dea', '0', '0', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa'),
('96352304', 0, 0, 'king_service2', '0', '0', '0', '0', 'home', NULL, '989154562820', 2500, 'Active', 4, '1', '1788111252', 'f', '6', '0', 'none', '101', '1783552993', '1', '1', '9fb27227fc9b', '0', '1', '0', '0', '0', NULL, 0, '0', '1', NULL, NULL, 'fa');

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

--
-- Table structure for table `wheel_list`
--

CREATE TABLE `wheel_list` (
  `id` int(6) UNSIGNED NOT NULL,
  `id_user` varchar(200) NOT NULL,
  `time` varchar(200) NOT NULL,
  `first_name` varchar(200) NOT NULL,
  `wheel_code` varchar(200) NOT NULL,
  `price` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wheel_list`
--

INSERT INTO `wheel_list` (`id`, `id_user`, `time`, `first_name`, `wheel_code`, `price`) VALUES
(1, '96352304', '2026/07/09 06:47:06', 'سید ضیا الدین', '1', '0'),
(2, '6185717419', '2026/07/10 02:01:28', 'peter', '5', '0'),
(3, '96352304', '2026/07/11 19:37:19', 'سید ضیا الدین', '3', '0'),
(4, '6812221987', '2026/07/12 11:49:16', 'Hajiesmaeily', '2', '0'),
(5, '776469659', '2026/07/15 00:27:53', 'Hosein', '3', '0'),
(6, '96352304', '2026/07/16 21:32:56', 'سید ضیا الدین', '4', '0'),
(7, '96352304', '2026/07/26 19:59:32', 'سید ضیا الدین', '1', '0'),
(8, '385721417', '2026/08/12 21:38:02', 'حسین', '4', '0'),
(9, '5974770955', '2026/08/18 22:04:28', 'Asal', '2', '0'),
(10, '2145474169', '2026/08/20 00:49:29', 'ali', '5', '0'),
(11, '96352304', '2026/08/30 21:04:56', 'سید ضیا الدین', '4', '0');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`id_admin`);

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

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

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

--
-- Indexes for table `card_number`
--
ALTER TABLE `card_number`
  ADD PRIMARY KEY (`cardnumber`);

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

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

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

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

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

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

--
-- Indexes for table `invoice`
--
ALTER TABLE `invoice`
  ADD PRIMARY KEY (`id_invoice`);

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

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

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

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

--
-- Indexes for table `PaySetting`
--
ALTER TABLE `PaySetting`
  ADD PRIMARY KEY (`NamePay`);

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

--
-- Indexes for table `reagent_report`
--
ALTER TABLE `reagent_report`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`user_id`);

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

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

--
-- Indexes for table `shopSetting`
--
ALTER TABLE `shopSetting`
  ADD PRIMARY KEY (`Namevalue`);

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

--
-- Indexes for table `topicid`
--
ALTER TABLE `topicid`
  ADD PRIMARY KEY (`report`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `app`
--
ALTER TABLE `app`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `botsaz`
--
ALTER TABLE `botsaz`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cancel_service`
--
ALTER TABLE `cancel_service`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `departman`
--
ALTER TABLE `departman`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `Discount`
--
ALTER TABLE `Discount`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `DiscountSell`
--
ALTER TABLE `DiscountSell`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `Giftcodeconsumed`
--
ALTER TABLE `Giftcodeconsumed`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `help`
--
ALTER TABLE `help`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `logs_api`
--
ALTER TABLE `logs_api`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `manualsell`
--
ALTER TABLE `manualsell`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `marzban_panel`
--
ALTER TABLE `marzban_panel`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `Payment_report`
--
ALTER TABLE `Payment_report`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `reagent_report`
--
ALTER TABLE `reagent_report`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

--
-- AUTO_INCREMENT for table `support_message`
--
ALTER TABLE `support_message`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wheel_list`
--
ALTER TABLE `wheel_list`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
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 */;
