Go Back   EQEmulator Home > EQEmulator Forums > General > General::Server Discussion
Reload this Page Update Guard and Citizen Graphics

General::Server Discussion Discussion about emulator servers.
Do not post support topics here.

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2020, 07:14 PM
djeryv
Hill Giant
  
Join Date: Apr 2008
Posts: 234
Default Update Guard and Citizen Graphics
This is an SQL file you can import into your game if you choose. What it does is change the graphics of the guards and citizens from the old models to the modern ones. It also runs through the guards and citizens and gives them random faces and some random clothing. Although it can be quite nostalgic to see the old style graphics of guards and such, this SQL file really makes the cities more diverse looking as the NPCs don't all look like cookie cutter models of each other. I ran around every city and I think it looks much better, but this is simply my opinion. I gave the guards chainmail for their appearances only because I (as a player) want to look kick ass in my plate mail armor when I walk the streets.

Code:
UPDATE npc_types SET bodytype=1, texture=0, helmtexture=0, face=666, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( class=40 OR class=41 ) AND ( id<800000 OR id>800100 );

UPDATE npc_types SET bodytype=1, texture=0, helmtexture=0, face=666, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( class=40 OR class=41 ) AND ( id<800000 OR id>800100 ) AND ( race=112 OR race=44 );

UPDATE npc_types SET bodytype=1, texture=0, helmtexture=0, face=666, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( name='Hendry_Seaworthy' OR name='Frizazz' OR name='Jozter' OR name='Sasha_the_Seer' OR name='Armorer_Dellin' OR name='Brother_Jentry' OR name='Jail_Clerk_Maryl' OR name='Dyllin_Starshine' OR name='Trantor_Everhot' OR name='Dunndrylla' OR name='Jorna' OR name='Turgan' OR name='a_kitchen_drudge' OR name='a_lady_in_waiting' OR name='a_maid' OR ( name LIKE 'a_gypsy_%' AND race=71 ) OR name='Mynthi_Davissi' OR name='Bidils_the_Quickhand' OR name='Ezmirella' OR name='Germe_Threadspinner' OR name='Innkeep_Dolman' OR name='King_Kazon_Stormhammer' OR name='Innkeep_Fenia' OR name='Innkeep_Olissa' OR name='Innkeep_Redthorn' OR name='Opal_Woodchopper' OR name='Peron_ThreadSpinner' OR name='Ranon_Strongarm' OR name='#High_Priest_I`Xar' OR name='Ace_Slighthand' OR name='Blinza_Toepopal' OR name='Exterminator_Sutten' OR name='Bearuth_the_Stoic' OR name='Psal_G`Noir' OR name='#Lanhern_Firepride' OR name='Madame_Serena' OR name='Brohan_Ironforge' OR name='Dranom_Ghenson' OR name='Hurrieta_Ironforge' OR name='Hefax_Tinmar' OR name='Mogan_Delfin' OR ( name='Cynthia' AND race=71 ) OR ( name='Delila' AND race=71 ) OR ( name='Kathryn' AND race=71 ) OR ( name='Kindra_Farseer' AND race=71 ) OR ( name='Meelana' AND race=71 ) OR ( name='Sheldon' AND race=71 ) );

UPDATE npc_types SET texture=3, helmtexture=3 WHERE face=666 AND name='King_Kazon_Stormhammer';
UPDATE npc_types SET texture=11, helmtexture=0 WHERE face=666 AND name='Psal_G`Noir';

UPDATE npc_types SET texture=4 WHERE face=666 AND ( name='Hendry_Seaworthy' OR name='Frizazz' OR name='Jozter' OR name='Bidils_the_Quickhand' OR name='Exterminator_Sutten' OR name='Ace_Slighthand' OR name='Kindra_Farseer' );

UPDATE npc_types SET race=1 WHERE face=666 AND ( race=67 OR race=71 OR race=44 );
UPDATE npc_types SET race=4 WHERE face=666 AND race=112;
UPDATE npc_types SET race=2 WHERE face=666 AND race=90;
UPDATE npc_types SET race=3 WHERE face=666 AND race=78;
UPDATE npc_types SET race=6 WHERE face=666 AND race=77;
UPDATE npc_types SET race=8 WHERE face=666 AND race=94;
UPDATE npc_types SET race=9 WHERE face=666 AND race=92;
UPDATE npc_types SET race=10 WHERE face=666 AND race=93;
UPDATE npc_types SET race=11 WHERE face=666 AND race=81;
UPDATE npc_types SET race=128 WHERE face=666 AND race=139;

