100 Commits
Author SHA1 Message Date
SnapperRy 0153481457 DB/CreatureText: revert 06d658f.
My bad.
2016-11-02 03:49:40 +01:00
SnapperRy bfac6c0ea4 DB/CreatureText: swap wrong faction texts for Commoners during Hallow's End. 2016-11-02 03:49:24 +01:00
SnapperRy 368641deb5 DB/SAI: remove SAI from gameobject Felhound Poo.
Aura apply is now handled by the related trap.
2016-11-02 03:48:15 +01:00
SnapperRy c664ec7064 DB/GameObject: add another missed trap from 7.x. 2016-11-02 03:48:06 +01:00
SnapperRy 72120bebe5 DB/GameObject: add missing traps taken from 7.x.
Entries taken from relevant dataX fields in 3.3.5 DB.
2016-11-02 03:47:57 +01:00
SnapperRy 56403fdaa7 DB/Gossip: remove wrong gossip text from Hemet Nesingwary (Nagrand).
This needs some more research. Apparently it should show only for people that completed this quest before TBC came out.
2016-11-02 03:17:32 +01:00
SnapperRy 477ba4e439 Core/SAI: reset event phase when calling SMART_ACTION_CALL_SCRIPT_RESET.
Now it really does what it says on the tin.
2016-11-02 03:14:26 +01:00
SnapperRy 26f513b111 Script/Quest: improvements for Shizz Work:
- Proper cosmetic effects for Fel Guard Hound.
- Spell cast when looting the Felhound Poo.
- Felhound Poo now always contains loot.
2016-11-02 03:14:18 +01:00
SnapperRy abaed4cf6c DB/Creature: restore ScriptName for Sentinel Sweetspring.
Wrongly removed it in b52e774.
2016-11-02 03:14:10 +01:00
SnapperRy 4f94b28aae DB/Event: forgot that Hallow's End is still running. 2016-11-02 03:14:02 +01:00
SnapperRy 5b55b3852a DB/Event: fix start date for Winter Veil. 2016-11-02 03:13:54 +01:00
SnapperRy ed043d2424 DB/Gossip: Grinkle and Barrus. 2016-11-02 03:13:43 +01:00
SnapperRy 8b20248823 Codestyle. 2016-11-02 03:13:35 +01:00
SnapperRy b08d79adc0 DB/Events: update event start dates and fix some wrong event durations.
Note: with the current event system, start dates for all events have to be updated at least once every four years in order to be correct (thanks to leap years).
2016-11-02 03:13:01 +01:00
SnapperRy 25caefdf4c Core/Script: Messenger Torvus. 2016-11-02 03:04:06 +01:00
SnapperRy 9c9ea81f9c DB/SAI: Borus Ironbender. 2016-11-02 03:01:52 +01:00
SnapperRy f076237518 DB/SAI: Zebu'tan and Alys Vol'tyr's conversations.
Also add forgotten creature_template change in 145bf1d.
2016-11-02 02:57:03 +01:00
SnapperRy 2da34a4dbb Forgot a wild comment, sorry. 2016-11-02 02:56:09 +01:00
SnapperRy f54150c8ff DB/SAI: Sentinel Sweetspring. 2016-11-02 02:55:45 +01:00
SnapperRy 69db007468 DB/SAI: Otonambusi. 2016-11-02 02:55:30 +01:00
SnapperRy 0122c28fdb DB/Conditions: add missing data for CONDITION_SOURCE_TYPE_QUEST_ACCEPT and CONDITION_SOURCE_TYPE_QUEST_SHOW_MARK.
Fixes cases where a quest mark was shown without said quest being actually available.
2016-11-02 02:51:32 +01:00
SnapperRy fe4da7ede8 Core/SAI: remove wrong DB errors.
It is normal to have events applicable only to certain instance difficulties.

