Florix

Members
 View profile  See their activity

  • Content count

    536

  • Joined

  • Last visited

Posts posted by Florix

  1. Posted · Edited by Florix

    Title: Engraved Stone Plaque
    Bugtracker Link:


    Patch Content:

     

    Well, book with a cool back story but it's not opening any page.
    About page_text_locale i wasn't sure which structure is used, the one on TrinityWiki looks weird.
    Data7 ID is custom.
    https://www.wowhead.com/object=237942/engraved-stone-plaque

     

      

    UPDATE `gameobject_template` SET `type`='10',`data7`='237942' WHERE `entry`='237942';
DELETE FROM `page_text` WHERE `entry`='237942';
INSERT INTO `page_text` VALUES 
('237942','In this dark cleft, the true shadows of madness and vengeance took hold, and many faithful Orgrimmar citizens lost their lives.$B$BLet us never forget the lessons that were learned in the siege of Orgrimmar.$B$BApart, we will fall. Together, we are Horde.','0','18935');
DELETE FROM `page_text_locale` WHERE `ID`='237942';
INSERT INTO `page_text_locale` (`ID`,`language`,`Name`) VALUES 
('237942','2','Dans cette faille sombre, les véritables ombres de la folie et de la vengeance ont fait leur nid, et bien des citoyens fidèles d’Orgrimmar y ont péri.$B$BN’oublions jamais les leçons apprises lors du siège d’Orgrimmar.$B$BDésunis, nous tomberons. Ensemble, nous sommes la Horde.'),
('237942','3','In dieser dunklen Kluft regieren die wahren Schatten des Wahnsinns und der Rache, und viele treue Bürger von Orgrimmar ließen ihr Leben.$B$BMögen wir die Lehren aus der Belagerung von Orgrimmar niemals vergessen.$B$BWenn wir nicht zusammenstehen, werden wir scheitern. Als Horde sind wir vereint.'),
('237942','6','En esta hendidura oscura, se arraigaron las verdaderas sombras de la locura y la venganza, y muchos ciudadanos fieles de Orgrimmar perdieron la vida.$B$BNunca olvidemos las lecciones que aprendimos en el asedio de Orgrimmar.$B$BSi nos separamos, caeremos. Juntos, somos una Horda.'),
('237942','8','В этой темной расселине обосновались истинные тени безумия и мести, и многие жители Оргриммара лишились жизни.$B$BДавайте же не будем забывать уроки, усвоенные нами при осаде Оргриммара.$B$BПорознь мы падем. Вместе мы – Орда.');

DELETE FROM `page_text_locale` WHERE `ID`='237942';
INSERT IGNORE INTO `page_text_locale` (`ID`, `locale`, `Text`) VALUES
('237942','frFR','Dans cette faille sombre, les véritables ombres de la folie et de la vengeance ont fait leur nid, et bien des citoyens fidèles d’Orgrimmar y ont péri.$B$BN’oublions jamais les leçons apprises lors du siège d’Orgrimmar.$B$BDésunis, nous tomberons. Ensemble, nous sommes la Horde.'),
('237942','deDE','In dieser dunklen Kluft regieren die wahren Schatten des Wahnsinns und der Rache, und viele treue Bürger von Orgrimmar ließen ihr Leben.$B$BMögen wir die Lehren aus der Belagerung von Orgrimmar niemals vergessen.$B$BWenn wir nicht zusammenstehen, werden wir scheitern. Als Horde sind wir vereint.'),
('237942','esES','En esta hendidura oscura, se arraigaron las verdaderas sombras de la locura y la venganza, y muchos ciudadanos fieles de Orgrimmar perdieron la vida.$B$BNunca olvidemos las lecciones que aprendimos en el asedio de Orgrimmar.$B$BSi nos separamos, caeremos. Juntos, somos una Horda.'),
('237942','ruRU','В этой темной расселине обосновались истинные тени безумия и мести, и многие жители Оргриммара лишились жизни.$B$BДавайте же не будем забывать уроки, усвоенные нами при осаде Оргриммара.$B$BПорознь мы падем. Вместе мы – Орда.');

     

     

  3. Posted

    Title: Slimy Mackerel School
    Bugtracker Link:

    https://firestorm-servers.com/en/report/see_report/114318

    Patch Content:

    Empty object without any loot. Data1 might have a different ID
    https://www.wowhead.com/object=278403/slimy-mackerel-school

    https://www.wowhead.com/item=152544/slimy-mackerel

      

    -- Slimy Mackerel School                     -278403
