-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Mar 03, 2026 at 02:18 PM -- Server version: 11.4.10-MariaDB -- PHP Version: 8.4.14 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: `devxmehd_kbd` -- -- -------------------------------------------------------- -- -- Table structure for table `addmoney` -- CREATE TABLE `addmoney` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `email` varchar(100) NOT NULL, `method` varchar(10) NOT NULL, `number` varchar(15) NOT NULL, `amount` int(11) NOT NULL, `trxid` varchar(10) NOT NULL, `status` varchar(10) NOT NULL DEFAULT 'Pending', `date` varchar(20) NOT NULL, `time` varchar(20) NOT NULL, `fcm` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `addmoney` -- INSERT INTO `addmoney` (`id`, `name`, `email`, `method`, `number`, `amount`, `trxid`, `status`, `date`, `time`, `fcm`) VALUES (18, 'Sakibul75', 'Sakibul75 @gmail.com', 'Bkash', '01999999999', 1, 'CL22PVMFCM', 'Success', '02-Dec-2025', '09:06:16 PM', ''), (19, 'Sakibul75', 'Sakibul75 @gmail.com', 'Bkash', '01987474202', 200, 'CL37QZ1BEP', 'Success', '04-Dec-2025', '12:20:17 PM', ''), (20, 'Sakibul75', 'Sakibul75 @gmail.com', 'Nagad', '01999999999', 10, '74N8LXOQ', 'Success', '04-Dec-2025', '03:39:09 PM', ''), (21, 'Sakibul75', 'Sakibul75 @gmail.com', 'Nagad', '01999999999', 10, '74N8LXOE', 'Success', '04-Dec-2025', '04:15:15 PM', ''), (22, 'devshihab', 'devshihab @gmail.com', 'Rocket', '01999999999', 100, '0169375162', 'Success', '23-Feb-2026', '06:14:30 PM', ''), (23, 'devshihab', 'devshihab @gmail.com', 'Bkash', '01999999999', 1000, 'shihabisal', 'Success', '23-Feb-2026', '06:15:24 PM', ''); -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(11) NOT NULL, `email` varchar(150) NOT NULL, `password` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `email`, `password`) VALUES (1, 'admin', '12345678'); -- -------------------------------------------------------- -- -- Table structure for table `dev` -- CREATE TABLE `dev` ( `id` int(11) NOT NULL, `firsttext` varchar(255) NOT NULL, `link` varchar(500) NOT NULL, `link_key` varchar(255) NOT NULL, `text` varchar(1000) DEFAULT NULL, `size` varchar(100) DEFAULT NULL, `size2` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `dev` -- INSERT INTO `dev` (`id`, `firsttext`, `link`, `link_key`, `text`, `size`, `size2`) VALUES (1, '\r\nটুর্নামেন্ট অ্যাপ বিক্রি হচ্ছে', 'http://devxmehedi.top/', 'https://devxmehedi.top', 'আমরা তৈরি করে দিচ্ছি আপনার নিজস্ব Android Tournament App এবং Website Tournament System।\r\n\r\n✔ Automatic Payment System\r\n✔ Admin System\r\n✔ Moderator Panel\r\n✔ সম্পূর্ন কাস্টম ডিজাইন \r\n\r\n💰 শুরু মাত্র ৭,০০০ টাকা থেকে!\r\n\r\nhttps://devxmehedi.top', '19', '14'); -- -------------------------------------------------------- -- -- Table structure for table `freefire` -- CREATE TABLE `freefire` ( `id` int(11) NOT NULL, `match_title` varchar(100) NOT NULL, `match_time` varchar(50) NOT NULL, `total_prize` int(11) NOT NULL, `per_kill` int(11) NOT NULL, `entry_fee` int(11) NOT NULL, `entry_type` varchar(10) NOT NULL, `match_type` varchar(20) NOT NULL, `version` varchar(10) NOT NULL, `play_map` varchar(10) NOT NULL, `registration` varchar(10) NOT NULL, `prize_details` text DEFAULT NULL, `total_player` int(11) NOT NULL, `total_joiner` int(11) NOT NULL DEFAULT 0, `match_result` varchar(10) NOT NULL, `room_id` varchar(100) NOT NULL, `room_pass` varchar(100) NOT NULL, `timer` varchar(100) DEFAULT 'Time: 29/09/2024 At 22:00 AM', `join_type` varchar(300) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `freefire` -- INSERT INTO `freefire` (`id`, `match_title`, `match_time`, `total_prize`, `per_kill`, `entry_fee`, `entry_type`, `match_type`, `version`, `play_map`, `registration`, `prize_details`, `total_player`, `total_joiner`, `match_result`, `room_id`, `room_pass`, `timer`, `join_type`) VALUES (1202, 'BR SURVIVAL MATCH', 'Time: 31/03/2026 At 12:00 PM', 620, 5, 15, 'Solo', 'Classic', 'MOBILE', 'Bermuda', 'Open', '🚗 BR Survival Match 🚗\n \n🥇 Winner - 60 Tk\n🥈 2nd Postion - 55 Tk\n🥉 3rd Postion - 50 Tk\n🏅 4th Position - 45 Tk\n🏅 5th Position - 40 Tk\n🏅 6th Position - 35 Tk\n🏅 7th Position - 30 Tk\n🏅 8th Position - 25 Tk\n🏅 9th Postion - 20 Tk\n🏅 10th Positon - 15 Tk\n🚫 Per Kill - 5 Tk\n💸 Entry Fee - 15 Tk\n🏆 Totall Win Prize : 620 Tk', 48, 0, 'NO', '1122', '1133', 'Time: 31/03/2026 At 12:00 AM', ''); -- -------------------------------------------------------- -- -- Table structure for table `ip_limit` -- CREATE TABLE `ip_limit` ( `id` int(11) NOT NULL, `ip_address` varchar(45) NOT NULL, `last_created` bigint(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `ip_limit` -- INSERT INTO `ip_limit` (`id`, `ip_address`, `last_created`) VALUES (1, '45.127.50.18', 1772501491); -- -------------------------------------------------------- -- -- Table structure for table `joiners` -- CREATE TABLE `joiners` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `type` varchar(10) NOT NULL, `email` varchar(100) NOT NULL, `match_id` int(11) NOT NULL, `total_kill` int(11) NOT NULL DEFAULT 0, `winning` int(11) NOT NULL DEFAULT 0, `fcm_key` varchar(250) NOT NULL, `fc` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `joiners` -- INSERT INTO `joiners` (`id`, `name`, `type`, `email`, `match_id`, `total_kill`, `winning`, `fcm_key`, `fc`) VALUES (16, 'JᴇꜱꜱᴏʀᴇㅤTᴏᴘ❶', 'freefire', 'Sakibul75 @gmail.com', 1201, 0, 0, 'Sakibul75 @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (17, 'JᴇꜱꜱᴏʀᴇㅤTᴏᴘ❶', 'freefire', 'Sakibul75 @gmail.com', 1202, 0, 0, 'Sakibul75 @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (19, 'Pro Rubel', 'freefire', 'ProRubel @gmail.com', 1233, 0, 0, 'ProRubel @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (20, 'JᴇꜱꜱᴏʀᴇㅤTᴏᴘ❶', 'freefire', 'Sakibul75 @gmail.com', 1233, 0, 0, 'Sakibul75 @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (21, 'JᴇꜱꜱᴏʀᴇㅤTᴏᴘ❶', 'freefire', 'Sakibul75 @gmail.com', 1204, 0, 0, 'Sakibul75 @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (26, 'hsheb\nehehhe', 'freefire', 'Sakibul75 @gmail.com', 1237, 0, 0, 'Sakibul75 @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (27, '\njshshshsghs', 'freefire', 'Sakibul75 @gmail.com', 1237, 0, 0, 'Sakibul75 @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (28, 'ywhsgsgs', 'freefire', 'Sakibul75 @gmail.com', 1237, 0, 0, 'Sakibul75 @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (29, 'JᴇꜱꜱᴏʀᴇㅤTᴏᴘ❶', 'freefire', 'Sakibul75 @gmail.com', 1237, 0, 0, 'Sakibul75 @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (30, 'jsjsjssjsj\najjshshs', 'freefire', 'Liss @gmail.com', 1237, 0, 0, 'Liss @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (31, 'jshshs.shshhs', 'freefire', 'Liss @gmail.com', 1237, 0, 0, 'Liss @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (32, 'uauahwgsg', 'freefire', 'Liss @gmail.com', 1237, 0, 0, 'Liss @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (33, 'wjqkjab🤬', 'freefire', 'Liss @gmail.com', 1237, 0, 0, 'Liss @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (34, 'JᴇꜱꜱᴏʀᴇㅤTᴏᴘ❶', 'freefire', 'Sakibul75 @gmail.com', 1205, 0, 0, 'Sakibul75 @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (35, 'JᴇꜱꜱᴏʀᴇㅤTᴏᴘ❶', 'freefire', 'Sakibul75 @gmail.com', 1206, 0, 0, 'Sakibul75 @gmail.com', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (36, 'সিহাব', 'freefire', 'devshihab @gmail.com', 1201, 0, 0, 'devshihab @gmail.com', 'dOoy7ihDLCU:APA91bGV9_kYwUOmq9qP6X9SxaLTXD5XiAhPHHsbKfc7Efx8ukPnoZS3ioSRFoEKCXN4B8dFLESqKyd4mnBu5CtHiQTNkN-JZYCI1vfv5E9czE-Qp4snhHo'), (37, 'dev shihab', 'freefire', 'devshihab @gmail.com', 1202, 0, 0, 'devshihab @gmail.com', 'dOoy7ihDLCU:APA91bGV9_kYwUOmq9qP6X9SxaLTXD5XiAhPHHsbKfc7Efx8ukPnoZS3ioSRFoEKCXN4B8dFLESqKyd4mnBu5CtHiQTNkN-JZYCI1vfv5E9czE-Qp4snhHo'), (38, 'devshihab ', 'freefire', 'devshihab @gmail.com', 1238, 0, 0, 'devshihab @gmail.com', 'cmeieSBnns4:APA91bHHuHVkXfnjjIE6fmpVvSHw_kW14PuUva7hI34vluUBT2t6DiBeRTJkR9UxSpm8z0VjbR3ADgGX__2nurhjx8ldclBfyWStYa40EbMwOP7URIgy-Ow'), (39, 'Mehedi', 'freefire', 'Mehedi @gmail.com', 1202, 0, 0, 'Mehedi @gmail.com', 'ecyO2uJYn0Y:APA91bG-DNrh5eQLArzSu5m62vD2LCQZOM1FMmERLeubPAXKG8-G9ZGtoTE715bytRoMSwRrJ1X_Qx5988l98j2WOp2_uRQp-xNRX-JmdsP496B-mdu6kFA'); -- -------------------------------------------------------- -- -- Table structure for table `ludoking` -- CREATE TABLE `ludoking` ( `id` int(11) NOT NULL, `match_title` varchar(1000) NOT NULL, `match_time` varchar(50) NOT NULL, `total_prize` int(11) NOT NULL, `entry_fee` int(11) NOT NULL, `entry_type` varchar(10) NOT NULL, `match_type` varchar(15) NOT NULL, `play_map` varchar(15) NOT NULL, `registration` varchar(10) NOT NULL, `prize_details` varchar(1000) NOT NULL, `total_player` int(11) NOT NULL, `total_joiner` int(11) NOT NULL DEFAULT 0, `match_result` varchar(10) NOT NULL, `room_details` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `mehedi_admin` -- CREATE TABLE `mehedi_admin` ( `id` int(11) NOT NULL, `homenotice` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `versioncode` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updatelink` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updatenotice` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updatedon` longtext DEFAULT NULL, `application` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `autopay` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notice` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `closedreason` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `mehedi_admin` -- INSERT INTO `mehedi_admin` (`id`, `homenotice`, `versioncode`, `updatelink`, `updatenotice`, `updatedon`, `application`, `autopay`, `notice`, `closedreason`) VALUES (1, '⛔Br এ বাহিরের প্লেয়ার ইনভাইট দিবেন না - নাইলে সোজা কিক খাবেন টাকা Refund পাবেন না⛔\n\nডিপোজিটে সমস্যা হলে টেলিগ্রামে মেসেজ দিন✅ নাম্বারে কল দিবেন না দয়া করে⛔\n\n*উইথড্র💥\n\nসকাল ৯ টা থেকে রাত ১০ টা পর্যন্ত 🔥\n\nযেকোনো সহযোগিতায় টেলিগ্রামে যোগাযোগ করুন 💝\n', '1.0', 'https://khelazone.top/Khela Zone.apk', 'Bug Fixed', '02-Dec-2025', 'ON', 'ON', 'যেকোন প্রয়োজনে টেলিগ্রামে যোগাযোগ করুন এবং এডমিনকে ইনবক্স করে অপেক্ষা করুন সমাধান পাবেন ইনশাআল্লাহ ।', 'App Currently off. Please try again.'); -- -------------------------------------------------------- -- -- Table structure for table `mehedi_number` -- CREATE TABLE `mehedi_number` ( `id` int(11) NOT NULL, `bkash` longtext NOT NULL, `nagad` longtext NOT NULL, `rocket` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `mehedi_number` -- INSERT INTO `mehedi_number` (`id`, `bkash`, `nagad`, `rocket`) VALUES (1, '01757317561', '01757317561', '01987474202'); -- -------------------------------------------------------- -- -- Table structure for table `mehedi_rules` -- CREATE TABLE `mehedi_rules` ( `id` int(11) NOT NULL, `br` text DEFAULT NULL, `cs` text DEFAULT NULL, `cs2` text DEFAULT NULL, `lw` text DEFAULT NULL, `free` text DEFAULT NULL, `ld` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `mehedi_rules` -- INSERT INTO `mehedi_rules` (`id`, `br`, `cs`, `cs2`, `lw`, `free`, `ld`) VALUES (1, 'BR MATCH ', 'BR SURVIVAL ', 'CS 2V2', 'CLASH SQUAD ', 'FREE MATCH ', 'LONE WOLF'); -- -------------------------------------------------------- -- -- Table structure for table `mehedi_setting` -- CREATE TABLE `mehedi_setting` ( `id` int(11) NOT NULL, `minimumdeposit` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `minimumwithdraw` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `referralbonus` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `adminsupport` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addmoney` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `collectroom` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `joinmatch` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `diamondlink` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `telegramlink` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `mehedi_setting` -- INSERT INTO `mehedi_setting` (`id`, `minimumdeposit`, `minimumwithdraw`, `referralbonus`, `adminsupport`, `addmoney`, `collectroom`, `joinmatch`, `diamondlink`, `telegramlink`) VALUES (1, '10', '80', '0', 'https://t.me/khelazoneowner', '', '', '', '', 'https://t.me/khelazonebd'); -- -------------------------------------------------------- -- -- Table structure for table `mehedi_slider` -- CREATE TABLE `mehedi_slider` ( `id` int(11) NOT NULL, `Url` longtext DEFAULT NULL, `Link` longtext DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `mehedi_slider` -- INSERT INTO `mehedi_slider` (`id`, `Url`, `Link`) VALUES (8, 'https://imagetourl.topzonebd.top/uploads/IMG_20260214_152939_411.jpg', 'https://t.me/devshihab '); -- -------------------------------------------------------- -- -- Table structure for table `refers` -- CREATE TABLE `refers` ( `id` int(11) NOT NULL, `date` varchar(50) NOT NULL, `name` varchar(100) NOT NULL, `status` varchar(20) NOT NULL DEFAULT 'Registered', `refer_by` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `statistics` -- CREATE TABLE `statistics` ( `id` int(11) NOT NULL, `email` varchar(100) NOT NULL, `type` varchar(10) NOT NULL, `match_id` int(11) NOT NULL, `match_title` varchar(1000) NOT NULL, `played_on` varchar(50) NOT NULL, `paid` int(11) NOT NULL, `winnings` int(11) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `statistics` -- INSERT INTO `statistics` (`id`, `email`, `type`, `match_id`, `match_title`, `played_on`, `paid`, `winnings`) VALUES (64, 'Sakibul75 @gmail.com', 'freefire', 1204, 'Lone Wolf ( 1 VS 1 )', '02-Dec-2025 08:55:11 PM', 30, 0), (65, 'Sakibul75 @gmail.com', 'freefire', 1237, 'Squad Time | Mobile | Regular', '03-Dec-2025 12:01:12 PM', 80, 0), (66, 'Sakibul75 @gmail.com', 'freefire', 1237, 'Squad Time | Mobile | Regular', '03-Dec-2025 12:02:20 PM', 80, 0), (67, 'Liss @gmail.com', 'freefire', 1237, 'Squad Time | Mobile | Regular', '03-Dec-2025 12:03:49 PM', 80, 0), (68, 'Sakibul75 @gmail.com', 'freefire', 1205, 'Lone Wolf ( 1 VS 1 )', '03-Dec-2025 05:05:10 PM', 30, 0), (69, 'Sakibul75 @gmail.com', 'freefire', 1206, 'Lone Wolf ( 1 VS 1 )', '03-Dec-2025 06:34:50 PM', 30, 0), (70, 'devshihab @gmail.com', 'freefire', 1201, 'Friday Free Match | Top 10 Prize ID & Pass Telegram Channel dea hobe Sobai Telegram Channel a Join Korun', '13-Feb-2026 12:23:10 AM', 0, 0), (71, 'devshihab @gmail.com', 'freefire', 1202, 'Friday Free Match | Top 10 Prize ID & Pass Telegram Channel dea hobe Sobai Telegram Channel a Join Korun', '13-Feb-2026 12:23:38 AM', 0, 0), (72, 'devshihab @gmail.com', 'freefire', 1238, 'Lone Wolf ( 1 VS 1 )', '23-Feb-2026 06:06:55 PM', 50, 0), (73, 'Mehedi @gmail.com', 'freefire', 1202, 'Solo Time | Mobile | Regular', '03-Mar-2026 01:57:26 PM', 10, 0); -- -------------------------------------------------------- -- -- Table structure for table `transaction` -- CREATE TABLE `transaction` ( `id` int(11) NOT NULL, `gateway` varchar(10) NOT NULL, `method` varchar(10) NOT NULL, `amount` int(11) NOT NULL, `sender` varchar(11) NOT NULL, `trxid` varchar(15) NOT NULL, `status` int(1) NOT NULL DEFAULT 0, `time` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `transaction` -- INSERT INTO `transaction` (`id`, `gateway`, `method`, `amount`, `sender`, `trxid`, `status`, `time`) VALUES (23, 'Nagad', 'Send Money', 50, '01999999999', '74N62QS7', 1, '2025-12-02 01:45:39'), (24, 'Bkash', 'Send Money', 150, '01999999999', 'CJ8BWU5GW', 1, '2025-12-02 07:41:47'), (25, 'Bkash', 'Send Money', 1, '01999999999', 'CL22PVMFCM', 1, '2025-12-02 15:05:53'), (26, 'Bkash', 'Send Money', 200, '01987474202', 'CL37QZ1BEP', 1, '2025-12-03 16:15:14'), (27, 'Nagad', 'Send Money', 10, '01999999999', '74N8LXOQ', 1, '2025-12-04 09:39:01'), (28, 'Nagad', 'Send Money', 10, '01999999999', '74N8LXOE', 1, '2025-12-04 10:15:03'), (29, 'Bkash', 'Send Money', 100, '01999999999', 'shihab ', 0, '2026-02-23 12:13:04'), (30, 'Bkash', 'Send Money', 100, '01999999999', 'shihab ', 0, '2026-02-23 12:13:05'), (31, 'Rocket', 'Send Money', 100, '01999999999', '01693751', 0, '2026-02-23 12:13:53'), (32, 'Rocket', 'Send Money', 100, '01999999999', '01693751', 0, '2026-02-23 12:13:54'), (33, 'Rocket', 'Send Money', 100, '01999999999', '0169375162', 1, '2026-02-23 12:14:25'), (34, 'Bkash', 'Send Money', 1000, '01999999999', 'shihabisal', 1, '2026-02-23 12:15:16'), (35, 'Bkash', 'Send Money', 1000, '01999999999', 'shihabisal', 1, '2026-02-23 12:15:16'); -- -------------------------------------------------------- -- -- Table structure for table `upload` -- CREATE TABLE `upload` ( `id` int(11) NOT NULL, `email` varchar(100) NOT NULL, `game_name` varchar(50) NOT NULL, `match_title` varchar(100) NOT NULL, `total_prize` int(11) NOT NULL, `image_url` varchar(200) NOT NULL, `match_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `first_name` varchar(50) NOT NULL, `last_name` varchar(50) NOT NULL, `username` varchar(50) NOT NULL, `email` varchar(100) NOT NULL, `number` varchar(20) NOT NULL, `password` varchar(30) NOT NULL, `balance` int(11) NOT NULL DEFAULT 0, `winning` int(11) NOT NULL DEFAULT 0, `total_paid` int(11) NOT NULL DEFAULT 0, `total_win` int(11) NOT NULL DEFAULT 0, `refer_earn` int(11) NOT NULL DEFAULT 0, `total_refer` int(11) NOT NULL DEFAULT 0, `fcm_key` varchar(250) NOT NULL, `device_id` varchar(150) NOT NULL, `total_play` int(11) NOT NULL DEFAULT 0, `total_kill` int(11) NOT NULL DEFAULT 0, `status` varchar(10) NOT NULL DEFAULT 'Unban', `reg_date` datetime NOT NULL DEFAULT current_timestamp(), `refer_by` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `first_name`, `last_name`, `username`, `email`, `number`, `password`, `balance`, `winning`, `total_paid`, `total_win`, `refer_earn`, `total_refer`, `fcm_key`, `device_id`, `total_play`, `total_kill`, `status`, `reg_date`, `refer_by`) VALUES (2, 'devshihab', 'devshihab', 'shihabislam00444@gmail.com', 'devshihab @gmail.com', '01904168818', '@shihabff', 1150, 0, 0, 0, 0, 0, 'cmeieSBnns4:APA91bHHuHVkXfnjjIE6fmpVvSHw_kW14PuUva7hI34vluUBT2t6DiBeRTJkR9UxSpm8z0VjbR3ADgGX__2nurhjx8ldclBfyWStYa40EbMwOP7URIgy-Ow', '73f44e86a8230c94', 3, 0, 'Unban', '2026-02-12 23:27:39', 'false'), (3, 'Mehedi', 'Mehedi', 'devxmehedi@gmail.com', 'Mehedi @gmail.com', '01608028356', 'Mehedi600', 990, 0, 0, 0, 0, 0, 'ecyO2uJYn0Y:APA91bG-DNrh5eQLArzSu5m62vD2LCQZOM1FMmERLeubPAXKG8-G9ZGtoTE715bytRoMSwRrJ1X_Qx5988l98j2WOp2_uRQp-xNRX-JmdsP496B-mdu6kFA', '39d6610c4e2d2a16', 1, 0, 'Unban', '2026-02-13 14:55:07', 'false'), (4, 'Developer_X_Itachi', 'Developer_X_Itachi', 'leong0541@gmail.com', 'Developer_X_Itachi @gmail.com', '01977012494', 'Labib12345', 0, 0, 0, 0, 0, 0, 'dHRIqpU62BE:APA91bEm1hHyirirfyWxim8tXCAQGNxUpubpi-57IrEeK0ZQtkag10TyEvwiFqIDzaFzbO49wxjAp3I8V_C9Qlo6L1qHK8q3KnR55Evcse0WBgJlwVcVQwU', 'd917b43239adc35a', 0, 0, 'Unban', '2026-02-14 19:23:12', 'false'); -- -------------------------------------------------------- -- -- Table structure for table `withdraw` -- CREATE TABLE `withdraw` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `email` varchar(100) NOT NULL, `method` varchar(10) NOT NULL, `number` varchar(15) NOT NULL, `amount` int(11) NOT NULL, `trxid` varchar(10) NOT NULL, `status` varchar(10) NOT NULL DEFAULT 'Pending', `date` varchar(20) NOT NULL, `time` varchar(20) NOT NULL, `fcm` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `withdraw` -- INSERT INTO `withdraw` (`id`, `name`, `email`, `method`, `number`, `amount`, `trxid`, `status`, `date`, `time`, `fcm`) VALUES (5, 'Sakibul75', 'Sakibul75 @gmail.com', 'Nagad', '01757317561', 80, '1O02S2SD', 'Success', '02-Dec-2025', '08:29:27 AM', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (6, 'Sakibul75', 'Sakibul75 @gmail.com', 'Bkash', '01757317561', 80, 'XBI6MMHW', 'Failed', '02-Dec-2025', '09:07:37 PM', 'czp29jcuIEg:APA91bGC273wuTljRLq6rwiGYR7gdSEkYWGVzfmuYVYhKE3Xk-loXzP_w6IGjMfjHltqMo_BoeGyC3EMqlYKhB8SMnE-Rlas4u1YyaYHiQJUcFdymqOm91A'), (7, 'devshihab', 'devshihab @gmail.com', 'BKash', '01904168818', 100, 'CAT524QV', 'Success', '23-Feb-2026', '05:59:29 PM', 'cmeieSBnns4:APA91bHHuHVkXfnjjIE6fmpVvSHw_kW14PuUva7hI34vluUBT2t6DiBeRTJkR9UxSpm8z0VjbR3ADgGX__2nurhjx8ldclBfyWStYa40EbMwOP7URIgy-Ow'); -- -- Indexes for dumped tables -- -- -- Indexes for table `addmoney` -- ALTER TABLE `addmoney` ADD PRIMARY KEY (`id`); -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `dev` -- ALTER TABLE `dev` ADD PRIMARY KEY (`id`); -- -- Indexes for table `freefire` -- ALTER TABLE `freefire` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ip_limit` -- ALTER TABLE `ip_limit` ADD PRIMARY KEY (`id`); -- -- Indexes for table `joiners` -- ALTER TABLE `joiners` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ludoking` -- ALTER TABLE `ludoking` ADD PRIMARY KEY (`id`); -- -- Indexes for table `mehedi_admin` -- ALTER TABLE `mehedi_admin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `mehedi_number` -- ALTER TABLE `mehedi_number` ADD PRIMARY KEY (`id`); -- -- Indexes for table `mehedi_rules` -- ALTER TABLE `mehedi_rules` ADD PRIMARY KEY (`id`); -- -- Indexes for table `mehedi_setting` -- ALTER TABLE `mehedi_setting` ADD PRIMARY KEY (`id`); -- -- Indexes for table `mehedi_slider` -- ALTER TABLE `mehedi_slider` ADD PRIMARY KEY (`id`); -- -- Indexes for table `refers` -- ALTER TABLE `refers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `statistics` -- ALTER TABLE `statistics` ADD PRIMARY KEY (`id`); -- -- Indexes for table `transaction` -- ALTER TABLE `transaction` ADD PRIMARY KEY (`id`); -- -- Indexes for table `upload` -- ALTER TABLE `upload` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `withdraw` -- ALTER TABLE `withdraw` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `addmoney` -- ALTER TABLE `addmoney` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `dev` -- ALTER TABLE `dev` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `freefire` -- ALTER TABLE `freefire` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1203; -- -- AUTO_INCREMENT for table `ip_limit` -- ALTER TABLE `ip_limit` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `joiners` -- ALTER TABLE `joiners` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40; -- -- AUTO_INCREMENT for table `ludoking` -- ALTER TABLE `ludoking` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `mehedi_admin` -- ALTER TABLE `mehedi_admin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `mehedi_number` -- ALTER TABLE `mehedi_number` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `mehedi_setting` -- ALTER TABLE `mehedi_setting` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `mehedi_slider` -- ALTER TABLE `mehedi_slider` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `refers` -- ALTER TABLE `refers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `statistics` -- ALTER TABLE `statistics` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74; -- -- AUTO_INCREMENT for table `transaction` -- ALTER TABLE `transaction` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36; -- -- AUTO_INCREMENT for table `upload` -- ALTER TABLE `upload` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `withdraw` -- ALTER TABLE `withdraw` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; 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 */;