aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
2010-11-10Core: Partial revert of rcb3188281e, rc85b35f076, r97f9a0fa3e due to missing ↵click
loader implementation. (files disabled but kept in repo, and will be fully reinstated once everything is sorted out) Note: SQL-update-data is NOT supplied for 're-converting' to old help-system - this is after all considered a workrepo untill we tag a commit as stable! --HG-- branch : trunk
2010-11-09Core/Scripts Part 1 of moving all commands to commandscriptsParadox
closes issue 4669 (first 5 patches rolled into 1) Patch by Paradox --HG-- branch : trunk
2010-11-09Core/Spells: Fix Sword Specialization (warrior) proc on abilitiesMachiavelli
Author: Dr.Tenma Fixes issue #4032 --HG-- branch : trunk
2010-11-09Core/Spells: Fix Shield of Righteousness damageMachiavelli
Author: Dr.Tenma Fixes issue #4174 --HG-- branch : trunk
2010-11-08Core/DBSchema: Changed core_revision in version table to string field.Shauren
--HG-- branch : trunk
2010-10-29Core/Spells: Deathfrost weapon enchantment shouldn't scale with spellpowerShocker
--HG-- branch : trunk
2010-10-25Core/Spells: Fixed coefficient of Frostbolt, by A.Metaphysical.DramaShauren
Closes issue #4386. --HG-- branch : trunk
2010-10-25Scripts/Pit of Saron: Added script for Overlord's Brand auraShauren
--HG-- branch : trunk
2010-10-24Scripts/Icecrown Citadel: Added Blood Prince Council scriptShauren
Scripts/Icecrown Citadel: Festergut will not cast Vile Gas on melee targets if there are at least 3 (25 man: 8) ranged targets Scripts/Icecrown Citadel: Festergut and Rotface gates will close with delay (when Putricide reaches the balcony) Scripts/Icecrown Citadel: Replaced ASSERT(instance) with code disabling the AI if not inside instance Core/Spells: Fixed TARGET_DEST_TARGET_RANDOM usage Core/Scripts: Extended DamageDealt in AI to accept damage type as 3rd parameter Scripts/Quests: Fixed quest "Unholy Infusion" (24749) --HG-- branch : trunk
2010-10-23Core/AI: implemented basic class for GameObjectAIRat
--HG-- branch : trunk
2010-10-18Scripts/Forge of Souls: Revisited Bronjahm script, removed ugly hacks and ↵Shauren
fixed spells properly --HG-- branch : trunk
2010-10-17Core/Guilds: guild code was completely refactored and rewritten.azazel
* OOP desing and implementation; * all the queries are moved to prepared statements; * guild loading is optimized; * all the possible interaction with guild's data is done inside the guild class; * added more hooks to GuildScript class; WARNING: Make sure you backup your characters database before applying this change (just in case). Known problems with guilds: * when new member is added to the guild, MOTD is not displayed for him in guild tab of social window; * if you add item with random property to guild bank visual representation of item below it becomes wrong (it displays wrong stack number); * packets order differs from official: currently guild bank packet traffic is twice as more than on offy. --HG-- branch : trunk
2010-10-16Scripts/Icecrown Citadel: Added Professor Putricide scriptShauren
Scripts/Icecrown Citadel: Fixed Professor Putricide gate opening when both Rotface and Festergut are dead Scripts/Icecrown Citadel: Added script updating entries of NPCs at Light's Hammer depending on faction Scripts/Icecrown Citadel: Rotface should not pick main tank as target for Slime Spray (removed debugging code) Core/Spells/Conditions : Spell script target condition now accepts ConditionValue3 as affecting effect mask (only search targets with matching mask) --HG-- branch : trunk extra : rebase_source : 943e3bac5d9063974d7f7132f144e91946f825d4
2010-10-15Typo in SQL...my bad. Thanx Stryker for spotting it.Xanadu
--HG-- branch : trunk
2010-10-14Core/Spells: Righteous Vengeance should proc with Divine Storm, Judgements ↵_manuel_
and Crusader Strike criticals, fixed by cryser99. Fixes issue 3082. Fixes issue 2760. --HG-- branch : trunk
2010-10-14Script/Spells: - Removed spell difficulty data already present in DBC.Xanadu
- Added some spell difficulty data for Razorscale and Ignis (thanks to Eclipse). --HG-- branch : trunk
2010-10-12Core/Spells: Attach the spell_creature_permanent_feign_death script to one ↵Shocker
more spell, 31261 --HG-- branch : trunk
2010-10-08Core/SQL: Updates for creature_classlevelstats by Shaurenrunningnak3d
--HG-- branch : trunk
2010-10-09DB-Schema/World/creature: Added possibility to override npcflag, unit_flags, ↵Shauren
dynamicflags in creature table Core/Player: Fixed bad query in previous revision --HG-- branch : trunk
2010-10-09Scripts/Icecrown Citadel: Added Rotface scriptShauren
Scripts/Icecrown Citadel: Corrected death speech for Stinky and Festergut Scripts/Icecrown Citadel: Fixed Boned! achievement conditions --HG-- branch : trunk
2010-10-08Scripts/Ulduar: Boss IgnisSupabad
- Update Boss Ignis thanks to snakeice for main patch - add support for spell slagpot thanks to Shauren and Linencloth - apply trinity coding standard to patch --HG-- branch : trunk
2010-10-07DB: Fix typo in world base fileSpp
Patch by Antihrist Closses issue 4331 --HG-- branch : trunk
2010-09-29Core/Spells: * Any offensive mage spell hit will now drop Fingers of Frost ↵Xanadu
charge. * Nature's Grace will proc only from non-periodic magic spell crits. --HG-- branch : trunk
2010-09-28Core/Spells: Fixed Shadowmourne procShauren
Scripts/Quests: Fixed quest 24547 (A Feast of Souls) Closes issue #2331. --HG-- branch : trunk
2010-09-28Core/Spells: Fix Glyph of Blast Wave (based on patch by dr.tenma), closes ↵Shocker
issue 3593 --HG-- branch : trunk
2010-09-27Core/Spells: * Removed special handling of ↵Xanadu
SPELL_AURA_ABILITY_IGNORE_AURASTATE, now handled by the proc system (again). * Fixed Fingers of Frost buff display. Closes issue #3324. --HG-- branch : trunk
2010-09-27Core/DB: Adjust max values for some columns in character_queststatusShocker
--HG-- branch : trunk
2010-09-26Core/Commands: Allow .gobject near to print gameobject entry tooShocker
--HG-- branch : trunk
2010-09-26Core/Spells: Fixed Ancestral Healing not proccing on Riptide, patch by dr.tenmaShauren
Closes issue #4120. --HG-- branch : trunk
2010-09-26Core/Scripts/SmartAI: removed test codeRat
Core/CreatureTextMgr: added reload command handle text from DB handle grouped texts handle repeatable/single texts based on probability todo: sound/emote, code cleanup --HG-- branch : trunk
2010-09-25SQL: Add SQL data from previous commit to world baseShocker
--HG-- branch : trunk
2010-09-21Core/Items: Implemented trading soulbound loot itemsShauren
Core/DBLayer: Converted more more player-related queries into prepared statements Core/Items: Fixed loading of enchantments Closes issue #4130. --HG-- branch : trunk
2010-09-21Scripts/Spells: move implementation of some spells into scripts.azazel
* 41337 Aura of Anger * 46394 Burn (Brutallus) * 53302 Sniper Training * 45472 Parachute * 66118 Leeching Swarm * 51685 Prey on the Weak * 20911 Blessing of Sanctuary * 25899 Greater Blessing of Sanctuary Scripts/Spells: remove several spells implementations from core to table (requires DB data) * 31231 Cheat Death * 51662 Hunger for Blood --HG-- branch : trunk
2010-09-21Core/Commands: Implement command for adding (completing) achievementsShocker
--HG-- branch : trunk
2010-09-19Core/Players: Added support for single character bansShauren
Core/Commands: Renamed .ban character to .ban playeraccount (.ban character will ban only the player, not account) This revision reaches 10000, congratulations and thanks to everyone who contributed! --HG-- branch : trunk
2010-09-18Scripts/Spelsl: improve 24751 Trick or Treat spell and implement 24750 Trick ↵azazel
spell. --HG-- branch : trunk
2010-09-17Scripts/Spell: implement script effect of spell 24751 Trick or Treat ↵azazel
(specially for Malcrom) --HG-- branch : trunk
2010-09-16Core/Quests: Added index column for quest poi points forcing them to load in ↵Shauren
certain order --HG-- branch : trunk
2010-09-16Scripts/Quests:azazel
* add support for quest 12634 Some Make Lemonade, Some Make Liquor (implement 51840 spell and Adventurous Dwarf AI, thanks akadabeer) * implement dummy effect for 49587 Seeds of Nature's Wrath spell (used in quest 12459 That Which Creates Can Also Destroy) * implement dummy effect for 19512 Apply Salve spell (used in quest 6124/6129 Curing the Sick) Scripts/Misc: some cleanup in chat log Core/Locales: fix issue when default locale for trinity_string strings was not used (thanks Aokromes for testing). --HG-- branch : trunk
2010-09-14Core/Pools: Implemented quest poolingShauren
Core/DBLayer: Added GetNumRows() method to PreparedResultSet --HG-- branch : trunk
2010-09-13Core/Spells: Remove duplicate healing bonus calculation for Prayer of ↵Shocker
Mending, closes issue 3879, thanks dr.tenma --HG-- branch : trunk
2010-09-13Core/Guilds: Fix Guild bank event log for big stacks, fixes issue 3996, ↵Shocker
thanks maketheking for pointing out the problem --HG-- branch : trunk
2010-09-13Core/Spells: Fix Bone Shield to drop charges only from damage and not heals, ↵Shocker
fixes issue 3284 --HG-- branch : trunk
2010-09-11SQL: Remove duplicate entry from base world_databaseShocker
--HG-- branch : trunk
2010-09-10Core/Groups: Store group member roles to DBSpp
--HG-- branch : trunk
2010-09-10Core: Minor code cleanup before next commitsSpp
--HG-- branch : trunk
2010-09-08SQL: Spell 44805 is an aura -- add proper place holder values.runningnak3d
Thanks tome --HG-- branch : trunk
2010-09-08Core/Spells: Missing SQL from previous commit regarding PvP Trinket/WOTF ↵Shocker
shared CD --HG-- branch : trunk
2010-09-08Core/Spells: Fixed PvP Trinket / Every Man for Himself / Will of the ↵Shocker
Forsaken shared CD, fixes issue 1872, based on dr.tenma's patch --HG-- branch : trunk
2010-09-08SQL: Add forgotten SQL update to base world SQLrunningnak3d
--HG-- branch : trunk