-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Feb 26, 2026 at 04:34 PM -- Server version: 11.4.9-MariaDB -- PHP Version: 8.4.15 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: `efztourf_database` -- -- -------------------------------------------------------- -- -- Table structure for table `pranto_addmoney` -- CREATE TABLE `pranto_addmoney` ( `id` int(11) NOT NULL, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `trxid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `fcm` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `pranto_addmoney` -- INSERT INTO `pranto_addmoney` (`id`, `username`, `amount`, `trxid`, `method`, `fcm`, `status`, `date`) VALUES (1, 'efzadminsaymon1', '5000', 'wiwjjwkwkekj', 'Bkash', 'c33bhWrcK0w:APA91bFyKBzqqcT5QidfdMNHPm2sxb82dt8LYr6zpj18GtpROgFJtGF5ARRG0ILNafsux1XVoQj695MoCBXhD_35RpSAVb-MwCw-Nn_XGJuHOI2LRZ-yXp8', 'Success', '2026-02-11 19:07:05'), (2, 'adminhasan1', '2000', 'igoytiit', 'Bkash', 'fcJJdb23CL0:APA91bFyLM_Y8lDhcSM_QLYKs7qaCNKq2INqpAxpRo9oKoE5yKySTT6ErF-yhV6WrV8-GiZcxAgoFbgw1IU5RFNJyz1RTIk8JBkcGdpE5tSZOj0KMhPM93c', 'Success', '2026-02-21 19:20:03'), (3, 'efzadminsaymon1', '5', 'DBM6D73DWS', 'Bkash', 'cjMCykLl8ZY:APA91bEjWfs-nApqjVvmcBYt-Qv0LvXYUWtr6vYJgCKWQcuAWR9va5T8mojuN2w3y7AHPaYqcDxCrMdve2Fi8sQOiSHmgaFqFNyeNBw1fRW2kAsU6769kG0', 'Success', '2026-02-22 20:05:25'); -- -------------------------------------------------------- -- -- Table structure for table `pranto_join` -- CREATE TABLE `pranto_join` ( `id` int(11) NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `matchid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `fcm` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `winning` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `totalkill` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `date` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `pranto_join` -- INSERT INTO `pranto_join` (`id`, `name`, `username`, `matchid`, `fcm`, `winning`, `totalkill`, `date`) VALUES (1, 'jaksjsk', 'efzadminsaymon1', '1', 'epz-UYNUCeU:APA91bG3G39mTMW-dWJMu3dOJ_RQFO92LEEFoOuoglJD1lXK6tM2yG-vO7CmogPXufa1aHgVq0JlYd2MAGC9D1-0HZV71it9-1qPyav6m4v2l94W1-JqJAg', '0', '0', '2026-02-13 17:08:47'), (2, '—͞BWX–NEXON!', 'adminhasan1', '4', 'fcJJdb23CL0:APA91bFyLM_Y8lDhcSM_QLYKs7qaCNKq2INqpAxpRo9oKoE5yKySTT6ErF-yhV6WrV8-GiZcxAgoFbgw1IU5RFNJyz1RTIk8JBkcGdpE5tSZOj0KMhPM93c', '0', '0', '2026-02-21 19:20:45'), (3, '—͞BWX–NEXON!', 'adminhasan1', '3', 'fcJJdb23CL0:APA91bFyLM_Y8lDhcSM_QLYKs7qaCNKq2INqpAxpRo9oKoE5yKySTT6ErF-yhV6WrV8-GiZcxAgoFbgw1IU5RFNJyz1RTIk8JBkcGdpE5tSZOj0KMhPM93c', '0', '0', '2026-02-21 19:21:04'), (4, '—͞Ꮪꫝᴍɪ፝֟ꫝ ꪇ༊', 'adminhasan1', '2', 'fcJJdb23CL0:APA91bFyLM_Y8lDhcSM_QLYKs7qaCNKq2INqpAxpRo9oKoE5yKySTT6ErF-yhV6WrV8-GiZcxAgoFbgw1IU5RFNJyz1RTIk8JBkcGdpE5tSZOj0KMhPM93c', '60', '58', '2026-02-21 19:21:25'), (5, 'Saymon', 'efzadminsaymon1', '5', 'cjMCykLl8ZY:APA91bEjWfs-nApqjVvmcBYt-Qv0LvXYUWtr6vYJgCKWQcuAWR9va5T8mojuN2w3y7AHPaYqcDxCrMdve2Fi8sQOiSHmgaFqFNyeNBw1fRW2kAsU6769kG0', '70', '5', '2026-02-22 20:26:34'), (6, 'saymon', 'efzadminsaymon1', '6', 'cjMCykLl8ZY:APA91bEjWfs-nApqjVvmcBYt-Qv0LvXYUWtr6vYJgCKWQcuAWR9va5T8mojuN2w3y7AHPaYqcDxCrMdve2Fi8sQOiSHmgaFqFNyeNBw1fRW2kAsU6769kG0', '100', '2', '2026-02-22 20:35:04'); -- -------------------------------------------------------- -- -- Table structure for table `pranto_match` -- CREATE TABLE `pranto_match` ( `id` int(11) NOT NULL, `matchtitle` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `input` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `matchtime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `totalprize` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `perkill` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `entryfee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `matchmap` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `playerneed` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `prizelist` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `matchentry` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `matchid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `matchtype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `matchurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `registration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `playerjoin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `roomid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `roompass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `pranto_match` -- INSERT INTO `pranto_match` (`id`, `matchtitle`, `input`, `date`, `time`, `matchtime`, `totalprize`, `perkill`, `entryfee`, `matchmap`, `playerneed`, `prizelist`, `matchentry`, `matchid`, `matchtype`, `position`, `matchurl`, `registration`, `playerjoin`, `roomid`, `roompass`) VALUES (1, 'Squad Match #1', '2026-02-13 17:30:00', '13-02-2026', '05:30 PM', '13-02-2026 at 05:30 PM', '800', '10', '20', 'Bermuda', '48', '👑 Winner - 90 Taka\n🥈 2nd Position - 70 Taka\n🥉 3rd Position - 40 Taka \n🏅 4th Position - 30 Taka \n🏅 5th Position - 20 Taka \n🔥 Per Kill : 10 Taka\n🏆 Total Prize Pool: 800 Taka', 'Solo', '7', 'BR MATCH', 'Match', 'Null', 'ON', '1', '12131619', '22'), (2, 'Br Solo Match #1', '2026-02-18 20:30:00', '18-02-2026', '08:30 PM', '18-02-2026 at 08:30 PM', '400', '10', '20', 'Bermuda', '48', '👑 Winner - 120 Taka\n🥈 2nd Position - 80 Taka\n🥉 3rd Position - 40 Taka \n🔥 Per Kill : 10 Taka\n🏆 Total Prize Pool: 800 Taka', 'Solo', '8', 'BR MATCH', 'Result', 'Null', 'ON', '1', '42589595', '9295'), (3, 'Br match #1', '2026-02-21 18:55:00', '21-02-2026', '06:55 PM', '21-02-2026 at 06:55 PM', '90', '10', '20', 'Bermuda', '20', '👑 Winner - 90 Taka\n🥈 2nd Position - 70 Taka\n🥉 3rd Position - 40 Taka \n🏅 4th Position - 30 Taka \n🏅 5th Position - 20 Taka \n🔥 Per Kill : 10 Taka\n🏆 Total Prize Pool: 800 Taka', 'Solo', '9', 'BR MATCH', 'Match', 'Null', 'ON', '1', 'False', 'False'), (4, 'solo Time #2', '2026-02-21 19:05:00', '21-02-2026', '07:05 PM', '21-02-2026 at 07:05 PM', '800', '10', '20', 'Bermuda', '20', '👑 Winner - 90 Taka\n🥈 2nd Position - 70 Taka\n🥉 3rd Position - 40 Taka \n🏅 4th Position - 30 Taka \n🏅 5th Position - 20 Taka \n🔥 Per Kill : 10 Taka\n🏆 Total Prize Pool: 800 Taka', 'Solo', '10', 'BR MATCH', 'Match', 'Null', 'ON', '1', 'False', 'False'), (5, 'Br Match #5', '2026-02-22 20:30:00', '22-02-2026', '08:30 PM', '22-02-2026 at 08:30 PM', '800', '10', '20', 'Bermuda', '20', '👑 Winner - 90 Taka\n🥈 2nd Position - 70 Taka\n🥉 3rd Position - 40 Taka \n🏅 4th Position - 30 Taka \n🏅 5th Position - 20 Taka \n🔥 Per Kill : 10 Taka\n🏆 Total Prize Pool: 800 Taka', 'Solo', '11', 'BR MATCH', 'Result', 'Null', 'ON', '1', '64646484', '46'), (6, 'Br Match #7', '2026-02-22 20:40:00', '22-02-2026', '08:40 PM', '22-02-2026 at 08:40 PM', '800', '10', '20', 'Bermuda', '20', '👑 Winner - 90 Taka\n🥈 2nd Position - 70 Taka\n🥉 3rd Position - 40 Taka \n🏅 4th Position - 30 Taka \n🏅 5th Position - 20 Taka \n🔥 Per Kill : 10 Taka\n🏆 Total Prize Pool: 800 Taka', 'Solo', '12', 'BR MATCH', 'Match', 'Null', 'ON', '1', '464664', '22'); -- -------------------------------------------------------- -- -- Table structure for table `pranto_otp` -- CREATE TABLE `pranto_otp` ( `id` int(11) NOT NULL, `email` varchar(100) NOT NULL, `otp` varchar(10) NOT NULL, `time` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `pranto_owner` -- CREATE TABLE `pranto_owner` ( `id` int(11) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `pranto_owner` -- INSERT INTO `pranto_owner` (`id`, `email`, `password`) VALUES (1, 'adminefztour26@gmail.com', '12345678@#PRANTO_ASDF_2K26_eFzTour'); -- -------------------------------------------------------- -- -- Table structure for table `pranto_statices` -- CREATE TABLE `pranto_statices` ( `id` int(11) NOT NULL, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `time` datetime NOT NULL DEFAULT current_timestamp(), `entryfee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `win` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `matchid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `pranto_statices` -- INSERT INTO `pranto_statices` (`id`, `username`, `title`, `time`, `entryfee`, `win`, `matchid`) VALUES (1, 'efzadminsaymon1', 'Squad Match #1', '2026-02-13 17:08:47', '20', '0', '1'), (2, 'adminhasan1', 'solo Time #2', '2026-02-21 19:20:45', '20', '0', '4'), (3, 'adminhasan1', 'Br match #1', '2026-02-21 19:21:04', '20', '0', '3'), (4, 'adminhasan1', 'Br Solo Match #1', '2026-02-21 19:21:26', '20', '60', '2'), (5, 'efzadminsaymon1', 'Br Match #5', '2026-02-22 20:26:34', '20', '70', '5'), (6, 'efzadminsaymon1', 'Br Match #7', '2026-02-22 20:35:04', '20', '200', '6'); -- -------------------------------------------------------- -- -- Table structure for table `pranto_topuplist` -- CREATE TABLE `pranto_topuplist` ( `id` int(11) NOT NULL, `topup` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `price` varchar(255) NOT NULL, `stock` int(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `pranto_topuplist` -- INSERT INTO `pranto_topuplist` (`id`, `topup`, `price`, `stock`) VALUES (1, 'Weekly Membership', '160', 0), (2, 'Monthly Membership', '765', 0), (3, '25 Diamond TopUp', '21', 0), (4, '50 Diamond TopUp', '38', 0), (5, '100 Diamond TopUp', '73', 0), (6, '115 Diamond TopUp', '81', 0), (7, '240 Diamond TopUp', '156', 0), (8, '355 Diamond TopUp', '233', 0), (9, '505 Diamond TopUp', '325', 0), (10, '610 Diamond TopUp', '387', 0), (11, '850 Diamond TopUp', '538', 0), (12, '1090 Diamond TopUp', '681', 0), (13, ' Weekly lite', '45', 0), (14, '3 Days Evo Access', '80', 0), (15, '7 Days Evo Access', '120', 0), (16, '14 Days Evo Access', '230', 0), (17, '30 Days Evo Access', '345', 0), (18, 'Level Up Pass - Level 6', '45', 0), (19, 'Level Up Pass - Level 10', '75', 0), (20, 'Level Up Pass - Level 15', '75', 0), (21, 'Level Up Pass - Level 20', '75', 0), (22, 'Level Up Pass - Level 25', '75', 0), (23, 'Level Up Pass - Level 30', '115', 0); -- -------------------------------------------------------- -- -- Table structure for table `pranto_topuporder` -- CREATE TABLE `pranto_topuporder` ( `id` int(11) NOT NULL, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `gameid` varchar(20) NOT NULL, `item` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `fcm` varchar(500) NOT NULL, `status` varchar(255) NOT NULL, `date` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `pranto_topuporder` -- INSERT INTO `pranto_topuporder` (`id`, `username`, `gameid`, `item`, `price`, `fcm`, `status`, `date`) VALUES (1, 'efzadminsaymon1', '2831598741', '500 Diamond', '320', 'c33bhWrcK0w:APA91bFyKBzqqcT5QidfdMNHPm2sxb82dt8LYr6zpj18GtpROgFJtGF5ARRG0ILNafsux1XVoQj695MoCBXhD_35RpSAVb-MwCw-Nn_XGJuHOI2LRZ-yXp8', 'Reject', '2026-02-11 19:07:23'), (2, 'efzadminsaymon1', '2831598741', '500 Diamond', '320', 'c33bhWrcK0w:APA91bFyKBzqqcT5QidfdMNHPm2sxb82dt8LYr6zpj18GtpROgFJtGF5ARRG0ILNafsux1XVoQj695MoCBXhD_35RpSAVb-MwCw-Nn_XGJuHOI2LRZ-yXp8', 'Success', '2026-02-11 19:08:06'), (3, 'efzadminsaymon1', '2831598741', '25 Diamond Top Up', '21', 'c33bhWrcK0w:APA91bFyKBzqqcT5QidfdMNHPm2sxb82dt8LYr6zpj18GtpROgFJtGF5ARRG0ILNafsux1XVoQj695MoCBXhD_35RpSAVb-MwCw-Nn_XGJuHOI2LRZ-yXp8', 'Success', '2026-02-11 19:17:09'), (4, 'efzadminsaymon1', '2831598741', 'Weekly Membership', '160', 'c33bhWrcK0w:APA91bFyKBzqqcT5QidfdMNHPm2sxb82dt8LYr6zpj18GtpROgFJtGF5ARRG0ILNafsux1XVoQj695MoCBXhD_35RpSAVb-MwCw-Nn_XGJuHOI2LRZ-yXp8', 'Success', '2026-02-12 13:21:49'); -- -------------------------------------------------------- -- -- Table structure for table `pranto_trx` -- CREATE TABLE `pranto_trx` ( `id` int(11) NOT NULL, `gateway` varchar(255) NOT NULL, `method` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `sender` varchar(255) NOT NULL, `trxid` varchar(255) NOT NULL, `status` int(1) NOT NULL DEFAULT 0, `date` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `pranto_trx` -- INSERT INTO `pranto_trx` (`id`, `gateway`, `method`, `amount`, `sender`, `trxid`, `status`, `date`) VALUES (3, 'Bkash', 'Null', '270', 'Null', 'DB46S1L4YS', 0, '2026-02-12 13:02:19'), (4, 'Bkash', 'Send Money', '160', '01312696235', 'DBD335M265', 0, '2026-02-13 23:39:13'), (5, 'Bkash', 'Send Money', '300', '01312696235', 'DBF45MSA9K', 0, '2026-02-15 23:28:55'), (6, 'Bkash', 'Null', '2000', 'Null', 'udofidot', 0, '2026-02-21 19:19:33'), (8, 'Bkash', 'Send Money', '250', '01312696235', 'DBM8CCPQKS', 0, '2026-02-22 01:08:55'), (9, 'Bkash', 'Send Money', '330', '01346823684', 'DBM4CU5F1Q', 0, '2026-02-22 14:55:44'), (10, 'Bkash', 'Send Money', '918', '01854111471', 'DBM8D1LQAM', 0, '2026-02-22 18:17:56'), (12, 'Bkash', 'Send Money', '500', '01586370652', 'DBN4DK424Q', 0, '2026-02-23 07:37:17'), (13, 'Bkash', 'Send Money', '500', '01852019325', 'DBN5E9UB97', 0, '2026-02-23 19:43:39'), (14, 'Bkash', 'Send Money', '1', '01586370652', 'DBO5ES633V', 0, '2026-02-24 10:41:59'), (15, 'Bkash', 'Send Money', '195', '01854111471', 'DBO0FF17AC', 0, '2026-02-24 19:47:07'), (16, 'Nagad', 'Send Money', '200', '01860629317', '74ZHPD6Y', 0, '2026-02-24 22:12:36'); -- -------------------------------------------------------- -- -- Table structure for table `pranto_users` -- CREATE TABLE `pranto_users` ( `id` int(11) NOT NULL, `username` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `number` varchar(11) NOT NULL, `password` varchar(500) NOT NULL, `balance` int(11) NOT NULL, `winning` int(11) NOT NULL, `played` int(11) NOT NULL, `totalwinning` int(11) NOT NULL, `deviceid` varchar(355) NOT NULL, `fcm` varchar(500) NOT NULL, `date` datetime NOT NULL DEFAULT current_timestamp(), `ban` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `pranto_users` -- INSERT INTO `pranto_users` (`id`, `username`, `email`, `number`, `password`, `balance`, `winning`, `played`, `totalwinning`, `deviceid`, `fcm`, `date`, `ban`) VALUES (1, 'PRANTO', 'prantoshil444@gmail.com', '01611834367', 'asdfasdf12', 0, 0, 0, 0, '17f65923e88ba84b', 'dxTNERFdk10:APA91bFBQusAsjlIPfS1ECzi6fOZtRyHiZLSwGzYfOChNMVuAXGpXhqlgUgeIvuTL-EDoGKV7i-l4UKQP-i-8qJv_23Pmgi-xwYc8aNdbmm8tlmGTRqrEzo', '2026-02-11 15:46:01', 'False'), (2, 'efzadminsaymon1', 'shsaymonofficial@gmail.com', '01836835601', 'S@ymon10', 4444, 270, 3, 270, '24dae526fddc1e36', 'c33bhWrcK0w:APA91bFyKBzqqcT5QidfdMNHPm2sxb82dt8LYr6zpj18GtpROgFJtGF5ARRG0ILNafsux1XVoQj695MoCBXhD_35RpSAVb-MwCw-Nn_XGJuHOI2LRZ-yXp8', '2026-02-11 18:30:28', 'False'), (3, 'adminhasan1', 'hasanbai9901@gmail.com', '01622149713', 'hasan?valo', 1940, 60, 3, 60, '4e3f860cb5f80458', 'fcJJdb23CL0:APA91bFyLM_Y8lDhcSM_QLYKs7qaCNKq2INqpAxpRo9oKoE5yKySTT6ErF-yhV6WrV8-GiZcxAgoFbgw1IU5RFNJyz1RTIk8JBkcGdpE5tSZOj0KMhPM93c', '2026-02-11 19:28:59', 'False'), (4, 'puukkk', 'pubgv0641@gmail.com', '01236253254', '12345678', 0, 0, 0, 0, '6d46c687513f2c19', 'cfjSX-WzBu4:APA91bEjwHNZXt_LTlbbu1LdcCvRrBkHcDXaMcC_2awJ2QE2k7n5Kic1E-p0TseUgGaOQrfeKEj-3E45gg6onv5mUb4WvsX0YXWhUQoEJ8BdNHUMcalpD6s', '2026-02-12 21:13:35', 'False'), (5, 'marufbk1', 'marufffid01@gmail.com', '01626476383', 'S@ymon10', 0, 0, 0, 0, '4d3a7ddcf6fb97cd', 'dLuqCHROXZQ:APA91bGQ8QYR6CuwU8X6vT7l_nz_o_3c8uzAvgId6Rj2fUyjelzvuPzBvWsopbHLtkJVir2WFSzULKUACwa9HoGxoFKgsZLzR3Jv4eJa-c9MDRb0_Kv6jlw', '2026-02-13 14:47:18', 'False'), (6, 'shaiful', 'hafizislam2324@gmail.com', '01952486254', 'zxcvbnm', 0, 0, 0, 0, 'a94519ec13f006f7', 'cUOTQ1wELmk:APA91bG7XhKLkiY9rYKTbpnWyafte9pIkMLMgRxleBF5w4CzN2kNvBxf4khhjkYE6MqGVDXiK3G2aG6un7HvjGhW51TvJG7zfus6F-_YiSPgZwpCVNsqRAg', '2026-02-15 18:12:36', 'False'), (7, 'DeveloperHabib', 'devhabib999bd@gmail.com', '01832331454', 'tarip2121', 0, 0, 0, 0, '128a15582c2310b8', 'cBLNoWffYmU:APA91bEnceLqxHonIpK41eWDA4xZ3RxW0hiiKuaXzeIsWJNNnrKGR8K-5qKDjrzoq7nNz0qvjrpYC2l5ncdWPUJMVYKlvCze4zfQV5_gDcIVnmVJZYeppoE', '2026-02-21 22:48:24', 'False'), (8, 'ashik_sir', 'flexymr123@gmail.com', '01873838660', '@shik!\"\':;', 0, 0, 0, 0, '4778dbc6263b490a', 'dKBCtnqszts:APA91bEdQv9MkHyoKJGnBLxMYxpo1oT0yttlPNzOsIDkavgrNf6IiU-NjDow5lSXuOJ3jUMjVE3YxpmHF7-MWNEgwHxIk86hBOnES3YDA6_OR-06yKdkzlE', '2026-02-22 20:00:23', 'False'), (9, 'AIMON36x', 'aimonhtz40701@gmail.com', '01604094501', 'AIMON36x', 0, 0, 0, 0, '18a171b6f78baef6', 'd9xZlbUcfcs:APA91bGHluTYVsngqt5dDflzUfATGf9gFKwCSLqFaBEXgGPnkRRrFBs6O4AMd_vS07OBnOQ6PYhU2Ye7hCYESVR9izJsUIbjyxlhv0_jVYJxndSSDOPF2t4', '2026-02-25 12:56:05', 'False'), (10, 'Nafis69x', 'mohammadshahriar65@gmail.com', '01612795352', '11223344', 0, 0, 0, 0, '1b6898cba428789e', 'd5mh7PPneSE:APA91bHIh2bU0-4WfQjMYrGOIA-e8ue6gOENqawxbq1E3StRHLbiwvnZH4o6hlXV4K-9886yLENoh6hB6YBBEV3edES1aJC2oBJ3fYdwzbTh5sIEYmmyvJ8', '2026-02-26 16:24:24', 'False'); -- -------------------------------------------------------- -- -- Table structure for table `pranto_withdraw` -- CREATE TABLE `pranto_withdraw` ( `id` int(11) NOT NULL, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `fcm` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `pranto_addmoney` -- ALTER TABLE `pranto_addmoney` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pranto_join` -- ALTER TABLE `pranto_join` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pranto_match` -- ALTER TABLE `pranto_match` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pranto_otp` -- ALTER TABLE `pranto_otp` ADD PRIMARY KEY (`id`), ADD KEY `email` (`email`); -- -- Indexes for table `pranto_owner` -- ALTER TABLE `pranto_owner` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pranto_statices` -- ALTER TABLE `pranto_statices` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pranto_topuplist` -- ALTER TABLE `pranto_topuplist` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pranto_topuporder` -- ALTER TABLE `pranto_topuporder` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pranto_trx` -- ALTER TABLE `pranto_trx` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pranto_users` -- ALTER TABLE `pranto_users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pranto_withdraw` -- ALTER TABLE `pranto_withdraw` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `pranto_addmoney` -- ALTER TABLE `pranto_addmoney` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `pranto_join` -- ALTER TABLE `pranto_join` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `pranto_match` -- ALTER TABLE `pranto_match` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `pranto_otp` -- ALTER TABLE `pranto_otp` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `pranto_owner` -- ALTER TABLE `pranto_owner` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `pranto_statices` -- ALTER TABLE `pranto_statices` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `pranto_topuplist` -- ALTER TABLE `pranto_topuplist` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `pranto_topuporder` -- ALTER TABLE `pranto_topuporder` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `pranto_trx` -- ALTER TABLE `pranto_trx` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `pranto_users` -- ALTER TABLE `pranto_users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `pranto_withdraw` -- ALTER TABLE `pranto_withdraw` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; 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 */;