[Release] Lua Cinematic then Boss

[Dynashock]

Yet another great release by you, Stoneharry. This is the stuff I want to see, it's inspiring. +rep

[Linkn]

I know I already commented on this but I hate that its below all the repacks and such. People need to see this script.

[thebigman]

Introduction

Very basically this is a Lua cinematic that occours in a hidden section of Dun'morgh (cant spell) near Ironforge which involves lots of emotes and visuals etc. After that The Lich King will kill all of your people and summon a boss, and then he will teleport away leaving you to fight the boss. Once the boss is dead or you wipe againts him, he will despawn and it can be restarted. You can add loot if you want.

- 5-10 people needed
- Lua cinematic is about 3mins long
- Boss fight cant be solo'd since he knocks the tank away
- Enjoy

Instructions:

- Put the script relevent to you into your scripts folder.
- Execute the sql that is relevent to you.
- Restart your server.
- Do .recall port cinematic

Video

Please watch the video in HQ... makes it so you can actually read it

[yt]<object width="640" height="505"><param name="movie" value="http://www.youtube.com/v/o6wTAiz9BwA&hl=en&fs=1&color1=0x5d1719&color2=0xcd311b"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/o6wTAiz9BwA&hl=en&fs=1&color1=0x5d1719&color2=0xcd311b" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="640" height="505"></embed></object>[/yt]

Script

LuaAppArc

Used pastebin because script is to long. See Link!
Click Here

GuaEngine

Used pastebin because script is to long. See Link!
Click Here

