DB CHEAT

-- phpMyAdmin SQL Dump
-- version 4.0.10.14
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Nov 24, 2016 at 02:00 AM
-- Server version: 5.6.33
-- PHP Version: 5.6.20

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

--
-- Database: `andre_1`
--

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

--
-- Table structure for table `api`
--

CREATE TABLE IF NOT EXISTS `api` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `apikey` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `nama` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=53 ;

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

--
-- Table structure for table `balance_history`
--

CREATE TABLE IF NOT EXISTS `balance_history` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `action` enum('Add Balance','Cut Balance') COLLATE utf8_swedish_ci NOT NULL,
  `quantity` int(10) NOT NULL,
  `msg` text COLLATE utf8_swedish_ci NOT NULL,
  `date` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `time` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=48 ;

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

--
-- Table structure for table `garena`
--

CREATE TABLE IF NOT EXISTS `garena` (
  `nama` varchar(200) NOT NULL,
  `code` varchar(200) NOT NULL,
  `jumlah` varchar(200) NOT NULL,
  `harga` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `gemscool`
--

CREATE TABLE IF NOT EXISTS `gemscool` (
  `nama` varchar(200) NOT NULL,
  `code` varchar(200) NOT NULL,
  `jumlah` varchar(200) NOT NULL,
  `harga` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `historyall`
--

CREATE TABLE IF NOT EXISTS `historyall` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `no` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `pembeli` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `barang` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `harga` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `status` enum('Sukses','Pending','Gagal','Sedang Di Proses') COLLATE utf8_swedish_ci NOT NULL,
  `data` varchar(1000) COLLATE utf8_swedish_ci NOT NULL,
  `tanggal` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=689 ;

--
-- Dumping data for table `historyall`
--

INSERT INTO `historyall` (`id`, `no`, `pembeli`, `barang`, `harga`, `status`, `data`, `tanggal`) VALUES
(688, '6480', 'admin', 'Register Cheat PointBlank 3 Hari', '10000', 'Sukses', 'HDSN : W2AD0AF0', '2016-11-24'),
(687, '3445', 'admin', 'Register Cheat PointBlank Permanent', '0', 'Sukses', 'HDSN : WD-WCAT14011153', '2016-11-23'),
(686, '2689', 'sambora', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : 9VY4016S', '2016-11-23'),
(685, '7549', 'tribanyuaji', 'Register Cheat LostSaga 1 Hari', '10000', 'Sukses', 'HDSN : JP2940N025JY2V', '2016-11-23'),
(684, '9632', 'admin', 'Register Cheat PointBlank Permanent', '0', 'Sukses', 'HDSN : 6VDDNTQT', '2016-11-23'),
(683, '5353', 'admin', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : 2143', '2016-11-23'),
(682, '7678', 'admin', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : Z2AX26ZP', '2016-11-23'),
(681, '5263', 'tribanyuaji', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : WD-WCAMD9636284', '2016-11-23'),
(680, '4669', 'admin', 'Register Cheat PointBlank 3 Hari', '10000', 'Sukses', 'HDSN : 9LR1ZW5Q', '2016-11-23'),
(679, '8894', 'tribanyuaji', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : 9VYE7Y79', '2016-11-23'),
(678, '3154', 'tribanyuaji', 'Register Cheat PointBlank 3 Hari', '10000', 'Sukses', 'HDSN : JP2940N025JY2V', '2016-11-23'),
(677, '6631', 'admin', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : as', '2016-11-23'),
(676, '3538', 'admin', 'Register Cheat LostSaga 1 Hari', '10000', 'Sukses', 'HDSN : 12', '2016-11-23'),
(675, '6613', 'sambora', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : 6RW0D9FX', '2016-11-23'),
(674, '5499', 'admin', 'Register Cheat PointBlank 3 Hari', '10000', 'Sukses', 'HDSN : 9VMMJ301', '2016-11-23'),
(673, '1858', 'admin', 'Register Cheat PointBlank 3 Hari', '10000', 'Sukses', 'HDSN : 9VMMJ301', '2016-11-23'),
(672, '6104', 'admin', 'Register Cheat PointBlank 3 Hari', '10000', 'Sukses', 'HDSN : 9VMMJ301', '2016-11-23'),
(671, '6787', 'sambora', 'Register Cheat Suntik 1 Hari', '70000', 'Sukses', 'HDSN : 6RW0D9FX', '2016-11-23'),
(670, '8704', 'admin', 'Register Cheat PointBlank Permanent', '0', 'Sukses', 'HDSN : 5QZ44S0L', '2016-11-23'),
(669, '6017', 'admin', 'Register Cheat PointBlank Permanent', '0', 'Sukses', 'HDSN : 9VYC4BYH', '2016-11-22'),
(668, '4446', 'admin', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : test', '2016-11-22');

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

--
-- Table structure for table `lostsaga`
--

CREATE TABLE IF NOT EXISTS `lostsaga` (
  `name` varchar(30) NOT NULL,
  `reseller` varchar(30) NOT NULL,
  `username` varchar(30) NOT NULL,
  `password` varchar(30) NOT NULL,
  `expired` date NOT NULL,
  `status` varchar(30) NOT NULL,
  PRIMARY KEY (`name`,`reseller`,`username`,`password`,`expired`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lostsaga`
--

INSERT INTO `lostsaga` (`name`, `reseller`, `username`, `password`, `expired`, `status`) VALUES
('IkanTeri', 'tribanyuaji', 'JP2940N025JY2V', '12345', '2016-11-24', 'aktif');

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

--
-- Table structure for table `market`
--

CREATE TABLE IF NOT EXISTS `market` (
  `no` int(10) NOT NULL AUTO_INCREMENT,
  `category` enum('CHEAT','WEBS') CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
  `service` varchar(100) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
  `rate` varchar(50) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
  `min` varchar(50) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
  `max` varchar(50) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
  `provider` varchar(50) NOT NULL,
  `provider_id` int(10) NOT NULL,
  `status` enum('Tersedia','Tidak tersedia') CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table `order_history`
--

CREATE TABLE IF NOT EXISTS `order_history` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `provider` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `buyer` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `service` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `link` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `quantity` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `price` int(10) NOT NULL,
  `status` enum('Pending','Processing','Error','Success') COLLATE utf8_swedish_ci NOT NULL,
  `date` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `time` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=47 ;

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

--
-- Table structure for table `PointBlank`
--

CREATE TABLE IF NOT EXISTS `PointBlank` (
  `name` varchar(30) NOT NULL,
  `reseller` varchar(30) NOT NULL,
  `username` varchar(30) NOT NULL,
  `password` varchar(30) NOT NULL,
  `expired` date NOT NULL,
  `status` varchar(30) NOT NULL,
  PRIMARY KEY (`name`,`reseller`,`username`,`password`,`expired`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PointBlank`
--

INSERT INTO `PointBlank` (`name`, `reseller`, `username`, `password`, `expired`, `status`) VALUES
('2143', 'admin', '2143', '12345', '2016-11-24', 'aktif'),
('5QZ44S0L', 'admin', '5QZ44S0L', '12345', '2290-09-07', 'aktif'),
('6VDDNTQT', 'admin', '6VDDNTQT', '12345', '2290-09-07', 'aktif'),
('9LR1ZW5Q', 'admin', '9LR1ZW5Q', '12345', '2016-11-26', 'aktif'),
('9VMMJ301', 'admin', '9VMMJ301', '12345', '2016-11-26', 'aktif'),
('9VYC4BYH', 'admin', '9VYC4BYH', '12345', '2290-09-06', 'aktif'),
('aaaaaaaaaaaaaaaaaaaaa', 'tribanyuaji', '9VYE7Y79', '12345', '2016-11-24', 'aktif'),
('Aldi', 'tribanyuaji', 'WD-WCAMD9636284', '12345', '2016-11-24', 'aktif'),
('Orang', 'tribanyuaji', 'JP2940N025JY2V', '12345', '2016-11-26', 'aktif'),
('TAMVAN', 'sambora', '6RW0D9FX', '12345', '2016-11-24', 'aktif'),
('tamvan', 'sambora', '9VY4016S', '12345', '2016-11-24', 'aktif'),
('W2AD0AF0', 'admin', 'W2AD0AF0', '12345', '2016-11-27', 'aktif'),
('WD-WCAT14011153', 'admin', 'WD-WCAT14011153', '12345', '2290-09-07', 'aktif'),
('Z2AX26ZP', 'admin', 'Z2AX26ZP', '12345', '2016-11-24', 'aktif');

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

--
-- Table structure for table `Premium`
--

CREATE TABLE IF NOT EXISTS `Premium` (
  `name` varchar(30) NOT NULL,
  `reseller` varchar(30) NOT NULL,
  `username` varchar(30) NOT NULL,
  `password` varchar(30) NOT NULL,
  `expired` date NOT NULL,
  `status` varchar(30) NOT NULL,
  `Premium` varchar(30) NOT NULL,
  PRIMARY KEY (`name`,`reseller`,`username`,`password`,`expired`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Premium`
--

INSERT INTO `Premium` (`name`, `reseller`, `username`, `password`, `expired`, `status`, `Premium`) VALUES
('valen', 'sambora', '6RW0D9FX', '12345', '2016-11-24', 'aktif', '');

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

--
-- Table structure for table `request_balance`
--

CREATE TABLE IF NOT EXISTS `request_balance` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `kode` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `username` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `quantity` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `method` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `status` enum('Pending','Success') COLLATE utf8_swedish_ci NOT NULL,
  `date` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `time` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=50 ;

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

--
-- Table structure for table `service`
--

CREATE TABLE IF NOT EXISTS `service` (
  `no` int(10) NOT NULL AUTO_INCREMENT,
  `category` enum('IG','TW','FB','YT','GP','SC','WEB','VINE','CHEAT','WEBS','HOST') COLLATE utf8_swedish_ci NOT NULL,
  `service` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `rate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `min` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `max` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `provider` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
  `provider_id` int(10) NOT NULL,
  `status` enum('Tersedia','Tidak tersedia') COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=41 ;

--
-- Dumping data for table `service`
--

INSERT INTO `service` (`no`, `category`, `service`, `rate`, `min`, `max`, `provider`, `provider_id`, `status`) VALUES
(3, 'CHEAT', 'Lost Saga Indonesia', '100', '1Day', '30Days', 'X-Assassin', 1, 'Tersedia'),
(4, 'CHEAT', 'Lost Saga Thailand', '100', '1Day', '30Days', 'X-Assassin', 2, 'Tidak tersedia'),
(5, 'CHEAT', 'Lost Saga Taiwan', '100', '1Day', '30Days', 'X-Assassin', 3, 'Tidak tersedia'),
(6, 'CHEAT', 'Lost Saga Korea', '100', '1Day', '30Days', 'X-Assassin', 4, 'Tidak tersedia'),
(7, 'CHEAT', 'Lost Saga Amerika', '100', '1Day', '30Days', 'X-Assassin', 5, 'Tidak tersedia'),
(8, 'CHEAT', 'Point Blank Indonesia', '100', '1Day', '30Days', 'X-Assassin', 6, 'Tidak tersedia'),
(9, 'CHEAT', 'Closer Indonesia', '100', '1Day', '30Days', 'X-Assassin', 7, 'Tidak tersedia'),
(10, 'CHEAT', 'RF Private Server', '100', '1Day', '30Days', 'X-Assassin', 8, 'Tidak tersedia'),
(11, 'CHEAT', 'Crossfire Indonesia', '100', '1Day', '30Days', 'X-Assassin', 9, 'Tidak tersedia'),
(12, 'CHEAT', 'Black Squad Indonesia', '100', '1Day', '30Days', 'X-Assassin', 10, 'Tidak tersedia');

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

--
-- Table structure for table `stockcash`
--

CREATE TABLE IF NOT EXISTS `stockcash` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `jenis` enum('Gemscool Cash','Garena SHELL') COLLATE utf8_swedish_ci NOT NULL,
  `isi` enum('33','66','165','330','1000','2000','3000','5000','10000') COLLATE utf8_swedish_ci NOT NULL,
  `harga` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `kodecash` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=43 ;

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

--
-- Table structure for table `transfersaldo`
--

CREATE TABLE IF NOT EXISTS `transfersaldo` (
  `username` varchar(1000) NOT NULL,
  `penerima` varchar(1000) NOT NULL,
  `jumlah` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `facebook` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `username` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `password` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `nama` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `level` enum('Admin','Reseller','SubReseller') COLLATE utf8_swedish_ci NOT NULL,
  `saldo` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `uplink` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=1014 ;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `facebook`, `username`, `password`, `nama`, `level`, `saldo`, `uplink`) VALUES
(1, '100014309824934', 'admin', '123qweasdzxc', 'Andre Gatami', 'Admin', '99999959999', 'Administrator'),
(1013, '100012164298550', 'tribanyuaji', 'qwerty1234cx', 'Tri Banyu Aji', 'Reseller', '999959999', 'Andre Gatami');

/*!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 */;