API tools faq
paste
Advertisement
kaderystalmane

Ernie Bug Fixes 7/29/15

kaderystalmane
Jul 30th, 2015
210
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.60 KB | None | 0 0
raw download clone embed print report
  1. /* Young Nightsaber (creature.id = 2031) will now use random move. */
  2. --Test Realm Bug
  3.  
  4. UPDATE 'world_mop'.'creature' SET 'spawndist' = 5 WHERE 'id' = 2031;
  5. --------------------------------------------------------------------------
  6. /* Ilthalaine (creature_template.entry = 2079) will now use proper capitalization when greeting the PC. */
  7. --Test Realm Bug
  8.  
  9. UPDATE `world_mop`.`creature_template` SET `gossip_menu_id`=55001 WHERE `entry`=2079;
  10. --------------------------------------------------------------------------
  11. /* Fel Moss Corruption (quest_template.id = 28714) will now properly use the PC's name when speaking to Ilthalaine during the quest. */
  12. --Test Realm Bug
  13.  
  14. UPDATE `world_mop`.`quest_template` SET `RequestItemsText`='Satisfy my suspicions, $n. Bring to me fel moss from the grelkin.' WHERE `Id`=28714;
  15. --------------------------------------------------------------------------
  16. /* Fel Moss Corruption (quest_template.id = 28714) will now properly use the PC's name when completing the quest. */
  17. --Test Realm Bug
  18.  
  19. UPDATE `world_mop`.`quest_template` SET `OfferRewardText`='Your service to the creatures of Shadowglen is worthy of reward, $n. $b$b You confirmed my fears, however. The grelkin are still tainted by fel moss, despite Teldrassil\'s blessing. Something sinister remains within the tree. I can only hope that the Gnarlpine tribe of furbolgs are free of the corruption, or we are still in grave danger. $b$b I will look into this further and contact those who might be of aid. Thank you, $c.' WHERE `Id`=28714;
  20. --------------------------------------------------------------------------
  21. /* Verdant Sigil (quest_template.id = 3120) will now become available after "Demonic Thieves" (quest_template.id = 28715). */
  22. --Test Realm Bug
  23.  
  24. UPDATE `world_mop`.`quest_template` SET `PrevQuestId`=28715 WHERE `Id`=3120;
  25. --------------------------------------------------------------------------
  26. /* Calligraphed Sigil (quest_template.id = 31168) will now become available after "Demonic Thieves" (quest_template.id = 28715). */
  27. --Test Realm Bug
  28.  
  29. UPDATE `world_mop`.`quest_template` SET `PrevQuestId`=28715 WHERE `Id`=31168;
  30. --------------------------------------------------------------------------
  31. /* Encrypted Sigil (quest_template.id = 3118) will now become available after "Demonic Thieves" (quest_template.id = 28715). */
  32. --Test Realm Bug
  33.  
  34. UPDATE `world_mop`.`quest_template` SET `PrevQuestId`=28715 WHERE `Id`=3118;
  35. --------------------------------------------------------------------------
  36. /* Etched Sigil (quest_template.id = 3117) will now become available after "Demonic Thieves" (quest_template.id = 28715). */
  37. --Test Realm Bug
  38.  
  39. UPDATE `world_mop`.`quest_template` SET `PrevQuestId`=28715 WHERE `Id`=3117;
  40. --------------------------------------------------------------------------
  41. /* Forbidden Sigil (quest_template.id = 26841) will now become available after "Demonic Thieves" (quest_template.id = 28715). */
  42. --Test Realm Bug
  43.  
  44. UPDATE `world_mop`.`quest_template` SET `PrevQuestId`=28715 WHERE `Id`=26841;
  45. --------------------------------------------------------------------------
  46. /* Hallowed Sigil (quest_template.id = 3119) will now become available after "Demonic Thieves" (quest_template.id = 28715). */
  47. --Test Realm Bug
  48.  
  49. UPDATE `world_mop`.`quest_template` SET `PrevQuestId`=28715 WHERE `Id`=3119;
  50. --------------------------------------------------------------------------
  51. /* Simple Sigil (quest_template.id = 3116) will now become available after "Demonic Thieves" (quest_template.id = 28715). */
  52. --Test Realm Bug
  53.  
  54. UPDATE `world_mop`.`quest_template` SET `PrevQuestId`=28715 WHERE `Id`=3116;
  55. --------------------------------------------------------------------------
  56. /* Training Dummy (creature_template.entry = 44614) is now stationary and quest updates correctly (.npc delete and .npc add 44548 in game in 21 locations). */
  57. --Test Realm Bug
  58.  
  59. UPDATE `world_mop`.`quest_template` SET `RequiredNpcOrGo1`=44548 WHERE `Id`=26940;
  60. --------------------------------------------------------------------------
  61. /* Training Dummy (creature_template.entry = 44614) is now stationary and quest updates correctly (.npc delete and .npc add 44548 in game in 21 locations). */
  62. --Test Realm Bug
  63.  
  64. UPDATE `world_mop`.`quest_template` SET `RequiredNpcOrGo1`=44548 WHERE `Id`=26945;
  65. --------------------------------------------------------------------------
  66. /* Training Dummy (creature_template.entry = 44614) is now stationary and quest updates correctly (.npc delete and .npc add 44548 in game in 21 locations). */
  67. --Test Realm Bug
  68.  
  69. UPDATE `world_mop`.`quest_template` SET `RequiredNpcOrGo1`=44548 WHERE `Id`=26946;
  70. --------------------------------------------------------------------------
  71. /* Training Dummy (creature_template.entry = 44614) is now stationary and quest updates correctly (.npc delete and .npc add 44548 in game in 21 locations). */
  72. --Test Realm Bug
  73.  
  74. UPDATE `world_mop`.`quest_template` SET `RequiredNpcOrGo1`=44548 WHERE `Id`=26947;
  75. --------------------------------------------------------------------------
  76. /* Training Dummy (creature_template.entry = 44614) is now stationary and quest updates correctly (.npc delete and .npc add 44548 in game in 21 locations). */
  77. --Test Realm Bug
  78.  
  79. UPDATE `world_mop`.`quest_template` SET `RequiredNpcOrGo1`=44548 WHERE `Id`=26948;
  80. --------------------------------------------------------------------------
  81. /* Training Dummy (creature_template.entry = 44614) is now stationary and quest updates correctly (.npc delete and .npc add 44548 in game in 21 locations). */
  82. --Test Realm Bug
  83.  
  84. UPDATE `world_mop`.`quest_template` SET `RequiredNpcOrGo1`=44548 WHERE `Id`=26949;
  85. --------------------------------------------------------------------------
  86. /* Training Dummy (creature_template.entry = 44614) is now stationary and quest updates correctly (.npc delete and .npc add 44548 in game in 21 locations). */
  87. --Test Realm Bug
  88.  
  89. UPDATE `world_mop`.`quest_template` SET `RequiredNpcOrGo1`=44548 WHERE `Id`=31169;
  90. --------------------------------------------------------------------------
  91. /* Priestess of the Moon (quest_template.id = 28723) now has correct spelling. */
  92. --Test Realm Bug
  93.  
  94. UPDATE `world_mop`.`quest_template` SET `OfferRewardText`='It is good that you\'ve come. It seems your training progresses quickly.' WHERE `Id`=28723;
  95. --------------------------------------------------------------------------
  96. /* Iverron's Antidote (quest_template.id = 28724) now has the PC name instead of <name> in the text. */
  97. --Test Realm Bug
  98.  
  99. UPDATE `world_mop`.`quest_template` SET `OfferRewardText`='These will do perfectly. Thank you, $n. Your swiftness is appreciated.' WHERE `Id`=28724;
  100. --------------------------------------------------------------------------
  101. /* The Balance of Nature (quest_template.id = 28713) now says the PC name in regular casing instead of ALL CAPS. */
  102. --Test Realm Bug
  103.  
  104. UPDATE `world_mop`.`quest_template` SET `OfferRewardText`='You performed your duties well, $n.' WHERE `Id`=28713;
  105. --------------------------------------------------------------------------
  106. /* Simple Sigil (quest_template.id = 3116) now says the PC name in regular casing instead of ALL CAPS. */
  107. --Test Realm Bug
  108.  
  109. UPDATE `world_mop`.`quest_template` SET `RequestItemsText`='You made it. I\'m so glad.$b$bMuch has happened over the last few years, $n: the creation of Teldrassil, the corruption of many of the forest creatures here and abroad, discovery of lands we thought lost to us like Feralas... so much, in so little time. But those are just some of the reasons we are here, the most important being to protect our kind from further evil.' WHERE `Id`=3116;
  110. --------------------------------------------------------------------------
  111. /* Encrypted Sigil (quest_template.id = 3118) now says the PC name instead of "Ferlis" when you turn in the quest. */
  112. --Test Realm Bug
  113.  
  114. UPDATE `world_mop`.`quest_template` SET `RequestItemsText`='Hello, $n. I\'m glad you found me. I was thinking that perhaps you got lost on the way here.$b$bNothing really new has happened in Shadowglen since I sent you my sigil, but I\'ll leave all the information gathering to you. Speak to the rest of the people around Aldrassil if you\'d like.' WHERE `Id`=3118;
  115. --------------------------------------------------------------------------
  116. /* Shanda (creature_template.entry = 3595) now says the PC name in correct case instead of ALL CAPS. */
  117. --Test Realm Bug
  118.  
  119. UPDATE `world_mop`.`npc_text` SET `text0_0`='My wisdom is yours, as is my knowledge. What can I do for you, $n?', `text0_1`='My wisdom is yours, as is my knowledge. What can I do for you, $n?' WHERE `ID`=4438;
  120. --------------------------------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!