· 8 years ago · Mar 21, 2018, 02:22 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10.14
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost:3306
6-- Generation Time: Nov 24, 2016 at 02:00 AM
7-- Server version: 5.6.33
8-- PHP Version: 5.6.20
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `andre_1`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `api`
27--
28
29CREATE TABLE IF NOT EXISTS `api` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `apikey` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
32 `nama` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
33 `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
34 PRIMARY KEY (`id`)
35) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=53 ;
36
37-- --------------------------------------------------------
38
39--
40-- Table structure for table `balance_history`
41--
42
43CREATE TABLE IF NOT EXISTS `balance_history` (
44 `id` int(10) NOT NULL AUTO_INCREMENT,
45 `username` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
46 `action` enum('Add Balance','Cut Balance') COLLATE utf8_swedish_ci NOT NULL,
47 `quantity` int(10) NOT NULL,
48 `msg` text COLLATE utf8_swedish_ci NOT NULL,
49 `date` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
50 `time` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
51 PRIMARY KEY (`id`)
52) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=48 ;
53
54-- --------------------------------------------------------
55
56--
57-- Table structure for table `garena`
58--
59
60CREATE TABLE IF NOT EXISTS `garena` (
61 `nama` varchar(200) NOT NULL,
62 `code` varchar(200) NOT NULL,
63 `jumlah` varchar(200) NOT NULL,
64 `harga` varchar(200) NOT NULL
65) ENGINE=MyISAM DEFAULT CHARSET=latin1;
66
67-- --------------------------------------------------------
68
69--
70-- Table structure for table `gemscool`
71--
72
73CREATE TABLE IF NOT EXISTS `gemscool` (
74 `nama` varchar(200) NOT NULL,
75 `code` varchar(200) NOT NULL,
76 `jumlah` varchar(200) NOT NULL,
77 `harga` varchar(200) NOT NULL
78) ENGINE=MyISAM DEFAULT CHARSET=latin1;
79
80-- --------------------------------------------------------
81
82--
83-- Table structure for table `historyall`
84--
85
86CREATE TABLE IF NOT EXISTS `historyall` (
87 `id` int(10) NOT NULL AUTO_INCREMENT,
88 `no` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
89 `pembeli` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
90 `barang` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
91 `harga` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
92 `status` enum('Sukses','Pending','Gagal','Sedang Di Proses') COLLATE utf8_swedish_ci NOT NULL,
93 `data` varchar(1000) COLLATE utf8_swedish_ci NOT NULL,
94 `tanggal` date NOT NULL,
95 PRIMARY KEY (`id`)
96) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=689 ;
97
98--
99-- Dumping data for table `historyall`
100--
101
102INSERT INTO `historyall` (`id`, `no`, `pembeli`, `barang`, `harga`, `status`, `data`, `tanggal`) VALUES
103(688, '6480', 'admin', 'Register Cheat PointBlank 3 Hari', '10000', 'Sukses', 'HDSN : W2AD0AF0', '2016-11-24'),
104(687, '3445', 'admin', 'Register Cheat PointBlank Permanent', '0', 'Sukses', 'HDSN : WD-WCAT14011153', '2016-11-23'),
105(686, '2689', 'sambora', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : 9VY4016S', '2016-11-23'),
106(685, '7549', 'tribanyuaji', 'Register Cheat LostSaga 1 Hari', '10000', 'Sukses', 'HDSN : JP2940N025JY2V', '2016-11-23'),
107(684, '9632', 'admin', 'Register Cheat PointBlank Permanent', '0', 'Sukses', 'HDSN : 6VDDNTQT', '2016-11-23'),
108(683, '5353', 'admin', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : 2143', '2016-11-23'),
109(682, '7678', 'admin', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : Z2AX26ZP', '2016-11-23'),
110(681, '5263', 'tribanyuaji', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : WD-WCAMD9636284', '2016-11-23'),
111(680, '4669', 'admin', 'Register Cheat PointBlank 3 Hari', '10000', 'Sukses', 'HDSN : 9LR1ZW5Q', '2016-11-23'),
112(679, '8894', 'tribanyuaji', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : 9VYE7Y79', '2016-11-23'),
113(678, '3154', 'tribanyuaji', 'Register Cheat PointBlank 3 Hari', '10000', 'Sukses', 'HDSN : JP2940N025JY2V', '2016-11-23'),
114(677, '6631', 'admin', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : as', '2016-11-23'),
115(676, '3538', 'admin', 'Register Cheat LostSaga 1 Hari', '10000', 'Sukses', 'HDSN : 12', '2016-11-23'),
116(675, '6613', 'sambora', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : 6RW0D9FX', '2016-11-23'),
117(674, '5499', 'admin', 'Register Cheat PointBlank 3 Hari', '10000', 'Sukses', 'HDSN : 9VMMJ301', '2016-11-23'),
118(673, '1858', 'admin', 'Register Cheat PointBlank 3 Hari', '10000', 'Sukses', 'HDSN : 9VMMJ301', '2016-11-23'),
119(672, '6104', 'admin', 'Register Cheat PointBlank 3 Hari', '10000', 'Sukses', 'HDSN : 9VMMJ301', '2016-11-23'),
120(671, '6787', 'sambora', 'Register Cheat Suntik 1 Hari', '70000', 'Sukses', 'HDSN : 6RW0D9FX', '2016-11-23'),
121(670, '8704', 'admin', 'Register Cheat PointBlank Permanent', '0', 'Sukses', 'HDSN : 5QZ44S0L', '2016-11-23'),
122(669, '6017', 'admin', 'Register Cheat PointBlank Permanent', '0', 'Sukses', 'HDSN : 9VYC4BYH', '2016-11-22'),
123(668, '4446', 'admin', 'Register Cheat PointBlank 1 Hari', '10000', 'Sukses', 'HDSN : test', '2016-11-22');
124
125-- --------------------------------------------------------
126
127--
128-- Table structure for table `lostsaga`
129--
130
131CREATE TABLE IF NOT EXISTS `lostsaga` (
132 `name` varchar(30) NOT NULL,
133 `reseller` varchar(30) NOT NULL,
134 `username` varchar(30) NOT NULL,
135 `password` varchar(30) NOT NULL,
136 `expired` date NOT NULL,
137 `status` varchar(30) NOT NULL,
138 PRIMARY KEY (`name`,`reseller`,`username`,`password`,`expired`,`status`)
139) ENGINE=InnoDB DEFAULT CHARSET=latin1;
140
141--
142-- Dumping data for table `lostsaga`
143--
144
145INSERT INTO `lostsaga` (`name`, `reseller`, `username`, `password`, `expired`, `status`) VALUES
146('IkanTeri', 'tribanyuaji', 'JP2940N025JY2V', '12345', '2016-11-24', 'aktif');
147
148-- --------------------------------------------------------
149
150--
151-- Table structure for table `market`
152--
153
154CREATE TABLE IF NOT EXISTS `market` (
155 `no` int(10) NOT NULL AUTO_INCREMENT,
156 `category` enum('CHEAT','WEBS') CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
157 `service` varchar(100) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
158 `rate` varchar(50) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
159 `min` varchar(50) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
160 `max` varchar(50) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
161 `provider` varchar(50) NOT NULL,
162 `provider_id` int(10) NOT NULL,
163 `status` enum('Tersedia','Tidak tersedia') CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
164 PRIMARY KEY (`no`)
165) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
166
167-- --------------------------------------------------------
168
169--
170-- Table structure for table `order_history`
171--
172
173CREATE TABLE IF NOT EXISTS `order_history` (
174 `id` int(10) NOT NULL AUTO_INCREMENT,
175 `order_id` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
176 `provider` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
177 `buyer` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
178 `service` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
179 `link` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
180 `quantity` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
181 `price` int(10) NOT NULL,
182 `status` enum('Pending','Processing','Error','Success') COLLATE utf8_swedish_ci NOT NULL,
183 `date` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
184 `time` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
185 PRIMARY KEY (`id`)
186) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=47 ;
187
188-- --------------------------------------------------------
189
190--
191-- Table structure for table `PointBlank`
192--
193
194CREATE TABLE IF NOT EXISTS `PointBlank` (
195 `name` varchar(30) NOT NULL,
196 `reseller` varchar(30) NOT NULL,
197 `username` varchar(30) NOT NULL,
198 `password` varchar(30) NOT NULL,
199 `expired` date NOT NULL,
200 `status` varchar(30) NOT NULL,
201 PRIMARY KEY (`name`,`reseller`,`username`,`password`,`expired`,`status`)
202) ENGINE=InnoDB DEFAULT CHARSET=latin1;
203
204--
205-- Dumping data for table `PointBlank`
206--
207
208INSERT INTO `PointBlank` (`name`, `reseller`, `username`, `password`, `expired`, `status`) VALUES
209('2143', 'admin', '2143', '12345', '2016-11-24', 'aktif'),
210('5QZ44S0L', 'admin', '5QZ44S0L', '12345', '2290-09-07', 'aktif'),
211('6VDDNTQT', 'admin', '6VDDNTQT', '12345', '2290-09-07', 'aktif'),
212('9LR1ZW5Q', 'admin', '9LR1ZW5Q', '12345', '2016-11-26', 'aktif'),
213('9VMMJ301', 'admin', '9VMMJ301', '12345', '2016-11-26', 'aktif'),
214('9VYC4BYH', 'admin', '9VYC4BYH', '12345', '2290-09-06', 'aktif'),
215('aaaaaaaaaaaaaaaaaaaaa', 'tribanyuaji', '9VYE7Y79', '12345', '2016-11-24', 'aktif'),
216('Aldi', 'tribanyuaji', 'WD-WCAMD9636284', '12345', '2016-11-24', 'aktif'),
217('Orang', 'tribanyuaji', 'JP2940N025JY2V', '12345', '2016-11-26', 'aktif'),
218('TAMVAN', 'sambora', '6RW0D9FX', '12345', '2016-11-24', 'aktif'),
219('tamvan', 'sambora', '9VY4016S', '12345', '2016-11-24', 'aktif'),
220('W2AD0AF0', 'admin', 'W2AD0AF0', '12345', '2016-11-27', 'aktif'),
221('WD-WCAT14011153', 'admin', 'WD-WCAT14011153', '12345', '2290-09-07', 'aktif'),
222('Z2AX26ZP', 'admin', 'Z2AX26ZP', '12345', '2016-11-24', 'aktif');
223
224-- --------------------------------------------------------
225
226--
227-- Table structure for table `Premium`
228--
229
230CREATE TABLE IF NOT EXISTS `Premium` (
231 `name` varchar(30) NOT NULL,
232 `reseller` varchar(30) NOT NULL,
233 `username` varchar(30) NOT NULL,
234 `password` varchar(30) NOT NULL,
235 `expired` date NOT NULL,
236 `status` varchar(30) NOT NULL,
237 `Premium` varchar(30) NOT NULL,
238 PRIMARY KEY (`name`,`reseller`,`username`,`password`,`expired`,`status`)
239) ENGINE=InnoDB DEFAULT CHARSET=latin1;
240
241--
242-- Dumping data for table `Premium`
243--
244
245INSERT INTO `Premium` (`name`, `reseller`, `username`, `password`, `expired`, `status`, `Premium`) VALUES
246('valen', 'sambora', '6RW0D9FX', '12345', '2016-11-24', 'aktif', '');
247
248-- --------------------------------------------------------
249
250--
251-- Table structure for table `request_balance`
252--
253
254CREATE TABLE IF NOT EXISTS `request_balance` (
255 `id` int(10) NOT NULL AUTO_INCREMENT,
256 `kode` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
257 `username` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
258 `quantity` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
259 `method` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
260 `status` enum('Pending','Success') COLLATE utf8_swedish_ci NOT NULL,
261 `date` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
262 `time` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
263 PRIMARY KEY (`id`)
264) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=50 ;
265
266-- --------------------------------------------------------
267
268--
269-- Table structure for table `service`
270--
271
272CREATE TABLE IF NOT EXISTS `service` (
273 `no` int(10) NOT NULL AUTO_INCREMENT,
274 `category` enum('IG','TW','FB','YT','GP','SC','WEB','VINE','CHEAT','WEBS','HOST') COLLATE utf8_swedish_ci NOT NULL,
275 `service` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
276 `rate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
277 `min` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
278 `max` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
279 `provider` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
280 `provider_id` int(10) NOT NULL,
281 `status` enum('Tersedia','Tidak tersedia') COLLATE utf8_swedish_ci NOT NULL,
282 PRIMARY KEY (`no`)
283) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=41 ;
284
285--
286-- Dumping data for table `service`
287--
288
289INSERT INTO `service` (`no`, `category`, `service`, `rate`, `min`, `max`, `provider`, `provider_id`, `status`) VALUES
290(3, 'CHEAT', 'Lost Saga Indonesia', '100', '1Day', '30Days', 'X-Assassin', 1, 'Tersedia'),
291(4, 'CHEAT', 'Lost Saga Thailand', '100', '1Day', '30Days', 'X-Assassin', 2, 'Tidak tersedia'),
292(5, 'CHEAT', 'Lost Saga Taiwan', '100', '1Day', '30Days', 'X-Assassin', 3, 'Tidak tersedia'),
293(6, 'CHEAT', 'Lost Saga Korea', '100', '1Day', '30Days', 'X-Assassin', 4, 'Tidak tersedia'),
294(7, 'CHEAT', 'Lost Saga Amerika', '100', '1Day', '30Days', 'X-Assassin', 5, 'Tidak tersedia'),
295(8, 'CHEAT', 'Point Blank Indonesia', '100', '1Day', '30Days', 'X-Assassin', 6, 'Tidak tersedia'),
296(9, 'CHEAT', 'Closer Indonesia', '100', '1Day', '30Days', 'X-Assassin', 7, 'Tidak tersedia'),
297(10, 'CHEAT', 'RF Private Server', '100', '1Day', '30Days', 'X-Assassin', 8, 'Tidak tersedia'),
298(11, 'CHEAT', 'Crossfire Indonesia', '100', '1Day', '30Days', 'X-Assassin', 9, 'Tidak tersedia'),
299(12, 'CHEAT', 'Black Squad Indonesia', '100', '1Day', '30Days', 'X-Assassin', 10, 'Tidak tersedia');
300
301-- --------------------------------------------------------
302
303--
304-- Table structure for table `stockcash`
305--
306
307CREATE TABLE IF NOT EXISTS `stockcash` (
308 `id` int(10) NOT NULL AUTO_INCREMENT,
309 `jenis` enum('Gemscool Cash','Garena SHELL') COLLATE utf8_swedish_ci NOT NULL,
310 `isi` enum('33','66','165','330','1000','2000','3000','5000','10000') COLLATE utf8_swedish_ci NOT NULL,
311 `harga` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
312 `kodecash` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
313 PRIMARY KEY (`id`)
314) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=43 ;
315
316-- --------------------------------------------------------
317
318--
319-- Table structure for table `transfersaldo`
320--
321
322CREATE TABLE IF NOT EXISTS `transfersaldo` (
323 `username` varchar(1000) NOT NULL,
324 `penerima` varchar(1000) NOT NULL,
325 `jumlah` longtext NOT NULL
326) ENGINE=MyISAM DEFAULT CHARSET=latin1;
327
328-- --------------------------------------------------------
329
330--
331-- Table structure for table `user`
332--
333
334CREATE TABLE IF NOT EXISTS `user` (
335 `id` int(10) NOT NULL AUTO_INCREMENT,
336 `facebook` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
337 `username` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
338 `password` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
339 `nama` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
340 `level` enum('Admin','Reseller','SubReseller') COLLATE utf8_swedish_ci NOT NULL,
341 `saldo` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
342 `uplink` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
343 PRIMARY KEY (`id`)
344) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=1014 ;
345
346--
347-- Dumping data for table `user`
348--
349
350INSERT INTO `user` (`id`, `facebook`, `username`, `password`, `nama`, `level`, `saldo`, `uplink`) VALUES
351(1, '100014309824934', 'admin', '123qweasdzxc', 'Andre Gatami', 'Admin', '99999959999', 'Administrator'),
352(1013, '100012164298550', 'tribanyuaji', 'qwerty1234cx', 'Tri Banyu Aji', 'Reseller', '999959999', 'Andre Gatami');
353
354/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
355/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
356/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;