BEGIN TRANSACTION; -- INSERT INTO List (ID,Type,Name,Value,SortOrder,Active) VALUES (1,'OGRE_SIZE','Mark I',NULL,1.00,1); -- INSERT INTO List (ID,Type,Name,Value,SortOrder,Active) VALUES (2,'OGRE_SIZE','Mark II',NULL,2.00,1); -- INSERT INTO List (ID,Type,Name,Value,SortOrder,Active) VALUES (3,'OGRE_SIZE','Mark III',NULL,3.00,1); -- INSERT INTO List (ID,Type,Name,Value,SortOrder,Active) VALUES (4,'OGRE_SIZE','Fencer',NULL,4.00,1); -- INSERT INTO List (ID,Type,Name,Value,SortOrder,Active) VALUES (5,'OGRE_SIZE','Mark IV',NULL,5.00,1); -- INSERT INTO List (ID,Type,Name,Value,SortOrder,Active) VALUES (6,'OGRE_SIZE','Mark V',NULL,6.00,1); -- INSERT INTO List (ID,Type,Name,Value,SortOrder,Active) VALUES (7,'OGRE_SIZE','Mark VI',NULL,7.00,1); -- INSERT INTO Suspension (ID,Name,ShortName,Value,CombatRatio,Active,Notes) VALUES (1,'T','STDR',2,'1:1',1,''); -- INSERT INTO Suspension (ID,Name,ShortName,Value,CombatRatio,Active,Notes) VALUES (2,'G','GEV',2,'1:1',1,'Takes 1/2 damage (round down) on D/DD CRT results.'); -- INSERT INTO Suspension (ID,Name,ShortName,Value,CombatRatio,Active,Notes) VALUES (3,'W','WLKR',2,'1:1',1,'Optional Rule- TUs can be disabled for a turn (i.e. Could slow Ogre) by D/DD results on CRT. Repeat Ds do not equate to an X.'); -- INSERT INTO Suspension (ID,Name,ShortName,Value,CombatRatio,Active,Notes) VALUES (4,'H','XPER',2,'1:2',1,''); INSERT INTO "GEV_Units" VALUES(1,'APC','APC','Armor','apc',1,2,2,3,0,8.0,0,1,1.0,'Can carry 3 squads of infantry'); INSERT INTO "GEV_Units" VALUES(2,'Aero - Missile','Aero-M','Armor','aero-missile',3,3,2,3,2,15.0,0,1,2.0,NULL); INSERT INTO "GEV_Units" VALUES(3,'Aero - Transport','Aero-T','Armor','aero-transport',0,0,1,3,2,12.0,0,1,3.0,NULL); INSERT INTO "GEV_Units" VALUES(4,'Aero','Aero','Armor','aero',2,2,2,4,3,15.0,0,1,4.0,NULL); INSERT INTO "GEV_Units" VALUES(5,'Armored Car','AC','Armor','ac',1,2,1,4,0,5.0,0,1,5.0,NULL); INSERT INTO "GEV_Units" VALUES(6,'Crawler - Missile','MslCrwl','Armor','crawler-missile',0,0,2,1,0,0.0,1,1,6.0,'MPs go to 2 after firing missile. No road bonus.'); INSERT INTO "GEV_Units" VALUES(7,'GEV - Heavy','HGEV','Armor','gev-heavy',3,3,3,3,2,15.0,0,1,7.0,NULL); INSERT INTO "GEV_Units" VALUES(8,'GEV - Howitzer','G-HWZ','Armor','gev-howitzer',6,6,1,1,1,23.0,0,1,8.0,'Shoot or 2nd move. Road bonus only in first phase'); INSERT INTO "GEV_Units" VALUES(9,'GEV - Light','LGEV','Armor','gev-light',1,2,1,4,3,8.0,1,1,9.0,NULL); INSERT INTO "GEV_Units" VALUES(10,'GEV - Lt. PC','LGEV-PC','Armor','gev-ltpc',1,2,1,4,3,9.0,0,1,10.0,''); INSERT INTO "GEV_Units" VALUES(11,'GEV - Missile','MslGEV','Armor','gev-missile',3,4,2,2,1,14.0,0,1,11.0,'Road bonus only in first phase'); INSERT INTO "GEV_Units" VALUES(12,'GEV - Shark','GEV','Armor','gev-shark',2,2,2,4,3,12.0,0,1,12.0,NULL); INSERT INTO "GEV_Units" VALUES(13,'GEV-PC','GEV-PC','Armor','gev-pc',1,2,2,3,2,11.0,1,1,13.0,NULL); INSERT INTO "GEV_Units" VALUES(14,'GEV','GEV','Armor','gev',2,2,2,4,3,12.0,1,1,14.0,NULL); INSERT INTO "GEV_Units" VALUES(15,'Gun Tower','GTWR','Armor','guntower',4,6,6,0,0,18.0,0,1,15.0,NULL); INSERT INTO "GEV_Units" VALUES(16,'Howitzer - Light','LHWZ','Armor','howitzer-light',3,7,1,0,0,16.0,0,1,16.0,NULL); INSERT INTO "GEV_Units" VALUES(17,'Howitzer - Mobile','MHWZ','Armor','howitzer-mobile',6,6,2,1,0,18.0,1,1,17.0,NULL); INSERT INTO "GEV_Units" VALUES(18,'Howitzer','HWZ','Armor','howitzer',6,8,1,0,0,22.0,1,1,18.0,NULL); INSERT INTO "GEV_Units" VALUES(19,'Long Tom','LTOM','Armor','longtom',4,12,1,0,0,36.0,0,1,19.0,NULL); INSERT INTO "GEV_Units" VALUES(20,'Tank - Assault','ASSLT','Armor','tank-assault',4,2,3,3,0,12.0,0,1,20.0,'Can split attack into 2 attacks of 2 ATT, like a SuperHeavy. 1 AP gun'); INSERT INTO "GEV_Units" VALUES(21,'Tank - Heavy','HVY','Armor','tank-heavy',4,2,3,3,0,10.0,1,1,21.0,NULL); INSERT INTO "GEV_Units" VALUES(22,'Tank - HeavyX','HvyX','Armor','tank-heavyx',3,3,3,3,0,12.0,0,1,22.0,NULL); INSERT INTO "GEV_Units" VALUES(23,'Tank - Light','LT','Armor','tank-light',2,2,2,3,0,7.0,1,1,23.0,NULL); INSERT INTO "GEV_Units" VALUES(24,'Tank - Medium','MT','Armor','tank-med',3,2,2,3,0,8.5,0,1,24.0,NULL); INSERT INTO "GEV_Units" VALUES(25,'Tank - Missile','MslT','Armor','tank-missile',3,4,2,2,0,12.0,1,1,25.0,NULL); INSERT INTO "GEV_Units" VALUES(26,'Tank - Panzer','PNZR','Armor','tank-panzer',2,3,3,3,0,8.5,0,1,26.0,NULL); INSERT INTO "GEV_Units" VALUES(27,'Tank - Superheavy','SHVY','Armor','tank-superheavy',6,3,5,3,0,18.0,1,1,27.0,NULL); INSERT INTO "GEV_Units" VALUES(28,'Walker - D2','Wlkr-2','Armor','walker-d2',2,4,2,2,0,8.0,0,1,28.0,NULL); INSERT INTO "GEV_Units" VALUES(29,'Walker - D3','Wlkr-3','Armor','walker-d3',3,2,3,3,0,9.0,0,1,29.0,NULL); INSERT INTO "GEV_Units" VALUES(30,'CP Alpha','CP-A','CP','cp-alpha',0,0,0,0,0,0.0,1,1,30.0,NULL); INSERT INTO "GEV_Units" VALUES(31,'CP Beta','CP-B','CP','cp-beta',0,0,0,0,0,0.0,1,1,31.0,NULL); INSERT INTO "GEV_Units" VALUES(32,'CP Delta','CP-D','CP','cp-delta',0,0,0,0,0,0.0,0,1,32.0,NULL); INSERT INTO "GEV_Units" VALUES(33,'CP GEV','CP-GEV','CP','cp-gev',0,0,1,1,1,0.0,0,1,33.0,'Road bonus only in 1st movement phase'); INSERT INTO "GEV_Units" VALUES(34,'CP Gamma','CP-G','CP','cp-gamma',0,0,0,0,0,0.0,1,1,34.0,NULL); INSERT INTO "GEV_Units" VALUES(35,'CP Mobile','CP-M','CP','cp-mobile',0,0,1,1,0,0.0,0,1,35.0,NULL); INSERT INTO "GEV_Units" VALUES(36,'Heavy Weapon','HvyWpn','Infantry','heavy-weapon',1,4,0,0,0,0.0,0,1,36.0,NULL); INSERT INTO "GEV_Units" VALUES(37,'Infantry - Engineer','Inf-Eng','Infantry','inf-eng',3,1,3,2,0,9.0,0,1,37.0,NULL); INSERT INTO "GEV_Units" VALUES(38,'Infantry - Jump','Inf-Jmp','Infantry','inf-jump',3,1,3,2,0,12.0,0,1,38.0,'Road bonus only in 1st movement phase'); INSERT INTO "GEV_Units" VALUES(39,'Infantry - Marine','Inf-Mar','Infantry','inf-mar',3,1,3,2,0,7.5,1,1,39.0,'Can move in water'); INSERT INTO "GEV_Units" VALUES(40,'Infantry - Ranger','Inf-Rngr','Infantry','inf-ranger',0,0,0,0,0,0.0,0,1,40.0,NULL); INSERT INTO "GEV_Units" VALUES(41,'Infantry - Recon','Inf-Recon','Infantry','inf-rcn',3,1,3,2,0,10.5,0,1,41.0,'Can move in water'); INSERT INTO "GEV_Units" VALUES(42,'Infantry - Standard','Inf','Infantry','inf-std',3,1,3,2,0,6.0,1,1,42.0,NULL); INSERT INTO "GEV_Units" VALUES(43,'Blank','Blank','Misc','blank',0,0,0,0,0,0.0,0,1,43.0,NULL); INSERT INTO "GEV_Units" VALUES(44,'Building - Admin','Admin','Misc','bldg-admin',0,0,0,0,0,0.0,1,1,44.0,NULL); INSERT INTO "GEV_Units" VALUES(45,'Bunker','Bunker','Misc','bunker',0,0,0,0,0,0.0,0,1,45.0,'Doubles defense of infantry within.'); INSERT INTO "GEV_Units" VALUES(46,'Hovertruck','HVTRK','Misc','hovertruck',0,0,1,2,1,0.0,1,1,46.0,NULL); INSERT INTO "GEV_Units" VALUES(47,'Laser Tower','LTWR','Misc','bldg-laser-tower',2,60,0,0,0,0.0,1,1,47.0,'20 SP'); INSERT INTO "GEV_Units" VALUES(48,'Laser','Laser','Misc','bldg-laser',2,30,0,0,0,0.0,1,1,48.0,'30 SP'); INSERT INTO "GEV_Units" VALUES(49,'Reactor','Ractor','Misc','bldg-power',0,0,0,0,0,0.0,1,1,49.0,'60 SP'); INSERT INTO "GEV_Units" VALUES(50,'Truck','Truck','Misc','truck',0,0,1,2,0,1.0,1,1,50.0,NULL); INSERT INTO "Gear" VALUES(0,0.0,'',NULL,0,0,0,0,0,0,NULL,15,3,0,0,15,0,1); INSERT INTO "Gear" VALUES(1,-20.0,'Main Batteries','MB',4,3,4,24,1,1,NULL,15,3,0,0,15,0,1); INSERT INTO "Gear" VALUES(2,-19.0,'Secondary Batteries','SB',3,2,3,15,1,1,NULL,15,3,0,0,15,0,1); INSERT INTO "Gear" VALUES(3,0.0,'Tertiary Batteries','TB',2,1,2,5,0,1,NULL,15,3,0,0,20,0,1); INSERT INTO "Gear" VALUES(4,-17.0,'Missiles, Internal','Msl-I',6,5,0,6,1,1,'Cannot be attacked separately.',10,4,0,0,40,0,1); INSERT INTO "Gear" VALUES(5,-18.0,'Missiles, External','Msl-E',6,5,3,12,1,1,NULL,10,4,0,0,20,0,1); INSERT INTO "Gear" VALUES(6,-16.0,'Missile Racks','Msl-Rack',0,0,4,8,1,1,'Each one destroyed also destroys one Msl-I.',15,3,0,0,10,0,1); INSERT INTO "Gear" VALUES(7,-10.0,'Anti-Personel Guns','AP',1,1,1,2,1,1,'Usable against Infantry and D0 targets only',16,3,0,0,30,0,1); INSERT INTO "Gear" VALUES(8,-1.0,'Tow Gear','TowGear',0,0,0,3,1,1,'Use per the rules in the Ogre Reinforcements Pack',15,3,0,0,1,0,1); INSERT INTO "Gear" VALUES(100,1.1,'Rocket Salvo, Internal','RktS-I',3,4,0,3,0,1,'Fired just as internal missiles - requires a Rocket Salvo Rack',10,4,0,0,40,0,1); INSERT INTO "Gear" VALUES(101,1.0,'Rocket Salvo, External','RktS-E',3,4,2,5,0,1,'Fired just as external missiles.',10,4,0,0,40,0,1); INSERT INTO "Gear" VALUES(102,1.2,'Rocket Salvo Rack','RktS-Rack',0,0,3,5,0,1,'Fires RktS-I''s, each sold separately. Each one destroyed also destroys one RktS-I.',15,3,0,0,10,0,1); INSERT INTO "Gear" VALUES(103,4.0,'Medium Howitzer','MedHWZ',6,6,5,65,0,1,'Optional Rule: move _or_ fire.',10,3,0,0,10,0,1); INSERT INTO "Gear" VALUES(104,5.0,'Howitzer','HWZ',6,8,6,100,0,1,'Optional Rule: move _or_ fire.',10,3,0,0,6,0,1); INSERT INTO "Gear" VALUES(105,6.0,'Long Tom','LTOM',4,12,6,120,0,1,'Optional Rule: move _or_ fire.',15,3,0,0,4,0,1); INSERT INTO "Gear" VALUES(106,101.0,'Cruise Missile, Internal','CMI',0,0,0,40,0,1,'Optional Rule: move _or_ fire.',15,3,0,0,10,0,1); INSERT INTO "Gear" VALUES(107,100.0,'Cruise Missile Launcher','CML',0,0,6,60,0,1,NULL,15,3,0,0,10,0,1); INSERT INTO "Gear" VALUES(109,110.0,'Engineering Arm','EA',0,0,4,5,0,1,NULL,15,3,0,0,4,0,1); INSERT INTO "Gear" VALUES(110,200.0,'Suicide Bomb','HariKari',0,0,0,60,0,1,'Cannot be attacked separately. Explodes as per chart at http://www.sjgames.com/ogre/articles/goliath.html.',15,3,0,0,10,0,1); INSERT INTO "Gear" VALUES(111,199.0,'Cargo Bay','Cargo',0,0,3,4,0,1,'Holds one armor unit or three infantry squads. Destruction destroys cargo. Use normal riding rules except that infantry cannot attack from the bay.',15,4,0,0,2,0,1); INSERT INTO "Gear" VALUES(112,198.0,'Infantry Bay','InfBay',0,0,4,3,0,1,'Holds three of any infantry, including Heavy Infantry or other large INF types. Inf destroyed if InfBay is destroyed. Use normal riding rules except that infantry cannot attack from the bay.',15,3,0,0,4,0,1); INSERT INTO "Gear" VALUES(113,-10.0,'Long-Range AP Guns','LRAP',1,2,1,3,0,1,'Usable against Infantry and D0 targets only',16,3,0,0,30,0,1); INSERT INTO "Ogre" VALUES(-1,-999.0,'New Ogre',NULL,NULL,'Default.png',7,0,0,0,NULL,0,0,0,NULL,NULL,NULL); INSERT INTO "Ogre" VALUES(1,-1.0,'Mark I','','MarkI','MarkI.png',5,3,5,5,47.45,0,1,1,'','',''); INSERT INTO "Ogre" VALUES(2,-0.99,'Mark II','','MarkII','MarkII.png',6,3,10,10,96.43,0,1,1,'','',''); INSERT INTO "Ogre" VALUES(3,-0.98,'Mark III','','MarkIII','MarkIII.png',7,3,15,16,163.77,0,1,1,'','',''); INSERT INTO "Ogre" VALUES(4,-0.97,'Fencer','','Fencer','Fencer.png',8,3,15,22,220.4,0,1,1,'','',''); INSERT INTO "Ogre" VALUES(5,-0.96,'Mark IV','','MarkIV','MarkIV.png',8,4,15,27,271.42,0,1,1,'','',''); INSERT INTO "Ogre" VALUES(6,-0.96,'Mark V','','MarkV','MarkV.png',8,3,20,27,270.91,0,1,1,'','',''); INSERT INTO "Ogre" VALUES(7,-0.95,'Mark VI','','MarkVI','MarkVI.png',9,3,25,37,367.34,0,1,1,'','',''); INSERT INTO "Ogre" VALUES(8,100.0,'Mark IIIb','','MarkIIIb','MarkIIIb.png',7,3,16,22,205.1,0,1,1,'','',''); INSERT INTO "Ogre" VALUES(100,100.0,'Flower','','Flower','Flower.png',8,4,15,21,223.21,0,0,1,'A refitted Mark IV built for quick strikes against smaller targets.','Stephan Beal','http://qub.sourceforge.net'); INSERT INTO "Ogre" VALUES(101,0.0,'Der Hammer','','DerHammer','Default.png',7,2,15,24,243.07,0,0,1,'','Stephan','http://www.wanderinghorse.net'); INSERT INTO "Ogre" VALUES(103,0.0,'Goliath','','Goliath','Default.png',7,3,10,9,91.83,0,0,1,'Explodes as per chart at http://www.sjgames.com/ogre/articles/goliath.html.','Stephan','http://www.wanderinghorse.net'); INSERT INTO "Ogre" VALUES(104,-0.79,'Doppelsoldner','','Doppelsoldner','Doppelsoldner.png',9,3,20,35,348.97,0,1,1,'','',''); INSERT INTO "Ogre" VALUES(105,-0.8,'Ninja','','Ninja','Ninja.png',7,4,10,18,183.92,0,1,1,'-1 to hit from all attacks except Infantry in an overrun.','',''); INSERT INTO "Ogre" VALUES(106,100.0,'Charlie Bravo','','CharlieBravo','Default.png',7,4,8,13,133.93,0,0,1,'This lightly armed Ogre is designed as a sentient Combat Engineering machine. It was a Combine design, but the Paneuros had a similar vehicle called the BPO. (Bekampfen Pioneer Ogre)','Jon Glenn','cybrludite@yahoo.com'); INSERT INTO "Ogre" VALUES(107,100.0,'iFencer','','iFencer','Fencer.png',8,3,16,24,238.77,0,0,1,'An improved Fencer design.','Imre A. Szabo','ias@sprintmail.com'); INSERT INTO "Ogre" VALUES(108,100.0,'Free Love','','FreeLove','FreeLove.png',8,2,25,30,294.64,0,0,1,'','Stephan','http://www.wanderinghorse.net'); INSERT INTO "Ogre" VALUES(109,0.0,'Cruiser','','Cruiser','Default.png',7,3,12,24,238.77,0,0,1,'','Stephan','http://www.wanderinghorse.net'); INSERT INTO "Ogre" VALUES(110,100.0,'Minuteman','','Minuteman','Default.png',8,4,10,14,137.5,0,0,1,'Infantry support unit, built to get men into The Thick quickly and safely.','Stephan','http://www.wanderinghorse.net'); INSERT INTO "Ogre" VALUES(111,100.0,'Model II-T','The Minivan','ModelIIT','MarkII.png',6,3,10,8,80.36,0,0,1,'','Stephan','http://www.wanderinghorse.net'); INSERT INTO "Ogre" VALUES(112,100.0,'Willie Winkie','Winkie','WillieWinkie','Doppelsoldner.png',8,4,10,51,508.92,0,0,1,'','Dilletante','hotspur@rocketmail.com'); INSERT INTO "Ogre" VALUES(113,100.0,'Marco','','Marco','Flower-nolabel.png',7,3,12,12,114.79,0,0,1,'A slightly-lighter, reworked Mark III.','Stephan','http://qub.sourceforge.net/'); INSERT INTO "Ogre" VALUES(114,100.0,'Katana','Katana','Katana','Default.png',7,4,8,15,150.89,0,0,1,'The Katanas and the slightly larger Samurai were the most common OGRE designs in Nihon''s arsenal. The Katana''s comprised the striking arm with their expendable missiles while the Samurai was designed for more staying power. Both the Katana and Samurai''s were designed to take on the Combine Mark-III, the Samurai slightly more powerful, the Katana slightly less. Both had exceptional speed which made the Nihon Empire unique in having the only high speed line units of the war.','Francisco Cestero','fjcestero@uswest.net'); INSERT INTO "Ogre" VALUES(116,100.0,'Lamer','','Lamer','MarkV-nolabel.png',8,3,18,22,221.93,0,0,1,'Close-up slammer-hammer. Got problems with infantry walls? Let Lamer spell an end to them for you.','Stephan','http://qub.sourceforge.net/'); INSERT INTO "Ogre" VALUES(117,100.0,'Mark IIIb - Cisco','','MarkIIIbCisco','MarkIIIb.png',7,3,12,19,186.73,0,0,1,'','Cisco',''); INSERT INTO "Ogre" VALUES(118,100.0,'Flower-S','','FlowerS','Flower.png',8,3,12,17,166.07,0,0,1,'A Support version of the Flower. Slowed down because the extra speed isn''t needed so much in a support role. The Flower-S accells at protecting other Ogres from close-up attacks. Used in conjunction with a missile-based Ogre, it can make quite a good defense partner.','Stephan Beal','http://www.wanderinghorse.net'); INSERT INTO "Ogre" VALUES(121,100.0,'Mark V-m','','MarkVm','MarkV-nolabel.png',8,3,20,30,303.05,0,0,1,'This is a missile rack armed Mark V.','George Leritte','gleritte@juno.com'); INSERT INTO "Ogre" VALUES(122,100.0,'Mark III-m','','MarkIIIm','MarkIII-nolabel.png',7,3,15,17,174.49,0,0,1,'This is a missile rack armed Mark III.','George Leritte','gleritte@juno.com'); INSERT INTO "Ogre" VALUES(125,100.0,'Copy of Mark V','Dire Wolf','CopyofMarkV','MarkV.png',8,3,20,32,324.48,0,0,1,'Better able to make those lone raids... and come back!','Herb Diehr','edcomp@provide.net'); INSERT INTO "Ogre" VALUES(126,100.0,'Wolf','','Wolf','Default.png',8,3,12,29,287.75,0,0,1,'','Herb Diehr','edcomp@provide.net'); INSERT INTO "Ogre" VALUES(127,100.0,'Trooper','','Trooper','MarkI-nolabel.png',5,4,5,7,73.21,0,0,1,'A slightly beefed up MK 1.','Doug Pappert','dpappert@kc.rr.com'); INSERT INTO "Ogre" VALUES(130,100.0,'Blackeye','Blackie','Blackeye','MarkII-nolabel.png',6,3,10,9,93.36,0,0,1,'A remodelled Mark II.','Stephan Beal','http://www.wanderinghorse.net'); INSERT INTO "Ogre" VALUES(131,100.0,'Blossom','Spitball','Blossom','MarkII-nolabel.png',6,3,10,9,105.61,0,0,1,'It''s to go into an area and fire a one- or two-shot volley at mid-range targets, or to snipe, if it can get away with it.','Stephan Beal','http://www.wanderinghorse.net'); INSERT INTO "Ogre" VALUES(132,100.0,'Buggy','','Buggy','MarkII-nolabel.png',6,4,8,11,112.5,0,0,1,'A faster model of the Blackeye','Stephan Beal','http://www.wanderinghorse.net'); INSERT INTO "Ogre" VALUES(133,100.0,'Buggy II','','BuggyII','MarkIV-nolabel.png',8,4,12,20,203.57,0,0,1,'','Stephan Beal','http://www.wanderinghorse.net'); INSERT INTO "Ogre" VALUES(134,100.0,'Mark VII','Behemoth','MarkVII','Default.png',9,2,40,47,474.09,0,0,1,'','Scott "Clu" Nelson','snelson_@yahoo.com'); INSERT INTO "Ogre" VALUES(136,100.0,'Bombard','Mad Bomber','Bombard','MarkIII.png',7,4,20,38,383.92,0,0,1,'A Fast Ogre that''s hard to stop. It can push into enemy territory and Nuc its target. Carries a backup missile, just in case the first one is shot down.','Scott "Clu" Nelson','snelson_@yahoo.com'); INSERT INTO "Ogre" VALUES(137,100.0,'Cyclops','Red-Eye','Cyclops','Default.png',7,4,10,41,408.92,0,0,1,'','Scott Clu Nelson','snelson_@yahoo.com'); INSERT INTO "Ogre" VALUES(138,100.0,'Mk VI Megascout','Dasher','MkVIMegascout','MarkVI-nolabel.png',9,6,10,48,482.13,0,0,1,'','Drew Dreasler','bavarian@interaccess.com'); INSERT INTO "Ogre" VALUES(139,100.0,'Mark VII jag','jaguar','MarkVIIjag','Default.png',9,4,20,63,632.13,0,0,1,'','Bill J','BillJ77@Hotmail.com'); INSERT INTO "Ogre" VALUES(140,100.0,'Mk VII WarWagon','WarOgre','MkVIIWarWagon','Default.png',7,3,25,38,378.05,0,0,1,'','Bill J','BillJ77@Hotmail.com'); INSERT INTO "Ogre" VALUES(141,100.0,'WarWagon Mk2','WW2','WarWagonMk2','Default.png',9,3,30,50,497.44,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(142,100.0,'Fence Jumper','Jumper','FenceJumper','Fencer-nolabel.png',8,6,5,42,423.2,0,0,1,'This unit is used primarily as a support unit to other ogres. Especially usefuk in urban settings.','Ross Winn','ross_winn@hotmail.com'); INSERT INTO "Ogre" VALUES(144,100.0,'Mark1r/Vandal','Slasher','Mark1rVandal','Default.png',5,4,4,7,66.07,0,0,1,'A modified mark 1 intended for raiding behind enemy lines. Chewing up supply and repair units in hit and run raids.','Christian Okane','COKane8116@aol.com'); INSERT INTO "Ogre" VALUES(145,100.0,'Mark Ib','','MarkIb','MarkI.png',5,3,5,6,55.87,0,0,1,'An attempt at up-gunning the Mark One; added a smaller turret with a secondary-class weapon. This version still proved too fragile for the cost, though the additional weapon proved useful enough to warrant the multi-gun design used in later Ogres.','Michael Powers','mpowers@mad.scientist.com'); INSERT INTO "Ogre" VALUES(147,100.0,'Mark If','','MarkIf','MarkI.png',5,3,5,5,46.68,0,0,1,'An anti-personnel variant of the Mark One, used mostly by Internal Security for riot-control work. These Ogres were withdrawn from duty after several units became confused and began identifying _all_ humans as potential targets.','Michael Powers','mpowers@mad.scientist.com'); INSERT INTO "Ogre" VALUES(148,100.0,'Mark Ic','','MarkIc','MarkI.png',5,3,5,5,53.57,0,0,1,'Another attempt at creating a Mark One that was a significant force on its own, this version replaced the main cannon with several launchers for tactical missiles. While this gave it more versatility and greater range, it was still not durable enough to complete a mission without support.','Michael Powers','mpowers@mad.scientist.com'); INSERT INTO "Ogre" VALUES(149,100.0,'Mark IIc','','MarkIIc','MarkII.png',6,3,10,9,91.83,0,0,1,'This version replaced the secondary cannon with a pair of external missiles as a feasibility study. It proved effective, and the missiles were included in the next generation of Ogres.','Michael Powers','mpowers@mad.scientist.com'); INSERT INTO "Ogre" VALUES(150,100.0,'Mark V-IYF','Inyoface','MarkVIYF','MarkV-nolabel.png',8,3,20,22,217.34,0,0,1,'This Mark V variant is intentded to be covered by longer-ranged units, or to provide cover for them.','Stephan Beal','http://www.wanderinghorse.net'); INSERT INTO "Ogre" VALUES(151,100.0,'Oni Mk. II','Long Tom','OniMkII','Spartan-nolabel.png',6,6,6,23,241.07,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(152,100.0,'Fiver','','Fiver','MarkV-nolabel.png',8,3,20,22,238.77,0,0,1,'Refitted Mark V, with more blasting power, and fewer guns.','Stephan Beal','http://byoo.rootonfire.org'); INSERT INTO "Ogre" VALUES(153,100.0,'Journeyman PC','Jammy','JourneymanPC','MarkIV-nolabel.png',8,4,10,12,122.32,0,0,1,'The Journeyman is a cargo unit made to get Infantry where they are needed, and quickly. It will not stand up long to combat, but can defend itself for a few minutes with it''s small array of rockets and tertiary cannon. In addition to it''s infantry bays, it may carry 3 infantry on it''s hull, per the standard GEV rules for carrying infantry.','Stephan Beal','http://byoo.rootonfire.org'); INSERT INTO "Ogre" VALUES(154,100.0,'Ninja/Vulcan','','NinjaVulcan','Ninja.png',7,4,11,18,188.39,0,0,1,'-1 to hit from all attacks except Infantry in an overrun. I''m currently working on a GURPS Ogre version of this, which is even more of a cross between a Vulcan and a Ninja.','Allen Smith','easmith@beatrice.rutgers.edu'); INSERT INTO "Ogre" VALUES(155,100.0,'Fast Assult Mk III','Dragster','FastAssultMkIII','Default.png',7,6,5,19,206.24,0,0,1,'','Daniel Gallant','adgallant@sympatico.ca'); INSERT INTO "Ogre" VALUES(156,100.0,'Merkava III-B','','MerkavaIIIB','MarkIIIb-nolabel.png',7,3,15,17,182.14,0,0,1,'Functionally identical to the Mark III-B, but built by the Israelis under license. The Merkava does, however, look somewhat different, with a lower, wider chassis more suitable to desert warfare','Sean Bayan Schoonmaker','s_schoon@pacbell.net'); INSERT INTO "Ogre" VALUES(157,100.0,'Mk III Zunder','The Zunder','MkIIIZunder','MarkIII-nolabel.png',7,4,10,35,373.2,0,0,1,'','Tom Zunder','tomz@writeme.com'); INSERT INTO "Ogre" VALUES(158,100.0,'Mk V - ATDR "Piercer"','Piercer','MkVATDRPiercer','Default.png',8,3,20,20,215.05,0,0,1,'Designed by the NA Combine, the Ogre Mk V ATDR (Advance Troop Deployment & Recovery) was an uncharacteristically defensive development of Ogre combat philosophy. The ATDR model was intended to serve as a frontline breeching vehicle and mobile emplacement. Its primary purpose was to work in concert with other ATDR units, establish a safe deployment zone for conventional troops and conduct repairs on damaged frontline armor units while defending the established deployment zone. Twenty ATDR units were produced for use during the short-lived ''St. Petersburg Offensive''. However, the adjusted behavioral programming used to recondition standard Mk V Combat Control Centers proved itself to be far too aggressive for the intended battlefield application of the ATDR. Ultimately, the ATDR program was scrapped and the existing Mk V ATDR units were reassigned to the South American & Antarctic Theatres.','Scott Weber','ocr-geist@home.com'); INSERT INTO "Ogre" VALUES(159,100.0,'Hunter-Killer','''Mike''','HunterKiller','Default.png',8,3,10,20,211.98,0,0,1,'This model is designed specifically to seek out and destroy heavy targets.','S. Ventura','unknownguardsman@excite.com'); INSERT INTO "Ogre" VALUES(160,100.0,'Mark III r','','MarkIIIr','Default.png',7,3,15,14,149.23,0,0,1,'Experimental APC variant. For deep penetration of special forces.','fizz','fizzmouse@yahoo.ca'); INSERT INTO "Ogre" VALUES(161,100.0,'E-1','Thors Hammer','E1','MarkVI-nolabel.png',9,4,30,69,692.84,0,0,1,'Experimental PanEuropean Ogre from the research facility in Stockholm.','Mattias Olofsson','mattias@lysator.liu.se'); INSERT INTO "Ogre" VALUES(162,100.0,'Steel Oni','','SteelOni','Default.png',7,3,15,19,194.38,0,0,1,'This was the smaller of Japan''s two OGRE designs. First saw action in 2074 during the Battle of Hong Kong. This unit is based on the American Mark III-B.','Andrew Gelbman','wizard@internetwizards.com'); INSERT INTO "Ogre" VALUES(163,100.0,'Golem','','Golem','Default.png',7,3,15,20,196.68,0,0,1,'The Golem was Israel''s OGRE design, more than a match for most Mark III designs, the IDF deployed these in 2073 though they remained secret until 2075 when an Iraqi/PanEuropean force violated Israel''s self-declared "security zone" in eastern Jordan. The Golem is a solid design, though very few became self-aware and none went rogue.','Andrew Gelbman','wizard@internetwizards.com'); INSERT INTO "Ogre" VALUES(164,100.0,'Fencer (Cannonical)','','FencerCannonical','Default.png',7,3,15,22,220.4,0,0,1,'The Fencer was PanEurope''s first indigenous OGRE design. Introduced in 2084, it was a compromise between stolen Anglo-American technology received after the Fall of Britain and research done in Germany to copy Combine Cybertanks.','Andrew Gelbman','wizard@internetwizards.com'); INSERT INTO "Ogre" VALUES(165,100.0,'Steel Samurai','','SteelSamurai','Default.png',8,4,15,30,301.78,0,0,1,'The Steel Samurai was the larger of Japan''s two OGRE designs, introduced in 2084 it was very successful against both Chinese "Dragon" super tanks and American Mk IV/V OGREs','Andrew Gelbman','wizard@internetwizards.com'); INSERT INTO "Ogre" VALUES(166,100.0,'gfhj','xgdxcf','gfhj','Doppelsoldner-nolabel.png',8,3,50,115,1154.05,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(167,100.0,'scroflagon','','scroflagon','Fencer.png',8,4,15,25,249.99,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(168,100.0,'scroflago','','scroflago','MarkVI.png',9,3,20,36,361.21,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(169,100.0,'Longarm','','Longarm','MarkIII.png',7,3,14,18,182.14,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(170,100.0,'MK III-H','','MKIIIH','MarkIII.png',7,3,14,19,186.73,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(171,100.0,'Wolfen','Grinder','Wolfen','Doppelsoldner.png',9,4,20,110,1096.4,0,0,1,'Designed as an offshoot of the MK VI to make a largely long range support weapon platform.','Ronald Matthews','ronel.matt@thegrid.net'); INSERT INTO "Ogre" VALUES(172,100.0,'Mark I-LR','Sitting Bull','MarkILR','MarkI.png',5,3,6,5,52.04,0,0,1,'Late in the Last War, one city state was able to improve a "found OGRE" to this configuration.','Kirk Hunt','kirkhunt@theriver.com'); INSERT INTO "Ogre" VALUES(173,100.0,'Mark I-at','Cochise','MarkIat','MarkI.png',5,3,6,6,61.22,0,0,1,'A brother to the Sitting Bull this improved configuration made for a potent combatant.','Kirk Hunt','kirkhunt@theriver.com'); INSERT INTO "Ogre" VALUES(174,100.0,'Mark I-as','Geronimo','MarkIas','MarkI.png',5,3,6,6,61.22,0,0,1,'Like "Sitting Bull" and "Cochise" the upgrades to this "found" OGRE were one of a kind. Includes the "Stealth Module" (-1 to hit from all attacks except Infantry in an overrun) for improved battlefield survivability rather than raids.','Kirk Hunt','kirkhunt@theriver.com'); INSERT INTO "Ogre" VALUES(175,100.0,'PHALANX','stubby','PHALANX','Default.png',7,3,4,14,135.46,0,0,1,'','erick','siniypiva@hotmail.com'); INSERT INTO "Ogre" VALUES(176,100.0,'MARK IBGF','BIGFOOT','MARKIBGF','Default.png',5,4,25,23,232.14,0,0,1,'','MARTIN EVANS','OGRE1994@WEBTV.COM'); INSERT INTO "Ogre" VALUES(177,100.0,'Wolfen-b','Grinder','Wolfenb','Doppelsoldner.png',9,4,30,131,1308.89,0,0,1,'Designed as an offshoot of the MK VI to make a largely long range support weapon platform. Weapons mix modified from Wolfen to provide better support fire at medium range.','Ronald Matthews','ronel.matt@thegrid.net'); INSERT INTO "Ogre" VALUES(178,100.0,'Terrorizer','Terry','Terrorizer','Doppelsoldner-nolabel.png',9,4,10,80,794.62,0,0,1,'I always wanted to design an Ogre ever since I first ran into this game almost twenty-five years ago. Now I can say that I did it. :)','T. K. Bertram','tkbertram@hotmail.com'); INSERT INTO "Ogre" VALUES(179,100.0,'Combat Engineer Vehicle','Kevin','CombatEngineerVehicle','Fencer-nolabel.png',8,4,15,162,1623.17,0,0,1,'Even in far future combat, there are still going to be times when you need an engineer platoon and its associated gear to clear obstacles, et.al. Which is where this comes in. If there were a way to do it, I''d add a dozer blade to the front for good measure. (Can you imagine being an infantry squad with a blade the size of a small house ripping up your positions?)','T. K. Bertram','tkbertram@hotmail.com'); INSERT INTO "Ogre" VALUES(180,100.0,'Steel Demon (ONI)','ONI','SteelDemonONI','MarkIIIb-nolabel.png',7,3,15,19,194.38,0,0,1,'The smaller of the Nihon Empire''s Ogre designs. This comes from GURPS Ogre (from SJ Games). Note that the secondary batteries have the same range as the main batteries.','George Leritte','gleritte@juno.com'); INSERT INTO "Ogre" VALUES(181,100.0,'Steel Warrior (SAMURAI)','SAMURAI','SteelWarriorSAMURAI','MarkV-nolabel.png',8,3,20,27,270.91,0,0,1,'The larger of the Nihon Empire''s Ogre designs. This comes from GURPS Ogre (from SJ Games). Note that the secondary batteries have the same range as the main batteries.','George Leritte','gleritte@juno.com'); INSERT INTO "Ogre" VALUES(182,100.0,'x1-pacific siege unit','DAUNTLESS','x1pacificsiegeunit','MarkVI.png',9,4,50,125,1246.4,0,0,1,'I MADE THIS UNIT AS A COUNTRY SIEGE UNIT','JOE FLYNN','RAVENSTONEGAMES.COM'); INSERT INTO "Ogre" VALUES(184,100.0,'COMBINE U-21','DESTROYER','COMBINEU21','MarkIII.png',7,4,15,41,412.49,0,0,1,'COMBINE''S TAKE ON THE GOLIATH. WITH ADDED PUNCH','JOE FLYNN','RAVENSTONEGAMES.COM'); INSERT INTO "Ogre" VALUES(185,100.0,'COMBINE U-70','KINGMAKER','COMBINEU70','MarkIII.png',8,3,25,76,757.63,0,0,1,'COMBINE''S PERSUADER .','JOE FLYNN','RAVENSTONEGAMES.COM'); INSERT INTO "Ogre" VALUES(186,100.0,'001','GOLDBERG','001','MarkVI.png',9,4,50,375,3754.36,0,0,1,'LIKE LIMPBIZKIT SAYS " KEEP ROLLING,ROLLING,ROLLING..."','ROB YANTES','RAVENSTONEGAMES.COM'); INSERT INTO "Ogre" VALUES(188,100.0,'MARK II-D','DEMOLISHER','MARKIID','MarkII.png',7,3,15,26,260.96,0,0,1,'','MARTIN EVANS','OGRE1994@WEBTV.COM'); INSERT INTO "Ogre" VALUES(189,100.0,'MARK I-B','BEHEMOTH','MARKIB','MarkI.png',5,4,5,23,231.24,0,0,1,'','MARTIN EVANS','OGRE1994@WEBTV.COM'); INSERT INTO "Ogre" VALUES(190,100.0,'INVINCIBLE','','INVINCIBLE','MarkVI-nolabel.png',9,4,50,492,4922.19,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(191,100.0,'s',NULL,NULL,'Default.png',7,0,0,0,NULL,0,0,1,NULL,NULL,NULL); INSERT INTO "Ogre" VALUES(192,100.0,'tesst','','tesst','Default.png',7,4,23,78,779.44,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(193,100.0,'Grunt','','Grunt','MarkI.png',5,3,10,9,86.48,0,0,1,'','Doug Pappert','dpappert@kc.rr.com'); INSERT INTO "Ogre" VALUES(194,100.0,'Dagger','','Dagger','MarkII-nolabel.png',6,3,8,8,81.89,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(195,100.0,'Dagger/b','','Daggerb','MarkII-nolabel.png',6,3,8,7,74.23,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(196,100.0,'Warhammer','','Warhammer','MarkIII-nolabel.png',7,3,12,14,142.34,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(197,100.0,'MARK-VIII','BOLO','MARKVIII','MarkVI.png',7,4,20,48,479.45,0,0,1,'BOLO DARE I SAY MORE!','FLYNN','RAVENSTONEGAMES'); INSERT INTO "Ogre" VALUES(198,100.0,'MARK-VIV','BOLO','MARKVIV','MarkVI.png',9,4,35,62,619.63,0,0,1,'A BIGGER BOLO!','FLYNN','RAVENSTONEGAMES'); INSERT INTO "Ogre" VALUES(199,100.0,'MARK-X','BOLO','MARKX','MarkVI.png',9,4,40,72,720.52,0,0,1,'YET A BIGGER BOLO!','FLYNN','RAVENSTONEGAMES'); INSERT INTO "Ogre" VALUES(200,100.0,'MARK-XX','ROGUE BOLO','MARKXX','MarkVI.png',9,4,50,94,938.37,0,0,1,'JUST READ THE BOOK!','FLYNN','RAVENSTONEGAMES'); INSERT INTO "Ogre" VALUES(201,100.0,'Dragon','False Ogre','Dragon','MarkIII.png',7,3,15,15,144.64,0,0,1,'Based off of the false Cybertank in GURPS Ogre, pg. 16','Keith Johnson','keith@sjgames.com'); INSERT INTO "Ogre" VALUES(203,100.0,'OM-Fencer','','OMFencer','Fencer.png',8,3,16,23,224.99,0,0,1,'The Ogre Minitures Fencer with 48 treads...','Imre A. Szabo','ias@sprintmail.com'); INSERT INTO "Ogre" VALUES(204,100.0,'Mark VIa','','MarkVIa','MarkVI.png',9,3,24,42,417.85,0,0,1,'Assault version of the Mark VI','Imre A. Szabo','ias@sprintmail.com'); INSERT INTO "Ogre" VALUES(205,100.0,'ARMAGEDDON','munchkin','ARMAGEDDON','MarkVI.png',9,4,50,492,4922.19,0,0,1,'','rogue765','rogue765@webtv.net'); INSERT INTO "Ogre" VALUES(206,100.0,'mark IV B','','markIVB','MarkIV-nolabel.png',8,4,5,20,199.99,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(208,100.0,'Mark IV A','','MarkIVA','MarkIV.png',8,4,15,27,271.42,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(209,100.0,'Mark III A','','MarkIIIA','MarkIII.png',7,3,15,16,163.77,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(210,100.0,'Copy of Mark II','','CopyofMarkII','MarkII.png',6,3,10,10,95.66,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(211,100.0,'Mark II A','','MarkIIA','MarkII.png',6,3,10,10,95.66,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(212,100.0,'Mark V A','','MarkVA','MarkV.png',8,3,20,27,270.91,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(213,100.0,'Havok','Havok','Havok','Default.png',9,4,20,42,423.2,0,0,1,'There were only four of these ogres produced, all by the Combine. They are very tough and optimized for striking at long range.','Nomad',''); INSERT INTO "Ogre" VALUES(214,100.0,'Harbinger','Harbinger','Harbinger','MarkIV-nolabel.png',7,4,12,24,241.07,0,0,1,'Speed 4, 2 main batteries, and 2 missile racks make this a tough opponent. It''s only weakness is a relatively few 48 tread units. It''s between a mark III and mark IV in size and programmed for cunning and hit and run tactics.','Nomad',''); INSERT INTO "Ogre" VALUES(215,100.0,'Mark IV-iiia Transport','Connestoga','MarkIViiiaTransport','Default.png',8,4,15,20,204.46,0,0,1,'This variant was created to facilitate delivering engineering and specialized assault infantry elements to combat zones. It has 3 infantry bays and a cargo bay capable of holding 1 armor unit or 3 squads of infantry.','Adam C. Lipscomb','ACLipscomb@fc.net'); INSERT INTO "Ogre" VALUES(216,100.0,'MK 2x1a','Pounder','MK2x1a','Spartan.png',6,2,10,8,77.01,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(217,100.0,'Vagabond Class','the Poet','VagabondClass','Default.png',8,4,12,27,267.85,0,0,1,'','george ibarra','nameless_vagabond@yahoo.com'); INSERT INTO "Ogre" VALUES(218,100.0,'Copy of Mark III','','CopyofMarkIII','MarkIII.png',7,3,15,16,163.77,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(219,100.0,'Mark IV C','','MarkIVC','MarkIV.png',8,4,15,27,270.53,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(220,100.0,'Mark V C','','MarkVC','MarkV.png',8,3,20,27,270.91,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(221,100.0,'Fencer A','','FencerA','Fencer.png',8,3,15,21,207.39,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(222,100.0,'Mk A1E3','the Gator','MkA1E3','Default.png',9,4,25,50,496.42,0,0,1,'','will W.',''); INSERT INTO "Ogre" VALUES(223,100.0,'Harbinger-Melee','Harbie','HarbingerMelee','Default.png',9,4,12,64,641.95,0,0,1,'','Mike',''); INSERT INTO "Ogre" VALUES(224,100.0,'Hydra','','Hydra','Default.png',9,4,12,92,917.83,0,0,1,'','Mike',''); INSERT INTO "Ogre" VALUES(225,100.0,'Mark IV-R','Ravager','MarkIVR','Lancer-nolabel.png',8,4,15,25,254.46,0,0,1,'','R.A.Gordon','None'); INSERT INTO "Ogre" VALUES(226,100.0,'Guardian','','Guardian','MarkIII-nolabel.png',6,3,10,20,195.91,0,0,1,'','R.A.Gordon','None'); INSERT INTO "Ogre" VALUES(227,100.0,'Mk3-Hydra','','Mk3Hydra','Default.png',7,4,12,67,674.09,0,0,1,'','Mike',''); INSERT INTO "Ogre" VALUES(228,100.0,'Mk VIII mod a1','Longbow','MkVIIImoda1','MarkV-nolabel.png',8,4,15,43,426.77,0,0,1,'A long range missile tosser. You can have my nukes when you pry them from my cold dead chassis!','Jim C','travmind@hotmail.com'); INSERT INTO "Ogre" VALUES(229,100.0,'Mk VII Mod a1','Quiver','MkVIIModa1','MarkIII-nolabel.png',6,4,10,30,296.42,0,0,1,'A fast supply variant for the Mk VIII a1 Longbow. If the Mk VII a1 and a Mk VIII a1 sit in a hex together for one turn, the Quiver can reload 20 missiles. Two turns for a full reload. To help keep the offensive rolling. The Quiver then returns for more reloads.','Jim C','travmind@hotmail.com'); INSERT INTO "Ogre" VALUES(230,100.0,'Mk1-turtle','','Mk1turtle','Default.png',5,4,20,23,233.03,0,0,1,'','Mike',''); INSERT INTO "Ogre" VALUES(231,100.0,'Reaper','','Reaper','Fencer-nolabel.png',9,2,20,19,190.17,0,0,1,'','R.A.Gordon','None'); INSERT INTO "Ogre" VALUES(232,100.0,'Vulcan Mk. I','Victors','VulcanMkI','Default-nolabel.png',7,3,15,11,104.84,0,0,1,'Because, incredibly, there wasn''t one up already. There should probably be two engineering arms, plus a "drone bay" much like an infantry bay. Submitted by Stephen Blount','',''); INSERT INTO "Ogre" VALUES(234,100.0,'Light Horse','','LightHorse','Default.png',7,4,10,13,128.57,0,0,1,'','Scott Nelson','snelson_@yahoo.com'); INSERT INTO "Ogre" VALUES(235,100.0,'Behemoth','','Behemoth','MarkVI.png',9,2,15,34,338.16,0,0,1,'I wrote a story around this monster.','Scott Nelson','snelson_@yahoo.com'); INSERT INTO "Ogre" VALUES(236,100.0,'Scorpion','','Scorpion','Default.png',8,4,15,41,414.27,0,0,1,'','Mike',''); INSERT INTO "Ogre" VALUES(237,100.0,'Hunter-MkI','Hunter','HunterMkI','Doppelsoldner.png',8,3,10,17,165.3,0,0,1,'Just want a record sheet O can test the concept of an Ogre-Hunter on','Vernon Burt','packrat@iol25.com'); INSERT INTO "Ogre" VALUES(238,100.0,'Copy of Hunter-MkI','Hunter','CopyofHunterMkI','Doppelsoldner.png',8,3,20,28,275.5,0,0,1,'Just want a record sheet I can test the concept of an Ogre-Hunter on','Vernon Burt','packrat@iol25.com'); INSERT INTO "Ogre" VALUES(239,100.0,'Mk-4-FS-a','','Mk4FSa','Default.png',8,4,12,53,533.02,0,0,1,'Fire Support Ogre, ver 1','Mike',''); INSERT INTO "Ogre" VALUES(240,100.0,'Mk-4-FS-b','','Mk4FSb','Default.png',8,4,12,64,640.16,0,0,1,'Fire Support Ogre, ver 2','Mike',''); INSERT INTO "Ogre" VALUES(241,100.0,'Mk-4-FS-b-4','','Mk4FSb4','Default.png',8,4,12,46,461.59,0,0,1,'Fire Support Ogre, ver 2a','Mike',''); INSERT INTO "Ogre" VALUES(242,100.0,'Mk-4-FS-C','','Mk4FSC','Default.png',8,4,12,69,684.8,0,0,1,'Fire Support Ogre, ver 3','Mike',''); INSERT INTO "Ogre" VALUES(243,100.0,'Mk-4-FS-C-5','','Mk4FSC5','Default.png',8,4,12,40,394.63,0,0,1,'Fire Support Ogre, ver 3a','Mike',''); INSERT INTO "Ogre" VALUES(244,100.0,'Mk-4-FS-MX','','Mk4FSMX','Default.png',8,4,12,76,760.69,0,0,1,'Fire Support Ogre, ver 4','Mike',''); INSERT INTO "Ogre" VALUES(245,100.0,'Mk-4-MS-a','','Mk4MSa','Default.png',8,4,12,39,390.17,0,0,1,'Missile Support Ogre, ver 1','Mike',''); INSERT INTO "Ogre" VALUES(246,100.0,'Mk-4-CA','','Mk4CA','Default.png',8,4,15,45,450.88,0,0,1,'City Assault Ogre, the Ogre smashes its way in and drops the infantry (''Dx3'') to hold the town until reinforcements can arrive - hopefully.','Mike',''); INSERT INTO "Ogre" VALUES(247,100.0,'Grunt2','TG','Grunt2','Default.png',7,4,2,3,33.03,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(248,100.0,'Mk VI (IP)','Devastator','MkVIIP','MarkVI-nolabel.png',9,3,30,53,532.64,0,0,1,'Built by the Combine after the appearance of the Dopplesoldner on the field in Paneurope. Exessive expense and difficulty in production lead to only building two of these machines, who named themselves Donner and Blitzen, much to the chagrin of the upper echelon Combine military command.','Mike Raper','mraper@triad.rr.com'); INSERT INTO "Ogre" VALUES(249,100.0,'M-2','Bradley','M2','MarkI-nolabel.png',6,4,10,13,127.68,0,0,1,'Designed as a heavy troop transport and scout vehicle. The M2 has two infantry bays, plus decent anti-infantry weapons. Its speed is it''s main strength...it is not designed for combat with heavy armor units, but to deliver armored infantry into hostile fire zones they may otherwise be unable to reach.','Mike Raper','mraper@triad.rr.com'); INSERT INTO "Ogre" VALUES(250,100.0,'Stock','','Stock','Default.png',7,3,15,16,163.77,0,0,1,'','Chris Tate','agentbz@hotmail.com'); INSERT INTO "Ogre" VALUES(251,100.0,'Lancer','','Lancer','Doppelsoldner.png',9,3,22,31,310.71,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(252,100.0,'I (au)','Red-Back','Iau','Default.png',5,4,5,9,92.85,0,0,1,'Packed to the gills, this Ogre was quite a supprise.','Brian',''); INSERT INTO "Ogre" VALUES(253,100.0,'Copy of I (au)','Red-Back','CopyofIau','MarkI.png',5,4,5,9,92.85,0,0,1,'Packed to the gills, this Ogre was quite a supprise. I don''t think that this will fit in a Mk 1 hull. Is there no checking?','Brian',''); INSERT INTO "Ogre" VALUES(254,100.0,'Mk I (au)','Red-Back','MkIau','Default.png',5,4,5,9,92.85,0,0,1,'Packed to the gills, this Ogre was quite a supprise.','Brian',''); INSERT INTO "Ogre" VALUES(255,100.0,'MK3','Pitcher','MK3','Default.png',7,4,12,27,267.85,0,0,1,'The Pitcher was intended as a cheaper version of the fencer using rocket salvos instead of missles. While the external missles helped, the effectiveness was questionable and only a few of these units were produced. One sucess came from an engagement with a swarm of LGEV''s where the high speed, multiple attacks and long range were quite effective','Avaheil D''otter','avaheildotter@aol.com'); INSERT INTO "Ogre" VALUES(256,100.0,'Copy of Mark I','','CopyofMarkI','MarkI.png',5,3,5,4,43.62,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(257,100.0,'Titan 6','','Titan6','MarkVI.png',9,3,25,36,362.75,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(258,100.0,'Apocolypse','Armageddon','Apocolypse','MarkVI-nolabel.png',9,4,50,439,4386.49,0,0,1,'KABOOM!','mg',''); INSERT INTO "Ogre" VALUES(259,100.0,'MkX','HyperOgre','MkX','Default-nolabel.png',9,0,50,245,2446.54,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(260,100.0,'Chaos Ogre Mark I','Chaos Ogre','ChaosOgreMarkI','MarkIV-nolabel.png',8,4,15,28,282.14,0,0,1,'','Nick Kiest','SimnicK@aol.com'); INSERT INTO "Ogre" VALUES(261,100.0,'God','','God','MarkIV-nolabel.png',9,4,50,196,1955.31,0,0,1,'','Nick Kiest','SimnicK@aol.com'); INSERT INTO "Ogre" VALUES(262,100.0,'Mk-1','Purple rain','Mk1','MarkII.png',6,2,20,14,141.96,0,0,1,'This model wasnt designed as a penetrator, he doesnt work alone. His existance was made to create a mobile artillery support to any attacking force, withouth costing too much to build','Krakatoa','finwe@zaz.com.br'); INSERT INTO "Ogre" VALUES(263,100.0,'anti-tank','','antitank','MarkII.png',6,3,10,12,123.21,0,0,1,'','Krakatoa','finwe@zaz.com.br'); INSERT INTO "Ogre" VALUES(264,100.0,'Mark III Miniatures','','MarkIIIMiniatures','MarkIII.png',7,3,16,17,168.36,0,0,1,'','',''); INSERT INTO "Ogre" VALUES(265,100.0,'Vulcan Mk. II','Super Vulcan or','VulcanMkII','MarkIII.png',7,3,15,12,116.32,0,0,1,'62 (+ 4 for an arm I couldn''t add = 66) Ciscos unit. The Vulcan Mk. II (The program doesn''t allow for two engineering arms) was the air transportable version of the Vulcan based of an two segmented early prototype version of what became the MK. III OGRE. Its'' light armament is only meant to discourage scouting infantry or GEV skirmishers. Two engineering arms allow the ogre to quickly assemble air-dropped OGREs along with its'' small army of worker drones that stow in the cargo bays. The exact quantity of drones was never officially established and often depended on availibility of manufacture. At least two units (multiple android drones) were required for standard operation with more adding to the speed of OGRE manufacture. The two secondary batteries are emplaced in turrets with retractible cherry picker arms that double as laser welders under low power due to an ingenious combi-design. Like the Mk. III OGRE, the Super Vulcan Mk. II is fit into two sections with the front mounting the enginerring arms, secondary batteries, the AI, and 5 of the AP units while the rear section held cargo units for spare parts, the drone complement, a small back-up AI computer with limited intelligence, a tow hook, and 3 AP batteries. The front section did retain the characteristic OGRE conning tower/sensor suite, which with any luck would inform the Mk.II Super Vulcan of enemy forces with enough time to evade the marauders. An interesting feature of the unit is that the front and rear segments could be detached although inly the front segment has true AI capability. The rear segment could operate under a human operator''s guidance or under its'' own limited secondary AI brain. The best part about the segmentation feature of the two modules was that this feature made the Mk. II Super Vulcan easily air-portable by larger transport assets such as the C-5 Galaxy''s successor, the C-25 Howard Hughes or "Howie" as it was known to the troops. A few "Howies" could move a Mk.II Super Vulcan and 3 MK. III OGRE "raiding package" package deep into enemy territory assuming hostile interceptors couldn''t find them. The "Howie''s" low observability technology and all weather terrain follwing sensor suite made the Mk. II Super Vulcan/C-25 "Howie" a valuable asset for the North American Combine. Mk. II Super Vulcans were originally created by the Israellis who built the Mk. II as a field mobile repair shop for its'' self-contained tank battallions, which kept many marauders away because Israel could quickly power project large armies with or without OGRE support over long diatances into the heart of Arabia if need be for retaliation. Mk. IIs have operated in many missions included field assembly of OGREs, field repair, and as combat engineers among their other missions. Paneuropean Russian/Soviet units were very fond of their copied Mk. II Super Vulcans and frequently deployed them into large regimental level OGRE raiding groups suppoerted by armor battallions. These same Russian units drove the NAC invaders off of the "Continent" before the end of the war.','Maksim-Smelchak','Max200@Lanset.com'); INSERT INTO "Ogre" VALUES(266,100.0,'Tremendous','Atomic Horor','Tremendous','MarkVI-nolabel.png',9,4,20,55,552.66,0,0,1,'','Blade',''); INSERT INTO "Ogre" VALUES(267,100.0,'Bolo Mk X','Thunderous','BoloMkX','MarkVI-nolabel.png',9,4,20,109,1085.69,0,0,1,'Based on the Bolo Books this is a Continental seige unit (all other units are advised to withdraw)','Blade',''); INSERT INTO "Ogre" VALUES(268,100.0,'Copy of Vulcan Mk. II','Super Vulcan or','CopyofVulcanMkII','MarkIII.png',7,3,15,12,116.32,0,0,1,'62 (+ 4 for an arm I couldn''t add = 66) Ciscos unit. The Vulcan Mk. II (The program doesn''t allow for two engineering arms) was the air transportable version of the Vulcan based of an two segmented early prototype version of what became the MK. III OGRE. Its'' light armament is only meant to discourage scouting infantry or GEV skirmishers. Two engineering arms allow the ogre to quickly assemble air-dropped OGREs along with its'' small army of worker drones that stow in the cargo bays. The exact quantity of drones was never officially established and often depended on availibility of manufacture. At least two android units (multiple android drones) were required for standard operation with more adding to the speed of OGRE manufacture. Drone engineering tanks cpould also be carried in the Super Vulcan''s rear module cargo bays. The two secondary batteries are emplaced in turrets with retractible cherry picker arms that double as laser welders under low power due to an ingenious combi-design. Like the Mk. III OGRE, the Super Vulcan Mk. II is fit into two sections with the front mounting the enginerring arms, secondary batteries, the AI, and 5 of the AP units while the rear section held cargo units for spare parts, the drone complement, a small back-up AI computer with limited intelligence, a tow hook, and 3 AP batteries. The front section did retain the characteristic OGRE conning tower/sensor suite, which with any luck would inform the Mk.II Super Vulcan of enemy forces with enough time to evade the marauders. An interesting feature of the unit is that the front and rear segments could be detached although only the front segment has true AI capability. The rear segment could operate under a human operator''s guidance or under its'' own limited secondary AI brain. The best part about the segmentation feature of the two modules was that this feature made the Mk. II Super Vulcan easily air-portable by larger transport assets such as the C-5 Galaxy''s successor, the C-25 Howard Hughes or "Howie" as it was known to the troops. A few "Howies" could move a Mk.II Super Vulcan and 3 MK. III OGRE "raiding package" package deep into enemy territory assuming hostile interceptors couldn''t find them. The "Howie''s" large bays allowed the gargantuan aircraft to drop the Super Vulcan and Mk. IIIs in only 2 packages a piece. For the Super Vulcan whose two segments could function independently, this meant that the Super Vulcan was cobat-ready the moment it left its'' drop harness. Under regular drop conditions, the Super Vulcan could assemble the 3 Mk. IIIs in under 4 minutes a piece! The "Howie''s" low observability technology, powerful Jamming "spoof" pods, and all weather terrain follwing sensor suite made the Mk. II Super Vulcan/C-25 "Howie" a valuable asset for the North American Combine. Mk. II Super Vulcans were originally created by the Israelis who built the Mk. II as a field mobile repair shop for its'' self-contained tank battallions, which kept many marauders away because Israel could quickly power project large armies with or without OGRE support over long distances into the heart of Arabia if need be for retaliation. Mk. IIs have operated in many missions included field assembly of OGREs, field repair, bridging, hasty field fortification, and as combat engineers among their other missions. Paneuropean Russian/Soviet units were very fond of their copied Mk. II Super Vulcans and frequently deployed them into large regimental level OGRE raiding groups supported by armor battallions. These same Russian units drove the NAC invaders off of the "Continent" before the end of the war.','Maksim-Smelchak','Max200@Lanset.com'); INSERT INTO "GearToOgre" VALUES(100,102,4); INSERT INTO "GearToOgre" VALUES(100,100,24); INSERT INTO "GearToOgre" VALUES(100,7,6); INSERT INTO "GearToOgre" VALUES(5,7,8); INSERT INTO "GearToOgre" VALUES(1,7,4); INSERT INTO "GearToOgre" VALUES(101,104,2); INSERT INTO "GearToOgre" VALUES(101,103,1); INSERT INTO "GearToOgre" VALUES(101,7,4); INSERT INTO "GearToOgre" VALUES(101,2,2); INSERT INTO "GearToOgre" VALUES(3,7,8); INSERT INTO "GearToOgre" VALUES(3,5,2); INSERT INTO "GearToOgre" VALUES(3,2,4); INSERT INTO "GearToOgre" VALUES(2,7,6); INSERT INTO "GearToOgre" VALUES(2,2,2); INSERT INTO "GearToOgre" VALUES(5,6,3); INSERT INTO "GearToOgre" VALUES(5,4,15); INSERT INTO "GearToOgre" VALUES(5,2,2); INSERT INTO "GearToOgre" VALUES(4,7,8); INSERT INTO "GearToOgre" VALUES(4,6,4); INSERT INTO "GearToOgre" VALUES(4,4,20); INSERT INTO "GearToOgre" VALUES(4,2,2); INSERT INTO "GearToOgre" VALUES(6,7,12); INSERT INTO "GearToOgre" VALUES(6,5,6); INSERT INTO "GearToOgre" VALUES(6,2,6); INSERT INTO "GearToOgre" VALUES(7,7,16); INSERT INTO "GearToOgre" VALUES(7,6,2); INSERT INTO "GearToOgre" VALUES(7,4,20); INSERT INTO "GearToOgre" VALUES(7,2,6); INSERT INTO "GearToOgre" VALUES(102,7,8); INSERT INTO "GearToOgre" VALUES(102,5,4); INSERT INTO "GearToOgre" VALUES(102,2,4); INSERT INTO "GearToOgre" VALUES(102,1,2); INSERT INTO "GearToOgre" VALUES(21,104,2); INSERT INTO "GearToOgre" VALUES(21,103,1); INSERT INTO "GearToOgre" VALUES(21,7,4); INSERT INTO "GearToOgre" VALUES(21,2,2); INSERT INTO "GearToOgre" VALUES(22,7,4); INSERT INTO "GearToOgre" VALUES(22,1,1); INSERT INTO "GearToOgre" VALUES(3,1,1); INSERT INTO "GearToOgre" VALUES(1,1,1); INSERT INTO "GearToOgre" VALUES(2,1,1); INSERT INTO "GearToOgre" VALUES(5,1,1); INSERT INTO "GearToOgre" VALUES(6,1,2); INSERT INTO "GearToOgre" VALUES(7,1,3); INSERT INTO "GearToOgre" VALUES(100,2,2); INSERT INTO "GearToOgre" VALUES(103,110,1); INSERT INTO "GearToOgre" VALUES(104,1,2); INSERT INTO "GearToOgre" VALUES(104,2,8); INSERT INTO "GearToOgre" VALUES(104,4,20); INSERT INTO "GearToOgre" VALUES(104,6,3); INSERT INTO "GearToOgre" VALUES(104,7,12); INSERT INTO "GearToOgre" VALUES(105,1,1); INSERT INTO "GearToOgre" VALUES(105,2,2); INSERT INTO "GearToOgre" VALUES(105,5,2); INSERT INTO "GearToOgre" VALUES(105,4,4); INSERT INTO "GearToOgre" VALUES(105,6,1); INSERT INTO "GearToOgre" VALUES(105,7,8); INSERT INTO "GearToOgre" VALUES(106,3,4); INSERT INTO "GearToOgre" VALUES(106,7,6); INSERT INTO "GearToOgre" VALUES(106,5,2); INSERT INTO "GearToOgre" VALUES(106,2,2); INSERT INTO "GearToOgre" VALUES(107,6,4); INSERT INTO "GearToOgre" VALUES(107,4,20); INSERT INTO "GearToOgre" VALUES(107,1,2); INSERT INTO "GearToOgre" VALUES(110,112,3); INSERT INTO "GearToOgre" VALUES(110,109,1); INSERT INTO "GearToOgre" VALUES(108,104,3); INSERT INTO "GearToOgre" VALUES(109,106,3); INSERT INTO "GearToOgre" VALUES(109,107,1); INSERT INTO "GearToOgre" VALUES(109,2,4); INSERT INTO "GearToOgre" VALUES(110,101,6); INSERT INTO "GearToOgre" VALUES(110,8,1); INSERT INTO "GearToOgre" VALUES(110,7,6); INSERT INTO "GearToOgre" VALUES(110,2,1); INSERT INTO "GearToOgre" VALUES(108,101,2); INSERT INTO "GearToOgre" VALUES(108,2,2); INSERT INTO "GearToOgre" VALUES(111,2,2); INSERT INTO "GearToOgre" VALUES(111,7,6); INSERT INTO "GearToOgre" VALUES(111,112,1); INSERT INTO "GearToOgre" VALUES(112,1,2); INSERT INTO "GearToOgre" VALUES(112,2,6); INSERT INTO "GearToOgre" VALUES(112,5,6); INSERT INTO "GearToOgre" VALUES(112,7,10); INSERT INTO "GearToOgre" VALUES(112,8,1); INSERT INTO "GearToOgre" VALUES(112,3,3); INSERT INTO "GearToOgre" VALUES(112,101,7); INSERT INTO "GearToOgre" VALUES(112,100,2); INSERT INTO "GearToOgre" VALUES(112,103,3); INSERT INTO "GearToOgre" VALUES(112,112,2); INSERT INTO "GearToOgre" VALUES(113,102,2); INSERT INTO "GearToOgre" VALUES(113,100,4); INSERT INTO "GearToOgre" VALUES(113,3,4); INSERT INTO "GearToOgre" VALUES(113,7,4); INSERT INTO "GearToOgre" VALUES(113,2,2); INSERT INTO "GearToOgre" VALUES(125,5,2); INSERT INTO "GearToOgre" VALUES(114,7,6); INSERT INTO "GearToOgre" VALUES(114,5,2); INSERT INTO "GearToOgre" VALUES(114,2,3); INSERT INTO "GearToOgre" VALUES(116,3,4); INSERT INTO "GearToOgre" VALUES(116,7,12); INSERT INTO "GearToOgre" VALUES(116,5,4); INSERT INTO "GearToOgre" VALUES(116,2,6); INSERT INTO "GearToOgre" VALUES(8,1,2); INSERT INTO "GearToOgre" VALUES(8,2,4); INSERT INTO "GearToOgre" VALUES(8,5,4); INSERT INTO "GearToOgre" VALUES(8,7,8); INSERT INTO "GearToOgre" VALUES(117,1,2); INSERT INTO "GearToOgre" VALUES(117,2,4); INSERT INTO "GearToOgre" VALUES(117,5,4); INSERT INTO "GearToOgre" VALUES(117,7,8); INSERT INTO "GearToOgre" VALUES(118,102,4); INSERT INTO "GearToOgre" VALUES(118,100,24); INSERT INTO "GearToOgre" VALUES(118,7,6); INSERT INTO "GearToOgre" VALUES(118,2,3); INSERT INTO "GearToOgre" VALUES(125,2,2); INSERT INTO "GearToOgre" VALUES(125,1,4); INSERT INTO "GearToOgre" VALUES(121,7,12); INSERT INTO "GearToOgre" VALUES(121,6,3); INSERT INTO "GearToOgre" VALUES(121,4,15); INSERT INTO "GearToOgre" VALUES(121,2,6); INSERT INTO "GearToOgre" VALUES(121,1,2); INSERT INTO "GearToOgre" VALUES(122,7,8); INSERT INTO "GearToOgre" VALUES(122,6,1); INSERT INTO "GearToOgre" VALUES(122,4,5); INSERT INTO "GearToOgre" VALUES(122,2,4); INSERT INTO "GearToOgre" VALUES(122,1,1); INSERT INTO "GearToOgre" VALUES(114,1,1); INSERT INTO "GearToOgre" VALUES(125,7,12); INSERT INTO "GearToOgre" VALUES(125,103,2); INSERT INTO "GearToOgre" VALUES(126,1,4); INSERT INTO "GearToOgre" VALUES(126,2,2); INSERT INTO "GearToOgre" VALUES(126,5,2); INSERT INTO "GearToOgre" VALUES(126,7,12); INSERT INTO "GearToOgre" VALUES(126,103,2); INSERT INTO "GearToOgre" VALUES(127,101,2); INSERT INTO "GearToOgre" VALUES(127,7,4); INSERT INTO "GearToOgre" VALUES(127,1,1); INSERT INTO "GearToOgre" VALUES(150,101,4); INSERT INTO "GearToOgre" VALUES(150,7,12); INSERT INTO "GearToOgre" VALUES(150,1,5); INSERT INTO "GearToOgre" VALUES(130,101,2); INSERT INTO "GearToOgre" VALUES(130,7,2); INSERT INTO "GearToOgre" VALUES(130,1,2); INSERT INTO "GearToOgre" VALUES(131,100,8); INSERT INTO "GearToOgre" VALUES(131,7,4); INSERT INTO "GearToOgre" VALUES(131,2,2); INSERT INTO "GearToOgre" VALUES(132,1,2); INSERT INTO "GearToOgre" VALUES(132,7,2); INSERT INTO "GearToOgre" VALUES(132,101,2); INSERT INTO "GearToOgre" VALUES(133,1,4); INSERT INTO "GearToOgre" VALUES(133,5,2); INSERT INTO "GearToOgre" VALUES(133,7,6); INSERT INTO "GearToOgre" VALUES(134,7,24); INSERT INTO "GearToOgre" VALUES(134,6,4); INSERT INTO "GearToOgre" VALUES(134,4,32); INSERT INTO "GearToOgre" VALUES(134,2,12); INSERT INTO "GearToOgre" VALUES(134,1,4); INSERT INTO "GearToOgre" VALUES(136,106,2); INSERT INTO "GearToOgre" VALUES(136,107,1); INSERT INTO "GearToOgre" VALUES(136,3,10); INSERT INTO "GearToOgre" VALUES(136,7,10); INSERT INTO "GearToOgre" VALUES(136,2,4); INSERT INTO "GearToOgre" VALUES(137,105,2); INSERT INTO "GearToOgre" VALUES(137,3,4); INSERT INTO "GearToOgre" VALUES(137,7,6); INSERT INTO "GearToOgre" VALUES(137,6,2); INSERT INTO "GearToOgre" VALUES(137,4,6); INSERT INTO "GearToOgre" VALUES(137,2,2); INSERT INTO "GearToOgre" VALUES(137,1,1); INSERT INTO "GearToOgre" VALUES(138,1,4); INSERT INTO "GearToOgre" VALUES(138,2,8); INSERT INTO "GearToOgre" VALUES(138,5,2); INSERT INTO "GearToOgre" VALUES(139,1,4); INSERT INTO "GearToOgre" VALUES(139,2,12); INSERT INTO "GearToOgre" VALUES(139,4,32); INSERT INTO "GearToOgre" VALUES(139,6,4); INSERT INTO "GearToOgre" VALUES(139,7,24); INSERT INTO "GearToOgre" VALUES(140,1,6); INSERT INTO "GearToOgre" VALUES(140,4,24); INSERT INTO "GearToOgre" VALUES(140,6,4); INSERT INTO "GearToOgre" VALUES(140,7,12); INSERT INTO "GearToOgre" VALUES(141,3,6); INSERT INTO "GearToOgre" VALUES(141,7,12); INSERT INTO "GearToOgre" VALUES(141,6,4); INSERT INTO "GearToOgre" VALUES(141,4,20); INSERT INTO "GearToOgre" VALUES(141,2,8); INSERT INTO "GearToOgre" VALUES(142,2,6); INSERT INTO "GearToOgre" VALUES(142,4,15); INSERT INTO "GearToOgre" VALUES(142,6,5); INSERT INTO "GearToOgre" VALUES(142,7,10); INSERT INTO "GearToOgre" VALUES(142,3,2); INSERT INTO "GearToOgre" VALUES(142,112,2); INSERT INTO "GearToOgre" VALUES(141,1,6); INSERT INTO "GearToOgre" VALUES(149,7,6); INSERT INTO "GearToOgre" VALUES(149,5,2); INSERT INTO "GearToOgre" VALUES(149,1,1); INSERT INTO "GearToOgre" VALUES(148,102,2); INSERT INTO "GearToOgre" VALUES(148,100,8); INSERT INTO "GearToOgre" VALUES(148,7,4); INSERT INTO "GearToOgre" VALUES(147,7,8); INSERT INTO "GearToOgre" VALUES(147,2,1); INSERT INTO "GearToOgre" VALUES(145,7,2); INSERT INTO "GearToOgre" VALUES(145,2,1); INSERT INTO "GearToOgre" VALUES(145,1,1); INSERT INTO "GearToOgre" VALUES(144,7,6); INSERT INTO "GearToOgre" VALUES(144,2,2); INSERT INTO "GearToOgre" VALUES(151,7,4); INSERT INTO "GearToOgre" VALUES(151,104,1); INSERT INTO "GearToOgre" VALUES(152,100,12); INSERT INTO "GearToOgre" VALUES(152,7,12); INSERT INTO "GearToOgre" VALUES(152,5,2); INSERT INTO "GearToOgre" VALUES(152,1,4); INSERT INTO "GearToOgre" VALUES(152,102,3); INSERT INTO "GearToOgre" VALUES(153,7,6); INSERT INTO "GearToOgre" VALUES(153,8,1); INSERT INTO "GearToOgre" VALUES(153,3,2); INSERT INTO "GearToOgre" VALUES(153,101,4); INSERT INTO "GearToOgre" VALUES(153,112,4); INSERT INTO "GearToOgre" VALUES(154,1,1); INSERT INTO "GearToOgre" VALUES(154,2,2); INSERT INTO "GearToOgre" VALUES(154,4,4); INSERT INTO "GearToOgre" VALUES(154,6,1); INSERT INTO "GearToOgre" VALUES(154,7,12); INSERT INTO "GearToOgre" VALUES(154,109,1); INSERT INTO "GearToOgre" VALUES(154,111,2); INSERT INTO "GearToOgre" VALUES(155,1,1); INSERT INTO "GearToOgre" VALUES(155,2,2); INSERT INTO "GearToOgre" VALUES(155,4,4); INSERT INTO "GearToOgre" VALUES(155,6,2); INSERT INTO "GearToOgre" VALUES(156,1,2); INSERT INTO "GearToOgre" VALUES(156,2,4); INSERT INTO "GearToOgre" VALUES(156,5,2); INSERT INTO "GearToOgre" VALUES(156,7,8); INSERT INTO "GearToOgre" VALUES(157,104,2); INSERT INTO "GearToOgre" VALUES(157,7,6); INSERT INTO "GearToOgre" VALUES(157,5,4); INSERT INTO "GearToOgre" VALUES(157,2,2); INSERT INTO "GearToOgre" VALUES(157,1,2); INSERT INTO "GearToOgre" VALUES(158,1,2); INSERT INTO "GearToOgre" VALUES(158,2,4); INSERT INTO "GearToOgre" VALUES(158,5,2); INSERT INTO "GearToOgre" VALUES(158,7,8); INSERT INTO "GearToOgre" VALUES(158,109,1); INSERT INTO "GearToOgre" VALUES(158,111,2); INSERT INTO "GearToOgre" VALUES(159,1,4); INSERT INTO "GearToOgre" VALUES(159,2,3); INSERT INTO "GearToOgre" VALUES(159,5,6); INSERT INTO "GearToOgre" VALUES(159,7,2); INSERT INTO "GearToOgre" VALUES(160,1,1); INSERT INTO "GearToOgre" VALUES(160,2,3); INSERT INTO "GearToOgre" VALUES(160,7,6); INSERT INTO "GearToOgre" VALUES(160,3,2); INSERT INTO "GearToOgre" VALUES(160,112,2); INSERT INTO "GearToOgre" VALUES(160,111,2); INSERT INTO "GearToOgre" VALUES(161,7,20); INSERT INTO "GearToOgre" VALUES(161,6,5); INSERT INTO "GearToOgre" VALUES(161,4,30); INSERT INTO "GearToOgre" VALUES(161,2,12); INSERT INTO "GearToOgre" VALUES(161,1,4); INSERT INTO "GearToOgre" VALUES(162,1,2); INSERT INTO "GearToOgre" VALUES(162,2,4); INSERT INTO "GearToOgre" VALUES(162,4,4); INSERT INTO "GearToOgre" VALUES(162,6,1); INSERT INTO "GearToOgre" VALUES(162,7,12); INSERT INTO "GearToOgre" VALUES(163,1,1); INSERT INTO "GearToOgre" VALUES(163,2,3); INSERT INTO "GearToOgre" VALUES(163,4,9); INSERT INTO "GearToOgre" VALUES(163,6,3); INSERT INTO "GearToOgre" VALUES(163,7,10); INSERT INTO "GearToOgre" VALUES(164,2,2); INSERT INTO "GearToOgre" VALUES(164,4,20); INSERT INTO "GearToOgre" VALUES(164,6,4); INSERT INTO "GearToOgre" VALUES(164,7,8); INSERT INTO "GearToOgre" VALUES(165,1,1); INSERT INTO "GearToOgre" VALUES(165,2,2); INSERT INTO "GearToOgre" VALUES(165,4,20); INSERT INTO "GearToOgre" VALUES(165,6,4); INSERT INTO "GearToOgre" VALUES(165,7,6); INSERT INTO "GearToOgre" VALUES(166,1,15); INSERT INTO "GearToOgre" VALUES(166,2,15); INSERT INTO "GearToOgre" VALUES(166,5,20); INSERT INTO "GearToOgre" VALUES(166,4,40); INSERT INTO "GearToOgre" VALUES(166,6,10); INSERT INTO "GearToOgre" VALUES(166,7,30); INSERT INTO "GearToOgre" VALUES(166,8,1); INSERT INTO "GearToOgre" VALUES(167,1,1); INSERT INTO "GearToOgre" VALUES(167,4,16); INSERT INTO "GearToOgre" VALUES(167,6,4); INSERT INTO "GearToOgre" VALUES(167,7,4); INSERT INTO "GearToOgre" VALUES(168,1,3); INSERT INTO "GearToOgre" VALUES(168,2,8); INSERT INTO "GearToOgre" VALUES(168,4,16); INSERT INTO "GearToOgre" VALUES(168,6,4); INSERT INTO "GearToOgre" VALUES(168,7,16); INSERT INTO "GearToOgre" VALUES(169,7,2); INSERT INTO "GearToOgre" VALUES(169,3,4); INSERT INTO "GearToOgre" VALUES(169,103,2); INSERT INTO "GearToOgre" VALUES(170,2,4); INSERT INTO "GearToOgre" VALUES(170,104,1); INSERT INTO "GearToOgre" VALUES(171,1,4); INSERT INTO "GearToOgre" VALUES(171,2,6); INSERT INTO "GearToOgre" VALUES(171,7,16); INSERT INTO "GearToOgre" VALUES(171,3,10); INSERT INTO "GearToOgre" VALUES(171,105,3); INSERT INTO "GearToOgre" VALUES(171,107,2); INSERT INTO "GearToOgre" VALUES(171,106,8); INSERT INTO "GearToOgre" VALUES(172,1,1); INSERT INTO "GearToOgre" VALUES(172,7,4); INSERT INTO "GearToOgre" VALUES(173,3,4); INSERT INTO "GearToOgre" VALUES(173,1,1); INSERT INTO "GearToOgre" VALUES(174,3,4); INSERT INTO "GearToOgre" VALUES(174,1,1); INSERT INTO "GearToOgre" VALUES(175,1,2); INSERT INTO "GearToOgre" VALUES(175,2,3); INSERT INTO "GearToOgre" VALUES(175,4,4); INSERT INTO "GearToOgre" VALUES(175,6,1); INSERT INTO "GearToOgre" VALUES(175,7,8); INSERT INTO "GearToOgre" VALUES(175,113,4); INSERT INTO "GearToOgre" VALUES(176,1,1); INSERT INTO "GearToOgre" VALUES(176,5,2); INSERT INTO "GearToOgre" VALUES(176,113,4); INSERT INTO "GearToOgre" VALUES(177,1,4); INSERT INTO "GearToOgre" VALUES(177,2,10); INSERT INTO "GearToOgre" VALUES(177,7,20); INSERT INTO "GearToOgre" VALUES(177,104,4); INSERT INTO "GearToOgre" VALUES(177,107,3); INSERT INTO "GearToOgre" VALUES(177,106,9); INSERT INTO "GearToOgre" VALUES(178,1,4); INSERT INTO "GearToOgre" VALUES(178,2,10); INSERT INTO "GearToOgre" VALUES(178,4,10); INSERT INTO "GearToOgre" VALUES(178,7,10); INSERT INTO "GearToOgre" VALUES(178,8,1); INSERT INTO "GearToOgre" VALUES(178,113,4); INSERT INTO "GearToOgre" VALUES(178,3,10); INSERT INTO "GearToOgre" VALUES(178,100,8); INSERT INTO "GearToOgre" VALUES(178,102,4); INSERT INTO "GearToOgre" VALUES(178,104,2); INSERT INTO "GearToOgre" VALUES(178,106,4); INSERT INTO "GearToOgre" VALUES(178,109,1); INSERT INTO "GearToOgre" VALUES(178,112,2); INSERT INTO "GearToOgre" VALUES(178,111,2); INSERT INTO "GearToOgre" VALUES(179,7,20); INSERT INTO "GearToOgre" VALUES(179,8,1); INSERT INTO "GearToOgre" VALUES(179,100,40); INSERT INTO "GearToOgre" VALUES(179,102,10); INSERT INTO "GearToOgre" VALUES(179,103,6); INSERT INTO "GearToOgre" VALUES(179,104,6); INSERT INTO "GearToOgre" VALUES(179,105,4); INSERT INTO "GearToOgre" VALUES(179,109,1); INSERT INTO "GearToOgre" VALUES(179,112,4); INSERT INTO "GearToOgre" VALUES(179,111,2); INSERT INTO "GearToOgre" VALUES(180,7,12); INSERT INTO "GearToOgre" VALUES(180,6,1); INSERT INTO "GearToOgre" VALUES(180,4,4); INSERT INTO "GearToOgre" VALUES(180,2,4); INSERT INTO "GearToOgre" VALUES(180,1,2); INSERT INTO "GearToOgre" VALUES(181,7,16); INSERT INTO "GearToOgre" VALUES(181,6,2); INSERT INTO "GearToOgre" VALUES(181,4,8); INSERT INTO "GearToOgre" VALUES(181,2,6); INSERT INTO "GearToOgre" VALUES(181,1,2); INSERT INTO "GearToOgre" VALUES(182,1,6); INSERT INTO "GearToOgre" VALUES(182,2,12); INSERT INTO "GearToOgre" VALUES(182,5,10); INSERT INTO "GearToOgre" VALUES(182,4,40); INSERT INTO "GearToOgre" VALUES(182,6,4); INSERT INTO "GearToOgre" VALUES(182,7,20); INSERT INTO "GearToOgre" VALUES(182,107,1); INSERT INTO "GearToOgre" VALUES(182,106,4); INSERT INTO "GearToOgre" VALUES(182,112,4); INSERT INTO "GearToOgre" VALUES(182,111,2); INSERT INTO "GearToOgre" VALUES(248,1,4); INSERT INTO "GearToOgre" VALUES(247,102,4); INSERT INTO "GearToOgre" VALUES(247,3,1); INSERT INTO "GearToOgre" VALUES(246,112,4); INSERT INTO "GearToOgre" VALUES(246,8,1); INSERT INTO "GearToOgre" VALUES(246,7,9); INSERT INTO "GearToOgre" VALUES(246,6,8); INSERT INTO "GearToOgre" VALUES(246,4,32); INSERT INTO "GearToOgre" VALUES(246,1,4); INSERT INTO "GearToOgre" VALUES(245,8,1); INSERT INTO "GearToOgre" VALUES(245,7,9); INSERT INTO "GearToOgre" VALUES(245,6,10); INSERT INTO "GearToOgre" VALUES(245,4,40); INSERT INTO "GearToOgre" VALUES(244,105,2); INSERT INTO "GearToOgre" VALUES(244,104,3); INSERT INTO "GearToOgre" VALUES(244,103,3); INSERT INTO "GearToOgre" VALUES(244,8,1); INSERT INTO "GearToOgre" VALUES(244,7,9); INSERT INTO "GearToOgre" VALUES(243,103,5); INSERT INTO "GearToOgre" VALUES(243,8,1); INSERT INTO "GearToOgre" VALUES(243,7,9); INSERT INTO "GearToOgre" VALUES(184,2,2); INSERT INTO "GearToOgre" VALUES(184,5,4); INSERT INTO "GearToOgre" VALUES(184,7,12); INSERT INTO "GearToOgre" VALUES(184,110,4); INSERT INTO "GearToOgre" VALUES(185,1,4); INSERT INTO "GearToOgre" VALUES(185,2,8); INSERT INTO "GearToOgre" VALUES(185,5,8); INSERT INTO "GearToOgre" VALUES(185,7,24); INSERT INTO "GearToOgre" VALUES(185,110,8); INSERT INTO "GearToOgre" VALUES(186,1,10); INSERT INTO "GearToOgre" VALUES(186,2,10); INSERT INTO "GearToOgre" VALUES(186,4,40); INSERT INTO "GearToOgre" VALUES(186,6,5); INSERT INTO "GearToOgre" VALUES(186,7,30); INSERT INTO "GearToOgre" VALUES(186,113,5); INSERT INTO "GearToOgre" VALUES(186,3,10); INSERT INTO "GearToOgre" VALUES(186,101,20); INSERT INTO "GearToOgre" VALUES(186,100,40); INSERT INTO "GearToOgre" VALUES(186,102,10); INSERT INTO "GearToOgre" VALUES(186,103,10); INSERT INTO "GearToOgre" VALUES(186,104,6); INSERT INTO "GearToOgre" VALUES(186,105,4); INSERT INTO "GearToOgre" VALUES(186,107,10); INSERT INTO "GearToOgre" VALUES(186,106,10); INSERT INTO "GearToOgre" VALUES(186,112,4); INSERT INTO "GearToOgre" VALUES(186,111,2); INSERT INTO "GearToOgre" VALUES(242,103,10); INSERT INTO "GearToOgre" VALUES(242,8,1); INSERT INTO "GearToOgre" VALUES(242,7,9); INSERT INTO "GearToOgre" VALUES(241,104,4); INSERT INTO "GearToOgre" VALUES(241,8,1); INSERT INTO "GearToOgre" VALUES(241,7,9); INSERT INTO "GearToOgre" VALUES(240,104,6); INSERT INTO "GearToOgre" VALUES(188,1,2); INSERT INTO "GearToOgre" VALUES(188,8,1); INSERT INTO "GearToOgre" VALUES(188,104,2); INSERT INTO "GearToOgre" VALUES(189,100,2); INSERT INTO "GearToOgre" VALUES(189,102,2); INSERT INTO "GearToOgre" VALUES(189,104,2); INSERT INTO "GearToOgre" VALUES(189,109,1); INSERT INTO "GearToOgre" VALUES(190,1,15); INSERT INTO "GearToOgre" VALUES(190,2,15); INSERT INTO "GearToOgre" VALUES(190,5,20); INSERT INTO "GearToOgre" VALUES(190,4,40); INSERT INTO "GearToOgre" VALUES(190,6,10); INSERT INTO "GearToOgre" VALUES(190,7,30); INSERT INTO "GearToOgre" VALUES(190,8,1); INSERT INTO "GearToOgre" VALUES(190,113,30); INSERT INTO "GearToOgre" VALUES(190,3,20); INSERT INTO "GearToOgre" VALUES(190,101,40); INSERT INTO "GearToOgre" VALUES(190,100,40); INSERT INTO "GearToOgre" VALUES(190,102,10); INSERT INTO "GearToOgre" VALUES(190,103,10); INSERT INTO "GearToOgre" VALUES(190,104,6); INSERT INTO "GearToOgre" VALUES(190,105,4); INSERT INTO "GearToOgre" VALUES(190,107,10); INSERT INTO "GearToOgre" VALUES(190,106,10); INSERT INTO "GearToOgre" VALUES(190,109,1); INSERT INTO "GearToOgre" VALUES(190,112,4); INSERT INTO "GearToOgre" VALUES(190,111,2); INSERT INTO "GearToOgre" VALUES(190,110,10); INSERT INTO "GearToOgre" VALUES(192,1,15); INSERT INTO "GearToOgre" VALUES(192,2,12); INSERT INTO "GearToOgre" VALUES(192,4,16); INSERT INTO "GearToOgre" VALUES(192,7,25); INSERT INTO "GearToOgre" VALUES(192,8,1); INSERT INTO "GearToOgre" VALUES(193,1,1); INSERT INTO "GearToOgre" VALUES(193,2,1); INSERT INTO "GearToOgre" VALUES(193,7,2); INSERT INTO "GearToOgre" VALUES(193,101,2); INSERT INTO "GearToOgre" VALUES(194,1,1); INSERT INTO "GearToOgre" VALUES(194,2,1); INSERT INTO "GearToOgre" VALUES(194,5,1); INSERT INTO "GearToOgre" VALUES(194,7,4); INSERT INTO "GearToOgre" VALUES(195,1,1); INSERT INTO "GearToOgre" VALUES(195,5,1); INSERT INTO "GearToOgre" VALUES(195,7,4); INSERT INTO "GearToOgre" VALUES(195,3,1); INSERT INTO "GearToOgre" VALUES(196,1,1); INSERT INTO "GearToOgre" VALUES(196,2,2); INSERT INTO "GearToOgre" VALUES(196,5,2); INSERT INTO "GearToOgre" VALUES(196,7,8); INSERT INTO "GearToOgre" VALUES(196,3,4); INSERT INTO "GearToOgre" VALUES(197,1,1); INSERT INTO "GearToOgre" VALUES(197,2,15); INSERT INTO "GearToOgre" VALUES(197,7,30); INSERT INTO "GearToOgre" VALUES(197,8,1); INSERT INTO "GearToOgre" VALUES(197,109,1); INSERT INTO "GearToOgre" VALUES(197,110,1); INSERT INTO "GearToOgre" VALUES(198,1,1); INSERT INTO "GearToOgre" VALUES(198,2,10); INSERT INTO "GearToOgre" VALUES(198,7,30); INSERT INTO "GearToOgre" VALUES(198,113,30); INSERT INTO "GearToOgre" VALUES(198,3,5); INSERT INTO "GearToOgre" VALUES(198,109,1); INSERT INTO "GearToOgre" VALUES(198,110,1); INSERT INTO "GearToOgre" VALUES(199,1,1); INSERT INTO "GearToOgre" VALUES(199,2,15); INSERT INTO "GearToOgre" VALUES(199,7,30); INSERT INTO "GearToOgre" VALUES(199,8,1); INSERT INTO "GearToOgre" VALUES(199,113,20); INSERT INTO "GearToOgre" VALUES(199,3,10); INSERT INTO "GearToOgre" VALUES(199,109,1); INSERT INTO "GearToOgre" VALUES(199,110,1); INSERT INTO "GearToOgre" VALUES(200,1,2); INSERT INTO "GearToOgre" VALUES(200,2,15); INSERT INTO "GearToOgre" VALUES(200,7,30); INSERT INTO "GearToOgre" VALUES(200,8,1); INSERT INTO "GearToOgre" VALUES(200,113,30); INSERT INTO "GearToOgre" VALUES(200,3,20); INSERT INTO "GearToOgre" VALUES(200,109,1); INSERT INTO "GearToOgre" VALUES(200,110,2); INSERT INTO "GearToOgre" VALUES(201,1,1); INSERT INTO "GearToOgre" VALUES(201,2,4); INSERT INTO "GearToOgre" VALUES(201,7,6); INSERT INTO "GearToOgre" VALUES(201,112,1); INSERT INTO "GearToOgre" VALUES(240,8,1); INSERT INTO "GearToOgre" VALUES(240,7,9); INSERT INTO "GearToOgre" VALUES(239,105,4); INSERT INTO "GearToOgre" VALUES(239,8,1); INSERT INTO "GearToOgre" VALUES(239,7,9); INSERT INTO "GearToOgre" VALUES(203,2,2); INSERT INTO "GearToOgre" VALUES(203,4,20); INSERT INTO "GearToOgre" VALUES(203,6,4); INSERT INTO "GearToOgre" VALUES(203,7,8); INSERT INTO "GearToOgre" VALUES(107,7,8); INSERT INTO "GearToOgre" VALUES(204,1,3); INSERT INTO "GearToOgre" VALUES(204,2,6); INSERT INTO "GearToOgre" VALUES(204,5,6); INSERT INTO "GearToOgre" VALUES(204,4,20); INSERT INTO "GearToOgre" VALUES(204,6,2); INSERT INTO "GearToOgre" VALUES(204,7,16); INSERT INTO "GearToOgre" VALUES(205,1,15); INSERT INTO "GearToOgre" VALUES(205,2,15); INSERT INTO "GearToOgre" VALUES(205,5,20); INSERT INTO "GearToOgre" VALUES(205,4,40); INSERT INTO "GearToOgre" VALUES(205,6,10); INSERT INTO "GearToOgre" VALUES(205,7,30); INSERT INTO "GearToOgre" VALUES(205,8,1); INSERT INTO "GearToOgre" VALUES(205,113,30); INSERT INTO "GearToOgre" VALUES(205,3,20); INSERT INTO "GearToOgre" VALUES(205,101,40); INSERT INTO "GearToOgre" VALUES(205,100,40); INSERT INTO "GearToOgre" VALUES(205,102,10); INSERT INTO "GearToOgre" VALUES(205,103,10); INSERT INTO "GearToOgre" VALUES(205,104,6); INSERT INTO "GearToOgre" VALUES(205,105,4); INSERT INTO "GearToOgre" VALUES(205,107,10); INSERT INTO "GearToOgre" VALUES(205,106,10); INSERT INTO "GearToOgre" VALUES(205,109,1); INSERT INTO "GearToOgre" VALUES(205,112,4); INSERT INTO "GearToOgre" VALUES(205,111,2); INSERT INTO "GearToOgre" VALUES(205,110,10); INSERT INTO "GearToOgre" VALUES(206,1,1); INSERT INTO "GearToOgre" VALUES(206,4,20); INSERT INTO "GearToOgre" VALUES(206,6,4); INSERT INTO "GearToOgre" VALUES(206,7,4); INSERT INTO "GearToOgre" VALUES(238,7,6); INSERT INTO "GearToOgre" VALUES(238,5,6); INSERT INTO "GearToOgre" VALUES(238,2,4); INSERT INTO "GearToOgre" VALUES(238,1,4); INSERT INTO "GearToOgre" VALUES(208,1,1); INSERT INTO "GearToOgre" VALUES(208,4,20); INSERT INTO "GearToOgre" VALUES(208,6,4); INSERT INTO "GearToOgre" VALUES(208,7,4); INSERT INTO "GearToOgre" VALUES(209,1,1); INSERT INTO "GearToOgre" VALUES(209,2,2); INSERT INTO "GearToOgre" VALUES(209,5,4); INSERT INTO "GearToOgre" VALUES(209,7,11); INSERT INTO "GearToOgre" VALUES(210,1,1); INSERT INTO "GearToOgre" VALUES(210,2,1); INSERT INTO "GearToOgre" VALUES(210,5,2); INSERT INTO "GearToOgre" VALUES(210,7,1); INSERT INTO "GearToOgre" VALUES(211,1,1); INSERT INTO "GearToOgre" VALUES(211,2,1); INSERT INTO "GearToOgre" VALUES(211,5,2); INSERT INTO "GearToOgre" VALUES(211,7,1); INSERT INTO "GearToOgre" VALUES(212,1,4); INSERT INTO "GearToOgre" VALUES(212,2,2); INSERT INTO "GearToOgre" VALUES(212,5,7); INSERT INTO "GearToOgre" VALUES(212,7,12); INSERT INTO "GearToOgre" VALUES(213,1,4); INSERT INTO "GearToOgre" VALUES(213,2,6); INSERT INTO "GearToOgre" VALUES(213,4,12); INSERT INTO "GearToOgre" VALUES(213,6,4); INSERT INTO "GearToOgre" VALUES(213,7,12); INSERT INTO "GearToOgre" VALUES(214,1,2); INSERT INTO "GearToOgre" VALUES(214,2,2); INSERT INTO "GearToOgre" VALUES(214,5,2); INSERT INTO "GearToOgre" VALUES(214,4,8); INSERT INTO "GearToOgre" VALUES(214,6,2); INSERT INTO "GearToOgre" VALUES(214,7,4); INSERT INTO "GearToOgre" VALUES(215,2,4); INSERT INTO "GearToOgre" VALUES(215,7,8); INSERT INTO "GearToOgre" VALUES(215,101,4); INSERT INTO "GearToOgre" VALUES(215,112,3); INSERT INTO "GearToOgre" VALUES(215,111,1); INSERT INTO "GearToOgre" VALUES(216,1,3); INSERT INTO "GearToOgre" VALUES(216,112,1); INSERT INTO "GearToOgre" VALUES(217,1,2); INSERT INTO "GearToOgre" VALUES(217,2,2); INSERT INTO "GearToOgre" VALUES(217,4,6); INSERT INTO "GearToOgre" VALUES(217,6,2); INSERT INTO "GearToOgre" VALUES(217,7,4); INSERT INTO "GearToOgre" VALUES(217,113,2); INSERT INTO "GearToOgre" VALUES(217,110,1); INSERT INTO "GearToOgre" VALUES(218,1,2); INSERT INTO "GearToOgre" VALUES(218,2,4); INSERT INTO "GearToOgre" VALUES(218,7,8); INSERT INTO "GearToOgre" VALUES(219,1,2); INSERT INTO "GearToOgre" VALUES(219,2,3); INSERT INTO "GearToOgre" VALUES(219,4,10); INSERT INTO "GearToOgre" VALUES(219,6,2); INSERT INTO "GearToOgre" VALUES(219,7,7); INSERT INTO "GearToOgre" VALUES(220,1,3); INSERT INTO "GearToOgre" VALUES(220,2,6); INSERT INTO "GearToOgre" VALUES(220,5,4); INSERT INTO "GearToOgre" VALUES(220,7,12); INSERT INTO "GearToOgre" VALUES(221,1,2); INSERT INTO "GearToOgre" VALUES(221,2,3); INSERT INTO "GearToOgre" VALUES(221,4,10); INSERT INTO "GearToOgre" VALUES(221,6,2); INSERT INTO "GearToOgre" VALUES(221,7,6); INSERT INTO "GearToOgre" VALUES(222,1,4); INSERT INTO "GearToOgre" VALUES(222,2,4); INSERT INTO "GearToOgre" VALUES(222,4,24); INSERT INTO "GearToOgre" VALUES(222,6,4); INSERT INTO "GearToOgre" VALUES(222,7,12); INSERT INTO "GearToOgre" VALUES(223,1,15); INSERT INTO "GearToOgre" VALUES(223,2,15); INSERT INTO "GearToOgre" VALUES(223,7,19); INSERT INTO "GearToOgre" VALUES(224,4,40); INSERT INTO "GearToOgre" VALUES(224,6,8); INSERT INTO "GearToOgre" VALUES(224,7,20); INSERT INTO "GearToOgre" VALUES(224,113,6); INSERT INTO "GearToOgre" VALUES(224,103,2); INSERT INTO "GearToOgre" VALUES(224,104,2); INSERT INTO "GearToOgre" VALUES(224,105,2); INSERT INTO "GearToOgre" VALUES(225,1,2); INSERT INTO "GearToOgre" VALUES(225,2,2); INSERT INTO "GearToOgre" VALUES(225,4,6); INSERT INTO "GearToOgre" VALUES(225,6,2); INSERT INTO "GearToOgre" VALUES(225,7,6); INSERT INTO "GearToOgre" VALUES(225,113,6); INSERT INTO "GearToOgre" VALUES(225,101,1); INSERT INTO "GearToOgre" VALUES(231,7,4); INSERT INTO "GearToOgre" VALUES(231,6,4); INSERT INTO "GearToOgre" VALUES(231,4,12); INSERT INTO "GearToOgre" VALUES(231,2,4); INSERT INTO "GearToOgre" VALUES(226,111,1); INSERT INTO "GearToOgre" VALUES(226,104,1); INSERT INTO "GearToOgre" VALUES(226,3,4); INSERT INTO "GearToOgre" VALUES(226,113,6); INSERT INTO "GearToOgre" VALUES(226,5,2); INSERT INTO "GearToOgre" VALUES(226,2,2); INSERT INTO "GearToOgre" VALUES(227,4,40); INSERT INTO "GearToOgre" VALUES(227,6,8); INSERT INTO "GearToOgre" VALUES(227,7,20); INSERT INTO "GearToOgre" VALUES(227,113,10); INSERT INTO "GearToOgre" VALUES(227,103,1); INSERT INTO "GearToOgre" VALUES(227,104,1); INSERT INTO "GearToOgre" VALUES(227,105,1); INSERT INTO "GearToOgre" VALUES(228,2,2); INSERT INTO "GearToOgre" VALUES(228,4,40); INSERT INTO "GearToOgre" VALUES(228,6,8); INSERT INTO "GearToOgre" VALUES(228,113,8); INSERT INTO "GearToOgre" VALUES(229,4,40); INSERT INTO "GearToOgre" VALUES(229,113,4); INSERT INTO "GearToOgre" VALUES(230,2,2); INSERT INTO "GearToOgre" VALUES(230,8,1); INSERT INTO "GearToOgre" VALUES(230,113,6); INSERT INTO "GearToOgre" VALUES(230,3,6); INSERT INTO "GearToOgre" VALUES(230,112,4); INSERT INTO "GearToOgre" VALUES(230,111,2); INSERT INTO "GearToOgre" VALUES(231,113,4); INSERT INTO "GearToOgre" VALUES(231,101,4); INSERT INTO "GearToOgre" VALUES(232,109,1); INSERT INTO "GearToOgre" VALUES(232,7,6); INSERT INTO "GearToOgre" VALUES(232,2,2); INSERT INTO "GearToOgre" VALUES(237,7,6); INSERT INTO "GearToOgre" VALUES(237,5,4); INSERT INTO "GearToOgre" VALUES(237,1,4); INSERT INTO "GearToOgre" VALUES(234,3,4); INSERT INTO "GearToOgre" VALUES(234,113,2); INSERT INTO "GearToOgre" VALUES(234,7,4); INSERT INTO "GearToOgre" VALUES(234,2,2); INSERT INTO "GearToOgre" VALUES(235,111,2); INSERT INTO "GearToOgre" VALUES(235,112,3); INSERT INTO "GearToOgre" VALUES(235,104,2); INSERT INTO "GearToOgre" VALUES(235,3,4); INSERT INTO "GearToOgre" VALUES(235,113,4); INSERT INTO "GearToOgre" VALUES(235,7,4); INSERT INTO "GearToOgre" VALUES(235,6,1); INSERT INTO "GearToOgre" VALUES(235,4,4); INSERT INTO "GearToOgre" VALUES(235,5,2); INSERT INTO "GearToOgre" VALUES(235,2,4); INSERT INTO "GearToOgre" VALUES(235,1,3); INSERT INTO "GearToOgre" VALUES(236,1,2); INSERT INTO "GearToOgre" VALUES(236,2,2); INSERT INTO "GearToOgre" VALUES(236,7,8); INSERT INTO "GearToOgre" VALUES(236,103,2); INSERT INTO "GearToOgre" VALUES(236,105,1); INSERT INTO "GearToOgre" VALUES(248,2,8); INSERT INTO "GearToOgre" VALUES(248,4,30); INSERT INTO "GearToOgre" VALUES(248,6,3); INSERT INTO "GearToOgre" VALUES(248,7,18); INSERT INTO "GearToOgre" VALUES(248,110,1); INSERT INTO "GearToOgre" VALUES(249,112,2); INSERT INTO "GearToOgre" VALUES(249,113,2); INSERT INTO "GearToOgre" VALUES(249,7,6); INSERT INTO "GearToOgre" VALUES(249,5,2); INSERT INTO "GearToOgre" VALUES(249,2,1); INSERT INTO "GearToOgre" VALUES(250,5,2); INSERT INTO "GearToOgre" VALUES(250,2,4); INSERT INTO "GearToOgre" VALUES(250,1,1); INSERT INTO "GearToOgre" VALUES(131,102,4); INSERT INTO "GearToOgre" VALUES(250,7,8); INSERT INTO "GearToOgre" VALUES(251,2,6); INSERT INTO "GearToOgre" VALUES(251,4,20); INSERT INTO "GearToOgre" VALUES(251,6,5); INSERT INTO "GearToOgre" VALUES(251,7,12); INSERT INTO "GearToOgre" VALUES(252,1,1); INSERT INTO "GearToOgre" VALUES(252,4,4); INSERT INTO "GearToOgre" VALUES(252,6,1); INSERT INTO "GearToOgre" VALUES(252,7,4); INSERT INTO "GearToOgre" VALUES(253,1,1); INSERT INTO "GearToOgre" VALUES(253,4,4); INSERT INTO "GearToOgre" VALUES(253,6,1); INSERT INTO "GearToOgre" VALUES(253,7,4); INSERT INTO "GearToOgre" VALUES(254,1,1); INSERT INTO "GearToOgre" VALUES(254,4,4); INSERT INTO "GearToOgre" VALUES(254,6,1); INSERT INTO "GearToOgre" VALUES(254,7,4); INSERT INTO "GearToOgre" VALUES(255,2,4); INSERT INTO "GearToOgre" VALUES(255,5,4); INSERT INTO "GearToOgre" VALUES(255,7,8); INSERT INTO "GearToOgre" VALUES(255,100,20); INSERT INTO "GearToOgre" VALUES(255,102,5); INSERT INTO "GearToOgre" VALUES(256,7,4); INSERT INTO "GearToOgre" VALUES(256,109,1); INSERT INTO "GearToOgre" VALUES(256,112,2); INSERT INTO "GearToOgre" VALUES(256,111,2); INSERT INTO "GearToOgre" VALUES(257,1,3); INSERT INTO "GearToOgre" VALUES(257,2,6); INSERT INTO "GearToOgre" VALUES(257,4,18); INSERT INTO "GearToOgre" VALUES(257,6,3); INSERT INTO "GearToOgre" VALUES(257,7,12); INSERT INTO "GearToOgre" VALUES(257,113,2); INSERT INTO "GearToOgre" VALUES(258,1,15); INSERT INTO "GearToOgre" VALUES(258,2,15); INSERT INTO "GearToOgre" VALUES(258,5,20); INSERT INTO "GearToOgre" VALUES(258,4,40); INSERT INTO "GearToOgre" VALUES(258,6,10); INSERT INTO "GearToOgre" VALUES(258,7,30); INSERT INTO "GearToOgre" VALUES(258,8,1); INSERT INTO "GearToOgre" VALUES(258,113,30); INSERT INTO "GearToOgre" VALUES(258,3,20); INSERT INTO "GearToOgre" VALUES(258,101,40); INSERT INTO "GearToOgre" VALUES(258,100,40); INSERT INTO "GearToOgre" VALUES(258,102,10); INSERT INTO "GearToOgre" VALUES(258,103,10); INSERT INTO "GearToOgre" VALUES(258,104,6); INSERT INTO "GearToOgre" VALUES(258,105,4); INSERT INTO "GearToOgre" VALUES(258,107,10); INSERT INTO "GearToOgre" VALUES(258,106,10); INSERT INTO "GearToOgre" VALUES(258,109,1); INSERT INTO "GearToOgre" VALUES(258,112,4); INSERT INTO "GearToOgre" VALUES(258,111,2); INSERT INTO "GearToOgre" VALUES(259,1,15); INSERT INTO "GearToOgre" VALUES(259,2,15); INSERT INTO "GearToOgre" VALUES(259,5,20); INSERT INTO "GearToOgre" VALUES(259,4,40); INSERT INTO "GearToOgre" VALUES(259,6,10); INSERT INTO "GearToOgre" VALUES(259,7,30); INSERT INTO "GearToOgre" VALUES(259,8,1); INSERT INTO "GearToOgre" VALUES(259,113,30); INSERT INTO "GearToOgre" VALUES(259,3,20); INSERT INTO "GearToOgre" VALUES(259,101,40); INSERT INTO "GearToOgre" VALUES(259,100,40); INSERT INTO "GearToOgre" VALUES(259,102,10); INSERT INTO "GearToOgre" VALUES(259,103,10); INSERT INTO "GearToOgre" VALUES(259,104,6); INSERT INTO "GearToOgre" VALUES(259,105,4); INSERT INTO "GearToOgre" VALUES(259,107,10); INSERT INTO "GearToOgre" VALUES(259,106,10); INSERT INTO "GearToOgre" VALUES(259,109,1); INSERT INTO "GearToOgre" VALUES(259,112,2); INSERT INTO "GearToOgre" VALUES(259,111,2); INSERT INTO "GearToOgre" VALUES(259,110,1); INSERT INTO "GearToOgre" VALUES(260,1,2); INSERT INTO "GearToOgre" VALUES(260,2,2); INSERT INTO "GearToOgre" VALUES(260,4,12); INSERT INTO "GearToOgre" VALUES(260,6,3); INSERT INTO "GearToOgre" VALUES(260,7,4); INSERT INTO "GearToOgre" VALUES(260,3,2); INSERT INTO "GearToOgre" VALUES(260,111,1); INSERT INTO "GearToOgre" VALUES(261,1,4); INSERT INTO "GearToOgre" VALUES(261,2,6); INSERT INTO "GearToOgre" VALUES(261,4,40); INSERT INTO "GearToOgre" VALUES(261,6,8); INSERT INTO "GearToOgre" VALUES(261,7,10); INSERT INTO "GearToOgre" VALUES(261,113,5); INSERT INTO "GearToOgre" VALUES(261,3,8); INSERT INTO "GearToOgre" VALUES(261,104,6); INSERT INTO "GearToOgre" VALUES(261,105,2); INSERT INTO "GearToOgre" VALUES(261,107,2); INSERT INTO "GearToOgre" VALUES(261,106,6); INSERT INTO "GearToOgre" VALUES(261,109,1); INSERT INTO "GearToOgre" VALUES(261,112,4); INSERT INTO "GearToOgre" VALUES(261,111,2); INSERT INTO "GearToOgre" VALUES(264,1,1); INSERT INTO "GearToOgre" VALUES(263,7,4); INSERT INTO "GearToOgre" VALUES(263,2,3); INSERT INTO "GearToOgre" VALUES(263,1,2); INSERT INTO "GearToOgre" VALUES(262,3,4); INSERT INTO "GearToOgre" VALUES(262,7,8); INSERT INTO "GearToOgre" VALUES(262,6,3); INSERT INTO "GearToOgre" VALUES(262,4,12); INSERT INTO "GearToOgre" VALUES(264,2,4); INSERT INTO "GearToOgre" VALUES(264,5,2); INSERT INTO "GearToOgre" VALUES(264,7,8); INSERT INTO "GearToOgre" VALUES(265,111,2); INSERT INTO "GearToOgre" VALUES(265,109,1); INSERT INTO "GearToOgre" VALUES(265,8,1); INSERT INTO "GearToOgre" VALUES(265,7,8); INSERT INTO "GearToOgre" VALUES(265,2,2); INSERT INTO "GearToOgre" VALUES(266,1,4); INSERT INTO "GearToOgre" VALUES(266,2,8); INSERT INTO "GearToOgre" VALUES(266,5,6); INSERT INTO "GearToOgre" VALUES(266,4,20); INSERT INTO "GearToOgre" VALUES(266,6,2); INSERT INTO "GearToOgre" VALUES(266,7,16); INSERT INTO "GearToOgre" VALUES(266,8,1); INSERT INTO "GearToOgre" VALUES(267,1,2); INSERT INTO "GearToOgre" VALUES(267,2,4); INSERT INTO "GearToOgre" VALUES(267,5,8); INSERT INTO "GearToOgre" VALUES(267,4,20); INSERT INTO "GearToOgre" VALUES(267,6,4); INSERT INTO "GearToOgre" VALUES(267,7,8); INSERT INTO "GearToOgre" VALUES(267,8,1); INSERT INTO "GearToOgre" VALUES(267,113,8); INSERT INTO "GearToOgre" VALUES(267,3,6); INSERT INTO "GearToOgre" VALUES(267,101,4); INSERT INTO "GearToOgre" VALUES(267,100,6); INSERT INTO "GearToOgre" VALUES(267,102,1); INSERT INTO "GearToOgre" VALUES(267,103,2); INSERT INTO "GearToOgre" VALUES(267,104,2); INSERT INTO "GearToOgre" VALUES(267,105,1); INSERT INTO "GearToOgre" VALUES(267,109,1); INSERT INTO "GearToOgre" VALUES(267,112,2); INSERT INTO "GearToOgre" VALUES(267,111,1); INSERT INTO "GearToOgre" VALUES(267,110,2); INSERT INTO "GearToOgre" VALUES(268,2,2); INSERT INTO "GearToOgre" VALUES(268,7,8); INSERT INTO "GearToOgre" VALUES(268,8,1); INSERT INTO "GearToOgre" VALUES(268,109,1); INSERT INTO "GearToOgre" VALUES(268,111,2); -- Exactly where these icons live is up to the application. INSERT INTO OgreIcons VALUES('Default-nolabel.png'); INSERT INTO OgreIcons VALUES('Default.png'); INSERT INTO OgreIcons VALUES('Doppelsoldner-nolabel.png'); INSERT INTO OgreIcons VALUES('Doppelsoldner.png'); INSERT INTO OgreIcons VALUES('Fencer-nolabel.png'); INSERT INTO OgreIcons VALUES('Fencer.png'); INSERT INTO OgreIcons VALUES('Flower-nolabel.png'); INSERT INTO OgreIcons VALUES('Flower.png'); INSERT INTO OgreIcons VALUES('FreeLove-nolabel.png'); INSERT INTO OgreIcons VALUES('FreeLove.png'); INSERT INTO OgreIcons VALUES('Lancer-nolabel.png'); INSERT INTO OgreIcons VALUES('Lancer.png'); INSERT INTO OgreIcons VALUES('MarkIIIb-nolabel.png'); INSERT INTO OgreIcons VALUES('MarkIIIb.png'); INSERT INTO OgreIcons VALUES('MarkIII-nolabel.png'); INSERT INTO OgreIcons VALUES('MarkIII.png'); INSERT INTO OgreIcons VALUES('MarkIIIx-nolabel.png'); INSERT INTO OgreIcons VALUES('MarkIIIx.png'); INSERT INTO OgreIcons VALUES('MarkII-nolabel.png'); INSERT INTO OgreIcons VALUES('MarkII.png'); INSERT INTO OgreIcons VALUES('MarkI-nolabel.png'); INSERT INTO OgreIcons VALUES('MarkI.png'); INSERT INTO OgreIcons VALUES('MarkIV-nolabel.png'); INSERT INTO OgreIcons VALUES('MarkIV.png'); INSERT INTO OgreIcons VALUES('MarkVI-nolabel.png'); INSERT INTO OgreIcons VALUES('MarkVI.png'); INSERT INTO OgreIcons VALUES('MarkV-nolabel.png'); INSERT INTO OgreIcons VALUES('MarkV.png'); INSERT INTO OgreIcons VALUES('Ninja-nolabel.png'); INSERT INTO OgreIcons VALUES('Ninja.png'); INSERT INTO OgreIcons VALUES('Spartan-nolabel.png'); INSERT INTO OgreIcons VALUES('Spartan.png'); -- Optional setup: -- Remove unofficial Ogres: -- DELETE FROM Ogre where IsOfficial=0; -- DELETE FROM Ogre where Ciscos>210; -- Calculate Ciscos: UPDATE Ogre SET Ciscos=0; INSERT INTO ttr_Ogre_Ciscos SELECT ID FROM Ogre; COMMIT TRANSACTION;