aboutsummaryrefslogtreecommitdiff
path: root/sql/mangos.sql
AgeCommit message (Collapse)Author
2009-07-31*Remove world_tmp_full - templates made by core devs are going to be ↵QAston
included in update sqls with _TDB suffix and after thatadded to db converters. *Remove some useless mangos sqls. --HG-- branch : trunk
2009-07-31*Merge after backout.QAston
--HG-- branch : trunk
2009-07-31Backed out changeset "[8251] Store in some DB tables only data for first ↵QAston
rank. Author: VladimirMangos" until support for different values for ranks and for custom ranks is added. --HG-- branch : trunk
2009-07-31 [8252] Move DB scripting code from global World to Map. Author: Ambalmegamage
This one more step to pre-map events proccesing and parallel in future. [8256] Restore DB script loading broken after [8252]. Author: VladimirMangos Also propetly decrease scheduled DB script actions at map unloading. Some code style restore. --HG-- branch : trunk
2009-07-31 [8251] Store in some DB tables only data for first rank. Author: ↵megamage
VladimirMangos * Allow add to DB data only for first rank in table `mangos_spell_bonus_data` and `mangos_spell_proc_event`. * Copy data for other ranks for speedup use at loading for this data and data from `spell_proc_item_enchant`. --HG-- branch : trunk
2009-07-30*Merge required after backout.QAston
--HG-- branch : trunk
2009-07-30*Merge required after backout.QAston
--HG-- branch : trunk
2009-07-30Backed out changeset 6ba74f274cb9 - mangos [8249]QAston
--HG-- branch : trunk
2009-07-30Backed out changeset 774aad302c74 - mangos [8247]QAston
--HG-- branch : trunk
2009-07-30 [8250] Cleanup code and data for `spell_threat` Author: nos4r2zodmegamage
* Load table data to std::map instead SQLStorage and add check loaded spell existance. * Drop from table not existed spells. --HG-- branch : trunk
2009-07-30 [8249] Implement support `spell_proc_item_enchant` table for ppm item ↵megamage
enchantments triggering at hit. * Added a new SQL table, spell_proc_item_enchant, for "custom" ppmRates on Item Enchants that do not use auras. With table data this must fix ppm for effect from 8033 and ranks enchanting, and item 6947/10918 and ranks enchanting. * Implemented SPELLMOD_FREQUENCY_OF_SUCCESS (26). That must fix work talent 14113, spell 32645 with ranks, glyph 41094 and item set effect 64917 in frequency part. Thanks to MaS0n as author alternative patch that partly used in this patch. Thanks to Thenecromancer as author alternative patch that ideas inspire MaS0n's patch writing and then this patch also. Author: nos4r2zod *Note: has been implemented before. Only use part of the patch. --HG-- branch : trunk
2009-07-30[8247] Some data for `spell_bonus_data` for DK spells. Author: nos4r2zodmegamage
I found TC seems to have these data. In the future *.tbd is used for review. Please do not apply them. --HG-- branch : trunk
2009-07-30 [8237] Apply attack power multiplier to creature bonus attackpower. ↵megamage
Author: Lynx3d Note: mindmg/maxdmg in creature_template expected including attackpower part in its. attackpower field only show part of attackpower not affected by AP multiplier. Thanks also to Seizer for take part in reseach and patch review. --HG-- branch : trunk
2009-07-30[8229] Improve stealth detection code for player case. Author: Ambalmegamage
--HG-- branch : trunk
2009-07-24[8215] Update sql/mangos_spell_check.sql. Author: VladimirMangosmegamage
--HG-- branch : trunk
2009-07-23 [8191] Drop code related to use long time empty `spell_affect` table. ↵megamage
Author: XTZGZoReX After switch to 3.x.x all data get explcitly from ClassMask fields in spell.dbc and no need in custom values. --HG-- branch : trunk
2009-07-20 [8190] Update killing quest objectives base at creature_template ↵megamage
KillCredit fields. Author: GriffonHeart Note: for avoid double counting must be removed C++ scripts and EventAI scripts that do same thing in old way. Signed-off-by: VladimirMangos <vladimir@getmangos.com> Also implement KillCreditN field check at loading. --HG-- branch : trunk
2009-07-12 [8158] Update `playercreateinfo_action` base at UDB data for this table. ↵megamage
Author: VladimirMangos * Some fixes added for used UDB data base at not applied old mangos sql update and drop some wrong data. * Primary key added to avoid button duplicates for (race,class) pair. * This update expected to fix recently problems with empty action bars for new created characters Note: This sql update not affect existed characters. --HG-- branch : trunk
2009-07-12[8145] Use constant name instead not-safe explicit value. Author: Ambalmegamage
--HG-- branch : trunk
2009-07-07 [8115] Replace table contecnt by expected data from mangos.sql Author: ↵megamage
VladimirMangos For finally fix problem with new crated characters in addition to [8107]. --HG-- branch : trunk
2009-07-01*Backup your DB!megamage
[8098] Support uint32 spell ids in code. Author: VladimirMangos * Propertly work with uint32 spell ids in player action bar * Fix in same time bug with not save equipment set button with id==0 * Merge misc field in character_action and playercreateinfo_action to action field as 3 byte * Propertly load uint32 spell ids from character_spell * Fixed types for some pet/creature related structure for spell id storing. --HG-- branch : trunk
2009-06-27 [8072] First step to get rid of data blob.megamage
Adds new fields gender, level, xp, money, playerBytes, playerBytes2 and playerFlags to characters table. The update will not work if your database contains characters with an old data field (not fitting to the actual client version). It's recommended to backup your character database before applying this patch. --HG-- branch : trunk
2009-06-27[8067] Fixed tabs and trailing whitespaces in code. Author: VladimirMangosmegamage
--HG-- branch : trunk
2009-06-27[8057] Move code from Event AI to class Creature function for reuse in other ↵megamage
scripting cases. Author: NoFantasy --HG-- branch : trunk
2009-06-27[8051] Fixed some drinking mana regen spells. Author: bobazmegamage
--HG-- branch : trunk
2009-06-17 [8030] Fixed spell 64901 work and related target selection code ↵megamage
refactoring. Author: VladimirMangos * Replace 64904 by 64901 in spellbook and action bars. * Implement proper max mana percent buff * Implement proper target selection. * Move group/raid targets seelction code to functions for reuse code. --HG-- branch : trunk
2009-06-15[8021] Implement triggering part of shaman talent 51483 and ranks. Author: ↵megamage
Beaste. sql by QAston --HG-- branch : trunk
2009-06-15 [8016] Work at npc click table data use. Author: VladimirMangosmegamage
* New fields in `npc_spellclick_spells` for allow set npc spell click mode from quest to infinity or to another quest, or from reward quest. * Not expect (and forbid set UNIT_NPC_FLAG_SPELLCLICK in DB and set it at `npc_spellclick_spells` loading. * Apply some speedups for creature checks affected by spel click state *Also add target position of 51852. By Roland --HG-- branch : trunk
2009-06-11 [7994] Include in mangos.sql/characters.sql changes from ↵megamage
sql/updates/7988_*.sql Author: VladimirMangos Also fix old typos in item_template data in mangos.sql --HG-- branch : trunk
2009-06-11*Switch to support client version 3.1.3megamage
*I strongly recommend you not to use this until you get the 313 db. Now all destructible buildings cause client crash. Source: Mangos Thanks to TOM_RUS for most work to make this switch possible ;) --HG-- branch : trunk
2009-06-10*Some merge of Mangos before update to 3.1.3. TC2 will update to 3.1.3 after ↵megamage
about 10 hours. --HG-- branch : trunk
2009-06-08 [7980] Implement item use target requirements store and check (new table ↵megamage
`item_required_target`). Author: NoFantasy Signed-off-by: VladimirMangos <vladimir@getmangos.com> * Also implement this table reload * Static Spell::SendCastResult function for call not from spell code. Can be also used in scripts where need send explicitly spell cast error to client. --HG-- branch : trunk
2009-06-03[7945] Implement support quest data for DetailsEmoteDelay and ↵megamage
OfferRewardEmoteDelay value for set time ordering details and reward emotes. Author: NoFantasy --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-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-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-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[7885] Fixed talent 34914 and ranks proc spell to correct spellid. Author: qsamegamage
--HG-- branch : trunk
2009-05-24[7879] Fixed proc for 31571 and ranks. Author: Tanatosmegamage
--HG-- branch : trunk
2009-05-22Correct typo in previous commitKudlaty
--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-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[7851] Fixed typo to allow work '.tele name' command.megamage
[7850] Fixed '.pinfo name' work, move reputation code from it to new command '.character reputation [$name]'. Provide and use universal way for get locale and locale index for chat/console command use. Author: VladimirMangos --HG-- branch : trunk
2009-05-17 [7839] Rafactoring player targeting code in chat command and related ↵megamage
cleanups/improvments. * New extractOptFirstArg function for easy get 2 args in case option playe name as first arg. * New extractPlayerTarget function for get player pointer/guid/name for online/offline player base at provided name or if not provided by current seelction with error cases processing. * Property apply mute/unmute in case use different character name from loggined currently for account. * .reset commands can be used from console now * .repairitems comamnd can be used from console now but only to online player. Author: VladimirMangos --HG-- branch : trunk
2009-05-15[7831] Prevent have hunter pet with level greater player levels at level ↵megamage
changes. Propertly set hunter pet xp values at level update. Author: VladimirMangos --HG-- branch : trunk
2009-05-14[7823] Fix ScalingStatValue field size in item_template table. Author: DiSlordmegamage
--HG-- branch : trunk
2009-05-13[7817] Add missing sql-updates to mangos.sql (7776, 7777, 7782) Author: Brueggusmegamage
--HG-- branch : trunk
2009-05-08[7796] Implement .lookup taxinode and .go taxinode commands. Author: ↵megamage
VladimirMangos --HG-- branch : trunk