Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DataBase leaked by #TrojanFM #GForce Pakistan
- Greetz:- #Mr.Instinct, #Keyboard005, #XTAM4, #Sea Monster!!!
- http://www.questonline.in
- -- phpMyAdmin SQL Dump
- -- version 2.11.4
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Apr 27, 2010 at 11:41 AM
- -- Server version: 5.0.51
- -- PHP Version: 5.2.5
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- --
- -- Database: `mlm`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `mlm_admin`
- --
- CREATE TABLE IF NOT EXISTS `mlm_admin` (
- `user_admin` varchar(50) NOT NULL,
- `user_pass` varchar(50) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `mlm_admin`
- --
- INSERT INTO `mlm_admin` (`user_admin`, `user_pass`) VALUES
- ('admin', 'mlm');
- -- --------------------------------------------------------
- --
- -- Table structure for table `mlm_amount`
- --
- CREATE TABLE IF NOT EXISTS `mlm_amount` (
- `id` int(11) NOT NULL,
- `pid` int(11) NOT NULL,
- `amount` decimal(10,2) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `mlm_amount`
- --
- INSERT INTO `mlm_amount` (`id`, `pid`, `amount`) VALUES
- (1, 1001, 10.00);
- -- --------------------------------------------------------
- --
- -- Table structure for table `mlm_levels`
- --
- CREATE TABLE IF NOT EXISTS `mlm_levels` (
- `level` int(11) NOT NULL,
- `amount` decimal(10,2) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `mlm_levels`
- --
- INSERT INTO `mlm_levels` (`level`, `amount`) VALUES
- (1, 1.50),
- (2, 0.20),
- (3, 0.20),
- (4, 0.20),
- (5, 0.20),
- (6, 0.20),
- (7, 0.20),
- (8, 0.10),
- (9, 0.10),
- (10, 0.10),
- (11, 0.10),
- (12, 0.20),
- (13, 0.20),
- (14, 0.20),
- (15, 0.20);
- -- --------------------------------------------------------
- --
- -- Table structure for table `mlm_signup`
- --
- CREATE TABLE IF NOT EXISTS `mlm_signup` (
- `pid` varchar(20) NOT NULL,
- `fname` varchar(200) NOT NULL,
- `lname` varchar(200) NOT NULL,
- `uname` varchar(200) NOT NULL,
- `email` varchar(200) NOT NULL,
- `password` varchar(200) NOT NULL,
- `paymentoptions` varchar(200) NOT NULL,
- `paypelid` varchar(200) NOT NULL,
- `addfname` varchar(200) NOT NULL,
- `addlname` varchar(200) NOT NULL,
- `address` varchar(200) NOT NULL,
- `mandal` varchar(200) NOT NULL,
- `district` varchar(200) NOT NULL,
- `state` varchar(200) NOT NULL,
- `pincode` bigint(200) NOT NULL,
- `terms` varchar(200) NOT NULL,
- `activate` varchar(20) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `mlm_signup`
- --
- INSERT INTO `mlm_signup` (`pid`, `fname`, `lname`, `uname`, `email`, `password`, `paymentoptions`, `paypelid`, `addfname`, `addlname`, `address`, `mandal`, `district`, `state`, `pincode`, `terms`, `activate`) VALUES
- ('1001', 'san3', 'san3', '', '[email protected]', 'san', 'p', '[email protected]', '', '', '', '', '', '', 0, 'no', 'yes'),
- ('1002', 'san', 'san', '', '[email protected]', 'san', 'p', '[email protected]', '', '', '', '', '', '', 0, 'no', 'yes'),
- ('1004', ' san2', 'san2', '', '[email protected]', 'san', 'p', '[email protected]', '', '', '', '', '', '', 0, 'no', 'yes'),
- ('1006', ' san', 'san1', '', '[email protected]', 'san', 'p', '[email protected]', '', '', '', '', '', '', 0, 'no', 'no'),
- ('1007', 'san5', 'san5', '', '[email protected]', 'san', 'p', '[email protected]', '', '', '', '', '', '', 0, 'no', 'no');
- -- --------------------------------------------------------
- --
- -- Table structure for table `mlm_transaction`
- --
- CREATE TABLE IF NOT EXISTS `mlm_transaction` (
- `id` int(11) NOT NULL,
- `pid` int(11) NOT NULL,
- `amount` decimal(10,2) NOT NULL,
- `payamt` decimal(10,2) NOT NULL,
- `balance` decimal(10,2) NOT NULL,
- `transaction` varchar(100) NOT NULL,
- `tr_date` date NOT NULL,
- `pay_date` varchar(60) NOT NULL,
- `paid` varchar(200) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `mlm_transaction`
- --
- INSERT INTO `mlm_transaction` (`id`, `pid`, `amount`, `payamt`, `balance`, `transaction`, `tr_date`, `pay_date`, `paid`) VALUES
- (1, 1001, 10.00, 10.00, 0.00, 'p', '2010-04-16', '2010-04-22', 'Y');
- -- --------------------------------------------------------
- --
- -- Table structure for table `mlm_tree`
- --
- CREATE TABLE IF NOT EXISTS `mlm_tree` (
- `pid` varchar(60) NOT NULL,
- `id` varchar(60) NOT NULL,
- `userid` varchar(200) NOT NULL,
- `conceptlevel` varchar(60) NOT NULL,
- `startid` int(11) NOT NULL,
- `refid` int(60) NOT NULL,
- `levels` varchar(60) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `mlm_tree`
- --
- INSERT INTO `mlm_tree` (`pid`, `id`, `userid`, `conceptlevel`, `startid`, `refid`, `levels`) VALUES
- ('1002', '102', '[email protected]', '2', 1001, 1001, '2'),
- ('1003', '103', '[email protected]', '2', 1001, 1001, '3'),
- ('1001', '101', '[email protected]', '1', 1001, 0, '3'),
- ('1004', '104', '[email protected]', '3', 1001, 1002, '1'),
- ('1005', '105', '[email protected]', '3', 1001, 1002, '1'),
- ('1006', '106', '[email protected]', '3', 1001, 1003, '1'),
- ('1007', '107', '[email protected]', '3', 1001, 1003, '1');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement