Florix

Members
  • Content count

    536
  • Joined

  • Last visited

Everything posted by Florix

  1. Title: Kul Tiran Tailoring Bugtracker Link: https://firestorm-servers.com/en/report/index Patch Content: The Required Level to learn this spell is still set to Lv 110. Should be level 5. https://www.wowhead.com/spell=264630/kul-tiran-tailoring UPDATE `npc_trainer` SET `ReqLevel`='5' WHERE `ID`='153817' AND `SpellID`='264630';
  2. Title: Conjurer Margoss Bugtracker Link: https://firestorm-servers.com/en/report/see_report/112189 Patch Content: Alright, same issue as on BFA; 3 items are missing on this vendor. Patch content: Hes still selling only 5 out of 8 items. Missing items: https://www.wowhead.com/item=142531/crate-of-bobbers-squeaky-duck https://www.wowhead.com/item=143842/trashy https://www.wowhead.com/item=142532/crate-of-bobbers-murloc-head Fix: DELETE FROM `npc_vendor` WHERE `entry`=108825; INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES (108825, 8, 143842, 0, 6013, 1, 0, 0, 23420), (108825, 7, 142532, 0, 6014, 1, 0, 0, 23420), (108825, 6, 142531, 0, 6014, 1, 0, 0, 23420), (108825, 5, 138811, 0, 6014, 1, 0, 0, 23420), (108825, 4, 138810, 0, 6013, 1, 0, 0, 23420), (108825, 3, 136375, 0, 6029, 1, 0, 0, 23420), (108825, 2, 136376, 0, 6029, 1, 0, 0, 23420), (108825, 1, 139175, 0, 6119, 1, 0, 0, 23420);
  3. Title: Fishing Bobbers Bugtracker Link: https://firestorm-servers.com/en/report/index Patch Content: I've noticed, that the Fishing Bobber Buffs are stack-able. Nothing serious but i do not think, it is supposed to be like that. The id and group_id are custom. You have to check in Firestorms DB which are still free to use. Patch content: https://www.wowhead.com/item=136375/squeaky-duck-bobber https://www.wowhead.com/item=142531/crate-of-bobbers-squeaky-duck https://www.wowhead.com/item=147309/crate-of-bobbers-face-of-the-forest https://www.wowhead.com/item=142530/crate-of-bobbers-tugboat https://www.wowhead.com/item=143662/crate-of-bobbers-wooden-pepe https://www.wowhead.com/item=180993/bat-visage-bobber https://www.wowhead.com/item=147311/crate-of-bobbers-replica-gondola https://www.wowhead.com/item=147310/crate-of-bobbers-floating-totem https://www.wowhead.com/item=147308/crate-of-bobbers-enchanted-bobber https://www.wowhead.com/item=147312/crate-of-bobbers-demon-noggin https://www.wowhead.com/item=147307/crate-of-bobbers-carved-wooden-helm https://www.wowhead.com/item=136373/can-o-worms-bobber https://www.wowhead.com/item=133688/tugboat-bobber https://www.wowhead.com/item=142532/crate-of-bobbers-murloc-head https://www.wowhead.com/item=142529/crate-of-bobbers-cat-head https://www.wowhead.com/item=142528/crate-of-bobbers-can-of-worms https://www.wowhead.com/item=136376/murloc-bobber https://www.wowhead.com/item=136375/squeaky-duck-bobber https://www.wowhead.com/item=136374/toy-cat-head-bobber https://www.wowhead.com/item=180168/oribobber Patch: -- #5001/Spell - Fishing Bobber buff stacking DELETE FROM `spell_group` WHERE `id`='50001'; INSERT INTO `spell_group` (`id`,`spell_id`) VALUES ('50001','231341'), ('50001','207698'), ('50001','240806'), ('50001','231338'), ('50001','232613'), ('50001','335484'), ('50001','240804'), ('50001','240802'), ('50001','240800'), ('50001','240801'), ('50001','240803'), ('50001','207695'), ('50001','201741'), ('50001','231349'), ('50001','231319'), ('50001','231291'), ('50001','207699'), ('50001','207698'), ('50001','207696'), ('50001','330634'); DELETE FROM `spell_group_stack_rules` WHERE `group_id`='50001'; INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES ('50001','1');
  4. Title: A Lesson in Mineralogy Bugtracker Link: https://firestorm-servers.com/en/report/see_report/112718 Patch Content: The Quest https://www.wowhead.com/quest=34809/a-lesson-in-mineralogy got 2 quest enders, one NPC and one Object, only the object is correct. Also, for some reason, the "<>" in the German lang pack on ObjectiveItemtext and OfferRewardtext shows "&lt;" instead. DELETE FROM `creature_questender` WHERE `quest`='34809' AND `npc`='79201'; UPDATE `quest_template_locale` SET `ObjectiveItemsText_loc3`='<Die Gold-o-matik 9000 zischt und surrt wie schweres Gerät vor sich hin.>',`OfferRewardText_loc3`='<Die Gold-o-matik 9000 zerknirscht und zermalmt die Überreste der Elementare.>$B$BKnack-knack-tschack, Tschack-knacktschak-knack...' WHERE `entry`='34809';
  5. Title: A Grandmother's Remedy Bugtracker Link: https://firestorm-servers.com/en/report/see_report/112750 Patch Content: The Quest https://www.wowhead.com/quest=33077/a-grandmothers-remedy cannot be done because has no npc_spellclick_spells https://www.wowhead.com/spell=136040/create-toad-juice to get https://www.wowhead.com/item=110723/vial-of-toad-juice#objective-of from https://www.wowhead.com/npc=75470 DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`='75470'; INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`user_type`) VALUES ('75470','136040','0'); UPDATE `creature_template` SET `npcflag`='16777216' WHERE `entry`='75470'; DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`='18' AND `SourceGroup`='75470'; INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`) VALUES ('18','75470','136040','9','33077'); UPDATE `quest_template_locale` SET `ObjectiveText1_loc2`='Fiole de jus de crapaud', `ObjectiveText1_loc3`='Fläschchen Krötensaft', `ObjectiveText1_loc6`='Vial de zumo de sapo', `ObjectiveText1_loc7`='Vial de zumo de sapo', `ObjectiveText1_loc8`='Сосуд с жабьей слизью' WHERE `entry`='33077'; DELETE FROM `item_template_locale` WHERE `entry`='110723'; INSERT INTO `item_template_locale` VALUES (`entry`,`item_loc2`,`item_loc3`,`item_loc6`,`item_loc7`,`item_loc8`,`description_loc2`,`description_loc3`,`description_loc6`,`description_loc7`,`description_loc8`) VALUES ('110723','Fiole de jus de crapaud','Fläschchen Krötensaft','Vial de zumo de sapo','Vial de zumo de sapo','Сосуд с жабьей слизью','"Elle luit."','"Es leuchtet."','"Brilla."','"Brilla."','"Светится."'); Not sure if item_template_locale is still a thing in SL, i remember it existed back in MoP and Trinity Wiki was still displaying it.
  6. Title: The Mother Lode Bugtracker Link: https://firestorm-servers.com/en/report/index Patch Content: https://www.wowhead.com/quest=35080/the-mother-lode should only be offered by https://www.wowhead.com/npc=81109/kimzee-pinchwhistle if you have the previous quest https://www.wowhead.com/quest=35077/defungination completed. UPDATE `quest_template_addon` SET `PrevQuestID`='35077' WHERE `ID`='35080';
  7. Title: Favor: Quests Bugtracker Link: https://firestorm-servers.com/en/report/see_report/113050 Patch Content: I faced myself an issue with a SL quest, maybe same issue for the other Quests as well. Patch Content: https://www.wowhead.com/npc=160081/taxera https://www.wowhead.com/quest=58069 https://www.wowhead.com/quest=58070 https://www.wowhead.com/quest=58071 https://www.wowhead.com/quest=58072 https://www.wowhead.com/quest=58073 https://www.wowhead.com/quest=58074 https://www.wowhead.com/quest=58075 https://www.wowhead.com/quest=58077 https://www.wowhead.com/quest=58078 https://www.wowhead.com/quest=58079 https://www.wowhead.com/quest=58080 https://www.wowhead.com/quest=60889 https://www.wowhead.com/quest=58081 Fix: -- #160081/NPC - Ta'xera - missing end quests DELETE FROM `creature_questender` WHERE `id`='160081' AND `quest` IN ('58069','58070','58071','58072','58073','58074','58075','58081','58077','58078','58079','58080','60889'); INSERT INTO `creature_questender` (`id`,`quest`) VALUES ('160081','58069'), ('160081','58070'), ('160081','58071'), ('160081','58072'), ('160081','58073'), ('160081','58074'), ('160081','58075'), ('160081','58081'), ('160081','58077'), ('160081','58078'), ('160081','58079'), ('160081','58080'), ('160081','60889'); Screenshot of this issue:
  8. Title: A Worthy Challenge: Gug'rokk Bugtracker Link: https://firestorm-servers.com/en/report/see_report/112744 Patch Content: Disabling this quest https://www.wowhead.com/quest=37260/a-worthy-challenge-gugrokk because it should not be available for players anymore. UPDATE `quest_template` SET `QuestType`='1',`Flags`='16384' WHERE `ID`='37260';
  9. Title: Silverwing Battle Tabard Bugtracker Link: https://firestorm-servers.com/en/report/see_report/111408 Patch Content: Fixing the incorrect ID of the ExtendedCost in npc_vendor of https://www.wowhead.com/item=19506/silverwing-battle-tabard in all 8 NPC Vendors. -- #19506/Item - Silverwing Battle Tabard - re-adding the item to fix the extended cost, some vendors, like 5193 sell it twice. ExtendedCost ID 5971 = 10x 137642 (Mark of Honor) DELETE FROM `npc_vendor` WHERE `entry` IN ('108138','14753','5193','52278','5049','16766','133164','5191') AND `item`='19506'; INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `type`) VALUES ('108138','0','19506','0','0','5971','1'), ('14753','0','19506','0','0','5971','1'), ('5193','0','19506','0','0','5971','1'), ('52278','0','19506','0','0','5971','1'), ('5049','0','19506','0','0','5971','1'), ('16766','0','19506','0','0','5971','1'), ('133164','0','19506','0','0','5971','1'), ('5191','0','19506','0','0','5971','1');
  10. Title: Poundfist Bugtracker Link: https://firestorm-servers.com/en/report/see_report/112745 Patch Content: This creature should be a Rare Elite, not just a Elite. Most rare monster scanning AddOns wont track him. UPDATE `creature_template` SET `rank`='2' WHERE `entry`='50985';
  11. I would suggest to create a shop ticket with your issue.
  12. I have the option for paysafe card. I guess, it depends on the region you live in?
  13. Legion, BfA and Shadowlands don't really need a realmlist if you're using the WoW Client from Firestorm.
  14. There is no realm list for Firestorm. Firestorms 9.1.5 client connects to the server.
  15. Title: Raptor and Kodo Mounts Bugtracker Link: https://firestorm-servers.com/en/report/index Patch Content: For some reason, they got random movement. It looks stupid. Little bonus NPC because i noticed it: https://www.wowhead.com/npc=40222/scout-bat UPDATE `creature` SET `MovementType`='0',`spawndist`='0' WHERE `id` IN ('12354','12355','14542','14550','14549','34155','12350','12346','12350','14544','14545','14543','12349','40222');
  16. ay, 20k topic. very lit
  17. Title: Lost Gilnean Wardog Bugtracker Link: https://firestorm-servers.com/en/report/see_report/112658 Patch Content: The Mob is spawned in Thunder Bluff, probably it was a hunter pet https://www.wowhead.com/npc=51037/lost-gilnean-wardog while sniffing and it got badly spawned. DELETE FROM `creature` WHERE `id`='51037' AND `ZoneId`='1638'; UPDATE `creature_template` SET `ScaleLevelMin`='14',`ScaleLevelMax`='30' WHERE `entry`='51037': No idea if SL still is using ZoneId, but if not. 1638 = Thunderbluff / MapID = 1
  18. A lot of legacy questlines like from Mists of Pandaria are not working.
  19. The transfer/copy is free
  20. The 7th chapter is not released yet
  21. It doesn't really matter if https://www.wowhead.com/spell=348162/wandering-ancient is a promotion mounts, Firestorm added promotion mounts already to the shop Big Plus on this idea!