aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
AgeCommit message (Collapse)Author
2009-05-30*Allow to spawn correct npc for defender/attacker in wintergrasp based on ↵megamage
game event. Now only xxx Champion is spawned based on faction for test. Other npc and gameobjects requires DB support (now in db the defender is always horde and attacker always alliance, and the data of counterpart is missing) *Fix defenders' portal (now only useable for horde) *Display random model if the model id in creature table is one of those in creature_template table (in this case they should be 0 actually). --HG-- branch : trunk
2009-05-30*Fix spell Rune Strike.megamage
--HG-- branch : trunk
2009-05-29 [7908] Extract class data from creature_*_addon bytes0 fields, drop its, ↵megamage
amd add unit_class field to creature_template. Author: NoFantasy --HG-- branch : trunk
2009-05-28 [7904] Change creature damage calculation formula. Author: Seizerkillermegamage
* Add new creature_template field `dmg_multiplier` * Make attackpower include in creature damage not dependent from attack speed. NOTE: included in sql update recalculation for creature damage related fields only make temporary possible usable values. Real values need revisited by DB devs for correctness. --HG-- branch : trunk
2009-05-28 [7903] Load and save for pets only talents. Not store unused (in fact) ↵megamage
free talent point amount. Author: VladimirMangos * Other pet spell types auto-learned at level setup/load. * Code will cleanup pet_spell table from non-talents spell if detect any at load. * Free talents points recalculated at loading and levelup so store its in DB useless. Note: bug with not highlighting learned pet talents (except first line) until learn one more talent not fixed. --HG-- branch : trunk
2009-05-28* Used trinity sql coding styleDrahy
--HG-- branch : trunk
2009-05-28Fix wrong data type for core_revision in DB, againParadox
--HG-- branch : trunk
2009-05-27*Some improvement of DK start zone quests (no new quest fixed)megamage
--HG-- branch : trunk
2009-05-27[7902] Speed up Creature and GO loads. Author: AlexDerekamegamage
--HG-- branch : trunk
2009-05-27[7896] Rename creature_template class/race fields to ↵megamage
trainer_class/trainer_race for clarify use. Author: NoFantasy --HG-- branch : trunk
2009-05-27Add fix for quest 12680Kudlaty
--HG-- branch : trunk
2009-05-27* Used trinity sql coding styleDrahy
--HG-- branch : trunk
2009-05-27*Change vehicle faction the same as the driver's when driver enters it.megamage
*Fix 3593 sql. --HG-- branch : trunk
2009-05-27Add script for quest 28406Kudlaty
--HG-- branch : trunk
2009-05-26*Fix a typo in 3467 sql that makes dk start zone taxi not work.megamage
--HG-- branch : trunk
2009-05-26*Fix DK quest 12641megamage
--HG-- branch : trunk
2009-05-26 [7893] Fixed work chat guild commands that expect guild name in args. Now ↵megamage
guild name always must be in "". Author: VladimirMangos --HG-- branch : trunk
2009-05-26Add spell target position for teleports in acherus (54744,54746)Kudlaty
--HG-- branch : trunk
2009-05-26Uptade spell script target with spells (54699,54725,54744,54746)Kudlaty
--HG-- branch : trunk
2009-05-25*Merge. Do not forget to apply TC1 sql!megamage
--HG-- branch : trunk
2009-05-25* Added revision info to full tables up to revision are updatedDrahy
* Removed some sqls from mangos already present in rev 3235 * Used trinity sql coding style --HG-- branch : trunk
2009-05-24*Use hex format for spell_full spell_proc_event table.megamage
--HG-- branch : trunk
2009-05-24 [7886] Drop use table `petcreateinfo_spell`megamage
This is first commit in chain for remove oudated and not used pet functionality. * Use instead dropped table CreatureSpellData.dbc if creature_template.PetSpellDataId set (mostly hunter pets) * Use creature_template.spellN if not set creature_template.PetSpellDataId (mostly different summon creatures) * Fixed bug with not removing from action bar spell icon for not ranked unlearned spells. Note: summoned controllable creatures without PetSpellDataId must have expected spells in spellN feilds for creature_template. [7887] Drop pet spell teaching code, including field in character_pet. Author: VladimirMangos --HG-- branch : trunk
2009-05-24[7879] Fixed proc for 31571 and ranks. Author: Tanatosmegamage
--HG-- branch : trunk
2009-05-24*Add vehicle id for three-seat mammoth.megamage
*Fix spell impale of archavon. --HG-- branch : trunk
2009-05-22Add a column to npc_spellclick_spells table to check if quest is ↵Kudlaty
completed/rewarded or incompleted 1: completed or rewarded; 3: incompleted; default 3 --HG-- branch : trunk
2009-05-22*Some work on wintergrasp. Player can get ranks by killing other players and ↵megamage
can build vehicles at workshop. Vehicles can be used to destroy buildings. Except these no other thing is done. --HG-- branch : trunk
2009-05-21*Fix reckongingQAston
*fix Sword and Board *Fix Vigilance *Rollback sw:death fix. --HG-- branch : trunk
2009-05-20*Merge SD2.Anubisss
*r978: Added few basic parts for ramparts instance script to be used in further development. *r979: Added support for quest 9686. - Skip this patch. Its already scripted. *r980: Added gossip to play movie cutscene after quest 12499/12500 rewarded. *r981: Clean up some code and correcting icon for gossip items. - Just use enums. *r982: Added support for quest 938 (consider it a test for similar quests) --HG-- branch : trunk
2009-05-20*Merge.megamage
--HG-- branch : trunk
2009-05-20*Update Naxx scripts. Now only Kelthuzad is incompletedmegamage
--HG-- branch : trunk
2009-05-20Add taxi scripts for npc Bat Handler CamilleKudlaty
--HG-- branch : trunk
2009-05-20[SD2] 1075Kudlaty
Added 6 new taxi paths (wyrmrest temple) --HG-- branch : trunk
2009-05-20[SD2] 1058Kudlaty
Simplify scripts using manual call ActivateTaxiPathTo(). --HG-- branch : trunk
2009-05-20Merge & move taxi scripts into one file as npc_taxiKudlaty
--HG-- branch : trunk
2009-05-20* Used trinity sql coding styleDrahy
--HG-- branch : trunk
2009-05-19*Merge SD2.Anubisss
*r973: Added support for quest 2767 *r974: Start MoveChase when boss reach phase 3. *r975: Added support for quest 863 - Skip this patch because its already scripted. Just use enum instead of #define *r976: Added support for quest 435 - Skip this patch because its already scripted. Just use enum instead of #define *977: Remove one needless grid search and use new functions for SetRun in one script. - Skip this patch because TrinityCore2 has use another way for it. --HG-- branch : trunk
2009-05-19 [7855] Add description command to pool_* tables for simplify DB ↵megamage
development. Author: Seizerkiller Note: this fields not used and not loaded by mangos. --HG-- branch : trunk
2009-05-19 [7852] Use union of per-event type structures, more checks at creature ↵megamage
event ai loading. Author: VladimirMangos Including: * Fixed check for EVENT_T_SPELLHIT school field. Add check at loading. Note: this event expect before and now schol _mask_ in param2. * In EVENT_T_RECEIVE_EMOTE use original player condition check code instead copy of related code. --HG-- branch : trunk
2009-05-19*Merge SD2.Anubisss
*r968: Adjust some scripts to use SetEquipmentSlots() *r969: Made a few corrections to EventAI.txt *r970: Added ScriptedAI function SetCombatMovement() for future use/development. *r971: Small adjustments to escortAI, remove some useless code and always use current WaitTimer if not already 0 after return to last known waypoint. *r972: Added support for quest 1651 --HG-- branch : trunk
2009-05-19*Corret proc from bloodsurge and judgements of the wiseQAston
*Do not proc backfire dmg from sw:death if target is killed *Allow hots to proc from selfcast *Fix glyph of corruption. --HG-- branch : trunk
2009-05-18*Merge.megamage
--HG-- branch : trunk
2009-05-18*Add some scripted spells for naxx.megamage
--HG-- branch : trunk
2009-05-18*Fix beacon of lightQAston
*Apply healing aura mods to leech auras. --HG-- branch : trunk
2009-05-18*Add a missing part of sql of 3391. By nesocipmegamage
--HG-- branch : trunk
2009-05-18*Spell_proc_event entries for Malestorm Weapon - by throneincQAston
*Fix bug that some spells can't proc *Add spell_proc_event entries for some items. --HG-- branch : trunk
2009-05-18*Fix the bug that startfall aoe damage also apply on direct target.megamage
*Add starfall spell bonus for other ranks. By Uruviel and Nesocip. --HG-- branch : trunk
2009-05-18*Rename a sql file because firstly You should convert the waypoints and ↵Anubisss
after drop the columns. --HG-- branch : trunk rename : sql/updates/3257_world_creature_addon_(waypoint).sql => sql/updates/3258_world_creature_addon_(waypoint).sql
2009-05-18*Add the missing sql from r1508.Anubisss
--HG-- branch : trunk
2009-05-17*Update script for Loatheb.megamage
--HG-- branch : trunk