Jump to content

tomatosz

Members
  • Content count

    96
  • Joined

  • Last visited

Community Reputation

17 Neutral

About tomatosz

  • Rank
    Gentry
  • Birthday 07/27/1995

Profile Information

  • Gender
    Female

Recent Profile Visitors

278 profile views
  1. [Quests] Grizzly Hills

    Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9202Describe your fix: Fixed the prerequisites of all horde and neutral quests in Grizzly Hills. In particular the pit quest should no longer come up to early and block other quests.Account name: TomatoszComment: Used wowhead, gamepedia and youtube videos to verify the intended quest order as much as I could. There may still be an issue with the chain following Out of Body Experience (12327) since that quest is currently unavailable so I couldn't check the quests after it. One possible issue remains: There are two versions of Cleansing Drak'Tharon (12238 and 30120), they're both available as intended, but they can also both be completed on the same character, and I don't know what the blizzlike situation here is. SQL fix UPDATE quest_template SET NextQuestInChain=12257 WHERE entry=12468; -- Set A Show of Strength as nextquestinchain to The Conqueror’s Task UPDATE quest_template SET PrevQuestId=12468 WHERE entry=12256; -- Make The Conqueror’s Task the prereq of The Flamebinder’s Secrets UPDATE quest_template SET PrevQuestId=12468 WHERE entry=12257; -- Make The Conqueror’s Task the prereq of A Show of Strength UPDATE quest_template SET PrevQuestId=12259 WHERE entry=12451; -- Make The Thane of Voldrune the prereq of Onward To Camp Oneqwah UPDATE quest_template SET PrevQuestId=12412 WHERE entry=12208; -- Make My Enemy’s Friend the prereq of Good Troll Hunting UPDATE quest_template SET PrevQuestId=12412 WHERE entry=12453; -- Make My Enemy’s Friend the prereq of Eyes Above UPDATE quest_template SET NextQuestInChain=12037 WHERE entry=12029; -- Set Search and Rescue as nextquestinchain to Seared Scourge UPDATE quest_template SET PrevQuestId=12484 WHERE entry=12483; -- Make ScourgeKabob the prereq of Shimmercap Stew UPDATE quest_template SET PrevQuestId=12029 WHERE entry=12037; -- Make Seared Scourge the prereq of Search and Rescue UPDATE quest_template SET PrevQuestId=12029 WHERE entry=12038; -- Make Seared Scourge the prereq of Seared Scourge (daily) UPDATE quest_template SET PrevQuestId=12422 WHERE entry=12425; -- Make Tactical Clemency the prereq of Ruuna the Blind (horde) UPDATE quest_template SET PrevQuestId=0 WHERE entry=12427; -- Delete the incorrect prereq for The Conquest Pit: Bear Wrestling DELETE FROM conditions WHERE SourcetypeOrReferenceId=19 AND SourceEntry IN (12229,12231,12241,12242) AND ConditionTypeOrReference=8; INSERT INTO conditions (SourcetypeOrReferenceId, SourceGroup, SourceEntry, ElseGroup, ConditionTypeOrReference, ConditionValue1, Comment) VALUES (19,0,12229,1,8,12207, "A Possible Link (horde) is only available when Vordrassil's Fall is completed"), (19,0,12229,1,8,12213, "A Possible Link (horde) is only available when The Darkness Beneath is completed"), (19,0,12231,1,8,12207, "The Bear God's Offspring is only available when Vordrassil's Fall is completed"), (19,0,12231,1,8,12213, "The Bear God's Offspring is only available when The Darkness Beneath is completed"), (19,0,12241,1,8,12229, "Destroy the Sapling is only available when A Possible Link (horde) is completed"), (19,0,12241,1,8,12231, "Destroy the Sapling is only available when The Bear God's Offspring is completed"), (19,0,12242,1,8,12229, "Vordrassil's Seeds (horde) is only available when A Possible Link (horde) is completed"), (19,0,12242,1,8,12231, "Vordrassil's Seeds (horde) is only available when The Bear God's Offspring is completed");
  2. Are Iron Nodes still bugged?

    Instead of screenshots, the coordinates of those nodes would be helpful
  3. [Quests] in Well of Eternity

    Nvm there's more issues with these quests, they can't be implemented just like that.
  4. [Quests] in Well of Eternity

    Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9592Describe your fix: Added the queststarter to the quests inside Well of Eternity: In Unending Numbers, The Vainglorious, The Path to the Dragon Soul Account name: TomatoszComment: SQL fix DELETE FROM creature_quest_starter WHERE quest IN (30099,30100,30101); INSERT INTO creature_quest_starter (id, quest) VALUES (55624,30099), (55624,30100), (55624,30101);
  5. No more group quests in Cataclysm? :(

    Afaik this trend already started in TBC though, for instance Jinta'alor was a huge elite quest chain that required a group to complete, but it was already nerfed somewhere in TBC.
  6. [Quest] Out of Body Experience

    Oh the problem was in something like that? -_- alright I added all the possible stuff I could think of that could be wrong in requirements =D
  7. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/4933Describe your fix: Took Out of Body Experience out of any NextQuestId's, then added it to NextQuestId of Ruuna's Request and put Ruuna's Request as its PrevQuestId. Also made sure the queststarter can actually give the quest, and added questender for completeness sakes.Account name: TomatoszComment: Edited what I could think of, not sure if it will be fixed. SQL fix UPDATE quest_template SET NextQuestId=0 WHERE NextQuestId=12327; UPDATE quest_template SET NextQuestInChain=0 WHERE NextQuestInChain=12327; UPDATE quest_template SET NextQuestId=12327 WHERE entry=12328; UPDATE quest_template SET NextQuestInChain=12327 WHERE entry=12328; UPDATE quest_template SET AllowableRaces=0, RecuiredSkillId=0, RequiredSkillPoints=0, RequiredMinRepFaction=0, RequiredMinRepValue=0 RequiredMaxRepFaction=0, RequiredMaxRepValue=0, PrevQuestId=12328 WHERE entry=12327; DELETE FROM creature_queststarter WHERE quest=12327; INSERT INTO creature_queststarter (id, quest) VALUES (27581,12327); DELETE FROM creature_questender WHERE quest=12327; INSERT INTO creature_questender (id, quest) VALUES (27581,12327);
  8. [Answered] A question about bugged quest.

    You can always try to *bump* the bugtracker post if it hasn't been commented on in a while :) but yeah as Priestelar said, priorities (and given the amount of bugs on bugtracker of all types, an older one may escape notice).
  9. This doesn't even happen to the regular world channel right now, I think people should have a choice in whether they want to join the/a world channel or not.
  10. Sold stacks of mana drinks

    Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9560Describe your fix: I updated the stacks in which mana drinks are sold to 5.Account name: TomatoszComment: Since I'm not sure which exact drinks have the issue, I just made the fix for all the vendored ones that wowhead lists until 4.3.4 (except for the ones that don't sell in stacks of 5 ofc). SQL fix UPDATE item_template SET BuyCount=5 WHERE entry IN ( 63251, 74822, 59029, 58256, 59230, 41731, 42777, 33445, 59229, 58274, 33444, 38698, 43086, 44941, 27860, 29395, 29401, 32668, 32722, 33042, 34780, 35954, 37253, 38431, 40357, 28399, 38430, 29454, 32455, 75028, 19301, 8766, 13724, 38429, 21215, 1645, 19300, 1708, 1205, 19299, 1179, 17404, 49601, 49602, 159, 49254);
  11. Is warrior worth it?

    People are pretty surprised to see my troll warrior too :p
  12. Is warrior worth it?

    If you're looking for a (subjectively ofcourse) fun to play class, go ahead and play your warrior. While it's not the most tryhard class it can definitely hold its own. I'm currently at 5/7hc on my mostly prot warr (cause that's how far my guild has progressed), so i can't judge how it does on raggy hc, but on the encounters I have done it provides a challenge but is definitely doable. If you want to avoid being ridiculed, do NOT roll a warrior, especially prot :P
  13. Brewfest mounts

    I'm assuming you mean this mount? It drops from the Keg-Shaped Treasure Chest which you can only get once a day by queueing for "Coren Direbrew" in rdf, which I believe you can do once you reach level 80 (but I could be mistaken there). You can't get it by just going into the regular BRD. The droprate is low, but I don't know how low (wowhead says it's 4%). No quest is needed.
  14. [Quest] Stop the Ascension!

    Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9534Describe your fix: Added both the horde and alliance version of Vrykul Scroll of Ascension to the relevant npcs, and added conditions so it only drops after Skorn Must Fall!/Operation: Skortful Wrath. Account name: TomatoszComment: The pre-req takes care of the faction requirements, let me know if I should still add those conditions for faction changers. SQL fix DELETE FROM creature_loot_template WHERE item IN (33314,33345); INSERT INTO creature_loot_template (entry, item, ChanceOrQuestChance, lootmode, groupid, mincountOrRef, maxcount) VALUES (23661,33314,50,1,0,1,1), (23661,33345,50,1,0,1,1), (23662,33314,50,1,0,1,1), (23662,33345,50,1,0,1,1), (23663,33314,50,1,0,1,1), (23663,33345,50,1,0,1,1), (23664,33314,50,1,0,1,1), (23664,33345,50,1,0,1,1), (23665,33314,50,1,0,1,1), (23665,33345,50,1,0,1,1), (23666,33314,50,1,0,1,1), (23666,33345,50,1,0,1,1), (23667,33314,50,1,0,1,1), (23667,33345,50,1,0,1,1), (23668,33314,50,1,0,1,1), (23668,33345,50,1,0,1,1), (23669,33314,50,1,0,1,1), (23669,33345,50,1,0,1,1), (23670,33314,50,1,0,1,1), (23670,33345,50,1,0,1,1); DELETE FROM conditions WHERE SourceTypeOrReferenceId=1 AND SourceEntry IN (33314,33345); INSERT INTO conditions (SourcetypeOrReferenceId, SourceGroup, SourceEntry, ConditionTypeOrReference, ConditionValue1, Comment) VALUES (1,23661,33314,8,11248,"Vrykul Scroll of Ascension (33314) drops only after quest Operation: Skornful Wrath (11248) rewarded"), (1,23661,33345,8,11256,"Vrykul Scroll of Ascension (33345) drops only after quest Skorn Must Fall! (11256) rewarded"), -- Winterskorn Tribesman (1,23662,33314,8,11248,"Vrykul Scroll of Ascension (33314) drops only after quest Operation: Skornful Wrath (11248) rewarded"), (1,23662,33345,8,11256,"Vrykul Scroll of Ascension (33345) drops only after quest Skorn Must Fall! (11256) rewarded"), -- Winterskorn Woodsman (1,23663,33314,8,11248,"Vrykul Scroll of Ascension (33314) drops only after quest Operation: Skornful Wrath (11248) rewarded"), (1,23663,33345,8,11256,"Vrykul Scroll of Ascension (33345) drops only after quest Skorn Must Fall! (11256) rewarded"), -- Winterskorn Shield-Maiden (1,23664,33314,8,11248,"Vrykul Scroll of Ascension (33314) drops only after quest Operation: Skornful Wrath (11248) rewarded"), (1,23664,33345,8,11256,"Vrykul Scroll of Ascension (33345) drops only after quest Skorn Must Fall! (11256) rewarded"), -- Winterskorn Warrior (1,23665,33314,8,11248,"Vrykul Scroll of Ascension (33314) drops only after quest Operation: Skornful Wrath (11248) rewarded"), (1,23665,33345,8,11256,"Vrykul Scroll of Ascension (33345) drops only after quest Skorn Must Fall! (11256) rewarded"), -- Winterskorn Raider (1,23666,33314,8,11248,"Vrykul Scroll of Ascension (33314) drops only after quest Operation: Skornful Wrath (11248) rewarded"), (1,23666,33345,8,11256,"Vrykul Scroll of Ascension (33345) drops only after quest Skorn Must Fall! (11256) rewarded"), -- Winterskorn Berserker (1,23667,33314,8,11248,"Vrykul Scroll of Ascension (33314) drops only after quest Operation: Skornful Wrath (11248) rewarded"), (1,23667,33345,8,11256,"Vrykul Scroll of Ascension (33345) drops only after quest Skorn Must Fall! (11256) rewarded"), -- Winterskorn Rune-Seer (1,23668,33314,8,11248,"Vrykul Scroll of Ascension (33314) drops only after quest Operation: Skornful Wrath (11248) rewarded"), (1,23668,33345,8,11256,"Vrykul Scroll of Ascension (33345) drops only after quest Skorn Must Fall! (11256) rewarded"), -- Winterskorn Rune-Caster (1,23669,33314,8,11248,"Vrykul Scroll of Ascension (33314) drops only after quest Operation: Skornful Wrath (11248) rewarded"), (1,23669,33345,8,11256,"Vrykul Scroll of Ascension (33345) drops only after quest Skorn Must Fall! (11256) rewarded"), -- Winterskorn Oracle (1,23670,33314,8,11248,"Vrykul Scroll of Ascension (33314) drops only after quest Operation: Skornful Wrath (11248) rewarded"), (1,23670,33345,8,11256,"Vrykul Scroll of Ascension (33345) drops only after quest Skorn Must Fall! (11256) rewarded"); -- Winterskorn Elder
  15. [Quest] The Clutches of Evil

    Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/2585Describe your fix: Took The Clutches of Evil out of any NextQuestId's, made sure its PrevQuestId is empty and made sure the queststarter can actually give the quest. Also added questender for completeness sakes.Account name: TomatoszComment: Edited what I could think of, not sure if it will be fixed. SQL fix UPDATE quest_template SET NextQuestId=0 WHERE NextQuestId=11157; UPDATE quest_template SET NextQuestInChain=0 WHERE NextQuestInChain=11157; UPDATE quest_template SET PrevQuestId=0 WHERE entry=11157; DELETE FROM creature_queststarter WHERE quest=11157; INSERT INTO creature_queststarter (id, quest) VALUES (23749,11157); DELETE FROM creature_questender WHERE quest=11157; INSERT INTO creature_questender (id, quest) VALUES (23749,11157);
×