- 188
- 2017
- 13
- Location
- PA, USA
Many NPC's cleaned up. The two code blocks listed below do the same thing so only one need be used.
The first code block handles all the NPC ID's in two commands since there is no equipment to assigned they all get zero.
I know running commands that do things in mass can make some a little nervous and I can respect that.
The second code block lists the individual UPDATE commands for each ID along with the NPC name for those wanting to see that.
In this one there are two UPDATES for each NPC. One for the `creature_template` and the second the `creature` tables.
First Code Block
Second Code Block
The first code block handles all the NPC ID's in two commands since there is no equipment to assigned they all get zero.
I know running commands that do things in mass can make some a little nervous and I can respect that.
The second code block lists the individual UPDATE commands for each ID along with the NPC name for those wanting to see that.
In this one there are two UPDATES for each NPC. One for the `creature_template` and the second the `creature` tables.
First Code Block
Code:
-- --------------------------------------------------------------------------------------------------------------------
-- Repack version: 7.0.2
-- DBError.log Clean-up
-- Creatures that should not have equipment assigned.
-- --------------------------------------------------------------------------------------------------------------------
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` IN (3652, 5348, 5465, 8667, 9397, 10236, 10237, 10238, 22062, 32258, 32520, 35334, 38213, 38578, 38914, 38916, 38922, 38927, 39077, 40109, 40747, 40754, 40815, 40826, 40827, 41107, 41215, 41250, 41677, 41984, 42098, 43814, 43972, 43980, 44374, 44424, 44598, 44694, 44710, 44833, 44842, 44852, 44873, 45979, 46516, 46517, 46520, 46522, 46523, 46525, 46528, 46529, 46532, 46644, 46931, 47042, 47043, 47044, 47242, 47282, 47284, 47626, 47677, 48230, 48266, 48279, 48284, 48338, 48340, 48342, 48343, 48351, 48686, 48840, 49725, 49727, 49732, 49743, 49746, 49833, 49835, 49836);
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` IN (3652, 5348, 5465, 8667, 9397, 10236, 10237, 10238, 22062, 32258, 32520, 35334, 38213, 38578, 38914, 38916, 38922, 38927, 39077, 40109, 40747, 40754, 40815, 40826, 40827, 41107, 41215, 41250, 41677, 41984, 42098, 43814, 43972, 43980, 44374, 44424, 44598, 44694, 44710, 44833, 44842, 44852, 44873, 45979, 46516, 46517, 46520, 46522, 46523, 46525, 46528, 46529, 46532, 46644, 46931, 47042, 47043, 47044, 47242, 47282, 47284, 47626, 47677, 48230, 48266, 48279, 48284, 48338, 48340, 48342, 48343, 48351, 48686, 48840, 49725, 49727, 49732, 49743, 49746, 49833, 49835, 49836);Second Code Block
Code:
-- --------------------------------------------------------------------------------------------------------------------
-- Repack version: 7.0.2
-- DBError.log Clean-up
-- Creatures that should not have equipment assigned.
-- --------------------------------------------------------------------------------------------------------------------
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 3652; -- Trigore the Lasher
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 5348; -- Dreamwatcher Forktongue*<Victim of the Nightmare>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 5465; -- Land Rager
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 8667; -- Gusting Vortex
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 9397; -- Unearthed Fossil
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 10236; -- Wep
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 10237; -- Yor
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 10238; -- Staggon
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 22062; -- Dr. Whitherlimb
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 32258; -- Gold Beetle
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 32520; -- Totally Generic Bunny (All Phase)
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 35334; -- Gnome Engineer
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 38213; -- Juvenile Bloodpetal
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 38578; -- Flinn*<Marshal Expeditions Recruiter>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 38914; -- Sandstone Golem
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 38916; -- Sandstone Earthen
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 38922; -- Examiner Andoren Dawnrise*<The Reliquary>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 38927; -- Mazoga
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 39077; -- Antechamber Guardian
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 40109; -- Prospector Gunstan*<Explorer's League>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 40747; -- Selia Sunglow
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 40754; -- Tanaris Broom
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 40815; -- Fedli Caskcheer*<Food & Drink Vendor>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 40826; -- Brod Anvilbeard*<General Goods>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 40827; -- Thurda*<Flight Master>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 41107; -- Kvaldir Deepwalker
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 41215; -- Raina Sunglide*<Flight Master>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 41250; -- Azsh'ir Wave Screamer
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 41677; -- Krom'gar Grunt
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 41984; -- Clarissa
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 42098; -- Invisible Stalker (Cataclysm Boss, Ignore Combat, Floating)
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 43814; -- Lurking Worgen
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 43972; -- Cordelia Everseek*<Food & Drink>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 43980; -- Chase Everseek*<Trade Goods>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 44374; -- Sherm*<Marshal Expeditions Recruiter>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 44424; -- Naz'jar Battlemaiden
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 44598; -- Desert Bloom
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 44694; -- Noxious Tunneler
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 44710; -- Sand Kitten
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 44833; -- Adarrah
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 44842; -- Uldum Watcher [PH]
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 44852; -- Rilgiz*<Banker>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 44873; -- Buzzard
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 45979; -- General Purpose Bunny JMF
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 46516; -- Uldum Caravan Harness
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 46517; -- Lady Humps
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 46520; -- Budd
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 46522; -- Samir
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 46523; -- Mack
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 46525; -- Turgore
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 46528; -- Tanzar
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 46529; -- Kurzel
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 46532; -- Adarrah's Camel
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 46644; -- Peregrine Statue
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 46931; -- Star Fire Bunny
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 47042; -- Porsha Brassbearing
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 47043; -- Lixi Greasenozzle
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 47044; -- Lamba Ginwhistle
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 47242; -- General Purpose Bunny JMF (Look 2)
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 47282; -- Fire Blossom Bunny
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 47284; -- Frost Blossom Bunny
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 47626; -- Admiral Ripsnarl
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 47677; -- General Purpose Bunny JMF (Look 3)
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 48230; -- Ogre Henchman
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 48266; -- Defias Cannon
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 48279; -- Goblin Overseer
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 48284; -- Mining Powder
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 48338; -- Mine Bunny*<Refreshments>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 48340; -- Drink Tray
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 48342; -- Goblin Cocktail
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 48343; -- Goblin Cocktail
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 48351; -- Mine Bunny*<Refreshments>
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 48686; -- Rattlesnake
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 48840; -- Barley H. Crown
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 49725; -- Emerald Boa
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 49727; -- Sidewinder
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 49732; -- Horned Lizard
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 49743; -- Dung Beetle
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 49746; -- Scarab Hatchling
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 49833; -- Stripe-Tailed Scorpid
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 49835; -- Desert Spider
UPDATE `creature_template` SET `equipment_id` = 0 WHERE `entry` = 49836; -- Stinkbug
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 3652; -- Trigore the Lasher
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 5348; -- Dreamwatcher Forktongue*<Victim of the Nightmare>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 5465; -- Land Rager
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 8667; -- Gusting Vortex
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 9397; -- Unearthed Fossil
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 10236; -- Wep
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 10237; -- Yor
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 10238; -- Staggon
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 22062; -- Dr. Whitherlimb
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 32258; -- Gold Beetle
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 32520; -- Totally Generic Bunny (All Phase)
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 35334; -- Gnome Engineer
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 38213; -- Juvenile Bloodpetal
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 38578; -- Flinn*<Marshal Expeditions Recruiter>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 38914; -- Sandstone Golem
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 38916; -- Sandstone Earthen
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 38922; -- Examiner Andoren Dawnrise*<The Reliquary>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 38927; -- Mazoga
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 39077; -- Antechamber Guardian
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 40109; -- Prospector Gunstan*<Explorer's League>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 40747; -- Selia Sunglow
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 40754; -- Tanaris Broom
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 40815; -- Fedli Caskcheer*<Food & Drink Vendor>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 40826; -- Brod Anvilbeard*<General Goods>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 40827; -- Thurda*<Flight Master>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 41107; -- Kvaldir Deepwalker
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 41215; -- Raina Sunglide*<Flight Master>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 41250; -- Azsh'ir Wave Screamer
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 41677; -- Krom'gar Grunt
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 41984; -- Clarissa
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 42098; -- Invisible Stalker (Cataclysm Boss, Ignore Combat, Floating)
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 43814; -- Lurking Worgen
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 43972; -- Cordelia Everseek*<Food & Drink>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 43980; -- Chase Everseek*<Trade Goods>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 44374; -- Sherm*<Marshal Expeditions Recruiter>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 44424; -- Naz'jar Battlemaiden
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 44598; -- Desert Bloom
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 44694; -- Noxious Tunneler
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 44710; -- Sand Kitten
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 44833; -- Adarrah
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 44842; -- Uldum Watcher [PH]
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 44852; -- Rilgiz*<Banker>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 44873; -- Buzzard
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 45979; -- General Purpose Bunny JMF
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 46516; -- Uldum Caravan Harness
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 46517; -- Lady Humps
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 46520; -- Budd
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 46522; -- Samir
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 46523; -- Mack
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 46525; -- Turgore
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 46528; -- Tanzar
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 46529; -- Kurzel
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 46532; -- Adarrah's Camel
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 46644; -- Peregrine Statue
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 46931; -- Star Fire Bunny
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 47042; -- Porsha Brassbearing
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 47043; -- Lixi Greasenozzle
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 47044; -- Lamba Ginwhistle
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 47242; -- General Purpose Bunny JMF (Look 2)
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 47282; -- Fire Blossom Bunny
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 47284; -- Frost Blossom Bunny
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 47626; -- Admiral Ripsnarl
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 47677; -- General Purpose Bunny JMF (Look 3)
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 48230; -- Ogre Henchman
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 48266; -- Defias Cannon
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 48279; -- Goblin Overseer
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 48284; -- Mining Powder
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 48338; -- Mine Bunny*<Refreshments>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 48340; -- Drink Tray
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 48342; -- Goblin Cocktail
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 48343; -- Goblin Cocktail
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 48351; -- Mine Bunny*<Refreshments>
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 48686; -- Rattlesnake
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 48840; -- Barley H. Crown
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 49725; -- Emerald Boa
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 49727; -- Sidewinder
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 49732; -- Horned Lizard
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 49743; -- Dung Beetle
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 49746; -- Scarab Hatchling
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 49833; -- Stripe-Tailed Scorpid
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 49835; -- Desert Spider
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 49836; -- Stinkbug