aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2017-10-15DB/Creature: fix Prince Valanar (ICC) respawn healthariel-
(cherry picked from commit acc6688d36a567015a48efbfd5f0a8f13e0dbc70)
2017-10-15DB/Quest: remove wrong repeatable flag from some quests.SnapperRy
(cherry picked from commit de22843bcbe13ea2ba1ef89605a96aaaac6a3587)
2017-10-15DB/SAI: Duggan WildhammerKillyana
By Staleness89 Closes #18112 (cherry picked from commit 3ab164f4add62c30d14b3f4b9b1e60d9560fd004)
2017-10-15Script/Spell: remove cosmetic effect for Water Bucket item at login if it ↵SnapperRy
expired after the player logged out. (cherry picked from commit 16cfd59f5b368fd1d05eeeab3afbacfccf0a6870) Add forgotten override. (cherry picked from commit c6f94ba42ec7e66419b636ac09aacc1ee7320a77) Fix non-PCH build. (cherry picked from commit 02cea9c0bac2f999b461d3679a32672b6f0ac2da)
2017-10-15DB/Spell: fix cosmetic effect triggered when a Water Barrel is used.SnapperRy
(cherry picked from commit e78cb6ac5c96c41dbded43f7f648ab8642eeac09)
2017-10-15DB/GameObject: Change position of the Candy Bucket in Bor'gorok OutpostKittnz
Updates #18104 (cherry picked from commit f1cced96b3094273e29adbf72de58617c538402d)
2017-10-15DB/Quest: Stinking Up Southshore should not be repeatable.SnapperRy
(cherry picked from commit 005e5537ea5646d1e22f2d6a3d22fe2e443bf2c1)
2017-10-15DB: Add some Npcs/Gobs related to Hallow's EndKillyana
(cherry picked from commit 0285486603a0364f8dfe2b6bec1391880adcede4)
2017-10-15DB/Quest: Hallow's End Treats for Spoops! should not be repeatable.SnapperRy
Also the item Hallow's End Pumpkin Treat should only be available from vendor after turning in that quest. (cherry picked from commit 489e5b60dbe2faeb3fc0c7f4c359d2e75a1c9472)
2017-10-15DB/GameObjects: Remove Apple Bob duplicate spawnsKillyana
(cherry picked from commit f3dcdc4e647ef3e573c9e8892109dd36bc0b11f4)
2017-10-15DB/Creature: assign core script to creature Magister Aledis.SnapperRy
Forgotten in 94c41c9. (cherry picked from commit 50011d7e2d8b78f2fc58b5b1048f744f197eed6d)
2017-10-09Core/Creature: Refactor and improve vendor items (#20328)Roc13x
* Implement item bonuses in vendors. * Implement the PlayerConditionID and IgnoreFiltering DB columns. * Fix loading referenced vendor items * Allow adding bonuses in .npc add item command
2017-10-03DB/Spell: some proc fixesariel-
- Glyph of Totem of Wrath should proc from triggered casts (fixes aura not applied when summoning through Call of the xx spells) - Fix Deadly brew not proccing at all - Fix Light's Beacon not healing with Holy Shock by xjose93 (cherry picked from commit c6d77e02860073e40a09cd1c847c73c02299eb29)
2017-10-03DB/SAI: improve timers and remove wrong text from Viera Sunwhisper.SnapperRy
(cherry picked from commit 5c7c8202ec86d2d19ac0fb8f71b8b321769b5a10)
2017-10-03DB/Conditions: show correct gossip for Baron Revilgaz if event Pirates' Day ↵SnapperRy
is not running. Also fix small typo in npc_text. (cherry picked from commit 8aa798a9b05a5827613ad0626836cd5123ce1309) DB/Gossip: Wizlo Bearingshiner. (cherry picked from commit 718d3e88c42d43106a7883e41bdfa9bf7b755e59)
2017-10-03DB/Misc: fix gossip text for Noth the Plaguebringer and remove wrong quest ↵SnapperRy
turn-in from the same npc. (cherry picked from commit bc78bfdea2f67b969b4fee08421f4d17ed1c6e1d)
2017-10-03Script/Quest: Arelion's Mistress.SnapperRy
(cherry picked from commit 94c41c92b35e20c47462113ad88b3d382dd9c44d) Fix warning. Also, the quest's name is Arelion's Secret, not Arelion's Mistress. (cherry picked from commit 79acb9fa71bb3016f5aa8f92b257346ed6c17dd7)
2017-10-03DB/SAI: prevent Dawnblade Hawkrider's SAI from targeting players.SnapperRy
Players will not be randomly attacked while in Isle of Quel'Danas anymore. (cherry picked from commit dfb23cf0be4750d8fb0c539c0c65f78b2883ac93)
2017-10-03DB/Misc: add conditions for spell Arrow Assault and remove wrong texts for ↵SnapperRy
two Death Knight starting zone creatures. Closes #16831. (cherry picked from commit 2161ac6757b94f93c8c57a5ff4b8416f31ab6187)
2017-10-03Fix for a typo in variable name. (#18086)Smokexyz
Causes an error on update. (cherry picked from commit 4de5a6e00594262e248640c125f0a7dfc88351ba)
2017-10-03DB/Gossip: add gossip for creature Deino that is shown after completing the ↵SnapperRy
quest A Letter for Home. (cherry picked from commit ec0a8d58eee35514f99bf8a1e305124959bc2e50) DB/Quest: Volatility (daily version) requires completion of Volatility (non-daily version). Also fix comment for condition in previous commit. (cherry picked from commit 115d2400e451e23589a49b2726e9a6906efc0293)
2017-10-03[3.3.5] Core/Scripts: move npc_braug_dimspirit to SAI (#17853)tkrokli
Additional change: The answers have been changed from containing only names to include the text ` is my answer.` from the matching lines in `broadcast_text`. - added DB creature_text entries for Braug Dimspirit - added DB gossip_menu_option entries for this NPC - implemented NPC `Say` line in reply to the wrong answers - avoiding gossip exploits by turning off npcflags during talk - added conditions for showing gossip depending on quest status - removed deprecated SD comments in zone_stonetalon_mountains.cpp (cherry picked from commit 86759c4537cbaac90391822104de4e3ac610013b)
2017-10-03Core/Scripts: move npc_saat to DB (#17813)tkrokli
The core script only contains gossip handling + conditions. - remove script from file the_black_morass.cpp - thereby removing 1 line of hardcoded text - remove redundant SD2 comments in header - add SAI, gossip and conditions to DB (cherry picked from commit 028a7b8e45746c0695a579d7883ea0e5878b827b) Rename 2016_10_32_17813_world.sql to 2016_10_15_01_world.sql (cherry picked from commit 13b748c682d0f9a42bc8dfa87c31043db5c06148)
2017-10-03[WIP] Core/Scripts: Gnomish Mind Control Cap and Gnomish Universal Remote ↵tkrokli
(#17374) (cherry picked from commit b651bf271b047d3c79d7e8fc2c558913d20c9e15) Rename 2016_09_09_20_world.sql to 2016_10_15_00_world.sql (cherry picked from commit d03b3e26438e12bda9069969041d50c36119c24b)
2017-10-03Creature/AI: prevent Kologarn's arms from attacking.SnapperRy
(cherry picked from commit d77a9588097c52e426ec70a762bfef05924471da)
2017-10-03Core/Scripts: Implemented right Snobold Vassal behavior on Gormok fight. ↵Keader
(#17934) (cherry picked from commit 8fb2dce01774bc0e1bcd96eddbfc1239200ae4ee)
2017-10-03Fixed sql errorjoschiwald
2017-10-03Core/Scripts Boss Lady DeathWhisper improvements (#17389)Gustavo
(cherry picked from commit 8e82d8a9e79ba95fbd780fa093416ebe7431a1c0) Rename 2016_99_99_99_world.sql to 2016_10_14_05_world.sql (cherry picked from commit b4b8a7477bcab15cb25a15bd3271279ae3220c94)
2017-10-03DB/Quest: add mail reward for the following quests:SnapperRy
True Believers and Still Believing (leftover from previous commit), A Terrible Purpose, Wrath of Neptulon (still missing the 100 gold attached), A Letter for Home (Alliance and Horde), Tactical Clemency, Abandoned Mail, Hammershout the Elder and various Lunar Festival mails. (cherry picked from commit 1824347594f3a53fd50c9e7da0d546becd69db0d)
2017-10-03DB/Quest: fix mail reward for True Believers and Still Believing.SnapperRy
(cherry picked from commit 830594259ead619a6453be02f1f11bf175559ebe)
2017-09-22Core/Bnet: Moved loading account info from rest service to sessionShauren
* This improves concurrency by removes thread synchronization when checking login tickets * Also allows users to use external (web based) login systems
2017-09-15Core/Items: Implement ItemLevelSelector.db2 (#20325)Ryan
ItemLevelSelector replaced ITEM_BONUS_ITEM_LEVEL_OVERRIDE in 7.2
2017-09-07DB: Deleted a bunch of invalid spell script assignments (old difficulty entries)Shauren
2017-09-06Script/Creature: Scarshield Infiltrator/Vaelan.SnapperRy
(cherry picked from commit fdc4ab4ab4ab99657cb64b42e9e30272aebc5527)
2017-09-06Core/SmartScripts: fixup SMART_EVENT_FLAG_WHILE_CHARMED behaviour to only ↵ariel-
mean charmed creatures (#17738 follow-up) Unit::IsControlledByPlayer is a expected value for TempSummons (like some triggers used in quests, summoned by spells). Previous logic broke a lot of quests which use triggers to do stuff. Allow JustSummoned and events linked from other events with flag set also in charmed (prevents breaking event chains) Allow vehicles (needed for vehicles with SmartAI, eg Iron Rune Constructs and You: Rocket Jumping) (cherry picked from commit 3e596376a7fae9fd585fac12e5122fd8f1b7ce14)
2017-09-06Script/Quest: Stop the Ascension!SnapperRy
(cherry picked from commit bdb08fba6ee5b0fcd68b2ec4d68e4b260549bfed) Forgot to change guid. (cherry picked from commit f20795ff36e2b72fb3587cc5e7dfe5d5eb345ae2)
2017-09-06DB/Creature: add additional text for Chief Plaguebringer Harris.SnapperRy
(cherry picked from commit 00ad5b2d67908354f742c6110c9829bf54ada410)
2017-09-06DB/Creature: cosmetic lightning effect for quest The Staff of Storm's Fury's ↵SnapperRy
location. (cherry picked from commit b0779cbb0238a2647c84ea11654a940012a1799a)
2017-09-06DB/Creature: Abdul the Insane.SnapperRy
Spawn, waypoints, texts. (cherry picked from commit 4f200b99d027f8e753fe144a39ce38f5f4303f89)
2017-09-06DB/Loot: item Abandoned Adventurer's Satchel should always drop from ↵SnapperRy
Northrend rares. (cherry picked from commit 1c94f4c39ede65885c4709ffb6261353a87ce1af)
2017-09-05DB/Quest: add vendor conditions for quest items related to A Carver and a ↵SnapperRy
Croaker and Parts for the Job. (cherry picked from commit 10329104be42ded80c5e358a5f0b6e98a68eb897)
2017-09-05Script/Quest: Apply Heat and Stir.SnapperRy
Enjoy one of the most frustrating quests in Northrend! (cherry picked from commit 387b18775d6f7b7d6e8cf669d36328867e5f39d5)
2017-09-05DB/Gossip: fix gossip for creature Jack Adams.SnapperRy
Involved in quest Gambling Debt (Part 2). (cherry picked from commit f64041e602dfcf80608402257782ff2627f09384)
2017-09-05DB/Conditions: spells Plagued Blood Explosion and Arcane Charges can only ↵SnapperRy
hit certain mobs. (cherry picked from commit 407983f3a372697c497c29b47029c1e9ae3af090)
2017-09-05DB/Gameobject: Fix respawn time for some objectsKillyana
By Tauriella Closes #18066 (cherry picked from commit 2fc9f6140903312c01150b874afb22da6d0413a6)
2017-09-05DB/Misc:SnapperRy
- Quest Nessa Shadowsong and following steps are only available to Night Elves. - Fix offer reward text for quest Elanaria. - NPC Webwood Spider should be neutral. - Small cosmetic fix for quest Force Commander Danath's end event. - Prevent NPCs Gnarlpine Shaman and Elder Timberling from spamming healing spells. (cherry picked from commit 04618be4279560fd05c8f7ce48895560f2ff39de)
2017-09-05DB/Quest: ... Or Maybe We Don'tKillyana
(cherry picked from commit 0ecb8836e28c0bff5810281c05159a5def9ba1c3)
2017-09-05DB/SAI: fix quest Gambling Debt (Part 1).SnapperRy
Closes #18063. (cherry picked from commit 173b33ab734700ecc717626c09aa1d3c95f0b636)
2017-09-05DB/Loot: Dustbringer.SnapperRy
(cherry picked from commit b60b0d927bb1d9f81a650748901293fce93de3cf)
2017-09-05DB/Loot: Blacktip Shark.SnapperRy
By Exodius, untaught and tkrokli. Closes #9453. (cherry picked from commit 4870e1265e414c455e1bd954312076bb871d8077)