diff options
| author | MitchesD <majklprofik@seznam.cz> | 2016-01-17 20:52:49 +0100 |
|---|---|---|
| committer | MitchesD <majklprofik@seznam.cz> | 2016-01-17 20:52:49 +0100 |
| commit | 34a07db263d7f6f6099af79acb131ce744633c3b (patch) | |
| tree | 448f52137c8d17fdb4f410f5c2261ed4fdb9cf64 | |
| parent | 5fd33ef16c74cd2a4d1a1cedd1c0185ae4afcb13 (diff) | |
DB/Creature: fixed invalid spawnMasks for all creatures
* fixed +- 1500 startup errors
| -rw-r--r-- | sql/updates/world/2016_01_17_21_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2016_01_17_21_world.sql b/sql/updates/world/2016_01_17_21_world.sql new file mode 100644 index 00000000000..68f78c6eaec --- /dev/null +++ b/sql/updates/world/2016_01_17_21_world.sql @@ -0,0 +1,9 @@ +UPDATE `creature` SET `spawnMask`=16 WHERE `spawnMask`=1 AND `map`=550; +UPDATE `creature` SET `spawnMask`=6 WHERE `spawnMask`=3 AND `map`=542; +UPDATE `creature` SET `spawnMask`=512 WHERE `spawnMask`=1 AND `map`=531; +UPDATE `creature` SET `spawnMask`=6 WHERE `spawnMask`=24 AND `map`=33; +UPDATE `creature` SET `spawnMask`=8 WHERE `spawnMask`=1 AND `map`=509; +UPDATE `creature` SET `spawnMask`=24 WHERE `spawnMask`=3 AND `map` IN(603,533); +UPDATE `creature` SET `spawnMask`=512 WHERE `spawnMask`=1 AND `map`=409; +UPDATE `creature` SET `spawnMask`=120 WHERE `spawnMask`=15 AND `map`=631; +UPDATE `creature` SET `spawnMask`=6 WHERE `spawnMask`=3 AND `map` IN(668,657,595); |