Azerothcore-wotlk: [DB/SAI] Latest DB Errors

Created on 11 May 2019 · 6Comments · Source: azerothcore/azerothcore-wotlk

Been checking server last 2 weeks with players, and those are most common Errors that happen from time to time.

Beside Module Spam (Know Error in Server.log) here's the list of most common.

2019-05-05 17:33:50 WaypointMovementGenerator::LoadPath: creature Defias Overseer (Entry: 634 GUID: 3131333) doesn't have waypoint path id: 0 (Multi GUIDs)
2019-05-05 17:40:37 WaypointMovementGenerator::LoadPath: creature Defias Taskmaster (Entry: 4417 GUID: 3131460) doesn't have waypoint path id: 0 (Multi GUIDs)
2019-05-09 19:35:57 WaypointMovementGenerator::LoadPath: creature Weaver (Entry: 5720 GUID: 3150301) doesn't have waypoint path id: 0 (Multi GUIDs) 
2019-05-09 23:16:07 WaypointMovementGenerator::LoadPath: creature Prince Keleseth (Entry: 23953 GUID: 3175719) doesn't have waypoint path id: 0 (Multi GUIDs)
2019-05-10 00:07:44 WaypointMovementGenerator::LoadPath: creature Flamewaker Protector (Entry: 12119 GUID: 3184595) doesn't have waypoint path id: 566070 (Multi GUIDs)
2019-05-10 00:53:52 WaypointMovementGenerator::LoadPath: creature Drakkari Gutripper (Entry: 26641 GUID: 3189131) doesn't have waypoint path id: 0 (Multi GUIDs)
2019-05-10 10:14:47 WaypointMovementGenerator::LoadPath: creature Bile Golem (Entry: 28201 GUID: 3182464) doesn't have waypoint path id: 0
2019-05-10 10:14:47 WaypointMovementGenerator::LoadPath: creature Crypt Fiend (Entry: 27734 GUID: 3182465) doesn't have waypoint path id: 0
2019-05-10 10:14:47 WaypointMovementGenerator::LoadPath: creature Devouring Ghoul (Entry: 28249 GUID: 3182507) doesn't have waypoint path id: 0
2019-05-10 10:14:47 WaypointMovementGenerator::LoadPath: creature Patchwork Construct (Entry: 27736 GUID: 3182508) doesn't have waypoint path id: 0

2019-05-10 16:33:33 Fishable areaId 3479 are not properly defined in `skill_fishing_base_level`.

2019-05-06 01:08:18 Creature 6613 (Entry: 7231) have UNIT_NPC_FLAG_VENDOR but have empty trading item list.

2019-05-11 19:10:07 ERROR: DoZoneInCombat called for creature that has empty threat list (creature entry = 15117)

2019-05-11 18:37:27 ERROR: MoveSplineInitArgs::Validate: expression 'velocity > 0.01f' failed for GUID: 202681 Entry: 17280 (Multi GUIDs)

2019-05-05 22:22:53 SmartScript::ProcessAction: Entry 14908 SourceType 0, Event 7, Link Event 8 not found or invalid, skipped.
2019-05-09 09:37:52 SmartScript::ProcessAction: Entry 16398 SourceType 1, Event 0, Link Event 1 not found or invalid, skipped.
2019-05-06 08:16:38 SmartScript::ProcessAction: Entry 2044 SourceType 0, Event 0, Link Event 3 not found or invalid, skipped.
2019-05-06 20:04:06 SmartScript::ProcessAction: Entry 25514 SourceType 0, Event 0, Link Event 1 not found or invalid, skipped.
2019-05-08 19:22:42 SmartScript::ProcessAction: Entry 22374 SourceType 0, Event 0, Link Event 1 not found or invalid, skipped.
2019-05-08 21:20:57 SmartScript::ProcessAction: Entry 16968 SourceType 0, Event 7, Link Event 8 not found or invalid, skipped.
2019-05-09 22:55:33 SmartScript::ProcessAction: Entry 24077 SourceType 0, Event 0, Link Event 1 not found or invalid, skipped.
2019-05-10 07:09:01 SmartScript::ProcessAction: Entry 26670 SourceType 0, Event 18, Link Event 19 not found or invalid, skipped.
2019-05-11 15:44:45 SmartScript::ProcessAction: Entry 20214 SourceType 0, Event 0, Link Event 1 not found or invalid, skipped.
2019-05-11 17:01:51 SmartScript::ProcessAction: Entry 30945 SourceType 0, Event 3, Link Event 4 not found or invalid, skipped.
2019-05-11 17:51:58 SmartScript::ProcessAction: Entry 16968 SourceType 0, Event 7, Link Event 8 not found or invalid, skipped.

2019-05-10 06:17:45 Creature::Create(): creature template (guidlow: 3158126, entry: 191577) does not exist.
2019-05-10 06:17:45 Creature::Create(): creature template (guidlow: 3158127, entry: 191583) does not exist.
2019-05-10 06:17:45 Creature::Create(): creature template (guidlow: 3158128, entry: 191587) does not exist.

2019-05-08 13:20:11 Gameobject (GUID: 2140565 Entry: 184981) not created: non-existing entry in `gameobject_template`. Map: 530 (X: 174.656204 Y: 2941.460449 Z: 24.702682)
2019-05-09 15:49:48 Gameobject (GUID: 2136466 Entry: 184981) not created: non-existing entry in `gameobject_template`. Map: 530 (X: 463.308716 Y: 2914.412109 Z: 41.515911)
2019-05-09 15:51:14 Gameobject (GUID: 2136492 Entry: 184981) not created: non-existing entry in `gameobject_template`. Map: 530 (X: 503.835632 Y: 2955.605225 Z: 32.195271)
2019-05-11 15:36:32 Gameobject (GUID: 2144716 Entry: 184981) not created: non-existing entry in `gameobject_template`. Map: 530 (X: 500.778961 Y: 2955.333740 Z: 32.511833)
2019-05-11 15:37:32 Gameobject (GUID: 2144810 Entry: 184981) not created: non-existing entry in `gameobject_template`. Map: 530 (X: 473.075165 Y: 2987.416260 Z: 23.230686)

2019-05-10 07:17:06 CreatureTextMgr: Could not find TextGroup 4 for Creature(Grauf) GuidLow 3161314 Entry 26893. Ignoring.
2019-05-08 21:45:33 CreatureTextMgr: Could not find Text for Creature(Bloodworm) Entry 28017 in 'creature_text' table. Ignoring.
2019-05-07 16:59:53 CreatureTextMgr: Could not find TextGroup 1 for Creature(Scarlet Ghoul) GuidLow 1976755 Entry 28897. Ignoring.
2019-05-08 19:29:08 CreatureTextMgr: Could not find TextGroup 1 for Creature(Risen Ghoul) GuidLow 3139161 Entry 26125. Ignoring.
2019-05-08 19:29:08 CreatureTextMgr: Could not find TextGroup 2 for Creature(Risen Ghoul) GuidLow 3139161 Entry 26125. Ignoring.
2019-05-08 19:34:48 CreatureTextMgr: Could not find TextGroup 2 for Creature(Scarlet Ghoul) GuidLow 1976756 Entry 28897. Ignoring.
2019-05-09 19:04:46 CreatureTextMgr: Could not find TextGroup 1 for Creature(Scarlet Abbot) GuidLow 3142929 Entry 4303. Ignoring.
2019-05-10 14:06:55 CreatureTextMgr: Could not find TextGroup 1 for Creature(Caverndeep Burrower) GuidLow 3131873 Entry 6206. Ignoring.
2019-05-11 10:59:36 CreatureTextMgr: Could not find Text for Creature(Irontree Wanderer) Entry 7138 in 'creature_text' table. Ignoring.

Most important, i suppose:

2019-05-08 13:16:18 SmartScript: Action target Creature(entry: 19763) is not using SmartAI, action skipped to prevent crash.
2019-05-08 13:18:40 SmartScript: Action target Creature(entry: 19766) is not using SmartAI, action skipped to prevent crash.
2019-05-08 13:18:48 SmartScript: Action target Creature(entry: 19764) is not using SmartAI, action skipped to prevent crash.
2019-05-10 08:39:59 SmartScript: Action target Creature(entry: 27807) is not using SmartAI, action skipped to prevent crash.

Commit: Up to date - Master
Will see if can sort some of them with Poszer.

DB Help wanted

Source

Knindzagxg

👍2

Most helpful comment

Fixed in https://github.com/azerothcore/azerothcore-wotlk/commit/052d3364d606354839f3548fba390c4e738935e1, https://github.com/azerothcore/azerothcore-wotlk/commit/b75e5c2d5d49316e5b0a7f344e070f0383de81d3, https://github.com/azerothcore/azerothcore-wotlk/commit/e4c33b46cbd0d78615b0d1402fb2532221d69bf9, https://github.com/azerothcore/azerothcore-wotlk/commit/f92f167c4f0b65fc4193db3c22ce9a13ca524b5e, https://github.com/azerothcore/azerothcore-wotlk/commit/354697b59af47b3a032b11328d56306d8bfd9751, https://github.com/azerothcore/azerothcore-wotlk/commit/d321388981e96172e12e5ab3d90ebb2c7d3e464d, https://github.com/azerothcore/azerothcore-wotlk/commit/24307697eb60b091d67559aa6bed1844346957e0

poszer on 28 May 2019

❤2

All 6 comments

PS. When it comes to Waypoint, multi spawns have issue, but just added 1.
I think all of them need to be re-writen.

Knindzagxg on 11 May 2019

👍1

Hmm, let's go. One by one :rofl:

poszer on 11 May 2019