UPDATE npc_types SET loottable_id=102887, d_melee_texture1=0 WHERE name='Guard_Swang' OR name='Guard_Lumpkin';
UPDATE npc_types SET name='Guard_L`Crit' WHERE name='Guard_LCrit';
UPDATE npc_types SET loottable_id=110208 WHERE name='Guard_H`Rugla' OR name='Guard_F`Lok' OR name='Guard_T`Kix' OR name='Guard_S`Kor' OR name='Guard_N`Mar' OR name='Guard_V`Retta' OR name='Guard_Punox' OR name='Guard_Ixtaz' OR name='Guard_L`Crit' OR name='Guard_Tolax';

UPDATE npc_types, spawn2, spawnentry SET race=8, bodytype=1, texture=0, helmtexture=0, face=667, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='kaladima' OR zone='kaladimb' OR zone='butcher' ) AND ( name LIKE 'Guard%' OR name LIKE 'Lieutenant%' ) AND ( race=67 OR race=71 OR race=90 OR race=78 OR race=77 OR race=94 OR race=92 OR race=93 OR race=81 OR race=139 OR race=44 OR race=106 OR race=112 OR race=239 ) AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=128, bodytype=1, texture=0, helmtexture=0, face=668, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='warslikswood' OR zone='swampofnohope' OR zone='lakeofillomen' OR zone='cabeast' OR zone='cabwest' OR zone='fieldofbone' ) AND ( name LIKE 'Captain%' OR name LIKE 'Crusader%' OR name LIKE 'Trooper%' OR name LIKE 'Exterminator%' OR name like '%Toilmaster' ) AND ( race=67 OR race=71 OR race=90 OR race=78 OR race=77 OR race=94 OR race=92 OR race=93 OR race=81 OR race=139 OR race=44 OR race=106 OR race=112 OR race=239 ) AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=1, bodytype=1, texture=0, helmtexture=0, face=669, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='qey2hh1' OR zone='qeynos' OR zone='qeynos2' OR zone='qeytoqrg' OR zone='northro' OR zone='nro' OR zone='northkarana' OR zone='jaggedpine' OR zone='highpasshold' OR zone='highpass' OR zone='highkeep' OR zone='freportw' OR zone='freporte' OR zone='freportn' OR zone='freeportmilitia' OR zone='freeportwest' OR zone='freeporteast' OR zone='commonlands' OR zone='commons' OR zone='ecommons' ) AND ( name='a_guard' OR name LIKE 'Lieutenant%' OR name LIKE 'Corporal%' OR name LIKE 'Sir_%' OR name LIKE '%Guard_%' OR name LIKE '%Commander%' OR name LIKE 'Capt_%' OR name LIKE 'Captain%' OR name LIKE '%Sergeant_%' OR name LIKE '%ilitia%' ) AND ( race=67 OR race=71 OR race=90 OR race=78 OR race=77 OR race=94 OR race=92 OR race=93 OR race=81 OR race=139 OR race=44 OR race=106 OR race=112 OR race=239 ) AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=3, bodytype=1, texture=0, helmtexture=0, face=670, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='barren' OR zone='tox' OR zone='toxxulia' OR zone='erudnext' OR zone='erudnint' ) AND ( name LIKE 'Sentinel%' OR name LIKE 'Warden%' OR name LIKE 'Chief%' OR name LIKE '%_Lt._%' OR name LIKE 'a_Stormguard_knight' OR name='Knarthenne_Skurl' ) AND ( race=67 OR race=71 OR race=90 OR race=78 OR race=77 OR race=94 OR race=92 OR race=93 OR race=81 OR race=139 OR race=44 OR race=106 OR race=112 OR race=239 ) AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=10, bodytype=1, texture=0, helmtexture=0, face=671, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='feerrott' OR zone='oggok' ) AND ( name LIKE 'Bouncer%' OR name LIKE 'Exterminator%' ) AND ( race=10 OR race=67 OR race=71 OR race=90 OR race=78 OR race=77 OR race=94 OR race=92 OR race=93 OR race=81 OR race=139 OR race=44 OR race=106 OR race=112 OR race=239 ) AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=10, bodytype=1, texture=0, helmtexture=0, face=671, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE name LIKE 'Guard_Swang' AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=5, bodytype=1, texture=0, helmtexture=0, face=672, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='felwithea' OR zone='felwitheb' OR zone='firiona' ) AND ( name LIKE 'Guard%' OR name LIKE 'Lieutenant%' OR name LIKE 'Shieldbearer%' ) AND ( race=67 OR race=71 OR race=90 OR race=78 OR race=77 OR race=94 OR race=92 OR race=93 OR race=81 OR race=139 OR race=44 OR race=106 OR race=112 OR race=239 ) AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=5, bodytype=1, texture=0, helmtexture=0, face=672, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='gfaydark' ) AND ( name LIKE 'Guard_Crystalwind' OR name LIKE 'Guard_Highmoon' ) AND ( race=67 OR race=71 OR race=90 OR race=78 OR race=77 OR race=94 OR race=92 OR race=93 OR race=81 OR race=139 OR race=44 OR race=106 OR race=112 OR race=239 ) AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=4, bodytype=1, texture=0, helmtexture=0, face=673, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='gfaydark' ) AND ( name LIKE 'Guard%' OR name LIKE 'Captain%' OR name LIKE 'Lieutenant%' ) AND name!='Guard_Crystalwind' AND name!='Guard_Highmoon' AND ( race=67 OR race=71 OR race=90 OR race=78 OR race=77 OR race=94 OR race=92 OR race=93 OR race=81 OR race=139 OR race=44 OR race=106 OR race=112 OR race=239 ) AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=9, bodytype=1, texture=0, helmtexture=0, face=674, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='innothule' OR zone='grobb' ) AND ( name LIKE 'Basher%' ) AND ( race=9 OR race=67 OR race=71 OR race=90 OR race=78 OR race=77 OR race=94 OR race=92 OR race=93 OR race=81 OR race=139 OR race=44 OR race=106 OR race=112 OR race=239 ) AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=11, bodytype=1, texture=0, helmtexture=0, face=675, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='alkabormare' OR zone='mistythicket' OR zone='misty' OR zone='rivervale' ) AND ( name LIKE '%Deputy%' ) AND ( race=67 OR race=71 OR race=90 OR race=78 OR race=77 OR race=94 OR race=92 OR race=93 OR race=81 OR race=139 OR race=44 OR race=106 OR race=112 OR race=239 ) AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=6, bodytype=1, texture=0, helmtexture=0, face=676, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='overthere' OR zone='nektulos' OR zone='neriaka' OR zone='neriakb' OR zone='neriakc' ) AND race=77 AND ( name LIKE 'Sergeant%' OR name LIKE 'Guard%' OR name LIKE 'Captain%' OR name LIKE 'Corporal%' OR name LIKE 'Dragoon%' OR name='Kirak_Vil' OR name LIKE 'General_%' ) AND ( race=67 OR race=71 OR race=90 OR race=78 OR race=77 OR race=94 OR race=92 OR race=93 OR race=81 OR race=139 OR race=44 OR race=106 OR race=112 OR race=239 ) AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=6, bodytype=1, texture=0, helmtexture=0, face=676, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='neriaka' OR zone='neriakb' OR zone='neriakc' ) AND race=77 AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=130, bodytype=1, texture=0, helmtexture=0, face=677, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='sharvahl' ) AND ( name LIKE '%_Guard_%' OR name LIKE '#General%' OR name LIKE 'General%' ) AND ( race=67 OR race=71 OR race=90 OR race=78 OR race=77 OR race=94 OR race=92 OR race=93 OR race=81 OR race=139 OR race=44 OR race=106 OR race=112 OR race=239 ) AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types, spawn2, spawnentry SET race=2, bodytype=1, texture=0, helmtexture=0, face=678, luclin_hairstyle=0, luclin_haircolor=0, luclin_eyecolor=0, luclin_eyecolor2=0, luclin_beardcolor=0, luclin_beard=0, drakkin_heritage=0, drakkin_tattoo=0, drakkin_details=0, armtexture=0, bracertexture=0, handtexture=0, legtexture=0, feettexture=0 WHERE ( zone='Everfrost' OR zone='halas' ) AND ( name LIKE '%_McMarrin' ) AND ( race=67 OR race=71 OR race=90 OR race=78 OR race=77 OR race=94 OR race=92 OR race=93 OR race=81 OR race=139 OR race=44 OR race=106 OR race=112 OR race=239 ) AND npc_types.id=npcID AND spawnentry.spawngroupID=spawn2.spawngroupID;

UPDATE npc_types SET gender=0 WHERE gender=2 AND face>=666 AND face<679 AND race=128;

UPDATE npc_types SET luclin_eyecolor=FLOOR(RAND()*10), luclin_eyecolor2=FLOOR(RAND()*10), luclin_haircolor=FLOOR(RAND()*20) WHERE face>=666 AND face<679 ORDER BY id;

UPDATE npc_types SET luclin_hairstyle=FLOOR(RAND()*4) WHERE face>=666 AND face<679 AND gender=0 AND ( race=1 OR race=2 OR race=4 OR race=5 OR race=6 OR race=7 OR race=8 OR race=11 OR race=12 ) ORDER BY id;
UPDATE npc_types SET luclin_hairstyle=FLOOR(RAND()*3) WHERE face>=666 AND face<679 AND gender=1 AND ( race=1 OR race=2 OR race=4 OR race=5 OR race=6 OR race=7 OR race=8 OR race=11 OR race=12 ) ORDER BY id;

UPDATE npc_types SET luclin_hairstyle=FLOOR(RAND()*9), luclin_haircolor=FLOOR(RAND()*4), drakkin_heritage=FLOOR(RAND()*7), drakkin_tattoo=FLOOR(RAND()*8), drakkin_details=FLOOR(RAND()*8) WHERE face>=666 AND face<679 AND gender=0 AND race=522 ORDER BY id;
UPDATE npc_types SET luclin_hairstyle=FLOOR(RAND()*8), luclin_haircolor=FLOOR(RAND()*4), drakkin_heritage=FLOOR(RAND()*7), drakkin_tattoo=FLOOR(RAND()*8), drakkin_details=FLOOR(RAND()*8) WHERE face>=666 AND face<679 AND gender=1 AND race=522 ORDER BY id;

UPDATE npc_types SET luclin_hairstyle=FLOOR(RAND()*4) WHERE face>=666 AND face<679 AND gender=1 AND race=9 ORDER BY id;
UPDATE npc_types SET luclin_hairstyle=FLOOR(RAND()*4) WHERE face>=666 AND face<679 AND gender=1 AND race=10 ORDER BY id;

UPDATE npc_types SET luclin_haircolor=FLOOR(RAND()*15) WHERE face>=666 AND face<679 AND race=5 ORDER BY id;

UPDATE npc_types SET luclin_hairstyle=FLOOR(RAND()*6), luclin_haircolor=0 WHERE face>=666 AND face<679 AND gender=0 AND race=3 ORDER BY id;
UPDATE npc_types SET luclin_hairstyle=FLOOR(RAND()*9), luclin_haircolor=0 WHERE face>=666 AND face<679 AND gender=1 AND race=3 ORDER BY id;

UPDATE npc_types SET luclin_haircolor=FLOOR(RAND()*10) WHERE face>=666 AND face<679 AND race=6 ORDER BY id;

UPDATE npc_types SET luclin_beard=FLOOR(RAND()*12) WHERE face>=666 AND face<679 AND race=522 AND gender=0 ORDER BY id;
UPDATE npc_types SET luclin_beard=FLOOR(RAND()*4) WHERE face>=666 AND face<679 AND race=522 AND gender=1 ORDER BY id;
UPDATE npc_types SET luclin_beard=FLOOR(RAND()*6) WHERE face>=666 AND face<679 AND race=1 AND gender=0 ORDER BY id;
UPDATE npc_types SET luclin_beard=FLOOR(RAND()*4) WHERE face>=666 AND face<679 AND race=5 AND gender=0 ORDER BY id;
UPDATE npc_types SET luclin_beard=FLOOR(RAND()*6) WHERE face>=666 AND face<679 AND race=11 AND gender=0 ORDER BY id;
UPDATE npc_types SET luclin_beard=FLOOR(RAND()*4) WHERE face>=666 AND face<679 AND race=7 AND gender=0 ORDER BY id;
UPDATE npc_types SET luclin_beard=FLOOR(RAND()*6) WHERE face>=666 AND face<679 AND race=12 AND gender=0 ORDER BY id;
UPDATE npc_types SET luclin_beard=FLOOR(RAND()*6) WHERE face>=666 AND face<679 AND race=2 AND gender=0 ORDER BY id;
UPDATE npc_types SET luclin_beard=FLOOR(RAND()*6) WHERE face>=666 AND face<679 AND race=8 AND gender=0 ORDER BY id;
UPDATE npc_types SET luclin_beard=FLOOR(RAND()*2) WHERE face>=666 AND face<679 AND race=8 AND gender=1 ORDER BY id;
UPDATE npc_types SET luclin_beard=FLOOR(RAND()*4) WHERE face>=666 AND face<679 AND race=6 AND gender=0 ORDER BY id;
UPDATE npc_types SET luclin_beard=FLOOR(RAND()*6) WHERE face>=666 AND face<679 AND race=2 AND gender=0 ORDER BY id;

UPDATE npc_types SET drakkin_tattoo=FLOOR(RAND()*9) WHERE face>=666 AND face<679 AND race=2 ORDER BY id;
UPDATE npc_types SET luclin_beardcolor=luclin_haircolor WHERE face>=666 AND face<679;

