aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2016-08-19AI/SmartScripts: Add param3 to SMART_ACTION_CAST and ↵treeston
SMART_ACTION_INVOKER_CAST that allows specific triggered flags to be set (rather than all-or-nothing). Ignored if SMARTCAST_TRIGGERED is not set.
2016-08-19Core/SmartScripts: Add SMART_TARGET_LOOT_RECIPIENTS. Does what it says on ↵treeston
the tin. Use this new target type to fix The Rider of Blood, The Rider of Frost, The Rider of the Unholy. Closes #17817.
2016-08-18DB/SAI: Add missing SAI for Mux ManascramblerKillyana
By Kodekc Closes #17788
2016-08-17DB/Quest: Children's Week quest RewardText variables $N / $gAokromes
Closes #17728 by tkrokli
2016-08-17[3.3.5] Core/Scripts: move npc_loramus_thalipedes to DBtkrokli
Another chapter in core script hardcoded text removal: - remove core script `npc_loramus_thalipedes` from zone_azshara.cpp - add gossip, SAI script and conditions to database - remove redundant SD2 comments from file header
2016-08-15DB/Creature: missing spawn creature 40405 Kieupid <Pet Trainer>Aokromes
Closes #17747 by tkrokli
2016-08-15Core/Scripts: move Pet Trainer gossip to DBtkrokli
SQL content based on issue 14719 by Killyana, conditions output from Malcrom's Condition Creator - remove hardcoded #define gossip options - enum gossip menu IDs from DB - remove outdated SD comments at the top of the file Closes #14719
2016-08-14DB/Misc: UpdatesDr-J
1) Update to conditions for Zombiefest as previous conditions appear to have stopped working correctly 2) Update for Dark Subjugator to prevent these becoming bugged, also correct unit flags for the sentrys to prevent these from agroing player if too close and dropping immune subjugator if killed 3) Conditions to prevent console spam from Bone Warrior closes #17655
2016-08-14Rename 2016_08_14_01_world.txt to 2016_08_14_01_world.sqlCarbenium
2016-08-14Core/Scripts: remove script npc_timothy_daniels (#17779)tkrokli
The core script `npc_timothy_daniels` is no longer needed, all the gossip handling is already present in the database. - remove core script npc_timothy_daniels - remove ScriptName from c_t entry in DB
2016-08-14Core/Scripts: move npc_mortog_steamhead to DBtkrokli
Move core script npc_mortog_steamhead to database - script contains gossip handling + 1 condition - both actions can be handled in DB settings
2016-08-11Rename 2016_08_04_05_world.sql to 2016_08_11_00_world.sqlAokromes
2016-08-11Core/Command: Check account password max lengthForesterDev
2016-08-09DB/Misc: FixesDr-J
1) Make http://www.wowhead.com/quest=13125/the-air-stands-still and http://www.wowhead.com/quest=13235/the-flesh-giant-champion so player only has to tag the elite to receive credit so that if those op elites which assist player does more damage than player they still receive credit. 2) An update to previous script for Murloc Pets
2016-08-09DB/Loot: Toc RecipesDr-J
Set it so that both horde and alliance have equal chance of getting a recipe drop in Trial of the Crusader rather than chance been 1% for horde and 6% for alliance.
2016-08-08DB/Misc: Fix a couple of start up errors and allow the mounted version of ↵Nyeriah
Attumen the Huntsmen to skip player damage check
2016-08-06Scripts/Commands: Some adjustments to make shutdown commands more user-friendly.treeston
- New error message if a shutdown is delayed due to force threshold. - New status message indicating that a server shutdown was successfully cancelled.
2016-08-05DB/Creature: Father KamarosDr-J
1) Add the missing second http://www.wowhead.com/npc=32800/father-kamaros (only http://www.wowhead.com/npc=31279/father-kamaros is spawned 2) Quests http://www.wowhead.com/quest=13221/im-not-dead-yet and http://www.wowhead.com/quest=13229/im-not-dead-yet should become available once http://www.wowhead.com/quest=13120/deaths-gaze and http://www.wowhead.com/quest=13119/destroying-the-altars become available not once http://www.wowhead.com/quest=13144/killing-two-scourge-with-one-skeleton is rewarded. 3) Quests http://www.wowhead.com/quest=13482/lets-get-out-of-here and http://www.wowhead.com/quest=13481/lets-get-out-of-here should become available once http://www.wowhead.com/quest=13144/killing-two-scourge-with-one-skeleton is rewarded. 4) Both quests I'm Not Dead Yet and Let's Get Out of Here should be exclusive grouped which player gets depends on what phase they are in when they encounter Father Kamaros 5) Script and texts and wp are identical for this quest as confirmed from sniff so duplicating script from 31279
2016-08-04Core/Scripts: remove #define text in pyrewood_ambushtkrokli
- remove #define text from script - move say text to DB table creature_text - add enum names and values - move values in code to enum
2016-08-04DB/SAI: Fix runtime SAI errorKillyana
2016-08-04DB: Blood elf start location / Sunstrider isle fixesKillyana
By msoky
2016-08-04Merge remote-tracking branch 'tkrokli/hunter_animal_handler' into 3.3.5 (PR ↵treeston
#16554)
2016-08-04Core/Scripts: move npc_kharan_mighthammer to DB/SAItkrokli
This PR affects the following 2 quests: Quest ID 4001 "What Is Going On?" - part 2 (Horde) Quest ID 4342 "Kharan's Tale" (Alliance) Target of this PR: Move core script npc_kharan_mighthammer to DB/SAI (thereby removing 10 lines of hardcoded text). * DB/conditions: extra gossip conditions - added conditions for gossip before quest taken and after quest completed. - removed redundant core script SAY_GET_ME_OUT_OF_HERE comment * DB/creature: add more text to Kharan - add all missing creature_text lines to entry 9021 Kharan Mighthammer - add SAI duration to wait before TEXT_OVER is triggered (3000 ms)
2016-08-03Fix deleting some gameobjectsKittnz
2016-08-03DB/Creature: Grizzly Hills Vordrassil areaKittnz
- Add missing Vordrassil's Seed spawns - Add missing creature spawns: Frostpaw Warrior, Redfang Hunter, Generic Trigger LAB, Frostpaw Shaman, Redfang Elder, Frostpaw Trapper - Add pathing for Frostpaw Shaman, Frostpaw Warrior - Change some SAI's, Redfang Hunter SAI, Frostpaw Shaman SAI, Generic Trigger LAB SAI
2016-08-03DB/Quest: From the Depths of Azjol-NerubDr-J
Fix this http://www.wowhead.com/quest=12036/from-the-depths-of-azjol-nerub again after https://github.com/TrinityCore/TrinityCore/commit/cdf8f3c2e1f0363b6d0b7ce82221c813d633a62c areatrigger_involvedrelation does not like sai triggers
2016-08-03DB/Misc: Fix on startup errorAokromes
2016-08-02DB/Quest: A Couple more event scriptsDr-J
1) http://www.wowhead.com/quest=11631/vision-of-air so there is actually visual rather than quest been immedietly completed when quest item used 2) Event for turn in of http://www.wowhead.com/quest=11695/the-horn-of-elemental-fury 3) A small fix for Subjugated Iskalder so this npc has to be taken back the the bone witch rather than credit been given on spawn and npc not moving (due to bad follow action),
2016-08-01Rename 9955_22_55_world.sql to 2016_08_01_01_world.sqlAokromes
2016-08-01Core/Scripts Shade of Akama Rewrite (#17567)Keader
2016-07-31DB/Item: Fix Pristine Glowbear Pelt disenchantAokromes
Closes #17684 by robinsch
2016-07-31Core/Scripts: convert script npcs_riverbreeze_and_silversky to SAI (#17690)tkrokli
Move script npcs_riverbreeze_and_silversky to SAI, thereby removing one line of hardcoded text. - Remove core script npcs_riverbreeze_and_silversky - Create SAI script for gossip event Cenarion Beacon - Add missing gossip_menu for plant description - Add missing creature_text about Cenarion Beacon - Add and correct conditions for gossip availability
2016-07-30Core/GameObjects: Gameobject rotation (from cmangos/mangos-wotlk@2bcbc0f) ↵ariel-
(#14146) cmangos/mangos-wotlk@0fe88f35dfb: [11531] Normalize gameobject's quaternion, thanks to zergtmn for pointing cmangos/mangos-wotlk@060dfb791b: [11667] Implement transport path rotation cmangos/mangos-wotlk@565f52c6c1: [11806] A bit gameobject code refactoring cmangos/mangos-wotlk@6874951: [11807] Add gameobject_addon table Closes #14146
2016-07-30DB/Creature: Fix dmgschool for multiple creatures.Aokromes
2016-07-29Core/Scripts: zone_silithus.cpp cleanup (#17165)tkrokli
- move npcs_rutgar_and_frankal to DB/SAI - move hardcoded text from go_wind_stone to DB - additional enum cleanup in zone_silithus.cpp - also solves a $r issue in SAY_TEMPLAR_AGGRO
2016-07-28Scripts/Karazhan: Rework Attumen the Huntsman's scriptNyeriah
Change log: - Timers are more accurate - Corrected Charge ability ID based on 6.x researches - Added Midnight's missing emotes - Fixed issue with instance being stuck in combat in case of wipes - Solved the rare scenario where Attumen would be summoned multiple times - Visual spell on 3rd phase transition added - Attumen and Midnight can now be damaged during 3rd phase transition - Midnight calls for the aid of every horse still alive in the stables - Use proper spells to summon Attumen and handle transitions - Now despawns on evade Video of encounter after changes: https://www.youtube.com/watch?v=KX0rqaBeSzw
2016-07-25DB/Misc: Various FixesDr-J
1) Add a missing to spell to make http://www.wowhead.com/object=182050/box-of-mushrooms#comments spawn a http://www.wowhead.com/npc=18120/angorosh-mauler when looted 2) http://www.wowhead.com/npc=30718/slumbering-mjordin should not be attackable until gossip selected 3) The Valiant's Challenge - Make the Argent Champion set data on squire danny by creature guid instead of closest creature to prevent credit not being given is player is too far away from squire danny. 4) Add civillian flags to http://www.wowhead.com/npc=18206/wastewalker-captive to prevent these non selectable caged npcs from attacking players 5) http://www.wowhead.com/item=7666/shattered-necklace should have possibility to drop for both factions (not just horde) the item is required for a quest for horde players but starts a different quest which horde cant even accept for alliance.
2016-07-22DB/Gameobject: Respawntimer fix for Quest 11695Aokromes
Closes #17643 by Tauriella
2016-07-20DB/Creature: update Drak'aguul script and fix a DB errorKillyana
Updates #16573
2016-07-20Creature/SAI: Add Frostbolt to Gordok Ogre-MageKillyana
2016-07-20DB/Creature: Precious <Simone's Pet> Z coordinateKillyana
Closes #17636 By tkrokli
2016-07-19DB/SAI: Kilix the Unraveler eventKillyana
Closes #16538 By Rushor
2016-07-19DB/SAI: Drak'aguulKillyana
Closes #16573
2016-07-19DB/Creature: update trainer type for Botanist Alaenra, was wrongly set as ↵ariel-
class trainer. Note: there are 2 other creatures like this: SELECT * FROM creature_template where trainer_type = 0 and (npcflag & 16) != 0 and trainer_class = 0; But one is not spawned (2942) and the other is hostile (14401)
2016-07-19DB/Quest: The Keeper's FavorKillyana
Fix spell target and cast type Closes #17623
2016-07-19SAI: Gordok Ogre-MageKillyana
Closes #17627
2016-07-19DB/NPC: Quartermaster BartlettKillyana
Closes #17611
2016-07-19DB/Creature: Add waypoints for Deathguard MolderKittnz
Closes #17626
2016-07-19Rename 9999_99_99_99_world.sql to ↵Shauren
sql/updates/world/3.3.5/2016_07_19_00_world.sql
2016-07-19Core/Mail: implement a way to specify NPC sender for mails when they should ↵SnapperRy
be different from the quest ender (#17601)