aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
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)
2022-01-21DB: Add missing comments to creature_summon_groupsoffl
Closes #24935 (cherry picked from commit 868797035b4275fb14d09f756306002bea67ff89)
2022-01-21DB/Creature: Update recently converted escort quests to prevent reactstate ↵offl
override Closes #24934 (cherry picked from commit 1c7e100b4311cb4cc4f7fec806f7d4590866a121)
2022-01-21DB/Quest: Convert & update support for 'Khu'nok Will Know' to SAIoffl
Closes #24933 (cherry picked from commit c6811d3e4e2f21789f619eff51936796e4cb669f)
2022-01-21DB: Add Comment column to spell_scripts, event_scripts and waypoint_scriptsoffl
Closes #24932 (cherry picked from commit a2bf8693eb9c9b59572176dd771673e0b1bce382)
2022-01-21DB/Creature: Enable Thomas Booker's movement & formation and remove useless ↵offl
dist and angle from some formations Closes #24926 (cherry picked from commit 79c269c161e66c8c1903160723e4fca12e40f360)
2022-01-21Core/Events: refactored battleground holiday assignments.Ovahlord
Instead of going with shitty bitmasks we now accept plain battleground ids instead (cherry picked from commit 8a82403400ef49415e14530f4b55d55ef38bc74e)
2022-01-21DB: Fix a DB errorKillyana
(cherry picked from commit 7987ec103e3b611daf9528be5859befa2be402cf)
2022-01-21DB/SAI: Remove some useless linesKillyana
(cherry picked from commit a3066ab060995fd5e0127a87a447a5ee1cb60390)
2022-01-21DB/Quest: Convert & update support for 'Chasing A-Me 01' to SAIoffl
Closes #24925 (cherry picked from commit 46ad9fa0d95676a8f047f04ff432b1c033c24196)
2022-01-21DB/Quest: Convert & update scripts from Thousand Needles to SAIoffl
Closes #24924 (cherry picked from commit 18864aeddbfdeca90e07d76e5f497c7862c17c0c)
2022-01-21DB/Quest: Convert & update support for 'Protect Kaya' to SAIoffl
Closes #24923 (cherry picked from commit c29e3b46af49e3baeb3da01f839aa9eb1a44bb7b)
2022-01-21DB/SAI: Add scripts to some Ulduar trash NPCsoffl
Closes #24909 (cherry picked from commit 7b010ca65bd8d9e023a1402862327e4937491a1f)
2022-01-21DB/SAI: Remove useless event params and no repeat event flag from some event ↵offl
types Closes #24898 (cherry picked from commit 5ac25bb7844ce0816796236bdafce2105e84d8c4)
2022-01-21DB/Creature: Execute Levixus' event only out of combatoffl
Closes #24897 (cherry picked from commit bc404e1cf5a51d2f152b003782791f21e9881cff)
2022-01-21DB/Creature: Migrate elder's auras to c_t_a (Lunar Festival)offl
Closes #24896 (cherry picked from commit d5be1e7b1f0d63913b6614c185a05f91adc17044)
2022-01-21DB/Creature: Improve Time Keeperoffl
Closes #24892 (cherry picked from commit cfcd23c6bf7c2cc903d1e5af69d6a7d2bb01ab36)
2022-01-21 DB/Creature: Sa'atoffl
Closes #24891 (cherry picked from commit c036aadc96e25e49ce6a29e95bfa888fc378af94)
2022-01-21DB/Creature: Bartolo Ginsetti & Beggaroffl
Closes #24890 (cherry picked from commit d813a22fefba3951994d0a44ca81e56fff74a25e)
2022-01-21DB/Quest: "Making Sense of It" outro event fixgenion18
Closes #24841 (cherry picked from commit b8fb3f0249a6d19c4583a41a04ce2cbee7bbf72d)
2022-01-21DB/Condition: Fix Berthold gossip option condition to teleport players to ↵Killyana
Aran library (cherry picked from commit 1837013c07fb2bd0706be31c22ce371177545535)
2022-01-21DB/Creature: Nat Pagleoffl
Closes #24889 (cherry picked from commit 488fbb20fc94bca593d0764da00eb802271a7849)
2022-01-21DB/Creature: Vindicator Vuuleenoffl
Closes #24888 (cherry picked from commit 7d335c90b57e4b1c8074c781405afb791ce46389)
2022-01-21DB/Creature: Add missing text to Converted Sentryoffl
Closes #24887 (cherry picked from commit db83d3214fb3c13ec4123ce28df420f9cf8834ef)
2022-01-21DB/Creature: Standardize and adjust creature respawn time part 4offl
Closes #24882 (cherry picked from commit 710cad3c59e1b28b26c680b1eab6224c007091dd)