DB*/fix_creature_text

[zTerragor]

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]

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

[qqwqqwe]

Unknown column 'entry' in 'field list'

[qqwqqwe]

Unable to import

[leelf00]

this SQL already in db

[qqwqqwe]

CreatureTextMgr: TextGroup 1 for Creature(Aspiring Trainee) GuidLow 563382 Entry 53565, id 0 already added
No defined handler for opcode 127.0.0.1 sent by [CMSG_UPDATE_CLIENT_SETTINGS 0x1D8D (7565)] 1

[qqwqqwe]

There are frequent such prompts

[qqwqqwe]

In console worldserver

[qqwqqwe]

CreatureTextMgr: TextGroup 0 for Creature(Recruitment Officer Carven) GuidLow 95043 Entry 25222, id 0 already added
CreatureTextMgr: TextGroup 1 for Creature(Recruitment Officer Carven) GuidLow 95043 Entry 25222, id 2 already added
CreatureTextMgr: TextGroup 1 for Creature(Recruitment Officer Carven) GuidLow 95043 Entry 25222, id 1 already added
CreatureTextMgr: TextGroup 3 for Creature(Recruitment Officer Carven) GuidLow 95043 Entry 25222, id 2 already added

[qqwqqwe]

When you stand in Stormstorm

[leelf00]

The warning is caused by a script bug.

[qqwqqwe]

Its a big one

[leelf00]

Yes.You can just ignore it now.I will push a commit to fix it when I have time,

[qqwqqwe]

Wait for you

[qqwqqwe]

its ok now