/sql/old/6.x/world/00_2014_10_19/2015_01_10_05_world.sql

https://gitlab.com/Eternal-WoW/TrinityCore-1 · SQL · 67 lines · 64 code · 2 blank · 1 comment · 0 complexity · 15b700e08be5acf5aad61a67fdfac805 MD5 · raw file 

    

  1. DELETE FROM `playercreateinfo` WHERE (`race`=1 AND `class`=10) OR (`race`=2 AND `class`=10) OR (`race`=3 AND `class`=10) OR (`race`=4 AND `class`=10) OR (`race`=5 AND `class`=10) OR (`race`=6 AND `class`=10) OR (`race`=24 AND `class`=8) OR (`race`=24 AND `class`=10) OR (`race`=24 AND `class`=1) OR (`race`=7 AND `class`=10) OR (`race`=24 AND `class`=3) OR (`race`=24 AND `class`=4) OR (`race`=24 AND `class`=5) OR (`race`=24 AND `class`=7) OR (`race`=8 AND `class`=10) OR (`race`=10 AND `class`=10) OR (`race`=11 AND `class`=10);
    2. 

  2. INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `position_x`, `position_y`, `position_z`) VALUES
    3. 

  3. (1, 10, 0, -8914.57, -133.909, 80.5378), -- Human - Monk
    4. 

  4. (2, 10, 1, -618.518, -4251.67, 38.718), -- Orc - Monk
    5. 

  5. (3, 10, 0, -6230.42, 330.232, 383.105), -- Dwarf - Monk
    6. 

  6. (4, 10, 1, 10311.3, 831.463, 1326.41), -- NightElf - Monk
    7. 

  7. (5, 10, 0, 1699.85, 1706.56, 135.928), -- Undead - Monk
    8. 

  8. (6, 10, 1, -2915.55, -257.347, 59.2693), -- Tauren - Monk
    9. 

  9. (24, 8, 860, 1466.09, 3465.98, 181.86), -- PandarenNeutral - Mage
    10. 

  10. (24, 10, 860, 1466.09, 3465.98, 181.86), -- PandarenNeutral - Monk
    11. 

  11. (24, 1, 860, 1466.09, 3465.98, 181.86), -- PandarenNeutral - Warrior
    12. 

  12. (7, 10, 0, -4983.42, 877.7, 274.31), -- Gnome - Monk
    13. 

  13. (24, 3, 860, 1466.09, 3465.98, 181.86), -- PandarenNeutral - Hunter
    14. 

  14. (24, 4, 860, 1466.09, 3465.98, 181.86), -- PandarenNeutral - Rogue
    15. 

  15. (24, 5, 860, 1466.09, 3465.98, 181.86), -- PandarenNeutral - Priest
    16. 

  16. (24, 7, 860, 1466.09, 3465.98, 181.86), -- PandarenNeutral - Shaman
    17. 

  17. (8, 10, 1, -1171.45, -5263.65, 0.847728), -- Troll - Monk
    18. 

  18. (10, 10, 530, 10349.6, -6357.29, 33.4026), -- BloodElf - Monk
    19. 

  19. (11, 10, 530, -3961.64, -13931.2, 100.615); -- Draenei - Monk
    20. 

  20. 

  21. UPDATE `playercreateinfo` SET `position_x`=-6230.42, `position_y`=330.232, `position_z`=383.105 WHERE `race`=3 AND `class`=3; -- Dwarf - Hunter
    22. 

  22. UPDATE `playercreateinfo` SET `position_x`=-6230.42, `position_y`=330.232, `position_z`=383.105 WHERE `race`=3 AND `class`=2; -- Dwarf - Paladin
    23. 

  23. UPDATE `playercreateinfo` SET `position_x`=-6230.42, `position_y`=330.232, `position_z`=383.105 WHERE `race`=3 AND `class`=1; -- Dwarf - Warrior
    24. 

  24. UPDATE `playercreateinfo` SET `position_x`=-6230.42, `position_y`=330.232, `position_z`=383.105 WHERE `race`=3 AND `class`=7; -- Dwarf - Shaman
    25. 

  25. UPDATE `playercreateinfo` SET `position_x`=-6230.42, `position_y`=330.232, `position_z`=383.105 WHERE `race`=3 AND `class`=5; -- Dwarf - Priest
    26. 

  26. UPDATE `playercreateinfo` SET `position_x`=-6230.42, `position_y`=330.232, `position_z`=383.105 WHERE `race`=3 AND `class`=4; -- Dwarf - Rogue
    27. 

  27. UPDATE `playercreateinfo` SET `position_x`=-6230.42, `position_y`=330.232, `position_z`=383.105 WHERE `race`=3 AND `class`=9; -- Dwarf - Warlock
    28. 

  28. UPDATE `playercreateinfo` SET `position_x`=-6230.42, `position_y`=330.232, `position_z`=383.105 WHERE `race`=3 AND `class`=8; -- Dwarf - Mage
    29. 

  29. UPDATE `playercreateinfo` SET `position_y`=831.463, `position_z`=1326.57 WHERE `race`=4 AND `class`=4; -- NightElf - Rogue
    30. 

  30. UPDATE `playercreateinfo` SET `position_y`=831.463, `position_z`=1326.57 WHERE `race`=4 AND `class`=5; -- NightElf - Priest
    31. 

  31. UPDATE `playercreateinfo` SET `position_y`=831.463, `position_z`=1326.57 WHERE `race`=4 AND `class`=1; -- NightElf - Warrior
    32. 

  32. UPDATE `playercreateinfo` SET `position_y`=831.463, `position_z`=1326.57 WHERE `race`=4 AND `class`=3; -- NightElf - Hunter
    33. 

  33. UPDATE `playercreateinfo` SET `position_y`=831.463, `position_z`=1326.57 WHERE `race`=4 AND `class`=8; -- NightElf - Mage
    34. 

  34. UPDATE `playercreateinfo` SET `position_y`=831.463, `position_z`=1326.57 WHERE `race`=4 AND `class`=11; -- NightElf - Druid
    35. 

  35. 

  36. -- By zone and orientation by Luhzinha 
    37. 

  37. UPDATE `playercreateinfo` SET `zone`=9,    `orientation`=5.13806 WHERE `race`=1  AND `class`=10; 
    38. 

  38. UPDATE `playercreateinfo` SET `zone`=14,   `orientation`=4.72222 WHERE `race`=2  AND `class`=10; 
    39. 

  39. UPDATE `playercreateinfo` SET `zone`=1,    `orientation`=6.17716 WHERE `race`=3  AND `class`=10; 
    40. 

  40. UPDATE `playercreateinfo` SET `zone`=141,  `orientation`=5.69632 WHERE `race`=4  AND `class`=10; 
    41. 

  41. UPDATE `playercreateinfo` SET `zone`=5692, `orientation`=4.88839 WHERE `race`=5  AND `class`=10; 
    42. 

  42. UPDATE `playercreateinfo` SET `zone`=221,  `orientation`=0.302378WHERE `race`=6  AND `class`=10; 
    43. 

  43. UPDATE `playercreateinfo` SET `zone`=5495, `orientation`=3.06393 WHERE `race`=7  AND `class`=10; 
    44. 

  44. UPDATE `playercreateinfo` SET `zone`=5691, `orientation`=5.78945 WHERE `race`=8  AND `class`=10; 
    45. 

  45. UPDATE `playercreateinfo` SET `zone`=3431, `orientation`=5.31605 WHERE `race`=10 AND `class`=10; 
    46. 

  46. UPDATE `playercreateinfo` SET `zone`=3526, `orientation`=2.08364 WHERE `race`=11 AND `class`=10; 
    47. 

  47. UPDATE `playercreateinfo` SET `zone`=5736, `orientation`=2.77359 WHERE `race`=24 AND `class`=1; 
    48. 

  48. UPDATE `playercreateinfo` SET `zone`=5736, `orientation`=2.77359 WHERE `race`=24 AND `class`=3; 
    49. 

  49. UPDATE `playercreateinfo` SET `zone`=5736, `orientation`=2.77359 WHERE `race`=24 AND `class`=4; 
    50. 

  50. UPDATE `playercreateinfo` SET `zone`=5736, `orientation`=2.77359 WHERE `race`=24 AND `class`=5; 
    51. 

  51. UPDATE `playercreateinfo` SET `zone`=5736, `orientation`=2.77359 WHERE `race`=24 AND `class`=7; 
    52. 

  52. UPDATE `playercreateinfo` SET `zone`=5736, `orientation`=2.77359 WHERE `race`=24 AND `class`=8; 
    53. 

  53. UPDATE `playercreateinfo` SET `zone`=5736, `orientation`=2.77359 WHERE `race`=24 AND `class`=10; 
    54. 

  54. UPDATE `playercreateinfo` SET `zone`=1519, `orientation`=0.67    WHERE `race`=25 AND `class`=1; 
    55. 

  55. UPDATE `playercreateinfo` SET `zone`=1519, `orientation`=0.67    WHERE `race`=25 AND `class`=3; 
    56. 

  56. UPDATE `playercreateinfo` SET `zone`=1519, `orientation`=0.67    WHERE `race`=25 AND `class`=4; 
    57. 

  57. UPDATE `playercreateinfo` SET `zone`=1519, `orientation`=0.67    WHERE `race`=25 AND `class`=5; 
    58. 

  58. UPDATE `playercreateinfo` SET `zone`=1519, `orientation`=0.67    WHERE `race`=25 AND `class`=7; 
    59. 

  59. UPDATE `playercreateinfo` SET `zone`=1519, `orientation`=0.67    WHERE `race`=25 AND `class`=8; 
    60. 

  60. UPDATE `playercreateinfo` SET `zone`=1519, `orientation`=0.67    WHERE `race`=25 AND `class`=10; 
    61. 

  61. UPDATE `playercreateinfo` SET `zone`=14,   `orientation`=0.13    WHERE `race`=26 AND `class`=1; 
    62. 

  62. UPDATE `playercreateinfo` SET `zone`=14,   `orientation`=0.13    WHERE `race`=26 AND `class`=3; 
    63. 

  63. UPDATE `playercreateinfo` SET `zone`=14,   `orientation`=0.13    WHERE `race`=26 AND `class`=4; 
    64. 

  64. UPDATE `playercreateinfo` SET `zone`=14,   `orientation`=0.13    WHERE `race`=26 AND `class`=5; 
    65. 

  65. UPDATE `playercreateinfo` SET `zone`=14,   `orientation`=0.13    WHERE `race`=26 AND `class`=7; 
    66. 

  66. UPDATE `playercreateinfo` SET `zone`=14,   `orientation`=0.13    WHERE `race`=26 AND `class`=8; 
    67. 

  67. UPDATE `playercreateinfo` SET `zone`=14,   `orientation`=0.13    WHERE `race`=26 AND `class`=10;
    68.