[x] ~~Related to this quest - https://wotlk.evowow.com/npc=27807?quest=12459~~
[x] ~~Not scripted AI for Weakened Overseer Deathgaze (This quest posible doesn't work ID: 12459)~~
~~First mob killed, correct.~~
~~Second quest mob killed, correct.~~
~~Third mob can kill, but he missing SAI, moving like without head.~~ - Fixed

2019-05-10 08:39:59 SmartScript: Action target Creature(entry: 27807) is not using SmartAI, action skipped to prevent crash.

[x] ~~Waiting my PR to be merged on master ( Than it will fix issue with this movements problems)~~ - Fixed

2019-05-05 17:33:50 WaypointMovementGenerator::LoadPath: creature Defias Overseer (Entry: 634 GUID: 3131333) doesn't have waypoint path id: 0 (Multi GUIDs)
2019-05-05 17:40:37 WaypointMovementGenerator::LoadPath: creature Defias Taskmaster (Entry: 4417 GUID: 3131460) doesn't have waypoint path id: 0 (Multi GUIDs)

[x] ~~Related to this quest - https://wotlk.evowow.com/?quest=10629~~
Checked, reproduced. The problem is that we missing creature in creature_template related to this quest. So, since this quest work like, yor pet have to summon gameobject after you kill creature there, and you loot them, until you find quest item, on the first try you are able to loot it, if the quest item isn't droped, and you try to kill second mob, than your mob spawn gameobject, but you are unable to loot it.
Found a fix for this also, will post in new PR. - Fixed

2019-05-08 13:20:11 Gameobject (GUID: 2140565 Entry: 184981) not created: non-existing entry in `gameobject_template`. Map: 530 (X: 174.656204 Y: 2941.460449 Z: 24.702682)
2019-05-09 15:49:48 Gameobject (GUID: 2136466 Entry: 184981) not created: non-existing entry in `gameobject_template`. Map: 530 (X: 463.308716 Y: 2914.412109 Z: 41.515911)
2019-05-09 15:51:14 Gameobject (GUID: 2136492 Entry: 184981) not created: non-existing entry in `gameobject_template`. Map: 530 (X: 503.835632 Y: 2955.605225 Z: 32.195271)
2019-05-11 15:36:32 Gameobject (GUID: 2144716 Entry: 184981) not created: non-existing entry in `gameobject_template`. Map: 530 (X: 500.778961 Y: 2955.333740 Z: 32.511833)
2019-05-11 15:37:32 Gameobject (GUID: 2144810 Entry: 184981) not created: non-existing entry in `gameobject_template`. Map: 530 (X: 473.075165 Y: 2987.416260 Z: 23.230686)

[x] ~~Creature::Create(): creature template Dunno what's this Entry, bcoz it doesnt exist in our Db, so more check will be fine.~~
~~Checked, posible problem is here, all of these entries are gameobjects, not creatures:~~ - Fixed in @Pondaveia referenced PR
https://github.com/azerothcore/azerothcore-wotlk/blob/bd749961868c0c4eb74f58c516319f35ab1cd84b/src/server/scripts/EasternKingdoms/ScarletEnclave/chapter1.cpp#L650

https://github.com/azerothcore/azerothcore-wotlk/blob/bd749961868c0c4eb74f58c516319f35ab1cd84b/src/server/scripts/EasternKingdoms/ScarletEnclave/chapter1.cpp#L652

https://github.com/azerothcore/azerothcore-wotlk/blob/bd749961868c0c4eb74f58c516319f35ab1cd84b/src/server/scripts/EasternKingdoms/ScarletEnclave/chapter1.cpp#L656

https://github.com/azerothcore/azerothcore-wotlk/blob/bd749961868c0c4eb74f58c516319f35ab1cd84b/src/server/scripts/EasternKingdoms/ScarletEnclave/chapter1.cpp#L660

2019-05-10 06:17:45 Creature::Create(): creature template (guidlow: 3158126, entry: 191577) does not exist.
2019-05-10 06:17:45 Creature::Create(): creature template (guidlow: 3158127, entry: 191583) does not exist.
2019-05-10 06:17:45 Creature::Create(): creature template (guidlow: 3158128, entry: 191587) does not exist.

https://github.com/azerothcore/azerothcore-wotlk/blob/67b8c472229a6250cc5675ecac65a9804fa55be9/src/server/game/Entities/Creature/Creature.cpp#L826

[x] MoveSplineInitArgs - Related to this NPC, it's in instance so we have to check it
https://wotlk.evowow.com/npc=17280 Shattered Hand Warhound
Done, checked. Problem is when you fight this two wolfs, and the one nps who's in formation with them when they patrol around. If you for example cast fear and run from them, than leave combat /evade. They re not despawned, they just continue their movement, leaving formation, moving some yards from this NPC near them. Than, they looks like '' walking '' but they not. Actually they 're waiting this NPC, to made fromation with them, than they continue to walk normally. In this case, i'll suggest to implement something on this like evade on combat force to despawn, or something like this.

2019-05-11 18:37:27 ERROR: MoveSplineInitArgs::Validate: expression 'velocity > 0.01f' failed for GUID: 202681 Entry: 17280 (Multi GUIDs)

[x] ~~Missing DB insert in this table and also in fishing_loot_template. 3479 is The Veiled Sea~~ - Fixed
~~Checked, found fix. Posible issue is if someone fishing there~~

2019-05-10 16:33:33 Fishable areaId 3479 are not properly defined in `skill_fishing_base_level`.

[x] ~~Wrong flags used on Creature Kelgruk Bloodaxe (Weaponsmith Trainer)~~ - Fixed

2019-05-06 01:08:18 Creature 6613 (Entry: 7231) have UNIT_NPC_FLAG_VENDOR but have empty trading item list.

This looks like Bloodprince loot issue, already was reported and fixed on TC with this commit :
https://github.com/TrinityCore/TrinityCore/commit/b7f2c87d37ad20e9fd39c6f0523f6b5edb9d4a66
https://www.bountysource.com/issues/1635844-bloodprince-loot-bug?utm_campaign=plugin&utm_content=tracker%2F1310&utm_medium=issues&utm_source=github

2019-05-11 19:10:07 ERROR: DoZoneInCombat called for creature that has empty threat list (creature entry = 15117)

poszer on 11 May 2019

Few SAI fixes for now. Most of them just have wrong Link IDs or issue with targets.

-- Table creature_template
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 9098;

-- Table smart_scripts
DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 9098);
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
(9098, 0, 0, 0, 11, 0, 100, 3, 0, 0, 0, 0, 58, 1, 13748, 1100, 3000, 30, 30, 1, 0, 0, 0, 0, 0, 0, 0, 'Scarshield Spellbinder - On Respawn - Install Template (No Repeat) (Normal Dungeon)'),
(9098, 0, 1, 0, 4, 0, 100, 2, 0, 0, 0, 0, 39, 10, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Scarshield Spellbinder - On Aggro - Call For Help (Normal Dungeon)'),
(9098, 0, 2, 0, 16, 0, 100, 2, 15123, 30, 3000, 6000, 11, 15123, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Scarshield Spellbinder - On Friendly Unit Missing Buff \'15123\' - Cast \'15123\' (Normal Dungeon)');

-- Table creature_template
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 16968; 

-- Table smart_scripts
DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 16968);
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
(16968, 0, 0, 1, 4, 0, 100, 0, 0, 0, 0, 0, 19, 33554432, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tunneler - On Aggro - Remove UNIT_FLAG_NOT_SELECTABLE'),
(16968, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 28, 29147, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tunneler - Link With Previous - Remove Tunnel Bore Passive'),
(16968, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 11, 37752, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tunneler - Link With Previous - Cast Stand'),
(16968, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tunneler - Link With Previous - Root'),
(16968, 0, 4, 5, 25, 0, 100, 0, 0, 0, 0, 0, 11, 29147, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tunneler - Spawn/Respawn/OOC - Cast Tunnel Bore Passive'),
(16968, 0, 5, 6, 61, 0, 100, 0, 0, 0, 0, 0, 18, 33554432, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tunneler - Link With Previous Set UNIT_FLAG_NOT_SELECTABLE'),
(16968, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 37751, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tunneler - Link With Previous - Cast Submerge'),
(16968, 0, 7, 0, 0, 0, 100, 0, 1000, 1000, 2100, 4500, 11, 31747, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Tunneler - In Combat - Cast Poison'),
(16968, 0, 8, 0, 0, 0, 100, 0, 10400, 10400, 45000, 50000, 11, 32738, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Tunneler - In Combat - Cast Bore'),
(16968, 0, 9, 0, 2, 0, 100, 0, 0, 30, 8000, 8000, 11, 32714, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tunneler - Between 0-30% Health - Cast 8599');

-- Table creature_template
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 30945; 

-- Table smart_scripts
DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 30945);
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
(30945, 0, 0, 1, 38, 0, 100, 0, 1, 1, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vardmadra - On Data Set 1 1 - Set Run On'),
(30945, 0, 1, 2, 61, 0, 100, 0, 1, 1, 0, 0, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 7234.74, 3643.58, 811.807, 5.507, 'Vardmadra - On Data Set 1 1 - Move To Position'),
(30945, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 1, 1, 10000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vardmadra - On Data Set 1 1 - Say Line 1'),
(30945, 0, 3, 0, 61, 0, 100, 1, 0, 0, 0, 0, 11, 25715, 2, 0, 0, 0, 0, 19, 30924, 200, 1, 0, 0, 0, 0, 'Vardmadra - On Data Set 1 1 - Cast \'Not-So-Honorable Combat: Summon Lady Nightswood\'s Moveto Target Bunny\''),
(30945, 0, 4, 5, 52, 0, 100, 0, 1, 30945, 0, 0, 1, 2, 10000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vardmadra - On Text 1 Over - Say Line 2'),
(30945, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 30924, 200, 1, 0, 0, 0, 0, 'Vardmadra - On Text 1 Over - Set Orientation Closest Creature \'Possessed Iskalder\''),
(30945, 0, 6, 7, 52, 0, 100, 0, 2, 30945, 0, 0, 1, 0, 10000, 0, 0, 0, 0, 11, 30955, 200, 0, 0, 0, 0, 0, 'Vardmadra - On Text 2 Over - Say Line 0'),
(30945, 0, 7, 8, 61, 0, 100, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 30955, 200, 0, 0, 0, 0, 0, 'Vardmadra - On Text 2 Over - Set Orientation Closest Creature \'Lady Nightswood\''),
(30945, 0, 8, 0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 11, 30955, 200, 0, 0, 0, 0, 0, 'Vardmadra - On Text 2 Over - Set Data 1 1'),
(30945, 0, 9, 0, 52, 0, 100, 0, 0, 30955, 0, 0, 5, 1, 10000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vardmadra - On Text 0 Over - Say Line 3'),
(30945, 0, 10, 0, 52, 0, 100, 0, 3, 30945, 0, 0, 1, 4, 10000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vardmadra - On Text 3 Over - Say Line 4'),
(30945, 0, 11, 0, 52, 0, 100, 0, 4, 30945, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vardmadra - On Text 4 Over - Despawn Instant'),
(30945, 0, 12, 0, 38, 0, 100, 0, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vardmadra - On Data Set 2 2 - Despawn Instant');

-- Table creature_template
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 20214; 

-- Table smart_scripts
DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 20214);
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
(20214, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 35788, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Arakkoa Egg - On Respawn - Cast \'35788\''),
(20214, 0, 1, 0, 0, 0, 100, 1, 2500, 2500, 0, 0, 11, 35788, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Arakkoa Egg - In Combat - Cast \'35788\' (No Repeat)');

DELETE FROM `smart_scripts` WHERE `entryorguid`=22374 AND `source_type`=0 AND `id`=1 AND `link`=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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES (22374, 0, 1, 0, 61, 0, 100, 257, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Hand of Kargath - On Update - Say Line 0');

-- Table creature_template
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 2044; 

-- Table smart_scripts
DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 2044);
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
(2044, 0, 0, 1, 11, 0, 100, 1, 0, 0, 0, 0, 1, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Forlorn Spirit - On Respawn - Say Line 0 (No Repeat)'),
(2044, 0, 1, 0, 61, 0, 100, 1, 0, 0, 0, 0, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, -10961.770508, 1566.371094, 45.618156, 4.3444406, 'Forlorn Spirit - On Respawn - Move To Position (No Repeat)'),
(2044, 0, 2, 3, 1, 0, 100, 1, 2500, 2500, 0, 0, 1, 2, 3, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Forlorn Spirit - Out of Combat - Say Line 2 (No Repeat)'),
(2044, 0, 3, 4, 61, 0, 100, 1, 0, 0, 0, 0, 1, 1, 3, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Forlorn Spirit - Out of Combat - Say Line 1 (No Repeat)'),
(2044, 0, 4, 0, 61, 0, 100, 1, 0, 0, 0, 0, 2, 16, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Forlorn Spirit - Out of Combat - Set Faction 16 (No Repeat)'),
(2044, 0, 5, 0, 0, 0, 100, 1, 2000, 2000, 2000, 2000, 11, 3105, 32, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Forlorn Spirit - In Combat - Cast \'3105\' (No Repeat)'),
(2044, 0, 6, 0, 0, 0, 100, 1, 5500, 5500, 0, 0, 11, 118, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Forlorn Spirit - In Combat - Cast \'118\' (No Repeat)');

More coming in next few days, and will cover text issues as well.

Knindzagxg on 17 May 2019