Skip to content

Instantly share code, notes, and snippets.

@mindsear

mindsear/335_PhilsTransmogMall.sql

Created July 25, 2018 16:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mindsear/b224a6d5a0e1b73a03bbc144cd0d63f7 to your computer and use it in GitHub Desktop.
Save mindsear/b224a6d5a0e1b73a03bbc144cd0d63f7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
335_PhilsTransmogMall.sql
-- ===================================================================================================================== --
--
-- [3.3.5] Transmog Mall, Created by philippovitch, Updated by mindsear (Jul-25-2018) for the latest TrinityCore TDB 335.64
--
-- ===================================================================================================================== --
Set @Subname_OS_WOTLK_1 := "Transmog Off-Set WOTLK 'Uncommon'";
Set @Subname_OS_WOTLK_2 := "Transmog Off-Set WOTLK 'Rare & Epics'";
Set @Subname_Wep_WOTLK_1 := "Transmog Weapons WOTLK 'Uncommon'";
Set @Subname_Wep_WOTLK_2 := "Transmog Weapons WOTLK 'Rare'";
Set @Subname_Wep_WOTLK_3 := "Transmog Weapons WOTLK 'Epics'";
Set @M_Cloth := 7;
Set @M_Leather := 8;
Set @M_Mail := 5;
Set @M_Plate := 6;
Set @Base_Entry := 500230;
DELETE FROM world.creature_template where `entry` between @Base_Entry AND @Base_Entry+114;
-- WOTLK
INSERT into world.creature_template (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) values
-- Head
(@Base_Entry,0,0,0,0,0,27822,0,0,0,'Transmog Head Cloth',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+1,0,0,0,0,0,27822,0,0,0,'Transmog Head Leather',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+2,0,0,0,0,0,27822,0,0,0,'Transmog Head Mail',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+3,0,0,0,0,0,27822,0,0,0,'Transmog Head Plate',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Shoulders
(@Base_Entry+4,0,0,0,0,0,27822,0,0,0,'Transmog Shoulders Cloth',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+5,0,0,0,0,0,27822,0,0,0,'Transmog Shoulders Leather',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+6,0,0,0,0,0,27822,0,0,0,'Transmog Shoulders Mail',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+7,0,0,0,0,0,27822,0,0,0,'Transmog Shoulders Plate',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Back
(@Base_Entry+8,0,0,0,0,0,27822,0,0,0,'Back',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+9,0,0,0,0,0,27822,0,0,0,'Back Leather',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+10,0,0,0,0,0,27822,0,0,0,'Back Mail',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+11,0,0,0,0,0,27822,0,0,0,'Back Plate',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Chest
(@Base_Entry+12,0,0,0,0,0,27822,0,0,0,'Transmog Chest Cloth',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+13,0,0,0,0,0,27822,0,0,0,'Transmog Chest Leather',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+14,0,0,0,0,0,27822,0,0,0,'Transmog Chest Mail',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+15,0,0,0,0,0,27822,0,0,0,'Transmog Chest Plate',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Hands
(@Base_Entry+16,0,0,0,0,0,27822,0,0,0,'Transmog Hands Cloth',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+17,0,0,0,0,0,27822,0,0,0,'Transmog Hands Leather',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+18,0,0,0,0,0,27822,0,0,0,'Transmog Hands Mail',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+19,0,0,0,0,0,27822,0,0,0,'Transmog Hands Plate',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Waist
(@Base_Entry+20,0,0,0,0,0,27822,0,0,0,'Transmog Waist Cloth',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+21,0,0,0,0,0,27822,0,0,0,'Transmog Waist Leather',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+22,0,0,0,0,0,27822,0,0,0,'Transmog Waist Mail',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+23,0,0,0,0,0,27822,0,0,0,'Transmog Waist Plate',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Legs
(@Base_Entry+24,0,0,0,0,0,27822,0,0,0,'Transmog Legs Cloth',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+25,0,0,0,0,0,27822,0,0,0,'Transmog Legs Leather',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+26,0,0,0,0,0,27822,0,0,0,'Transmog Legs Mail',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+27,0,0,0,0,0,27822,0,0,0,'Transmog Legs Plate',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Boots
(@Base_Entry+28,0,0,0,0,0,27822,0,0,0,'Transmog Boots Cloth',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+29,0,0,0,0,0,27822,0,0,0,'Transmog Boots Leather',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+30,0,0,0,0,0,27822,0,0,0,'Transmog Boots Mail',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+31,0,0,0,0,0,27822,0,0,0,'Transmog Boots Plate',@Subname_OS_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340);
-- WOTLK 2
INSERT into world.creature_template (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) values
-- Head
(@Base_Entry+32,0,0,0,0,0,27822,0,0,0,'Transmog Head Cloth',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+33,0,0,0,0,0,27822,0,0,0,'Transmog Head Leather',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+34,0,0,0,0,0,27822,0,0,0,'Transmog Head Mail',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+35,0,0,0,0,0,27822,0,0,0,'Transmog Head Plate',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Shoulders
(@Base_Entry+36,0,0,0,0,0,27822,0,0,0,'Transmog Shoulders Cloth',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+37,0,0,0,0,0,27822,0,0,0,'Transmog Shoulders Leather',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+38,0,0,0,0,0,27822,0,0,0,'Transmog Shoulders Mail',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+39,0,0,0,0,0,27822,0,0,0,'Transmog Shoulders Plate',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Back
(@Base_Entry+40,0,0,0,0,0,27822,0,0,0,'Back',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+41,0,0,0,0,0,27822,0,0,0,'Back Leather',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+42,0,0,0,0,0,27822,0,0,0,'Back Mail',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+43,0,0,0,0,0,27822,0,0,0,'Back Plate',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Chest
(@Base_Entry+44,0,0,0,0,0,27822,0,0,0,'Transmog Chest Cloth',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+45,0,0,0,0,0,27822,0,0,0,'Transmog Chest Leather',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+46,0,0,0,0,0,27822,0,0,0,'Transmog Chest Mail',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+47,0,0,0,0,0,27822,0,0,0,'Transmog Chest Plate',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Hands
(@Base_Entry+48,0,0,0,0,0,27822,0,0,0,'Transmog Hands Cloth',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+49,0,0,0,0,0,27822,0,0,0,'Transmog Hands Leather',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+50,0,0,0,0,0,27822,0,0,0,'Transmog Hands Mail',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+51,0,0,0,0,0,27822,0,0,0,'Transmog Hands Plate',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Waist
(@Base_Entry+52,0,0,0,0,0,27822,0,0,0,'Transmog Waist Cloth',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+53,0,0,0,0,0,27822,0,0,0,'Transmog Waist Leather',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+54,0,0,0,0,0,27822,0,0,0,'Transmog Waist Mail',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+55,0,0,0,0,0,27822,0,0,0,'Transmog Waist Plate',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Legs
(@Base_Entry+56,0,0,0,0,0,27822,0,0,0,'Transmog Legs Cloth',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+57,0,0,0,0,0,27822,0,0,0,'Transmog Legs Leather',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+58,0,0,0,0,0,27822,0,0,0,'Transmog Legs Mail',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+59,0,0,0,0,0,27822,0,0,0,'Transmog Legs Plate',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Boots
(@Base_Entry+60,0,0,0,0,0,27822,0,0,0,'Transmog Boots Cloth',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+61,0,0,0,0,0,27822,0,0,0,'Transmog Boots Leather',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+62,0,0,0,0,0,27822,0,0,0,'Transmog Boots Mail',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+63,0,0,0,0,0,27822,0,0,0,'Transmog Boots Plate',@Subname_OS_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340);
-- WEAPON WOTLK
INSERT into world.creature_template (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) values
-- -------- Uncommon
-- AXES
(@Base_Entry+64,0,0,0,0,0,27822,0,0,0,'1H Axes',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+65,0,0,0,0,0,27822,0,0,0,'2H Axes',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Swords
(@Base_Entry+66,0,0,0,0,0,27822,0,0,0,'1H Swords',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+67,0,0,0,0,0,27822,0,0,0,'2H Swords',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Mace
(@Base_Entry+68,0,0,0,0,0,27822,0,0,0,'1H Mace',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+69,0,0,0,0,0,27822,0,0,0,'2H Mace',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Daggers
(@Base_Entry+70,0,0,0,0,0,27822,0,0,0,'Daggers',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Staves
(@Base_Entry+71,0,0,0,0,0,27822,0,0,0,'Staves',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Tome
(@Base_Entry+72,0,0,0,0,0,27822,0,0,0,'Tome',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Shield 1 - 30
(@Base_Entry+73,0,0,0,0,0,27822,0,0,0,'Shields I (71-75)',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Shield 31 - 60
(@Base_Entry+74,0,0,0,0,0,27822,0,0,0,'Shields II (76-80)',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Guns
(@Base_Entry+75,0,0,0,0,0,27822,0,0,0,'Guns',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Polearns
(@Base_Entry+76,0,0,0,0,0,27822,0,0,0,'Polearns',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Wands
(@Base_Entry+77,0,0,0,0,0,27822,0,0,0,'Wands',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Pugilats
(@Base_Entry+78,0,0,0,0,0,27822,0,0,0,'Pugilat',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- CrossBows
(@Base_Entry+79,0,0,0,0,0,27822,0,0,0,'CrossBows',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Bows
(@Base_Entry+80,0,0,0,0,0,27822,0,0,0,'Bows',@Subname_Wep_WOTLK_1,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Rare
-- AXES
(@Base_Entry+81,0,0,0,0,0,27822,0,0,0,'1H Axes',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+82,0,0,0,0,0,27822,0,0,0,'2H Axes',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- SWORDS
(@Base_Entry+83,0,0,0,0,0,27822,0,0,0,'1H Swords',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+84,0,0,0,0,0,27822,0,0,0,'2H Swords',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- MACES
(@Base_Entry+85,0,0,0,0,0,27822,0,0,0,'1H Maces',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+86,0,0,0,0,0,27822,0,0,0,'2H Maces',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Daggers
(@Base_Entry+87,0,0,0,0,0,27822,0,0,0,'Daggers',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Staves
(@Base_Entry+88,0,0,0,0,0,27822,0,0,0,'Staves',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Tome
(@Base_Entry+89,0,0,0,0,0,27822,0,0,0,'Tome',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Shield 61-65
(@Base_Entry+90,0,0,0,0,0,27822,0,0,0,'Shield I (71-75)',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Shield 66-70
(@Base_Entry+91,0,0,0,0,0,27822,0,0,0,'Shield II (76-80)',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Gun
(@Base_Entry+92,0,0,0,0,0,27822,0,0,0,'Gun',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Polearns
(@Base_Entry+93,0,0,0,0,0,27822,0,0,0,'Polearns',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Wand
(@Base_Entry+94,0,0,0,0,0,27822,0,0,0,'Wand',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Pugilat
(@Base_Entry+95,0,0,0,0,0,27822,0,0,0,'Pugilat',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- CrossBows
(@Base_Entry+96,0,0,0,0,0,27822,0,0,0,'CrossBows',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Bows
(@Base_Entry+97,0,0,0,0,0,27822,0,0,0,'Bows',@Subname_Wep_WOTLK_2,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Epic
-- AXES
(@Base_Entry+98,0,0,0,0,0,27822,0,0,0,'1H Axes',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+99,0,0,0,0,0,27822,0,0,0,'2H Axes',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- SWORDS
(@Base_Entry+100,0,0,0,0,0,27822,0,0,0,'1H Swords',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+101,0,0,0,0,0,27822,0,0,0,'2H Swords',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- MACES
(@Base_Entry+102,0,0,0,0,0,27822,0,0,0,'1H Maces',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
(@Base_Entry+103,0,0,0,0,0,27822,0,0,0,'2H Maces',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Daggers
(@Base_Entry+104,0,0,0,0,0,27822,0,0,0,'Daggers',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Staves
(@Base_Entry+105,0,0,0,0,0,27822,0,0,0,'Staves',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Tome
(@Base_Entry+106,0,0,0,0,0,27822,0,0,0,'Tome',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Shield 1-30
(@Base_Entry+107,0,0,0,0,0,27822,0,0,0,'Shield I (71-75)',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Shield 31-60
(@Base_Entry+108,0,0,0,0,0,27822,0,0,0,'Shield II (76-80)',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Gun
(@Base_Entry+109,0,0,0,0,0,27822,0,0,0,'Gun',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Polearns
(@Base_Entry+110,0,0,0,0,0,27822,0,0,0,'Polearns',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Wand
(@Base_Entry+111,0,0,0,0,0,27822,0,0,0,'Wand',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Pugilat
(@Base_Entry+112,0,0,0,0,0,27822,0,0,0,'Pugilat',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- CrossBows
(@Base_Entry+113,0,0,0,0,0,27822,0,0,0,'CrossBows',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340),
-- Bows
(@Base_Entry+114,0,0,0,0,0,27822,0,0,0,'Bows',@Subname_Wep_WOTLK_3,'',0,80,80,2,35,128,1,1.14286,1,0,0,2000,0,1,1,1,32768,2048,8,0,0,0,0,0,7,4096,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,1,1,1,1,1,0,0,1,0,0,'',12340);
-- NPC OS VENDOR
-- Heads
-- Head Cloth WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry);
INSERT INTO world.npc_vendor SELECT @Base_Entry,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 1 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Head Leather WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+1);
INSERT INTO world.npc_vendor SELECT @Base_Entry+1,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` = 1 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Head Mail WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+2);
INSERT INTO world.npc_vendor SELECT @Base_Entry+2,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` = 1 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Head Plate WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+3);
INSERT INTO world.npc_vendor SELECT @Base_Entry+3,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` = 1 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Shoulders
-- Shoulders Cloth WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+4);
INSERT INTO world.npc_vendor SELECT @Base_Entry+4,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 3 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Shoulders Leather WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+5);
INSERT INTO world.npc_vendor SELECT @Base_Entry+5,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` = 3 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Shoulders Mail WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+6);
INSERT INTO world.npc_vendor SELECT @Base_Entry+6,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` = 3 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Shoulders Plate WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+7);
INSERT INTO world.npc_vendor SELECT @Base_Entry+7,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` = 3 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Back (Cloaks)
-- Cloaks WOTLK
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+8);
INSERT INTO world.npc_vendor SELECT @Base_Entry+8,0,`entry`,0,0,0,1
FROM world.item_template WHERE `InventoryType` = 16 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Cloaks WOTLK
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+9);
INSERT INTO world.npc_vendor SELECT @Base_Entry+9,0,`entry`,0,0,0,1
FROM world.item_template WHERE `InventoryType` = 16 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Cloaks WOTLK
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+10);
INSERT INTO world.npc_vendor SELECT @Base_Entry+10,0,`entry`,0,0,0,1
FROM world.item_template WHERE `InventoryType` = 16 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Cloaks UNUSED
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+11);
INSERT INTO world.npc_vendor SELECT @Base_Entry+11,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 16 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Chests
-- Chest Cloth WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+12);
INSERT INTO world.npc_vendor SELECT @Base_Entry+12,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` in (5,20) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Chest Leather WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+13);
INSERT INTO world.npc_vendor SELECT @Base_Entry+13,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` in (5,20) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Chest Mail WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+14);
INSERT INTO world.npc_vendor SELECT @Base_Entry+14,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` in (5,20) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Chest Plate WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+15);
INSERT INTO world.npc_vendor SELECT @Base_Entry+15,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` in (5,20) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Hands
-- Hands Cloth WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+16);
INSERT INTO world.npc_vendor SELECT @Base_Entry+16,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 10 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Hands Leather WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+17);
INSERT INTO world.npc_vendor SELECT @Base_Entry+17,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` = 10 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Hands Mail WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+18);
INSERT INTO world.npc_vendor SELECT @Base_Entry+18,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` = 10 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Hands Plate WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+19);
INSERT INTO world.npc_vendor SELECT @Base_Entry+19,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` = 10 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Waist
-- Waist Cloth WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+20);
INSERT INTO world.npc_vendor SELECT @Base_Entry+20,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 6 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Waist Leather WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+21);
INSERT INTO world.npc_vendor SELECT @Base_Entry+21,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` = 6 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Waist Mail WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+22);
INSERT INTO world.npc_vendor SELECT @Base_Entry+22,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` = 6 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Waist Plate WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+23);
INSERT INTO world.npc_vendor SELECT @Base_Entry+23,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` = 6 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Legs
-- Legs Cloth WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+24);
INSERT INTO world.npc_vendor SELECT @Base_Entry+24,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 7 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Legs Leather WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+25);
INSERT INTO world.npc_vendor SELECT @Base_Entry+25,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` = 7 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Legs Mail WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+26);
INSERT INTO world.npc_vendor SELECT @Base_Entry+26,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` = 7 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Legs Plate WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+27);
INSERT INTO world.npc_vendor SELECT @Base_Entry+27,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` = 7 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Boots
-- Boots Cloth WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+28);
INSERT INTO world.npc_vendor SELECT @Base_Entry+28,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 8 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Boots Leather WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+29);
INSERT INTO world.npc_vendor SELECT @Base_Entry+29,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` = 8 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Boots Mail WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+30);
INSERT INTO world.npc_vendor SELECT @Base_Entry+30,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` = 8 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Boots Plate WOTLK 1
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+31);
INSERT INTO world.npc_vendor SELECT @Base_Entry+31,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` = 8 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- NPC OS VENDOR
-- Heads
-- Head Cloth WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+32);
INSERT INTO world.npc_vendor SELECT @Base_Entry+32,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 1 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Head Leather WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+33);
INSERT INTO world.npc_vendor SELECT @Base_Entry+33,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` = 1 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Head Mail WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+34);
INSERT INTO world.npc_vendor SELECT @Base_Entry+34,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` = 1 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Head Plate WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+35);
INSERT INTO world.npc_vendor SELECT @Base_Entry+35,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` = 1 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Shoulders
-- Shoulders Cloth WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+36);
INSERT INTO world.npc_vendor SELECT @Base_Entry+36,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 3 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Shoulders Leather WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+37);
INSERT INTO world.npc_vendor SELECT @Base_Entry+37,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` = 3 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Shoulders Mail WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+38);
INSERT INTO world.npc_vendor SELECT @Base_Entry+38,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` = 3 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Shoulders Plate WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+39);
INSERT INTO world.npc_vendor SELECT @Base_Entry+39,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` = 3 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Back (Cloaks)
-- Cloaks WOTLK
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+40);
INSERT INTO world.npc_vendor SELECT @Base_Entry+40,0,`entry`,0,0,0,1
FROM world.item_template WHERE `InventoryType` = 16 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Cloaks WOTLK
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+41);
INSERT INTO world.npc_vendor SELECT @Base_Entry+41,0,`entry`,0,0,0,1
FROM world.item_template WHERE `InventoryType` = 16 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Cloaks WOTLK
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+42);
INSERT INTO world.npc_vendor SELECT @Base_Entry+42,0,`entry`,0,0,0,1
FROM world.item_template WHERE `InventoryType` = 16 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Cloaks UNUSED
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+43);
INSERT INTO world.npc_vendor SELECT @Base_Entry+43,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 16 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Chests
-- Chest Cloth WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+44);
INSERT INTO world.npc_vendor SELECT @Base_Entry+44,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` in (5,20) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Chest Leather WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+45);
INSERT INTO world.npc_vendor SELECT @Base_Entry+45,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` in (5,20) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Chest Mail WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+46);
INSERT INTO world.npc_vendor SELECT @Base_Entry+46,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` in (5,20) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Chest Plate WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+47);
INSERT INTO world.npc_vendor SELECT @Base_Entry+47,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` in (5,20) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Hands
-- Hands Cloth WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+48);
INSERT INTO world.npc_vendor SELECT @Base_Entry+48,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 10 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Hands Leather WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+49);
INSERT INTO world.npc_vendor SELECT @Base_Entry+49,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` = 10 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Hands Mail WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+50);
INSERT INTO world.npc_vendor SELECT @Base_Entry+50,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` = 10 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Hands Plate WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+51);
INSERT INTO world.npc_vendor SELECT @Base_Entry+51,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` = 10 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Waist
-- Waist Cloth WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+52);
INSERT INTO world.npc_vendor SELECT @Base_Entry+52,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 6 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Waist Leather WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+53);
INSERT INTO world.npc_vendor SELECT @Base_Entry+53,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` = 6 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Waist Mail WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+54);
INSERT INTO world.npc_vendor SELECT @Base_Entry+54,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` = 6 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Waist Plate WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+55);
INSERT INTO world.npc_vendor SELECT @Base_Entry+55,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` = 6 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Legs
-- Legs Cloth WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+56);
INSERT INTO world.npc_vendor SELECT @Base_Entry+56,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 7 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Legs Leather WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+57);
INSERT INTO world.npc_vendor SELECT @Base_Entry+57,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` = 7 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Legs Mail WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+58);
INSERT INTO world.npc_vendor SELECT @Base_Entry+58,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` = 7 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Legs Plate WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+59);
INSERT INTO world.npc_vendor SELECT @Base_Entry+59,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` = 7 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Boots
-- Boots Cloth WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+60);
INSERT INTO world.npc_vendor SELECT @Base_Entry+60,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Cloth AND `InventoryType` = 8 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Boots Leather WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+61);
INSERT INTO world.npc_vendor SELECT @Base_Entry+61,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Leather AND `InventoryType` = 8 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Boots Mail WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+62);
INSERT INTO world.npc_vendor SELECT @Base_Entry+62,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Mail AND `InventoryType` = 8 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Boots Plate WOTLK 2
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+63);
INSERT INTO world.npc_vendor SELECT @Base_Entry+63,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Material` = @M_Plate AND `InventoryType` = 8 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` BETWEEN 3 AND 4 AND `RequiredLevel` between 71 AND 80;
-- Weapons Uncommon WOTLK
-- 1H Axes
-- One-Handed
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+64);
INSERT INTO world.npc_vendor SELECT @Base_Entry+64,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 3 AND `subclass` = 0 AND `InventoryType` in (13,14,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- 2H Axes
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+65);
INSERT INTO world.npc_vendor SELECT @Base_Entry+65,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 1 AND `Subclass` = 1 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- 1H Swords
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+66);
INSERT INTO world.npc_vendor SELECT @Base_Entry+66,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 3 AND `Subclass` = 7 AND `InventoryType` in (13,14,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- 2H Swords
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+67);
INSERT INTO world.npc_vendor SELECT @Base_Entry+67,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 1 AND `Subclass` = 8 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- 1H Maces
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+68);
INSERT INTO world.npc_vendor SELECT @Base_Entry+68,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 3 AND `Subclass` = 4 AND `InventoryType` in (13,14,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- 2H Maces
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+69);
INSERT INTO world.npc_vendor SELECT @Base_Entry+69,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 1 AND `Subclass` = 5 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Daggers
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+70);
INSERT INTO world.npc_vendor SELECT @Base_Entry+70,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 3 AND `Subclass` = 15 AND `InventoryType` IN (13,14,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Staves
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+71);
INSERT INTO world.npc_vendor SELECT @Base_Entry+71,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 2 AND `Subclass` = 10 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Tome
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+72);
INSERT INTO world.npc_vendor SELECT @Base_Entry+72,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 0 AND `InventoryType` = 23 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Shield
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+73);
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+74);
INSERT INTO world.npc_vendor SELECT @Base_Entry+73,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 4 AND `Subclass` = 6 AND `InventoryType` = 14 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 75;
INSERT INTO world.npc_vendor SELECT @Base_Entry+74,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 4 AND `Subclass` = 6 AND `InventoryType` = 14 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 75 AND 80;
-- Guns
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+75);
INSERT INTO world.npc_vendor SELECT @Base_Entry+75,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 3 AND `InventoryType` = 26 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Polearns
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+76);
INSERT INTO world.npc_vendor SELECT @Base_Entry+76,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` in (1,2) AND `Subclass` = 6 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Wands
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+77);
INSERT INTO world.npc_vendor SELECT @Base_Entry+77,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 19 AND `InventoryType` = 26 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Pugilats
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+78);
INSERT INTO world.npc_vendor SELECT @Base_Entry+78,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 7 AND `Subclass` = 13 AND `InventoryType` in (13,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- CrossBows
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+79);
INSERT INTO world.npc_vendor SELECT @Base_Entry+79,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 18 AND `InventoryType` = 26 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Bows
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+80);
INSERT INTO world.npc_vendor SELECT @Base_Entry+80,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 2 AND `InventoryType` = 15 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 2 AND `RequiredLevel` between 71 AND 80;
-- Weapons Rare WOTLK
-- 1H Axes
-- One-Handed
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+81);
INSERT INTO world.npc_vendor SELECT @Base_Entry+81,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 3 AND `subclass` = 0 AND `InventoryType` in (13,14,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- 2H Axes
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+82);
INSERT INTO world.npc_vendor SELECT @Base_Entry+82,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 1 AND `Subclass` = 1 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- 1H Swords
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+83);
INSERT INTO world.npc_vendor SELECT @Base_Entry+83,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 3 AND `Subclass` = 7 AND `InventoryType` in (13,14,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- 2H Swords
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+84);
INSERT INTO world.npc_vendor SELECT @Base_Entry+84,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 1 AND `Subclass` = 8 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- 1H Maces
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+85);
INSERT INTO world.npc_vendor SELECT @Base_Entry+85,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 3 AND `Subclass` = 4 AND `InventoryType` in (13,14,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- 2H Maces
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+86);
INSERT INTO world.npc_vendor SELECT @Base_Entry+86,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 1 AND `Subclass` = 5 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- Daggers
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+87);
INSERT INTO world.npc_vendor SELECT @Base_Entry+87,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 3 AND `Subclass` = 15 AND `InventoryType` IN (13,14,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- Staves
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+88);
INSERT INTO world.npc_vendor SELECT @Base_Entry+88,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 2 AND `Subclass` = 10 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- Tome
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+89);
INSERT INTO world.npc_vendor SELECT @Base_Entry+89,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 0 AND `InventoryType` = 23 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- Shield
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+90);
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+91);
INSERT INTO world.npc_vendor SELECT @Base_Entry+90,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 4 AND `Subclass` = 6 AND `InventoryType` = 14 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 75;
INSERT INTO world.npc_vendor SELECT @Base_Entry+91,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 4 AND `Subclass` = 6 AND `InventoryType` = 14 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 75 AND 80;
-- Guns
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+92);
INSERT INTO world.npc_vendor SELECT @Base_Entry+92,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 3 AND `InventoryType` = 26 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- Polearns
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+93);
INSERT INTO world.npc_vendor SELECT @Base_Entry+93,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` in (1,2) AND `Subclass` = 6 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- Wands
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+94);
INSERT INTO world.npc_vendor SELECT @Base_Entry+94,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 19 AND `InventoryType` = 26 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- Pugilats
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+95);
INSERT INTO world.npc_vendor SELECT @Base_Entry+95,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 7 AND `Subclass` = 13 AND `InventoryType` in (13,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- CrossBows
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+96);
INSERT INTO world.npc_vendor SELECT @Base_Entry+96,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 18 AND `InventoryType` = 26 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- Bows
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+97);
INSERT INTO world.npc_vendor SELECT @Base_Entry+97,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 2 AND `InventoryType` = 15 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 3 AND `RequiredLevel` between 71 AND 80;
-- Weapons Epic WOTLK
-- 1H Axes
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+98);
INSERT INTO world.npc_vendor SELECT @Base_Entry+98,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 3 AND `subclass` = 0 AND `InventoryType` in (13,14,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- 2H Axes
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+99);
INSERT INTO world.npc_vendor SELECT @Base_Entry+99,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 1 AND `Subclass` = 1 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- 1H Swords
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+100);
INSERT INTO world.npc_vendor SELECT @Base_Entry+100,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 3 AND `Subclass` = 7 AND `InventoryType` in (13,14,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- 2H Swords
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+101);
INSERT INTO world.npc_vendor SELECT @Base_Entry+101,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 1 AND `Subclass` = 8 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- 1H Maces
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+102);
INSERT INTO world.npc_vendor SELECT @Base_Entry+102,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 3 AND `Subclass` = 4 AND `InventoryType` in (13,14,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- 2H Maces
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+103);
INSERT INTO world.npc_vendor SELECT @Base_Entry+103,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 1 AND `Subclass` = 5 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- Daggers
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+104);
INSERT INTO world.npc_vendor SELECT @Base_Entry+104,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 3 AND `Subclass` = 15 AND `InventoryType` IN (13,14,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- Staves
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+105);
INSERT INTO world.npc_vendor SELECT @Base_Entry+105,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 2 AND `Subclass` = 10 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- Tome
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+106);
INSERT INTO world.npc_vendor SELECT @Base_Entry+106,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 0 AND `InventoryType` = 23 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- Shield
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+107);
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+108);
INSERT INTO world.npc_vendor SELECT @Base_Entry+107,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 4 AND `Subclass` = 6 AND `InventoryType` = 14 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 75;
INSERT INTO world.npc_vendor SELECT @Base_Entry+108,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 4 AND `Subclass` = 6 AND `InventoryType` = 14 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 75 AND 80;
-- Guns
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+109);
INSERT INTO world.npc_vendor SELECT @Base_Entry+109,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 3 AND `InventoryType` = 26 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- Polearns
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+110);
INSERT INTO world.npc_vendor SELECT @Base_Entry+110,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` in (1,2) AND `Subclass` = 6 AND `InventoryType` = 17 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- Wands
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+111);
INSERT INTO world.npc_vendor SELECT @Base_Entry+111,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 19 AND `InventoryType` = 26 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- Pugilats
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+112);
INSERT INTO world.npc_vendor SELECT @Base_Entry+112,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 7 AND `Subclass` = 13 AND `InventoryType` in (13,21,22) AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- CrossBows
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+113);
INSERT INTO world.npc_vendor SELECT @Base_Entry+113,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 18 AND `InventoryType` = 26 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
-- Bows
DELETE FROM world.npc_vendor WHERE (`entry`= @Base_Entry+114);
INSERT INTO world.npc_vendor SELECT @Base_Entry+114,0,`entry`,0,0,0,1
FROM world.item_template WHERE `Sheath` = 0 AND `Subclass` = 2 AND `InventoryType` = 15 AND `itemset` = 0 AND `ItemLevel` between 150 AND 284 AND `Quality` = 4 AND `RequiredLevel` between 71 AND 80;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment