PHer War SQL Proj

From FiranMUX

Here is the deal! War names need ids. Just fill them in on this page.

• 0 = a Firan PC (Adan)
• 1 = a Firan griffon (Bluestreak)
• 2 = a Shami griffon (Adskij)
• 3 = a Shami Soldier
• 4 = a Shami Archer
• 5 = a Shami Warlord
• 6 = a Shami Spearman
• 7 = a Shami Pilot/Flyer
• 8 = a Shami Priest
• 9 = other (i.e. wizards, etc)
• 10 = Shami Slave

update warroster set id=0 where person='Abed'
update warroster set id=9 where person='Adam'
update warroster set id=0 where person='Adan'
update warroster set id=3 where person='Adretizi'
update warroster set id=2 where person='Adskij'
update warroster set id=0 where person='Aervani'
update warroster set id=0 where person='Aeryk'
update warroster set id=10 where person='Afra'
update warroster set id=0 where person='Agray'
update warroster set id=0 where person='Akai'
update warroster set id=0 where person='Alastor'
update warroster set id=0 where person='Alessandro'
update warroster set id=0 where person='Alexa'
update warroster set id=0 where person='Amadea'
update warroster set id=0 where person='Andreas'
update warroster set id=0 where person='Apalonius'
update warroster set id=4 where person='Aprangi'
update warroster set id=0 where person='Aranos'
update warroster set id=0 where person='Arcos'
update warroster set id=0 where person='Argin'
update warroster set id=0 where person='Arik'
update warroster set id=0 where person='Arinsana'
update warroster set id=10 where person='Artanos'
update warroster set id=10 where person='Asiki'
update warroster set id=5 where person='Ayerbaiz'
update warroster set id=3 where person='Balgal'
update warroster set id=0 where person='Balinda'
update warroster set id=3 where person='Bamorane'
update warroster set id=3 where person='Bamorase'
update warroster set id=3 where person='Bandkondak'
update warroster set id=3 where person='Bangarang'
update warroster set id=0 where person='Banian'
update warroster set id=0 where person='Barasa'
update warroster set id=10 where person='Barell'
update warroster set id=0 where person='Bashar'
update warroster set id=3 where person='Blansordi'
update warroster set id=8 where person='Blezik'
update warroster set id=1 where person='Bluestreak'
update warroster set id=4 where person='Boomarger'
update warroster set id=6 where person='Brakit'
update warroster set id=4 where person='Briktunik'
update warroster set id=5 where person='Bropapma'
update warroster set id=3 where person='Cheflagz'
update warroster set id=1 where person='Chetwood'
update warroster set id=3 where person='Ciribati'
update warroster set id=4 where person='Claguck'
update warroster set id=0 where person='Clarissa'
update warroster set id=0 where person='Cortik'
update warroster set id=6 where person='Cuisnak'
update warroster set id=0 where person='Daphrus'
update warroster set id=0 where person='Dar'
update warroster set id=0 where person='Darius'
update warroster set id=7 where person='Darnt'
update warroster set id=0 where person='Davonos'
update warroster set id=4 where person='Dhast'
update warroster set id=4 where person='Dhist'
update warroster set id=6 where person='Dhralan'
update warroster set id=1 where person='Dirge'
update warroster set id=1 where person='Divebomb'
update warroster set id=0 where person='Donam'
update warroster set id=3 where person='Donamund'
update warroster set id=0 where person='Donos'
update warroster set id=4 where person='Dorfnes'
update warroster set id=6 where person='Dragisk'
update warroster set id=3 where person='Dubyik'
update warroster set id=3 where person='Durnt'
update warroster set id=5 where person='Ehrip'
update warroster set id=4 where person='Elafh'
update warroster set id=0 where person='Elvetus'
update warroster set id=0 where person='Eriden'
update warroster set id=0 where person='Esen'
update warroster set id=0 where person='Evius'
update warroster set id=0 where person='Fiero'
update warroster set id=0 where person='Firnik'
update warroster set id=2 where person='Firusurad'
update warroster set id=4 where person='Floomits'
update warroster set id=3 where person='Forbamif'
update warroster set id=5 where person='Forkon'
update warroster set id=1 where person='Frenzy'
update warroster set id=6 where person='Friknak'
update warroster set id=0 where person='Fudathim'
update warroster set id=4 where person='Furthazan'
update warroster set id=0 where person='Gaddineez'
update warroster set id=6 where person='Gadfanik'
update warroster set id=0 where person='Galanthis'
update warroster set id=2 where person='Gamoozi'
update warroster set id=3 where person='Ganorz'
update warroster set id=1 where person='Garissa'
update warroster set id=3 where person='Garthanz'
update warroster set id=0 where person='Gemma'
update warroster set id=6 where person='Gertenk'
update warroster set id=3 where person='Gharlhin'
update warroster set id=3 where person='Ghazli'
update warroster set id=4 where person='Gilbarth'
update warroster set id=7 where person='Gipran'
update warroster set id=3 where person='Gmughl'
update warroster set id=0 where person='Gondarus'
update warroster set id=4 where person='Grarblatz'
update warroster set id=3 where person='Grewnel'
update warroster set id=10 where person='Guveeni'
update warroster set id=6 where person='Hakrit'
update warroster set id=3 where person='Haliborten'
update warroster set id=8 where person='Hazarat'
update warroster set id=4 where person='Hbala'
update warroster set id=1 where person='Headstrong'
update warroster set id=3 where person='Hheiren'
update warroster set id=3 where person='Hornyz'
update warroster set id=1 where person='Hound'
update warroster set id=0 where person='Huetzi'
update warroster set id=0 where person='Hufimo'
update warroster set id=3 where person='Hureitdf'
update warroster set id=3 where person='Hylral'
update warroster set id=3 where person='Idinduit'
update warroster set id=3 where person='Idoonoik'
update warroster set id=3 where person='Ilfated'
update warroster set id=5 where person='Imgandar'
update warroster set id=0 where person='Inarus'
update warroster set id=0 where person='Ion'
update warroster set id=3 where person='Ionorz'
update warroster set id=1 where person='Ironhide'
update warroster set id=5 where person='Islik'
update warroster set id=3 where person='Isonisn'
update warroster set id=6 where person='Jakrap'
update warroster set id=6 where person='Jborst'
update warroster set id=0 where person='Jericho'
update warroster set id=8 where person='Jhaltep'
update warroster set id=0 where person='Judanarius'
update warroster set id=0 where person='Judanus'
update warroster set id=2 where person='Jukolil'
update warroster set id=3 where person='Jurk'
update warroster set id=0 where person='Kadikos'
update warroster set id=0 where person='Kaedin'
update warroster set id=0 where person='Kael'
update warroster set id=0 where person='Kalina'
update warroster set id=6 where person='Kambrsit'
update warroster set id=1 where person='Kamili'
update warroster set id=0 where person='Karana'
update warroster set id=0 where person='Karish'
update warroster set id=0 where person='Katarus'
update warroster set id=0 where person='Keeli'
update warroster set id=0 where person='Kelarik'
update warroster set id=8 where person='Kestafu'
update warroster set id=0 where person='Kisandera'
update warroster set id=8 where person='Kishali'
update warroster set id=3 where person='Kraztor'
update warroster set id=3 where person='Krilkiz'
update warroster set id=3 where person='Krithor'
update warroster set id=4 where person='Kurk'
update warroster set id=0 where person='Ladonna'
update warroster set id=3 where person='Largsed'
update warroster set id=1 where person='Laserbeak'
update warroster set id=6 where person='Legrak'
update warroster set id=0 where person='Lemachus'
update warroster set id=0 where person='Lianos'
update warroster set id=3 where person='Ligront'
update warroster set id=10 where person='Lik'
update warroster set id=3 where person='Limrotz'
update warroster set id=9 where person='Lisa'
update warroster set id=3 where person='Llordnaz'
update warroster set id=5 where person='Lopan'
update warroster set id=2 where person='Losparik'
update warroster set id=0 where person='Lucas'
update warroster set id=0 where person='Lucia'
update warroster set id=3 where person='Mambrap'
update warroster set id=0 where person='Marsalos'
update warroster set id=10 where person='Marsilla'
update warroster set id=3 where person='Medharz'
update warroster set id=0 where person='Melani'
update warroster set id=5 where person='Melsshon'
update warroster set id=1 where person='Mirage'
update warroster set id=3 where person='Molsifen'
update warroster set id=5 where person='Morik'
update warroster set id=4 where person='Mornoogie'
update warroster set id=6 where person='Mrabnas'
update warroster set id=3 where person='Myashixz'
update warroster set id=3 where person='Myrzbon'
update warroster set id=6 where person='Nadrik'
update warroster set id=8 where person='Namizik'
update warroster set id=0 where person='Nelisha'
update warroster set id=0 where person='Niobe'
update warroster set id=3 where person='Nirazeems'
update warroster set id=0 where person='Nisa'
update warroster set id=3 where person='Nopitup'
update warroster set id=0 where person='Norik'
update warroster set id=1 where person='Novius'
update warroster set id=4 where person='Nozernik'
update warroster set id=4 where person='Numiler'
update warroster set id=0 where person='Nydiam'
update warroster set id=0 where person='Odoni'
update warroster set id=6 where person='Oloath'
update warroster set id=8 where person='Omantepki'
update warroster set id=3 where person='Omgarack'
update warroster set id=4 where person='Omnak'
update warroster set id=9 where person='OpalBuilder'
update warroster set id=0 where person='Oribanna'
update warroster set id=3 where person='Oristanis'
update warroster set id=0 where person='Parosh'
update warroster set id=3 where person='Phlegmik'
update warroster set id=2 where person='Piyut'
update warroster set id=3 where person='Posfdin'
update warroster set id=0 where person='Primo'
update warroster set id=0 where person='Quenna'
update warroster set id=5 where person='Quintluz'
update warroster set id=6 where person='Quistrik'
update warroster set id=6 where person='Radfert'
update warroster set id=4 where person='Raflaz'
update warroster set id=0 where person='Rally'
update warroster set id=0 where person='Ramisa'
update warroster set id=1 where person='Ramjet'
update warroster set id=0 where person='Ranselis'
update warroster set id=0 where person='Rezzana'
update warroster set id=0 where person='Riosan'
update warroster set id=0 where person='Rislan'
update warroster set id=2 where person='Rituyok'
update warroster set id=0 where person='Rodiste'
update warroster set id=3 where person='Roythorz'
update warroster set id=1 where person='Runabout'
update warroster set id=1 where person='Runamuck'
update warroster set id=0 where person='Sabria'
update warroster set id=1 where person='Sandstorm'
update warroster set id=3 where person='Sanselhor'
update warroster set id=0 where person='Sarina'
update warroster set id=0 where person='Savaren'
update warroster set id=10 where person='Seez'
update warroster set id=0 where person='Sharin'
update warroster set id=0 where person='Sinan'
update warroster set id=8 where person='Skajhit'
update warroster set id=3 where person='Skezalif'
update warroster set id=3 where person='Skusoh'
update warroster set id=1 where person='Skyscreamer'
update warroster set id=8 where person='Slarhit'
update warroster set id=4 where person='Smhalck'
update warroster set id=4 where person='Soit'
update warroster set id=3 where person='Sreemeel'
update warroster set id=3 where person='Sreez'
update warroster set id=0 where person='Srenni'
update warroster set id=6 where person='Srestik'
update warroster set id=10 where person='Stevana'
update warroster set id=0 where person='Tabarus'
update warroster set id=0 where person='Tagda'
update warroster set id=0 where person='Talion'
update warroster set id=1 where person='Tantrum'
update warroster set id=0 where person='Tanya'
update warroster set id=4 where person='Targanth'
update warroster set id=5 where person='Tarntil'
update warroster set id=3 where person='Tebonath'
update warroster set id=3 where person='Tehrdonaz'
update warroster set id=0 where person='Tezzer'
update warroster set id=0 where person='Thaddia'
update warroster set id=1 where person='Thrust'
update warroster set id=0 where person='Tiernan'
update warroster set id=0 where person='Timon'
update warroster set id=1 where person='Tito'
update warroster set id=4 where person='Traklicken'
update warroster set id=0 where person='Treydan'
update warroster set id=2 where person='Tuyerguve'
update warroster set id=0 where person='Tyrin'
update warroster set id=0 where person='Tyrsun'
update warroster set id=2 where person='Uelacirga'
update warroster set id=3 where person='Ulgreje'
update warroster set id=0 where person='Ulrik'
update warroster set id=0 where person='Ulyn'
update warroster set id=0 where person='Umaish'
update warroster set id=4 where person='Uteekzer'
update warroster set id=10 where person='Valora'
update warroster set id=3 where person='Vashnu'
update warroster set id=0 where person='Vasyklo'
update warroster set id=0 where person='Veliana'
update warroster set id=10 where person='Vinosaria'
update warroster set id=5 where person='Virstin'
update warroster set id=6 where person='Vrasmak'
update warroster set id=4 where person='Vrishnu'
update warroster set id=8 where person='Vrolemki'
update warroster set id=3 where person='Vsnorith'
update warroster set id=0 where person='Wakiro'
update warroster set id=4 where person='Weetzle'
update warroster set id=6 where person='Wesbrek'
update warroster set id=1 where person='Wifnan'
update warroster set id=1 where person='Wrath'
update warroster set id=0 where person='Wylma'
update warroster set id=0 where person='Yacen'
update warroster set id=5 where person='Yakut'
update warroster set id=3 where person='Yosskulas'
update warroster set id=3 where person='Ypnos'
update warroster set id=0 where person='Zafir'
update warroster set id=3 where person='Zalbonz'
update warroster set id=0 where person='Zelva'
update warroster set id=4 where person='Zerbort'
update warroster set id=3 where person='Zernik'
update warroster set id=3 where person='Zhurenis'
update warroster set id=5 where person='Zig'
update warroster set id=4 where person='Zilkarth'
update warroster set id=4 where person='Zilthriganz'
update warroster set id=6 where person='Zobrot'
update warroster set id=3 where person='Zorehts'
update warroster set id=6 where person='Zrebnk'
update warroster set id=3 where person='Zyhornth'