azerothcore / azerothcore-wotlk

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

Minerals and herbs should be provided to all phase(phaseMask) #6931

Closed PkllonG closed 12 months ago

PkllonG commented 3 years ago

Current Behaviour

.go o 120721
Then step back 10 yards
Then go 10 yards

The minerals will disappear

Expected Blizzlike Behaviour

Minerals and herbs should be provided to all phase(phaseMask)

Source

No response

Steps to reproduce the problem

.go o 120721
Then step back 10 yards
Then go 10 yards

Extra Notes

No response

AC rev. hash/commit

1c45234

Operating system

w10 64

Custom changes or Modules

No response

--- Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/99900392-minerals-and-herbs-should-be-provided-to-all-phase-phasemask?utm_campaign=plugin&utm_content=tracker%2F40032087&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F40032087&utm_medium=issues&utm_source=github).
dr-j commented 3 years ago

Already addressed this a while ago


UPDATE `gameobject` SET `phaseMask`='255' WHERE  `id` IN(1617,1618,1619,3724,3725,3726,1620,1621,3727,3729,1622,1623,1624,2045,3730,2041,2046,1628,2044,2041,2043,176636,176642,142140,142141,142142,142143,142144,180165,183046,180164,176641,176640,176639,176638,176637,142145,176583,176584,176586,176587,176588,176589,180166,180167, 180168,183043,183044,183045,181270,181271,181275,181276,181277,181278,183385,181279,181282,181281,189973,190169,190173,190175,190174,190170,190172,191019,190171,190176,1731,181248,103713,2055,3763,1732,3764,103711,181249,2054,1733,1735,105569,73939,1734,2040,123310,150079,150080,176645,181109,2047,123309,150081,150082,181108,176643,123848,175404,181555,181556,181557,181569,181570,189978,189979,189980,189981,191133) AND `map` IN(0,1,530,571);
FrancescoBorzi commented 3 years ago

@dr-j thanks for providing a solution for this issue, I'd kindly ask you to provide a PR with it.

There are 2 ways of creating PRs at AzerothCore: