Created
July 25, 2018 16:15
-
-
Save mindsear/b224a6d5a0e1b73a03bbc144cd0d63f7 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- ===================================================================================================================== -- | |
-- | |
-- [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