Jump to content

Tomaatje

Members
  • Content count

    98
  • Joined

  • Last visited

Community Reputation

18 Neutral

About Tomaatje

  • Rank
    Gentry
  • Birthday 07/27/1995

Profile Information

  • Gender
    Female

Recent Profile Visitors

351 profile views
  1. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/408Describe your fix: I have made the quest Blood Ritual (alliance) no longer autocomplete, and instead require a gossip option being used which triggers a small script (talking and a spell being cast).Account name: TomatoszComment: Ok, that previous fix was a mess, sorry for that :( Should have all the bugs out of the code now, and it will definitely note spread Kasim over the entire server anymore. It worked for me on the PTR, after the gossip fix from rev. 5541 is implemented. (To test before that fix, add this to the SQL: UPDATE creature_template SET gossip_menu_id=11613 WHERE entry=42298; INSERT INTO gossip_menu (entry, text_id) VALUES (11613,16214); ) SQL fix: SET @GOSSIPMENU := 11613; -- Save gossip_menu_id from Kasim SET @ENTRY := 42298; -- Save entry from Kasim SET @QUESTID := 26160; -- Save quest id UPDATE creature_template SET npcflag=npcflag|1 WHERE [email protected]; -- Allow Gossip on Kasim -- Add gossip for quest script to Kasim DELETE FROM gossip_menu_option WHERE [email protected]; INSERT INTO `gossip_menu_option` (menu_id,id,option_text,option_id,npc_option_npcflag) VALUES (@GOSSIPMENU,1,'I would like to start the Blood Ritual, Kasim.',1,1); -- Add conditions for the gossip to show up: must have quest but not have it finished DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`[email protected]; INSERT INTO `conditions` (SourcetypeOrReferenceId, SourceGroup, SourceEntry, ElseGroup, ConditionTypeOrReference, ConditionValue1, NegativeCondition, Comment) VALUES (15,@GOSSIPMENU,1,1,9,@QUESTID,0,"Gossip only shows if player has quest Blood Ritual (alliance)."), (15,@GOSSIPMENU,1,1,28,@QUESTID,1,"Gossip only shows if player has not completed quest Blood Ritual (alliance)."); -- Adding necessary texts for the script to Kasim DELETE FROM `creature_text` WHERE `entry` = @ENTRY; INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`distance_range`,`BroadcastTextId`) VALUES (@ENTRY,0,0,'Very well. Stand back... this may get messy.',12,0,100,0,0,0,'Kasim Sharim',0,42214), (@ENTRY,1,0,'The blood ritual is complete... and I can now see where three amulets await you.',12,0,100,0,0,0,'Kasim Sharim',0,42215); -- Make quest completable through smart scripts UPDATE quest_template SET SpecialFlags=SpecialFlags|2 WHERE [email protected]; -- Adding actual scripts UPDATE creature_template SET AIName="SmartAI" WHERE entry= @ENTRY; DELETE FROM smart_scripts WHERE [email protected] AND script_source_type=0; INSERT INTO smart_scripts (entryorguid, script_source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, event_cooldown_min, event_cooldown_max, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, source_type, source_param1, source_param2, source_param3, source_condition_id, target_type, target_param1, target_param2, target_param3, target_condition_id, target_x, target_y, target_z, target_o, comment) VALUES (@ENTRY, 0, 0, 1, 62, 0, 100, 0, @GOSSIPMENU, 1, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "On gossip action 1 from menu @GOSSIPMENU selected - Action invoker: Close gossip // "), (@ENTRY, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 0, 0, 195, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, " Linked - Self: Talk 0 // "), (@ENTRY, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 0, 0, 11, 77573, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, " Linked - Self: Cast spell Blood Ritual (77573) on Action invoker // "), (@ENTRY, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 0, 0, 187, 3000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, " Linked - Wait 3 seconds // "), (@ENTRY, 0, 4, 5, 61, 0, 100, 0, 0, 0, 0, 0, 0, 0, 195, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Linked - Self: Talk 1 // "), (@ENTRY, 0, 5, 6, 61, 0, 100, 0, 0, 0, 0, 0, 0, 0, 187, 2000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, " Linked - Wait 2 seconds // "), (@ENTRY, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 0, 26, @QUESTID, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, " Linked - Action invoker: Call event happened from quest Blood Ritual (26160) for the whole group with GUID Action invoker // ");
  2. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9677Describe your fix: I added the recipe Drakehide Leg Reinforcements to all trainers that should teach them according to Tauri.Account name: TomatoszComment: - SQL fix https://gist.github.com/tomatosz/b9c66d17927bd7db090e5ce236f0fa09
  3. [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");
  4. Are Iron Nodes still bugged?

    Instead of screenshots, the coordinates of those nodes would be helpful
  5. Nvm there's more issues with these quests, they can't be implemented just like that.
  6. Please move to rejected/delete 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
  7. 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.
  8. [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
  9. [Quest] Out of Body Experience

    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);
  10. [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).
  11. It's possible "world" channel for others languages?

    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.
  12. 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);
  13. Is warrior worth it?

    People are pretty surprised to see my troll warrior too :p
  14. 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
  15. 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.
×