DB*/fix_creature_text - Githubissues

zTerragor commented 1 year ago

SQL Fix `/SQL_SCRIPT SCARFACE/ /23.4.2022/

npc_stormwind_infantry current script in SmartScript,creature texts already in db.

/Text for Creature(Stormwind Infantry) Entry 49869/ DELETE FROM creature_text WHERE entry = '49869'; INSERT INTO creature_text(entry, groupid, id, text, text_female, TextRange, type, language, probability, emote, duration, sound, BroadcastTextId, comment) VALUES (49869, 0, 0, 'I need a heal!', '', 0, 12, 0, 100, 0, 0, 0, 49898, 'Infanterist'), (49869, 0, 1, 'HELP!', '', 0, 12, 0, 100, 0, 0, 0, 49897, 'Infanterist'), (49869, 0, 2, 'Make yourself useful and heal me!', '', 0, 12, 0, 100, 0, 0, 0, 49896, 'Infanterist'), (49869, 0, 3, 'I could use a heal, brother!', '', 0, 12, 0, 100, 0, 0, 0, 49895, 'Infanterist');

-- Text for Creature(Blackrock Invader) Entry 42937 ,Probability are gussed DELETE FROM creature_text WHERE CreatureID = '42937'; INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, SoundType, BroadcastTextId, TextRange, comment) VALUES (42937, 0, 0, 'Orc KILL $r!', 12, 0, 100, 0, 0, 0, 0, 42876, 0, 'Blackrock Invader on Aggro Text'), (42937, 0, 1, 'Blackrock take forest!', 12, 0, 100, 0, 0, 0, 0, 42879, 0, 'Blackrock Invader on Aggro Text'), (42937, 0, 2, 'The grapes were VERY TASTY!', 12, 0, 100, 0, 0, 0, 0, 42880, 0, 'Blackrock Invader on Aggro Text'), (42937, 0, 3, 'Eat you!', 12, 0, 100, 0, 0, 0, 0, 42878, 0, 'Blackrock Invader on Aggro Text'), (42937, 0, 4, 'Beg for life!', 12, 0, 100, 0, 0, 0, 0, 42877, 0, 'Blackrock Invader on Aggro Text');

/Text for Creature(Blackrock Spy) Entry 49874/ DELETE FROM creature_text WHERE entry = '49874'; INSERT INTO creature_text(entry, groupid, id, text, text_female, TextRange, type, language, probability, emote, duration, sound, BroadcastTextId, comment) VALUES (49874, 0, 0, 'Orc KILL $r!', '', 0, 12, 0, 50, 0, 0, 0, 42876, 'on Aggro Text'), (49874, 0, 1, 'Blackrock take forest!', '', 0, 12, 0, 50, 0, 0, 0, 42879, 'on Aggro Text'), (49874, 0, 2, 'The grapes were VERY TASTY!', '', 0, 12, 0, 50, 0, 0, 0, 42880, 'on Aggro Text');

/Text for Creature(Scarlet Warrior) Entry 1535/ DELETE FROM creature_text WHERE entry = '1535'; INSERT INTO creature_text(entry, groupid, id, text, text_female, TextRange, type, language, probability, emote, duration, sound, BroadcastTextId, comment) VALUES (1535, 0, 0, 'The light condemns all who harbor evil. Now you will die!', '', 0, 12, 0, 50, 0, 0, 0, 2627, 'on Aggro Text'), (1535, 0, 1, 'You carry the taint of the scourge. Prepare to enter the twisting nether.', '', 0, 12, 0, 50, 0, 0, 0, 2625, 'on Aggro Text'), (1535, 0, 2, 'The Scarlet Crusade shall smite the wicked and drive evil from these lands!', '', 0, 12, 0, 50, 0, 0, 0, 2628, 'on Aggro Text'), (1535, 1, 0, '%s attempts to run away in fear!', '', 0, 16, 0, 100, 0, 0, 0, 1150, 'combat Flee'); `

leelf00 commented 1 year ago

Every creature_text should has a BroadcastTextId.I update the missing BroadcastTextId.Smart Script still missing.