UPDATE `gameobject_template` SET `Data1`='278403' WHERE  `entry`=278403;

DELETE FROM `gameobject_loot_template` WHERE `Entry` = 278403;
INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(278403, 152544, 0, 100, 0, 1, 1, 1, 1, 'Slimy Mackerel');

     

  4. Posted

    Title: Eat Your Greens
    Bugtracker Link:

    https://firestorm-servers.com/en/report/index

    Patch Content:

    So, i did the achievement https://www.wowhead.com/achievement=12588/eat-your-greens in Nazmir and noticed, that all the buffs stack. I watched some retail videos where this was not the case.
    Note: each buff gives 10% stat, like crit, mastery and so on
    Note2: the ID 5001 is custom

    Patch Content:
    https://www.wowhead.com/spell=273779
    https://www.wowhead.com/spell=273797
    https://www.wowhead.com/spell=275054
    https://www.wowhead.com/spell=273781
    https://www.wowhead.com/spell=275032
    https://www.wowhead.com/spell=275059

      

    DELETE FROM `spell_group` WHERE `id`='5001';
INSERT INTO `spell_group` (`id`,`spell_id`) VALUES 
('5001','273779'),
('5001','273797'),
('5001','275054'),
('5001','273781'),
('5001','275032'),
('5001','275059');
DELETE FROM `spell_group_stack_rules` WHERE `group_id`='5001';
INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES 
('5001','1');

     

  7. Posted · Edited by Florix

    Your character name: Florix
    Character who you're reporting: Teccanina, Laelitha, Bloodstriker
    Realm: Oribos
    Date of incident: 12/04/22
    Description & Evidence:

     

    After posting my guild-ad, Teccanina started to write crap about Germans. I've pointed out, that i can report him for the stuff he is typing but he continued and others joined.

    The world_en chat should not be a place for this kind of bevaivor in a 12+ rated game and there need to be harder sanctions.

    VxvXgyO.png

    rBYIwF4.png

     

  9. Posted

    Title: Great Sea Catfish School
    Bugtracker Link:

    https://firestorm-servers.com/en/report/see_report/114243

    Patch Content:

    Empty object without any loot. Data1 might have a different ID

    Patch Content:
    https://www.wowhead.com/item=152547/great-sea-catfish

    https://www.wowhead.com/object=278399/great-sea-catfish-school

      

    -- Great Sea Catfish School                       -278399
UPDATE `gameobject_template` SET `Data1`='278399' WHERE  `entry`=278399;

DELETE FROM `gameobject_loot_template` WHERE `Entry` = 278399;
INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(278399, 152547, 0, 100, 0, 1, 1, 1, 1, 'Great Sea Catfish');

     

  11. Posted

    Title: NPC level 123 => 45
    Bugtracker Link:

    https://firestorm-servers.com/en/report/see_report/114240

    Patch Content:

    NPCs with level 123 instead of 45

    Patch Content:

    https://www.wowhead.com/npc=105982
    https://www.wowhead.com/npc=103834
    https://www.wowhead.com/npc=105983
    https://www.wowhead.com/npc=106000
    https://www.wowhead.com/npc=106030
    https://www.wowhead.com/npc=106004
    https://www.wowhead.com/npc=103830
    https://www.wowhead.com/npc=105976
    https://www.wowhead.com/npc=109609
    https://www.wowhead.com/npc=94456
    https://www.wowhead.com/npc=94458
    https://www.wowhead.com/npc=106054
    https://www.wowhead.com/npc=106056
    https://www.wowhead.com/npc=106023 

    UPDATE `creature_template` SET `minlevel`='45',`maxlevel`='45' WHERE `entry` IN ('105982','103834','105983','106000','106030','106004','103830','105976','109609','94456','94458','106054','106056','106023');

     

  12. Posted

    Title: Beastmaster Tagh
    Bugtracker Link:

    https://firestorm-servers.com/en/report/see_report/114223

    Patch Content:

    NPC missing 3 Quests.

     

    Patch Content:

    https://www.wowhead.com/npc=80833/beastmaster-tagh

    https://www.wowhead.com/quest=34108/wanted-kiluun

    https://www.wowhead.com/quest=34106/wanted-ratok-the-hammer

    https://www.wowhead.com/quest=34107/wanted-hilaani

      

    DELETE FROM `creature_queststarter` WHERE `id`='80833';
