-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Mar 23, 2024 at 02:47 AM
-- Server version: 10.11.7-MariaDB-cll-lve
-- PHP Version: 7.2.34

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

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

--
-- Table structure for table `addmoney`
--

CREATE TABLE `addmoney` (
  `id` int(11) NOT NULL,
  `email` text NOT NULL,
  `m_id` int(11) NOT NULL,
  `amount` decimal(11,0) NOT NULL,
  `status` text NOT NULL,
  `oderid` text NOT NULL,
  `txid` text NOT NULL,
  `data` text NOT NULL,
  `trans_date` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `addmoney`
--

INSERT INTO `addmoney` (`id`, `email`, `m_id`, `amount`, `status`, `oderid`, `txid`, `data`, `trans_date`) VALUES
(1, 'ahhhhgs', 2, 1, 'SUCCESS', 'TEST1699000548', '1699000570', '{\"txnStatus\":\"TXN_SUCCESS\",\"resultInfo\":\"Txn Success\",\"orderId\":\"TEST1699000548\",\"txnAmount\":\"1.00\",\"txnId\":1699000570,\"bankTxnId\":\"20231103110920000927200964582015804\",\"paymentMode\":\"UPI\",\"txnDate\":\"2023-11-03 02:06:10\",\"utr\":\"330795484739\",\"sender_vpa\":\"8709566166\",\"sender_note\":\"2\",\"payee_vpa\":\"paytmqr2810050501014ffnhthkzu7m@paytm\"}', '03/11/2023_08:36:13'),
(2, 'ahhhhgs', 2, 1, 'SUCCESS', 'TEST1699000778', '1699000800', '{\"txnStatus\":\"TXN_SUCCESS\",\"resultInfo\":\"Txn Success\",\"orderId\":\"TEST1699000778\",\"txnAmount\":\"1.00\",\"txnId\":1699000800,\"bankTxnId\":\"20231103111070000927201929812932381\",\"paymentMode\":\"UPI\",\"txnDate\":\"2023-11-03 02:10:00\",\"utr\":\"330713214280\",\"sender_vpa\":\"8709566166\",\"sender_note\":\"2\",\"payee_vpa\":\"paytmqr2810050501014ffnhthkzu7m@paytm\"}', '03/11/2023_08:40:03'),
(3, 'ahhhhgs', 2, 1, 'SUCCESS', 'TEST1699000864', '1699000885', '{\"txnStatus\":\"TXN_SUCCESS\",\"resultInfo\":\"Txn Success\",\"orderId\":\"TEST1699000864\",\"txnAmount\":\"1.00\",\"txnId\":1699000885,\"bankTxnId\":\"20231103110920000927202270763106572\",\"paymentMode\":\"UPI\",\"txnDate\":\"2023-11-03 02:11:25\",\"utr\":\"330776622829\",\"sender_vpa\":\"8709566166\",\"sender_note\":\"2\",\"payee_vpa\":\"paytmqr2810050501014ffnhthkzu7m@paytm\"}', '03/11/2023_08:41:28'),
(4, 'ahhhhgs', 2, 1, 'SUCCESS', 'TEST1699001273', '1699001295', '{\"txnStatus\":\"TXN_SUCCESS\",\"resultInfo\":\"Txn Success\",\"orderId\":\"TEST1699001273\",\"txnAmount\":\"1.00\",\"txnId\":1699001295,\"bankTxnId\":\"20231103110980000927204000058407130\",\"paymentMode\":\"UPI\",\"txnDate\":\"2023-11-03 02:18:15\",\"utr\":\"330794663075\",\"sender_vpa\":\"8709566166\",\"sender_note\":\"2\",\"payee_vpa\":\"paytmqr2810050501014ffnhthkzu7m@paytm\"}', '03/11/2023_08:48:18'),
(5, 'ahhhhgs', 2, 1, 'SUCCESS', 'TEST1699001609', '1699001661', '{\"txnStatus\":\"TXN_SUCCESS\",\"resultInfo\":\"Txn Success\",\"orderId\":\"TEST1699001609\",\"txnAmount\":\"1.00\",\"txnId\":1699001661,\"bankTxnId\":\"20231103110990000927205512960160893\",\"paymentMode\":\"UPI\",\"txnDate\":\"2023-11-03 02:24:21\",\"utr\":\"330730348037\",\"sender_vpa\":\"8709566166\",\"sender_note\":\"2\",\"payee_vpa\":\"paytmqr2810050501014ffnhthkzu7m@paytm\"}', '03/11/2023_08:54:24'),
(6, 'ahhhhgs', 2, 1, 'SUCCESS', 'TEST1699001797', '1699001830', '{\"txnStatus\":\"TXN_SUCCESS\",\"resultInfo\":\"Txn Success\",\"orderId\":\"TEST1699001797\",\"txnAmount\":\"1.00\",\"txnId\":1699001830,\"bankTxnId\":\"20231103111090000927206227917038476\",\"paymentMode\":\"UPI\",\"txnDate\":\"2023-11-03 02:27:10\",\"utr\":\"330779221421\",\"sender_vpa\":\"8709566166\",\"sender_note\":\"2\",\"payee_vpa\":\"paytmqr2810050501014ffnhthkzu7m@paytm\"}', '03/11/2023_08:57:12');

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

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

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `username` text NOT NULL,
  `email` text NOT NULL,
  `Password` text NOT NULL,
  `block` text NOT NULL,
  `permission` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `adminffd`
--

CREATE TABLE `adminffd` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `default_login` enum('0','1') NOT NULL DEFAULT '0' COMMENT '0=yes,1=no',
  `permission` longtext NOT NULL,
  `craeted_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `history_trans`
--

CREATE TABLE `history_trans` (
  `id` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `title` int(11) NOT NULL,
  `time` text NOT NULL,
  `amount` int(11) NOT NULL,
  `oldamount` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `visble` int(11) NOT NULL,
  `member_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `history_trans`
--

INSERT INTO `history_trans` (`id`, `type`, `title`, `time`, `amount`, `oldamount`, `status`, `visble`, `member_id`) VALUES
(1, 2, 3, '03/11/2023_02:21:06', 0, 1000, 0, 0, 1),
(2, 2, 1, '03/11/2023_08:18:57', 0, 0, 0, 0, 2),
(3, 2, 1, '03/11/2023_08:58:49', 10, 500, 0, 0, 1),
(4, 2, 1, '03/11/2023_08:58:59', 10, 500, 0, 0, 1),
(5, 2, 1, '03/11/2023_08:59:43', 10, 9500, 0, 0, 1),
(6, 2, 1, '03/11/2023_09:00:08', 25, 9490, 0, 0, 1),
(7, 2, 3, '03/11/2023_09:40:24', 0, 9465, 0, 0, 1),
(8, 2, 1, '05/11/2023_04:39:49', 10, 9455, 0, 0, 1);

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

--
-- Table structure for table `matches`
--

CREATE TABLE `matches` (
  `m_id` int(11) NOT NULL,
  `match_name` varchar(50) NOT NULL,
  `match_url` varchar(255) NOT NULL,
  `match_time` varchar(100) NOT NULL,
  `win_prize` double NOT NULL,
  `prize_description` text NOT NULL,
  `room_description` text DEFAULT NULL,
  `per_kill` double NOT NULL,
  `entry_fee` double NOT NULL,
  `type` varchar(50) NOT NULL,
  `MAP` varchar(50) NOT NULL,
  `game_id` int(11) NOT NULL,
  `match_type` text NOT NULL,
  `match_desc` text NOT NULL,
  `match_private_desc` text NOT NULL,
  `no_of_player` int(11) NOT NULL,
  `match_status` enum('0','1','2','3','4') DEFAULT '1' COMMENT '0=deactive,1=active,2 =complete,3 = start,4=cancel',
  `date_created` datetime NOT NULL,
  `number_of_position` int(11) NOT NULL,
  `result_notification` text NOT NULL,
  `match_banner` varchar(200) NOT NULL,
  `match_sponsor` text NOT NULL,
  `pin_match` enum('0','1') NOT NULL DEFAULT '0' COMMENT '0=no,1=yes',
  `image_id` int(11) NOT NULL,
  `total_player` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `matches`
--

INSERT INTO `matches` (`m_id`, `match_name`, `match_url`, `match_time`, `win_prize`, `prize_description`, `room_description`, `per_kill`, `entry_fee`, `type`, `MAP`, `game_id`, `match_type`, `match_desc`, `match_private_desc`, `no_of_player`, `match_status`, `date_created`, `number_of_position`, `result_notification`, `match_banner`, `match_sponsor`, `pin_match`, `image_id`, `total_player`) VALUES
(7, '1vs1 new cs squard', 'https://fairbattle.earnmoreap.in/', '15/06/2023 4:00 pm', 85, '<p>Winner Team Got 85rs</p>\n\n<p>&nbsp;</p>\n', NULL, 0, 50, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n', '', 2, '2', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 2),
(8, 'Ludo King 1 vs 1', '', '11/09/2023', 18, '<p> winner Got 18rs</p>', 'id pass', 0, 10, 'solo', 'Ludo', 3, 'Tppi', 'No Hack no froud after win match <a href=\"https://api.whatsapp.com/send?phone=917545812537&text=Hello%20Fair%20Battle%20Support\" > WhatsApp us <a>', '', 2, '1', '2023-06-30 09:17:54', 0, '', '', '', '0', 0, 2),
(9, 'Solo Free Fire  Match Free', 'https://fairbattle.earnmoreap.in/', '18/08/2023 8:30 PM', 25, '<h3>1. ₹25 due to less player </h3>\r\n\r\n', '<p>Room Id:- 53280608<p><br><p>Room Password:- 725055<p>', 0, 0, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is solo no hack no froud , must level greater than 30 </strong></p>\r\n', '', 32, '2', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 47),
(11, '1vs1 new cs squard', 'https://fairbattle.earnmoreap.in/', '3/06/2023 9:05 Pm', 40, '<p>Winner Team Got 40rs</p>\n\n<p>&nbsp;</p>\n', '<p>code : 270648473</p>\n\n<p>password : 123</p>\n', 0, 25, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n', '', 2, '2', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 2),
(12, '1vs1 new cs squard', 'https://fairbattle.earnmoreap.in/', '3/06/2023 10:45 Pm', 40, '<p>Winner Team 1 Got 40rs</p>', '<p>code : 271314597</p>\n\n<p>password : 00</p>\n', 0, 25, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n', '', 3, '2', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 2),
(13, '1vs1 new Cs Squard', 'https://fairbattle.earnmoreap.in/', '12/08/2023 08:20Pm', 45, '<p>Winner Won 1st player Got 40rs</p>\r\n', '<p> Team code : 8188935</p>\r\n', 0, 25, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p>', '', 2, '2', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 2),
(14, '4vs4 new Cs Squard', 'https://fairbattle.earnmoreap.in/', '12/08/2023 08:20 Pm', 500, '<p>Winner Team  player Got 125x4₹ </p>\r\n', '<p>code : 271314597</p>\r\n\r\n<p>password : 00</p>\r\n', 0, 75, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p>', '', 0, '0', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 8),
(15, '1vs1 new Craftland', 'https://fairbattle.earnmoreap.in/', '12/08/2023 03:20Pm', 45, '<p>Winner Won 1st player Got 40rs</p>\r\n', '<p> Team code : 8188935</p>\r\n', 0, 25, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p><h3>Match In Craffland<h3>', '', 0, '0', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 2),
(16, '4vs4 new Cs Squard', 'https://fairbattle.earnmoreap.in/', '13/08/2023 09:30 Pm', 80, '<p>Winner Team  player Got 80 </p>\r\n', '<p>code : 271314597</p>\r\n\r\n<p>password : 00</p>\r\n', 0, 50, 'Squard', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p>', '', 0, '0', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 2),
(17, '2vs2 Free Fire Match', 'https://fairbattle.earnmoreap.in/', '15/08/2023 03:00Pm', 80, '<p>Winner Team Got 80rs</p>\r\n', '<p> Team code : 8188935</p>\r\n', 0, 50, 'Due', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector ,No graned And No mag-7\r\n</p><h3> No Hack<h3>', '', 0, '0', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 2),
(18, 'Solo Free Fire  Match #18', 'https://fairbattle.earnmoreap.in/', '18/09/2023 08:30 PM', 350, '<h3>1. ₹60</h3>\n<br>\n<h3>2.  ₹50</h3>\n<br>\n<h3>3.  ₹40</h3><br><P>\n4.  ₹30</p><br>5.  ₹20</p><br>\n\n', NULL, 3, 10, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is solo no hack no froud </strong></p>\r\n', '', 24, '1', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 48),
(19, '1vs1 new Craftland', 'https://fairbattle.earnmoreap.in/', '19/08/2023 08:30Pm', 25, '<p>Winner Won 1st player Got 25rs</p>\r\n', '<p>code : 58041694</p>\n\n<p> Password: 45 </p>\n', 0, 15, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p><h3>Match In Craffland<h3>', '', 2, '2', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 2),
(20, '1vs1 new Craftland', 'https://fairbattle.earnmoreap.in/', '21/08/2023 07:30Pm', 40, '<p>Winner Won 1st player Got 40rs</p>\n', '<p>Team code : 0786248</p>\r\n\r\n\r\n', 0, 25, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p><h3>Match In Craffland<h3>', '', 2, '2', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 2),
(21, '2vs2 Fairbattle #21', 'https://fairbattle.earnmoreap.in/', '08/09/2023 3:30 PM', 60, '<p>Winner Won 1st player Got 30rs</p><br><p>Winner Won 2st player Got 30rs</p>\n', '<p>Team code : 0786248</p>\r\n\r\n\r\n', 0, 20, 'Due', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\n</p>', '', 0, '4', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 4),
(22, 'Solo Free Fire  Match Free', 'https://fairbattle.earnmoreap.in/', '04/09/2023 8:30 PM', 50, '<h3>1. ₹50 if 41+ player not join prize decrease or postpond </h3>\r\n\r\n', '<p>Room Id:- 97600732 <p><br><p>Room Password:- 87095 <p>', 0, 0, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is solo no hack no froud , must level greater than 30 </strong></p>\r\n', '', 33, '2', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 47),
(23, '1vs1 Free fire', 'https://fairbattle.earnmoreap.in/', '09/09/2023 02:30Pm', 40, '<p>Winner Won 1st player Got 40rs</p>\r\n', '<p> Room Id : 123568387</p>\r\n<p> password: 11</p>\r\n\r\n\r\n', 0, 25, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p><h3>Match In Craffland<h3>', '', 2, '2', '0000-00-00 00:00:00', 2, '', '', '', '0', 1, 2),
(24, 'Fair Solo Free Fire  Match Free ', 'https://fairbattle.earnmoreap.in/', '07/09/2023 3:00 PM', 75, '<br> <p> 1st player - 50 </p> </br>2st player - 25 </p> \n', '<p>Room Id:- 113945577 <p><p>Room Password:- 007 <p>', 0, 5, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is solo no hack no froud , must level greater than 30 </strong></p>\r\n', '', 32, '2', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 47),
(25, 'Free Solo bgmi  Match #25', 'https://fairbattle.earnmoreap.in/', '13/09/2023 3:00 PM', 75, '<br> <p> 1st player - ₹30 </p> </br>2nd player - ₹20 </p> \n</p> </br>3rd player - ₹10 </p> \n</p> </br>4th-7th player - ₹5</p> \n', '<p>Room Id:- 113945577 <p><p>Room Password:- 007 <p>', 0, 0, 'Solo', 'Erangel', 1, 'TPP', '<p><strong>Match is solo no hack no froud , must level greater than 30 </strong></p>\r\n', '', 66, '3', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 100),
(26, 'Fair Solo bgmi  Match #26', 'https://fairbattle.earnmoreap.in/', '10/09/2023 3:00 PM', 75, '<br> <p> 1st player - ₹30 </p> </br>2nd player - ₹20 </p> \n</p> </br>3rd player - ₹10 </p> \n</p> </br>4th-7th player - ₹5</p> \n', '<p>Room Id:- 113945577 <p><p>Room Password:- 007 <p>', 0, 0, 'Solo', 'Erangel', 1, 'TPP', '<p><strong>Match is solo no hack no froud , must level greater than 30 </strong></p>\r\n', '', 0, '0', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 100),
(27, 'Fair Solo Free Fire  Match Free ', 'https://fairbattle.earnmoreap.in/', '09/09/2023 7:30 PM', 75, '<br> <p> 1st player - ₹30 </p> </br>2nd player - ₹20 </p> \n</p> </br>3rd player - ₹10 </p> \n</p> </br>4th-7th player - ₹5</p> \n', '<p>Room Id:- 125701636 <p><p>Room Password:- 87009 <p>', 0, 5, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is solo no hack no froud , must level greater than 30 </strong></p>\r\n', '', 71, '2', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 75),
(28, 'Fair Solo Free Fire  Match Free ', 'https://fairbattle.earnmoreap.in/', '11/09/2023 3:00 PM', 75, '<br> <p> 1st player - ₹30 </p> </br>2nd player - ₹20 </p> \r\n</p> </br>3rd player - ₹10 </p> \r\n</p> </br>4th-7th player - ₹5</p> \r\n', '<p>Room Id:- 136934980 <p><p>Room Password:- 0001 <p>', 0, 0, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is solo no hack no froud , must level greater than 30 </strong></p>\r\n', '', 72, '2', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 75),
(29, '1vs1 Free fire', 'https://fairbattle.earnmoreap.in/', '11/09/2023 12:00Pm', 35, '<p>Winner Won 1st player Got 35rs</p>\n', '<p> Room Id : 136002792</p>\r\n<p> password: 80920</p>\r\n\r\n\r\n', 0, 25, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p><h3>Match In Craffland<h3>', '', 2, '2', '0000-00-00 00:00:00', 2, '', '', '', '0', 1, 2),
(30, 'Ludo King 1 vs 1', '', '11/09/2023', 18, '<p> winner Got 18rs</p>', 'id pass', 0, 10, 'solo', 'Ludo', 3, 'Tppi', 'No Hack no froud after win match <a href=\"https://api.whatsapp.com/send?phone=917545812537&text=Hello%20Fair%20Battle%20Support\" > WhatsApp us <a>', '', 0, '1', '2023-06-30 09:17:54', 0, '', '', '', '0', 0, 2),
(31, 'Ludo King 1 vs 1', '', '11/09/2023', 35, '<p> winner Got 35rs</p>', 'id pass', 0, 20, 'solo', 'Ludo', 3, 'Tppi', 'No Hack no froud after win match <a href=\"https://api.whatsapp.com/send?phone=917545812537&text=Hello%20Fair%20Battle%20Support\" > WhatsApp us <a>', '', 0, '1', '2023-06-30 09:17:54', 0, '', '', '', '0', 0, 2),
(32, 'Ludo King 1 vs 1', '', '11/09/2023', 35, '<p> winner Got 35rs</p>', 'id pass', 0, 20, 'solo', 'Ludo', 3, 'Tppi', 'No Hack no froud after win match <a href=\"https://api.whatsapp.com/send?phone=917545812537&text=Hello%20Fair%20Battle%20Support\" > WhatsApp us <a>', '', 0, '1', '2023-06-30 09:17:54', 0, '', '', '', '0', 0, 2),
(33, 'Fair Solo Free Fire  Match Free ', 'https://fairbattle.earnmoreap.in/', '13 sep 2:30 PM', 75, '<br> <p> 1st player - ₹30 </p> </br>2nd player - ₹20 </p> \r\n</p> </br>3rd player - ₹10 </p> \r\n</p> </br>4th-7th player - ₹5</p> \r\n', '<p>Room Id:- 146847369 <p><p>Room Password:- 121 <p>', 0, 0, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is solo no hack no froud , must level greater than 30 </strong></p>\r\n', '', 85, '2', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 85),
(34, '1vs1 Free fire', 'https://fairbattle.earnmoreap.in/', '13/09/2023 01:00Pm', 35, '<p>Winner Won 1st player Got 35rs</p>\n', '<p> Room Id : 146468760 </p>\r\n<p> password: 6666 </p>\r\n\r\n\r\n', 0, 25, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p>', '', 2, '2', '0000-00-00 00:00:00', 2, '', '', '', '0', 1, 2),
(35, '4vs4 CS Free fire', 'https://fairbattle.earnmoreap.in/', '17 sep 1:00PM', 60, '<p>Winner Every Player Get ₹15*4</p>\r\n', '<p> Room Id : 169150469 </p>\r\n<p> password: 98 </p>\r\n\r\n\r\n', 0, 10, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p>', '', 8, '2', '0000-00-00 00:00:00', 2, '', '', '', '0', 1, 8),
(36, '2vs2 CS Free fire', 'https://fairbattle.earnmoreap.in/', '18 sep 6:00 PM', 60, '<p>Winner Every Player Get ₹30*2</p>\r\n', '<p> Room Id : 177641469 </p>\r\n<p> password: 98</p>\r\n\r\n\r\n', 0, 20, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p>', '', 4, '2', '0000-00-00 00:00:00', 2, '', '', '', '0', 1, 4),
(37, '1vs1 Free fire', 'https://fairbattle.earnmoreap.in/', '15/09/2023 03:30Pm', 35, '<p>Winner Won 1st player Got 35rs</p>\r\n', '<p> Room Id : 157618406 </p>\r\n<p> password: 0001 </p>\r\n\r\n\r\n', 0, 25, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p>', '', 2, '2', '0000-00-00 00:00:00', 2, '', '', '', '0', 1, 2),
(38, '1vs1 Free fire', 'https://fairbattle.earnmoreap.in/', '17/09/2023 03:30Pm', 35, '<p>Winner Won 1st player Got 35rs</p>\r\n', '<p> Room Id : 170403838 </p>\r\n<p> password: 91 </p>\r\n\r\n\r\n', 0, 25, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p>', '', 2, '2', '0000-00-00 00:00:00', 2, '', '', '', '0', 1, 2),
(39, '1vs1 Free fire', 'https://fairbattle.earnmoreap.in/', '18/09/2023 08:00Pm', 35, '<p>Winner Won 1st player Got 35rs</p>\r\n', '<p> Room Id : 178606756 </p>\n<p> password: 77 </p>\n\n\n', 0, 25, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p>', '', 2, '2', '0000-00-00 00:00:00', 2, '', '', '', '0', 1, 2),
(40, 'Fair Solo Free Fire  Match Free ', 'https://fairbattle.earnmoreap.in/', '22/09/2023 2:00 PM', 75, '<br> <p> 1st player - ₹30 </p> </br>2nd player - ₹20 </p> \r\n</p> </br>3rd player - ₹10 </p> \r\n</p> </br>4th-7th player - ₹5</p> \r\n', '<p>Room Id:- 202409388 <p><p>Room Password:- 91 <p>', 0, 0, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is solo no hack no froud , must level greater than 30 </strong></p>\r\n', '', 72, '2', '2023-06-15 16:22:09', 2, '', '', '', '0', 1, 75),
(41, '1vs1 Free fire', 'https://fairbattle.earnmoreap.in/', '18/09/2023 08:00Pm', 35, '<p>Winner Won 1st player Got 35rs</p>\r\n', '<p> Room Id : 178606756 </p>\r\n<p> password: 77 </p>\r\n\r\n\r\n', 0, 25, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p>', '', 1, '1', '0000-00-00 00:00:00', 2, '', '', '', '0', 1, 2),
(42, '4vs4 CS Free fire', 'https://fairbattle.earnmoreap.in/', '22/09/2023 03:00PM', 60, '<p>Winner Every Player Get ₹15*4</p>\r\n', '<p> Room Id : 169150469 </p>\r\n<p> password: 98 </p>\r\n\r\n\r\n', 0, 10, 'Solo', 'Bermuda', 2, 'TPP', '<p><strong>Match is clasahsqud</strong></p>\r\n<br><p>The tournament will be played in the Clash Squad Ranked mode, ensuring a competitive and balanced environment for all teams. No Vector No graned No mag-7\r\n</p>', '', 3, '1', '0000-00-00 00:00:00', 2, '', '', '', '0', 1, 8);

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

--
-- Table structure for table `match_join_member`
--

CREATE TABLE `match_join_member` (
  `match_join_member_id` int(11) NOT NULL,
  `match_id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `pubg_id` varchar(50) NOT NULL,
  `team` text NOT NULL,
  `position` varchar(50) NOT NULL,
  `place` double NOT NULL,
  `place_point` double NOT NULL,
  `killed` int(11) NOT NULL,
  `win` double NOT NULL,
  `win_prize` double NOT NULL,
  `bonus` double NOT NULL,
  `total_win` double NOT NULL,
  `refund` double NOT NULL,
  `entry_from` enum('0','1','2') NOT NULL DEFAULT '0' COMMENT '0=unknown,1=app,2=web',
  `date_craeted` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `match_join_member`
--

INSERT INTO `match_join_member` (`match_join_member_id`, `match_id`, `member_id`, `pubg_id`, `team`, `position`, `place`, `place_point`, `killed`, `win`, `win_prize`, `bonus`, `total_win`, `refund`, `entry_from`, `date_craeted`) VALUES
(1, 25, 2, '11', '', '0', 0, 0, 0, 0, 0, 0, 0, 0, '2', '0000-00-00 00:00:00'),
(2, 18, 1, 'Uhh', '', '0', 0, 0, 0, 0, 0, 0, 0, 0, '2', '0000-00-00 00:00:00'),
(3, 41, 1, '66', '', '0', 0, 0, 0, 0, 0, 0, 0, 0, '2', '0000-00-00 00:00:00'),
(4, 42, 1, 'ajay', '', '0', 0, 0, 0, 0, 0, 0, 0, 0, '2', '0000-00-00 00:00:00');

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

--
-- Table structure for table `userdataa`
--

CREATE TABLE `userdataa` (
  `id` int(11) NOT NULL,
  `username` text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
  `email` text NOT NULL,
  `Password` text NOT NULL,
  `block` int(11) NOT NULL,
  `addmoney` int(11) NOT NULL,
  `winmoney` int(11) NOT NULL,
  `total_match` int(11) NOT NULL,
  `withdrawal` int(11) NOT NULL,
  `referby` text NOT NULL,
  `refercode` text NOT NULL,
  `refa` int(11) NOT NULL,
  `refb` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `userdataa`
--

INSERT INTO `userdataa` (`id`, `username`, `email`, `Password`, `block`, `addmoney`, `winmoney`, `total_match`, `withdrawal`, `referby`, `refercode`, `refa`, `refb`) VALUES
(1, 'Ajay', 'kusratsingh@gmail.com', '12345678', 0, 8955, 490, 3, 510, 'no', 'Ajay', 0, 0),
(2, 'ajay', 'kusratsinghh@gmail.com', '12345678', 0, 600, 0, 1, 0, 'no', 'ajay', 0, 0),
(3, 'AjaySingh', 'kusratsinghj@gmail.com', '12345678', 0, 0, 0, 0, 0, 'no', 'AjaySingh', 0, 0),
(4, 'Nk', 'Demo@gmail.com', '123456', 0, 0, 0, 0, 0, 'no', 'Nk', 0, 0),
(5, 'ajibar', 'ajibcomedy@gmail.com', 'Ajibar@78', 0, 0, 0, 0, 0, 'no', 'ajibar', 0, 0);

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

--
-- Table structure for table `withdraw`
--

CREATE TABLE `withdraw` (
  `id` int(11) NOT NULL,
  `upiid` text NOT NULL,
  `amount` int(11) NOT NULL,
  `time` text NOT NULL,
  `status` int(11) NOT NULL,
  `memer_id` int(11) NOT NULL,
  `date` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdraw`
--

INSERT INTO `withdraw` (`id`, `upiid`, `amount`, `time`, `status`, `memer_id`, `date`) VALUES
(1, 'Ggh', 500, '03/11/2023_02:21:06', 0, 1, ''),
(2, '766677ggh', 10, '03/11/2023_09:40:24', 0, 1, '');

--
-- 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 `history_trans`
--
ALTER TABLE `history_trans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `matches`
--
ALTER TABLE `matches`
  ADD PRIMARY KEY (`m_id`);

--
-- Indexes for table `match_join_member`
--
ALTER TABLE `match_join_member`
  ADD PRIMARY KEY (`match_join_member_id`);

--
-- Indexes for table `userdataa`
--
ALTER TABLE `userdataa`
  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=7;

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `history_trans`
--
ALTER TABLE `history_trans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `matches`
--
ALTER TABLE `matches`
  MODIFY `m_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `match_join_member`
--
ALTER TABLE `match_join_member`
  MODIFY `match_join_member_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `userdataa`
--
ALTER TABLE `userdataa`
  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=3;
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 */;
