Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

[Fix]Fix smart script after reward quest 808 #12545

Closed
kldxzzhc2 opened this Issue Jul 18, 2014 · 3 comments

Comments

Projects
None yet
3 participants

core 5544ce1
db up-to-date

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`='3188';
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 ('3188', '0', '0', '0', '20', '0', '100', '1', '808', '0', '0', '0', '12', '3289', '3', '30000', '0', '0', '0', '1', '0', '0', '0', '-820.3756', '-4921.19', '19.2492', '3.1711', 'summon 3289');

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`='3289';
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 ('3289', '0', '0', '0', '11', '0', '100', '1', '2000', '2000', '0', '0', '1', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', 'Say Line 0');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES
('3289', '0', '0', 'Thank you, my friend $n. I\\\'m free now...', '12', '1', '0', '0', '0', '0', 'Say Line 0', '1000001');
INSERT INTO `broadcast_text` (`ID`, `Language`, `MaleText`, `FemaleText`, `EmoteID0`, `EmoteID1`, `EmoteID2`, `EmoteDelay0`, `EmoteDelay1`, `EmoteDelay2`, `SoundId`, `Unk1`, `Unk2`, `VerifiedBuild`) VALUES
('1000001', '1', 'Thank you, my friend $n. I\\\'m free now...', '', '0', '0', '0', '0', '0', '0', '0', '0', '1', '18019');
Owner

Aokromes commented Jul 18, 2014

broadcast_text , BroadcastTextID, VerifiedBuild comes from sniff, we don't put ' around numbers.

Sorry, I don't know how to use sniff. Just ignore that two field

Member

DDuarte commented Jul 24, 2014

Thanks for the fix but it does not adhere to our guidelines defined here: http://www.trinitycore.org/f/topic/2588-sql-guidelines/

@DDuarte DDuarte closed this Jul 24, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment