aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
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
2016-07-15Rename 2016_06_15_99_world.sql to 2016_07_15_08_world.sqlSnapperRy
2016-07-15Core/Scripts: Migrate Tanaris NPC's to SAI (#17390)Andrew Letson
2016-07-15Rename 9999_99_99_99_world.sql to 2016_07_15_07_world.sqlSnapperRy
2016-07-15Core/SmartAI: change SMART_ACTION_RISE_UP (114) to SMART_ACTION_MOVE_OFFSET ↵SnapperRy
and implement offset movement via target fields. (#17362)
2016-07-15Change creature guid for previous commitSnapperRy
Thanks Aokromes. Also forgot to mention, thanks Rushor for the main script
2016-07-15DB/Script: partly script Shadowy Assassin's event in SouthshoreSnapperRy
Updates #14880
2016-07-15Rename 9999_99_99_99_world.sql to 2016_07_15_05_world.sqlAokromes
2016-07-15Core/Creature: implement INHABIT_ROOT to apply UNIT_STATE_ROOT to creature ↵SnapperRy
(#17543) Add flag 8 to InhabitType for creatures that should appear rooted client-side
2016-07-15Script/Archavon: Implement EMOTE_LEAPAokromes
By robinsch
2016-07-15DB/SpellArea: prevent access to HyjalSnapperRy
By dr-j, closes #17467
2016-07-15DB/Gossip: add npc text for Baine BloodhoofSnapperRy
Closes #17575
2016-07-15DB/Loot: reduce drop chance for many white itemsSnapperRy
Closes #17578
2016-07-15DB/Quest: fix availability for Alliance's breadcrumb quests to AshenvaleSnapperRy
Onward to Ashenvale can always be done, while only one quest between Trek to Ashenvale and the Draenei-only Travel to Astranaar can be completed.