aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2013-02-03DB/Schema: Change engine and collation of `world`.`lfg_entrances`Nay
latin1 -> utf8_general_ci InnoDB -> MyISAM (defaults for all `world` DB tables)
2013-02-01DB/WDB: Fixed some wrong WDBVerified; those templates IDs are way too high ↵Kinzcool
to have been took from retail
2013-02-01Scripts/Icecrown Citadel:Shauren
* Fixed Coldflame dealing double damage * Targets hit by Bone Slice will now be immune to Bone Spike Graveyard * Fixed healing players on Bone Spike Closes #1091 Closes #4473 Closes #5854 Closes #7060
2013-02-01DB/Loot: Fix Prismatic Black DiamondZaphod
2013-02-01DB/Gameobject: Removed gameobject with bad wdb dataVincent_Michael
2013-01-30DB/Auth: Fix typo in sql/base/auth_database.sqlEmo
ERROR 1136 (21S01) at line 216: Column count doesn't match value count at row 1
2013-01-29DB/Loot: Fix 9 drop chance in gameobject_template (7 quests should be fixed ↵Nay
by this) If a GO with flags 4 drops a quest item, ChanceOrQuestChance for that items needs to be negative Query used to find the issue: ``` SELECT * FROM `gameobject_loot_template` WHERE (`item` IN (SELECT `questItem1` FROM `gameobject_template` WHERE (`flags` & 4) != 0) OR `item` IN (SELECT `questItem2` FROM `gameobject_template` WHERE (`flags` & 4) != 0) OR `item` IN (SELECT `questItem3` FROM `gameobject_template` WHERE (`flags` & 4) != 0) OR `item` IN (SELECT `questItem4` FROM `gameobject_template` WHERE (`flags` & 4) != 0) OR `item` IN (SELECT `questItem5` FROM `gameobject_template` WHERE (`flags` & 4) != 0) OR `item` IN (SELECT `questItem6` FROM `gameobject_template` WHERE (`flags` & 4) != 0)) AND `ChanceOrQuestChance` > 0; ```
2013-01-29DB/Achievements: Fix Portal JockeyFH3095
Current Status: Portal Jockey(10) is rewarded from 10nh and 25nh, Portal Jockey(25) is rewarded from 10hc and 25hc. Reason: Achievement-criteria 12971 is required for Portal Jockey(25), but checks for map-difficulty 2=10hc. On the other side achievment-criteria 12979 is required for Portal Jockey(10), but checks for map-difficulty 1=25nh. Closes #9081 Ref #6810
2013-01-29DB/Loot: Add Cache of the Ley-Guardian to heroic Oculus loot when RDF aura ↵w1sht0l1v3
is present. Closes #6927
2013-01-28DB/Gameobjects: Set proper state for ToCr doors and fixed looting of ↵Kinzcool
Venomhide Egg & Discarded Soul Crystal
2013-01-27DB/Gameobjects: Added an another missing GameobjectKinzcool
2013-01-27Typo: i will now go hang myself..... _ typoZxBiohazardZx
2013-01-27Fix/Commit: push final file, not the workingcopyZxBiohazardZx
2013-01-27DB/Creature: Add spawns for Unseen in Duskwood (thanks Expecto for that)Expecto
DB/SAI: Add SAI for the Unseen's Aura (thx ZxBiohazardZx)
2013-01-27Core/Authserver: Added possibility to allow realm connections both from ↵Shauren
"world" and local networks.
2013-01-27Update sql/updates/world/2013_01_26_07_world_gameobject_template.sqlNay
2013-01-26DB/Gameobject: Added a missing gameobject templateKinzcool
2013-01-26DB/Creature: Fixed equipment of Elder Razormaw, he should no longer have a ↵Kinzcool
sword as arms
2013-01-27DB: Fix importGacko
2013-01-26Scripts/Commands: Add guild info to .pinfoNay
Original patch by @secharles, modified Closes #8946
2013-01-26DB/Misc:ZxBiohazardZx
Add Rare Bosses to Dire Maul Closes #5882 Add SAI for Quest: No Mercy for the Captured Closes #568 Add Spawn for Sand Shark Closes #5925 (thx Mogale) Fix underground Centaurs Closes #8498 (thx baric)
2013-01-26DB/Loot: some modifications to Mithrill Bound TrunkZxBiohazardZx
Closes #3801
2013-01-26DB/Conditions: Add conditions for Bellowing Roar / EruptionVincent_Michael
2013-01-26DB/Loot: add loot for Protectorate Treasure Cache and make sure you always ↵ZxBiohazardZx
get sometime out of it... Closes #8589
2013-01-26DB/Loot: add missing items to Coren Direbrewdele
Closes #7297
2013-01-26Script/Commands: Implement command to list the members of a group/party.w1sht0l1v3
2013-01-25DB: Fix SAI broke by quest_end_script conversionGacko
Closes #8995
2013-01-25DB/Stats: Correct a few creature_classlevelstatsMalcrom
Research done for 4.3.4 but still valid in 3.3.5
2013-01-25DB/Texts: Ensure that correct types are used in `creature_text` (42 texts ↵nelegalno
should be corrected) Closes #9055
2013-01-24DB/SAI: Fix quest Wrangle Some Aether Rays!Kirkhammett
Closes #6176 Closes #8968
2013-01-23SQL: Rename SQL merged in PRVincent_Michael
2013-01-23Merge pull request #9016 from joschiwald/spellscripts4blub
Core/Spell: convert more spells to SpellScripts
2013-01-23Script/Commands: Add command to join an existing group/party.w1sht0l1v3
2013-01-23DB/Misc: Add back flight aura on Wyrmrest Defender.(probably deleted on last ↵w1sht0l1v3
template_addon cleanup) Correct a SAI line for Nerub'ar Broodkeeper.
2013-01-22Core/Spell: convert more spells to SpellScriptsjoschiwald
2013-01-22DB/SAI: Fix more some db errors no.4Vincent_Michael
2013-01-22DB/mmaps: Rename mmap commands related sqlNay
2013-01-21Merge pull request #9018 from TrinityCore/mmapsKinzcool
Mmaps
2013-01-21DB/SAI: Fix more some db errors no.3Vincent_Michael
2013-01-21Merge remote-tracking branch 'origin/master' into mmapsNay
2013-01-21DB: Thuk the DefiantGacko
Set hostile to make Stasis Chambers of Bash'ir (10974) solvable. Solves #6422
2013-01-21DB/Misc: Fix db errorsVincent_Michael
2013-01-21Scripts/ZG: Fix some code style issues and logic errorsNay
2013-01-20Scripting/Zulgrub: Updated Boss Arlokk Script.Malcrom
2013-01-20Merge branch 'master' of github.com:TrinityCore/TrinityCore into mmapsVincent_Michael
Conflicts: src/server/game/Movement/MovementGenerators/TargetedMovementGenerator.cpp
2013-01-20DB/SAI: Fix more some db errors no.2Vincent_Michael
2013-01-20Merge pull request #8961 from joschiwald/spellscripts3Nay
Core/Spells: convert some spells to SpellScripts
2013-01-20DB/SAI: Fix more some db errorsVincent_Michael
2013-01-20DB: Image of Commander AmeerGacko
Thanks @nelegalno
2013-01-20DB/SAI: Fix some db errorsVincent_Michael