server icon indicating copy to clipboard operation
server copied to clipboard
verified publisher icon LandSandBoat

🐛 Trial of The Magians 4718, 4719, 4698, 4699

Open Aeisu opened this issue 3 years ago • 3 comments

  • [x] I have paid attention to this example and will edit again if need be to not break the formatting, or I will be ignored
  • [x] I have searched existing issues to see if the issue has already been opened, and I have checked the commit log to see if the issue has been resolved since my server was last updated
  • [x] I have read and understood the Contributing Guide

Branch affected by issue

base

Steps to reproduce

Trade Valor Gauntlets +1 to Magian Moogle to begin Upgrade Trial quest 4719 See that the reward is an EXP Ring..... those thieving bastard moogles -.-

Expected behavior

Trade Valor Gauntlets +1 to Magian Moogle See that the reward is Valor Gauntlets +2

img_20220915_113044

Aeisu avatar Sep 15 '22 15:09 Aeisu

I found the problem, it lies int he Magians.sql Line 546 and 547 INSERT INTO magian VALUES (4718,15108,0,0,0,0,0,0,0,0,10796,0,0,0,0,0,0,0,0,1306,0,50,0,0); -- NQ INSERT INTO magian VALUES (4719,14915,0,0,0,0,0,0,0,0,10796,0,0,0,0,0,0,0,0,1307,0,30,0,0); -- HQ

The rewards are incorrect values the lines should read 10696 for Valor Gauntlets +2 not 10796 for Decennial Ring

INSERT INTO magian VALUES (4718,15108,0,0,0,0,0,0,0,0,10696,0,0,0,0,0,0,0,0,1306,0,50,0,0); -- NQ INSERT INTO magian VALUES (4719,14915,0,0,0,0,0,0,0,0,10696,0,0,0,0,0,0,0,0,1307,0,30,0,0); -- HQ

https://www.ffxiah.com/item/10696/vlr-gauntlets-2 https://www.ffxiah.com/item/10796/decennial-ring

Aeisu avatar Sep 15 '22 19:09 Aeisu

img_20220915_155948 looks like changing the numbers worked

Aeisu avatar Sep 15 '22 20:09 Aeisu

found another one with the wrong reward img_20220915_163751

Magian.sql Line 597 598 should be 10694 not 10794 for Duelist Gloves +2

INSERT INTO magian VALUES (4698,15106,0,0,0,0,0,0,0,0,10794,0,0,0,0,0,0,0,0,1306,0,50,0,0); -- NQ INSERT INTO magian VALUES (4699,14913,0,0,0,0,0,0,0,0,10794,0,0,0,0,0,0,0,0,1307,0,30,0,0); -- HQ

INSERT INTO magian VALUES (4698,15106,0,0,0,0,0,0,0,0,10694,0,0,0,0,0,0,0,0,1306,0,50,0,0); -- NQ INSERT INTO magian VALUES (4699,14913,0,0,0,0,0,0,0,0,10694,0,0,0,0,0,0,0,0,1307,0,30,0,0); -- HQ

https://www.ffxiah.com/item/10694/dls-gloves-2 https://www.ffxiah.com/item/10794/blenmots-ring

img_20220915_164743

Aeisu avatar Sep 15 '22 20:09 Aeisu

Related to #1586

Era-Lusiphur avatar Apr 13 '23 11:04 Era-Lusiphur