· 9 years ago · Dec 23, 2016, 04:50 PM
1CREATE TABLE IF NOT EXISTS `MainData` (
2 `ID` int(11) NOT NULL AUTO_INCREMENT,
3 `SID` varchar(128) NOT NULL,
4 `Username` varchar(128) NOT NULL,
5 `Global` int(11) NOT NULL DEFAULT '0',
6 `Currency` int(11) NOT NULL DEFAULT '0',
7 `PremiumCurrency` int(11) NOT NULL DEFAULT '0',
8 `Kills` int(11) NOT NULL DEFAULT '0',
9 `Deaths` int(11) NOT NULL DEFAULT '0',
10 `Games` int(11) NOT NULL DEFAULT '0',
11 `Won` int(11) NOT NULL DEFAULT '0',
12 `Lost` int(11) NOT NULL DEFAULT '0',
13 `Streak` int(11) NOT NULL DEFAULT '0',
14 `EquippedGun1` int(11) NOT NULL DEFAULT '1',
15 `EquippedGun2` int(11) NOT NULL DEFAULT '2',
16 `Horizon` int(11) NOT NULL DEFAULT '1',
17 `Usergroup` varchar(128) NOT NULL DEFAULT 'USER',
18 PRIMARY KEY (`ID`)
19) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;
20
21--
22-- Dumping data for table `MainData`
23--
24
25
26-- --------------------------------------------------------
27
28--
29-- Table structure for table `WeaponData`
30--
31
32CREATE TABLE IF NOT EXISTS `WeaponData` (
33 `ID` int(11) NOT NULL AUTO_INCREMENT,
34 `SteamID` varchar(64) NOT NULL,
35 `Data` mediumtext NOT NULL,
36 PRIMARY KEY (`ID`)
37) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;
38
39--
40-- Dumping data for table `WeaponData`
41--
42
43INSERT INTO `WeaponData` (`ID`, `SteamID`, `Data`) VALUES
44(33, 'STEAM_0:0:59541175', '[{"Level":73,"Kills":1081,"Name":"UMP-45","Unlocked":1},{"Level":72,"Kills":1067,"Name":"P99","Unlocked":1},{"Level":70,"Kills":1065,"Name":"AK47","Unlocked":1},{"Level":72,"Kills":1079,"Name":"AR15","Unlocked":1},{"Level":70,"Kills":1065,"Name":"Five Seven","Unlocked":1},{"Level":72,"Kills":1077,"Name":"Scar-H","Unlocked":1},{"Level":72,"Kills":1067,"Name":"G3A3","Unlocked":1},{"Level":72,"Kills":1076,"Name":"G36C","Unlocked":1},{"Level":72,"Kills":1068,"Name":"MP5","Unlocked":1},{"Level":72,"Kills":1072,"Name":"Desert Eagle","Unlocked":1},{"Level":70,"Kills":1065,"Name":"L115","Unlocked":1},{"Level":73,"Kills":1085,"Name":"L85A2","Unlocked":1},{"Level":72,"Kills":1072,"Name":"M14","Unlocked":1},{"Level":70,"Kills":1065,"Name":"M1911","Unlocked":1},{"Level":73,"Kills":1082,"Name":"M249","Unlocked":1},{"Level":72,"Kills":1072,"Name":"M3","Unlocked":1},{"Level":72,"Kills":1068,"Name":"Mac-11","Unlocked":1},{"Level":70,"Kills":1065,"Name":"MR96","Unlocked":1},{"Level":72,"Kills":1068,"Name":"PM","Unlocked":1},{"Level":72,"Kills":1068,"Name":"Shorty","Unlocked":1},{"Level":71,"Kills":1066,"Name":"VSS","Unlocked":1}]'),
45(35, 'STEAM_0:0:100213027', '[{"Name":"UMP-45","Kills":3,"Unlocked":1,"Level":1},{"Name":"P99","Kills":2,"Unlocked":1,"Level":1},{"Name":"AK47","Kills":0,"Unlocked":1,"Level":1},{"Name":"AR15","Kills":0,"Unlocked":1,"Level":1},{"Name":"Five Seven","Kills":0,"Unlocked":1,"Level":1},{"Name":"Scar-H","Kills":0,"Unlocked":1,"Level":1},{"Name":"G3A3","Kills":0,"Unlocked":1,"Level":1},{"Name":"G36C","Kills":1,"Unlocked":1,"Level":1},{"Name":"MP5","Kills":0,"Unlocked":1,"Level":1},{"Name":"Desert Eagle","Kills":0,"Unlocked":1,"Level":1},{"Name":"L115","Kills":0,"Unlocked":1,"Level":1},{"Name":"L85A2","Kills":0,"Unlocked":1,"Level":1},{"Name":"M14","Kills":0,"Unlocked":1,"Level":1},{"Name":"M1911","Kills":0,"Unlocked":1,"Level":1},{"Name":"M249","Kills":0,"Unlocked":1,"Level":1},{"Name":"M3","Kills":0,"Unlocked":1,"Level":1},{"Name":"Mac-11","Kills":0,"Unlocked":1,"Level":1},{"Name":"MR96","Kills":0,"Unlocked":1,"Level":1},{"Name":"PM","Kills":0,"Unlocked":1,"Level":1},{"Name":"Shorty","Kills":0,"Unlocked":1,"Level":1},{"Name":"VSS","Kills":0,"Unlocked":1,"Level":1}]'),
46(36, 'STEAM_0:0:81269929', '[{"Level":1,"Kills":0,"Name":"UMP-45","Unlocked":1},{"Level":1,"Kills":0,"Name":"P99","Unlocked":1},{"Level":1,"Kills":0,"Name":"AK47","Unlocked":1},{"Level":1,"Kills":0,"Name":"AR15","Unlocked":1},{"Level":1,"Kills":0,"Name":"Five Seven","Unlocked":1},{"Level":1,"Kills":0,"Name":"Scar-H","Unlocked":1},{"Level":1,"Kills":0,"Name":"G3A3","Unlocked":1},{"Level":1,"Kills":0,"Name":"G36C","Unlocked":1},{"Level":1,"Kills":0,"Name":"MP5","Unlocked":1},{"Level":1,"Kills":0,"Name":"Desert Eagle","Unlocked":1},{"Level":1,"Kills":0,"Name":"L115","Unlocked":1},{"Level":1,"Kills":0,"Name":"L85A2","Unlocked":1},{"Level":1,"Kills":0,"Name":"M14","Unlocked":1},{"Level":1,"Kills":0,"Name":"M1911","Unlocked":1},{"Level":1,"Kills":0,"Name":"M249","Unlocked":1},{"Level":1,"Kills":0,"Name":"M3","Unlocked":1},{"Level":1,"Kills":0,"Name":"Mac-11","Unlocked":1},{"Level":1,"Kills":0,"Name":"MR96","Unlocked":1},{"Level":1,"Kills":0,"Name":"PM","Unlocked":1},{"Level":1,"Kills":0,"Name":"Shorty","Unlocked":1},{"Level":1,"Kills":0,"Name":"VSS","Unlocked":1}]'),
47(37, 'STEAM_0:1:73301929', '[{"Unlocked":1,"Kills":0,"Level":1,"Name":"UMP-45"},{"Unlocked":1,"Kills":1,"Level":1,"Name":"P99"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"AK47"},{"Unlocked":1,"Kills":18,"Level":2,"Name":"AR15"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Five Seven"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Scar-H"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"G3A3"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"G36C"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"MP5"},{"Unlocked":1,"Kills":2,"Level":1,"Name":"Desert Eagle"},{"Unlocked":1,"Kills":1,"Level":1,"Name":"L115"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"L85A2"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"M14"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"M1911"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"M249"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"M3"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Mac-11"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"MR96"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"PM"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Shorty"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"VSS"}]'),
48(38, 'STEAM_0:0:11544930', '[{"Level":1,"Kills":8,"Name":"UMP-45","Unlocked":1},{"Level":1,"Kills":3,"Name":"P99","Unlocked":1},{"Level":1,"Kills":0,"Name":"AK47","Unlocked":1},{"Level":1,"Kills":2,"Name":"AR15","Unlocked":1},{"Level":1,"Kills":0,"Name":"Five Seven","Unlocked":1},{"Level":1,"Kills":0,"Name":"Scar-H","Unlocked":1},{"Level":1,"Kills":0,"Name":"G3A3","Unlocked":1},{"Level":1,"Kills":0,"Name":"G36C","Unlocked":1},{"Level":1,"Kills":0,"Name":"MP5","Unlocked":1},{"Level":1,"Kills":0,"Name":"Desert Eagle","Unlocked":1},{"Level":1,"Kills":0,"Name":"L115","Unlocked":1},{"Level":1,"Kills":0,"Name":"L85A2","Unlocked":1},{"Level":1,"Kills":0,"Name":"M14","Unlocked":1},{"Level":1,"Kills":0,"Name":"M1911","Unlocked":1},{"Level":1,"Kills":0,"Name":"M249","Unlocked":1},{"Level":1,"Kills":0,"Name":"M3","Unlocked":1},{"Level":1,"Kills":0,"Name":"Mac-11","Unlocked":1},{"Level":1,"Kills":0,"Name":"MR96","Unlocked":1},{"Level":1,"Kills":0,"Name":"PM","Unlocked":1},{"Level":1,"Kills":0,"Name":"Shorty","Unlocked":1},{"Level":1,"Kills":0,"Name":"VSS","Unlocked":1}]'),
49(39, 'STEAM_0:0:45660124', '[{"Unlocked":1,"Kills":16,"Level":2,"Name":"UMP-45"},{"Unlocked":1,"Kills":4,"Level":1,"Name":"P99"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"AK47"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"AR15"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Five Seven"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Scar-H"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"G3A3"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"G36C"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"MP5"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Desert Eagle"},{"Unlocked":1,"Kills":1,"Level":1,"Name":"L115"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"L85A2"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"M14"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"M1911"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"M249"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"M3"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Mac-11"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"MR96"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"PM"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Shorty"},{"Unlocked":1,"Kills":2,"Level":1,"Name":"VSS"}]'),
50(40, 'STEAM_0:1:62816181', '[{"Unlocked":1,"Kills":1,"Level":1,"Name":"UMP-45"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"P99"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"AK47"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"AR15"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Five Seven"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Scar-H"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"G3A3"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"G36C"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"MP5"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Desert Eagle"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"L115"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"L85A2"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"M14"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"M1911"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"M249"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"M3"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Mac-11"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"MR96"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"PM"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"Shorty"},{"Unlocked":1,"Kills":0,"Level":1,"Name":"VSS"}]');
51
52-- --------------------------------------------------------
53
54--
55-- Table structure for table `Weapons`
56--
57
58CREATE TABLE IF NOT EXISTS `Weapons` (
59 `ID` int(11) NOT NULL AUTO_INCREMENT,
60 `Name` varchar(64) NOT NULL,
61 `Class` int(64) NOT NULL DEFAULT '1',
62 `link` varchar(64) NOT NULL,
63 `Rarity` varchar(64) NOT NULL,
64 PRIMARY KEY (`ID`)
65) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
66
67--
68-- Dumping data for table `Weapons`
69--
70
71INSERT INTO `Weapons` (`ID`, `Name`, `Class`, `link`, `Rarity`) VALUES
72(1, 'UMP-45', 1, 'cw_ump45', 'common'),
73(2, 'P99', 2, 'cw_p99', 'common'),
74(3, 'AK47', 1, 'cw_ak47', 'epic'),
75(4, 'AR15', 1, 'cw_ar15', 'epic'),
76(5, 'Five Seven', 2, 'cw_fiveseven', 'rare'),
77(6, 'ScarH', 1, 'cw_scarh', 'common'),
78(7, 'G3A3', 1, 'cw_g3a3', 'common'),
79(8, 'G36C', 1, 'cw_g36c', 'common'),
80(9, 'MP5', 1, 'cw_mp5', 'common'),
81(10, 'Desert Eagle', 2, 'cw_deagle', 'common'),
82(11, 'L115', 1, 'cw_l115', 'rare'),
83(12, 'L85A2', 1, 'cw_l85a2', 'common'),
84(13, 'M14', 1, 'cw_m14', 'common'),
85(14, 'M1911', 2, 'cw_m1911', 'common'),
86(15, 'M249', 1, 'cw_m249_official', 'epic'),
87(16, 'M3', 1, 'cw_m3super90', 'common'),
88(17, 'Mac-11', 2, 'cw_mac11', 'epic'),
89(18, 'MR96', 2, 'cw_mr96', 'common'),
90(19, 'PM', 2, 'cw_makarov', 'common'),
91(20, 'Shorty', 2, 'cw_shorty', 'rare'),
92(21, 'VSS', 1, 'cw_vss', 'common');