Closes #18082.
2016-11-02 02:50:57 +01:00
SnapperRy 7eb9d35a4d DB/SAI: fix Plague Walker's Aura of Lost Hope usage (Ahn'Kahet: The Old Kingdom).
Closes #8675.
2016-11-02 02:50:40 +01:00
SnapperRy c817438c01 DB/Quest: event for quests Hallow's End Treats for Spoops/Jesper. 2016-11-02 02:50:16 +01:00
SnapperRy 3c15310bb9 DB/Quest: remove wrong repeatable flag from some quests. 2016-11-02 02:42:47 +01:00
SnapperRy ffe4d8f357 Fix non-PCH build. 2016-10-24 14:05:23 +02:00
SnapperRy bc1bdb9e16 Add forgotten override. 2016-10-24 14:04:57 +02:00
SnapperRy f134011668 Script/Spell: remove cosmetic effect for Water Bucket item at login if it expired after the player logged out. 2016-10-24 14:04:45 +02:00
SnapperRy 6e1a558455 DB/Spell: fix cosmetic effect triggered when a Water Barrel is used. 2016-10-24 14:04:36 +02:00
SnapperRy d8254a59bb DB/Quest: Stinking Up Southshore should not be repeatable. 2016-10-24 14:03:25 +02:00
SnapperRy 30431c6ec0 DB/Quest: Hallow's End Treats for Spoops! should not be repeatable.
Also the item Hallow's End Pumpkin Treat should only be available from vendor after turning in that quest.
2016-10-24 14:01:36 +02:00
SnapperRy 37202838bb DB/Creature: assign core script to creature Magister Aledis.
Forgotten in 94c41c9.
2016-10-24 14:01:14 +02:00
SnapperRy c88803050e DB/Creature: remove wrong text from NPC Argos Nightwhisper.
Closes #18088.
2016-10-24 13:55:54 +02:00
SnapperRy f28c778788 Core/Spell: allow SPELL_EFFECT_QUEST_COMPLETE to set a quest to rewarded only if that quest is used as internal flag by the server (has flag 1024 - QUEST_FLAGS_TRACKING). 2016-10-24 13:55:33 +02:00
SnapperRy 4f313746e0 Core/Quest: show DIALOG_STATUS_AVAILABLE instead of DIALOG_STATUS_REWARD for non-repeatable autocomplete quests. 2016-10-24 13:55:18 +02:00
SnapperRy 51c6209922 Core/Quest: send correct packet when a quest cannot be rewarded for item-related errors. 2016-10-24 13:55:04 +02:00
SnapperRy c5f95f1cd6 DB/SAI: improve timers and remove wrong text from Viera Sunwhisper. 2016-10-24 13:54:34 +02:00
SnapperRy 28aba933d6 Core/Text: allow GENDER_NONE to use FemaleText in broadcast_text if not empty.
Otherwise it would only use MaleText, which breaks cases where female NPCs change model to one that has no gender.
2016-10-24 13:52:08 +02:00
SnapperRy 9a08815526 DB/Gossip: add gossip texts for the following creatures in Stranglethorn Vale:
Krazek, Kebok, "Sea Wolf" MacKinley, Sergeant Yohwa and Crank Fizzlebub.
2016-10-24 13:51:37 +02:00
SnapperRy 77cc7a82bc DB/Gossip: Wizlo Bearingshiner. 2016-10-24 13:51:25 +02:00
SnapperRy 38fdbad957 DB/Conditions: show correct gossip for Baron Revilgaz if event Pirates' Day is not running.
Also fix small typo in npc_text.
2016-10-24 13:50:04 +02:00
SnapperRy 121768547a DB/Misc: fix gossip text for Noth the Plaguebringer and remove wrong quest turn-in from the same npc. 2016-10-24 13:49:50 +02:00
SnapperRy 2bc051aabf Fix warning.
Also, the quest's name is Arelion's Secret, not Arelion's Mistress.
2016-10-24 13:48:42 +02:00
SnapperRy 8ba4528db8 Script/Quest: Arelion's Mistress. 2016-10-24 13:48:00 +02:00
SnapperRy d77b366703 Core/Quest: do not set a quest to failed if it's rewarded or has no status at all (not taken). 2016-10-24 13:47:32 +02:00
SnapperRy b1ffe52a62 DB/Quest: fix race availability for four quests (that should be Human only). 2016-10-24 13:45:23 +02:00
SnapperRy 16b729426f DB/SAI: prevent Dawnblade Hawkrider's SAI from targeting players.
Players will not be randomly attacked while in Isle of Quel'Danas anymore.
2016-10-24 13:44:46 +02:00
SnapperRy c37b9f8353 DB/Misc: add conditions for spell Arrow Assault and remove wrong texts for two Death Knight starting zone creatures.
Closes #16831.
2016-10-24 13:44:28 +02:00
SnapperRy b5b4b03f8a DB/Quest: Volatility (daily version) requires completion of Volatility (non-daily version).
Also fix comment for condition in previous commit.
2016-10-24 13:43:45 +02:00
SnapperRy 9af45a9438 DB/Gossip: add gossip for creature Deino that is shown after completing the quest A Letter for Home. 2016-10-24 13:43:33 +02:00
SnapperRy 49b596cb47 Rename 2016_10_32_17813_world.sql to 2016_10_15_01_world.sql 2016-10-24 13:37:37 +02:00
SnapperRy f8ac417d2c Rename 2016_09_09_20_world.sql to 2016_10_15_00_world.sql 2016-10-24 13:37:03 +02:00
SnapperRy a0313cb09d Core/Scripts: Gnomish Mind Control Cap and Gnomish Universal Re…
…mote
2016-10-24 13:36:53 +02:00
SnapperRy 983f6bea49 Creature/AI: prevent Kologarn's arms from attacking. 2016-10-24 13:28:41 +02:00
SnapperRy 4fc4c81e89 Core/SAI: always use DespawnOrUnsummon() for SMART_ACTION_FORCE_DESPAWN.
SmartAI uses that same method internally, so there's no need to handle it in two different ways.

