API tools faq
paste
Aokromes

phaseMask to PhaseId/PhaseGroup wip

Aokromes
Sep 1st, 2015
176
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.38 KB | None | 0 0
raw download clone embed print report
  1. --
  2. UPDATE `creature` SET `PhaseId`=169 WHERE `phaseMask`=1;
  3. UPDATE `creature` SET `PhaseId`=170 WHERE `phaseMask`=2;
  4. UPDATE `creature` SET `PhaseId`=171 WHERE `phaseMask`=4;
  5. UPDATE `creature` SET `PhaseId`=172 WHERE `phaseMask`=8;
  6. UPDATE `creature` SET `PhaseId`=173 WHERE `phaseMask`=16;
  7. UPDATE `creature` SET `PhaseId`=174 WHERE `phaseMask`=32;
  8. UPDATE `creature` SET `PhaseId`=175 WHERE `phaseMask`=64;
  9. UPDATE `creature` SET `PhaseId`=176 WHERE `phaseMask`=128;
  10. UPDATE `creature` SET `PhaseId`=177 WHERE `phaseMask`=256;
  11. UPDATE `creature` SET `PhaseId`=178 WHERE `phaseMask`=512;
  12.  
  13. UPDATE `creature` SET `PhaseGroup`=371 WHERE `phaseMask`=3; -- phasemask 1, 2 (phaseid 169, 170)
  14. UPDATE `creature` SET `PhaseGroup`=396 WHERE `phaseMask`=5; -- phasemask 1, 4 (phaseid 169, 171)
  15. UPDATE `creature` SET `PhaseGroup`=368 WHERE `phaseMask`=7; -- phasemask 1, 2, 4 (phaseid 169, 170, 171)
  16.  
  17. UPDATE `creature` SET `PhaseGroup`=392 WHERE `phaseMask`=10; -- phasemask 2, 8 (phaseid 170, 172)
  18. UPDATE `creature` SET `PhaseGroup`=xxx WHERE `phaseMask`=11; -- phasemask 1, 2, 8 (phaseid 169, 170, 172)
  19. UPDATE `creature` SET `PhaseGroup`=367 WHERE `phaseMask`=12; -- phasemask 4, 8 (phaseid 171, 172)
  20. UPDATE `creature` SET `PhaseGroup`=391 WHERE `phaseMask`=17; -- phasemask 1, 16 (phaseid 169, 173)
  21. UPDATE `creature` SET `PhaseGroup`=xxx WHERE `phaseMask`=20; -- phasemask 4, 16 (phaseid 171, 173)
  22. UPDATE `creature` SET `PhaseGroup`=374 WHERE `phaseMask`=49; -- phasemask 1, 16, 32 (phaseid 169, 173, 174)
  23. UPDATE `creature` SET `PhaseGroup`=394 WHERE `phaseMask`=66; -- phasemask 2, 64 (phaseid 170, 175)
  24. UPDATE `creature` SET `PhaseGroup`=408 WHERE `phaseMask`=69; -- phasemask 1, 4, 64 (phaseid 169, 170, 175)
  25.  
  26. UPDATE `creature` SET `PhaseGroup`=375 WHERE `phaseMask`=129; -- phasemask 1, 128 (phaseid 169, 176)
  27. UPDATE `creature` SET `PhaseGroup`=xxx WHERE `phaseMask`=131; -- phasemask 1, 2, 128 (phaseid 169, 170, 176)
  28. UPDATE `creature` SET `PhaseGroup`=xxx WHERE `phaseMask`=173; -- phasemask 1, 4, 8, 32, 128 (phaseid 169, 171, 172, 174, 176)
  29. UPDATE `creature` SET `PhaseGroup`=xxx WHERE `phaseMask`=175; -- phasemask 1, 2, 4, 8, 32, 128 (phaseid 169, 170, 171, 172, 174, 176)
  30. UPDATE `creature` SET `PhaseGroup`=369 WHERE `phaseMask`=192; -- phasemask 64, 128 (phaseid 175, 176)
  31. UPDATE `creature` SET `PhaseGroup`=397 WHERE `phaseMask`=193; -- phasemask 1, 64, 128 (phaseid 169, 175, 176)
  32. UPDATE `creature` SET `PhaseGroup`=400 WHERE `phaseMask`=197; -- phasemask 1, 4, 64, 128 (phaseid 169, 171, 175, 176)
  33.  
  34. UPDATE `creature` SET `PhaseGroup`=387 WHERE `phaseMask`=202; -- phasemask 2, 4, 64, 128 (phaseid 170, 171, 175, 176)
  35. UPDATE `creature` SET `PhaseGroup`=404 WHERE `phaseMask`=229; -- phasemask 1, 4, 32, 64, 128 (phaseid 169, 171, 174, 175, 176)
  36. UPDATE `creature` SET `PhaseGroup`=404 WHERE `phaseMask`=231; -- phasemask 1, 2, 4, 32, 64, 128 (phaseid 169, 170, 171, 174, 175, 176)
  37. UPDATE `creature` SET `PhaseGroup`=370 WHERE `phaseMask`=257; -- phasemask 1, 256 (phaseid 169, 177)
  38. UPDATE `creature` SET `PhaseGroup`=373 WHERE `phaseMask`=271; -- phasemask 1, 2, 4, 8, 256 (phaseid 169, 170, 171, 172, 177)
  39.  
  40. UPDATE `creature` SET `PhaseGroup`=376 WHERE `phaseMask`=487; -- phasemask 1, 2, 4, 32, 64, 128, 256 (phaseid 169, 170, 171, 174, 175, 176,177)
  41. UPDATE `creature` SET `PhaseGroup`=376 WHERE `phaseMask`=511; -- phasemask 1, 2, 4, 8, 16, 32, 64, 128, 256 (phaseid 169, 170, 171, 172, 173, 174, 175, 176, 177)
  42. UPDATE `creature` SET `PhaseGroup`=372 WHERE `phaseMask`=1023; -- phasemask 1, 2, 4, 8, 16, 32, 64, 128, 256, 512 (phaseid 169, 170, 171, 172, 173, 174, 175, 176, 177, 178)
  43.  
  44. --
  45. UPDATE `gameobject` SET `PhaseId`=169 WHERE `phaseMask`=1;
  46. UPDATE `gameobject` SET `PhaseId`=170 WHERE `phaseMask`=2;
  47. UPDATE `gameobject` SET `PhaseId`=171 WHERE `phaseMask`=4;
  48. UPDATE `gameobject` SET `PhaseId`=172 WHERE `phaseMask`=8;
  49. UPDATE `gameobject` SET `PhaseId`=173 WHERE `phaseMask`=16;
  50. UPDATE `gameobject` SET `PhaseId`=174 WHERE `phaseMask`=32;
  51. UPDATE `gameobject` SET `PhaseId`=175 WHERE `phaseMask`=64;
  52. UPDATE `gameobject` SET `PhaseId`=176 WHERE `phaseMask`=128;
  53. UPDATE `gameobject` SET `PhaseId`=177 WHERE `phaseMask`=256;
  54. UPDATE `gameobject` SET `PhaseId`=178 WHERE `phaseMask`=512;
  55.  
  56. UPDATE `gameobject` SET `PhaseGroup`=371 WHERE `phaseMask`=3; -- phasemask 1, 2 (phaseid 169, 170)
  57. UPDATE `gameobject` SET `PhaseGroup`=396 WHERE `phaseMask`=5; -- phasemask 1, 4 (phaseid 169, 171)
  58. UPDATE `gameobject` SET `PhaseGroup`=368 WHERE `phaseMask`=7; -- phasemask 1, 2, 4 (phaseid 169, 170, 171)
  59.  
  60. UPDATE `gameobject` SET `PhaseGroup`=392 WHERE `phaseMask`=10; -- phasemask 2, 8 (phaseid 170, 172)
  61. UPDATE `gameobject` SET `PhaseGroup`=xxx WHERE `phaseMask`=11; -- phasemask 1, 2, 8 (phaseid 169, 170, 172)
  62. UPDATE `gameobject` SET `PhaseGroup`=367 WHERE `phaseMask`=12; -- phasemask 4, 8 (phaseid 171, 172)
  63. UPDATE `gameobject` SET `PhaseGroup`=391 WHERE `phaseMask`=17; -- phasemask 1, 16 (phaseid 169, 173)
  64. UPDATE `gameobject` SET `PhaseGroup`=xxx WHERE `phaseMask`=20; -- phasemask 4, 16 (phaseid 171, 173)
  65. UPDATE `gameobject` SET `PhaseGroup`=374 WHERE `phaseMask`=49; -- phasemask 1, 16, 32 (phaseid 169, 173, 174)
  66. UPDATE `gameobject` SET `PhaseGroup`=394 WHERE `phaseMask`=66; -- phasemask 2, 64 (phaseid 170, 175)
  67. UPDATE `gameobject` SET `PhaseGroup`=408 WHERE `phaseMask`=69; -- phasemask 1, 4, 64 (phaseid 169, 170, 175)
  68.  
  69. UPDATE `gameobject` SET `PhaseGroup`=375 WHERE `phaseMask`=129; -- phasemask 1, 128 (phaseid 169, 176)
  70. UPDATE `gameobject` SET `PhaseGroup`=xxx WHERE `phaseMask`=131; -- phasemask 1, 2, 128 (phaseid 169, 170, 176)
  71. UPDATE `gameobject` SET `PhaseGroup`=xxx WHERE `phaseMask`=173; -- phasemask 1, 4, 8, 32, 128 (phaseid 169, 171, 172, 174, 176)
  72. UPDATE `gameobject` SET `PhaseGroup`=xxx WHERE `phaseMask`=175; -- phasemask 1, 2, 4, 8, 32, 128 (phaseid 169, 170, 171, 172, 174, 176)
  73. UPDATE `gameobject` SET `PhaseGroup`=369 WHERE `phaseMask`=192; -- phasemask 64, 128 (phaseid 175, 176)
  74. UPDATE `gameobject` SET `PhaseGroup`=397 WHERE `phaseMask`=193; -- phasemask 1, 64, 128 (phaseid 169, 175, 176)
  75. UPDATE `gameobject` SET `PhaseGroup`=400 WHERE `phaseMask`=197; -- phasemask 1, 4, 64, 128 (phaseid 169, 171, 175, 176)
  76.  
  77. UPDATE `gameobject` SET `PhaseGroup`=387 WHERE `phaseMask`=202; -- phasemask 2, 4, 64, 128 (phaseid 170, 171, 175, 176)
  78. UPDATE `gameobject` SET `PhaseGroup`=404 WHERE `phaseMask`=229; -- phasemask 1, 4, 32, 64, 128 (phaseid 169, 171, 174, 175, 176)
  79. UPDATE `gameobject` SET `PhaseGroup`=404 WHERE `phaseMask`=231; -- phasemask 1, 2, 4, 32, 64, 128 (phaseid 169, 170, 171, 174, 175, 176)
  80. UPDATE `gameobject` SET `PhaseGroup`=370 WHERE `phaseMask`=257; -- phasemask 1, 256 (phaseid 169, 177)
  81. UPDATE `gameobject` SET `PhaseGroup`=373 WHERE `phaseMask`=271; -- phasemask 1, 2, 4, 8, 256 (phaseid 169, 170, 171, 172, 177)
  82.  
  83. UPDATE `gameobject` SET `PhaseGroup`=376 WHERE `phaseMask`=487; -- phasemask 1, 2, 4, 32, 64, 128, 256 (phaseid 169, 170, 171, 174, 175, 176, 177)
  84. UPDATE `gameobject` SET `PhaseGroup`=376 WHERE `phaseMask`=511; -- phasemask 1, 2, 4, 8, 16, 32, 64, 128, 256 (phaseid 169, 170, 171, 172, 173, 174, 175, 176, 177)
  85. UPDATE `gameobject` SET `PhaseGroup`=372 WHERE `phaseMask`=1023; -- phasemask 1, 2, 4, 8, 16, 32, 64, 128, 256, 512 (phaseid 169, 170, 171, 172, 173, 174, 175, 176, 177, 178)
  86.  
  87. UPDATE `creature` SET `PhaseId`=169 WHERE `PhaseId`=1;
  88. UPDATE `creature` SET `PhaseId`=172 WHERE `PhaseId`=8;
  89. UPDATE `creature` SET `PhaseId`=174 WHERE `PhaseId`=32;
  90. UPDATE `creature` SET `PhaseId`=175 WHERE `PhaseId`=64;
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!