aboutsummaryrefslogtreecommitdiff
path: root/sql/mangos.sql
AgeCommit message (Collapse)Author
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
2009-05-06[7777] Fixed talent 30299 and ranks procing also from holy dmg. Author: Corfenmegamage
--HG-- branch : trunk
2009-05-05 [7776] Completed implementation of CMSG_SPELLCLICK Author: arraimegamage
For vehicles, you have to add the correct SPELL_AURA_CONTROL_VEHICLE spells to npc_spellclick_spells, otherwise you won't be able to use them --HG-- branch : trunk
2009-04-27[7720] Fixed crash at .character level use from console. Include GM name in ↵megamage
message for command target if report need. Author: VladimirMangos --HG-- branch : trunk
2009-04-27[7714] Implement new command .character level for set level provided level. ↵megamage
Author: VladimirMangos --HG-- branch : trunk
2009-04-24 [7705] Rename some account/character related commands.megamage
* .lockaccount -> .account lock * .password -> .account password * .chardelete -> .character delete * .customize -> .character customize * .rename -> .character rename [7706] Rename command .plimit -> .server plimit Author: VladimirMangos --HG-- branch : trunk
2009-04-13[7662] Spell power coefficients for talent 48505 and ranks. Author: nos4r2zodmegamage
--HG-- branch : trunk
2009-04-09[7643] Allow set, store and output creture EventAI data version in addition ↵megamage
to world DB and script library versions. Author: VladimirMangos *This patch is disabled in TC2. --HG-- branch : trunk
2009-04-08 [7633] Implement support multiply basic requirements for crireria in ↵megamage
`achievement_criteria_data`. Author: VladimirMangos Also implement additional basic requirements for proper implementing checks for ACHIEVEMENT_CRITERIA_TYPE_DO_EMOTE Req. DB support. --HG-- branch : trunk
2009-04-08[7627] Replace built-in in code table by new DB table ↵megamage
`achievement_criteria_data` for store additional data for achievement criteria. Author: VladimirMangos --HG-- branch : trunk
2009-04-07[7622] Added creatureAI with related database tables. Author: AlexDerekamegamage
*Note: three tables are renamed. --HG-- branch : trunk
2009-04-05[7616] Implement .debug play cinematic and .debig play movie. Rename .debug ↵megamage
playsound to .debug play sound. Author: VladimirMangos *Note: some conflicts of string. --HG-- branch : trunk
2009-04-05[7615] Continue sorting chat command function declarations. Move send ↵megamage
commands in new .send * subcommand list. Author: VladimirMangos --HG-- branch : trunk
2009-04-03[7609] Trailing whitespace cleaning Author: fregharmegamage
--HG-- branch : trunk
2009-03-28[7568] Spell proc event data from forums Author: DiSlordmegamage
--HG-- branch : trunk
2009-03-28 [7565] Move all hardcoded strings used in .account onlinelist to DB. ↵megamage
Author: VladimirMangos Also update format as originally suggested by Cha0S2. --HG-- branch : trunk
2009-03-28 [7560] Implement IconName for gameobject Author: NoFantasymegamage
--HG-- branch : trunk
2009-03-28[7558] Implement command: .learn all_mypettalents Author: VladimirMangosmegamage
Also output more correct messages at use .reset talents to pet --HG-- branch : trunk
2009-03-26[7545] Fixed exploration achievements for certian areas Author: DonTomikamegamage
[7546] move uptime table to Realm database, use realmid column. Author: Triply --HG-- branch : trunk
2009-03-24[7537] Command .lookup player will report in case found accounts/ip but ↵megamage
without existed characters. Author: VladimirMangos --HG-- branch : trunk
2009-03-21 [7503] Implement proper (not 2 level limited) help.security set for chat ↵megamage
commands and subcommands. Update some commands data. Author: VladimirMangos * Now `command` table loading set data for any use subcommand levels * Errors output for not existed in code commands at related data loading from table. * Detail log level report outout about overwrited security level for loaded chat command data. Using this functionality found and fixed/update data for `command` in mangos.sql NOTE: some command security levels changed. Thank you to benemorius for pointing to this security problem. --HG-- branch : trunk