aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2013-03-12Core/Objects: Updated `playercreateinfo_spell`'s content for Cataclysm with ↵Warpten
the new database structure. Also fixed some characters not being able to clear glyphs (missing spell) and removed a hack.
2013-03-11Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
2013-03-11Core/Objects: Changed `playercreateinfo_spell` and ↵Warpten
`playercreateinfo_spell_custom` to use race and class masks. Specifying a race mask of zero will provide the spell to every race. Specifying a class mask of zero will provide the spell to every class that the race can be. Note: As the SQL truncates `playercreateinfo_spell`, all your "custom" additions will be gone.
2013-03-11DB/Auth/Schema: Change secId from int(10)u to tinyint(3)u in ↵Nay
rbac_security_level_groups Closes #9403
2013-03-11DB/Quests: Fixes Scare the Guano Out of Them! Closes #6854Pitcrawler
Thanks @w1sht0l1v3 for initial work
2013-03-10Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
2013-03-10DB/Quests: Fixes Memories of Stormhoof, closes #1065Pitcrawler
2013-03-10Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
Conflicts: src/server/game/AI/EventAI/CreatureEventAI.cpp src/server/game/AI/EventAI/CreatureEventAIMgr.h src/server/game/Entities/Creature/Creature.cpp src/server/game/Entities/Object/Object.cpp src/server/game/Entities/Player/Player.cpp src/server/game/Entities/Unit/Unit.cpp src/server/game/Entities/Unit/Unit.h src/server/game/Guilds/Guild.cpp src/server/game/Handlers/MailHandler.cpp src/server/game/Spells/Auras/SpellAuraEffects.cpp src/server/game/Spells/Auras/SpellAuras.cpp src/server/game/Spells/SpellEffects.cpp src/server/scripts/Commands/cs_misc.cpp src/server/scripts/Commands/cs_modify.cpp src/server/scripts/EasternKingdoms/ZulGurub/boss_venoxis.cpp src/server/scripts/Kalimdor/zone_azshara.cpp src/server/scripts/Kalimdor/zone_darkshore.cpp src/server/scripts/Kalimdor/zone_durotar.cpp src/server/scripts/Kalimdor/zone_orgrimmar.cpp src/server/scripts/Spells/spell_mage.cpp src/server/shared/Packets/ByteBuffer.h
2013-03-09DB/Quests: Fixes Dun-da-Dun-tah! Closes #4182Pitcrawler
2013-03-09Core/Commands: Add unit flags 2 for .npc infoVincent_Michael
2013-03-09Core/Commands: Add mmaps check for command .gpsVincent_Michael
2013-03-09SQL: Rename a SQL from PRNay
2013-03-09SQL: Update sql/base/auth_database.sqlNay
2013-03-09Merge pull request #9388 from thomas007788/DeserterCmdNay
Implement .deserter commands
2013-03-09Add the following commands:Nefarion
.deserter instance add $time (Adds the instance deserter debuff with $time duration to your target) .deserter bg add $time (Adds the BG deserter debuff with $time duration to your target) .deserter instance remove (Removes the instance deserter debuff) .deserter instance remove (Removes the bg deserter debuff)
2013-03-09Scripts/Eye of Eternity: Remove some uneeded check and last to do that is ↵Trista
uneeded after last GO changes * also repair some broken GO data for 3.3.5a.
2013-03-09DB/Misc: Fix some db startup errorsVincent_Michael
2013-03-09Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
Conflicts: src/server/game/Handlers/ChatHandler.cpp
2013-03-08Typo fix... ¬¬Spp
2013-03-08Core/RBAC: Change default db permissions to behave like a server with ↵Spp
default config before RBAC conversion (Missing change from previous commit) To enable any of the removed config option you should now add the proper role to the proper groups IE: AllowTwoSide.Interaction.Mail = 1 --> Add role 19 to group 1 (Add it to players)
2013-03-08Scripts/Icecrown: Add script* support for Borrowed Technology/Volatility questsTrista
* There are heavy core problems that make it not fully functional for now. 1) Enter vehicle of 31578 is being overriding the vehicle aura of the accessory so it kicks it out. (both get applied to 1, but instead decoy should be to 0). 2) Even if mentioned above get fixed the accessory is supposed to implicitly hit another passenger with explosion and no seat flags for it even unknown. 3) Armored Decoy doesn't keep emote from freeze mechanic when enter vehicle connected with a not supported flag. 4) Vehicle speed seems too fast (there is some general vehicle not correct speed problem with spline being involved). Connected with: #5757
2013-03-07Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
2013-03-07DB/Quests: Fixes Chill out, monPitcrawler
Really closes #5200
2013-03-07Scripts/Eye of Eternity: Fix vehicle crashesTrista
* I tought if a spell would hit all targets on map then the force cast would be cast for each, apparently I was wrong since it had unlimited implicit targets. * Remove a condition with target mask players since there is a attribute that takes care of that. Closes #9365
2013-03-07SQL: Update 2013_02_18_00_world_misc_equip.sqlNay
Fix "column `id` in field list is ambiguous" Thanks Guybrush *Should* not have caused any issues but warnings are bad.
2013-03-06Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
2013-03-06Scripts/Eye of Eternity: Fix Arcane Barrage handling and a lot other mechanicsTrista
* Nexus Lords had a bit imba timers on Arcane Shork, sorry for it wrong information. Now have retail timers. * Scion of Eternity Arcane Barrage had wrong timers also for intial random cast and for each after. They were a bit lower. * Implemented source mechanic that will always differ target of cast X to target of next cast. All rest is % chance based on various cases can happen. * Removed condition for Arcane Overlaod bubbles now aura will never ("disappear"), if two are at one place they will override each other, but damage will never be leaked test enough times so don't bother stating opposite. Damage in ALL cases is reduced. * Made Malygos range outside of platform a bit shorter to match retail real distance that also fixed timings of bubble mechanic, now they will always be there, if you are fast enough. * And finally fixed some slight stuff on Malygos spell. Now all will work and Arcane Storm has it's correct visual mechanic again. Closes #9321
2013-03-04Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
Conflicts: src/server/game/Entities/Creature/Creature.h src/server/game/Entities/Player/Player.cpp src/server/game/Entities/Player/Player.h src/server/game/Entities/Unit/Unit.cpp src/server/game/Entities/Unit/Unit.h src/server/game/Globals/ObjectMgr.cpp src/server/game/Handlers/CharacterHandler.cpp
2013-03-04Unbreak the build and renamed sql file to proper dateShauren
2013-03-04DB/Quests: Added a lot of factionchange questsKinzcool
2013-03-04Core/Players: Implemented converting quests on faction change (keeping old ↵Shauren
faction quests in disabled state - not loaded during login) and restoring them if changing back to original faction Closes #890 Closes #9248
2013-03-04Commit: fuck mondays, i cba to fix it, its outZxBiohazardZx
2013-03-04Commit: its monday.......ZxBiohazardZx
2013-03-04DB/SAI: add SAI for quest: The Admiral Revealed (12852)Kirkhammett
Closes #9094
2013-03-04DB/Quest: fix some questrequirements in BE start zone by Praxious, Closes #9156ZxBiohazardZx
Commit: fix naming on previous file, fix typo in 2013_03_04_00
2013-03-04DB/Waypoints: add waypoints for Doomsayer Jurim, thx KelsarhuZxBiohazardZx
Closes #8958
2013-03-04DB/Gameobject: Add missing GameobjectZxBiohazardZx
Closes #8948
2013-03-03Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
2013-03-03SQL: Fix typoVincent_Michael
2013-03-03DB/SAI: Add SAI for quest "A Worthy Weapon"Durotar
Closes #9250
2013-03-03DB/Misc:ZxBiohazardZx
Add Missing Sunreaver Guardian Mage (thx aokromes) Closes #9311 Add SAI for Mission: The Abyssal Shelf (thx Kirkhammett)
2013-03-03Scripts/Eye of Eternity: Rewrite Arcane Barrage mechanicTrista
* Note that even after last changes happens I'm not sure exactly how the timers are controlled. The wipe chance should be a lot smaller now.. Any further change I can think of is beyond what I see. The main problem is currently. In theory there is chance, If timers get to be same with delay lesser than 2 seconds and if target randomisations select same target for shit out of luck reason. And if starting different timers were matching you can be hit atleast 2-3 times and on 25 mode maybe more. The timers are not with fixed difference for sure is all I know.
2013-03-01Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
2013-03-01DB/Quests: Fixes To Legion Hold (10563,10596). Closes #9153, #6909Pitcrawler
Thanks @Kirkhammett for the initial work.
2013-03-01Scripts/Eye of Eternity: Remove some flags, fix some timers and some miscTrista
* Starting timers were a bit slower * Destroy platform proper timing for drake casting mount spell to player (trigger) * Remove IMMUNITY_PC flag after Iris is triggered (thx to Expecto) and readd it on evade * Remove NOT_SELECTABLE flag since shouldn't be present at starting event * Fix misc of id of Static Field added to LOS attributes
2013-03-01DB/Quests: Fixes Through the Eye (13121), closes #9070Pitcrawler
Thanks @Kirkhammet for inital work
2013-02-28Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
Conflicts: src/server/game/Entities/Creature/Creature.h src/server/game/Entities/Player/Player.h src/server/game/Spells/SpellMgr.cpp
2013-02-28DB/Spells: Opening spell (id: 61437)added to some of Blood Elf's classesTrista
* Add missing generic spell for opening chests for most of Blood Elf's classes. It was preventing them to loot in Eye of Eternity Alexstrasza's Gift Box, Heart of Magic and maybe more.
2013-02-28Scripts/Eye of Eternity: Rewrite most of it.Trista
Closes: #1133, #8212, #1150, #5003, #6794 * More stuff will be done, a lot to clean maybe, as of raiding it's good to go now pretty much*. * Big thx to Shauren, Horn, manuel, Machiavelli, Nay, Krofna and rest who helped.
2013-02-27Core/ZulGurub: Move mondokir hardcoded spawn in dbVincent_Michael