All pastes #1210504 Raw Edit

Mine

public text v1 · immutable
#1210504 ·published 2008-09-25 11:28 UTC
rendered paste body
-- Vol'jin UPDATE `creature_template` SET `minhealth` = 600000, `maxhealth` = 600000, `rank` = 3 WHERE `entry` = 10540;
UPDATE `creature` SET `curhealth` = 600000 WHERE `guid` = 3394;

-- Sylvanas UPDATE `creature_template` SET `minhealth` = 670000, `maxhealth` = 670000 WHERE `entry` = 10181;
UPDATE `creature` SET `curhealth` = 670000 WHERE `guid` = 32039;

-- Varimathras UPDATE `creature_template` SET `minhealth` = 80000, `maxhealth` = 80000, `rank` = 3, `spell1` = 20743, `spell2` = 20741 WHERE `entry` = 2425;
UPDATE `creature` SET `curhealth` = 80000 WHERE `guid` = 31901;

-- Vol'jin UPDATE `creature_template` SET `minhealth` = 600000, `maxhealth` = 600000, `rank` = 3 WHERE `entry` = 10540;
UPDATE `creature` SET `curhealth` = 600000 WHERE `guid` = 3394;

-- Highlord Bolvar Fordragon
UPDATE `creature_template` SET `spell1` = 20684, `spell2` = 15062, `spell3` = 20683, `spell4` = 0 WHERE `entry` = 1748;

-- Stormwind Royal Guard
UPDATE `creature_template` SET `maxlevel` = 65, `spell1` = 15284, `spell2` = 15655, `spell3` = 16145, `spell4` = 8269 WHERE `entry` = 1756;

-- General Marcus Jonathan
UPDATE `creature_template` SET `minhealth` = 43000, `maxhealth` = 43000 WHERE `entry` = 466;
UPDATE `creature` SET `curhealth` = 43000 WHERE `guid` = 79677;

-- Swamp Gas
UPDATE `creature_template` SET `armor`= 0, `mindmg` = 0, `maxdmg` = 0, `attackpower` = 0, `minrangedmg` = 0, `maxrangedmg` = 0, `type` = 13 WHERE `entry` = 17378;

-- Aldor Gryphon Guard
UPDATE `creature_template` SET `InhabitType` = 4 WHERE `entry` = 22077;

-- Vilewing Chimaera
UPDATE `creature_template` SET `InhabitType` = 4 WHERE `entry` = 21879;

-- Uvuros
UPDATE `creature_template` SET `minhealth` = 69000, `maxhealth` = 69000, `spell1` = 38361, `spell2` = 37939 WHERE `entry` = 21102;
UPDATE `creature` SET `curhealth` = 69000 WHERE `guid` = 74137;

-- Wing Commander Brack
UPDATE `creature_template` SET `npcflag` = 3 WHERE `entry` = 19401;

-- Apothecary Albreck
UPDATE `creature_template` SET `MovementType` = 0 WHERE `entry` = 21279;
UPDATE `creature` SET `spawndist` = 0 WHERE `guid` = 74544;

-- Ogri'la Peacekeeper
UPDATE `creature_template` SET `minlevel` = 71, `maxlevel` = 73, `minhealth` = 6900, `maxhealth` = 7500, `faction_A` = 1872, `faction_H` = 1872, `speed` = 1.2, `mindmg` = 450, `maxdmg` = 850, `attackpower` = 1800, `baseattacktime` = 2 WHERE `entry` = 23115;
UPDATE `creature` SET `curhealth` = 6900 WHERE `id` = 23115;

-- Tork
UPDATE `creature_template` SET `minlevel` = 65, `maxlevel` = 65, `minhealth` = 5200, `maxhealth` = 5200, `faction_A` = 1872, `faction_H` = 1872, `mindmg` = 300, `maxdmg` = 500, `attackpower` = 1300, `rangeattacktime` = 2, `ScriptName` = '' WHERE `entry` = 23347;
UPDATE `creature` SET `curhealth` = 5200 WHERE `guid` = 91788;

-- Torkus
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 70, `minhealth` = 7800, `maxhealth` = 7800, `faction_A` = 1872, `faction_H` = 1872, `ScriptName` = '' WHERE `entry` = 23316;
UPDATE `creature` SET `curhealth` = 7800 WHERE `guid` = 91793;

-- Gahk
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 70, `minhealth` = 100000, `maxhealth` = 100000, `faction_A` = 1872, `faction_H` = 1872, `ScriptName` = '' WHERE `entry` = 23300;
UPDATE `creature` SET `curhealth` = 100000 WHERE `guid` = 91791;

-- Torkus Jr.
UPDATE `creature_template` SET `minlevel` = 65, `maxlevel` = 65, `minhealth` = 3600, `maxhealth` = 3600, `faction_A` = 1872, `faction_H` = 1872 WHERE `entry` = 23365;
UPDATE `creature` SET `curhealth` = 3600 WHERE `guid` = 91794;

-- Kronk
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 70, `minhealth` = 6900, `maxhealth` = 6900, `faction_A` = 1872, `faction_H` = 1872, `ScriptName` = '' WHERE `entry` = 23253;
UPDATE `creature` SET `curhealth` = 6900 WHERE `guid` = 91790;

-- Torki
UPDATE `creature_template` SET `minlevel` = 65, `maxlevel` = 65, `minhealth` = 11000, `maxhealth` = 11000, `faction_A` = 1872, `faction_H` = 1872, `ScriptName` = '' WHERE `entry` = 23362;
UPDATE `creature` SET `curhealth` = 11000 WHERE `guid` = 91789;

-- Ogri'la Storyteller
UPDATE `creature_template` SET `minlevel` = 71, `maxlevel` = 73, `minhealth` = 5900, `maxhealth` = 6400, `faction_A` = 1872, `faction_H` = 1872, `ScriptName` = '' WHERE `entry` = 23256;
UPDATE `creature` SET `curhealth` = 5900 WHERE `guid` = 91792;