aboutsummaryrefslogtreecommitdiff
path: root/sql/mangos.sql
AgeCommit message (Collapse)Author
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
2009-03-07 [7399] Rewrited BattleGround starting code - moved it to battleground ↵megamage
class. Author: Triply Fixed message color for premature finish warnings. Fixed .debug bg command won't allow 1v0 arenas now, only battlegrounds 1v0. Added battleground announcer message removed in [7384]. [7401] Fixed bgqueue invitation to already started battlegrounds - not tested. Author: Triply --HG-- branch : trunk
2009-03-06[7393] Implement access to client side holiday ids. Author: VladimirMangosmegamage
* src/game/GameEvent.* renamed to src/game/GameEventMgr.* for consistence * `game_event` now have new `holiday` field for store client side holiday id associated with game event * Added new enum HolidayIds with existed at this moment holiday ids. * New function "bool IsHolidayActive(HolidayIds id)" added accessabel from scripts for active holidays check. --HG-- branch : trunk
2009-03-06[7388] Fixed battleground premature warning message. SQL files are attached, ↵megamage
you must execute them! Author: Triply Fix for message's color will be soon. --HG-- branch : trunk
2009-03-06[7387] Check maxcount >= min count for item (not reference) record in loot ↵megamage
templates DB tables.. Author: VladimirMangos --HG-- branch : trunk
2009-03-05[7382] Add 2 unknown field to `creature_template` sent in ↵megamage
SMSG_CREATURE_QUERY_RESPONSE to client Author: NoFantasy --HG-- branch : trunk
2009-03-03 [7376] Allow store in spell_area.aura_spell negative values for "not has ↵megamage
aura" requirement. Author: VladimirMangos Also * Allow have in aura_spell spells with SPELL_AURA_PHASE in first effect. * Allow negative aura_spell chaining in spell_area table. * Better check at loading duplicate data (by requiremnt set) in spell_area table. --HG-- branch : trunk
2009-03-02[7369] Remove ReqSourceRef in quest_template. Author: NoFantasymegamage
--HG-- branch : trunk
2009-02-27 [7349] Implement spell cast depenences from area/quest.aura state store ↵megamage
in new table `spell_area`. Author: VladimirMangos * It allow store requirenments: area, active or rewarded quest (until possible another quest not rewarded), aura present at character, character race/gender. * Listed spell can marked as auto-casted when fit requirents. In this case spell requirements checked at zone/subzone update (and then resurraction also), quest start/reward, dummy aura apply. * Old hardcoded lines for similar check removed from sources and required DB support for work now. --HG-- branch : trunk