SQLite format 3@ e_e';indexsqlite_autoindex_Gear_1GearP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)G]tableGEV_UnitsGEV_UnitsCREATE TABLE GEV_Units ( ID integer primary key autoincrement, Name varchar(50) NOT NULL default '', ShortName varchar(20) default NULL, Category varchar(50) default 'Armor', Icon varchar(100) default 'blank', ATT integer default NULL, RNG integer default NULL, DEF integer default NULL, MP1 integer default NULL, MP2 integer default '0', Ciscos double(4,1) default '0.0', IsOfficial tinyint(4) default '0', Active tinyint(4) NOT NULL default '1', SortOrder double(16,4) default '0.0000', D     OgreGearq9t]e9MRocket Salvo, ExternalRktS-EFired just as external missiles. (d9 ?񙙙Rocket Salvo, InternalRktS-IFired just as internal missiles - requires a Rocket Salvo Rack (aoTow GearTowGearUse per the rules in the Ogre Reinforcements Pack`1cAnti-Personel GunsAPUsable against Infantry and D0 targets onlya'cMissile RacksMsl-RackEach one destroyed also destroys one Msl-I. 81Missiles, ExternalMsl-E  V1IMissiles, InternalMsl-ICannot be attacked separately. (51Tertiary BatteriesTB63Secondary BatteriesSB1)Main BatteriesMB.'oe U""bQ:l~-pH3Anti-Personnel Guns1Long-Range AP Gunsq%Infantry Bayp Cargo Bayo%Suicide Bombn+Engineering Armm;Cruise Missile Launcherk=Cruise Missile, Internalj Long Tomi Howitzerh+Medium Howitzerg/Rocket Salvo Rackf9Rocket Salvo, Externale9Rocket Salvo, Internald Tow GearAnti-Personel Guns'Missile Racks1Missiles, External1Missiles, Internal1Tertiary Batteries3Secondary Batteries)Main Batteries' dd7';indexsqlite_autoindex_Gear_1GearG]tableGEV_UnitsGEV_UnitsCREATE TABLE GEV_Units ( ID integer primary key autoincrement, Name varchar(50) NOT NULL default '', ShortName varchar(20) default NULL, Category varchar(50) default 'Armor', Icon varchar(100) default 'blank', ATT integer default NULL, RNG integer default NULL, DEF integer default NULL, MP1 integer default NULL, MP2 integer default '0', Ciscos double(4,1) default '0.0', IsOfficial tinyint(4) default '0', Active tinyint(4) NOT NULL default '1', SortOrder double(16,4) default '0.0000', Notes varchar(255) default NULL )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) $$YtableGearGearCREATE TABLE Gear ( ID integer primary KEY autoincrement DEFAULT NULL, SortOrder float(6,4) default '0.0000', Name varchar(50) NOT NULL default '', ShortName varchar(50) default NULL, Attack tinyint(1) default '0', Range tinyint(1) default '0', Defense tinyint(1) default '0', Ciscos tinyint(2) default '0', IsOfficial tinyint(1) default '0', Active tinyint(1) default '1', Notes text DEFAULT '', -- The following are hints for layout of record forms CountPerRow tinyint(1) default '15', -- number of items per row CountGroupBy tinyint(1) default '3', -- group items in sets of this many. e.g 3 = ooo ooo ooo ... CountDefault tinyint(1) default '0', -- Default count for input field CountHintMin tinyint(1) default '0', -- Min count for input field CountHintMax tinyint(1) default '10', -- Max count for input field CountHintDefault tinyint(1) default '0', -- ??? CountHintStep tinyint(1) default '1', -- ??? UNIQUE (Name) ) ';indexsqlite_autoindex_Gear_1GearW!!ytableGearToOgreGearToOgre CREATE TABLE GearToOgre ( Ogre_ID int(10) NOT NULL default '0', Gear_ID int(10) NOT NULL default '0', Count int(10) default '0', UNIQUE(Ogre_ID,Gear_ID) ON CONFLICT REPLACE )3G!indexsqlite_autoindex_GearToOgre_1GearToOgre );indexsqlite_autoindex_Ogre_1Ogre s 5tableOgreIconsOgreIconsCREATE TABLE OgreIcons( Icon text, UNIQUE(Icon) ON CONFLICT IGNORE )1 Eindexsqlite_autoindex_OgreIcons_1OgreIconsH!!Wviewv_overviewv_overviewCREATE VIEW v_overview AS SELECT o.ID, o.Name, o.MP, (o.TUMP * o.MP) as 'Treads', o.Ciscos, (o.Ciscos / 10.0) as 'Cisco Armor Value', (o.Ciscos * 0.6) as 'Approx SJG VP' FROM Ogre o WHERE -- IsOfficial!=0 AND Active != 0Fypg^ULC:1( }tkbYPG>5,#xof]TKB90' \r[rZqYqXqWqdVqfUppTpgSpdRpeQpPpOp NpMpLpKopJoIoHlGleFnEnDnCneBmAmk@mj?lh>nm=np<k;k:k9j8j7j6j5i4i3i2i1i0i/h .h-h,h+h*gn)('&%$#"! ghffff      eBr@>U<:K8}5/4\ApxX`h8@HP (0xhp`X8P@H (0xhp`X0@8HP (edcbtat`t_t^r]r\r[qZqYqXqdWqfVppUpgTpdSpeRpQpPpOpNpMpLopKoJoIlHleGnFnEnDneCmBmkAmj@lh?nm>np=k<k;k:j9j8j7j6i5i4i3i2i1i0h/h.h-h,h+gn*)('&%$#"! ghffff 9 ? C = h; !7 6np=WdcWhzt]nA^2mGK`.~3x0u1jdW!S=4 -"$%")('*+,-/uEq#e $Mk-4-FS-a Marcoq $ }tableciscosciscosCREATE TABLE ciscos ( count integer default 0, desc text default '?', Ciscos integer default 0 )++ktablettr_Ogre_Ciscosttr_Ogre_CiscosCREATE TABLE ttr_Ogre_Ciscos ( Ogre_ID integer default 0, UNIQUE(Ogre_ID) ON CONFLICT REPLACE )=Q+indexsqlite_autoindex_ttr_Ogre_Ciscos_1ttr_Ogre_Ciscos n`H8"zeXB4 #Spartan.png3Spartan-nolabel.png Ninja.png/Ninja-nolabel.png MarkV.png/MarkV-nolabel.png !MarkVI.png1MarkVI-nolabel.png !MarkIV.png1MarkIV-nolabel.png MarkI.png/MarkI-nolabel.png !MarkII.png1MarkII-nolabel.png%MarkIIIx.png5MarkIIIx-nolabel.png #MarkIII.png3MarkIII-nolabel.png%MarkIIIb.png 5MarkIIIb-nolabel.png !Lancer.png 1Lancer-nolabel.png %FreeLove.png 5FreeLove-nolabel.png !Flower.png1Flower-nolabel.png !Fencer.png1Fencer-nolabel.png/Doppelsoldner.png?Doppelsoldner-nolabel.png #Default.png3Default-nolabel.png ~gX?.PBuf+#Spartan.png 3Spartan-nolabel.png Ninja.png/Ninja-nolabel.png MarkV.png/MarkV-nolabel.png!MarkVI.png1MarkVI-nolabel.png!MarkIV.png1MarkIV-nolabel.png MarkI.png/MarkI-nolabel.png!MarkII.png1MarkII-nolabel.png%MarkIIIx.png5MarkIIIx-nolabel.png#MarkIII.png3MarkIII-nolabel.png%MarkIIIb.png5MarkIIIb-nolabel.png !Lancer.png 1Lancer-nolabel.png %FreeLove.png 5FreeLove-nolabel.png !Flower.png1Flower-nolabel.png!Fencer.png1Fencer-nolabel.png/Doppelsoldner.png?Doppelsoldner-nolabel.png#Default.png3Default-nolabel.png Y6wY3#!-{2009-08-04 20:44:25Mk-1Purple rainMarkII.png@aQKrakatoafinwe@zaz.com.brThis 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 buildw3/!1!+ 2009-08-04 20:44:25Chaos Ogre Mark IChaos OgreMarkIV-nolabel.png@q=p Nick KiestSimnicK@aol.comB3 ! 2009-08-04 20:44:25Titan 6MarkVI.png @vF3#+7C2009-08-04 20:44:25MK3PitcherDefault.png @q\)Avaheil D'otteravaheildotter@aol.comThe 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    ^)+qtriggertr_Ogre_Ciscosttr_Ogre_CiscosCREATE TRIGGER tr_Ogre_Ciscos AFTER INSERT ON ttr_Ogre_Ciscos BEGIN DELETE FROM ciscos; INSERT INTO ciscos SELECT go.Count, g.ShortName, (go.Count*g.Ciscos) FROM Gear g, GearToOgre go WHERE go.Ogre_ID=NEW.Ogre_ID AND g.ID=go.Gear_ID ORDER BY g.SortOrder; UPDATE Ogre SET Ciscos=( SELECT round( 5.357 * (sum(v.Ciscos)+(2*(o.TUMP*o.MP))) / (10 - o.MP) + o.CiscosFudge, 2 ) FROM ciscos AS v, Ogre AS o WHERE o.ID=NEW.Ogre_ID) WHERE ID=NEW.Ogre_ID; DELETE FROM ciscos; DELETE FROM ttr_Ogre_Ciscos; END e..E]1I/Missiles, InternalMsl-ICannot be attacked separately. (]e9MRocket Salvo, ExternalRktS-EFired just as external missiles. (d9 ?񙙙Rocket Salvo, InternalRktS-IFired just as internal missiles - requires a Rocket Salvo Rack (aoTow GearTowGearUse per the rules in the Ogre Reinforcements Packa3cAnti-Personnel GunsAPUsable against Infantry and D0 targets onlya'cMissile RacksMsl-RackEach one destroyed also destroys one Msl-I. 81Missiles, ExternalMsl-E  51Tertiary BatteriesTB63Secondary BatteriesSB1)Main BatteriesMB.' AhyADo3Cargo BayCargoHolds one armor unit or three infantry squads. Destruction destroys cargo. Use normal riding rules except that infantry cannot attack from the bay.!n%aSuicide BombHariKari<Cannot be attacked separately. Explodes as per chart at http://www.sjgames.com/ogre/articles/goliath.html.2m+nEngineering ArmEA;k;dCruise Missile LauncherCML<Zj=IeCruise Missile, InternalCMI(Optional Rule: move _or_ fire.KiILong TomLTOM xOptional Rule: move _or_ fire.JhIHowitzerHWZdOptional Rule: move _or_ fire. Tg+IMedium HowitzerMedHWZAOptional Rule: move _or_ fire.  f/1?333333Rocket Salvo RackRktS-RackFires RktS-I's, each sold separately. Each one destroyed also destroys one RktS-I.   bq1cLong-Range AP GunsLRAPUsable against Infantry and D0 targets onlysp% Infantry BayInfBayHolds 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.  PT!e;Pz 3  2009-08-04 20:44:25NinjaNinja.png @fp =All attackers get -1 to-hit except Infantry in an overrun.<3#2009-08-04 20:44:25New OgreDefault.png@3  2009-08-04 20:44:25Mark IMarkI.png@GB3 ! 2009-08-04 20:44:25Mark IIMarkII.png @XQD3 # 2009-08-04 20:44:25Mark IIIMarkIII.png@dx =qA3 ! 2009-08-04 20:44:25FencerFencer.png@kB3 ! 2009-08-04 20:44:25Mark IVMarkIV.png@pQ@3  2009-08-04 20:44:25Mark VMarkV.png@p\(B3 ! 2009-08-04 20:44:25Mark VIMarkVI.png @vp =3 F3 % 2009-08-04 20:44:25Mark IIIbMarkIIIb.png@i33333O 3' / 2009-08-04 20:44:25DoppelsoldnerDoppelsoldner.png @uυQt3  2009-08-04 20:44:25NinjaNinja.png All attackers get -1 to-hit except Infantry in an overrun. 8i8%wI".FXc| 3CObmw`9Copy of Copy of Mark I)Copy of Mark I Fencer-B-Copy of MK III-T $Copyme'Blackeye v2.1#Blackeye v2 /Chaos Ogre Mark IMK3 Blackeye Blossom Bombard Buggy Buggy II%COMBINE U-21'Charlie Bravoj Cruiserm Cyclops Dagger Dagger/b!Der Hammere'Doppelsoldner Dragon1Fast Assult Mk III%Fence Jumper Fencer3Fencer (Cannonical) Fencer AFiredance Fiver Flowerd Flower-Sv Free Lovel Golem Goliath Grunt Grunt2 GuardianHarbinger Havok'Hunter-Killer!Hunter-MkI I (au)'Journeyman PC Katanar Lamert Lancer#Light Horse LongarmM-2 MARK I-BMARK IBGFMARK II-DMARK-VIII MK 2x1a MK III-H /_jy- ,;JYu%8FPSfF)Mark VI (2008) +Mark III-SGB-A03Mark III Miniatures Mk-1Mk I (au) Mark IMark I-LRMark I-asMark I-at Mark IIMark II A Mark III!Mark III A!Mark III r!Mark III-mz Mark IIIb/Mark IIIb - Ciscou Mark IIc Mark IVMark IV AMark IV CMark IV-R9Mark IV-iiia Transport Mark Ib Mark Ic Mark If Mark V Mark V A Mark V C!Mark V-IYF Mark V-my Mark VI1Mark VII (Variant) Mark VIa'Mark1r/Vandal'Merkava III-B Minutemann Mk A1E3'Mk III Zunder7Mk V - ATDR "Piercer"!Mk VI (IP)+Mk VI Megascout'Mk VII Mod a1+Mk VII WarWagon)Mk VIII mod a1 Mk-4-CA#Mk-4-FS-C-5 QQWW39!#-/?2009-08-04 20:44:25Mark IV-iiia TransportConnestogaDefault.png@iQAdam C. LipscombACLipscomb@fc.netThis 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.5,#xof]TKB90' \r[rZqYqXqWqdVqfUppTpgSpdRpeQpPpOp NpMpLpKopJoIoHlGleFnEnDnCneBmAmk@mj?lh>nm=np<k;k:k9j8j7j6j5i4i3i2i1i0i/h .h-h,h+h gn)('&%$#"! ghffff      eeegeh Qypg^ULC:1( uj_TI>3(xmbWLA6+   -f,+* )d (h'&%$#"! dfp        i~ }e|{zey~gx~ w~v~u~trszrzqzpzoznymylykyjy iuhugufuedcbat`t_t ^t]r a'/7?GOW_gow!*3<ENW`ir{'/7?GOW_gow o n m l k h%&  $ '  ()bcde j d f g e ] ^ _ ` a bnL! gh#"d=d>dd?df@eeegehffffh+h,h-h.h/i0i1i3i2i4i5j9j6j8j7k<k;k:kJlHleGlh?mBmj@mkAnFnEnDneCnm> U"*2:BJRZbjrz &.6>FNV^fnv~$.8BLV`jt~oIoJopKpLpMpQpNpOpPpdSpeRpgTppUqZqXqYqdWqfVrtr]r\r[tat^t`t_ufuguhuivAvBvdCvfDynymylykyjzszrzqzpzo~u~v~w~x~gy|{ez   e   d f 7 8 e9            j k       i    K|qf[PE:/$ti^SH=2'wlaVK@5* }|q{zyxwvutsrqphongmlkjihgfedcba`_^]\[ZY XW VUT SRQPOoNpMLKJIHGFEoDmCBA@?>=<;h:9876543!pe  EQQ[eoy#-7AKU_ir{$.8BLV`jt~               p         d f   ~e}  h    d f p e~ } | { 0 1 2 3 4 m5 o6             h     m o |Iqf[PE:/$ti^SH=2'wlaVK@5* KJkIHGFE DCiBpA@?>n=m<;:9876543210/.-,+e*)('m&h%f$d#h"!  hn  g(     p  f 7     q~ G::DNXblv  *4>HR\fpz$.8BLV`jt~        o p                               g  h            q   q      T U V W X    n N|qf[PE:/$ti^SH=2'wlaVK@5* eq         ~}n|q{zyxwvputospreqponmlkji hg fed cba`_^]\ [ZYXWVUTSRQPONML L:DNXblv0&  *4>HR\fpz$.8BLV`jt~ p i h f d " h# d$ f% h& m'      ( ) * e+ , - . / 0 3 1 2 4 5 8 6 7 9 : ; < m= n> ? @ A pB F G H I K L N M O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g <llw'2=HS^it$/:EP[fq|aVK@5* gofedc ba`q_ ^]\[ZfYdXWV ohq !"#($%q&('q()*q+,p-o.q/e01234q56789:g;i<=>?@nApBqCDEFGHIJKLM NOPQRSTU F  *bvl4>HR\fpz$.8BLV`jt~ i    E D iC m/ . -FoR0 pQNhPN ON qN<M2L K qJ I H q    o p q     e q    q    g i    E D iC   h   g          p  f      n    p q       .}} "-8CNYdoz *5@KValwti=2'5m4 3210/m.-, o+ m* ) ( !e $ e# VWXYdZf[\]^_ `qabc defgohijklmno pqrM             z{ | }k~jdf    <v v vd vfd d M\fpz$.8BLV`jt~RH>4*  lvbXND:0&      w v u t s r q p e\ [ Z Y qG F E  o,  m+  *  )  ( ez y x  e$  #  "  !  O  N  M             d f      q       o             S  R  Q  P M|qf[PE:/$|qf[PE:/%ukaWMC9/%rqpo n m  l k j h g f e d b a ` _  ^ ] \e[ZYXWVUTS R Q P O N M LnKJqIHGqFEDvfCvdBvAv@df?dd>d=d!e 9e876o5m4 3210/m.-, o+ m* ) ( $ e# " ! e 9  *4>HR\fpz$.8BLV`jt~ i j k m l n o p q er ot ps u pv w x y z { n} q| ~                        e q    h o q    q FotableOgreOgre CREATE TABLE Ogre( -- Ogre Ciscos cost: -- Cost := 2 * Treads -- Cost += (Cost of each Gear item) -- FinalCost := 5.357 * Cost / (10 - Ogre.MP) -- -- Cisco/SJG Conversions: -- Ciscos / 10 == Cisco Armor Unit Equivalence -- Ciscos * 0.6 = Approx SJG VP cost ID integer primary KEY autoincrement DEFAULT NULL, Active INT DEFAULT 1, LastUpdated valchar(18) DEFAULT current_timestamp, Name varchar(50) NOT NULL default '', Nickname varchar(50) default NULL, IsOfficial tinyint(1) default '0', Icon varchar(100) default 'Default.png', SizeClass integer default 7, MP integer default '0', TUMP integer default '0', Ciscos int(11) default '0', CiscosFudge int(11) default '0', Submitter varchar(100) default NULL, SubmitterInfo varchar(100) default NULL, Notes text, UNIQUE (Name) ) m4n3 #G!2009-08-04 20:44:25MinutemanDefault.png @a0Stephanhttp://www.wanderinghorse.netInfantry support unit, built to get men into The Thick quickly and safely.to3!#!G 2009-08-04 20:44:25Model II-TThe MinivanMarkII.png @T =pStephanhttp://www.wanderinghorse.netup3'/!9 2009-08-04 20:44:25Willie WinkieWinkieDoppelsoldner.png @θQDilletantehotspur@rocketmail.comq3 1CY2009-08-04 20:44:25MarcoFlower-nolabel.png @]zGStephanhttp://qub.sourceforge.net/A slightly-lighter, reworked Mark III. |qf[PE:/$p i h f d p~e}|{zeyxwvuts llVnIB3 1 2009-08-04 20:44:25DaggerMarkII-nolabel.png@Tx\)KC3 1 2009-08-04 20:44:25Dagger/bMarkII-nolabel.png@RQMD3 3 2009-08-04 20:44:25WarhammerMarkIII-nolabel.png @aG{qE3!+72009-08-04 20:44:25MARK-VIIIBOLOMarkVI.png@}33333FLYNNRAVENSTONEGAMESBOLO DARE I SAY MORE! I3!#'/y2009-08-04 20:44:25DragonFalse OgreMarkIII.png@bzGKeith Johnsonkeith@sjgames.comBased off of the false Cybertank in GURPS Ogre, pg. 16K3 !'1c2009-08-04 20:44:25OM-FencerFencer.png@lzHImre A. Szaboias@sprintmail.comThe Ogre Minitures Fencer with 48 treads... Iwx-Ir1 %[ BlackeyeBlackieMarkII-nolabel.png @WW =pStephan Bealhttp://wanderinghorse.net/home/stephan/n /%1ATrooperMarkI-nolabel.png@RMp =Doug Pappertdpappert@kc.rr.comA slightly beefed up MK 1.I #!1 ~WolfDefault.png @qHerb Diehredcomp@provide.net! 3)/YzMark III-mMarkIII-nolabel.png@eϮzHGeorge Lerittegleritte@juno.comThis is a missile rack armed Mark III.z /)/UyMark V-mMarkV-nolabel.png@rGeorge Lerittegleritte@juno.comThis is a missile rack armed Mark V.D ! %[OvFlower-SFlower.png@fStephan Bealhttp://wanderinghorse.net/home/stephan/A Support version of the Flower. More guns at the cost of speed. The Flower-S excels at protecting other Ogres from close-up attacks. Used in conjunction with a missile-based Ogre, the FLower can make a great defense partner.@/ % uMark IIIb - CiscoMarkIIIb.png @gW\(Cisco ZZZ%#-1 CyclopsRed-EyeDefault.png @yQScott Clu Nelsonsnelson_@yahoo.comy$!# 11ABombardMad BomberMarkIII.png@wQScott "Clu" Nelsonsnelson_@yahoo.comA 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.g#1# 11 Mark VII (Variant)BehemothDefault.png @wzGScott "Clu" Nelsonsnelson_@yahoo.comk" 1 %[ Buggy IIMarkIV-nolabel.png @ir=p Stephan Bealhttp://wanderinghorse.net/home/stephan/! 1 %[KBuggyMarkII-nolabel.png@\ Stephan Bealhttp://wanderinghorse.net/home/stephan/A faster model of the Blackeye.k 1 %[}BlossomSpitballMarkII-nolabel.png @[*G{Stephan Bealhttp://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. `86`S*'#+1sMark1r/VandalSlasherDefault.png@PzGChristian OkaneCOKane8116@aol.comA modified mark 1 intended for raiding behind enemy lines. Chewing up supply and repair units in hit and run raids.D)%17QFence JumperJumperFencer-nolabel.png@zs33333Ross Winnross_winn@hotmail.comThis unit is used primarily as a support unit to other ogres. Especially usefuk in urban settings.9(%# WarWagon Mk2WW2Default.png @ =pY'+#3 Mk VII WarWagonWarOgreDefault.png@wBill JBillJ77@Hotmail.comk&+1'= Mk VI MegascoutDasherMarkVI-nolabel.png  @~"zGDrew Dreaslerbavarian@interaccess.com oo<, )?WMark IfMarkI.png@GW =pMichael Powersmpowers@mad.scientist.comAn 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.O+ )?}Mark IbMarkI.png@K\(Michael Powersmpowers@mad.scientist.comAn 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. VoVD0!3 Oni Mk. IILong TomSpartan-nolabel.png@n"=p P/!/%GUMark V-IYFInyofaceMarkV-nolabel.png@k*G{Stephan Bealhttp://www.wanderinghorse.netThis Mark V variant is intentded to be covered by longer-ranged units, or to provide cover for them.. !)?Mark IIcMarkII.png @VQMichael Powersmpowers@mad.scientist.comThis 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.y- )?QMark IcMarkI.png@KMichael Powersmpowers@mad.scientist.comAnother 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. 1g1h41#)9 Fast Assult Mk IIIDragsterDefault.png@iǮzHDaniel Gallantadgallant@sympatico.ca3%  #EeNinja/VulcanNinja.png @gzGAllen Smitheasmith@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.?2'1%A7Journeyman PCJammyMarkIV-nolabel.png @^zGStephan Bealhttp://byoo.rootonfire.orgThe 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.1 /%AFiverMarkV-nolabel.png@n"=p Stephan Bealhttp://byoo.rootonfire.orgRefitted Mark V, with more blasting power, and fewer guns. kM 9! #1Mark III rDefault.png@b\(fizzfizzmouse@yahoo.caExperimental APC variant. For deep penetration of special forces.-8'#!C!Hunter-Killer'Mike'Default.png @j\(S. Venturaunknownguardsman@excite.comThis model is designed specifically to seek out and destroy heavy targets.n77##1!Mk V - ATDR "Piercer"PiercerDefault.png@jᙙScott Weberocr-geist@home.comDesOc6'!3!- Mk III ZunderThe ZunderMarkIII-nolabel.png @wS33333Tom Zundertomz@writeme.com-5' 595Merkava III-BMarkIIIb-nolabel.png@fzGSean Bayan Schoonmakers_schoon@pacbell.netFunctionally 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 warfareigned 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. `K<3 #)AWFencer (Cannonical)Default.png@kAndrew Gelbmanwizard@internetwizards.comThe 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.%; #)A'GolemDefault.png@h\(Andrew Gelbmanwizard@internetwizards.comThe 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.u: #)A?Steel OniDefault.png@hL(\Andrew Gelbmanwizard@internetwizards.comThis 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. U!d-C79Mark I-atCochiseMarkI.png@N(\Kirk Huntkirkhunt@theriver.comA brother to the Sitting Bull this improved configuration made for a potent combatant.:B%7IMark I-LRSitting BullMarkI.png@JQKirk Huntkirkhunt@theriver.comLate in the Last War, one city state was able to improve a "found OGRE" to this configuration.2A # MK III-HMarkIII.png@gW\(1@ # LongarmMarkIII.png@fzG2? ! scroflagoMarkVI.png @v\(3>! ! scroflagonFencer.png@o?zH =' #)AeSteel SamuraiDefault.png@rzGAndrew Gelbmanwizard@internetwizards.comThe 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 g G/5)/_Steel Demon (ONI)ONIMarkIIIb-nolabel.png@hL(\George Lerittegleritte@juno.comThe 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.XF#%1 MARK IBGFBIGFOOTDefault.png@mzGMARTIN EVANSOGRE1994@WEBTV.COMQE#7 PHALANXstubbyDefault.png@`Qericksiniypiva@hotmail.comCD7cMark I-asGeronimoMarkI.png@N(\Kirk Huntkirkhunt@theriver.comLike "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. "Z4"_Q!+7MARK-VIIIBOLOMarkVI.png@}33333FLYNNRAVENSTONEGAMESBOLO DARE I SAY MORE!;P 3 WarhammerMarkIII-nolabel.png @aG{9O 1 Dagger/bMarkII-nolabel.png@RQ7N 1 DaggerMarkII-nolabel.png@Tx\)KM %1 GruntMarkI.png @UQDoug Pappertdpappert@kc.rr.com#L#sDefault.pngVK%1 MARK I-BBEHEMOTHMarkI.png@m \)MARTIN EVANSOGRE1994@WEBTV.COMZJ!!%1 MARK II-DDEMOLISHERMarkII.png@pO\(MARTIN EVANSOGRE1994@WEBTV.COM I%#3kCOMBINE U-21DESTROYERMarkIII.png@y =pJOE FLYNNRAVENSTONEGAMES.COMCOMBINE'S TAKE ON THE GOLIATH. WITH ADDED PUNCHH;/)/]Steel Warrior (SAMURAI)SAMURAIMarkV-nolabel.png@p\(George Lerittegleritte@juno.comThe 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. oEu9Z# HavokHavokDefault.png @zs33333NomadThere were only four of these ogres produced, all by the Combine. They are very tough and optimized for striking at long range.0Y  Mark V AMarkV.png@p\(2X ! Mark II AMarkII.png @W=p 4W! # Mark III AMarkIII.png@dx =q2V ! Mark IV AMarkIV.png@pQ:U 1 mark IV BMarkIV-nolabel.png@hzHnT !'1IMark VIaMarkVI.png @zImre A. Szaboias@sprintmail.comAssault version of the Mark VI|S !'1cOM-FencerFencer.png@lzHImre A. Szaboias@sprintmail.comThe Ogre Minitures Fencer with 48 treads...R!#'/yDragonFalse OgreMarkIII.png@bzGKeith Johnsonkeith@sjgames.comBased off of the false Cybertank in GURPS Ogre, pg. 16 NQN1a ! Fencer AFencer.png@izG0`  Mark V CMarkV.png@p\(2_ ! Mark IV CMarkIV.png@pzGh^)#'C Vagabond Classthe PoetDefault.png @pgeorge ibarranameless_vagabond@yahoo.com8]# MK 2x1aPounderSpartan.png @S@ =qE\9!#-/?Mark IV-iiia TransportConnestogaDefault.png@iQAdam C. LipscombACLipscomb@fc.netThis 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.*[1 OHarbingerHarbingerMarkIV-nolabel.png @n"=p NomadSpeed 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. pl"]pEh 1! ReaperFencer-nolabel.png @gp =R.A.GordonNone8g! # Mk1-turtleDefault.png@m \)Mikeif'35!Mk VII Mod a1QuiverMarkIII-nolabel.png @rQJim Ctravmind@hotmail.comA 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.Be)/5SMk VIII mod a1LongbowMarkV-nolabel.png@zQJim Ctravmind@hotmail.comA long range missile tosser. You can have my nukes when you pry them from my cold dead chassis!Hd 3! GuardianMarkIII-nolabel.png @h}QR.A.GordonNoneOc1! Mark IV-RRavagerLancer-nolabel.png@oθQR.A.GordonNoneAb# Mk A1E3the GatorDefault.png @Qwill W. @79@Rp# # ?Mk-4-FS-C-5Default.png @xzGMikeFire Support Ogre, ver 3aRo# # ?Mk-4-FS-b-4Default.png @|p =MikeFire Support Ogre, ver 2aOn # =Mk-4-FS-aDefault.png @(\MikeFire Support Ogre, ver 1!m!/#/Hunter-MkIHunterDoppelsoldner.png @dVernon Burtpackrat@iol25.comJust want a record sheet O can test the concept of an Ogre-Hunter on6l # ScorpionDefault.png@yQMikeJk/ !A]FiredanceSplatMarkI-nolabel.png@q =pMike Duganmikenmenchie@sbcglobal.netFiredance was envisioned as a platfrom to kill vehicles, not to take on heavier units like other OGREs. Sj# #%1 Light HorseDefault.png @`=p Scott Nelsonsnelson_@yahoo.comFi%3 ) sVulcan Mk. IVictorsDefault-nolabel.png@[*G{Stephen BlountBecause, incredibly, there wasn't one up already. There should probably be a "drone bay" much like an infantry bay. --t!!1!3OMk VI (IP)DevastatorMarkVI-nolabel.png @QMike Rapermraper@triad.rr.comBuilt 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.2s# Grunt2TGDefault.png@BNzGAr # #Mk-4-CADefault.png@|.zGMikeCity Assault Ogre, the Ogre smashes its way in and drops the infantry ('Dx3') to hold the town until reinforcements can arrive - hopefully.Rq # CMk-4-MS-aDefault.png @xbQMikeMissile Support Ogre, ver 1 u'|ty# uMk I (au)Red-BackDefault.png@W6fffffBrianPacked to the gills, this Ogre was quite a supprise.qx# uI (au)Red-BackDefault.png@W6fffffBrianPacked to the gills, this Ogre was quite a supprise.6w / LancerDoppelsoldner.png @sk\(Lv #!3 StockDefault.png@dx =qChris Tateagentbz@hotmail.comu/!3mM-2BradleyMarkI-nolabel.png @_QMike Rapermraper@triad.rr.comDesigned 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. IY=3 # Mark III MiniaturesMarkIII.png@e QJ~ !- anti-tankMarkII.png @^p =Krakatoafinwe@zaz.com.br}#!-{Mk-1Purple rainMarkII.png@aQKrakatoafinwe@zaz.com.brThis 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 builde|/!1!+ Chaos Ogre Mark IChaos OgreMarkIV-nolabel.png@q=p Nick KiestSimnicK@aol.com0{ ! Titan 6MarkVI.png @v4z#+7CMK3PitcherDefault.png @q\)Avaheil D'otteravaheildotter@aol.comThe 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\.comThe 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 par Z3Q#2011-04-21 13:06:21New Ogre #20110421070621.841495966Default.png^lchakMax200@Lanset.comThe 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 u >`\3 !- 2009-08-04 20:44:25anti-tankMarkII.png @^p =Krakatoafinwe@zaz.com.brO33 # 2009-08-04 20:44:25Mark III MiniaturesMarkIII.png@e Q 3'%3 +/O2009-08-04 20:44:25Vulcan Mk. IISuper VulcanMarkIII-nolabel.png@^ Maksim-Smec^ 3!'1  2009-08-05 15:21:50TremendousAtomic HorrorMarkVI-nolabel.png @EGzBlade2 3#1 %[_2009-08-04 20:44:25Blackeye v2Blackie 2MarkII-nolabel.png @YqRStephan Bealhttp://wanderinghorse.net/home/stephan/Intended primarily for light escort jobs.f3'%1 %[;2010-02-23 20:18:03Blackeye v2.1Blackie 2.10MarkII-nolabel.png @V1{,-ZStephan Bealhttp://wanderinghorse.net/home/stephan/A slight variation on the Blackeye v2.0, with one more SB, no AP, and two fewer RktS-E.\[]HIJKLMONPQRSTUVWXYZ]\\^EFotableOgreOgre CREATE TABLE Ogre( -- Ogre Ciscos cost: -- Cost := 2 * Treads -- Cost += (Cost of each Gear item) -- FinalCost := 5.357 * Cost / (10 - Ogre.MP) -- -- Cisco/SJG Conversions: -- Ciscos / 10 == Cisco Armor Unit Equivalence -- Ciscos * 0.6 = Approx SJG VP cost ID integer primary KEY autoincrement DEFAULT NULL, Active INT DEFAULT 1, LastUpdated valchar(18) DEFAULT current_timestamp, Name varchar(50) NOT NULL default '', Nickname varchar(50) default NULL, IsOfficial tinyint(1) default '0', Icon varchar(100) default 'Default.png', SizeClass integer default 7, MP integer default '0', TUMP integer default '0', Ciscos int(11) default '0', CiscosFudge int(11) default '0', Submitter varchar(100) default NULL, SubmitterInfo varchar(100) default NULL, Notes text, UNIQUE (Name) ) [3 1 %[G2009-08-04 20:44:25SpraycanFlower-nolabel.png @V33333Stephan Bealhttp://wanderinghorse.net/home/stephan/Spraycan's sole purpose is hosing down infantry. Little ones, big ones, fast ones, slow ones.f3+ 3 %[M2009-09-05 22:26:50Mark III-SGB-A0MarkIII-nolabel.png@dx =qStephan Bealhttp://wanderinghorse.net/home/stephan/Another experimental form of the Mark III, intended for the same missions as the original model.3-#  2010-02-13 18:24:48Copy of MK III-THedgehogMarkIII.png@Z\)RlyehableThe Ogre Mk III-T was implemented by some of the Factory-States. It simply upgrades the 8 AP guns to 4 Tertiary guns to provide additional anti-vehicle protection from swarms of light vehicles."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.AI, and 5 of the AP units while the rear section held cargo uanits 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 blchakMax200@Lanset.comThe 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 u ((z3 # }2011-06-28 23:22:29$CopymeDefault.png@6d跍Intended to be copied as a starting point for new ogres.D3 !  2010-02-14 08:33:05Fencer-BFencer.png@X-Y;^Ry3) !%k2011-04-21 13:03:43Copy of Mark IBoltMarkI.png@J XsHerb Diehr734/461-3304Experimental version made when Mk III came out.}39  i2011-04-21 13:06:21Copy of Copy of Mark IMarkI.png@Emhr!Experimental version mde when Mk III came out. Ajc!!viewv_overviewv_overviewCREATE VIEW v_overview AS SELECT o.ID as ID, o.Name as Name, o.MP as MP, (o.TUMP * o.MP) as 'Treads', o.Ciscos as Ciscos, (o.Ciscos / 10.0) as 'Cisco Armor Value', (o.Ciscos * 0.6) as 'Approx SJG VP' FROM Ogre o WHERE -- IsOfficial!=0 AND Active != 0';indexsqlite_autoindex_Ogre_1Ogre )qtriggertr_Ogre_deleteOgreCREATE TRIGGER tr_Ogre_delete BEFORE DELETE ON Ogre BEGIN DELETE FROM GearToOgre WHERE Ogre_ID=OLD.ID; END