Does not affect functionality, but prevents useless SAI error log in case the target creature is not using SAI.
2016-10-24 13:27:26 +02:00
SnapperRy 620f4f2955 Rename 2016_99_99_99_world.sql to 2016_10_14_05_world.sql 2016-10-24 13:27:16 +02:00
SnapperRy ff53b66933 DB/Quest: add mail reward for the following quests:
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.
2016-10-24 13:19:53 +02:00
SnapperRy 4e5251a396 DB/Quest: fix mail reward for True Believers and Still Believing. 2016-10-24 13:19:40 +02:00
SnapperRy 496268c478 Script/Creature: Scarshield Infiltrator/Vaelan. 2016-10-24 13:19:02 +02:00
SnapperRy adb3889885 Core/Item: fix wrong error message triggered when trying to equip two items with the same ItemLimitCategory. 2016-10-24 13:12:58 +02:00
SnapperRy 4f0ac16cfe Forgot to change guid. 2016-10-24 13:03:04 +02:00
SnapperRy 5497eebe29 Script/Quest: Stop the Ascension! 2016-10-24 13:02:50 +02:00
SnapperRy b9c2bdf4d0 DB/Creature: add additional text for Chief Plaguebringer Harris. 2016-10-24 13:02:32 +02:00
SnapperRy 4a4142747b Core/Loot: revert unique item check introduced in ea69115.
Proven to be wrong in its current form. Will reintroduce later either in the same method or via db conditions.
2016-10-24 11:17:17 +02:00
SnapperRy 8707ff2425 Core/Loot: limit unique items check introduced in ea69115 to affect only items that start a quest.
Turns out epic and legendary items are excluded from this limitation (or it could be just instanced content that is immune to this). Other qualities are affected as normal. Sorry for the mishap.
2016-10-24 11:16:47 +02:00
SnapperRy dff25e23cd DB/Creature: cosmetic lightning effect for quest The Staff of Storm's Fury's location. 2016-10-24 11:16:28 +02:00
SnapperRy dd5559de7d DB/Creature: Abdul the Insane.
Spawn, waypoints, texts.
2016-10-24 11:16:19 +02:00
SnapperRy cab90f1ae2 DB/Loot: item Abandoned Adventurer's Satchel should always drop from Northrend rares. 2016-10-24 11:16:10 +02:00
SnapperRy f1653109aa DB/Quest: add vendor conditions for quest items related to A Carver and a Croaker and Parts for the Job. 2016-10-24 11:15:59 +02:00
SnapperRy 7835c9bd64 DB/Gossip: fix gossip for creature Jack Adams.
Involved in quest Gambling Debt (Part 2).
2016-10-24 11:11:06 +02:00
SnapperRy 2ea0715519 DB/Conditions: spells Plagued Blood Explosion and Arcane Charges can only hit certain mobs. 2016-10-24 11:10:53 +02:00
SnapperRy e5d916364e DB/Misc:
- 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.
2016-10-24 11:08:04 +02:00
SnapperRy bb67d36b19 Rename 2016_10_09_01_world.sql to 2016_10_09_01_world_335.sql 2016-10-24 11:07:30 +02:00
SnapperRy dc132eb2e9 DB/SAI: fix quest Gambling Debt (Part 1).
Closes #18063.
2016-10-24 11:06:35 +02:00
SnapperRy 76d8a6e636 Core/SAI: don't reset event phase when npc evades/resets.
The scripts themselves should take care of that.
2016-10-24 11:06:13 +02:00
SnapperRy af9ba0ff11 DB/Loot: Dustbringer. 2016-10-24 11:02:49 +02:00
SnapperRy 40958940e1 DB/Loot: Blacktip Shark.
By Exodius, untaught and tkrokli. Closes #9453.
2016-10-24 11:02:18 +02:00
SnapperRy e0f43cca2d Core/Wintergrasp: fix ownership of workshops at the beginning of a new battle.
Those two, together with the two workshop in the Keep, always belong to the defender team. The SouthEast and SouthWest ones always belong to the attacker team.
2016-10-24 10:59:42 +02:00
SnapperRy a6eb8d9b11 Core/Wintergrasp: cleanup and codestyle. 2016-10-22 10:53:40 +02:00
SnapperRy ddead3b6c2 DB/Wintergrasp: availability of different No Mercy for the Merciless and Slay Them All! depends on who is currently holding the keep. 2016-10-22 10:50:50 +02:00
SnapperRy 0ebe771dfa DB/Wintergrasp: four more Horde guards in Wintergrasp Keep that should only appear when it is held by Horde. 2016-10-22 10:50:10 +02:00
SnapperRy 870ad3af32 Remove unused variable. 2016-10-22 10:48:58 +02:00
SnapperRy 76c462d04f Battlefield/Wintergrasp: improvements:
- Move Wintergrasp Keep guard spawns from core to db, removing all duplicates in the meanwhile.
- Add Alliance Brigadier General inside the relic room.

