[V12] Flight landing and other bug

[Patman24601]

[Location, Faction, Race] Darnassus, Alliance, Human
[Name, Type] Leora (flight master), flight path
[Problem Description] landing after a flight to this flight master in Darnassus causes the WoW client to crash. Origin was Rut'theran village. Worldserver provided error message: "ERROR [sql.sql] Creature (GUID: 34020 Entry: 1287] has wrong spell 0 defined in 'auras' field"
[How it should work] WoW should resume as normal after landing from a flight.

[Location, Faction, Race] Teldrassil, Alliance, Human
[Name, Type] Fidelio ,flight path
[Problem Description] landing after a flight to this flight master in Dolonaar,Teldrasill causes the WoW client to crash. Origin was Darnassus. This appears to happen with all flights within Teldrassil and Darnassus. Error in worldserver: "ERROR [entities.player] Character 11 have too short taxi destination list. teleport to original node."
[How it should work] WoW should resume as normal after landing from a flight.

[Location, Faction, Race] Elwynn Forest, Alliance, Human
[Name, Type] graveyard, spirit healer
[Problem Description] Character dying in Stormwind City; (for example, to a crazed cultist) get sent to a graveyard just outside the city, however there is no spirit healer in the graveyard if the player wanted to resurrect.
[How it should work] There should be a spirit healer in the graveyard.

 

[dolgan]

[Location, Faction, Race] Darnassus, Alliance, Human
[Name, Type] Leora (flight master), flight path
[Problem Description] landing after a flight to this flight master in Darnassus causes the WoW client to crash. Origin was Rut'theran village. Worldserver provided error message: "ERROR [sql.sql] Creature (GUID: 34020 Entry: 1287] has wrong spell 0 defined in 'auras' field"
[How it should work] WoW should resume as normal after landing from a flight.

[Location, Faction, Race] Teldrassil, Alliance, Human
[Name, Type] Fidelio ,flight path
[Problem Description] landing after a flight to this flight master in Dolonaar,Teldrasill causes the WoW client to crash. Origin was Darnassus. This appears to happen with all flights within Teldrassil and Darnassus. Error in worldserver: "ERROR [entities.player] Character 11 have too short taxi destination list. teleport to original node."
[How it should work] WoW should resume as normal after landing from a flight.

[Location, Faction, Race] Elwynn Forest, Alliance, Human
[Name, Type] graveyard, spirit healer
[Problem Description] Character dying in Stormwind City; (for example, to a crazed cultist) get sent to a graveyard just outside the city, however there is no spirit healer in the graveyard if the player wanted to resurrect.
[How it should work] There should be a spirit healer in the graveyard.

I have noticed that for some reason flight paths are setting off anticheat.

If you are not intending to make your server public and are just playing solo, you can stop the flight path crashing by disabling anti-cheat kicks.
set Anticheat.Action = 0 in worldserver.conf

Not an ideal soloution, but one that will work for now.
The aura's error would not cause your client to crash

 

[Patman24601]

That works. I mainly play solo, so I'll use that workaround. Thanks

 

[dolgan]

That works. I mainly play solo, so I'll use that workaround. Thanks

No Worries

Also, the spirit healer one.

It sends you to the wrong place when you die. The spirit healer is actually just above the G of Goldshire on the map, roughly 39.4 60.5

 

[ExO]

"[Location, Faction, Race] Elwynn Forest, Alliance, Human
[Name, Type] graveyard, spirit healer
[Problem Description] Character dying in Stormwind City; (for example, to a crazed cultist) get sent to a graveyard just outside the city, however there is no spirit healer in the graveyard if the player wanted to resurrect.
[How it should work] There should be a spirit healer in the graveyard."'

"It sends you to the wrong place when you die. The spirit healer is actually just above the G of Goldshire on the map, roughly 39.4 60.5"

-- FIXED in V13.1

 

[Maze]

"[Location, Faction, Race] Elwynn Forest, Alliance, Human
[Name, Type] graveyard, spirit healer
[Problem Description] Character dying in Stormwind City; (for example, to a crazed cultist) get sent to a graveyard just outside the city, however there is no spirit healer in the graveyard if the player wanted to resurrect.
[How it should work] There should be a spirit healer in the graveyard."'

"It sends you to the wrong place when you die. The spirit healer is actually just above the G of Goldshire on the map, roughly 39.4 60.5"

-- FIXED in V13.1

Character dying in Stormwind still get send to a wrong graveyard and miss the spirit healer for the Horde .
Here is a temp fix for V13.1. Should work for 13.0 too.

UPDATE game_graveyard_zone SET faction=0 WHERE id=854 AND ghost_zone=1519;
UPDATE game_graveyard_zone SET id=106, faction=469 WHERE id=107 AND ghost_zone=1519;
INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (1468, 1519, 67);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (6491, 0, 12, 91, 1, 1, 0, 0, -9561.22, -602.222, 58.3578, 3.88103, 300, 0, 0, 4120, 0, 0, 0, 0, 0, 0, 0);