· 11 years ago · Aug 03, 2015, 06:49 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : atom
5Source Server Version : 50543
6Source Host : sql4.freemysqlhosting.net:3306
7Source Database : sql484153
8
9Target Server Type : MYSQL
10Target Server Version : 50543
11File Encoding : 65001
12
13Date: 2015-07-17 23:51:31
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for blacklist
20-- ----------------------------
21DROP TABLE IF EXISTS `blacklist`;
22CREATE TABLE `blacklist` (
23 `ID` int(11) NOT NULL AUTO_INCREMENT,
24 `IP` varchar(15) NOT NULL,
25 `note` text NOT NULL,
26 PRIMARY KEY (`ID`)
27) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
28
29-- ----------------------------
30-- Records of blacklist
31-- ----------------------------
32INSERT INTO `blacklist` VALUES ('1', '127.0.0.1', '');
33INSERT INTO `blacklist` VALUES ('3', '1.1.1.1', '');
34INSERT INTO `blacklist` VALUES ('6', '92.238.36.22', 'Don\'t hit him');
35
36-- ----------------------------
37-- Table structure for fe
38-- ----------------------------
39DROP TABLE IF EXISTS `fe`;
40CREATE TABLE `fe` (
41 `ID` int(11) NOT NULL AUTO_INCREMENT,
42 `userID` int(11) NOT NULL,
43 `type` varchar(1) NOT NULL,
44 `ip` varchar(15) NOT NULL,
45 `note` text NOT NULL,
46 PRIMARY KEY (`ID`)
47) ENGINE=MyISAM DEFAULT CHARSET=latin1;
48
49-- ----------------------------
50-- Records of fe
51-- ----------------------------
52
53-- ----------------------------
54-- Table structure for gateway
55-- ----------------------------
56DROP TABLE IF EXISTS `gateway`;
57CREATE TABLE `gateway` (
58 `email` varchar(1024) NOT NULL
59) ENGINE=MyISAM DEFAULT CHARSET=latin1;
60
61-- ----------------------------
62-- Records of gateway
63-- ----------------------------
64INSERT INTO `gateway` VALUES ('blazedstress@hotmail.com');
65
66-- ----------------------------
67-- Table structure for iplogs
68-- ----------------------------
69DROP TABLE IF EXISTS `iplogs`;
70CREATE TABLE `iplogs` (
71 `ID` int(11) NOT NULL AUTO_INCREMENT,
72 `userID` int(11) NOT NULL,
73 `logged` varchar(15) NOT NULL,
74 `date` int(11) NOT NULL,
75 PRIMARY KEY (`ID`),
76 KEY `ID` (`ID`)
77) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;
78
79-- ----------------------------
80-- Records of iplogs
81-- ----------------------------
82INSERT INTO `iplogs` VALUES ('73', '298', '63.141.217.152', '1437089657');
83INSERT INTO `iplogs` VALUES ('72', '292', '208.167.254.53', '1437081577');
84
85-- ----------------------------
86-- Table structure for logs
87-- ----------------------------
88DROP TABLE IF EXISTS `logs`;
89CREATE TABLE `logs` (
90 `user` varchar(15) NOT NULL,
91 `ip` varchar(15) NOT NULL,
92 `port` int(11) NOT NULL,
93 `time` int(11) NOT NULL,
94 `method` varchar(10) NOT NULL,
95 `date` int(11) NOT NULL
96) ENGINE=MyISAM DEFAULT CHARSET=latin1;
97
98-- ----------------------------
99-- Records of logs
100-- ----------------------------
101INSERT INTO `logs` VALUES ('lolamoomoo1', '90.211.155.246', '80', '20', 'SSYN', '1436804100');
102INSERT INTO `logs` VALUES ('callumrose13', '92.238.36.22', '80', '30', 'UDP', '1436806823');
103INSERT INTO `logs` VALUES ('callumrose13', '92.238.36.22', '53', '30', 'UDP', '1436809538');
104INSERT INTO `logs` VALUES ('lolamoomoo1', '188.221.69.28', '80', '300', 'SSYN', '1436809785');
105INSERT INTO `logs` VALUES ('lolamoomoo1', '90.211.155.246', '80', '20', 'UDP', '1436979630');
106INSERT INTO `logs` VALUES ('lolamoomoo1', '73.51.73.174', '80', '10', 'UDP', '1436979921');
107INSERT INTO `logs` VALUES ('lolamoomoo1', '73.51.73.174', '80', '20', 'UDP', '1436980043');
108INSERT INTO `logs` VALUES ('lolamoomoo1', '107.195.133.141', '80', '20', 'UDP', '1436980078');
109INSERT INTO `logs` VALUES ('lolamoomoo1', '107.195.133.141', '80', '60', 'UDP', '1436980302');
110INSERT INTO `logs` VALUES ('lolamoomoo1', '194.110.243.10', '80', '60', 'UDP', '1436980429');
111INSERT INTO `logs` VALUES ('lolamoomoo1', '194.110.243.10', '53', '60', 'UDP', '1436980542');
112INSERT INTO `logs` VALUES ('lolamoomoo1', '194.110.243.10', '80', '300', 'UDP', '1436980686');
113INSERT INTO `logs` VALUES ('IFreeze', '122.109.4.92', '80', '120', 'SSYN', '1436985139');
114INSERT INTO `logs` VALUES ('lolamoomoo1', '1.1.2.1', '8', '1', 'UDP', '1437000858');
115INSERT INTO `logs` VALUES ('lolamoomoo1', '1.1.1.2', '80', '10', 'UDP', '1437000870');
116INSERT INTO `logs` VALUES ('lolamoomoo1', '73.139.50.41', '53', '20', 'UDP', '1437001846');
117INSERT INTO `logs` VALUES ('lolamoomoo1', '194.110.243.10', '80', '300', 'UDP', '1437001937');
118INSERT INTO `logs` VALUES ('Pikotee', '186.150.131.162', '80', '60', 'UDP', '1437002183');
119INSERT INTO `logs` VALUES ('Pikotee', '109.162.39.240', '80', '120', 'UDP', '1437002381');
120INSERT INTO `logs` VALUES ('Pikotee', '109.162.39.240', '80', '120', 'UDP', '1437003120');
121INSERT INTO `logs` VALUES ('Pikotee', '109.162.39.240', '80', '120', 'UDP', '1437003871');
122INSERT INTO `logs` VALUES ('Pikotee', '73.139.50.41', '80', '60', 'UDP', '1437005190');
123INSERT INTO `logs` VALUES ('Pikotee', '80.93.124.85', '80', '120', 'UDP', '1437027776');
124INSERT INTO `logs` VALUES ('Pikotee', '37.201.212.103', '80', '120', 'UDP', '1437040482');
125INSERT INTO `logs` VALUES ('Pikotee', '73.139.50.41', '80', '60', 'UDP', '1437041122');
126INSERT INTO `logs` VALUES ('Inclusive', '188.221.69.28', '80', '60', 'UDP', '1437041756');
127INSERT INTO `logs` VALUES ('lolamoomoo1', '188.221.69.28', '80', '60', 'UDP', '1437050460');
128INSERT INTO `logs` VALUES ('IFreeze', '31.220.16.22', '80', '200', 'SSYN', '1437051870');
129INSERT INTO `logs` VALUES ('lolamoomoo1', '108.175.147.120', '21', '20', 'UDP', '1437052645');
130INSERT INTO `logs` VALUES ('lolamoomoo1', '108.175.147.120', '21', '300', 'UDP', '1437052679');
131INSERT INTO `logs` VALUES ('INCLUSIVE', '104.31.76.207', '80', '500', 'UDP', '1437052768');
132INSERT INTO `logs` VALUES ('lolamoomoo1', '46.105.213.41', '80', '300', 'UDP', '1437060435');
133INSERT INTO `logs` VALUES ('INCLUSIVE', '46.105.213.41', '80', '100', 'UDP', '1437060510');
134INSERT INTO `logs` VALUES ('lolamoomoo1', '62.205.81.189', '80', '1500', 'UDP', '1437066861');
135INSERT INTO `logs` VALUES ('callumrose13', '88.175.184.63', '80', '600', 'UDP', '1437066963');
136INSERT INTO `logs` VALUES ('Brad', '194.110.243.10', '80', '300', 'UDP', '1437069716');
137INSERT INTO `logs` VALUES ('lolamoomoo1', '194.110.243.10', '80', '300', 'UDP', '1437069817');
138INSERT INTO `logs` VALUES ('Brad', '205.196.120.6', '80', '300', 'UDP', '1437070206');
139INSERT INTO `logs` VALUES ('lolamoomoo1', '205.196.120.6', '80', '300', 'UDP', '1437070301');
140INSERT INTO `logs` VALUES ('Brad', '94.229.170.48', '80', '300', 'UDP', '1437070580');
141INSERT INTO `logs` VALUES ('lolamoomoo1', '1.1.1.2', '80', '30', 'UDP', '1437070698');
142INSERT INTO `logs` VALUES ('Brad', '94.4.34.37', '80', '300', 'UDP', '1437071040');
143INSERT INTO `logs` VALUES ('callumrose13', '54.246.94.65', '80', '300', 'UDP', '1437071202');
144INSERT INTO `logs` VALUES ('Brad', '94.4.34.37', '80', '300', 'UDP', '1437071415');
145INSERT INTO `logs` VALUES ('INCLUSIVE', '75.118.240.204', '80', '300', 'UDP', '1437076569');
146INSERT INTO `logs` VALUES ('lolamoomoo1', '1.1.1.2', '80', '1', 'UDP', '1437079322');
147INSERT INTO `logs` VALUES ('lolamoomoo1', '1.1.1.2', '80', '1', 'UDP', '1437079341');
148INSERT INTO `logs` VALUES ('lolamoomoo1', '1.1.1.2', '80', '1', 'UDP', '1437079354');
149INSERT INTO `logs` VALUES ('INCLUSIVE', '75.118.240.204', '80', '3000', 'UDP', '1437079783');
150INSERT INTO `logs` VALUES ('lolamoomoo1', '1.1.1.2', '80', '1', 'UDP', '1437079857');
151INSERT INTO `logs` VALUES ('lolamoomoo1', '1.1.1.2', '80', '1', 'UDP', '1437079923');
152INSERT INTO `logs` VALUES ('lolamoomoo1', '1.1.1.2', '80', '1', 'UDP', '1437079936');
153INSERT INTO `logs` VALUES ('callumrose13', '92.4.14.114', '80', '3100', 'UDP', '1437081786');
154INSERT INTO `logs` VALUES ('lolamoomoo1', '151.227.113.159', '80', '60', 'UDP', '1437085494');
155INSERT INTO `logs` VALUES ('IFreeze', '80.202.165.19', '80', '300', 'UDP', '1437135310');
156
157-- ----------------------------
158-- Table structure for news
159-- ----------------------------
160DROP TABLE IF EXISTS `news`;
161CREATE TABLE `news` (
162 `ID` int(11) NOT NULL AUTO_INCREMENT,
163 `title` varchar(50) NOT NULL,
164 `detail` text NOT NULL,
165 `date` int(11) NOT NULL,
166 PRIMARY KEY (`ID`)
167) ENGINE=MyISAM DEFAULT CHARSET=latin1;
168
169-- ----------------------------
170-- Records of news
171-- ----------------------------
172
173-- ----------------------------
174-- Table structure for payments
175-- ----------------------------
176DROP TABLE IF EXISTS `payments`;
177CREATE TABLE `payments` (
178 `ID` int(11) NOT NULL AUTO_INCREMENT,
179 `paid` float NOT NULL,
180 `plan` int(11) NOT NULL,
181 `user` int(15) NOT NULL,
182 `email` varchar(60) NOT NULL,
183 `tid` varchar(30) NOT NULL,
184 `date` int(255) NOT NULL,
185 PRIMARY KEY (`ID`)
186) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
187
188-- ----------------------------
189-- Records of payments
190-- ----------------------------
191
192-- ----------------------------
193-- Table structure for plans
194-- ----------------------------
195DROP TABLE IF EXISTS `plans`;
196CREATE TABLE `plans` (
197 `ID` int(11) NOT NULL AUTO_INCREMENT,
198 `name` varchar(50) NOT NULL,
199 `description` text NOT NULL,
200 `mbt` int(11) NOT NULL,
201 `unit` varchar(10) NOT NULL,
202 `length` int(11) NOT NULL,
203 `price` float NOT NULL,
204 PRIMARY KEY (`ID`)
205) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
206
207-- ----------------------------
208-- Records of plans
209-- ----------------------------
210INSERT INTO `plans` VALUES ('15', 'Orange pack', '1200 Sec - Lifetime', '1200', 'Years', '1000', '9');
211INSERT INTO `plans` VALUES ('14', 'Blue pack', '900 Sec - Lifetime', '900', 'Years', '1000', '8');
212INSERT INTO `plans` VALUES ('12', 'Green pack ', '600 Sec - Lifetime', '600', 'Years', '1000', '6');
213INSERT INTO `plans` VALUES ('11', 'Red pack ', '300 Sec - Lifetime', '300', 'Years', '1000', '4');
214INSERT INTO `plans` VALUES ('10', 'Debutant Pack', '120 Sec - Lifetime', '120', 'Years', '10000', '3');
215INSERT INTO `plans` VALUES ('16', 'Purple pack', '1500 Sec - Lifetime', '1500', 'Years', '1000', '10');
216INSERT INTO `plans` VALUES ('17', 'Cyan pack', '1800 Sec - Lifetime', '1800', 'Years', '1000', '11');
217INSERT INTO `plans` VALUES ('18', 'Yellow pack', '2100 Sec - Lifetime', '2100', 'Years', '1000', '13');
218INSERT INTO `plans` VALUES ('19', 'Gray pack', '2500 Sec - Lifetime', '2500', 'Years', '1000', '14');
219INSERT INTO `plans` VALUES ('20', 'White pack', '2800 Sec - Lifetime', '2800', 'Years', '1000', '15');
220INSERT INTO `plans` VALUES ('21', 'Black pack', '3100 Sec - Lifetime', '3100', 'Years', '1000', '17');
221INSERT INTO `plans` VALUES ('25', 'All Inclusive', '5000 Sec - Lifetime', '5000', 'Years', '1000', '25');
222
223-- ----------------------------
224-- Table structure for users
225-- ----------------------------
226DROP TABLE IF EXISTS `users`;
227CREATE TABLE `users` (
228 `ID` int(11) NOT NULL AUTO_INCREMENT,
229 `username` varchar(15) NOT NULL,
230 `password` varchar(40) NOT NULL,
231 `email` varchar(50) NOT NULL,
232 `rank` int(11) NOT NULL DEFAULT '0',
233 `membership` int(11) NOT NULL,
234 `expire` int(11) NOT NULL,
235 `status` int(11) NOT NULL,
236 PRIMARY KEY (`ID`),
237 KEY `ID` (`ID`)
238) ENGINE=MyISAM AUTO_INCREMENT=302 DEFAULT CHARSET=latin1;
239
240-- ----------------------------
241-- Records of users
242-- ----------------------------
243INSERT INTO `users` VALUES ('273', 'lolamoomoo1', 'dd629cdec186b2ea60fedb81eaf733f748414bf1', 'blazedlewis@nigge.rs', '1', '21', '0', '0');
244INSERT INTO `users` VALUES ('274', 'Inclusive', '4bb9630609cb7feec830356a48956e9d12b70249', 'Inclusive@nigge.rs', '1', '21', '0', '0');
245INSERT INTO `users` VALUES ('275', 'iKatKing10362', '24bc829b26063fbe2bc5888b72cd795a788cffba', 'artinius.king@gmail.com', '0', '10', '0', '0');
246INSERT INTO `users` VALUES ('276', 'callumrose13', '0d55870981d30c9e2a4faafe9dab995c5cc8510f', 'callumbrose13@gmail.com', '0', '21', '0', '0');
247INSERT INTO `users` VALUES ('277', 'IFreeze', 'bb7ee8164894e9ab4e77b2a62af017172e6d3b67', 'ifreeze@cock.li', '0', '21', '0', '0');
248INSERT INTO `users` VALUES ('278', 'ProMannen', '28ac5ded182848b39b9f88159a822684927df6bc', 'sawallsynder@gmail.com', '0', '0', '0', '0');
249INSERT INTO `users` VALUES ('279', 'SquashMC', '31c6dd1f83c018a90a9d92f7ccaebad25d10788f', 'rashad.najee.muhammad@gmail.com', '0', '0', '0', '0');
250INSERT INTO `users` VALUES ('280', 'Gazement', '4061c2ee636f985a548b64734e5cbb406ce6953b', 'Ozn@cock.li', '0', '11', '0', '0');
251INSERT INTO `users` VALUES ('281', 'SenkaTheGod', 'a642a77abd7d4f51bf9226ceaf891fcbb5b299b8', 'fwfEW@fewf.ewfwef', '0', '0', '0', '0');
252INSERT INTO `users` VALUES ('282', 'ZombieDigital', '5cdee40241f43e99464a74d37943ab1b6d67e38a', 'wiiugaming68@gmail.com', '0', '0', '0', '0');
253INSERT INTO `users` VALUES ('283', 'Pikotee', '36194a7b337654025a8443d1d1b04bae56484bde', 'ibertrand@rocketmail.com', '0', '10', '0', '0');
254INSERT INTO `users` VALUES ('284', 'Abris21', '4bb339cb95ecbd0137810930ad84ded375e4d952', 'fredrikkirkegaard2@hotmail.com', '0', '0', '0', '0');
255INSERT INTO `users` VALUES ('285', 'Savaged', '1d092999f88cacc1802619e63479ba715273f4ab', 'salinas.richie10@gmail.com', '0', '0', '0', '0');
256INSERT INTO `users` VALUES ('286', 'wtwy', '57ff76d4201abbbca1b1cb3e05ab4bb034875591', 'asdj3@hotmail.com', '0', '0', '0', '0');
257INSERT INTO `users` VALUES ('287', 'Brad', '4f68981f1acb2a877473f07e6f2c0ad26986f2ff', 'ghostvideogamers@gmail.com', '0', '11', '0', '0');
258INSERT INTO `users` VALUES ('288', 'Johnclarke', '2223a9f6363ec39b1ea255fd2b0133b2853868f0', 'johnclarke420@yahoo.com', '0', '0', '0', '0');
259INSERT INTO `users` VALUES ('289', 'avichi', 'b361f2ceecad30e2b7a9b8cf98f2b06456621550', 'dennydoty12@hotmail.com', '0', '0', '0', '0');
260INSERT INTO `users` VALUES ('290', 'hugo', '090be37688c4b63111c30f2caa8bad70e9be9895', 'hugoampereira@hotmail.com', '0', '0', '0', '0');
261INSERT INTO `users` VALUES ('291', 'Millenium', 'e961bd179d22562b97627cad1984d126521e2007', 'millenium@nigge.rs', '0', '0', '0', '0');
262INSERT INTO `users` VALUES ('292', 'nigger', '85fe8de475bc9884da850bb5ac9dedaa50a5f850', 'weed@null.net', '0', '0', '0', '0');
263INSERT INTO `users` VALUES ('293', 'aggrun', '92114177563c7b5998bda0d12ec67dde39afc7df', 'aggronboss@gmail.com', '0', '0', '0', '0');
264INSERT INTO `users` VALUES ('294', 'nixcommands', '2bb23f0638d7c87cb44b0f7abe9ce85ecdd13212', 'randomemail@email.com', '0', '0', '0', '0');
265INSERT INTO `users` VALUES ('295', 'Lover2901', '18ebda8a59112354834a6ed225f9f1d97d9e81ff', 'jatuporn.r@web.de', '0', '0', '0', '0');
266INSERT INTO `users` VALUES ('296', 'amigo2011', '3d0f3b9ddcacec30c4008c5e030e6c13a478cb4f', 'md.bruns@home.nl', '0', '0', '0', '0');
267INSERT INTO `users` VALUES ('297', 'ghosted', '86c3ea6e30a58ef2c1a88e70752ec9a54d444ce2', 'doxnet@armyspy.com', '0', '0', '0', '0');
268INSERT INTO `users` VALUES ('298', 'ghosting', 'e85eaece86b58f512bf08dd1d47161561d6766d4', 'ghost@armyspy.com', '0', '0', '0', '0');
269INSERT INTO `users` VALUES ('300', 'InclusiveModz', '4bb9630609cb7feec830356a48956e9d12b70249', 'InclusiveModz@gmail.com', '0', '0', '0', '0');
270INSERT INTO `users` VALUES ('301', 'Rida', 'f5ad543b59574efcbe91f03cd0c57dd0e6990714', 'rida123@gmail.com', '0', '10', '0', '0');