-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jun 10, 2026 at 12:14 AM -- Server version: 8.0.44-cll-lve -- PHP Version: 8.4.21 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: `aaysrcri_mohammadi` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int NOT NULL, `user` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `pass` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `cypto_wallet_address` text NOT NULL, `card_number` text NOT NULL, `card_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `usdt_wallet` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `zarinpal_merchant` varchar(64) DEFAULT NULL, `support_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `contact_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `channel_id` varchar(64) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `user`, `pass`, `cypto_wallet_address`, `card_number`, `card_name`, `usdt_wallet`, `zarinpal_merchant`, `support_text`, `contact_text`, `channel_id`) VALUES (1, 'admin', '5bfd1e04db7adafc4908107e1cb08c0d', 'TZ3tuzQDS7G4pAC1gYtCN9ZJ5C55xwhg4n', '6104337519165284', 'میلاد حبیب پور ', NULL, 'ab9af902-ae22-11e6-95b0-000c295eb8fc', '👤 جهت ارتباط با پشتیبانی پیام خود را به آیدی پشتیبانی ارسال نمایید.', '📞 جهت ارتباط با ما به آیدی پشتیبانی ربات پیام ارسال فرمایید.', '5763684194'); -- -------------------------------------------------------- -- -- Table structure for table `c2c_reqs` -- CREATE TABLE `c2c_reqs` ( `id` int NOT NULL, `chatid` bigint NOT NULL, `pckg_id` text NOT NULL, `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `price` text NOT NULL, `time` int NOT NULL DEFAULT '30', `image` text NOT NULL, `is_discount` enum('yes','no') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('pending','rejected','confirmed') NOT NULL DEFAULT 'pending', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; -- -- Dumping data for table `c2c_reqs` -- INSERT INTO `c2c_reqs` (`id`, `chatid`, `pckg_id`, `title`, `price`, `time`, `image`, `is_discount`, `status`, `created_at`) VALUES (1, 1209024131, '1', 'یک ماهه', '3,000,000', 30, '299', 'no', 'confirmed', '2025-10-13 08:40:59'), (2, 1209024131, '1', 'یک ماهه', '3,000,000', 30, '332', 'no', 'confirmed', '2025-10-13 12:21:12'), (3, 5803067539, '1', 'یک ماهه', '3,000,000', 30, '344', 'no', 'confirmed', '2025-10-13 12:27:24'), (4, 78239217, '1', 'یک ماهه', '3,000,000', 30, '356', 'no', 'rejected', '2025-10-13 12:29:57'), (5, 5625196705, '1', 'یک ماهه', '3,000,000', 30, '154', 'no', 'pending', '2026-05-31 09:39:57'), (6, 7691741202, '1', 'یک ماهه', '900,000', 30, '184', 'no', 'pending', '2026-05-31 09:56:21'), (7, 161104720, '1', 'یک ماهه', '900,000', 30, '196', 'no', 'pending', '2026-05-31 10:03:54'), (8, 161104720, '1', 'یک ماهه', '900,000', 30, '206', 'no', 'pending', '2026-05-31 10:06:52'), (9, 161104720, '1', 'یک ماهه', '900,000', 30, '217', 'no', 'pending', '2026-05-31 10:10:25'), (10, 161104720, '1', 'یک ماهه', '900,000', 30, '228', 'no', 'confirmed', '2026-05-31 10:10:59'), (11, 161104720, '1', 'یک ماهه', '900,000', 30, '239', 'no', 'pending', '2026-05-31 11:17:54'), (12, 7691741202, '1', 'یک ماهه', '900,000', 30, '248', 'no', 'pending', '2026-05-31 11:18:22'), (13, 161104720, '2', 'تست یک ', '250,000', 30, '386', 'no', 'pending', '2026-05-31 17:48:53'), (14, 7691741202, '2', 'تست یک ', '250,000', 30, '407', 'no', 'pending', '2026-05-31 17:50:32'), (15, 5803067539, '2', 'تست یک ', '250,000', 30, '426', 'no', 'confirmed', '2026-05-31 20:57:25'), (16, 5803067539, '2', 'تست یک ', '250,000', 30, '437', 'no', 'rejected', '2026-05-31 20:59:02'), (17, 161104720, '2', 'تست یک ', '250,000', 30, '470', 'no', 'pending', '2026-06-01 00:05:00'), (18, 7691741202, '2', 'تست یک ', '250,000', 30, '510', 'no', 'confirmed', '2026-06-01 08:00:49'), (19, 161104720, '2', 'تست یک ', '250,000', 30, '571', 'no', 'confirmed', '2026-06-01 08:54:15'); -- -------------------------------------------------------- -- -- Table structure for table `discount_codes` -- CREATE TABLE `discount_codes` ( `id` int NOT NULL, `code` varchar(32) NOT NULL, `amount` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; -- -- Dumping data for table `discount_codes` -- INSERT INTO `discount_codes` (`id`, `code`, `amount`) VALUES (1, '111', 50); -- -------------------------------------------------------- -- -- Table structure for table `hash` -- CREATE TABLE `hash` ( `id` int NOT NULL, `chatid` bigint NOT NULL, `hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `time` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `id` int NOT NULL, `chatid` bigint NOT NULL, `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `price` text NOT NULL, `is_discount` enum('yes','no') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `time` int NOT NULL, `pay_type` enum('gate','c2c','crypto') NOT NULL, `status` enum('pending','paid','failed') NOT NULL DEFAULT 'paid', `authority` varchar(64) DEFAULT NULL, `discount_code` varchar(32) DEFAULT NULL, `ref_id` text, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; -- -- Dumping data for table `orders` -- INSERT INTO `orders` (`id`, `chatid`, `title`, `price`, `is_discount`, `time`, `pay_type`, `status`, `authority`, `discount_code`, `ref_id`, `created_at`) VALUES (1, 1178247636, 'تست یک ', '250,000', 'no', 30, 'gate', 'pending', NULL, NULL, NULL, '2026-06-06 13:07:43'), (2, 1178247636, 'تست یک ', '125,000', 'yes', 30, 'gate', 'pending', NULL, '111', NULL, '2026-06-06 13:12:50'), (3, 1178247636, 'تست یک ', '250,000', 'no', 30, 'gate', 'pending', NULL, NULL, NULL, '2026-06-06 18:54:42'), (4, 421943770, 'تست یک ', '250,000', 'no', 30, 'gate', 'pending', NULL, NULL, NULL, '2026-06-06 20:37:15'), (5, 421943770, 'تست یک ', '250,000', 'no', 30, 'gate', 'pending', NULL, NULL, NULL, '2026-06-06 20:37:15'), (6, 421943770, 'تست یک ', '250,000', 'no', 30, 'gate', 'pending', NULL, NULL, NULL, '2026-06-07 18:11:06'), (7, 1178247636, 'تست یک ', '250,000', 'no', 30, 'gate', 'pending', NULL, NULL, NULL, '2026-06-07 18:55:21'), (8, 421943770, 'تست یک ', '250,000', 'no', 30, 'gate', 'pending', NULL, NULL, NULL, '2026-06-08 13:44:07'), (9, 1178247636, 'تست یک ', '250,000', 'no', 30, 'gate', 'pending', NULL, NULL, NULL, '2026-06-09 13:58:46'); -- -------------------------------------------------------- -- -- Table structure for table `package` -- CREATE TABLE `package` ( `id` int NOT NULL, `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `price` float NOT NULL, `price_usdt` decimal(10,2) NOT NULL DEFAULT '0.00', `time` bigint NOT NULL, `channel_id` bigint NOT NULL DEFAULT '-1002794251497' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; -- -- Dumping data for table `package` -- INSERT INTO `package` (`id`, `title`, `price`, `price_usdt`, `time`, `channel_id`) VALUES (2, 'تست یک ', 250000, 15.00, 30, -1002794251497), (3, 'تست دوم', 10000, 0.00, 60, -1002794251497); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int NOT NULL, `telfamily` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `telname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `username` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `chatid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `req1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `req2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `req3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `req4` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `expire_time` bigint NOT NULL DEFAULT '0', `status` enum('active','deactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'deactive', `one_day_alert` enum('yes','no') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'no' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `telfamily`, `telname`, `username`, `chatid`, `req1`, `req2`, `req3`, `req4`, `expire_time`, `status`, `one_day_alert`) VALUES (1, '', 'کارشناس فروش AHPBOT', 'ahpbot_sale', '1756129440', '', '', '168', '', 1783220906, 'active', 'no'), (4, '', 'm.moh', NULL, '1178247636', '', '', '295', '', 1783363983, 'active', 'no'), (5, '', 'گروه تست جناب محمدی ', NULL, '5763684194', NULL, NULL, NULL, NULL, 0, 'deactive', 'no'), (6, '', 'em', NULL, '421943770', '', '8', '282', '', 0, 'deactive', 'no'); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `c2c_reqs` -- ALTER TABLE `c2c_reqs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `discount_codes` -- ALTER TABLE `discount_codes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `hash` -- ALTER TABLE `hash` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `hash_unique` (`hash`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `package` -- ALTER TABLE `package` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `c2c_reqs` -- ALTER TABLE `c2c_reqs` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `discount_codes` -- ALTER TABLE `discount_codes` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `hash` -- ALTER TABLE `hash` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `package` -- ALTER TABLE `package` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; 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 */;