Kaiza
05-30-2009, 09:13 AM
http://pastebin.com/m241822c6]
Script was too long so here is pastebin :)
SQL for fireworks:
INSERT INTO `gameobject_names` (entry, `Type`, DisplayID, Name, spellfocus, sound1, sound2 , sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14)
VALUES (19993, 5, 6859, "Fireworks Galore!", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
SQL for mob:
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
values ('22898', "Fearbringer", "Cinematic", '', '0', '5', '0', '3', '0', '0', '26497', '0', '0', '0', '1', '1', '0', '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`)
values ('22898', '350', '350', '14', '1200000', '1200000', '1600', '1', '0', '2000', '0', '6000', '12000', '0', '0', '0', '0', '300000', '6000', '2000', '2000', '2000', '2000', '2000', '2000', '0', '0', "0", '1', '6000000', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');
THIS IS ORIGINALY CREATED BY Nymphx FROM MMO.....
This fight is great :) go go go use it he was 1st place on contest!!
Script was too long so here is pastebin :)
SQL for fireworks:
INSERT INTO `gameobject_names` (entry, `Type`, DisplayID, Name, spellfocus, sound1, sound2 , sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14)
VALUES (19993, 5, 6859, "Fireworks Galore!", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
SQL for mob:
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
values ('22898', "Fearbringer", "Cinematic", '', '0', '5', '0', '3', '0', '0', '26497', '0', '0', '0', '1', '1', '0', '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`)
values ('22898', '350', '350', '14', '1200000', '1200000', '1600', '1', '0', '2000', '0', '6000', '12000', '0', '0', '0', '0', '300000', '6000', '2000', '2000', '2000', '2000', '2000', '2000', '0', '0', "0", '1', '6000000', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');
THIS IS ORIGINALY CREATED BY Nymphx FROM MMO.....
This fight is great :) go go go use it he was 1st place on contest!!