-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- 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 `withdraw`
--
ALTER TABLE `withdraw`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