UPDATE npc_types SET size=6 WHERE race=1 AND face>=666 AND face<679;
UPDATE npc_types SET size=7 WHERE race=2 AND face>=666 AND face<679;
UPDATE npc_types SET size=6 WHERE race=3 AND face>=666 AND face<679;
UPDATE npc_types SET size=5 WHERE race=4 AND face>=666 AND face<679;
UPDATE npc_types SET size=6 WHERE race=5 AND face>=666 AND face<679;
UPDATE npc_types SET size=5 WHERE race=6 AND face>=666 AND face<679;
UPDATE npc_types SET size=5.5 WHERE race=7 AND face>=666 AND face<679;
UPDATE npc_types SET size=4 WHERE race=8 AND face>=666 AND face<679;
UPDATE npc_types SET size=8 WHERE race=9 AND face>=666 AND face<679;
UPDATE npc_types SET size=9 WHERE race=10 AND face>=666 AND face<679;
UPDATE npc_types SET size=3.5 WHERE race=11 AND face>=666 AND face<679;
UPDATE npc_types SET size=3 WHERE race=12 AND face>=666 AND face<679;
UPDATE npc_types SET size=7 WHERE race=130 AND face>=666 AND face<679;
UPDATE npc_types SET size=6 WHERE race=522 AND face>=666 AND face<679;
UPDATE npc_types SET size=6 WHERE race=128 AND face>=666 AND face<679;
UPDATE npc_types SET size=5 WHERE race=330 AND face>=666 AND face<679;

UPDATE npc_types SET d_melee_texture1=10649 WHERE face>666 AND face<679;

UPDATE npc_types SET texture=FLOOR(RAND()*5) WHERE ( FLOOR(RAND()*6) > 3 ) AND ( class=40 OR class=41 ) AND texture=0 AND face=666;
UPDATE npc_types SET texture=FLOOR(11+(RAND()*6)) WHERE ( FLOOR(RAND()*6) > 4 ) AND ( class=40 OR class=41 ) AND ( race=1 OR race=3 OR race=5 OR race=6 OR race=12 OR race=128 ) AND texture=0 AND face=666;
UPDATE npc_types SET texture=FLOOR(RAND()*2) WHERE ( class=40 OR class=41 ) AND texture=0 AND face=666;

UPDATE npc_types SET texture=FLOOR(11+(RAND()*6)) WHERE face=666 AND ( name='Sasha_the_Seer' OR name='a_gypsy_' OR name='Mynthi_Davissi' OR name='Ezmirella' OR name='#High_Priest_I`Xar' );
UPDATE npc_types SET texture=2 WHERE face=666 AND ( name='Armorer_Dellin' OR name='Brother_Jentry' OR name='Jail_Clerk_Maryl' OR name='Dyllin_Starshine' OR name='#Lanhern_Firepride' OR name='Brohan_Ironforge' OR name='Hurrieta_Ironforge' OR name='Delila' OR name='Meelana' OR name='Sheldon' );
UPDATE npc_types SET texture=1 WHERE face=666 AND ( name='Opal_Woodchopper' OR name='Peron_ThreadSpinner' OR name='Ranon_Strongarm' OR name='Innkeep_Redthorn' OR name='Innkeep_Olissa' OR name='Innkeep_Fenia' OR name='Innkeep_Dolman' OR name='Germe_Threadspinner' OR name='Dunndrylla' OR name='Jorna' OR name='Turgan' OR name='a_kitchen_drudge' OR name='a_lady_in_waiting' OR name='a_maid' OR name='Blinza_Toepopal' OR name='Bearuth_the_Stoic' OR name='Madame_Serena' OR name='Dranom_Ghenson' OR name='Hefax_Tinmar' OR name='Mogan_Delfin' OR name='Cynthia' OR name='Kathryn' );

UPDATE npc_types SET texture=2, helmtexture=2 WHERE face>666 AND face<679;
UPDATE npc_types SET texture=3, helmtexture=3 WHERE ( race=128 OR race=8 OR race=5 ) AND face>666 AND face<679;

UPDATE npc_types SET face=FLOOR(RAND()*8) WHERE face>=666 AND face<679;
UPDATE npc_types SET face=FLOOR(RAND()*7) WHERE face>=666 AND face<679 AND race=522;
UPDATE npc_types SET face=FLOOR(RAND()*10) WHERE face>=666 AND face<679 AND race=330;
UPDATE npc_types SET face=1 WHERE race=6 and face=6;
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 03:59 PM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3