SkyFire.406a icon indicating copy to clipboard operation
SkyFire.406a copied to clipboard

Stranglethorn graveyard

Open olivete opened this issue 12 years ago • 11 comments

Some graveyards are not working and we could add them by the regular way... dbc files and so.

Stranglethorn however is kinnda hard, i could not fix this one. Cant find its info and if a char dies there, he get teleported to barrens or forgot ally grave name :/

But the thing is, Stranglethorn grave yards are not working.

Would you please check this out?

Thanks alot!

olivete avatar May 19 '12 00:05 olivete

DB issue

Walkum avatar May 19 '12 01:05 Walkum

Are they not in the game_graveyard_zone?

Chpgmr avatar May 21 '12 22:05 Chpgmr

I dont think so... everybody dies there, get teleported to another area grave yard, just cant recall the gy of ally... for horde is barrens!

olivete avatar May 21 '12 22:05 olivete

Try these:

INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (1779, 5339, 0); INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (1780, 5339, 0); INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (1781, 5339, 0); INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (1782, 5339, 0); INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (1459, 5339, 0); INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (1458, 5339, 0); INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (1460, 5339, 0);

Let me know if there are others.

Chpgmr avatar May 21 '12 22:05 Chpgmr

Gonna try it, thanks VERY MUCH.

As soon as I can, I will return to let you know if this worked!

olivete avatar May 21 '12 22:05 olivete

I did not have a chance to restart the server yet, but doing a .reload game_graveyard_zone, did not work for both factions. I will restart very soon to confirm this.

Anyway, thank very much for trying help!

olivete avatar May 21 '12 22:05 olivete

hmm

Chpgmr avatar May 21 '12 23:05 Chpgmr

I think I find why this happens, so there is the Stranglethorn Vale (id: 5339) which contains 2 subzone : Northern Stranglethorn (id: 33) and The Cape of Stranglethorn (id : 5287). When graveyard are loaded, subzone links are skipped (get this errors on world console : Table game_graveyard_zone has a record for subzone id 33 instead of zone, skipped) And when you die in stranglethorn, you get this error : Table game_graveyard_zone incomplete : zone 33 Team 67 does not have a linked graveyard. So a possible fix will be to add a stranglethorn exception on graveyard loading and add the two stranglethorn subzone to graveyard (33 and 5287), I'm going to test it, I will return to let you know if this worked.

And sorry for my bad english

azuss avatar Jul 18 '12 19:07 azuss

Please do it and let us know! That is a very bad issue. Thanks alot azuss!

olivete avatar Jul 18 '12 19:07 olivete

Okay, it work ! here is the fix : In server source, in game/Globals/ObjectMgr.cpp, search for this string : "Table game_graveyard_zone has a record for subzone id (%u) instead of zone, skipped", on the if condition above, replace if (areaEntry->zone != 0) by if (areaEntry->zone != 0 && zoneId != 33 && zoneId != 5287). It permits to load the 2 stranglethorn subzone's graveyard.

In DB you have : DELETE FROM game_graveyard_zone WHERE id=109; INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (109, 214, 0); INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (109, 5287, 0); INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (109, 5339, 0);

DELETE FROM game_graveyard_zone WHERE id=389; INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (389, 33, 0); INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (389, 214, 0); INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (389, 5339, 0);

azuss avatar Jul 18 '12 19:07 azuss

Man, thanks alot!!!!

olivete avatar Jul 18 '12 20:07 olivete