-
Content count
9 -
Joined
-
Last visited
Posts posted by valhro
-
-
Title: Recipe : Suramar Surf and Turf
Bugtracker Link:
Patch Content:
Hi !
I didn't DELETE creature_loot_template but I added one with a different groupId that will give a chance to drop items.
-- Legion Recipe: Suramar Surf and Turf -- Recipe : Surf -- Tideclaw 110824 DELETE FROM `creature_loot_template` WHERE (`Item`='141011'); INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Chance`, `GroupId`) VALUES ('110824', '141011', '16', '3'), -- Sashj'tar Pincher 102819 ('102819', '141011', '13', '3'), -- Frothing Crab 107312 ('107312', '141011', '13', '3'), -- Coastal Spikeback 99720 ('99720', '141011', '11', '3'), -- Pinchshank 107846 ('107846', '141011', '9', '3'), -- Deepwater Spikeback 99504 ('99504', '141011', '8', '3'); -- Recipe : Turf -- Shieldscar Doe 112827 DELETE FROM `creature_loot_template` WHERE (`Item`='141012'); INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Chance`, `GroupId`) VALUES ('112827', '141012', '19', '3'), -- Sashj'tar Pincher 112825 ('112825', '141012', '17', '3'), -- Frothing Crab 113205 ('113205', '141012', '15', '3'), -- Coastal Spikeback 106837 ('106837', '141012', '13', '3'), -- Pinchshank 103805 ('103805', '141012', '13', '3'), -- Deepwater Spikeback 110042 ('110042', '141012', '7', '3'), -- Deepwater Spikeback 110043 ('110043', '141012', '5', '3');
-
Title: [Legion] Jewelcrafting Questline
Bugtracker Link:
Patch Content:
Hi !
Here is a patch for Jewelcrafting Questline. I posted it on French Forum but I think this is more efficient here.
Corrected Quest :
1. Facet-nating Friends
2. Truly Outrageous
3. An Eye for Detail
4. Swift Vengeance
5. Making the Cut
6. A Familiar Ring to It
7. Getting the Band Back Together
8. Knocked for a Loop
9. Finishing Touches
10. Raising the Drogbar
11. Bruls Before Jewels
12. Lapidary Lessons
13. Hidden Intentions
14. Come at Me, Brul
15. The Charge Within
16. Mysteries of Nature
17. Eyes of Nashal
18. Jabrul Needs You
19. To Dalaran, With Love
20. Socket to MeContent access :
- Tiffany's Design
- Jabrul's Design (Only if questchain completed)
- Jewelcrafting mini-game
- Achievement http://wowhead.com/achievement=10587/
SQL PATCH (>900 lines so I put it on pastebin):
C++ PATCH :
class scene_jewelcrafting_game : public SceneScript { public: scene_jewelcrafting_game() : SceneScript("scene_jewelcrafting_game") { } // Called when a player receive trigger from scene void OnSceneTriggerEvent(Player* player, uint32 /*sceneInstanceID*/, SceneTemplate const* /*sceneTemplate*/, std::string const& triggerName) override { if(player) if (triggerName == "achievement") player->CompletedAchievement(10587);// Jewel crafting Achievement (HOT SWAPPER) } };
SCREENSHOT (French texts because of locales but they are in english in my SQL)
3 people like this
in Accepted
Posted
Title: Fishing in Dalaran
Bugtracker Link:
Patch Content:
Content :
- Fishing in Dalaran
- fishing_loot_template for Dalaran's Fountain, Margoss's Retreat & Violet hold (Didn't know loot_template for Underbelly so I didn't implant)
- Unlock Achievement http://www.wowhead.com/achievement=10722/the-wish-remover
- Currency : http://www.wowhead.com/item=138777/drowned-mana implanted & Margoss's Reputation too (1 mana => 50 rep, 10 mana => 500 rep)
- Margoss is able to Teleport you back in Dalaran
Core don't consider Dalaran map as MAP_LIQUID_TYPE_WATER (like Undercity or Ironforge), so there's not LiquidLevel = we can't fish in Dalaran
Waiting for a better correction (from you or from TrinityCore) :
src\server\game\Spells\Spell.cpp
switchcase => case TARGET_DEST_CASTER_FISHING:
Under => if (m_caster->GetMap()->getLiquidStatus(x, y, z, MAP_ALL_LIQUIDS, &liquidData))
liquidLevel = liquidData.level;
C++
SQL :