Closes #7593.
2016-10-22 10:48:36 +02:00
SnapperRy c24c06ddcc Core/Wintergrasp: fix Defend the Siege quests.
Closes #7953.
2016-10-22 10:48:20 +02:00
SnapperRy 3c828cfe8f DB/Quest: improvements for quests related to NPC Denalan:
- Timberling Sprouts requires Denalan's Earth rewarded.
- Fix offer reward text for Denalan's Earth.
- Improve scripts for end event of quests Denalan's Earth, The Shimmering Frond and The Glowing Fruit.
2016-10-22 10:48:09 +02:00
SnapperRy 3316e638d4 DB/Gameobject: remove wrong "Greetings, $n" gossip from 256 questgiver gameobjects. 2016-10-21 09:36:05 +02:00
SnapperRy 3fe3f32d15 DB/Quest: Covert Ops - Alpha and Covert Ops - Beta require completion of both Ineptitude + Chemicals = Fun and Special Delivery for Gaxim. 2016-10-21 08:57:55 +02:00
SnapperRy f6829ac70d DB/Quest: the two versions of Jonespyre's Request require Morrowgrain Research rewarded.
Also fix ExclusiveGroup typo.
2016-10-21 08:57:09 +02:00
SnapperRy a91b3907da DB/Creature: fix faction for Githyiss the Vile.
Should be neutral, like the other nearby spiders.
2016-10-21 08:56:45 +02:00
SnapperRy 8d785f9352 DB/Quest: fix quest "Gerenzo's Orders" (Part 1).
Thanks classicdb for coordinates and npc entries. Closes #1724.
2016-10-21 08:48:17 +02:00
SnapperRy 001f4881f8 Fix non PCH build. 2016-10-21 08:47:52 +02:00
SnapperRy 19ff6b29d4 DB/Misc:
- Fix DB error introduced in f7fdc3b5.
- Remove wrong (Cataclysm) gossip for creature Sentinel Selarin.
- Remove questgiver flag from Sentinel Aynasha when accepting quest "One Shot. One Kill."
2016-10-21 08:47:18 +02:00
SnapperRy a1f70df336 DB/SAI: better handling for Ward of Laze aura.
By Killyana.
2016-10-21 08:47:03 +02:00
SnapperRy 37340f1639 DB/Quest: fix quest "One Shot. One Kill."
Thanks tkrokli for the initial research.
2016-10-21 08:46:33 +02:00
SnapperRy 8fc89414f3 DB/Creature: fix gossip for some creatures.
Terenthis, Volcor (Darkshore), Denalan (Teldrassil).
2016-10-21 08:45:58 +02:00
SnapperRy 28d81dcebd DB/Quest: improve Escape Through Force and fix Escape Through Stealth. 2016-10-21 08:45:08 +02:00
SnapperRy bd210a8d37 DB/Quest: fix event for quest A Lost Master (Part 2).
/wave Grimclaw!
2016-10-21 08:44:58 +02:00
SnapperRy 4d660ccdce Both updates are only for 3.3.5 branch. 2016-10-21 08:44:13 +02:00
SnapperRy 49067b0634 DB/Quest: improve end event for Escape Through Stealth/Force.
Texts, npcflags and prevent duplicate spawns.
2016-10-21 08:43:29 +02:00
SnapperRy 74e7192d95 DB/Quest: end event for How Big a Threat? (Part 2). 2016-10-21 08:43:15 +02:00