aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
AgeCommit message (Collapse)Author
2009-08-24 [8412] Update some new and old client supported shift-links to proper ↵megamage
format. Author: VladimirMangos * List all client and server side supported shift-link types updated in Chat.cpp * Now Henchant anf Hglyph links can be used in commands as spell links. * Hitem and Hquest links changed to client supported form. --HG-- branch : trunk
2009-08-24 [8409] Fixed guild creation date loading, and added another guild ↵megamage
loading optimization - last one. Signed-off-by: Triply <triply@getmangos.com> --HG-- branch : trunk
2009-08-24 [8402] Optimalized guild_eventlog and guild_bank_eventlog loading from ↵megamage
database. Added config options to set count of eventlog records stored in DB. Attached SQL files will DROP existing and create new tables. Make sure you create backup (if you need old data). Renamed few variables in Guild class. Signed-off-by: Triply <triply@getmangos.com> *Note: existing guild bank log will be removed. --HG-- branch : trunk
2009-08-24 [8397] Remove no longer needed ranks of spell 7386.megamage
Signed-off-by: NoFantasy <nofantasy@nf.no> --HG-- branch : trunk
2009-08-24*Some better check of well-fed buff. Source: Mangosmegamage
--HG-- branch : trunk
2009-08-24 [8394] Fixes for some non-self only positive spells. Author: VladimirMangosmegamage
* Propertly reject self targeting for pet spell 2947 and ranks, and spell 54646. * Some related fixes for pet spells with target mode TARGET_SINGLE_FRIEND_2 * Implement original caster bonus part of spell 54646. --HG-- branch : trunk
2009-08-24rename misnamed 5332 sql.Chaz Brown
--HG-- branch : trunk rename : sql/updates/5532_world_scripts_dk.sql => sql/updates/5332_world_scripts_dk.sql
2009-08-23*Better mob ai for quest an end to all things.megamage
--HG-- branch : trunk
2009-08-23*Fix Glyph of InnervateNevan
--HG-- branch : trunk
2009-08-23*Fix Glyph of StarfireNevan
*Fix Glyph of Shred *Fix Glyph of Backstab -- Thanks megamage for help me with that. --HG-- branch : trunk
2009-08-23*Update flame leviathan script.megamage
--HG-- branch : trunk
2009-08-22*Keristrasza - Teleport players to Saragosa's Landing script - by Oculusmaximius
--HG-- branch : trunk
2009-08-22*Fix quest endless hunger. By BroodWyrmmegamage
--HG-- branch : trunk
2009-08-22*Add a ; after a SQL query. By Sundark.Anubisss
--HG-- branch : trunk
2009-08-21*Fix a typo in sql.megamage
--HG-- branch : trunk
2009-08-21Script for Plaguehound Tracker. Thanks to manuel and NevanKudlaty
--HG-- branch : trunk
2009-08-21Merge [SD2]Kudlaty
r1358 Add gossip and taxi related to quest 11692. Patch by hoshie --HG-- branch : trunk
2009-08-21*Remove the sql which will damage the db. If a hack on db is needed to fix ↵megamage
something, please do so in core. The id can be overriden when reading the data. --HG-- branch : trunk
2009-08-21Fix typos in 5250 sql that might ruin DBs other than UDB, if you are using a ↵Chaz Brown
DB other than UDB and used this SQL, you may need to reinstall your DB, UDB users will be fine. --HG-- branch : trunk
2009-08-21Temporary fix for The Endless Hunger - includes the sql to reverse the change.Chaz Brown
--HG-- branch : trunk
2009-08-20*Cleanup + missed SQLmaximius
--HG-- branch : trunk
2009-08-20* Add missing SQL from 5238Machiavelli
--HG-- branch : trunk
2009-08-20Script for quest 12969. Script by GyulloKudlaty
--HG-- branch : trunk
2009-08-20* Add query to 5036_character_updates_dual_spec.sql to prevent loss of ↵Machiavelli
glyphs on players from transition to dual spec. Note: has no effect on characters after r5036 --HG-- branch : trunk
2009-08-20Add script for quest 12864. Script by manuelKudlaty
--HG-- branch : trunk
2009-08-20Merge [SD2]Kudlaty
r1354 Add one lost text from revision 1352. --HG-- branch : trunk
2009-08-20Merge [SD2]Kudlaty
r1346 Convert script for quest 2078 to use followerAI r1347 Use spell to summon friends instead of manual summon in script for quest 1249. r1348 Extend followerAI function SetFollowComplete with argument to simplify implementation of end events in scripts. r1349 Convert script related to quest 1560 to use followerAI r1350 Apply SD2 code style to one instance and boss script - skip r1351 Add basic support for quest 4491. r1352 Add basic support for quest 5321 r1353 Adjust way to complete quest, for script related to quest 938 --HG-- branch : trunk
2009-08-18*Summon GO dawn of light instead of changing db.megamage
--HG-- branch : trunk
2009-08-18*Deleting some missed talents that need cleaning up for dual spec to work fully.maximius
--HG-- branch : trunk
2009-08-18*fix Kalecgos immunitiesRat
--HG-- branch : trunk
2009-08-18*Script of quest The Light of Dawn. By ckegg.megamage
*I have reduced the number of mobs because they may make the server laggy if the server is not good. --HG-- branch : trunk
2009-08-18AHBot - Fix maxstack DB option to correctly set stacks to a random choice ↵Chaz Brown
between 1 and the maxstack setting of the item, instead of 1. - Thanks T`lexii for pointing this out --HG-- branch : trunk
2009-08-17*Script for quest "An End To All Things..."megamage
--HG-- branch : trunk
2009-08-17 [8377] Resolve some spell_area problems in GM and non-GM mode. Author: ↵megamage
VladimirMangos * Make spell 40216 and 42016 casted/remove at aura 40214 apply/remove. And drop related spell_area possible existed data. * In general restore apply area limitations to spell casting in GM mode. --HG-- branch : trunk
2009-08-17Channel system update:Machiavelli
* Fix bug that player does not have moderator priveliges when ownership was passed on to him after previous owner left the channel. * Comment out code + alter DB field that are responsible for storing ownerGUID in the database, making it no longer possible for an ex-owner to instantly regain ownership by rejoining the channel as this is not blizzlike. The code is commented out in case someone wants to make a configurable option out of it. * Cleanup some other code in affected files. --HG-- branch : trunk
2009-08-17*Fix dk quest chain until "The Scarlet Apocalypse"megamage
--HG-- branch : trunk
2009-08-17*Fix Glyph of RakeNevan
--HG-- branch : trunk
2009-08-17*Add script of quest "Bloody Breakout". Original patch by ckegg.megamage
--HG-- branch : trunk
2009-08-17Fix sqlKudlaty
--HG-- branch : trunk
2009-08-17Fix negative spawntimesecs handling in gameobjects - they now start off ↵QAston
unspawned and disappear correctly upon despawn (even if PCs aren't moving) Quest 308 changed to not require completion of 403 (offi does not have 403 as quest, just a gossip) Quest 308 finish script changed to show unguarded barrel earlier (as it does in offi) Author of all of these: totoro. --HG-- branch : trunk
2009-08-16*Add script of quest "How to win friends and influence enemies". Author ↵megamage
ckegg. With some modifications. *Fix the bug that persuader can be used on other creatures. --HG-- branch : trunk
2009-08-17*TypoNevan
--HG-- branch : trunk
2009-08-17*Fix Frozen Power TalentNevan
--HG-- branch : trunk
2009-08-17Fix typoKudlaty
--HG-- branch : trunk
2009-08-17*Add spell_bonus_data for lightwell - by ElronQAston
*Add aura_required, aura_forbidden, user_type columns to npc_spellclick_spells table for additional requirement checks *Remove workarounds from lightwell code and use new npc_spellclick_spells fields instead. --HG-- branch : trunk
2009-08-17Merge [SD2]Kudlaty
r1341 Use same text for all OOX-scripts. Minor adjustments in addition. Patch by Meldanor r1342 Fix typo in scriptdev2_script_full.sql - skip r1343 Some cleanup and corrections for Windows project files. r1344 Clean more files of trailing whitespace. --HG-- branch : trunk
2009-08-17*Send correct gossip icons for unlearn talent, unlearn pet talent and ↵Machiavelli
purchase dual talent. Dual talent still needs some changes to gossip to make blizzlike. --HG-- branch : trunk
2009-08-17Add missing sql fileKudlaty
--HG-- branch : trunk
2009-08-17mergeKudlaty
--HG-- branch : trunk
2009-08-17Merge [SD2]Kudlaty
r1326 Correct waypoints and details for quest 863 r1327 Add function GetPlayerForEscort to escortAI (not used by escortAI yet) r1328 Updated 0.12 patch and redesigned Karathress for better maintenance. Fixed an issue with Karathres's speech and a little casting bug. - skip r1329 Remove use of old uint64 variable for player guid in escortAI and use function to retrieve pointer to player instead. r1330 Restore compile and use FailQuest instead of no longer existing FailTimedQuest (ref Mangos 8355). Move all waypoints to db --HG-- branch : trunk