aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2020-08-02DB/SAI: Update some scripts using CMC cast flag or remove itoffl
Closes #25123
2020-08-02DB/Creature: Obsidian Sanctum - Fire Cyclone shouldn't enter in combatJildor
Closes #25113
2020-08-02DB/Creature: Add script to Arakkoa Egg (20214)offl
Closes #25112
2020-08-02DB/Quest: Update support for 'The Skettis Offensive' (10879)offl
Closes #25111
2020-08-02DB/Gossip: Add correct broadcast texts and language to some gossip texts part 3offl
Closes #25106
2020-08-02DB/SAI: Use spells which triggers Arcane Missiles instead of triggered spellsoffl
Closes #25103
2020-08-02DB/Creature: Remove never used option and text for Franclorn Forgewrightoffl
Closes #25101
2020-08-02DB/Gossip: Add correct broadcast texts and language to some gossip texts part 2offl
Closes #25097
2020-08-02DB/Gossip: Add correct broadcast texts and language to some gossip texts part 1offl
Closes #25091
2020-08-02DB/Gossip: Add correct broadcast texts to some gossip optionsoffl
Closes #25087
2020-08-02DB/Creature: Reoder some texts, add correct broadcast text, fix language and ↵offl
add more texts Closes #25082
2020-08-02DB/Creature: Remove event for Duggan Wildhammer, added in Cataoffl
Closes #25081
2020-08-02DB/Creature: Fix Sethekk Spirit's level and add missing emotes to some ↵offl
creatures from Sethekk Halls Closes #25080
2020-08-02DB/Creature: Fix text range for Jaina's & Sylvanas' texts (Forge of Souls)offl
Closes #25078
2020-08-02DB/Creature: Make Amnennar the Coldbringer's adds not despawn instantly ↵Jinnaix
after summon Closes #25077
2020-07-31DB/Creature: Standardize creature respawn time part 10offl
Closes #25075
2020-07-31DB/Creature: Remove gold and loot from some unlootable creaturesoffl
Closes #25070
2020-07-31DB/Creature: Standardize creature respawn time part 9offl
Closes #25068
2020-07-31DB/Creature: Make Honeybee follow playeroffl
Closes #25064
2020-07-31DB/Quest: Rework support for 'Oh Noes, the Tadpoles!' (11560)offl
Closes #25062
2020-07-31DB/Creature: Standardize and adjust creature respawn time, remove wrong ↵offl
spawns part 8 Closes #25060
2020-07-31DB/Creature: Significantly increase amount of gold drop from Doomwalker & ↵offl
Doom Lord Kazzak Closes #25059
2020-07-31DB/Creature: Add missing green items to Doomwalker & Badge of Justice to ↵offl
Doomwalker & Doom Lord Kazzak Closes #25058
2020-07-31DB/Spell: Add some missing conditions to spells with ↵offl
SPELL_EFFECT_ACTIVATE_OBJECT Closes #25057
2020-07-31DB/Creature: Deathwhisper Necrolyteoffl
Closes #25048
2020-07-31DB/Quest: Update support for 'The Black Knight's Curse' (14016)offl
Closes #25043
2020-07-31DB/Creature: Add more texts to Naxxanar Skeletal Mageoffl
Closes #25034
2020-07-31DB/Creature: Add formations & more proper waypoints to some packs in SWPoffl
Closes #25011
2020-07-31DB/Quest: Simplify & update support for 'The Lost Spirits'offl
Closes #25009
2020-07-31DB/Quest: Add support for 'Surrender... Not!'offl
Closes #25002
2020-07-31DB/SAI: Darkweb Victim / Kurzeloffl
By @dr-j Closes #24995
2020-07-31DB/Quest: Rework support for two 'Test of Lore' questsoffl
Closes #24993
2020-07-31DB/Quest: Update support for 'Protect Kanati Greycloud'offl
Closes #24992
2020-07-31DB/Quest: Update support for quest 'Suppression'offl
Closes #24991
2020-07-31DB/Quest: Update support for 'Zuluhed the Whacked'offl
Closes #24990
2020-07-31DB/Creature: Tel'athion the Impureoffl
By @ZenoX92 Closes #24988
2020-07-31DB/SAI: Harold Laneoffl
By @ZenoX92 Closes #24987
2020-07-31DB/SAI: Use serverside spells to activate taxi in some scriptsoffl
Closes #24986
2020-07-31DB/GameObject: Update GAMEOBJECT_TYPE_GUARDPOST values from Cata to 3.3.5offl
Closes #24984
2020-07-31DB/Misc: Nesingwary Safari's Eventsoffl
By @ZenoX92 Closes #24983
2020-07-31DB: Fix teleport positions of Scarlet Monastery areatriggersoffl
By @ipriver Closes #24982
2020-07-30Scripts/Deadmines: Doors after Rhahk'Zor, Sneed and Gilnid (#25107)Somebody
* Fix doors opening after killing Sneed and Gilnid in the Deadmines dungeon * Add SQL file * Update 2020_99_99_00_world.sql SQL conventions * Change SAI door opening into C++ door opening and make it use SetBossState. * Delete 2020_99_99_00_world.sql Replaced by different sql file * Make CircleCI happy * Change const to constexpr for EncounterCount variable * Update src/server/scripts/EasternKingdoms/Deadmines/deadmines.h Co-authored-by: Peter Keresztes Schmidt <carbenium@outlook.com> * Update src/server/scripts/EasternKingdoms/Deadmines/deadmines.h Co-authored-by: Peter Keresztes Schmidt <carbenium@outlook.com> * Rename 9999_99_99_00_world.sql to 2020_07_30_00_world.sql Co-authored-by: Peter Keresztes Schmidt <carbenium@outlook.com> Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com>
2020-07-29DB/World: Fix primary key in quest_greeting_localejackpoz
Close #25115 By @Cerveciento
2020-07-29DB/Creature: Fixed level of Puddle Stalker (Rotface)Keader
It also fix issues with Ooze Flood getting wrong resist values
2020-07-29Scripts/Quest: Force of Neltharaku quest credit (#24807)Trond B. Krokli
* Scripts/Quest: Force of Neltharaku quest credit **Description:** Suggested solution to resolve the kill credit double cast issue in the quest "The Force of Neltharaku" (10854). by Rushor **Changes proposed:** - Remove duplicate spell casts in the zone quest script - Remove commented-out script section - Set a couple of unit flags (anim/stand/hover) - Move return new creature script override to end of script - Move PlayerGUID, FlyTimer, and Tapped to Private - Add DB flight movement control to Enslaved Netherwing Drake - Add SpellMgr MaxAffectedTargets = 1 for spell 38762 - Add movement enum POINT_MOVE_UP - Add missing enum for quest ID **Target branch(es):** 3.3.5/master - [X] 3.3.5 - [X] master **Issues addressed:** Closes #24796 **Tests performed:** (Does it build, tested in-game, etc.) Pending for now. **Known issues and TODO list:** (add/remove lines as needed) - [X] Open PR in draft mode until testing is cleared - [ ] Compile and create local server - [ ] Test changes on local server * Rename 9999_99_99_99_world.sql to 2020_07_29_00_world.sql Co-authored-by: Rushor <Rushor@users.noreply.github.com> Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com>
2020-07-24DB/SAI: Replace functions with case in the view in ↵jackpoz
vw_smart_scripts_with_labels to about permission issues
2020-07-24DB/Misc: Update view and functions to work when importing TDBjackpoz
2020-07-24DB/SAI: Add new view vw_smart_scripts_with_labels that shows labels instead ↵jackpoz
of numbers from smart_scripts table
2020-07-24Core/Metric: Add more metrics about World::Update() loop (#25098)Giacomo Pozzoni
* Core/Metric: Add more metrics about World::Update() loop * Add new Performance profiling grafana dashboard * Add new cmake setting WITHOUT_METRICS that disables all metrics As new metrics are added, someone might want to disable them if unused. * Add more metrics about World::Update() loop * Remove old performance profiling features Remove "server set difftime" command, "-RecordUpdateTimeDiffInterval" and "MinRecordUpdateTimeDiff" worldserver config settings and their related code. The whole UpdateTime class could be removed too. * Update and rename 2020_07_99_99_world.sql to 2020_07_24_00_world.sql
2020-07-22Core/Combat: Disable triggers entering combat (#25086)Giacomo Pozzoni
* Core/Combat: Disable triggers entering combat * Move check to database flags_extra flag in creature_template with value 0x00002000 * Fix Rotface puddle stalker too * Rename 9999_99_99_99_world.sql to 2020_07_22_00_world.sql