Epic Bossbattle

[Fugunsk]

Video good thing as useless ... SQL files or bad!

[friskey4u]

-- Hand of Itharius
INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `civilian`, `leader`)
VALUES ('479', 'Hand of Itharius', '', '', '7', '0', '1', '20381', '0', '0', '0', '0', NULL);
INSERT INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `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`)
VALUES ('479', '92', '92', '1720', '257876', '257876', '0', '1', '0', '1500', '3000', '4000', '0', '0', '0', '45600', '0', '0', '0', '0', '0', '0', '0', '2', '1', '0', '0', '0', '0', '0', '2.5', '8', '14');


-- Hand of Itharius Alternative
INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `civilian`, `leader`)
VALUES ('455', 'Hand of Itharius', '', '', '7', '0', '1', '20381', '0', '0', '0', '0', NULL);
INSERT INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `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`)
VALUES ('455', '92', '92', '1720', '257876', '257876', '0', '1', '0', '1500', '3000', '4000', '0', '0', '0', '45600', '0', '0', '0', '0', '0', '0', '0', '2', '1', '0', '0', '0', '0', '0', '2.5', '8', '14');


-- Portal Event
INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `civilian`, `leader`)
VALUES ('457', 'Portal', '', '', '10', '0', '0', '9510', '0', '0', '0', '0', NULL);
INSERT INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `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`)
VALUES ('457', '80', '80', '35', '90000', '90000', '0', '2', '0', '1630', '77', '99.33', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '2.5', '8', '14');


-- Demonic Minion
INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `civilian`, `leader`)
VALUES ('463', 'Demonic Minion', 'Slave of Itharius', '', '3', '0', '1', '10992', '0', '0', '0', '0', NULL);
INSERT INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `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`)
VALUES ('463', '90', '93', '1394', '36344', '40423', '0', '4', '0', '1800', '2829', '3974', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '5', '0', '0', '0', '0', '0', '4', '12', '14');


-- Demonic Stalker
INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `civilian`, `leader`)
VALUES ('477', 'Demonic Stalker', 'Slave of Itharius', '', '3', '0', '1', '10993', '0', '0', '0', '0', NULL);
INSERT INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `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`)
VALUES ('477', '90', '93', '1394', '26344', '30423', '23456', '5', '0', '1800', '2829', '3974', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '5', '0', '0', '0', '0', '0', '4', '12', '14');



-- Demonic Warrior
INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `civilian`, `Leader`)
VALUES ('484', 'Demonic Warrior', 'Slave of Itharius', '', '3', '0', '1', '15301', '0', '0', '0', '0', NULL);
INSERT INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `Faction`, `minhealth`, `maxhealth`, `mana`, `Scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `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`)
VALUES ('484', '93', '96', '1394', '46344', '50423', '0', '0.5', '0', '1400', '2829', '3974', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '5', '0', '0', '0', '0', '0', '4', '12', '14');


-- Itharius
INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `civilian`, `leader`)
VALUES ('425', 'Itharius Dawnstrider', '', '', '10', '0', '3', '22586', '0', '0', '0', '0', '1');
INSERT INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `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`)
VALUES ('425', '96', '96', '1394', '3400000', '3400000', '100', '1.6', '0', '1600', '2435', '4325', '0', '0', '0', '36000', '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '0', '2.5', '12', '14');








UPDATE `creature_names` SET `name` = 'Itharius Dawnstrider', `subname` = '', `info_str` = '', `type` = '10', `family` = '0', `rank` = '3', `male_displayid` = '22586', `female_displayid` = '0', `male_displayid2` = '0', `female_displayid2` = '0', `civilian` = '0', `leader` = '1' WHERE `entry` = '425' LIMIT 1;
UPDATE `creature_proto` SET `minlevel` = '96', `maxlevel` = '96', `faction` = '1394', `minhealth` = '2000000', `maxhealth` = '2000000', `mana` = '2452000', `scale` = '1.6', `npcflags` = '0', `attacktime` = '1600', `mindamage` = '2435', `maxdamage` = '4325', `rangedattacktime` = '0', `rangedmindamage` = '0', `rangedmaxdamage` = '0', `respawntime` = '56000', `armor` = '1253', `resistance1` = '0', `resistance2` = '0', `resistance3` = '0', `resistance4` = '0', `resistance5` = '0', `resistance6` = '0', `combat_reach` = '2', `bounding_radius` = '0', `auras` = '0', `boss` = '1', `money` = '0', `invisibility_type` = '0', `death_state` = '0', `walk_speed` = '2.5', `run_speed` = '12', `fly_speed` = '14' WHERE `entry` = 425 LIMIT 1;

That SQL works with the Latest of ArcEmu.
Rev. 2074 and up

[alj03]

Nice +1 rep if i can!

[Exacute]

Hale you for once made my day +rep x2

[ViV09]

Cool One

[Sandile]

10 minutes video... I couldn't see much for sure.. but thats the wow video quality :P, we never see the videos xD.
Maby you could explain what it does in text? Anyways +Rep

[bill45]

This is a great script and great video of the battle +Repx2 rep if it was possible. Not allowed to I guess :/

[Coffzor]

Dude, I'm going to say this as simple i can, THIS IS F**KING EPIC! I want this as a sticky in the Release Section - Gastric or Hellgawd, Could you please make this as a Sticky? Its Epixx

Edit:

Edit: Cannot give Rep to this post?!?!?! WTF

[slipknot33]

That is a fu**in Lua boss script =) Great work!

Continue dud!

[xX EPIC Xx]

nice +rep x2

[Hardball]

Wow I didn't know this was still popluar hehe. Well since it is mine as well give an update for efficiency. Scroll threw the script and in all the section where it says abilities for example you have:

fAgony = 40932

just put the word local in front of it so you will have:

local fAgony = 40932

Reason for this is because without the word local it is a global variable that can be called from other scripts. However with the word local it is used strictly in that script and that script alone. Just a heads up. It is optional you don't have to do it. But for all you code peeps out there who like efficiency that will help a tad.