azerothcore / azerothcore-wotlk

Complete Open Source and Modular solution for MMO
http://www.azerothcore.org
GNU Affero General Public License v3.0
6.63k stars 2.64k forks source link

[Howling Fjord] Quest: Draconis Gastritis - can't be completed #13842

Open whiteblue8823 opened 2 years ago

whiteblue8823 commented 2 years ago

Current Behaviour

The quest is: Draconis Gastritis id:11280

You can accept the quest from the NPC, but when you use the item, the dragon comes and just attacks and doesn't allow you to complete the quest. I've tested it several times.

Expected Blizzlike Behaviour

after using the quest item, the target dragon should react with the item been used and let the quest be done.

Source

No response

Steps to reproduce the problem

  1. take the quest
  2. use the quest item
  3. bug happen

Extra Notes

No response

AC rev. hash/commit

AzerothCore rev. 5cf7d3d198f6 2022-11-13 18:41:10 -0300 (master branch) (Win64, RelWithDebInfo, Static) Using SSL version: OpenSSL 1.1.1s 1 Nov 2022 (library: OpenSSL 1.1.1s 1 Nov 2022) Using Boost version: 1.79.0 Using MySQL version: 80031 Using CMake version: 3.24.3 Compiled on: Windows 10.0.22000 Worldserver listening connections on port 8085 Realmlist (Realm Id: 1) configured in port 8085 VMAPs status: Enabled. LineOfSight: 1, getHeight: 1, indoorCheck: 1 MMAPs status: Enabled maps directory located in C:/App/AzerothCore/RelWithDebInfo/Data/maps. Total size: 291014951 bytes vmaps directory located in C:/App/AzerothCore/RelWithDebInfo/Data/vmaps. Total size: 658130721 bytes mmaps directory located in C:/App/AzerothCore/RelWithDebInfo/Data/mmaps. Total size: 2320900676 bytes Using enUS DBC Locale as default. All available DBC locales: enUS Using World DB: ACDB 335.8-dev LoginDatabase queue size: 0 CharacterDatabase queue size: 0 WorldDatabase queue size: 0 No modules enabled AC> Update time diff: 17. Players

Operating system

Windows 11

Custom changes or Modules

None

zylok520 commented 2 years ago

The normal situation is that after using the task item, the dragon will go down to the ground, eat the food, and then the changes will be made to complete the task; now the dragon has come down, but there is nothing happened.

saligin commented 2 months ago

I used this method, and it worked for me!

UPDATE creature_template SET AIName='SmartAI' WHERE entry IN (23689,24170);

DELETE FROM smart_scripts WHERE entryorguid IN (23689,24170) 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 (23689,0,1,2,65,0,100,0,0,0,0,0,11,36809,2,0,0,0,0,1,0,0,0,0,0,0,0,'Proto-Drake - Reach Target - Cast Spell (36809)'), (23689,0,2,0,61,0,100,0,0,0,0,0,33,24170,0,0,0,0,0,18,35,0,0,0,0,0,0,'Draconis Gastritis Bunny - On Death - Quest Reward'), (23689,0,3,0,1,0,100,0,10000,10000,10000,10000,29,0,0,24170,1,1,0,19,24170,75,0,0,0,0,0,'Proto-Drake - Find Target - Follow'), (23689,0,4,0,65,0,100,0,0,0,0,0,51,0,0,0,0,0,0,19,24170,5,0,0,0,0,0,'Proto-Drake - Reach Target - Kill Dummy'), (23689,0,5,0,61,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Proto-Drake - On Find Target - Set Phase 1'), (23689,0,6,0,1,1,100,0,45000,45000,45000,45000,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Proto-Drake - Idle on Ground(Phase 1) - Despawn'), (24170,0,0,0,54,0,100,0,0,0,0,0,50,186598,60000,0,0,0,0,1,0,0,0,0,0,0,0,'Draconis Gastritis Bunny - On Create - Spawn GO'), (24170,0,1,0,6,0,100,0,0,0,0,0,33,24170,0,0,0,0,0,18,20,0,0,0,0,0,0,'Draconis Gastritis Bunny - On Death - Quest Reward'), (24170,0,2,0,54,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Draconis Gastritis Bunny - On Create - Hide'), (24170,0,3,0,6,0,100,0,0,0,0,0,41,0,0,0,0,0,0,15,186598,5,0,0,0,0,0,'Draconis Gastritis Bunny - On Death - Remove Gobjects');