aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2016-08-05DB/Creature: Father KamarosDr-J
1) Add the missing second http://www.wowhead.com/npc=32800/father-kamaros (only http://www.wowhead.com/npc=31279/father-kamaros is spawned 2) Quests http://www.wowhead.com/quest=13221/im-not-dead-yet and http://www.wowhead.com/quest=13229/im-not-dead-yet should become available once http://www.wowhead.com/quest=13120/deaths-gaze and http://www.wowhead.com/quest=13119/destroying-the-altars become available not once http://www.wowhead.com/quest=13144/killing-two-scourge-with-one-skeleton is rewarded. 3) Quests http://www.wowhead.com/quest=13482/lets-get-out-of-here and http://www.wowhead.com/quest=13481/lets-get-out-of-here should become available once http://www.wowhead.com/quest=13144/killing-two-scourge-with-one-skeleton is rewarded. 4) Both quests I'm Not Dead Yet and Let's Get Out of Here should be exclusive grouped which player gets depends on what phase they are in when they encounter Father Kamaros 5) Script and texts and wp are identical for this quest as confirmed from sniff so duplicating script from 31279
2016-08-04Core/Scripts: remove #define text in pyrewood_ambushtkrokli
- remove #define text from script - move say text to DB table creature_text - add enum names and values - move values in code to enum
2016-08-04DB/SAI: Fix runtime SAI errorKillyana
2016-08-04DB: Blood elf start location / Sunstrider isle fixesKillyana
By msoky
2016-08-04Merge remote-tracking branch 'tkrokli/hunter_animal_handler' into 3.3.5 (PR ↵treeston
#16554)
2016-08-04Core/Scripts: move npc_kharan_mighthammer to DB/SAItkrokli
This PR affects the following 2 quests: Quest ID 4001 "What Is Going On?" - part 2 (Horde) Quest ID 4342 "Kharan's Tale" (Alliance) Target of this PR: Move core script npc_kharan_mighthammer to DB/SAI (thereby removing 10 lines of hardcoded text). * DB/conditions: extra gossip conditions - added conditions for gossip before quest taken and after quest completed. - removed redundant core script SAY_GET_ME_OUT_OF_HERE comment * DB/creature: add more text to Kharan - add all missing creature_text lines to entry 9021 Kharan Mighthammer - add SAI duration to wait before TEXT_OVER is triggered (3000 ms)
2016-08-03Fix deleting some gameobjectsKittnz
2016-08-03DB/Creature: Grizzly Hills Vordrassil areaKittnz
- Add missing Vordrassil's Seed spawns - Add missing creature spawns: Frostpaw Warrior, Redfang Hunter, Generic Trigger LAB, Frostpaw Shaman, Redfang Elder, Frostpaw Trapper - Add pathing for Frostpaw Shaman, Frostpaw Warrior - Change some SAI's, Redfang Hunter SAI, Frostpaw Shaman SAI, Generic Trigger LAB SAI
2016-08-03DB/Quest: From the Depths of Azjol-NerubDr-J
Fix this http://www.wowhead.com/quest=12036/from-the-depths-of-azjol-nerub again after https://github.com/TrinityCore/TrinityCore/commit/cdf8f3c2e1f0363b6d0b7ce82221c813d633a62c areatrigger_involvedrelation does not like sai triggers
2016-08-03DB/Misc: Fix on startup errorAokromes
2016-08-02DB/Quest: A Couple more event scriptsDr-J
1) http://www.wowhead.com/quest=11631/vision-of-air so there is actually visual rather than quest been immedietly completed when quest item used 2) Event for turn in of http://www.wowhead.com/quest=11695/the-horn-of-elemental-fury 3) A small fix for Subjugated Iskalder so this npc has to be taken back the the bone witch rather than credit been given on spawn and npc not moving (due to bad follow action),
2016-08-01Rename 9955_22_55_world.sql to 2016_08_01_01_world.sqlAokromes
2016-08-01Core/Scripts Shade of Akama Rewrite (#17567)Keader
2016-07-31DB/Item: Fix Pristine Glowbear Pelt disenchantAokromes
Closes #17684 by robinsch
2016-07-31Core/Scripts: convert script npcs_riverbreeze_and_silversky to SAI (#17690)tkrokli
Move script npcs_riverbreeze_and_silversky to SAI, thereby removing one line of hardcoded text. - Remove core script npcs_riverbreeze_and_silversky - Create SAI script for gossip event Cenarion Beacon - Add missing gossip_menu for plant description - Add missing creature_text about Cenarion Beacon - Add and correct conditions for gossip availability
2016-07-30Core/GameObjects: Gameobject rotation (from cmangos/mangos-wotlk@2bcbc0f) ↵ariel-
(#14146) cmangos/mangos-wotlk@0fe88f35dfb: [11531] Normalize gameobject's quaternion, thanks to zergtmn for pointing cmangos/mangos-wotlk@060dfb791b: [11667] Implement transport path rotation cmangos/mangos-wotlk@565f52c6c1: [11806] A bit gameobject code refactoring cmangos/mangos-wotlk@6874951: [11807] Add gameobject_addon table Closes #14146
2016-07-30DB/Creature: Fix dmgschool for multiple creatures.Aokromes
2016-07-29Core/Scripts: zone_silithus.cpp cleanup (#17165)tkrokli
- move npcs_rutgar_and_frankal to DB/SAI - move hardcoded text from go_wind_stone to DB - additional enum cleanup in zone_silithus.cpp - also solves a $r issue in SAY_TEMPLAR_AGGRO
2016-07-28Scripts/Karazhan: Rework Attumen the Huntsman's scriptNyeriah
Change log: - Timers are more accurate - Corrected Charge ability ID based on 6.x researches - Added Midnight's missing emotes - Fixed issue with instance being stuck in combat in case of wipes - Solved the rare scenario where Attumen would be summoned multiple times - Visual spell on 3rd phase transition added - Attumen and Midnight can now be damaged during 3rd phase transition - Midnight calls for the aid of every horse still alive in the stables - Use proper spells to summon Attumen and handle transitions - Now despawns on evade Video of encounter after changes: https://www.youtube.com/watch?v=KX0rqaBeSzw
2016-07-25DB/Misc: Various FixesDr-J
1) Add a missing to spell to make http://www.wowhead.com/object=182050/box-of-mushrooms#comments spawn a http://www.wowhead.com/npc=18120/angorosh-mauler when looted 2) http://www.wowhead.com/npc=30718/slumbering-mjordin should not be attackable until gossip selected 3) The Valiant's Challenge - Make the Argent Champion set data on squire danny by creature guid instead of closest creature to prevent credit not being given is player is too far away from squire danny. 4) Add civillian flags to http://www.wowhead.com/npc=18206/wastewalker-captive to prevent these non selectable caged npcs from attacking players 5) http://www.wowhead.com/item=7666/shattered-necklace should have possibility to drop for both factions (not just horde) the item is required for a quest for horde players but starts a different quest which horde cant even accept for alliance.
2016-07-22DB/Gameobject: Respawntimer fix for Quest 11695Aokromes
Closes #17643 by Tauriella
2016-07-20DB/Creature: update Drak'aguul script and fix a DB errorKillyana
Updates #16573
2016-07-20Creature/SAI: Add Frostbolt to Gordok Ogre-MageKillyana
2016-07-20DB/Creature: Precious <Simone's Pet> Z coordinateKillyana
Closes #17636 By tkrokli
2016-07-19DB/SAI: Kilix the Unraveler eventKillyana
Closes #16538 By Rushor
2016-07-19DB/SAI: Drak'aguulKillyana
Closes #16573
2016-07-19DB/Creature: update trainer type for Botanist Alaenra, was wrongly set as ↵ariel-
class trainer. Note: there are 2 other creatures like this: SELECT * FROM creature_template where trainer_type = 0 and (npcflag & 16) != 0 and trainer_class = 0; But one is not spawned (2942) and the other is hostile (14401)
2016-07-19DB/Quest: The Keeper's FavorKillyana
Fix spell target and cast type Closes #17623
2016-07-19SAI: Gordok Ogre-MageKillyana
Closes #17627
2016-07-19DB/NPC: Quartermaster BartlettKillyana
Closes #17611
2016-07-19DB/Creature: Add waypoints for Deathguard MolderKittnz
Closes #17626
2016-07-19Rename 9999_99_99_99_world.sql to ↵Shauren
sql/updates/world/3.3.5/2016_07_19_00_world.sql
2016-07-19Core/Mail: implement a way to specify NPC sender for mails when they should ↵SnapperRy
be different from the quest ender (#17601)
2016-07-18DB/SAI: Naturalist BiteDr-J
Improvements to previous script which only gave credit for lost in action
2016-07-18DB/Creature: Misc fixesAokromes
By Malcrom
2016-07-16Core/Conditions: implement CONDITION_DAILY_QUEST_DONE to check whether or ↵SnapperRy
not a daily quest has been completed by a player in that day. Also use it to fix two quest chains broken in commit 7905651. Should be the only ones of their kind.
2016-07-16Core/Scripts: Hallow's End Pumpkin TreatKeader
Add all 6 spells available from item 20557, Hallow's End Pumpkin Treat: - Hallow's End Candy, Orange Giant (24924) - Hallow's End Candy, Skeleton (24925) - Hallow's End Candy, Pirate (24926) - Hallow's End Candy, Ghost (24927) - Hallow's End Candy, Female Defias Pirate (44742) - Hallow's End Candy, Male Defias Pirate (44743) Thanks @Keader for creating the new spell scripts & SQL, saved me a lot of time! :-)
2016-07-16Core/Commands: Allow .cooldown command to work on player petsShauren
2016-07-16DB/Creature: Delete incorrectly deleted spawnAokromes
2016-07-16Update 2016_07_12_01_world.sqlAokromes
2016-07-16DB/Creature: Fix Runetog WildhammerAokromes
Closes #17592 by Silvertower
2016-07-16Rename 2016_99_99_99_world.sql to 2016_07_16_03_world.sqlariel-
2016-07-16Core/Spells: Fix Roar of Sacrifice damage part (#17519)ariel-
2016-07-16DB/Creature: Adjust spawntime of new spawns in Icecrown Citadel 25ariel-
2016-07-16DB/Loot: remove wrong loot for item 'Recipe: Savory Deviate Delight'SnapperRy
Reference loot belongs to 'Murloc Warrior' hailing from Westfall, while the item can only drop from The Barrens' residents
2016-07-16DB/Conditions: fix cast conditions for two more spellsSnapperRy
2016-07-15DB/Conditions: fix three spells that require a NPC to be nearbySnapperRy
Namely, the Venomhide Hatchling feeding quests
2016-07-15DB/Conditions: fix exploit related to quest Disclosure (ID: 12710)SnapperRy
NPC could be repeatedly summoned by clicking the related gameobject
2016-07-15DB/Quest: fix required race for two Argent Tournament dailiesSnapperRy
2016-07-15DB/Mail: add Argent Tournament mail sent when reaching level 77SnapperRy