[SOLVED] Teleport player on quest accept in sql not in c++

[royal27]

I want to make after i take the quest from a npc to teleport me in another place instantly,can someone give me a example how?I have inserted in smart_script table this code but dosent work,give me please a full example if you can

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 
(35552, 0, 0, 0, 19, 0, 100, 0, 14212, 0, 0, 0, 62, 654, 0, 0, 0, 0, 0, 7, 0, 0, 0, 1539.71, 1571.48, 29.2049, 0, "On Quest Accept - it is going");

I have the quest sacrifices that i want to teleport me

 

[Rochet2]

The code looks fine to me, assuming .go xyz 1539.71 1571.48 29.2049 654 works fine.

Do you start the quest from the NPC?
Does the NPC have an empty scriptname and SmartAI set as AIName in creature_template?

 

[royal27]

scriptname is empty

 

[Neccta]

scriptname is empty

AIName needs to be set to 'SmartAI'. You can use the following query to change it.

UPDATE creature_template SET AIName = 'SmartAI' WHERE entry = [COLOR="#FF0000"]YourCreatureEntry[/COLOR];

 

[royal27]

ok,thank you,also i have problem with arcane missles,dosent activate,can you give me an sql to put in dbase?

 

[royal27]

OK,i've updated this script to my npc 35552 nto tele me in another place but dosent work with smart_scripts,here is the example i used from you,can you give me example?

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
(35552, 0, 0, 0, 19, 0, 100, 0, 14212, 0, 0, 0, 62, 654, 0, 0, 0, 0, 0, 7, 0, 0, 0, 1539.71, 1571.48, 29.2049, 0, "On Quest Accept - it is going");

UPDATE creature_template SET AIName = 'SmartAI' WHERE entry = 35552;

 

[Neccta]

If I remember correctly there where two QUEST_ACCEPTED event types, try 47.

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 
(35552, 0, 0, 0, 47, 0, 100, 0, 14212, 0, 0, 0, 62, 654, 0, 0, 0, 0, 0, 7, 0, 0, 0, 1539.71, 1571.48, 29.2049, 0, "On Quest Accept - it is going"); 

UPDATE creature_template SET AIName = 'SmartAI' WHERE entry = 35552;

 

[royal27]

works,thanks