aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
AgeCommit message (Collapse)Author
2014-08-22Fix some DB errors I am responsible for.Dr-J
Grr, I was going to script these but found was already scripted, but I left the ids in the line to set ai name in the commit I did make Closes #12912
2014-08-22DB/Misc: Fix Conqueror Krenna/Gorgonna PhasingDr-J
Fix phasing on Conqueror Krenna/Gorgonna in Conquest Hold (Grizzly Hills) so once The Conquest Pit: Final Showdown is turned in Conqueror Krenna and her 2 side parts disappear and Gorgonna replaces Conqueror Krenna as leader of conquest hold.
2014-08-21Added a missing comma in d90d0fb6140ec1f149954d6422dee383dbb953abKinzcool
2014-08-21DB/Creatures: Fixed the InhabitType of some water creatures (fishes ↵Kinzcool
shouldn't walk)
2014-08-22DB/Misc: The Spirit of GnomereganDr-J
* Proper Phasing for The Spirit of Gnomeregan (Flight Master * Script turn in event for Have a Part, Give a Part
2014-08-22DB/Conditions: Master Smith BurninateAokromes
By Rushor, closes #12713
2014-08-21DB/SAI: Son of CenariusDr-J
delete the permament spawns of Treant Ally at each Son of Cenarius and script Son of Cenerius to summon these using the proper spell.
2014-08-21Change of guid, as was erroringDr-J
2014-08-21DB/Misc: Various Frenzyheart/Oracles Chain fixesDr-J
* Rescripted Injured Rainspeaker oracle and both Just Following Orders and Fortunate Misunderstandings and works properly now ie when you find the injured rainspeaker oracle you find lying on ground, you select gossip option to pull injured rainspeaker oracle to his feet crocodile attacks, once crocodile is killed Shaman Vekjik turns up and says a few lines * New waypoints for a Rough Ride from sniff, the crocofile no longer goes through texture but camera is still glitchy * Mosswalker victims will now summon mosswalker pocessions if the event of them deciding to die while doing the mosswalker saviour * Correct text for softknuckle matrat for when summoned * Spawn Shaman Jakjek and Lightningcaller Soo-met and phasing for these, however phasing does not work exactly as should do as you should only be able to see these two npcs while you are working towards that faction but since quests stay rewarded even after you change faction there is no way of doing this using quest and spell area is limited, there are two faction choice tracker quests (hidden) for wolvar and gorloc and spells which add this quests to player but also once these are rewarded they stay rewarded.
2014-08-21DB/Warsong Gulch: Supreme DefenderAokromes
By horn, closes #3859
2014-08-21DB/Conditions: Add gossip conditions to Highlord Darion MograineAokromes
Closes #12868
2014-08-20Rename 2014_08_19_01_world_misc.sql to 2014_08_19_02_world_misc.sqlAokromes
2014-08-20DB/SAI: All is Well That Ends WellDr-J
Script turn in event with Rhonin and Brann Bronzebeard for turn in of either version of all is well that ends well rhonin will respawn a few seconds after despawning after using the teleport visual due to script on Archmage Aethas Sunreaver to respawn him, on retail he is there right after he teleports but since in sai teleport does not work for npcs have had to use a work around to get to respawn otherwise been a faction leader takes a long time to respawn on tc.
2014-08-19DB/Gameevent: Brew of the YearDr-J
Adds vendors, events, sai for faction change, change of appearance depending on location (orgrimmar or iron forge), gossip and conditions * To Do * At start of each monthly event mail should be sent to players who are members with a sample of that months brew, this is not currently implemented. * Possibly missing yells from vendors saying beer but cannot confirm this.
2014-08-19DB/Misc: Greetings texts for Dalaran VendorsDr-J
Only one not working is Tiffany Cartier even though sai is same as the rest and texts are added, idk seems theres an invisible wall as unlike other vendors player cannot get behind counter where tiffany is either.
2014-08-19DB/Misc:Missing EmotesDr-J
Add missing emotes for Image of Loken and High Abbot Landgren for quest scripts,
2014-08-18Rename 2014_08_14_02_world_command.sql to 2014_08_18_01_world_command.sqlDuarte Duarte
2014-08-18Core/RBAC: Fix RBAC permissionsZharvek
This commit adds three missing commands to the world.commands table. The RBAC.h file is updated to the correct IDs from the auth.rbac_permissions table and the world.commands table. The RBAC.h file also had to be reordered to keep it clean. Closes #12854 Signed-off-by: DDuarte <dnpd.dd@gmail.com>
2014-08-18Scripts/Ulduar: Spellscripts for MimironUnholychick
Closes #12579 Signed-off-by: DDuarte <dnpd.dd@gmail.com>
2014-08-16DB/Misc: Misc FixesDr-J
On agro texts and a missing gossip option and menu.
2014-08-15DB/SAI: New Hearthglen FixesDr-J
Several missing texts for creatures in New Hearthglen Also scripts Admiral Barean Westwind (Dragonblight version)
2014-08-15Remove uneeded files.Dr-J
2014-08-15DB/Misc: ResubmissionDr-J
Resubmit https://github.com/TrinityCore/TrinityCore/commit/c212c4fcc3bde1809e58fe1c16d37a29d70ce7bb with different guids
2014-08-15DB/Creature: Remnant of Dahlia SuntouchDr-J
Script event which occurs when Dahlia Suntouch is killed.
2014-08-14DB/Misc: Missing SpawnsDr-J
Respawn the following creatures as tc had considerably less spawns of them than should have done * Tua'kea Crab Trap * Nerub'ar Victim * Giant Tidecrawler
2014-08-14DB/Misc: More event fixesDr-J
* Scripts repeating event between High Overlord Saurfang and Garrosh Hellscream in Warsong Hold * Scripts repeating event between Chieftain Wintergale, Durm Icehide and Sage Aeire at Taunka'le Village * A few texts for reward/accepting of quests * On Agro texts for several creatures, even though these still need scripting with abillities * A run-time error * A bit of additional script for Watcher Leesa'oh to prevent npc bugging out (no npc flags) caused by sai not running if no player in grid and if player disappears will cause npc to remain without npc flags, as the sai to restore flags wont run from script if no player there, at start of script, script will set phase 1 with ooc to restore flags in that phase.
2014-08-14Core/Creature: update creature_template and some other small thingsjoschiwald
http://www.trinitycore.org/f/topic/9572-creature-damage/
2014-08-14Scripts/Icecrown Citadel: The Teleporters in ICC are now Blizzlike *Upon ↵Jared P. Jones
entering the raid, the Lights Hammer teleporter is no longer immediately active. Both the Light's Hammer and the Oratory Portal will pop up after the completion of Lord Marrowgar as it does on official during 3.3.5a. *A teleporter in ICC can no longer teleport you to itself. *There is no longer a reason to allow GMs to use portals without available GOSSIP text and teleport locations. Therefore the teleports now use GO_FLAG_NOT_SELECTABLE when they are unavailable. In the future we can enable GMs to use portals without bosses defeated, however for now all it does is break the instance if some bosses are done out of order. *Currently the Upper Spire teleporter cannot be visited unless the event ColdFlameTraps is completed. This isn't blizz-like. During WotLK retail, the teleporter in the upper spire can be visited once any member has walked over an AreaTrigger which is located the moment you enter the UpperSpire Facade. The cold flame event has nothing to do with the teleporter, the cold flame event instead should be triggered to "DONE" when a rogue instead disarms it. *A bug has been addressed that causes the ColdFlameTraps event to not start back up after a server restart. The event will now restart as long as the player goes through the Saurfang->Upper Spire doorway; I'm not sure who required the doorway to be an area trigger, but it's hacky and not blizzlike. I have not yet addressed the area trigger problem with the doorway in this commit, mainly because the point of this commit is to make the ICC teleporters extremely Blizz-Like. *The "Conspicuous Lever" will now spawn inside of ICC. (From Sniff on Retail) While the lever currently doesn't do anything, in the future it will turn off the ColdFlame Traps. *The teleporter near Saurfang is not supposed to disable during the Intro. It disables whenever Saurfang enters combat with the players. The teleporter then enablers again when combat stops. Closes #12834
2014-08-13DB/SAI: Script more quest complete scriptsDr-J
Script turn in events for http://www.wowwiki.com/Quest%3ABlighted_Last_Rites and http://www.wowwiki.com/Quest%3ATest_at_Sea All waypoints, texts, spells are sniffed, Also fix Blighted Last Rites so it works properly, as the Scarlet Onslaught Prisoner should not die when the flask of the blight is used on it instead it should emote 'The %s moans but seems otherwise unaffected by the blight.' so fixed that too.
2014-08-12Rename 2014_08_11_02_world_misc.sql to 2014_08_12_01_world_misc.sqlDr-J
2014-08-12DB/Misc: Fix some errorsDr-J
2014-08-12DB/SAI: Rescript Manaforge questsDr-J
Rescripts the following quests: - * Shutting Down Manaforge B'naar * Shutting Down Manaforge Coruu * Shutting Down Manaforge Duro * Shutting Down Manaforge Ara All events are now started from gossip select which is correct way rather than player just clicking on console go remains clickable if player does not have access crystal or is not on quest but displays different gossip without the option to start event Added mising gossips for npcs in manaforge coruu for if spoken to while player is disguised from item provided for http://www.wowhead.com/quest=10198
2014-08-11Rename 2014_08_11_01_world_misc.sql to 2014_08_11_01_world_misc.sqlDr-J
2014-08-11DB/Misc: More textsDr-J
add some missing texts from npcs, also set missing emotes for some existing texts.
2014-08-11DB/Creature: Watcher Leesa'ohDr-J
Script turn in event for stealing back the mushrooms.
2014-08-10DB/Misc: Perry Gatner eventDr-J
Script for Perry Gatner. This script may be updated when I sniff more but all data is from sniffs, I wont add texts without the emotes so thats why there will be updates which will just be texts and additional timed action lists to run as random scripts..
2014-08-10DB/Misc: Add More missing textsDr-J
Add missing texts for hellfire peninsula.
2014-08-10DB/Quest: Fix Hunter Trainer Offering Quest To RoguesAokromes
By MrSmite, closes #12809
2014-08-06Renamed '2014_08_06_00_World_Gameobject' to '2014_08_06_00_world_gameobject.sql'Bonny1992
2014-08-06DB/Gameobject: Winterhoof Water WellDr-J
Fix spawn status of Winterhoof Water Well Closes #12739
2014-08-05Update 2014_08_05_01_world_misc.sqlAokromes
2014-08-05Update 2014_08_05_02_world_page_text.sqlAokromes
2014-08-05Update 2014_08_05_03_world_page_text.sqlAokromes
2014-08-05Update 2014_08_05_05_world_page_text.sqlAokromes
2014-08-05DB/Quest: The Perfect StoutAokromes
By Crysicle, closes #12692
2014-08-05DB/Misc: Senir's ReportAokromes
By Crysicle, closes #12693
2014-08-05DB/Creature: Rockjaw BackbreakerAokromes
By Crysicle, closes #12694
2014-08-05DB/Misc: Brock's ListAokromes
By Crysicle, closes #12721
2014-08-05DB/Misc: A Bloodstained Journal PageAokromes
By Crysicle, closes #12722
2014-08-05DB/Misc: Gramma Stonefield's NoteAokromes
By Crysicle, closes #12723