Aktionen
Fehler #15125
geschlossen
[DK-Fraktionsendquest] Fehlerhaftes Verhalten der Elitesoldaten
Beginn:
14.08.2015
DB-Link:
Update Text Deutsch:
Die Stadtwachen sollten nun verärgert auf neue Todesritter reagieren und diese mit faulem Obst bewerfen, verspotten und anspucken.
Beschreibung
https://github.com/unified-db/Database/issues/76#issuecomment-131041216
+(-1609081,'%s throws rotten apple on $N.',0,2,0,0,'city guard EMOTE_APPLE'),
+(-1609082,'%s throws rotten banana on $N.',0,2,0,0,'city guard EMOTE_BANANA'),
+(-1609083,'%s spits on $N.',0,2,0,0,'city guard EMOTE_SPIT'),
+(-1609084,'Monster!',0,0,0,14,'city guard SAY_RANDOM_1'),
+(-1609085,'Murderer!',0,0,0,14,'city guard SAY_RANDOM_2'),
+(-1609086,'GET A ROPE!',0,0,0,25,'city guard SAY_RANDOM_3'),
+(-1609087,'How dare you set foot in our city!',0,0,0,25,'city guard SAY_RANDOM_4'),
+(-1609088,'You disgust me.',0,0,0,14,'city guard SAY_RANDOM_5'),
(-1609287,'Looks like we\'re going to have ourselves an execution.',0,0,0,25,'city guard SAY_RANDOM_6'),
+(-1609288,'Traitorous dog.',0,0,0,14,'city guard SAY_RANDOM_7'),
+(-1609289,'My family was wiped out by the Scourge! MONSTER!',0,0,0,25,'city guard SAY_RANDOM_8');
+(-1609081,'%s throws rotten apple on $N.',0,2,0,0,'city guard EMOTE_APPLE'),
+(-1609082,'%s throws rotten banana on $N.',0,2,0,0,'city guard EMOTE_BANANA'),
+(-1609083,'%s spits on $N.',0,2,0,0,'city guard EMOTE_SPIT'),
+(-1609084,'Monster!',0,0,0,14,'city guard SAY_RANDOM_1'),
+(-1609085,'Murderer!',0,0,0,14,'city guard SAY_RANDOM_2'),
+(-1609086,'GET A ROPE!',0,0,0,25,'city guard SAY_RANDOM_3'),
+(-1609087,'How dare you set foot in our city!',0,0,0,25,'city guard SAY_RANDOM_4'),
+(-1609088,'You disgust me.',0,0,0,14,'city guard SAY_RANDOM_5'),
+(-1609287,'Looks like we\'re going to have ourselves an execution.',0,0,0,25,'city guard SAY_RANDOM_6'),
+(-1609288,'Traitorous dog.',0,0,0,14,'city guard SAY_RANDOM_7'),
+(-1609289,'My family was wiped out by the Scourge! MONSTER!',0,0,0,25,'city guard SAY_RANDOM_8');
+enum
+{
+ SPELL_RETURN_ORGRIMMAR = 58552,
+ SPELL_RETURN_STORMWIND = 58533,
+
+ SPELL_TOSS_APPLE = 58509,
+ SPELL_TOSS_BANANA = 58513,
+ SPELL_SPIT = 58520,
+
+ EMOTE_APPLE = -1609081,
+ EMOTE_BANANA = -1609082,
+ EMOTE_SPIT = -1609083,
+ SAY_RANDOM_1 = -1609084,
+ SAY_RANDOM_2 = -1609085,
+ SAY_RANDOM_3 = -1609086,
+ SAY_RANDOM_4 = -1609087,
+ SAY_RANDOM_5 = -1609088,
+ SAY_RANDOM_6 = -1609287,
+ SAY_RANDOM_7 = -1609288,
+ SAY_RANDOM_8 = -1609289,
+};
Wenn man in die stadt kommt und sich den wachen:
UPDATE creature_template SET ScriptName='guard_orgrimmar' WHERE entry=14304; +UPDATE creature_template SET ScriptName='guard_stormwind' WHERE entry IN (68,1756,1976);
nähert und man die quest:
quests 13188 / 13189
abgeschlossen aber nicht rewarded hat sollten die kreaturen die oben genannten rndmactions ausführen (spucken, zeugs werfen, fluchen etc.)
Aktionen
#1
Von Rushor vor mehr als 9 Jahren aktualisiert
-- DK Faction Endquest - Implement Reaction for Orgrimmar and Alliance Guards UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=68; DELETE FROM `creature_text` WHERE `entry`=68; INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (68, 2, 0, '%s throws a rotten apple at $n.', 16, 0, 100, 0, 0, 0, 31671, 'Stormwind City Guard'), (68, 3, 0, '%s throws rotten banana on $n.', 16, 0, 100, 0, 0, 0, 31672, 'Stormwind City Guard'), (68, 4, 0, '%s spits on $n.', 16, 0, 100, 0, 0, 0, 31673, 'Stormwind City Guard'), (68, 5, 0, 'Monster!', 12, 0, 100, 0, 0, 0, 31662, 'Stormwind City Guard'), (68, 5, 1, 'Murderer!', 12, 0, 100, 0, 0, 0, 31679, 'Stormwind City Guard'), (68, 5, 2, 'GET A ROPE!', 12, 0, 100, 0, 0, 0, 31669, 'Stormwind City Guard'), (68, 5, 3, 'How dare you set foot in our city!', 12, 0, 100, 0, 0, 0, 31684, 'Stormwind City Guard'), (68, 5, 4, 'You disgust me.', 12, 0, 100, 0, 0, 0, 31680, 'Stormwind City Guard'), (68, 5, 5, 'Looks like we\'re going to have ourselves an execution.', 12, 0, 100, 0, 0, 0, 31682, 'Stormwind City Guard'), (68, 5, 6, 'Traitorous dog.', 12, 0, 100, 0, 0, 0, 31665, 'Stormwind City Guard'), (68, 5, 7, 'My family was wiped out by the Scourge! MONSTER!', 12, 0, 100, 0, 0, 0, 31667, 'Stormwind City Guard'); DELETE FROM `creature_text` WHERE `entry`=14304; INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (14304, 2, 0, '%s throws a rotten apple at $n.', 16, 0, 100, 0, 0, 0, 31671, 'Kor\'kron Elite'), (14304, 3, 0, '%s throws rotten banana on $n.', 16, 0, 100, 0, 0, 0, 31672, 'Kor\'kron Elite'), (14304, 4, 0, '%s spits on $n.', 16, 0, 100, 0, 0, 0, 31673, 'Kor\'kron Elite'), (14304, 5, 0, 'Monster!', 12, 0, 100, 0, 0, 0, 31662, 'Kor\'kron Elite'), (14304, 5, 1, 'Murderer!', 12, 0, 100, 0, 0, 0, 31679, 'Kor\'kron Elite'), (14304, 5, 2, 'GET A ROPE!', 12, 0, 100, 0, 0, 0, 31669, 'Kor\'kron Elite'), (14304, 5, 3, 'How dare you set foot in our city!', 12, 0, 100, 0, 0, 0, 31684, 'Kor\'kron Elite'), (14304, 5, 4, 'You disgust me.', 12, 0, 100, 0, 0, 0, 31680, 'Kor\'kron Elite'), (14304, 5, 5, 'Looks like we\'re going to have ourselves an execution.', 12, 0, 100, 0, 0, 0, 31682, 'Kor\'kron Elite'), (14304, 5, 6, 'Traitorous dog.', 12, 0, 100, 0, 0, 0, 31665, 'Kor\'kron Elite'), (14304, 5, 7, 'My family was wiped out by the Scourge! MONSTER!', 12, 0, 100, 0, 0, 0, 31667, 'Kor\'kron Elite'); DELETE FROM `creature_text` WHERE `entry`=1756; INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (1756, 2, 0, '%s throws a rotten apple at $n.', 16, 0, 100, 0, 0, 0, 31671, 'Stormwind Royal Guard'), (1756, 3, 0, '%s throws rotten banana on $n.', 16, 0, 100, 0, 0, 0, 31672, 'Stormwind Royal Guard'), (1756, 4, 0, '%s spits on $n.', 16, 0, 100, 0, 0, 0, 31673, 'Stormwind Royal Guard'), (1756, 5, 0, 'Monster!', 12, 0, 100, 0, 0, 0, 31662, 'Stormwind Royal Guard'), (1756, 5, 1, 'Murderer!', 12, 0, 100, 0, 0, 0, 31679, 'Stormwind Royal Guard'), (1756, 5, 2, 'GET A ROPE!', 12, 0, 100, 0, 0, 0, 31669, 'Stormwind Royal Guard'), (1756, 5, 3, 'How dare you set foot in our city!', 12, 0, 100, 0, 0, 0, 31684, 'Stormwind Royal Guard'), (1756, 5, 4, 'You disgust me.', 12, 0, 100, 0, 0, 0, 31680, 'Stormwind Royal Guard'), (1756, 5, 5, 'Looks like we\'re going to have ourselves an execution.', 12, 0, 100, 0, 0, 0, 31682, 'Stormwind Royal Guard'), (1756, 5, 6, 'Traitorous dog.', 12, 0, 100, 0, 0, 0, 31665, 'Stormwind Royal Guard'), (1756, 5, 7, 'My family was wiped out by the Scourge! MONSTER!', 12, 0, 100, 0, 0, 0, 31667, 'Stormwind Royal Guard'); DELETE FROM `creature_text` WHERE `entry`=1976; INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (1976, 2, 0, '%s throws a rotten apple at $n.', 16, 0, 100, 0, 0, 0, 31671, 'Stormwind City Patroller'), (1976, 3, 0, '%s throws rotten banana on $n.', 16, 0, 100, 0, 0, 0, 31672, 'Stormwind City Patroller'), (1976, 4, 0, '%s spits on $n.', 16, 0, 100, 0, 0, 0, 31673, 'Stormwind City Patroller'), (1976, 5, 0, 'Monster!', 12, 0, 100, 0, 0, 0, 31662, 'Stormwind City Patroller'), (1976, 5, 1, 'Murderer!', 12, 0, 100, 0, 0, 0, 31679, 'Stormwind City Patroller'), (1976, 5, 2, 'GET A ROPE!', 12, 0, 100, 0, 0, 0, 31669, 'Stormwind City Patroller'), (1976, 5, 3, 'How dare you set foot in our city!', 12, 0, 100, 0, 0, 0, 31684, 'Stormwind City Patroller'), (1976, 5, 4, 'You disgust me.', 12, 0, 100, 0, 0, 0, 31680, 'Stormwind City Patroller'), (1976, 5, 5, 'Looks like we\'re going to have ourselves an execution.', 12, 0, 100, 0, 0, 0, 31682, 'Stormwind City Patroller'), (1976, 5, 6, 'Traitorous dog.', 12, 0, 100, 0, 0, 0, 31665, 'Stormwind City Patroller'), (1976, 5, 7, 'My family was wiped out by the Scourge! MONSTER!', 12, 0, 100, 0, 0, 0, 31667, 'Stormwind City Patroller'); -- AIs -- Stormwind City Guard SAI SET @ENTRY := 68; UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; 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,0,10,0,100,0,1,10,10000,10000,87,@ENTRY*100+00,@ENTRY*100+01,@ENTRY*100+02,@ENTRY*100+03,0,0,1,100,0,0,0,0,0,0,"Stormwind City Guard - Within 1-10 Range Out of Combat LoS - Run Random Script"); DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=68; INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES (22,1,68,0,0,28,0,13188,0,0,0,"","Only Run script if quest is completed"); -- Kor'kron Elite SAI SET @ENTRY := 14304; UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; 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,0,10,0,100,0,1,10,10000,10000,87,68*100+00,68*100+01,68*100+02,68*100+03,0,0,1,100,0,0,0,0,0,0,"Kor'kron Elite - Within 1-10 Range Out of Combat LoS - Run Random Script"); DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=14304; INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES (22,1,14304,0,0,28,0,13189,0,0,0,"","Only Run script if quest is completed"); -- Stormwind City Patroller SAI SET @ENTRY := 1976; UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; 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,0,10,0,100,0,1,10,10000,10000,87,68*100+00,68*100+01,68*100+02,68*100+03,0,0,1,100,0,0,0,0,0,0,"Stormwind City Patroller - Within 1-10 Range Out of Combat LoS - Run Random Script"); DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=1976; INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES (22,1,1976,0,0,28,0,13188,0,0,0,"","Only Run script if quest is completed"); -- Stormwind Royal Guard SAI SET @ENTRY := 1756; UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; 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,0,10,0,100,0,1,10,10000,10000,87,68*100+00,68*100+01,68*100+02,68*100+03,0,0,1,100,0,0,0,0,0,0,"Stormwind Royal Guard - Within 1-10 Range Out of Combat LoS - Run Random Script"); DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=1756; INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES (22,1,1756,0,0,28,0,13188,0,0,0,"","Only Run script if quest is completed"); -- Actionlist SAI SET @ENTRY := 6800; DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9; 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,9,0,0,0,0,100,0,0,0,0,0,11,58509,0,0,0,0,0,21,100,0,0,0,0,0,0,"Stormwind City Guard - On Script - Cast 'Rotten Apple Toss'"), (@ENTRY,9,1,0,0,0,100,0,0,0,0,0,1,2,0,0,0,0,0,21,100,0,0,0,0,0,0,"Stormwind City Guard - On Script - Say Line 2"); -- Actionlist SAI SET @ENTRY := 6801; DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9; 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,9,0,0,0,0,100,0,0,0,0,0,11,58513,0,0,0,0,0,21,100,0,0,0,0,0,0,"Stormwind City Guard - On Script - Cast 'Rotten Banana Toss'"), (@ENTRY,9,1,0,0,0,100,0,0,0,0,0,1,3,0,0,0,0,0,21,100,0,0,0,0,0,0,"Stormwind City Guard - On Script - Say Line 3"); -- Actionlist SAI SET @ENTRY := 6802; DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9; 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,9,0,0,0,0,100,0,0,0,0,0,11,58520,0,0,0,0,0,21,100,0,0,0,0,0,0,"Stormwind City Guard - On Script - Cast 'Spit'"), (@ENTRY,9,1,0,0,0,100,0,0,0,0,0,1,4,0,0,0,0,0,21,100,0,0,0,0,0,0,"Stormwind City Guard - On Script - Say Line 4"); -- Actionlist SAI SET @ENTRY := 6803; DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9; 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,9,0,0,0,0,100,0,0,0,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stormwind City Guard - On Script - Say Line 5"); DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (58509, 58513, 58520); INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (58509, 58511, 0, 'Rotten Apple - Rotten Apple'), (58513, 58514, 0, 'Rotten Banana - Rotten Banana'), (58520, 58519, 0, 'Spit - Spit');
Aktionen
#2
Von Rushor vor mehr als 9 Jahren aktualisiert
- Status wurde von Neu zu Ready geändert
- Update Text Deutsch aktualisiert (Vergleich)
Aktionen
#3
Von Rushor vor mehr als 9 Jahren aktualisiert
noch zusätzlich für https://db.rising-gods.de/?npc=3296 hinzugefügt
quelle: https://youtu.be/tHr8Zb-JUCY?t=25s
Von
Aktionen
#5
Von Rushor vor mehr als 8 Jahren aktualisiert
Bedeutung Live:
Der Bug wurde erfolgreich behoben und befindet sich auf dem Spielserver. Sollte der Fehler weiterhin bestehen sollte ein neues Ticket ( https://redmine.rising-gods.de/projects/live/issues/new ) erstellt werden. Anmerkungen in dem alten abgewiesenen oder live genommenen Ticket werden ignoriert und gelöscht.
Aktionen