Jump to content

tomatosz

Members
  • Content count

    76
  • Joined

  • Last visited

Community Reputation

13 Neutral

About tomatosz

  • Rank
    Gentry
  • Birthday 07/27/1995

Profile Information

  • Gender
    Female

Recent Profile Visitors

221 profile views
  1. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9369Describe your fix: Fixed the prerequisites to all quests given by Koltira Deathweaver. Also connected some quests with NextQuestInChain making the intended chains a bit clearer.Account name: TomatoszComment: used these comments to connect the quests, and verified what I could using gitgudguides vids and a few other vids. Not entirely sure about the last (seperated) 6 lines of the fix, since that connects ExclusiveGroups using PrevQuestId instead of NextQuestId (couldn't use NextQuestId since the quests had other followups as well). SQL fix UPDATE quest_template SET NextQuestId=13237, NextQuestInChain=13237 WHERE entry=13260; -- Set Takes One to Know One as prereq for Poke and Prod with NextQuestInChain UPDATE quest_template SET PrevQuestId=13260 WHERE entry=13237; -- Same as above UPDATE quest_template SET PrevQuestId=13237, NextQuestInChain=13279 WHERE entry=13277; -- Set Poke and Prod as prereq for Against the Giants, Set Basic Chemistry as NextQuestInChain to Against the Giants UPDATE quest_template SET PrevQuestId=13277 WHERE entry=13278; -- Set Against the Giants as prereq for Coprous the Defiled UPDATE quest_template SET PrevQuestId=13277, NextQuestId=13281 WHERE entry=13279; -- Set Against the Giants as prereq for Basic Chemistry, set Basic Chemistry as prereq for Neutralizing the Plague UPDATE quest_template SET PrevQuestId=13279 WHERE entry=13281; -- Set Basic Chemistry as prereq for Neutralizing the Plague UPDATE quest_template SET PrevQuestId=13237 WHERE entry=13264; -- Set Poke and Prod as prereq for Thats Abominable! UPDATE quest_template SET PrevQuestId=13264 WHERE entry=13276; -- Set Thats Abominable! as prereq for Thats Abominable! (daily) UPDATE quest_template SET PrevQuestId=13264 WHERE entry=13351; -- Set Thats Abominable! as prereq for Sneak Preview UPDATE quest_template SET PrevQuestId=13351 WHERE entry=13354; -- Set Sneak Preview as prereq for Chain of Command UPDATE quest_template SET PrevQuestId=13351 WHERE entry=13355; -- Set Sneak Preview as prereq for Cannot Reproduce UPDATE quest_template SET PrevQuestId=13351 WHERE entry=13352; -- Set Sneak Preview as prereq for Drag and Drop UPDATE quest_template SET PrevQuestId=13352 WHERE entry=13353; -- Set Drag and Drop as prereq for Drag and Drop (daily) UPDATE quest_template SET PrevQuestId=13352, NextQuestId=13365 WHERE entry=13358; -- Set Drag and Drop as prereq for Not a Bug, set Not a Bug as prereq for Not a Bug (daily) UPDATE quest_template SET PrevQuestId=13358 WHERE entry=13365; -- Set Not a Bug as prereq for Not a Bug (daily) UPDATE quest_template SET PrevQuestId=13352, NextQuestInChain=13367 WHERE entry=13366; -- Set Drag and Drop as prereq for Need More Info, set No Rest for the Wicked as NextQuestInChain to Need More Info UPDATE quest_template SET PrevQuestId=13366 WHERE entry=13367; -- Set Need More Info as prereq for No Rest For the Wicked UPDATE quest_template SET PrevQuestId=13367 WHERE entry=13368; -- Set No Rest For The Wicked as prereq for No Rest For The Wicked (daily) UPDATE quest_template SET PrevQuestId=13366 WHERE entry=13306; -- Set Need More Info as prereq for Raise the Barricades UPDATE quest_template SET PrevQuestId=13306, NextQuestId=13329, NextQuestInChain=13329, ExclusiveGroup=-13307 WHERE entry=13307; -- Set Raise the Barricades as prereq for Bloodspattered Banners, set Bloodspattered Banners and The Ironwall Rampart as prereqs for Before the Gate of Horror with NextQuestInChain from Bloodspattered Banners UPDATE quest_template SET NextQuestId=13329, ExclusiveGroup=-13307 WHERE entry=13312; -- Set Bloodspattered Banners and The Ironwall Rampart as prereqs for Before the Gate of Horror UPDATE quest_template SET PrevQuestId=13329 WHERE entry=13328; -- Set Before the Gate of Horror as prereq for Shatter the Shards UPDATE quest_template SET PrevQuestId=13329 WHERE entry=13316; -- Set Before the Gate of Horror as prereq to The Guardians of Corprethar UPDATE quest_template SET NextQuestId=13363 WHERE entry=13362; -- Set Knowledge Is a Terrible Burden as prereq for Argent Aid UPDATE quest_template SET PrevQuestId=13362 WHERE entry=13363; -- Same as above UPDATE quest_template SET NextQuestInChain=13349 WHERE entry=13348; -- Set Cradle of the Frostblood as NextQuestInChain to Futility UPDATE quest_template SET PrevQuestId=13348 WHERE entry=13349; -- Set Futility as prereq for Cradle of the Frostblood UPDATE quest_template SET NextQuestId=13304, NextQuestInChain=13304 WHERE entry=13282; -- Set Return to the Surface as prereq for Field Repairs with NextQuestInChain UPDATE quest_template SET PrevQuestId=13282 WHERE entry=13304; -- Same as above UPDATE quest_template SET NextQuestInChain=12899 WHERE entry=12897 -- The Shadow Vault as NextQuestInChain to If He Cannot Be Turned UPDATE quest_template SET PrevQuestId=12897 WHERE entry=12899; -- Set If He Cannot Be Turned as prereq for The Shadow Vault UPDATE quest_template SET ExclusiveGroup=-13306 WHERE entry=13367; -- Attempt to set Raise the Barricades and No Rest For the Wicked as prereq for The Ironwall Rampart UPDATE quest_template SET ExclusiveGroup=-13306 WHERE entry=13306; -- Attempt to set Raise the Barricades and No Rest For the Wicked as prereq for The Ironwall Rampart UPDATE quest_template SET PrevQuestId=13306 WHERE entry=13312; -- Attempt to set Raise the Barricades and No Rest for the Wicked as prereq for The Ironwall Rampart UPDATE quest_template SET ExclusiveGroup=-12899 WHERE entry=12899; -- Attempt to set The Shadow Vault and Orgrims Hammer as prereqs for Opportunity UPDATE quest_template SET ExclusiveGroup=-12899 WHERE entry=13224; -- Attempt to set The Shadow Vault and Orgrims Hammer as prereqs for Opportunity UPDATE quest_template SET PrevQuestId=12899 WHERE entry=13258; -- Attempt to set The Shadow Vault and Orgrims Hammer as prereqs for Opportunity
  2. [Quest] Mind Tricks

    Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9411Describe your fix: Took Mind Tricks out of any NextQuestId's, added the correct PrevQuestId 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=13308; UPDATE quest_template SET NextQuestInChain=0 WHERE NextQuestInChain=13308; UPDATE quest_template SET PrevQuestId=13224 WHERE entry=13308; DELETE FROM creature_queststarter WHERE quest=13308; INSERT INTO creature_queststarter (id, quest) VALUES (31892,13308); DELETE FROM creature_questender WHERE quest=13308; INSERT INTO creature_questender (id, quest) VALUES (31892,13308);
  3. [Quest] Blood Ritual

    ONLY ALLIANCE VERSION. Details for possible horde fix under code. 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: Couldn't help it, as it's so similar to the Loramus Thalipedes Awaits quest that Herkor helped me fix. Horde version also has some walking, so I'll try to stop myself from trying to fix that one. Assumptions: - Kasim has no gossip options yet (i.e. SELECT* FROM gossip_menu_option WHERE menu_id=@GOSSIPMENU; is empty where SET @GOSSIPMENU=(SELECT gossip_menu_id FROM creature_template WHERE entry=42298);) - Kasim has no smart scripts yet (i.e. SELECT* FROM `smart_scripts` WHERE entryorguid=42298 AND `script_source_type`=0; is empty) - Kasim has no creature texts yet (i.e. SELECT* FROM `creature_text` WHERE `entry` = 42298; is empty) SQL fix: UPDATE creature_template SET npcflag=npcflag|1 WHERE entry=42298; -- Allow Gossip on Kasim SET @GOSSIPMENU=(SELECT gossip_menu_id FROM creature_template WHERE entry=42298); -- Save gossip_menu_id from Kasim -- Add gossip for quest script to Kasim DELETE FROM gossip_menu_option WHERE menu_id=@GOSSIPMENU; 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`=@GOSSIPMENU; INSERT INTO `conditions` (SourcetypeOrReferenceId, SourceGroup, SourceEntry, ElseGroup, ConditionTypeOrReference, ConditionValue1, NegativeCondition, Comment) VALUES (15,@GOSSIPMENU,1,1,9,26160,0,"Gossip only shows if player has quest Blood Ritual (alliance)."), (15,@GOSSIPMENU,1,1,28,26160,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` = 42298; INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`distance_range`,`BroadcastTextId`) VALUES (7506,0,0,'Very well. Stand back... this may get messy.',12,0,100,0,0,0,'Kasim Sharim',0,41391), (7506,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,41392); -- Make quest completable through smart scripts UPDATE quest_template SET SpecialFlags=SpecialFlags|2 WHERE entry=26160; -- Adding actual scripts SET @ENTRY := 42298; UPDATE creature_template SET AIName="SmartAI" WHERE entry= @ENTRY; DELETE FROM smart_scripts WHERE entryorguid=@ENTRY 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, 31, 0, 100, 0, 77573, 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, 26160, 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 // "); Details for Horde fix (anything not mentioned is the same): - npc is 7506 (instead of 42298) - quest is 25686 (instead of 26160) - gossip is 'I would like to start the Blood Ritual, Lynnore.' - after first talk she walks forward ca. 3 yards to ca. (-11466.5,-2629, 3.231252) in ca. 1-1.5sec (couldn't measure exactly, vid: https://www.youtube.com/watch?v=v0X46yrxYvI) - second talk is 'The blood ritual is complete... and I can now see where Loramus Thalipedes await you.' - after 2sec wait she walks back to original position - For Lynnore, gossip_menu_option id=1, creature_text group_id IN (0,1) and smart_scripts id IN (0,1,2,3,4) are already used (if my previous fix gets accepted), so don't use DELETE on those tables and start after these numbers.
  4. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9427 Describe your fix: Deleted spawns of these npc's in wrong place. Account name: Tomatosz Comment: SQL fix: DELETE FROM creature WHERE map=0 AND position_x>-10905 AND position_x<-10865 AND position_y>-2945 AND position_y<-2915 AND id IN (7505,7506);
  5. [Quests][Horde] Blasted Lands

    Bugtracker link: Not reported. Describe your fix: Fixed the prerequisites to the Horde Blasted Lands quests. This probably needs to be done for Alliance too. Account name: Tomatosz Comment: Made it fit the required quests on gamepedia. Verified it with gitgudguides vids. SQL fix: UPDATE quest_template SET NextQuestId=25696 WHERE entry=25695; -- Set Watching Our Back (horde) as prereq for The Sunveil Excursion UPDATE quest_template SET PrevQuestId=25695 WHERE entry=25696; -- Same as above UPDATE quest_template SET PrevQuestId=25703 WHERE entry IN (25705,25706,25707); -- Set Atrocities as prereq for False Idols, Neptools Revenge and The Future of the Rockpool UPDATE quest_template SET NextQuestId=25674, ExclusiveGroup=28553 WHERE entry=28553; -- Connect breadcrumbs for Blasted Lands (only one completable), set prereq for Futile Pride to be one of the breadcrumbs (Okrilla and the Blasted Lands) UPDATE quest_template SET NextQuestId=25674, ExclusiveGroup=28553 WHERE entry=28671; -- Same as above (Warchiefs Command: Blasted Lands!) UPDATE quest_template SET NextQuestId=25674, ExclusiveGroup=28553 WHERE entry=28858; -- Same as above (Blasted Lands: The Other Side of the World) UPDATE quest_template SET NextQuestId=25674, ExclusiveGroup=28553 WHERE entry=28865; -- Same as above (Call of the Warmatron) UPDATE quest_template SET PrevQuestId=0 WHERE entry=25674; -- Clear PrevQuestId for Futile Pride UPDATE quest_template SET PrevQuestId=25674 WHERE entry=25675; -- Set Futile Pride as prereq for Ogre Combat UPDATE quest_template SET PrevQuestId=25676, NextQuestId=25679, ExclusiveGroup=-25677 WHERE entry=25677; -- Set Heartstrike as prereq for Its All Mine, set Its All Mine and Pick Your Fate as prereqs for Into the Mountain UPDATE quest_template SET PrevQuestId=25676, NextQuestId=25679, ExclusiveGroup=-25677 WHERE entry=25678; -- Set Heartstrike as prereq for Pick Your Fate, set Its All Mine and Pick Your Fate as prereqs for Into the Mountain UPDATE quest_template SET PrevQuestId=25684 WHERE entry=25690; -- Set Attune the Bloodstone (horde) as prereq for A Bloodmages Gotta Eat Too (horde) UPDATE quest_template SET PrevQuestId=25689, NextQuestId=25693, ExclusiveGroup=-25691 WHERE entry=25691; -- Set Time is Short (horde) as prereq for The Charred Granite of the Dark Portal (horde), set The Charred Granite of the Dark Portal (horde) and The Vile Blood of Demons (horde) as prereqs for Enhancing the Stone UPDATE quest_template SET PrevQuestId=25689, NextQuestId=25693, ExclusiveGroup=-25691 WHERE entry=25692; -- Set Time is Short (horde) as prereq for The Vile Blood of Demons (horde), set The Charred Granite of the Dark Portal (horde) and The Vile Blood of Demons (horde) as prereqs for Enhancing the Stone (horde) UPDATE quest_template SET PrevQuestId=0 WHERE entry=25693; -- Clear PrevQuestId for Enhancing the Stone (horde) UPDATE quest_template SET PrevQuestId=25693, NextQuestId=25700, ExclusiveGroup=-25697 WHERE entry=25697; -- Set Enhancing the Stone as prereq for The Amulet of Allistarj (horde), set The Amulet of Allistarj (horde), The Amulet of Sevine (horde) and The Amulet of Grol (horde) as prereqs for Loramus Thalipedes Awaits UPDATE quest_template SET PrevQuestId=25693, NextQuestId=25700, ExclusiveGroup=-25697 WHERE entry=25698; -- Set Enhancing the Stone as prereq for The Amulet of Sevine (horde), set The Amulet of Allistarj (horde), The Amulet of Sevine (horde) and The Amulet of Grol (horde) as prereqs for Loramus Thalipedes Awaits UPDATE quest_template SET PrevQuestId=25693, NextQuestId=25700, ExclusiveGroup=-25697 WHERE entry=25699; -- Set Enhancing the Stone as prereq for The Amulet of Grol (horde), set The Amulet of Allistarj (horde), The Amulet of Sevine (horde) and The Amulet of Grol (horde) as prereqs for Loramus Thalipedes Awaits UPDATE quest_template SET PrevQuestId=0 WHERE entry=25700; -- Clear PrevQuestId for Loramus Thalipedes Awaits
  6. How to become a Content Fixer!

    Do Content Fixers have database access, or is that mostly reserved for devs?
  7. [NPC] Anzu placement (and NPC's around him)

    Oh crap, you're right, thanks. Changed it.
  8. [Quest] Loramus Thalipedes Awaits

    I want to do a similar one as well (Blood Ritual) but I'll wait till I get feedback on this one first =D Edit: nvm, too much stuff is different on Atlantiss, don't wanna bother ppl all the time.
  9. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9430Describe your fix: I have made the quest Loramus Thalipedes Awaits 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: Added two versions of this fix. The bottom one works on my local TrinityCore client. For the top one I used some values I saw Piklo use in a smart_scripts fix, namely action_type to add a timer and to talk, also a different name for a column in creature_text. It may need more adaptations as my local client doesn't have a quest_objectives table (dunno if Atlantiss does). Edit: Everything should be changed to Atlantiss values in the top one now, thanks Herkor! Assumptions (verified :) ): - Lynnore has no gossip options yet (i.e. SELECT* FROM gossip_menu_option WHERE menu_id=@GOSSIPMENU; is empty where SET @GOSSIPMENU=(SELECT gossip_menu_id FROM creature_template WHERE entry=7506);) - Lynnore has no smart scripts yet (i.e. SELECT* FROM `smart_scripts` WHERE entryorguid=7506 AND `script_source_type`=0; is empty) - Lynnore has no creature texts yet (i.e. SELECT* FROM `creature_text` WHERE `entry` = 7506; is empty) SQL fix: Atlantiss values (thanks Herkor for helping :) ) UPDATE creature_template SET npcflag=npcflag|1 WHERE entry=7506; -- Allow Gossip on Lynnore SET @GOSSIPMENU=(SELECT gossip_menu_id FROM creature_template WHERE entry=7506); -- Save gossip_menu_id from Lynnore -- Add gossip for quest script to Lynnore DELETE FROM gossip_menu_option WHERE menu_id=@GOSSIPMENU; INSERT INTO `gossip_menu_option` (menu_id,id,option_text,option_id,npc_option_npcflag) VALUES (@GOSSIPMENU,1,'I would like to start the Amulet Ritual, Lynnore.',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`=@GOSSIPMENU; INSERT INTO `conditions` (SourcetypeOrReferenceId, SourceGroup, SourceEntry, ElseGroup, ConditionTypeOrReference, ConditionValue1, NegativeCondition, Comment) VALUES (15,@GOSSIPMENU,1,1,9,25700,0,"Gossip only shows if player has quest Loramus Thalipedes Awaits."), (15,@GOSSIPMENU,1,1,28,25700,1,"Gossip only shows if player has not completed quest Loramus Thalipedes Awaits."); -- Adding necessary texts for the script to Lynnore DELETE FROM `creature_text` WHERE `entry` = 7506; INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`distance_range`,`BroadcastTextId`) VALUES (7506,0,0,'With the power within the amulets of Razelikh...',12,0,100,0,0,0,'Bloodmage Lynnore',0,41391), (7506,1,0,'... I bind you to his lair!',12,0,100,0,0,0,'Bloodmage Lynnore',0,41392); -- Make quest completable through smart scripts UPDATE quest_template SET SpecialFlags=SpecialFlags|2 WHERE entry=25700; -- Adding actual scripts SET @ENTRY := 7506; UPDATE creature_template SET AIName="SmartAI" WHERE entry= @ENTRY; DELETE FROM smart_scripts WHERE entryorguid=@ENTRY 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, 820, 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 820 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, 77581, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, " Linked - Self: Cast spell Amulet Ritual (77581) on Action invoker // "), (@ENTRY, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 0, 26, 25700, 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 Loramus Thalipedes Awaits (25700) for the whole group with GUID Action invoker // "); (@ENTRY, 0, 4, 0, 31, 0, 100, 0, 77581, 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, "On spell Amulet Ritual (77581) hit target - Self: Talk 1 // "), The one that worked locally (but some stuff that will be different in Atlantiss) UPDATE creature_template SET npcflag=npcflag|1 WHERE entry=7506; -- Allow Gossip on Lynnore SET @GOSSIPMENU=(SELECT gossip_menu_id FROM creature_template WHERE entry=7506); -- Save gossip_menu_id from Lynnore -- Add gossip for quest script to Lynnore DELETE FROM gossip_menu_option WHERE menu_id=@GOSSIPMENU; INSERT INTO `gossip_menu_option` (menu_id,id,option_text,option_id,npc_option_npcflag) VALUES (@GOSSIPMENU,0,'I would like to start the Amulet Ritual, Lynnore.',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`=@GOSSIPMENU; INSERT INTO `conditions` (SourcetypeOrReferenceId, SourceGroup, ElseGroup, ConditionTypeOrReference, ConditionValue1, NegativeCondition, Comment) VALUES (15,@GOSSIPMENU,1,9,25700,0,"Gossip only shows if player has quest Loramus Thalipedes Awaits."), (15,@GOSSIPMENU,1,28,25700,1,"Gossip only shows if player has not completed quest Loramus Thalipedes Awaits."); -- Adding necessary texts for the script to Lynnore DELETE FROM `creature_text` WHERE `entry` = 7506; INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`TextRange`,`BroadcastTextId`) VALUES (7506,0,0,'With the power within the amulets of Razelikh...',12,0,100,0,0,0,'Bloodmage Lynnore',0,41391), (7506,1,0,'... I bind you to his lair!',12,0,100,0,0,0,'Bloodmage Lynnore',0,41392); -- Make quest completable through smart scripts DELETE FROM quest_template_addon WHERE ID=25700; INSERT INTO quest_template_addon (ID,SpecialFlags) VALUES (25700,2); -- Adding actual scripts UPDATE creature_template SET AIName="SmartAI" WHERE entry= 7506; -- Allow Lynnore to use smart scripts. DELETE FROM `smart_scripts` WHERE entryorguid=7506 AND `source_type`=0; -- delete all smart scripts on Lynnore INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`comment`) VALUES (7506,0,1,62,@GOSSIPMENU,0,0,0,72,0,0,0,0,0,0,7,"Upon choosing gossip option 1, close gossip."), (7506,1,2,61,0,0,0,0,1,0,5000,0,0,0,0,7,"linked - Self: talk 0 to action invoker"), (7506,2,3,61,0,0,0,0,15,25700,0,0,0,0,0,7,"linked - Quest Loramus Thalipedes Awaits completed"), (7506,3,0,61,0,0,0,0,11,77581,0,0,0,0,0,7,"linked - Self: cast Amulet Ritual (77581) on action invoker"), (7506,4,0,52,0,7506,0,0,1,1,0,0,0,0,0,7,"5sec after talk0, Self: talk 1 to action invoker");
  10. [NPC] Bloodmage Lynnore

    Bugtracker link: not reportedDescribe your fix: Updated the gossip of Bloodmage Lynnore to the Cataclysm text (according to gamepedia)Account name: TomatoszComment: Noticed the difference in a Gidgutguides vid. SQL fix: SET @GOSSIPMENU=(SELECT gossip_menu_id FROM creature_template WHERE entry=7506); SET @NPCTEXT=(SELECT text_id FROM gossip_menu WHERE entry=@GOSSIPMENU); UPDATE npc_text SET text0_1='Blood magic is shunned by many as a dark and forgotten art. In that and many other ways, it shares some distinct characteristics with demonic magic. Here, in the demon-scourged remains of the Black Morass, we believe that our blood studies will flourish.' WHERE ID=@NPCTEXT;
  11. Quest Siegebreaker

    At least add the bugtracker link so that can be closed after :) https://github.com/Atlantiss/BugTracker/issues/1421
  12. Bugtracker link: - Describe your fix: Deleted the entries I added in a previous fix (https://community.atlantiss.eu/index.php?/topic/14499-riding-trainer-pamphlet-lvl20/) Account name: Tomatosz Comment: Turns out this should no longer be available in 4.2 (https://github.com/Atlantiss/BugTracker/issues/9376) SQL fix: DELETE FROM mail_loot_template WHERE Entry IN (224, 225, 226, 227, 228, 229, 230, 231, 232, 233);
  13. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/759 (only Anzu issue, not Talon King Ikiss) Describe your fix: Made the npcs in Anzu's room spawn only on normal, and moved Anzu to the middle of the room. Account name: Tomatosz Comment: I updated the spawnmask to only normal for the npc's that spawn both normal and heroic, and (just in case they exist) deleted the npc's in the room that spawn only on heroic (and are not Anzu). Chose the coordinates for updating/deleting in such a way that the guardians outside the room are unaffected (on my local server). SQL fix: UPDATE creature SET spawnMask=1 WHERE spawnMask=3 AND map=556 AND position_x>-138 AND position_x<-32 AND position_y>250 AND position_y<330 AND position_z>20 AND id<>23035; DELETE FROM creature WHERE spawnMask=2 AND map=556 AND position_x>-138 AND position_x<-32 AND position_y>250 AND position_y<330 AND position_z>20 AND id<>23035; UPDATE creature SET position_x=-89, position_y=288, position_z=26.483200, orientation=3.14159 WHERE id=23035;
  14. [Quests][Horde] Hinterlands

    Bugtracker link: Mostly a response to this fix to this alliance side issue, also https://github.com/Atlantiss/BugTracker/issues/8166. Describe your fix: Fixed the prerequisites to the Horde Hinterlands quests, and set a bunch of quests to pop up right after completing the previous one instead of having to click the questgiver again. Account name: Tomatosz Comment: Used a combination of Wowhead comments and Gitgudguides (and some more vids sometimes, when multiple quests activate 1 quest). All should fit with the vids now. SQL fix: UPDATE quest_template SET NextQuestInChain = 26224 WHERE entry = 26223; UPDATE quest_template SET PrevQuestId = 26263 WHERE entry IN (26267, 26268, 26283); -- Set Thornar Thunderclash as pre-req for Skulk Rock Clean-Up, Skulk Rock Supplies and Prime Slime UPDATE quest_template SET NextQuestId = 26432, NextQuestInChain = 26432, ExclusiveGroup = -26267 WHERE entry = 26267; -- Set both Skulk Rock Clean-Up and Skulk Rock Supplies as pre-req for The Fall of Jintha’Alor UPDATE quest_template SET NextQuestId = 26432, NextQuestInChain = 26432, ExclusiveGroup = -26267 WHERE entry = 26268; -- same as above UPDATE quest_template SET NextQuestInChain = 26307 WHERE entry = 26306; UPDATE quest_template SET NextQuestInChain = 26308 WHERE entry = 26307; UPDATE quest_template SET NextQuestId = 26367, ExclusiveGroup = -26307 WHERE entry = 26307; -- Set both Death to the Vilebranch and Heads Up as pre-req for Ongo’Longo’s Revenge UPDATE quest_template SET NextQuestId = 26367, ExclusiveGroup = -26307 WHERE entry = 26366; -- same as above UPDATE quest_template SET NextQuestInChain = 26363 WHERE entry = 26367; UPDATE quest_template SET NextQuestInChain = 26369 WHERE entry = 26363; UPDATE quest_template SET NextQuestId = 26384 WHERE entry = 26369; -- Set Hunt the Keeper as pre-req for Darkcleric Marnal UPDATE quest_template SET PrevQuestId = 26369 WHERE entry = 26384; -- same as above UPDATE quest_template SET NextQuestInChain = 26309 WHERE entry = 26310; UPDATE quest_template SET NextQuestId = 26368 WHERE entry = 26309; -- Set Dark Vessels (horde) as pre-req for Venomous Secrets UPDATE quest_template SET PrevQuestId = 26309 WHERE entry = 26368; -- same as above UPDATE quest_template SET NextQuestInChain = 26406 WHERE entry = 26381; UPDATE quest_template SET NextQuestInChain = 26418 WHERE entry = 26406; UPDATE quest_template SET NextQuestInChain = 26558 WHERE entry = 26418; UPDATE quest_template SET NextQuestInChain = 26419 WHERE entry = 26558; UPDATE quest_template SET NextQuestInChain = 26387 WHERE entry = 26382;
  15. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/3055 Describe your fix: Turned the Algaefin Rockfish schools into Deepsea Sagefish schools. Account name: Tomatosz Comment: - SQL fix: UPDATE gameobject SET id=208311 WHERE id=202781;
×