diff options
Diffstat (limited to 'devtools/processgamestats/cstrike_gamestats.db')
| -rw-r--r-- | devtools/processgamestats/cstrike_gamestats.db | 191 |
1 files changed, 191 insertions, 0 deletions
diff --git a/devtools/processgamestats/cstrike_gamestats.db b/devtools/processgamestats/cstrike_gamestats.db new file mode 100644 index 0000000..30210d3 --- /dev/null +++ b/devtools/processgamestats/cstrike_gamestats.db @@ -0,0 +1,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"; + |