BEGIN TRANSACTION; 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,4,100,0,1,'Optional Rule: move _or_ fire.',10,3,0,0,3,0,1); INSERT INTO "Gear" VALUES(105,6.0,'Long Tom','LTOM',4,12,4,120,0,1,'Optional Rule: move _or_ fire.',15,3,0,0,2,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,4,0,1); INSERT INTO "Gear" VALUES(107,100.0,'Cruise Missile Launcher','CML',0,0,6,60,0,1,NULL,15,3,0,0,2,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.',1,1,0,0,1,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,0,'New Ogre',NULL,0,'Default.png',7,0,0,NULL,0,NULL,NULL,NULL); INSERT INTO "Ogre" VALUES(1,1,'Mark I','',1,'MarkI.png',5,3,5,47.45,0,'','',''); INSERT INTO "Ogre" VALUES(2,1,'Mark II','',1,'MarkII.png',6,3,10,96.43,0,'','',''); INSERT INTO "Ogre" VALUES(3,1,'Mark III','',1,'MarkIII.png',7,3,15,163.77,0,'','',''); INSERT INTO "Ogre" VALUES(4,1,'Fencer','',1,'Fencer.png',8,3,15,220.4,0,'','',''); INSERT INTO "Ogre" VALUES(5,1,'Mark IV','',1,'MarkIV.png',8,4,15,271.42,0,'','',''); INSERT INTO "Ogre" VALUES(6,1,'Mark V','',1,'MarkV.png',8,3,20,270.91,0,'','',''); INSERT INTO "Ogre" VALUES(7,1,'Mark VI','',1,'MarkVI.png',9,3,25,367.34,0,'','',''); INSERT INTO "Ogre" VALUES(8,1,'Mark IIIb','',1,'MarkIIIb.png',7,3,16,205.1,0,'','',''); INSERT INTO "Ogre" VALUES(100,1,'Flower','',0,'Flower.png',8,4,15,226.78,'','Stephan Beal','http://wanderinghorse.net/home/stephan/','A refitted Mark IV built for quick strikes against smaller targets.'); INSERT INTO "Ogre" VALUES(101,1,'Der Hammer','',0,'Default.png',7,2,15,243.07,0,'Stephan','http://www.wanderinghorse.net',''); INSERT INTO "Ogre" VALUES(103,1,'Goliath','',0,'Default.png',7,3,10,91.83,0,'Stephan','http://www.wanderinghorse.net','Explodes as per chart at http://www.sjgames.com/ogre/articles/goliath.html.'); INSERT INTO "Ogre" VALUES(104,1,'Doppelsoldner','',1,'Doppelsoldner.png',9,3,20,348.97,0,'','',''); INSERT INTO "Ogre" VALUES(105,1,'Ninja','',1,'Ninja.png',7,4,10,183.92,0,'','','All attackers get -1 to-hit except Infantry in an overrun.'); INSERT INTO "Ogre" VALUES(106,1,'Charlie Bravo','',0,'Default.png',7,4,8,133.93,0,'Jon Glenn','cybrludite@yahoo.com','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)'); INSERT INTO "Ogre" VALUES(107,1,'iFencer','',0,'Fencer.png',8,3,16,238.77,0,'Imre A. Szabo','ias@sprintmail.com','An improved Fencer design.'); INSERT INTO "Ogre" VALUES(108,1,'Free Love','',0,'FreeLove.png',8,2,25,294.64,0,'Stephan','http://www.wanderinghorse.net',''); INSERT INTO "Ogre" VALUES(109,1,'Cruiser','',0,'Default.png',7,3,12,238.77,0,'Stephan','http://www.wanderinghorse.net',''); INSERT INTO "Ogre" VALUES(110,1,'Minuteman','',0,'Default.png',8,4,10,137.5,0,'Stephan','http://www.wanderinghorse.net','Infantry support unit, built to get men into The Thick quickly and safely.'); INSERT INTO "Ogre" VALUES(111,1,'Model II-T','The Minivan',0,'MarkII.png',6,3,10,80.36,0,'Stephan','http://www.wanderinghorse.net',''); INSERT INTO "Ogre" VALUES(112,1,'Willie Winkie','Winkie',0,'Doppelsoldner.png',8,4,10,508.92,0,'Dilletante','hotspur@rocketmail.com',''); INSERT INTO "Ogre" VALUES(113,1,'Marco','',0,'Flower-nolabel.png',7,3,12,116.32,0,'Stephan','http://qub.sourceforge.net/','A slightly-lighter, reworked Mark III.'); INSERT INTO "Ogre" VALUES(114,1,'Katana','Katana',0,'Default.png',7,4,8,150.89,0,'Francisco Cestero','fjcestero@uswest.net','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.'); INSERT INTO "Ogre" VALUES(116,1,'Lamer','',0,'MarkV-nolabel.png',8,3,18,221.93,0,'Stephan','http://qub.sourceforge.net/','Close-up slammer-hammer. Got problems with infantry walls? Let Lamer spell an end to them for you.'); INSERT INTO "Ogre" VALUES(117,1,'Mark IIIb - Cisco','',0,'MarkIIIb.png',7,3,12,186.73,0,'Cisco','',''); INSERT INTO "Ogre" VALUES(118,1,'Flower-S','',0,'Flower.png',8,3,12,169.13,'','Stephan Beal','http://wanderinghorse.net/home/stephan/','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.'); INSERT INTO "Ogre" VALUES(121,1,'Mark V-m','',0,'MarkV-nolabel.png',8,3,20,303.05,0,'George Leritte','gleritte@juno.com','This is a missile rack armed Mark V.'); INSERT INTO "Ogre" VALUES(122,1,'Mark III-m','',0,'MarkIII-nolabel.png',7,3,15,174.49,0,'George Leritte','gleritte@juno.com','This is a missile rack armed Mark III.'); INSERT INTO "Ogre" VALUES(126,1,'Wolf','',0,'Default.png',8,3,12,287.75,0,'Herb Diehr','edcomp@provide.net',''); INSERT INTO "Ogre" VALUES(127,1,'Trooper','',0,'MarkI-nolabel.png',5,4,5,73.21,0,'Doug Pappert','dpappert@kc.rr.com','A slightly beefed up MK 1.'); INSERT INTO "Ogre" VALUES(130,1,'Blackeye','Blackie',0,'MarkII-nolabel.png',6,3,10,93.36,'','Stephan Beal','http://wanderinghorse.net/home/stephan/',''); INSERT INTO "Ogre" VALUES(131,1,'Blossom','Spitball',0,'MarkII-nolabel.png',6,3,10,65.049286,'','Stephan Beal','http://wanderinghorse.net/home/stephan/','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.'); INSERT INTO "Ogre" VALUES(132,1,'Buggy','',0,'MarkII-nolabel.png',6,4,8,112.5,'','Stephan Beal','http://wanderinghorse.net/home/stephan/','A faster model of the Blackeye.'); INSERT INTO "Ogre" VALUES(133,1,'Buggy II','',0,'MarkIV-nolabel.png',8,4,12,203.57,'','Stephan Beal','http://wanderinghorse.net/home/stephan/',''); INSERT INTO "Ogre" VALUES(134,1,'Mark VII (Variant)','Behemoth',0,'Default.png',9,2,1,369.63,'','Scott "Clu" Nelson','snelson_@yahoo.com',''); INSERT INTO "Ogre" VALUES(136,1,'Bombard','Mad Bomber',0,'MarkIII.png',7,4,20,251.779,'','Scott "Clu" Nelson','snelson_@yahoo.com','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.'); INSERT INTO "Ogre" VALUES(137,1,'Cyclops','Red-Eye',0,'Default.png',7,4,10,408.92,0,'Scott Clu Nelson','snelson_@yahoo.com',''); INSERT INTO "Ogre" VALUES(138,1,'Mk VI Megascout','Dasher',0,'MarkVI-nolabel.png',9,6,10,482.13,0,'Drew Dreasler','bavarian@interaccess.com',''); INSERT INTO "Ogre" VALUES(140,1,'Mk VII WarWagon','WarOgre',0,'Default.png',7,3,25,378.05,0,'Bill J','BillJ77@Hotmail.com',''); INSERT INTO "Ogre" VALUES(141,1,'WarWagon Mk2','WW2',0,'Default.png',9,3,30,497.44,0,'','',''); INSERT INTO "Ogre" VALUES(142,1,'Fence Jumper','Jumper',0,'Fencer-nolabel.png',8,6,5,423.2,0,'Ross Winn','ross_winn@hotmail.com','This unit is used primarily as a support unit to other ogres. Especially usefuk in urban settings.'); INSERT INTO "Ogre" VALUES(144,1,'Mark1r/Vandal','Slasher',0,'Default.png',5,4,4,66.07,0,'Christian Okane','COKane8116@aol.com','A modified mark 1 intended for raiding behind enemy lines. Chewing up supply and repair units in hit and run raids.'); INSERT INTO "Ogre" VALUES(145,1,'Mark Ib','',0,'MarkI.png',5,3,5,55.87,0,'Michael Powers','mpowers@mad.scientist.com','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.'); INSERT INTO "Ogre" VALUES(147,1,'Mark If','',0,'MarkI.png',5,3,5,46.68,0,'Michael Powers','mpowers@mad.scientist.com','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.'); INSERT INTO "Ogre" VALUES(148,1,'Mark Ic','',0,'MarkI.png',5,3,5,55.1,0,'Michael Powers','mpowers@mad.scientist.com','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.'); INSERT INTO "Ogre" VALUES(149,1,'Mark IIc','',0,'MarkII.png',6,3,10,91.83,0,'Michael Powers','mpowers@mad.scientist.com','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.'); INSERT INTO "Ogre" VALUES(150,1,'Mark V-IYF','Inyoface',0,'MarkV-nolabel.png',8,3,20,217.34,0,'Stephan Beal','http://www.wanderinghorse.net','This Mark V variant is intentded to be covered by longer-ranged units, or to provide cover for them.'); INSERT INTO "Ogre" VALUES(151,1,'Oni Mk. II','Long Tom',0,'Spartan-nolabel.png',6,6,6,241.07,0,'','',''); INSERT INTO "Ogre" VALUES(152,1,'Fiver','',0,'MarkV-nolabel.png',8,3,20,241.07,0,'Stephan Beal','http://byoo.rootonfire.org','Refitted Mark V, with more blasting power, and fewer guns.'); INSERT INTO "Ogre" VALUES(153,1,'Journeyman PC','Jammy',0,'MarkIV-nolabel.png',8,4,10,122.32,0,'Stephan Beal','http://byoo.rootonfire.org','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.'); INSERT INTO "Ogre" VALUES(154,1,'Ninja/Vulcan','',0,'Ninja.png',7,4,11,188.39,'','Allen Smith','easmith@beatrice.rutgers.edu','-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.'); INSERT INTO "Ogre" VALUES(155,1,'Fast Assult Mk III','Dragster',0,'Default.png',7,6,5,206.24,0,'Daniel Gallant','adgallant@sympatico.ca',''); INSERT INTO "Ogre" VALUES(156,1,'Merkava III-B','',0,'MarkIIIb-nolabel.png',7,3,15,182.14,0,'Sean Bayan Schoonmaker','s_schoon@pacbell.net','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'); INSERT INTO "Ogre" VALUES(157,1,'Mk III Zunder','The Zunder',0,'MarkIII-nolabel.png',7,4,10,373.2,0,'Tom Zunder','tomz@writeme.com',''); INSERT INTO "Ogre" VALUES(158,1,'Mk V - ATDR "Piercer"','Piercer',0,'Default.png',8,3,20,215.05,0,'Scott Weber','ocr-geist@home.com','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.'); INSERT INTO "Ogre" VALUES(159,1,'Hunter-Killer','''Mike''',0,'Default.png',8,3,10,211.98,0,'S. Ventura','unknownguardsman@excite.com','This model is designed specifically to seek out and destroy heavy targets.'); INSERT INTO "Ogre" VALUES(160,1,'Mark III r','',0,'Default.png',7,3,15,149.23,0,'fizz','fizzmouse@yahoo.ca','Experimental APC variant. For deep penetration of special forces.'); INSERT INTO "Ogre" VALUES(162,1,'Steel Oni','',0,'Default.png',7,3,15,194.38,0,'Andrew Gelbman','wizard@internetwizards.com','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.'); INSERT INTO "Ogre" VALUES(163,1,'Golem','',0,'Default.png',7,3,15,196.68,0,'Andrew Gelbman','wizard@internetwizards.com','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.'); INSERT INTO "Ogre" VALUES(164,1,'Fencer (Cannonical)','',0,'Default.png',7,3,15,220.4,0,'Andrew Gelbman','wizard@internetwizards.com','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.'); INSERT INTO "Ogre" VALUES(165,1,'Steel Samurai','',0,'Default.png',8,4,15,301.78,0,'Andrew Gelbman','wizard@internetwizards.com','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'); INSERT INTO "Ogre" VALUES(167,1,'scroflagon','',0,'Fencer.png',8,4,15,249.99,0,'','',''); INSERT INTO "Ogre" VALUES(168,1,'scroflago','',0,'MarkVI.png',9,3,20,361.21,0,'','',''); INSERT INTO "Ogre" VALUES(169,1,'Longarm','',0,'MarkIII.png',7,3,14,182.14,0,'','',''); INSERT INTO "Ogre" VALUES(170,1,'MK III-H','',0,'MarkIII.png',7,3,14,186.73,0,'','',''); INSERT INTO "Ogre" VALUES(172,1,'Mark I-LR','Sitting Bull',0,'MarkI.png',5,3,6,52.04,0,'Kirk Hunt','kirkhunt@theriver.com','Late in the Last War, one city state was able to improve a "found OGRE" to this configuration.'); INSERT INTO "Ogre" VALUES(173,1,'Mark I-at','Cochise',0,'MarkI.png',5,3,6,61.22,0,'Kirk Hunt','kirkhunt@theriver.com','A brother to the Sitting Bull this improved configuration made for a potent combatant.'); INSERT INTO "Ogre" VALUES(174,1,'Mark I-as','Geronimo',0,'MarkI.png',5,3,6,61.22,0,'Kirk Hunt','kirkhunt@theriver.com','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.'); INSERT INTO "Ogre" VALUES(175,1,'PHALANX','stubby',0,'Default.png',7,3,4,135.46,0,'erick','siniypiva@hotmail.com',''); INSERT INTO "Ogre" VALUES(176,1,'MARK IBGF','BIGFOOT',0,'Default.png',5,4,25,232.14,0,'MARTIN EVANS','OGRE1994@WEBTV.COM',''); INSERT INTO "Ogre" VALUES(180,1,'Steel Demon (ONI)','ONI',0,'MarkIIIb-nolabel.png',7,3,15,194.38,0,'George Leritte','gleritte@juno.com','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.'); INSERT INTO "Ogre" VALUES(181,1,'Steel Warrior (SAMURAI)','SAMURAI',0,'MarkV-nolabel.png',8,3,20,270.91,0,'George Leritte','gleritte@juno.com','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.'); INSERT INTO "Ogre" VALUES(184,1,'COMBINE U-21','DESTROYER',0,'MarkIII.png',7,4,15,412.49,0,'JOE FLYNN','RAVENSTONEGAMES.COM','COMBINE''S TAKE ON THE GOLIATH. WITH ADDED PUNCH'); INSERT INTO "Ogre" VALUES(188,1,'MARK II-D','DEMOLISHER',0,'MarkII.png',7,3,15,260.96,0,'MARTIN EVANS','OGRE1994@WEBTV.COM',''); INSERT INTO "Ogre" VALUES(189,1,'MARK I-B','BEHEMOTH',0,'MarkI.png',5,4,5,233.03,0,'MARTIN EVANS','OGRE1994@WEBTV.COM',''); INSERT INTO "Ogre" VALUES(191,1,'s',NULL,0,'Default.png',7,0,0,NULL,0,NULL,NULL,NULL); INSERT INTO "Ogre" VALUES(193,1,'Grunt','',0,'MarkI.png',5,3,10,86.48,0,'Doug Pappert','dpappert@kc.rr.com',''); INSERT INTO "Ogre" VALUES(194,1,'Dagger','',0,'MarkII-nolabel.png',6,3,8,81.89,0,'','',''); INSERT INTO "Ogre" VALUES(195,1,'Dagger/b','',0,'MarkII-nolabel.png',6,3,8,74.23,0,'','',''); INSERT INTO "Ogre" VALUES(196,1,'Warhammer','',0,'MarkIII-nolabel.png',7,3,12,142.34,0,'','',''); INSERT INTO "Ogre" VALUES(197,1,'MARK-VIII','BOLO',0,'MarkVI.png',7,4,20,479.45,0,'FLYNN','RAVENSTONEGAMES','BOLO DARE I SAY MORE!'); INSERT INTO "Ogre" VALUES(201,1,'Dragon','False Ogre',0,'MarkIII.png',7,3,15,144.64,0,'Keith Johnson','keith@sjgames.com','Based off of the false Cybertank in GURPS Ogre, pg. 16'); INSERT INTO "Ogre" VALUES(203,1,'OM-Fencer','',0,'Fencer.png',8,3,16,224.99,0,'Imre A. Szabo','ias@sprintmail.com','The Ogre Minitures Fencer with 48 treads...'); INSERT INTO "Ogre" VALUES(204,1,'Mark VIa','',0,'MarkVI.png',9,3,24,417.85,0,'Imre A. Szabo','ias@sprintmail.com','Assault version of the Mark VI'); INSERT INTO "Ogre" VALUES(206,1,'mark IV B','',0,'MarkIV-nolabel.png',8,4,5,199.99,0,'','',''); INSERT INTO "Ogre" VALUES(208,1,'Mark IV A','',0,'MarkIV.png',8,4,15,271.42,0,'','',''); INSERT INTO "Ogre" VALUES(209,1,'Mark III A','',0,'MarkIII.png',7,3,15,163.77,0,'','',''); INSERT INTO "Ogre" VALUES(211,1,'Mark II A','',0,'MarkII.png',6,3,10,95.66,0,'','',''); INSERT INTO "Ogre" VALUES(212,1,'Mark V A','',0,'MarkV.png',8,3,20,270.91,0,'','',''); INSERT INTO "Ogre" VALUES(213,1,'Havok','Havok',0,'Default.png',9,4,20,423.2,0,'Nomad','','There were only four of these ogres produced, all by the Combine. They are very tough and optimized for striking at long range.'); INSERT INTO "Ogre" VALUES(214,1,'Harbinger','Harbinger',0,'MarkIV-nolabel.png',7,4,12,241.07,0,'Nomad','','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.'); INSERT INTO "Ogre" VALUES(215,1,'Mark IV-iiia Transport','Connestoga',0,'Default.png',8,4,15,204.46,0,'Adam C. Lipscomb','ACLipscomb@fc.net','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.'); INSERT INTO "Ogre" VALUES(216,1,'MK 2x1a','Pounder',0,'Spartan.png',6,2,10,77.01,0,'','',''); INSERT INTO "Ogre" VALUES(217,1,'Vagabond Class','the Poet',0,'Default.png',8,4,12,267.85,0,'george ibarra','nameless_vagabond@yahoo.com',''); INSERT INTO "Ogre" VALUES(219,1,'Mark IV C','',0,'MarkIV.png',8,4,15,270.53,0,'','',''); INSERT INTO "Ogre" VALUES(220,1,'Mark V C','',0,'MarkV.png',8,3,20,270.91,0,'','',''); INSERT INTO "Ogre" VALUES(221,1,'Fencer A','',0,'Fencer.png',8,3,15,207.39,0,'','',''); INSERT INTO "Ogre" VALUES(222,1,'Mk A1E3','the Gator',0,'Default.png',9,4,25,496.42,0,'will W.','',''); INSERT INTO "Ogre" VALUES(225,1,'Mark IV-R','Ravager',0,'Lancer-nolabel.png',8,4,15,254.46,0,'R.A.Gordon','None',''); INSERT INTO "Ogre" VALUES(226,1,'Guardian','',0,'MarkIII-nolabel.png',6,3,10,195.91,0,'R.A.Gordon','None',''); INSERT INTO "Ogre" VALUES(228,1,'Mk VIII mod a1','Longbow',0,'MarkV-nolabel.png',8,4,15,426.77,0,'Jim C','travmind@hotmail.com','A long range missile tosser. You can have my nukes when you pry them from my cold dead chassis!'); INSERT INTO "Ogre" VALUES(229,1,'Mk VII Mod a1','Quiver',0,'MarkIII-nolabel.png',6,4,10,296.42,0,'Jim C','travmind@hotmail.com','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.'); INSERT INTO "Ogre" VALUES(230,1,'Mk1-turtle','',0,'Default.png',5,4,20,233.03,0,'Mike','',''); INSERT INTO "Ogre" VALUES(231,1,'Reaper','',0,'Fencer-nolabel.png',9,2,20,190.17,0,'R.A.Gordon','None',''); INSERT INTO "Ogre" VALUES(232,1,'Vulcan Mk. I','Victors',0,'Default-nolabel.png',7,3,15,108.67,'','Stephen Blount','','Because, incredibly, there wasn''t one up already. There should probably be a "drone bay" much like an infantry bay.'); INSERT INTO "Ogre" VALUES(234,1,'Light Horse','',0,'Default.png',7,4,10,128.57,0,'Scott Nelson','snelson_@yahoo.com',''); INSERT INTO "Ogre" VALUES(235,1,'Behemoth','',0,'MarkIV-nolabel.png',9,2,15,338.16,'','Scott Nelson','snelson_@yahoo.com','I wrote a story around this monster.'); INSERT INTO "Ogre" VALUES(236,1,'Scorpion','',0,'Default.png',8,4,15,414.27,0,'Mike','',''); INSERT INTO "Ogre" VALUES(237,1,'Hunter-MkI','Hunter',0,'Doppelsoldner.png',8,3,10,165.3,0,'Vernon Burt','packrat@iol25.com','Just want a record sheet O can test the concept of an Ogre-Hunter on'); INSERT INTO "Ogre" VALUES(239,1,'Mk-4-FS-a','',0,'Default.png',8,4,12,533.02,0,'Mike','','Fire Support Ogre, ver 1'); INSERT INTO "Ogre" VALUES(241,1,'Mk-4-FS-b-4','',0,'Default.png',8,4,12,461.59,0,'Mike','','Fire Support Ogre, ver 2a'); INSERT INTO "Ogre" VALUES(243,1,'Mk-4-FS-C-5','',0,'Default.png',8,4,12,394.63,0,'Mike','','Fire Support Ogre, ver 3a'); INSERT INTO "Ogre" VALUES(245,1,'Mk-4-MS-a','',0,'Default.png',8,4,12,390.17,0,'Mike','','Missile Support Ogre, ver 1'); INSERT INTO "Ogre" VALUES(246,1,'Mk-4-CA','',0,'Default.png',8,4,15,450.88,0,'Mike','','City Assault Ogre, the Ogre smashes its way in and drops the infantry (''Dx3'') to hold the town until reinforcements can arrive - hopefully.'); INSERT INTO "Ogre" VALUES(247,1,'Grunt2','TG',0,'Default.png',7,4,2,36.61,0,'','',''); INSERT INTO "Ogre" VALUES(248,1,'Mk VI (IP)','Devastator',0,'MarkVI-nolabel.png',9,3,30,532.64,0,'Mike Raper','mraper@triad.rr.com','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.'); INSERT INTO "Ogre" VALUES(249,1,'M-2','Bradley',0,'MarkI-nolabel.png',6,4,10,127.68,0,'Mike Raper','mraper@triad.rr.com','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.'); INSERT INTO "Ogre" VALUES(250,1,'Stock','',0,'Default.png',7,3,15,163.77,0,'Chris Tate','agentbz@hotmail.com',''); INSERT INTO "Ogre" VALUES(251,1,'Lancer','',0,'Doppelsoldner.png',9,3,22,310.71,0,'','',''); INSERT INTO "Ogre" VALUES(252,1,'I (au)','Red-Back',0,'Default.png',5,4,5,92.85,0,'Brian','','Packed to the gills, this Ogre was quite a supprise.'); INSERT INTO "Ogre" VALUES(254,1,'Mk I (au)','Red-Back',0,'Default.png',5,4,5,92.85,0,'Brian','','Packed to the gills, this Ogre was quite a supprise.'); INSERT INTO "Ogre" VALUES(255,1,'MK3','Pitcher',0,'Default.png',7,4,12,272.31,0,'Avaheil D''otter','avaheildotter@aol.com','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'); INSERT INTO "Ogre" VALUES(257,1,'Titan 6','',0,'MarkVI.png',9,3,25,362.75,0,'','',''); INSERT INTO "Ogre" VALUES(260,1,'Chaos Ogre Mark I','Chaos Ogre',0,'MarkIV-nolabel.png',8,4,15,282.14,0,'Nick Kiest','SimnicK@aol.com',''); INSERT INTO "Ogre" VALUES(262,1,'Mk-1','Purple rain',0,'MarkII.png',6,2,20,141.96,0,'Krakatoa','finwe@zaz.com.br','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'); INSERT INTO "Ogre" VALUES(263,1,'anti-tank','',0,'MarkII.png',6,3,10,123.21,0,'Krakatoa','finwe@zaz.com.br',''); INSERT INTO "Ogre" VALUES(264,1,'Mark III Miniatures','',0,'MarkIII.png',7,3,16,168.36,0,'','',''); INSERT INTO "Ogre" VALUES(265,1,'Vulcan Mk. II','Super Vulcan',0,'MarkIII-nolabel.png',7,3,15,120.15,'','Maksim-Smelchak','Max200@Lanset.com','The Vulcan Mk. II 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 engineering 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 supported by armor battalions. These same Russian units drove the NAC invaders off of the "Continent" before the end of the war.'); INSERT INTO "Ogre" VALUES(266,1,'Tremendous','Atomic Horor',0,'MarkVI-nolabel.png',9,4,20,552.66,0,'Blade','',''); INSERT INTO "Ogre" VALUES(269,1,'Blackeye v2','Blackie 2',0,'MarkII-nolabel.png',6,3,10,101.78,'','Stephan Beal','http://wanderinghorse.net/home/stephan/','Intended primarily for light escort jobs.'); INSERT INTO "Ogre" VALUES(270,1,'Blackeye v2.1','Blackie 2.10',0,'MarkII-nolabel.png',6,3,12,111.73,'','Stephan Beal','http://wanderinghorse.net/home/stephan/','A slight variation on the Blackeye v2.0, with one more SB, no AP, and two fewer RktS-E.'); 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(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(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(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(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(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(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(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(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(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(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(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(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(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(241,104,4); INSERT INTO "GearToOgre" VALUES(241,8,1); INSERT INTO "GearToOgre" VALUES(241,7,9); 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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(136,2,4); INSERT INTO "GearToOgre" VALUES(136,7,10); INSERT INTO "GearToOgre" VALUES(136,3,10); INSERT INTO "GearToOgre" VALUES(136,107,1); INSERT INTO "GearToOgre" VALUES(136,106,2); INSERT INTO "GearToOgre" VALUES(131,2,2); INSERT INTO "GearToOgre" VALUES(131,7,4); INSERT INTO "GearToOgre" VALUES(131,100,8); INSERT INTO "GearToOgre" VALUES(131,102,4); INSERT INTO "GearToOgre" VALUES(134,1,4); INSERT INTO "GearToOgre" VALUES(134,2,12); INSERT INTO "GearToOgre" VALUES(134,4,32); INSERT INTO "GearToOgre" VALUES(134,6,4); INSERT INTO "GearToOgre" VALUES(134,7,24); 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(118,2,3); INSERT INTO "GearToOgre" VALUES(118,7,6); INSERT INTO "GearToOgre" VALUES(118,100,24); INSERT INTO "GearToOgre" VALUES(118,102,4); INSERT INTO "GearToOgre" VALUES(100,2,2); INSERT INTO "GearToOgre" VALUES(100,7,6); INSERT INTO "GearToOgre" VALUES(100,100,24); INSERT INTO "GearToOgre" VALUES(100,102,4); INSERT INTO "GearToOgre" VALUES(130,1,2); INSERT INTO "GearToOgre" VALUES(130,7,2); INSERT INTO "GearToOgre" VALUES(130,101,2); INSERT INTO "GearToOgre" VALUES(235,1,3); INSERT INTO "GearToOgre" VALUES(235,2,4); INSERT INTO "GearToOgre" VALUES(235,5,2); INSERT INTO "GearToOgre" VALUES(235,4,4); INSERT INTO "GearToOgre" VALUES(235,6,1); INSERT INTO "GearToOgre" VALUES(235,7,4); INSERT INTO "GearToOgre" VALUES(235,113,4); INSERT INTO "GearToOgre" VALUES(235,3,4); INSERT INTO "GearToOgre" VALUES(235,104,2); INSERT INTO "GearToOgre" VALUES(235,112,3); INSERT INTO "GearToOgre" VALUES(235,111,2); INSERT INTO "GearToOgre" VALUES(269,1,1); INSERT INTO "GearToOgre" VALUES(269,2,1); INSERT INTO "GearToOgre" VALUES(269,7,2); INSERT INTO "GearToOgre" VALUES(269,101,6); INSERT INTO "GearToOgre" VALUES(270,1,1); INSERT INTO "GearToOgre" VALUES(270,2,2); INSERT INTO "GearToOgre" VALUES(270,101,4); INSERT INTO "GearToOgre" VALUES(265,2,2); INSERT INTO "GearToOgre" VALUES(265,7,8); INSERT INTO "GearToOgre" VALUES(265,8,1); INSERT INTO "GearToOgre" VALUES(265,109,2); INSERT INTO "GearToOgre" VALUES(265,111,2); INSERT INTO "GearToOgre" VALUES(232,2,2); INSERT INTO "GearToOgre" VALUES(232,7,6); INSERT INTO "GearToOgre" VALUES(232,109,2); 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(132,1,2); INSERT INTO "GearToOgre" VALUES(132,7,2); INSERT INTO "GearToOgre" VALUES(132,101,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;