aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2022-01-24DB/Creature: Standardize creature respawn time part 10offl
Closes #25075 (cherry picked from commit 5b863acf9285d675a61819d939f38297f49d5c92)
2022-01-24DB/Creature: Remove gold and loot from some unlootable creaturesoffl
Closes #25070 (cherry picked from commit e3ceffdd1a41238c0242a7c271d9b84ea934ffbe)
2022-01-24DB/Creature: Standardize creature respawn time part 9offl
Closes #25068 (cherry picked from commit cf21b4a745b3b21c7b2a17403380fc0f9e14acc3)
2022-01-24DB/Creature: Make Honeybee follow playeroffl
Closes #25064 (cherry picked from commit aced3dcb9af9e010449451791be2ea0e5f84c27c)
2022-01-24DB/Quest: Rework support for 'Oh Noes, the Tadpoles!' (11560)offl
Closes #25062 (cherry picked from commit 7c2859fa1b69d66c024af7d5c164df9c805dc8ba)
2022-01-24DB/Creature: Standardize and adjust creature respawn time, remove wrong ↵offl
spawns part 8 Closes #25060 (cherry picked from commit 5e1a7074c7defb2200f9d9073f8adf5f754e0fcf)
2022-01-24DB/Creature: Significantly increase amount of gold drop from Doomwalker & ↵offl
Doom Lord Kazzak Closes #25059 (cherry picked from commit 632a1d7d2453edf846edbd5a3088762263f95938)
2022-01-24DB/Spell: Add some missing conditions to spells with ↵offl
SPELL_EFFECT_ACTIVATE_OBJECT Closes #25057 (cherry picked from commit 509c24ab53a97999ff5982e858935cd86199c527)
2022-01-24DB/Creature: Deathwhisper Necrolyteoffl
Closes #25048 (cherry picked from commit 7d7be8d5ac77f2d3a16f7b64aa04804041c37463)
2022-01-24DB/Quest: Update support for 'The Black Knight's Curse' (14016)offl
Closes #25043 (cherry picked from commit 6a9c63886e04830f52fe1e3e85fca9b97ac64e5e)
2022-01-24DB/Creature: Add more texts to Naxxanar Skeletal Mageoffl
Closes #25034 (cherry picked from commit db40ad767539410015e542d94aaab89e8e1bc6cf)
2022-01-24DB/Creature: Add formations & more proper waypoints to some packs in SWPoffl
Closes #25011 (cherry picked from commit 9cee34ddb7e98ded5c21b639d0a8c2eb8f4d782a)
2022-01-24DB/Quest: Simplify & update support for 'The Lost Spirits'offl
Closes #25009 (cherry picked from commit 1f866dc8a513776ea364c60bcc77791550ff801c)
2022-01-24DB/Quest: Add support for 'Surrender... Not!'offl
Closes #25002 (cherry picked from commit ef9ec91f1d80e1cb1f3fc216444bb32440a6aac3)
2022-01-24DB/SAI: Darkweb Victim / Kurzeloffl
By @dr-j Closes #24995 (cherry picked from commit fb98337cc0232db5eb60cc2a4c3466c4d881212a)
2022-01-24DB/Quest: Rework support for two 'Test of Lore' questsoffl
Closes #24993 (cherry picked from commit 7908b003110d90c92608aba4c58cc93756c933a0)
2022-01-24DB/Quest: Update support for 'Protect Kanati Greycloud'offl
Closes #24992 (cherry picked from commit 2d93f1487aebfaebfcf1a84a821745d03f045e40)
2022-01-24DB/Quest: Update support for quest 'Suppression'offl
Closes #24991 (cherry picked from commit 2dd7cc88481648c6810346de9573cebb19a2c90c)
2022-01-24DB/Quest: Update support for 'Zuluhed the Whacked'offl
Closes #24990 (cherry picked from commit 37b8760ced64ae8264ab77bc6db4d33d362ad1b6)
2022-01-24DB/Creature: Tel'athion the Impureoffl
By @ZenoX92 Closes #24988 (cherry picked from commit 560a9c75ffcbc01716470d9dd80ea0b601d20fac)
2022-01-24DB/SAI: Harold Laneoffl
By @ZenoX92 Closes #24987 (cherry picked from commit b1e1fe9c3ba84c7459218486af69dd30d818045d)
2022-01-24DB/SAI: Use serverside spells to activate taxi in some scriptsoffl
Closes #24986 (cherry picked from commit 7762a53b43a0c35f305c1e14a854936e0464cf5d)
2022-01-24DB/Misc: Nesingwary Safari's Eventsoffl
By @ZenoX92 Closes #24983 (cherry picked from commit efbd50ed0eef1c05e0f6580e1db442b6ba731c80)
2022-01-24Scripts/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> (cherry picked from commit e0dae8feb6607b5190d14b56ecfc10bbfa667c95)
2022-01-23DB/SAI: Add new view vw_smart_scripts_with_labels that shows labels instead ↵jackpoz
of numbers from smart_scripts table (cherry picked from commit c164c257ae0586bdebb9b81ecb965d9d07eabfef)
2022-01-23Core/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 (cherry picked from commit 3c0ac7302f902d1811d2c215217a3d701f8b5b19)
2022-01-23Core/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 (cherry picked from commit 6440c3bcac85a40de5c34aef1d8a8856966cc140)
2022-01-23Core/Spells: Implement SPELL_EFFECT_ACTIVATE_OBJECT. (#23) (#24997)Giacomo Pozzoni
* Core/Spells: Implement SPELL_EFFECT_ACTIVATE_OBJECT. (#23) Original research by @xvwyh. * Add missing sql update * Fix some build errors * Remove unused enum values * Change artkits from 0-4 to 0-3 * Remove unused code * Code review feedback * Fix sql * Remove artkit4 special case handling * Default initialize artKits * Code review feedback * Split sql into structure and data files Co-authored-by: Warpten <vertozor@gmail.com> (cherry picked from commit 203573db83fb1d3f141b5aadbf1d1ca0a637bf94)
2022-01-22Scripts/Spells: Move spell_anchor_here to generic because is used by more ↵Aqua Deus
than one boss (#27641)
2022-01-22Core: Updated allowed build to 9.1.5.42010Shauren
2022-01-22DB/Creature: Remove flee actions from civilians & texts related to civiliansoffl
Closes #24979 (cherry picked from commit 92efefabc8b3107ab743b88346867a4ec5423efe)
2022-01-22DB/Creature: Standardize creature respawn time part 7offl
Closes #24978 (cherry picked from commit 1943f7fc0760f416000eef75d9cdc948850cae7e)
2022-01-22DB: Restore incorrectly removed spawn_group dataoffl
Closes #24977 (cherry picked from commit 6c806490d339b78e7de5a6ddf49c91f4dca0c751)
2022-01-22DB/Quest: The DivinationZenoX92
Closes #24975 (cherry picked from commit 293fd67faceffdd7b86dc6843cda5a899af6cac2)
2022-01-22DB/Creature: Warmaul Chef BufferloZenoX92
Closes #24974 (cherry picked from commit b54d389cf1ec812293e385e7b8a2f1b53aab7a9c)
2022-01-22DB/Item: Diabolical Plans & Flayed Demon SkinZenoX92
Closes #24971 (cherry picked from commit c1eb1c41f8b28793cbf4fb49b29f0106d8666c03)
2022-01-22DB/Creature: Adjust some rare creatures respawn timeoffl
Closes #24970 (cherry picked from commit e472ef0237ba4d3a7a2ac1374fee9faec1ecdaaf)
2022-01-22DB/Creature: Make Xi'ri & Brutallus invincibleoffl
Closes #24967 (cherry picked from commit 3660e272d471b9eb686d6b5166554190873248b2)
2022-01-22DB/Creature: Standardize creature respawn time, remove wrong spawns part 6offl
Closes #24966 (cherry picked from commit 1cc16afc4f601a0c9c607a22ed14e03c0e02edcd)
2022-01-22DB/Creature: Argent SkytalonKillyana
Closes #24963 (cherry picked from commit 95dd021f08d9434625b48ef5b7e137a34d91d2eb)
2022-01-22DB/Quest: Quest Emotes (Azuremyst Isle)ZenoX92
Closes #24953 (cherry picked from commit d5466ae56332d96e5c7b4d7582841144ae6b170a)
2022-01-22DB/Texts: Antonio PerelliZenoX92
Closes #24951 (cherry picked from commit 88f9b8634fca75c3a99aa1c113535ad3534bd2a6)
2022-01-21DB/Quest: Gizmo for WarugZenoX92
Closes #24950 (cherry picked from commit eb5bd6af8cdb18f78e1e9bb72f5be3eaee3145a7)
2022-01-21DB: Add broadcast texts to some creature textsoffl
Closes #24948 (cherry picked from commit c73238ec3b7e79cffcd9cf9a5f8647af6622bcaa)
2022-01-21DB/Creature: Add gossip options to retrieve Brood of Nozdormu rings and ↵offl
script Anachronos' combat part Closes #24944 (cherry picked from commit da62d78731a0997f7a898b58755d4eb3dc55340f)
2022-01-21DB/Creature: Warmaster Laggrond & Lieutenant Haggerdin: Options to restore ↵offl
Frostwolf / Stormpike Insignia Closes #24943 (cherry picked from commit 4c25aeaa2392d3e1a96b67b12314d693a4bf3294)
2022-01-21DB/Creature: Smith Regzar & Murgot Deepforgeoffl
Closes #24942 (cherry picked from commit 169ee64502f042b30e7fbc73274d843174452aa8)
2022-01-21DB/Creature: Make Steven Thomas & Arcanist Myndimendez & Roitau invincibleoffl
Closes #24939 (cherry picked from commit d1e26da3206ebc6bb068e8f3c6aeacd7bbae2b36)
2022-01-21DB/SAI: Update some scripts using CMC cast flagoffl
Closes #24937 (cherry picked from commit c3f682c8e5a33b5e572ca946e1fbc13071eeeadd)
2022-01-21DB/Creature: Standardize creature respawn time, remove wrong spawns part 5offl
Closes #24936 (cherry picked from commit 49755908248cb7ffb72a9a095736cded6f105323)