aboutsummaryrefslogtreecommitdiff
path: root/sql/mangos.sql
AgeCommit message (Collapse)Author
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
2009-03-19*Update gameobject visual and command. By Vladimir.megamage
--HG-- branch : trunk
2009-03-16 [7472] Fixed messages in Eye of Storm Battleground. Author: Triplymegamage
--HG-- branch : trunk
2009-03-13[7453] Fixed some example data in mangos.sql Author: VladimirMangosmegamage
--HG-- branch : trunk
2009-03-10 [7439] Fix wrong liquid level in some places. Need reectract maps. ↵megamage
Author: DiSlord Remove some log on extract maps. Add liquid status log to .gps command --HG-- branch : trunk
2009-03-09[7422] Allow localization base at guildmaster locale default guild rank ↵megamage
names at guild creating. Author: VladimirMangos --HG-- branch : trunk