Thread: [MaNGOS] Icecrown Citadel 25-man Heroic Item Vendor

Arcemu:

Code:

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) 
values ('56011', "Bro-ham", "Icecrown 25-man Heroic Items", '', '0', '10', '0', '3', '0', '0', '30226', '0', '0', '0', '1', '1', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`, `summonguard`) 
values ('56011', '80', '80', '7', '11770', '11770', '', '1', '129', '1000', '0', '322', '483', '0', '0', '0', '0', '30000', '8219', '0', '0', '0', '0', '0', '0', '0', '0', "0", '0', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES 
(56011, 50172, 1),
(56011, 50176, 1),
(56011, 50364, 1),
(56011, 50365, 1),
(56011, 50605, 1),
(56011, 50606, 1),
(56011, 50608, 1),
(56011, 50610, 1),
(56011, 50612, 1),
(56011, 50614, 1),
(56011, 50615, 1),
(56011, 50617, 1),
(56011, 50621, 1),
(56011, 50623, 1),
(56011, 50624, 1),
(56011, 50625, 1),
(56011, 50626, 1),
(56011, 50627, 1),
(56011, 50629, 1),
(56011, 50631, 1),
(56011, 50633, 1),
(56011, 50635, 1),
(56011, 50636, 1),
(56011, 50638, 1),
(56011, 50641, 1),
(56011, 50642, 1),
(56011, 50643, 1),
(56011, 50644, 1),
(56011, 50645, 1),
(56011, 50648, 1),
(56011, 50651, 1),
(56011, 50652, 1),
(56011, 50653, 1),
(56011, 50654, 1),
(56011, 50655, 1),
(56011, 50656, 1),
(56011, 50657, 1),
(56011, 50659, 1),
(56011, 50663, 1),
(56011, 50664, 1),
(56011, 50667, 1),
(56011, 50674, 1),
(56011, 50676, 1),
(56011, 50677, 1),
(56011, 50678, 1),
(56011, 50679, 1),
(56011, 50680, 1),
(56011, 50685, 1),
(56011, 50688, 1),
(56011, 50693, 1),
(56011, 50694, 1),
(56011, 50696, 1),
(56011, 50697, 1),
(56011, 50698, 1),
(56011, 50699, 1),
(56011, 50700, 1),
(56011, 50702, 1),
(56011, 50703, 1),
(56011, 50704, 1),
(56011, 50705, 1),
(56011, 50706, 1),
(56011, 50708, 1),
(56011, 50710, 1),
(56011, 50711, 1),
(56011, 50713, 1),
(56011, 50714, 1),
(56011, 50717, 1),
(56011, 50718, 1),
(56011, 50719, 1),
(56011, 50720, 1),
(56011, 50722, 1),
(56011, 50723, 1),
(56011, 50728, 1),
(56011, 50729, 1),
(56011, 52025, 1),
(56011, 52026, 1),
(56011, 52028, 1),
(56011, 52029, 1);