Sql

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('500000','Soldier','The Korin','','0','7','0','1','0','0','24195','21493','21497','21498','1','1',NULL,NULL);
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('500001','Soldier','The Korin','','0','7','0','1','0','0','24195','21493','21497','21498','1','1',NULL,NULL);
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('500002','Soldier','The Korin','','0','7','0','1','0','0','24195','21493','21497','21498','1','1',NULL,NULL);
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('500003','Soldier','The Korin','','0','7','0','1','0','0','24195','21493','21497','21498','1','1',NULL,NULL);
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('500004','General Fern','The Korin','','0','7','0','2','0','0','23418','23418','0','0','1','1',NULL,NULL);
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('500005','Scouter Dom','The Korin','','0','7','0','4','0','0','23491','23491','0','0','1','1',NULL,NULL);
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('500006','Plague','The Scourge','','0','0','0','3','0','0','10815','10815','0','0','1','1',NULL,NULL);
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('500007','The Lich King','','','0','0','0','3','0','0','22234','22234','0','0','1','1',NULL,NULL);
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('500008','Grobulus','','','0','5','0','3','0','0','23890','23890','0','0','1','1',NULL,NULL);
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('500009','Ghoul','Minion of Grobulus','','0','0','0','1','0','0','25000','25001','0','0','1','1',NULL,NULL);
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('500009','80','80','20','100000','100000','0','1','0','1500','0','500','2000','0','0','0','0','0','100','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0','0','0','0','0','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('500008','83','83','35','1000000','1000000','500000','1','0','1500','0','2333','7873','0','0','0','0','0','5533','0','0','0','0','0','0','1','1','0','1','337333','0','0','2.5','8','14','0','0','0','0','0','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('500007','83','83','35','9000000','52000000','888222','1.5','0','1500','0','5000','9000','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','1','0','0','0','2.5','8','14','0','0','0','0','0','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('500006','99','99','35','111111','111111111','0','1','0','1400','0','50','500','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','2.5','2.5','0','0','0','0','0','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('500005','77','77','35','2000','2000','0','1','1','1500','0','50','500','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','8','8','14','0','0','0','0','0','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('500004','83','83','35','100000','100000','0','1.3','0','1500','0','5000','7500','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','1','0','0','0','2.5','8','14','0','0','0','0','0','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('500003','80','81','35','50000','60000','0','1','0','1500','0','2500','3744','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0','0','0','0','0','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('500002','80','81','35','50000','60000','0','1','0','1500','0','2500','3744','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0','0','0','0','0','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('500001','80','81','35','50000','60000','0','1','0','1500','0','2500','3744','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0','0','0','0','0','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('500000','80','81','35','50000','60000','0','1','0','1500','0','2500','3744','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0','0','0','0','0','0','0');
insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`) values('15115555','500000','0','-4757.86','603.368','401.697','0.0581299','0','21493','35','0','65536','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`) values('15115556','500001','0','-4754.74','604.738','401.088','3.52016','0','21498','35','0','65536','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`) values('15115557','500002','0','-4742.04','603.646','400.714','2.14842','0','24195','35','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`) values('15115558','500003','0','-4743.65','605.875','400.614','5.32143','0','21498','35','0','65536','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`) values('15115564','500005','0','-4747.93','594.872','401.233','1.21836','0','23491','35','0','65536','0','0','0','0','0','0','0','0','0','4947','0','0');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('5999','cinematic','0','-4746.01','596.034','410.238');

If that doesn't work and you really want it do this:

replace 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('500000','Soldier','The Korin','','0','7','0','1','0','0','24195','21493','21497','21498','1','1',NULL,NULL);
replace 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('500001','Soldier','The Korin','','0','7','0','1','0','0','24195','21493','21497','21498','1','1',NULL,NULL);
replace 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('500002','Soldier','The Korin','','0','7','0','1','0','0','24195','21493','21497','21498','1','1',NULL,NULL);
replace 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('500003','Soldier','The Korin','','0','7','0','1','0','0','24195','21493','21497','21498','1','1',NULL,NULL);
replace 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('500004','General Fern','The Korin','','0','7','0','2','0','0','23418','23418','0','0','1','1',NULL,NULL);
replace 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('500005','Scouter Dom','The Korin','','0','7','0','4','0','0','23491','23491','0','0','1','1',NULL,NULL);
replace 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('500006','Plague','The Scourge','','0','0','0','3','0','0','10815','10815','0','0','1','1',NULL,NULL);
replace 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('500007','The Lich King','','','0','0','0','3','0','0','22234','22234','0','0','1','1',NULL,NULL);
replace 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('500008','Grobulus','','','0','5','0','3','0','0','23890','23890','0','0','1','1',NULL,NULL);
replace 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('500009','Ghoul','Minion of Grobulus','','0','0','0','1','0','0','25000','25001','0','0','1','1',NULL,NULL);
replace 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('500009','80','80','20','100000','100000','0','1','0','1500','0','500','2000','0','0','0','0','0','100','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0','0','0','0','0','0','0');
replace 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('500008','83','83','35','1000000','1000000','500000','1','0','1500','0','2333','7873','0','0','0','0','0','5533','0','0','0','0','0','0','1','1','0','1','337333','0','0','2.5','8','14','0','0','0','0','0','0','0');
replace 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('500007','83','83','35','9000000','52000000','888222','1.5','0','1500','0','5000','9000','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','1','0','0','0','2.5','8','14','0','0','0','0','0','0','0');
replace 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('500006','99','99','35','111111','111111111','0','1','0','1400','0','50','500','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','2.5','2.5','0','0','0','0','0','0','0');
replace 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('500005','77','77','35','2000','2000','0','1','1','1500','0','50','500','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','8','8','14','0','0','0','0','0','0','0');
replace 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('500004','83','83','35','100000','100000','0','1.3','0','1500','0','5000','7500','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','1','0','0','0','2.5','8','14','0','0','0','0','0','0','0');
replace 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('500003','80','81','35','50000','60000','0','1','0','1500','0','2500','3744','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0','0','0','0','0','0','0');
replace 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('500002','80','81','35','50000','60000','0','1','0','1500','0','2500','3744','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0','0','0','0','0','0','0');
replace 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('500001','80','81','35','50000','60000','0','1','0','1500','0','2500','3744','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0','0','0','0','0','0','0');
replace 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('500000','80','81','35','50000','60000','0','1','0','1500','0','2500','3744','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0','0','0','0','0','0','0');
replace into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`) values('15115555','500000','0','-4757.86','603.368','401.697','0.0581299','0','21493','35','0','65536','0','0','0','0','0','0','0','0','0','0','0','0');
replace into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`) values('15115556','500001','0','-4754.74','604.738','401.088','3.52016','0','21498','35','0','65536','0','0','0','0','0','0','0','0','0','0','0','0');
replace into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`) values('15115557','500002','0','-4742.04','603.646','400.714','2.14842','0','24195','35','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
replace into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`) values('15115558','500003','0','-4743.65','605.875','400.614','5.32143','0','21498','35','0','65536','0','0','0','0','0','0','0','0','0','0','0','0');
replace into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`) values('15115564','500005','0','-4747.93','594.872','401.233','1.21836','0','23491','35','0','65536','0','0','0','0','0','0','0','0','0','4947','0','0');
replace into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('5999','cinematic','0','-4746.01','596.034','410.238');

Credits

- Me
- A few random people for ideas


Note: This was setup for ArcEmu, NCDB. If you get errors with the Lua or Sql you will need to convert it.

sucks lol. the aspire repack you made doesn't even work with your own script. which btw you said it would, uses the gua engine,

lol the DB doesn't even support the line "can_ranged"

thanks but nothanks.

[Linkn]

Note: This was setup for ArcEmu, NCDB. If you get errors with the Lua or Sql you will need to convert it.

Good going.

[stoneharry]

The reason you get errors with Aspire thebigman is because you don't understand Aspire's support. In 3.1 their Lua compatability doesn't actually work, it's not me it's you in other words. The GuaEngine is not only compatable with Aspire or even made for it, infact it is also compatable with ArcEmu. Sun++ is the officially supporter of Aspire and you should try them and learn a bit about Lua before saying how noob my script is
Also don't quote the whole thread... Thanks for all the other comments but again, don't bump this please.

[thebigman]

Good going.

and how does one convert it? compiling it was confusing as hell for me. So thats out of the picure. (cant find win file or w/e) so do tell how one converts.


Edit: I appologize I didn't mean to for it to look like the script is noob, I love it and edited to make it slightly better for me, I am just really frustrated when i work with emu shit. I always get and error and never get an easy break.

also I cannot find an arc emu repack, nor can compile one of my own. too many errors.

[stoneharry]

Compiling is one of those things that when you get it, you'll never forget it.
And the only differences in the "GuaEngine" script and the "LuaAppArc" script is that the GuaEngine uses a different spawn syntex.
Basically in LuaAppArc:
:SpawnCreature(id, x, y, z, o, faction, timer)
GuaEngine:
:SpawnCreature(id, x, y, z, o, faction, timer, left hand item, right hand item, bow)

[thebigman]

So what should I use for the vampirism repack V5? I don't think it has gua but does that mean it has to have LuaAppArc?

[thebigman]

[stoneharry]

That means it works fine - if you get a problem then it's the Lua engine. I cant do anything about that and I advice you ask some friends if you cant find how to get Lua working. Also don't double post

[Blackboy0]

Compiling is one of those things that when you get it, you'll never forget it.
And the only differences in the "GuaEngine" script and the "LuaAppArc" script is that the GuaEngine uses a different spawn syntex.
Basically in LuaAppArc:
:SpawnCreature(id, x, y, z, o, faction, timer)
GuaEngine:
:SpawnCreature(id, x, y, z, o, faction, timer, left hand item, right hand item, bow)

Actually, I believe that HalestormXV of LuAppArc implemented that feature, so left hand, right hand, bow is also in LuAppArc, included in the latest versions.

[Morsicle]

It's not that hard to get it working. You just have to convert the SQL according to your DB, or simply make the SQL manually for the NPC's that you need for the LUA script. I have taken this script, and given it to my DB/LUA Surgeon, and he just got everything working for us so.........

It's definitely something that works. Nice work Stoneharry.

[palkiake]

Hey, awesome script +rep x5 for you stoneharry, but i cant get it to work? What have i done wrong, i savd the scripts as lua's in my scripts folder and executed the second sql lines and the guys are spawned but when i talk to that 1 guy he doesnt gimme a menu. How can i fix this?

[stoneharry]

Hey, awesome script +rep x5 for you stoneharry, but i cant get it to work? What have i done wrong, i savd the scripts as lua's in my scripts folder and executed the second sql lines and the guys are spawned but when i talk to that 1 guy he doesnt gimme a menu. How can i fix this?

Ermm, I'm guessing your Lua engine is screwed up then if there were no problems setting it up. If using ArcEmu get LuaAppArc (found in general discussions of Lua stickied on there homepage) or the GuaEngine (found on first/second page on here) and if you use Aspire, GuaEngine again, but make sure you use 3.0.9 or 3.1.x branch depending on what you need. If you still have problems after that tell me

[palkiake]

I dont think theres anything wrong with my lua engine (what that might be xD) because it loads ur other scripted cinematic boss fight (the 1 in ironforge).