aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2010-04-17Add Visual chains spell for FJOLA LIGHTBANE and EYDIS DARKBANEmalcromdev@gmail.com>
--HG-- branch : trunk
2010-04-17Whack questgivers in the head with a bat to make them properly show ! or ? ↵click
properly depending on the questtype they hand out Patch by Liberate --HG-- branch : trunk
2010-04-16Moved sql update files to 3.3.3a_old dir.teacher
p.s. The previous commit proves we are a crAAAzy community! --HG-- branch : trunk
2010-04-16Reapply the previous "actionbars"-fix/handling db/coresideclick
Fixes issue #1669 Note: This issue has been a pain in the rear, as it was actually messing up clients that ran a vanilla client without addons. The issue only comes in to place when players load a SINGLE actionbar, and not selecting "activate all bars". Extensive testing and debugging done to figure out why this actually happened - I'll fricking shoot the next one messing with it! --HG-- branch : trunk
2010-04-15Fix Threat of Thassarian. Thanks Azuritus.Trazom62
Fixes issue #1657. --HG-- branch : trunk
2010-04-15Changed worldstates.comment field to allow NULL values (by Spp).teacher
Proper naming for recent sql files. Who was the fool to give me push access!? --HG-- branch : trunk
2010-04-15Fixed my typo in characters.sql (thx Kaelima for whacking me)<2teacher
--HG-- branch : trunk
2010-04-15Added worldstates values in characters.sql and re-dumped to prevent any issues.teacher
The first time there was no insert statement in the sql update. --HG-- branch : trunk
2010-04-15Fix typo in sql file.Spp
--HG-- branch : trunk
2010-04-15Fix bad use of worldstates table in last commitSpp
--HG-- branch : trunk
2010-04-15Another fix quest flags, Implement support weekly quests cooldowns(Original ↵n0n4m3
patch by GriffonHeart), also code cleanups. --HG-- branch : trunk
2010-04-14*fix typo in characters.sql thanks to D3VILRat
--HG-- branch : trunk
2010-04-14*added script for Hunter Pet Trainers for Pet Talent ResettingRat
--HG-- branch : trunk
2010-04-14Create new table character_stats for external tools(website,etc). This table ↵n0n4m3
use only when player logout. Original code by hunuza. --HG-- branch : trunk
2010-04-14Add index for some tables in characters DB. by AlexDereka.n0n4m3
--HG-- branch : trunk
2010-04-14Drop not needed table 'item_text', add new column 'text' in table ↵n0n4m3
'item_instance'. Original patch by Vladimir. --HG-- branch : trunk
2010-04-13* Add missing cleanup-SQL for the actionBar-field removalclick
ALL of this is actually handled in characters_action, both loading and storing --HG-- branch : trunk
2010-04-13* Fix actionbars-issue with talent-based spells/actions disappearingclick
* Revert previous mess someone(tm) made with the "reinstating" actionBars -field (me!) --HG-- branch : trunk
2010-04-12Add missing SQL from conversion - fixes durability-issues on items when ↵click
logging in Original SQL by Vladimir@MaNGOS --HG-- branch : trunk
2010-04-12Restore load/save shown actionbars, missing from 3.3.3 upgradeclick
Original SQL by hunuza/MaNGOS project --HG-- branch : trunk
2010-04-12Fixed proper spellid1 value for spelldifficulty_dbc id:3014 (by Trazom).teacher
Added serverside spells place holders for future development. Fixed world.sql import error. --HG-- branch : trunk
2010-04-12Removed no longer existing spell in spell_linked_spell.teacher
--HG-- branch : trunk
2010-04-11Azuremyst Isle: Support for quest 9544Tartalo
The Prophecy of Akida --HG-- branch : trunk
2010-04-11Fix typo in world.sql (spell_difficulty_dbc)Trazom62
--HG-- branch : trunk
2010-04-11Added missing spelldifficulty_dbc data to world.sqlteacher
--HG-- branch : trunk
2010-04-11Added realmlist gamebuild default value update missing in 7849.teacher
Added new line at the end of some files. --HG-- branch : trunk
2010-04-11Remove outdate spell data.n0n4m3
--HG-- branch : trunk
2010-04-11Missing changes for prev. commit. thx to Aokromes.n0n4m3
--HG-- branch : trunk
2010-04-11Update realmlist gamebuild.n0n4m3
--HG-- branch : trunk
2010-04-11Fix load spell.dbc, sql table spell_dbc also drop unused fields.n0n4m3
--HG-- branch : trunk
2010-04-11Add sql for drop mail column 'itemtextid' and add new column 'body'.n0n4m3
--HG-- branch : trunk
2010-04-11Drop characters data blob. Bit thx to hunuza.n0n4m3
--HG-- branch : trunk
2010-04-11* Prepare SQL updates-folder, moved old files to 3.3.2_oldclick
--HG-- branch : trunk rename : sql/updates/7705_characters_worldstates.sql => sql/updates/3.3.2_old/7705_characters_worldstates.sql rename : sql/updates/7707_world_spell_dbc.sql => sql/updates/3.3.2_old/7707_world_spell_dbc.sql rename : sql/updates/7721_world_script_texts.sql => sql/updates/3.3.2_old/7721_world_script_texts.sql rename : sql/updates/7721_world_script_waypoints.sql => sql/updates/3.3.2_old/7721_world_script_waypoints.sql rename : sql/updates/7721_world_scriptname.sql => sql/updates/3.3.2_old/7721_world_scriptname.sql rename : sql/updates/7739_world_scriptname.sql => sql/updates/3.3.2_old/7739_world_scriptname.sql rename : sql/updates/7748_world_scriptname.sql => sql/updates/3.3.2_old/7748_world_scriptname.sql rename : sql/updates/7751_world_script_texts.sql => sql/updates/3.3.2_old/7751_world_script_texts.sql rename : sql/updates/7751_world_scriptname.sql => sql/updates/3.3.2_old/7751_world_scriptname.sql rename : sql/updates/7753_world_scriptname.sql => sql/updates/3.3.2_old/7753_world_scriptname.sql rename : sql/updates/7760_world_spell_group.sql => sql/updates/3.3.2_old/7760_world_spell_group.sql rename : sql/updates/7760_world_spell_group_stack_rules.sql => sql/updates/3.3.2_old/7760_world_spell_group_stack_rules.sql rename : sql/updates/7767_world_spell_group.sql => sql/updates/3.3.2_old/7767_world_spell_group.sql rename : sql/updates/7778_world_item_required_target.sql => sql/updates/3.3.2_old/7778_world_item_required_target.sql rename : sql/updates/7780_world_scriptname.sql => sql/updates/3.3.2_old/7780_world_scriptname.sql rename : sql/updates/7786_world_scriptname.sql => sql/updates/3.3.2_old/7786_world_scriptname.sql rename : sql/updates/7797_world_scriptname.sql => sql/updates/3.3.2_old/7797_world_scriptname.sql rename : sql/updates/7812_world_creature_template.sql => sql/updates/3.3.2_old/7812_world_creature_template.sql rename : sql/updates/7812_world_spell_dbc.sql => sql/updates/3.3.2_old/7812_world_spell_dbc.sql rename : sql/updates/7813_world_script_texts.sql => sql/updates/3.3.2_old/7813_world_script_texts.sql rename : sql/updates/7813_world_scriptname.sql => sql/updates/3.3.2_old/7813_world_scriptname.sql rename : sql/updates/7815_world_spelldifficulty_dbc.sql => sql/updates/3.3.2_old/7815_world_spelldifficulty_dbc.sql rename : sql/updates/7816_world_spelldifficulty_dbc.sql => sql/updates/3.3.2_old/7816_world_spelldifficulty_dbc.sql rename : sql/updates/7823_world_spelldifficulty_dbc.sql => sql/updates/3.3.2_old/7823_world_spelldifficulty_dbc.sql rename : sql/updates/7827_world_script_texts.sql => sql/updates/3.3.2_old/7827_world_script_texts.sql
2010-04-10Fix a typo in sql file nameSpp
--HG-- branch : trunk
2010-04-10Azjol Nerub: Anub'arak and Krikthir script textsSpp
Patch by terrorbringer Closes issue 1570 --HG-- branch : trunk
2010-04-10*modified spelldifficulty handler to work with all spell casts for creatures ↵Rat
that are in instances thanks to Shauren for help *modified most of the scripts to use normal_mode spell for casting (code was autogenerated, post errors if any) *added sql for all modded spells (autogenerated..) --HG-- branch : trunk
2010-04-09Changed recent spell_difficulty_dbc table creation to CHARSET=utf8.teacher
Added recent sql updates to world.sql... --HG-- branch : trunk
2010-04-09*add example difficulty spells for magus telestraRat
--HG-- branch : trunk
2010-04-09*added code for loading Spelldifficulty.dbc + Custom Spelldifficulty from ↵Rat
Database *added spell searcher based on creature's map difficulty, usage is optional and only for scipts for now *added new table spelldifficulty_dbc --HG-- branch : trunk
2010-04-08Script Instance Forge of Souls.Trazom62
Script based on proposal of Synric on trinitycore forum (submitted by Skarabex on GC). Fix EventMap::DelayEvents Fixes issue #1310. --HG-- branch : trunk
2010-04-08Added serverside spell as place holders for future development.teacher
Added some vehicleIDs and creature_template spells (by Xanadu and Mikebeck). Some fixes for proper sql format. --HG-- branch : trunk
2010-04-07Little sql cleanup and full update.teacher
--HG-- branch : trunk
2010-04-07remove CRLF from blackrock spire scripts.malcromdev@gmail.com>
--HG-- branch : trunk
2010-04-07Clean SQLs from last commitTartalo
--HG-- branch : trunk
2010-04-07Blackrock Spire: Implements Leroy Jenkins achievement, by Spichy.Tartalo
Fixes issue #1073. Please, post your contribution following our coding style, otherwise I have to waste a lot of time cleaning up the code --HG-- branch : trunk
2010-04-06Eastern Kingdoms, Alterac Valley: Register scripts on dbTartalo
--HG-- branch : trunk
2010-04-05Add Spells to Coldarra Warmages to target Tansisus Shield Bunnys same as ↵malcromdev@gmail.com>
Violet Stand. Also required: http://trinitydatabase.org/index.php?/topic/15320-fix-for-transis-shield-bunnys-coldarra/ --HG-- branch : trunk
2010-04-05* Actual backoutBrian
* SQL needed to undo 7769 --HG-- branch : trunk
2010-04-05* Backed out changeset 44ff24439269Brian
* We will implement this in a generic way using the conditions system --HG-- branch : trunk
2010-04-05Add option maxPercentHealth to item_required_target to allow setting health ↵malcromdev@gmail.com>
percentage a target must be at before item use on item_required_target is allowed. This will allow better scripting of quest item use on some creatures. --HG-- branch : trunk