aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2015-02-11DB/Auth: Remove auto_increment value from auth_database.sqlDuarte Duarte
2015-02-11DB/PlayerStats: Corrections to intellect between levels 10 and 19Orphus
2015-02-08Core/Packets: updated some contactlist packetsjoschiwald
2015-02-06DB: fixed The Brewmaiden SAIjoschiwald
2015-02-05SQL: Make sure the correct world db is select when executing SQL update scriptsjackpoz
Make sure script 2014_12_25_00_hotfixes_locale_broadcast_text.sql affects the correct world database version "TDB 6.00". This fixes an issue where the script would drop table "locales_broadcast_text" from a world database of another version (335, 434). Issue added in df444890daf74e95d51a229f99996561a88ac71a
2015-02-04DB/World: Remove a partial duplicated SQL ↵Nayd
(ba906b69e0a90e714da4fe139c25134ca68d402a)
2015-02-02DB/Misc: Fix some run-time errorsDr-J
Solve issues with sai generating errors in Dalaran through sai triggering on non player characters (cherry picked from commit 6ef97aa9429bd6730394465536e291747435e884)
2015-02-02DB/World: Add multiple SQLs from 3.3.5 branch (last ~3 months)Nayd
Multiple authors (most by @DRJ) 42f1a0b DB/Creature: Toc binding must start at Icehowl not at Gormok cc00321 DB/Creature: Fix some startup errors 747e72f DB/Creature: Icecrown/Wrathgate - 1 4d2c35e DB/Creature: Fix for Bleeding Hallow Dark Shaman without waypoint data b7bacea DB/Creature: Hellfire Peninsula - Waypoints - 5 d443a76 DB/Misc: Fix Mog dorg the Wizened quest linking issues 286fab5 + 561fc77 DB/Item: Bubbling Brightbrew Charm 20af358 DB/Creature: Spawns and waypoints on Storm Peaks 65364af DB/Creature: Add 4 missing spawns e583777 DB/Waypoint: Edrick Killian & Mattie Alred 92d42e3 DB/Creature: Deathbound Ward 5719fe9 DB/Creature: Hellfire Peninsula - Waypoints - 2 495c64b DB/Creature: Hellfire Peninsula - Waypoints - 4 60f4c7d DB/Creature: Hellfire Peninsula - Waypoints - 3 3747f99 DB/Spells: Bizuri's Totem of Shattered Ice / Idol of the Crying Moon 7523d60 DB/Quest: Heart of Hakkar 2dc0ffe DB/Creature: Dalaran Citizen and Great Hexer Ohodo 161d688 DB/Gossip: some missing gossip menu ids, menus and menu options) cbb1f7c DB/Creature: Fix Lesser Nether Drake unit_flags c385e53 DB/SAI: Ulduar Scripts 46828c4 DB/Creature: Archmage Pentarus Flying Machine 9feabd1 DB/Creature: Ruul the Darkener 6627a44 DB/Quest: Post-Partum Aggression 1175ba7 DB/Spell: Fix Venomhide Poison staking with spell power a455b47 DB/Misc: Misc fixes c136e4c DB/Misc: Missing spell targets/conditions 4265f7e DB/Gameobject: Update Archivum Console Scripts (Ulduar) 2c0b3de DB/Quest: Swift Discipline bf0a546 DB/Misc: Wrathgate Again 598908b DB/Misc: Wrathgate Stuff 4bc96bf DB/Quest: Prisoners of the Grimtotems e79521d DB/Quest: The Flesh Giant Champion 153be1a DB/Quest: Stinky's Escape bef81c9 DB/Quest: What the Soul sees 068999f DB/Event: Perry Gatner b8560bc DB/Misc: More Perry Gatner Texts 2f56fdb DB/Misc: Kill warnings 13f205a DB/Misc: Cosmetic Fixes 463aeb6 DB/Misc: Traveler's Tundra Mammoth e536922 DB/Misc: Updates a209e53 DB/Quest: Further Conversations c734743 DB/Misc: Various Updates 4387bc3 DB/Creature: Vacillating Voidcaller fff2aff DB/Creature: Harbinger of the Raven fe31f10 DB/Achievement: Pilgrim's Peril 5e5b8e2 DB/Quest: We Strike! 0411157 DB/Creature: Fix Void Conduit InhabitType 84d1ac2 DB/Achievement: Now We're Cookin a5c90b4 DB/Conditions: Gossip conditions for AT Valiants and Champions. b1ab1bb DB/Creature: Misc updates for AT Valiants and Champions. 5a30c00 DB/Creature: Fix class of Water Terror 3236f16 DB/Creature: Fix Wyrmrest Skytalon class b604292 DB/Misc: Getry (Again) e60656e DB/Quest: Changes to script for Foolish Endeavors ef6772b DB/Misc: Misc fixes 2 92ddfd3 DB/Quest: Misc Fixes 3b1acea DB/Misc: Deviate Ravager dd87d74 DB/Misc: Fix typo in .titles current helptext 1dba02c DB/Misc: Fix typo 75decfc DB/SAI: Fix 3 startup errors 6f58467 DB/Misc: Quest linking 849e7a6 DB/Quest: Of keys and cages 898ecf7 DB/Misc: Misc Fixes 5e95a0f DB/Quest: Flight of the Wintergarde Defender 251a347 DB/Quest: Blending In 0527800 DB/Quest: Sniffing Out the Perpetrator (Alliance) 502a7e6 DB/Spells: Cleaned playercreateinfo_spell_custom table and added WoTLK class spells only 971f486 DB/Quest: All Hail Roanauk! ff18a6e DB/Quest: Return of the High Chief 3e4b83b DB/Misc: Rescue from Town Square 11e192c DB/SAI: Clear param2 for Remove Aura dd1e9ec DB/Misc: Put right fieldnae in delete clause which was causing error on apply d0ae507 DB/Misc: Eye of Dominion gossip conditions 0872174 DB/Misc: Lithe Stalker Quests 820e3eb DB/Quest: A Undead's Best Friend / Eidolan Watcher 141cf75 DB/Quest: The Vile Hold 5dd9901 DB/Quest: New Recruit aac03a8 DB/Item: Northrend Mystery Gem Pouch (3.3.5) 499cf73 DB/Misc: Fix 2 startup errors 39b7ab2 DB/Pathing: Mattie Alred 5085375 DB/Quest: Sniffing Out the Perpetrator (Horde Only) d680e82 DB/Misc: Hellfire Peninsula Pathing 8274cae DB/Creature: Fix 2 startup errors ee623a4 DB/Gameobject: Everfrost Chip a5d6f1d DB/Misc: Commoner Texts b70b4c5 DB/Misc: Fleeing Soldiers 6ad8f4b DB/Misc: Winterveil fb1b7f6 DB/Misc: Lights Vengence 97d415d DB/Misc: Additions to fb1b7f6 e0d1070 DB/Misc: The Sacred and the Corrupt Turn in event 4874c9f DB/Misc: Tabard Vendors 4a6d169 DB/Misc: Lights Vengeance (Again) (typo fixes and misc. commits not listed but were also included) Ref #13792
2015-02-02(1) Scripts/Spells: Death Grip should not be castable while jumping/falling ↵Nayd
and should have 8-30 yards range in PvP instead of 0-30 yards Closes #13499 (cherry picked from commit e8955cf6ddddd6953340c2ceeb3b5b4a98d57c90) Conflicts: sql/updates/world/2014_12_28_01_world.sql (2) Scripts/Spells: Adding overrides Death Grip Initial. Thanks @Goatform (cherry picked from commit bb002803bc0cd0283db0873e9a12db43a82ca30b) (3) Scripts/Spells: Move death grip from DB Moves death grip from DB to spellscript for clarity and to reduce confusion in future. (cherry picked from commit 77887ab32ff4d703dbc618b5cab364f02582c5e7) Conflicts: sql/updates/world/2014_12_28_03_world.sql
2015-01-30Core/Spells: Reimplemented automatic spell learningShauren
* Fixed learning/unlearning talents
2015-01-30SQL: Fix importVincent-Michael
2015-01-30Scripts/HoR: implement Quel'Delar questMitchesD
* support for quest 24480, 24561 * there may be some visual problems but quest should work as intended Closes https://github.com/TrinityCore/TrinityCore/issues/838 (cherry picked from commit 71b53601a3c5701600b3585709e190525e0ae818)
2015-01-28Rollback unintended change to 2014_12_25_00_hotfixes_locale_broadcast_text.sqlNayd
2015-01-28Core/Packets: Update and enable SMSG_WEATHERNayd
2015-01-27DB/Schema: Update characters databaseNayd
- Change multiple table's chartset from latin1 to utf8 - Add primary keys to tables that didn't have one - Replaced one unique constraint by primary key
2015-01-19Revert changes to 2014_10_19_05_hotfixes_broadcast_text.sql in previous ↵Nayd
commit (08a98c623742cd2873) Be right back, filling a bug report to Notepad++ for corrupting files
2015-01-19Line ending fix, sorry.Nayd
2015-01-18Scripts/HellfireRamparts: Add a missing reset call and correct spawn masks ↵Nyeriah
for Reinforced Fel Iron Chests Thanks to @ariel- for noticing the missing _Reset(); Closes #13747 (cherry picked from commit 866eff64aa90974e2b1a774b8fd6ea4856346635)
2015-01-16Core/Misc: Implemented leveling/killing experience loading from ↵Kinzcool
gtOCTLevelExperience.dbc * Updated the xp formula to Warlords of Draenor
2015-01-16Core/Auras: Fixed saving all aura effect values to databaseShauren
2015-01-15Core/Player: Fixed Pandaren languageWalkum
Closes #13910
2015-01-12Scripts/Spells: Update several Death Knight spell scriptsUnholychick
New Scripts: Army Transform Festering Strike Glyph of Death's Embrace Glyph of Foul Menagerie Glyph of Runic Power Glyph of the Geist Glyph of the Skeleton Periodic Taunt Soul Reaper Unholy Blight Updated to 6.x: Anti-Magic Shell Blood Boil Death and Decay Death Coil Death Pact Death Strike Icebound Fortitude Raise Dead Vampiric Blood Will of the Necropolis Deprecated and removed Scripts: spell_dk_anti_magic_shell_raid spell_dk_anti_magic_shell_self spell_dk_anti_magic_zone spell_dk_blood_gorged spell_dk_butchery spell_dk_death_strike_enabler spell_dk_improved_blood_presence spell_dk_improved_frost_presence spell_dk_improved_unholy_presence spell_dk_necrotic_strike spell_dk_pestilence spell_dk_presence spell_dk_rune_tap_party spell_dk_scent_of_blood spell_dk_scourge_strike Closes #13759
2015-01-11DB/Players: Major update to `player_levelstats`Hanfblatt
Closes #13823
2015-01-11DB/Players: Add `playercreateinfo` data for races 25 and 26 (Pandaren ↵AriDEV
non-neutral)
2015-01-11DB/Schema: Boost stats in `player_levelstats` from tinyint to smallintNayd
Needed to accommodate base stats higher than 255 Ref #13823
2015-01-10Core/Entities: Load creature health points from the Gt DBCsKinzcool
2015-01-10Scripts/HellfireRamparts: Remove the spawning of the Reinforced Fel Iron ↵Nyeriah
chest from scripts Updates #13747 (cherry picked from commit 9c9e5abca3dd9bdc8f776ffacd72500367e56043)
2015-01-10DB: Update `playercreateinfo`Nayd
Closes #13837
2015-01-10DB/Instances: Add areatrigger teleports for MoP instances entrances and exitsAriDEV
Closes #13873
2015-01-10DB/Achievements: Achievement Reward: "You'll Get Caught Up In The... Frostfire!"AriDEV
After Complete of The Achievement "You'll Get Caught Up In The... Frostfire!" Players get a Reward mail with Text From Draka with the Subject "The Frostwolves Thank You" Closes #13587
2015-01-10DB/Instances: Add instance templates for MoP and WoDAriDEV
Closes #13819 Ref #13873
2015-01-10DB/Mail: Lucky Red Envelope MailAriDEV
Since 2012, This item is not posted per Mail anymore, instead of Mail Spam its rewarded directly from Quest. Closes #13570
2015-01-10Core/Maps: Updated map difficultiesShauren
2015-01-02Merge pull request #13809 from AriDEV/6.xjoschiwald
Server/PacketIO: Currency Updates
2015-01-02Server/PacketIO: Currency UpdatesAriDEV
* Update SMSG_SET_CURRENCY & SMSG_SETUP_CURRENCY Packets. * Update of Database Structure and SQLStatements for Currencies. Signed-off-by: AriDEV <aridev666@gmail.com>
2014-12-31Core/Achievements: Enabled saving progress and converted old saved dataShauren
2014-12-29DB/Quests: Updated the data after quest_template's structure correctionsKinzcool
2014-12-29Core/Quests: Do not rely on StorageIndex for quest objectivesIntel
Also fixed unsigned columns in quest_template
2014-12-29DB/Creature: Fix a typo mess upNyeriah
2014-12-28DB/Quests: Updated `quest_template` up to 6.0.3.19034Kinzcool
2014-12-28DB/Creature: Add trigger and civilian flags to the other difficulty entries ↵Nyeriah
of the Combustion trigger
2014-12-28SQL: Sync auth baseVincent-Michael
2014-12-28Rename fileNayd
2014-12-28DB/Auth: Add more locales to battlenet_componentsNayd
Thanks @Luhzinha Closes #13800
2014-12-28Core/Quests: Updated Quest System to new FormatIntel
All quest requirements are now in quest_objectives table quest_template table contains _ONLY_ WDB data and must not be modified Currently supported objectives are MONSTER, GAMEOBJECT, ITEM, TALKTO, CURRENCY, REPUTATION, MONEY, PLAYERKILLS, AREATRIGGER
2014-12-28SQL: Added a missing semicolonKinzcool
2014-12-28DB/Quests: Added quest_details data from 4.3.4.15595Kinzcool
2014-12-28Scripts/Quests: Fix Quest A Spirit Guidepete318
- Ensures rep adjustment buff is always applied (overrides evade, implements existing evade + re-apply buff) - Removes un-owned ravagers with incorrect faction from DB (the correct ones are spawned with their masters without the DB entries) - Create some extra steps in the wolf's waypoints in order to generate some AI events for the Ryga NPC. I think it's a bit of a dirty solution, but it seems to work with minimal changes. - Created RP series of events with Ryga NPC and Ancestral Wolf Spirit (Ryga Kneels, talks to wolf, then returns to spawn position after around a minute). Closes #13619 Fix #4028 (cherry picked from commit f2444eedf92fce39f7685eafead61d88d4ad89ef) Conflicts: sql/updates/world/2014_12_28_02_world.sql
2014-12-28Scripts/Instance: The Stonecore updatesMihapro
Stonecore Teleporters scripted. Some corrections, better handlings, fixed Travis warnings ... Closes #13626 (cherry picked from commit 9a941ae125c8b22b802270f7f419c1a8bfd2a343) Conflicts: src/server/scripts/Maelstrom/Stonecore/boss_high_priestess_azil.cpp src/server/scripts/Maelstrom/Stonecore/boss_ozruk.cpp src/server/scripts/Maelstrom/Stonecore/instance_stonecore.cpp src/server/scripts/Maelstrom/Stonecore/stonecore.cpp
2014-12-28Core/Scripts: Add Conjure Refreshment Table scriptGigi1237
- Fix Conjure Refreshment for characters above level 85 Closes #13780