Sorry but i like to play, so i suggest to put inside some things which could run into my mind, and God knows how many we are in my mind
Because it isn't a fix to EC "official", i won't link this post in my profile... at least, for the moment (and because there aren't not yet enought as a "real" event)
Because it isn't a fix to EC "official", i won't link this post in my profile... at least, for the moment (and because there aren't not yet enought as a "real" event)
Code:
-- Notebook of Titesusy, 2019.03.04
SET @my_Balafre_id = 6850; -- creature_template free
SET @my_Balafre_guid = 23100; -- creature free
SET @my_scale = 2;
SET @my_level = 30;
SET @my_damage = 150;
-- Templates of creatures
DELETE FROM creature_template WHERE entry IN ( @my_Balafre_id );
INSERT INTO creature_template (entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname,
IconName, gossip_menu_id, minlevel, maxlevel, `exp`, exp_unk, faction_A, faction_H, npcflag, speed_walk, speed_run, speed_swim, speed_fly, scale, rank, mindmg, maxdmg,
dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class,
trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, type_flags2, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4,
resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, currencyId, currencyCount, AIName, MovementType,
InhabitType, HoverHeight, Health_mod, Mana_mod, Mana_mod_extra, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6,
movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName, WDBVerified) VALUES
(@my_Balafre_id ,'0','0','0','0','0','12818','0','0','0','Stitches','Gift from the Embalmer','','0', @my_level , @my_level ,'0','0','14','35','0','0.75','1','0.75','1.14286', @my_scale ,'1','30', @my_damage ,'0','24','1','2000','2000','1','8','2048','0','0','0','0','0','0','1','1','0','6','0','0', @my_Balafre_id ,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','182','182','','','SmartAI','0','3','0','5','1','1','7000','0','0','0','0','0','0','0','0','1','0','0','0','','13623');
-- Move...
DELETE FROM creature_addon WHERE guid = @my_Balafre_guid;
INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (@my_Balafre_guid, @my_Balafre_guid * 10);
DELETE FROM waypoint_data WHERE ( id = @my_Balafre_guid * 10 );
INSERT INTO waypoint_data (id, point, position_x, position_y, position_z, orientation, delay, move_type, action, action_chance, inverse_formation_angle, wpguid) VALUES
(@my_Balafre_guid * 10 ,'1','-10754.6','63.3186','28.4363','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'2','-10781','2.29319','29.7349','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'3','-10808.2','-86.9689','29.2709','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'4','-10836.7','-165.631','33.8208','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'5','-10850.3','-224.076','38.0416','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'6','-10867.7','-297.367','37.9755','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'7','-10891.3','-348.298','38.8906','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'8','-10911.5','-360.375','39.5574','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'9','-10923.4','-352.899','39.057','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'10','-10930.5','-334.752','35.5157','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'11','-10895.6','-317.483','38.0097','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'12','-10869.4','-290.03','38.1087','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'13','-10860.6','-275.183','38.1518','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'14','-10848','-221.353','37.8922','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'15','-10831.9','-155.07','32.5185','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'16','-10812.1','-98.8896','29.6446','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'17','-10792.3','-41.4492','29.4412','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'18','-10773.6','21.6685','28.7905','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'19','-10757.5','56.2357','28.423','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'20','-10749.4','106.182','28.3744','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'21','-10757.3','144.07','29.0985','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'22','-10764.6','146.943','29.6411','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'23','-10759.1','139.059','29.1467','0','0','0','0','100','0','0'),
(@my_Balafre_guid * 10 ,'24','-10748.8','109.096','28.3503','0','0','0','0','100','0','0');
-- implementation of the creatures + put it into event
DELETE FROM creature WHERE id IN ( @my_Balafre_id );
INSERT INTO creature
(guid, id, map, zone, area, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags, walkmode, saiscriptflag) VALUES
(@my_Balafre_guid, @my_Balafre_id,'0','10','10','1','65535','0','0','-10748.3','107.224','28.3368','4.62478','3600','0','0','4775','0','2','0','0','0', '0' ,'0'); -- 3600 respawn
DELETE FROM game_event_creature WHERE guid IN ( SELECT creature.guid
FROM creature
WHERE creature.id IN ( @my_Balafre_id ));
INSERT INTO game_event_creature (eventEntry, guid) VALUES ( '25', @my_Balafre_guid ); -- Nights event
-- french fix
UPDATE locales_creature SET name_loc2 = 'Balafré', subname_loc2 = "Cadeau de l'Embaumeur" WHERE ( entry = @my_Balafre_id OR entry = '43862' );
-- Loot tables
DELETE FROM creature_loot_template WHERE (entry = @my_Balafre_id );
INSERT INTO creature_loot_template (entry, item, ChanceOrQuestChance, mincountOrRef, maxcount) VALUES
(@my_Balafre_id ,'7684','5','1','1'),
(@my_Balafre_id ,'7755','5','1','1'),
(@my_Balafre_id ,'17749','5','1','1'),
(@my_Balafre_id ,'17732','5','1','1');
-- Generated by Event Horizon Sai
DELETE FROM `smart_scripts` WHERE `entryorguid`=@my_Balafre_id AND `source_type`=0;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(@my_Balafre_id,0,0,0,0,0,100,0,7000,14000,8000,15000,11,18813,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,"Belafre - In Combat - Cast 'Thrash' "),
(@my_Balafre_id,0,1,0,2,0,100,1,50,100,10000,30000,11,41105,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,"Belafre - Defensive Aura"),
(@my_Balafre_id,0,2,0,0,0,100,0,20000,30000,20000,30000,11,5568,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,"Belafre - In Combat - Cast Stun"),
(@my_Balafre_id,0,3,0,2,0,100,1,0,49,20000,50000,11,41107,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,"Belafre - Berserker Aura"),
(@my_Balafre_id,0,4,0,0,0,100,0,20000,30000,20000,30000,11,23314,4,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,"Belafre - Acide corosif");
Last edited: