[CODE]SET @ENTRY := 27627; – NPC entry
SET @ENTRY2 := 27626; – NPC entry
SET @SPELL := 49134; – Tranquilizer Dart
UPDATE creature_template SET AIName=‘SmartAI’ WHERE entry IN (@ENTRY,@ENTRY2);
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid IN (@ENTRY,@ENTRY2);
DELETE FROM smart_scripts WHERE source_type=9 AND entryorguid IN (@ENTRY2100);
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
(@ENTRY,0,0,1,8,0,100,0,@SPELL,0,2000,5000,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Tatjana - On Spellhit - stop combat movement’),
(@ENTRY,0,1,2,61,0,100,0,0,0,0,0,20,0,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Tatjana - On Spellhit - stop attack’),
(@ENTRY,0,2,3,61,0,100,0,0,0,0,0,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Tatjana - On Spellhit - set faction 35’),
(@ENTRY,0,3,0,61,0,100,0,0,0,0,0,80,@ENTRY2100,0,0,0,0,0,10,118047,27626,0,0,0,0,0, ‘Tatjana - run script for Tatjana’‘s Horse’),
(@ENTRY2100,9,0,1,61,0,100,0,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Tatjana’‘s Horse - script - stop combat movement’),
(@ENTRY2100,9,1,2,61,0,100,0,0,0,0,0,20,0,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Tatjana’‘s Horse - script - stop attack’),
(@ENTRY2*100,9,2,0,61,0,100,0,0,0,0,0,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Tatjana’‘s Horse - script - set faction 35’),
(@ENTRY2,0,0,0,27,0,100,0,0,0,0,0,15,12330,0,0,0,0,0,7,0,0,0,0,0,0,0, ‘Tatjana’‘s Horse - On passanger boarde - Anatoly Will Talk quest complete’); – hack till we dont have proper wp’s
– Missing wps for horse on passange boarded
DELETE FROM vehicle_template_accessory WHERE entry=27626;
insert into vehicle_template_accessory (entry, accessory_entry, seat_id, minion, description, summontype, summontimer) values
(27626,27627,0,0, ‘Tatjana’‘s Horse’,6,30000);
DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceEntry=49134;
INSERT INTO conditions (SourceTypeOrReferenceId,SourceEntry,ConditionTypeOrReference,ConditionValue1,ConditionValue2) VALUES
(13,49134,18,1,27627);
UPDATE creature_template SET npcflag=16777216,speed_run=1.28571 WHERE entry=27626; – Tatjana’s Horse
DELETE FROM creature_template_addon WHERE entry IN (27626,27627);
INSERT INTO creature_template_addon (entry,mount,bytes1,bytes2,emote,auras) VALUES
(27626,0,0,1,0, NULL), – Tatjana’s Horse
(27627,0,0,1,0, NULL); – Tatjana
UPDATE npc_spellclick_spells SET spell_id=43671 WHERE npc_entry=27626; – wrong spell was being use[/sql][/CODE]