1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
|
create table weapons
(
WeaponID INT,
PRIMARY KEY( WeaponID ),
Count INT,
) TYPE=MyISAM;
create table maps
(
MapName CHAR(16),
PRIMARY KEY( MapName ),
TerroristWins INT,
CTWins INT,
) TYPE=MyISAM;
create table autobuy
(
Purchase CHAR(16),
PRIMARY KEY( Purchase ),
Count INT,
) TYPE=MyISAM;
create table purchases_pricing
(
snapshot CHAR(16),
PRIMARY KEY( snapshot ),
dt2 DATETIME,
weapon_id INT,
purchases INT,
current_price INT,
projected_price INT,
) TYPE=MyISAM;
create table snapshot_counter
(
counter INT,
PRIMARY KEY( counter ),
) TYPE=MyISAM;
create table weapon_info
(
WeaponID INT,
PRIMARY KEY( WeaponID ),
side ENUM('Terrorists', 'Counter-Terrorists', 'Both'),
fullname CHAR( 32 ),
default_price INT,
current_price INT,
) TYPE=MyISAM;
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 1, 3, "228 COMPACT", 600, 600 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 2, 3, "9X19MM SIDEARM", 400, 400 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 16, 3, "K&M .45 TACTICAL", 500, 500 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 25, 3, "NIGHT HAWK .50C", 650, 650 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 11, 2, "ES FIVE-SEVEN", 750, 750 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 10, 1, ".40 DUAL ELITES", 800, 800 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 20, 3, "LEONE 12 GAUGE SUPER", 1700, 1700 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 5, 3, "LEONE YG1265 AUTO SHOTGUN", 3000, 3000 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 22, 2, "SCHMIDT MACHINE PISTOL", 1250, 1250 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 18, 3, "K&M SUB-MACHINE GUN", 1500, 1500 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 12, 3, "K&M UMP45", 1700, 1700 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 29, 3, "ES C90", 2350, 2350 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 7, 1, "INGRAM MAC-10", 1400, 1400 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 15, 2, "CLARION 5.56", 2250, 2250 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 3, 3, "SCHMIDT SCOUT", 2750, 2750 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 21, 2, "MAVERICK M4A1 CARBINE", 3100, 3100 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 8, 2, "BULLPUP", 3500, 3500 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 13, 1, "KRIEG 550 COMMANDO", 4200, 4200 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 26, 1, "KRIEG 552", 3500, 3500 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 17, 3, "MAGNUM SNIPER RIFLE", 4750, 4750 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 14, 1, "IDF DEFENDER", 2000, 2000 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 27, 1, "CV-47", 2500, 2500 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 23, 2, "D3/AU-1", 5000, 5000 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 19, 3, "M249", 5750, 5750 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 31, 3, "KEVLAR", 650, 650 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 32, 3, "KEVLAR+HELMET", 1000, 1000 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 24, 3, "FLASHBANG", 200, 200 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 4, 3, "HE GRENADE", 300, 300 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 9, 3, "SMOKE GRENADE", 300, 300 );
Insert into weapon_info ( WeaponID, side, fullname, default_price, current_price ) values ( 33, 3, "NIGHTVISION", 1250, 1250 );
# update weapons set Count=Count+450 where WeaponID = 0;
# Insert into weapons (WeaponID,Count) values ( 1, 0 );
# update maps set TerroristWins=0, CTWins=0 where MapName = "cs_assault";
# Insert into maps (MapName,TerroristWins, CTWins) values ( "cs_assault", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "cs_compound", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "cs_havana", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "cs_italy", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "cs_militia", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "cs_office", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "de_aztec", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "de_cbble", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "de_chateau", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "de_dust2", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "de_dust", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "de_inferno", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "de_nuke", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "de_piranesi", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "de_port", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "de_prodigy", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "de_tides", 0, 0 );
# Insert into maps (MapName,TerroristWins, CTWins) values ( "de_train", 0, 0 );
//Autobuy
Insert into autobuy (Purchase, Count) values ( "Auto-Buy", 0 );
Insert into autobuy (Purchase, Count) values ( "Re-Buy", 0 );
Insert into autobuy (Purchase, Count) values ( "Auto-Buy: M4A1", 0 );
Insert into autobuy (Purchase, Count) values ( "Auto-Buy: AK47", 0 );
Insert into autobuy (Purchase, Count) values ( "Auto-Buy: Famas", 0 );
Insert into autobuy (Purchase, Count) values ( "Auto-Buy: Galil", 0 );
Insert into autobuy (Purchase, Count) values ( "Auto-Buy: Suit", 0 );
Insert into autobuy (Purchase, Count) values ( "Auto-Buy: Kev", 0 );
update autobuy set Count=0 where Purchase = "Auto-Buy";
update autobuy set Count=0 where Purchase = "Re-Buy";
update autobuy set Count=0 where Purchase = "Auto-Buy: M4A1";
update autobuy set Count=0 where Purchase = "Auto-Buy: AK47";
update autobuy set Count=0 where Purchase = "Auto-Buy: Famas";
update autobuy set Count=0 where Purchase = "Auto-Buy: Galil";
update autobuy set Count=0 where Purchase = "Auto-Buy: Suit";
update autobuy set Count=0 where Purchase = "Auto-Buy: Kev";
//Copy and Paste into the SQL terminal to reset everything
update weapons set Count=0 where WeaponID = 1;
update weapons set Count=0 where WeaponID = 2;
update weapons set Count=0 where WeaponID = 3;
update weapons set Count=0 where WeaponID = 4;
update weapons set Count=0 where WeaponID = 5;
update weapons set Count=0 where WeaponID = 6;
update weapons set Count=0 where WeaponID = 7;
update weapons set Count=0 where WeaponID = 8;
update weapons set Count=0 where WeaponID = 9;
update weapons set Count=0 where WeaponID = 10;
update weapons set Count=0 where WeaponID = 11;
update weapons set Count=0 where WeaponID = 12;
update weapons set Count=0 where WeaponID = 13;
update weapons set Count=0 where WeaponID = 14;
update weapons set Count=0 where WeaponID = 15;
update weapons set Count=0 where WeaponID = 16;
update weapons set Count=0 where WeaponID = 17;
update weapons set Count=0 where WeaponID = 18;
update weapons set Count=0 where WeaponID = 19;
update weapons set Count=0 where WeaponID = 20;
update weapons set Count=0 where WeaponID = 21;
update weapons set Count=0 where WeaponID = 22;
update weapons set Count=0 where WeaponID = 23;
update weapons set Count=0 where WeaponID = 24;
update weapons set Count=0 where WeaponID = 25;
update weapons set Count=0 where WeaponID = 26;
update weapons set Count=0 where WeaponID = 27;
update weapons set Count=0 where WeaponID = 28;
update weapons set Count=0 where WeaponID = 29;
update weapons set Count=0 where WeaponID = 30;
update weapons set Count=0 where WeaponID = 31;
update weapons set Count=0 where WeaponID = 32;
update weapons set Count=0 where WeaponID = 33;
update maps set TerroristWins=0, CTWins=0 where MapName = "cs_assault";
update maps set TerroristWins=0, CTWins=0 where MapName = "cs_compound";
update maps set TerroristWins=0, CTWins=0 where MapName = "cs_havana";
update maps set TerroristWins=0, CTWins=0 where MapName = "cs_italy";
update maps set TerroristWins=0, CTWins=0 where MapName = "cs_militia";
update maps set TerroristWins=0, CTWins=0 where MapName = "cs_office";
update maps set TerroristWins=0, CTWins=0 where MapName = "de_aztec";
update maps set TerroristWins=0, CTWins=0 where MapName = "de_cbble";
update maps set TerroristWins=0, CTWins=0 where MapName = "de_chateau";
update maps set TerroristWins=0, CTWins=0 where MapName = "de_dust2";
update maps set TerroristWins=0, CTWins=0 where MapName = "de_dust";
update maps set TerroristWins=0, CTWins=0 where MapName = "de_inferno";
update maps set TerroristWins=0, CTWins=0 where MapName = "de_nuke";
update maps set TerroristWins=0, CTWins=0 where MapName = "de_piranesi";
update maps set TerroristWins=0, CTWins=0 where MapName = "de_port";
update maps set TerroristWins=0, CTWins=0 where MapName = "de_prodigy";
update maps set TerroristWins=0, CTWins=0 where MapName = "de_tides";
update maps set TerroristWins=0, CTWins=0 where MapName = "de_train";
|