INSERT INTO `creature_queststarter` (`id`,`quest`) VALUES
('80833','34106'),
('80833','34108'),
('80833','34107');
DELETE FROM `creature_questender` WHERE `id`='80833';
INSERT INTO `creature_questender` (`id`,`quest`) VALUES
('80833','34106'),
('80833','34108'),
('80833','34107');
UPDATE `creature_template` SET `npcflag`='3' WHERE `entry`='80833';

     

  13. Posted

    Title: Out of the Chains
    Bugtracker Link:

    https://firestorm-servers.com/en/report/see_report/114213

    Patch Content:

    The required quest item https://www.wowhead.com/item=110664/bloodmaul-slave-key does not drop from https://www.wowhead.com/npc=78778/rugrum-the-pit-boss

    Patch Content:

    https://www.wowhead.com/quest=34314/out-of-the-chains

    https://www.wowhead.com/npc=78778/rugrum-the-pit-boss

    https://www.wowhead.com/item=110664/bloodmaul-slave-key

      

    DELETE FROM `creature_loot_template` WHERE `entry`='78778' AND `item`='110664';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `shared`) VALUES 
(78778, 110664, -71, 0, 0, 1, 1, 0);

     

  18. Posted

    Title: Usuri Brightcoin
    Bugtracker Link:

    https://firestorm-servers.com/en/report/index

    Patch Content:

    Comment from 4.0.1  "As of patch 4.0.1 this vendor has no items but she'll still buy your junk."
    Comment from 7.0.3 "Seems to be still the case... She has nothing to sell. Wish Blizzard wouldn't abandon NPCs like this."

    Patch Content:
    https://www.wowhead.com/npc=35790
    https://www.wowhead.com/item=40752
    https://www.wowhead.com/item=45624
    https://www.wowhead.com/item=40753
    https://www.wowhead.com/item=47241

     

    Fix:
      

    DELETE FROM `npc_vendor` WHERE `entry`='35790' AND `item` IN ('40752','45624','40753','47241');

     

  19. Posted

    Title: Spirit Drinker
    Bugtracker Link:

    https://firestorm-servers.com/en/report/index

    Patch Content:

    The Bonus Quest https://www.wowhead.com/quest=57591/spirit-drinker does not provide any reputation, which was odd for me. I checked on Youtube and several videos, showing how players got reputation from this quest. And of course, there are more quest with this ID but only 57591 is available on Firestorm.
    I'm not really used to quest_template_addon so bear with me for any mistakes.

    Fix:
      

    UPDATE `quest_template_addon` SET `RequiredMinRepFaction`='2417',`RequiredMaxRepFaction`='2417',`RequiredMinRepValue`='15',`RequiredMaxRepValue`='15'  WHERE `ID`='57591';

     

  20. Posted

    Title: Nixi Fireclaw
    Bugtracker Link:

    https://firestorm-servers.com/en/report/index

    Patch Content:

    This vendor https://www.wowhead.com/npc=32334/nixi-fireclaw used to sell https://www.wowhead.com/item=43236/stars-sorrow in WotLK but  it got removed in later a patch. This item cannot be bought by players because of unavailable currency.

    Patch Content:

    https://www.wowhead.com/npc=32334/nixi-fireclaw

    https://www.wowhead.com/item=43236/stars-sorrow

    Fix: 

    DELETE FROM `npc_vendor` WHERE `entry`='32334' AND `item`='43236';

     

    ZPVlZf7.png

  21. Posted

    Title: Demonic Gateway
    Bugtracker Link:

    https://firestorm-servers.com/en/report/index

    Patch Content:

    Shortly after a Server Restart, i have spotted this random Demonic Gateway in Stormsong Valley which does not belong there. For sure it is from a sniff which has not been removed yet.

    Patch Content:
    https://www.wowhead.com/stormsong-valley
    https://www.wowhead.com/npc=59262/demonic-gateway

    Fix:
      

    DELETE FROM `creature` WHERE `ID`='59262' AND `ZoneID`='9042';

    Xajd6If.png