aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
2017-06-28Combat/threat rewrite prep - merge RBAC/DB changes.treeston
2017-06-17Another follow-up to b59ca1c and 41eddd5, fixing missing update entry in ↵treeston
auth_database base. This is a stupid, stupid system we have here.
2017-06-17Correct some missing auth DB changes from b59ca1c.treeston
2017-06-13Typo fixAokromes
2017-06-12Add new command 'npc showloot'. Does exactly what it says on the tin.treeston
2017-06-12Insert dynamic_spawning RBACs (already reserved in RBAC.h as of 55d8c2b) ↵treeston
into auth database to prevent constant base file conflicts on that branch.
2017-06-12- Add new commands .group set assistant, .group set maintank and .group set ↵treeston
mainassist to toggle raid member flags. - Fix 2017_05_29_00_auth.sql to be reapply safe.
2017-05-29Scripts/Command: implement .debug play music commandForesterDev
Closes #19809
2017-04-19TDB 335.63 - 2017/04/18TDB335.63DDuarte
2017-04-12Core/Instance: stop updating the instance resettimes based on creature respawnsariel-
- Rather update normal instance reset time to 2 hours after last creature kill - This fixes yet another integer overflow due to the possibility of having time_t max showing up - Also change respawntime and resettime fields to bigint on respawn/instance related tables - Start using prepared statements on the InstanceSaveMgr
2017-04-11Core/Loot: implement Loot Item Storage (#19018)xinef1
* Created Item Loot Storage, no more synchronous DB selects * Fixed buyback case, where stored loot was not removed from db * Added Primary key, and changed field types to be unsigned for table item_loot_money
2017-04-03DB/Schema: add unsigned to some guid fields in charactersariel-
2017-03-27Update characters_database.sqlAokromes
2017-03-17Core/Players: Rename "heroic character" to "death knight"Chazy Chaz
Closes #19287
2017-02-06Updated auth_database.sql after 9e65feadariel-
2017-01-08Scripts/Commands: Fix guid usage and enhance commands (#18278)Rochet2
- Fix targeting gameobjects and creatures for .dist and .gps. The old code used DB guid to search from core generated guid lists. - Fix some error messages saying 'no player found' even if creatures and gameobjects and players were searched - Change atoi to atoul when receiving lowguids as string or other uint32 values - Use ObjectGuid::LowType instead of uint32 for lowguid type - Allow .gob info to take in gameobject guid link as well as entry link in addition to gameobject entry and update the documentation of the command - Change .gob delete to post the spawnid (dbguid) instead of the ingame generated guid (which is basically never seen or used by the player in any other commands that I see) - Allow spawntimesecs to be negative when spawning a gameobject - Disable searching by ingame spawn id in commands. (it makes little sense for a user to provide a number which is then attempted to be used as DB guid and non DB guid when both could have a match) - Update .gob turn documentation to tell about possibility to provide orientation in command - Correct the types in .gob add command result trinity_string - Correct the creature search for .npc del - Change .event to .event info - Add .go offset command - Remove the .go command for empty string (no subcommand given) because it just used .go xyz - Extend .gob info to show size, faction, flags and model dimensions - Remove some unnecessary casts - Document .wp show better (first and last were not documented) - Insert spawnid to .wp show info error message - Fix spawntime printing for .gobject target - Fix guid targetting for .npc set movetype - Fix query by spawnid for .wp show info - Fix deleting of existing waypoints when twice doing the command .wp show on - Fix deleting of existing waypoints when doing the command .wp show off - Change wpguid column in DB and in core to uint32, which is what the spawnid type is in core and db.
2017-01-06Core/Scripts: added command to move characters across accountsariel-
2016-10-30Update characters_database.sqlariel-
Last one, I promise
2016-10-30Update characters_database.sqlariel-
Missing line from previous commit
2016-10-30Core/Auras: don't save auras casted by itemsariel-
- Drop useless field from DB (itemGuid was being saved, but never used, see Prepared Statements) - This type of auras (like Water Bucket, Precious Ribbon, etc) will be recasted on login anyways. This reverts commit 16cfd59f5b368fd1d05eeeab3afbacfccf0a6870
2016-10-16TDB 335.62 - 2016/10/17TDB335.62DDuarte
2016-10-04Core/Spells: Implementation of QAston proc systemariel-
- Move checks from Unit::IsTriggeredAtSpellProcEvent (old system) to Aura::IsProcTriggeredOnEvent (new system) - Templatize SpellModOp param of Player::ApplySpellMod, also killed charge counter from SpellModifier and Player system for handling charges... no point in having 3 different systems doing the same thing - Automatically add default entries to spellProcMap, based on spellinfo (else auras won't proc without an entry) Based on old Unit::ProcDamageAndSpellFor - Old Unit::ProcDamageAndSpellFor renamed to Unit::ProcSkillsAndReactives and made private, will no longer handle auras. - Start making use of HealInfo::AbsorbHeal in unit calculations, add effective healing info to HealInfo struct - Changes in spell reflection system, emulates old behaviour, delaying aura drop - Removed old charge count hacks in SpellMgr::LoadSpellInfoCorrections - Removed bogus error log when procChance is 0: Some auras have initial 0 procChance but modified by SPELLMOD_CHANCE_OF_SUCCESS - Fixed TriggerAurasProcOnEvent logic that tried to trigger twice from actor. - Allow non damaging spells with DamageClass Melee or Ranged to proc character enchants. Ref issue #17034: * http://web.archive.org/web/20110309092008/http://elitistjerks.com/f47/t49865-paladin_retribution_pve/ * When an auto-attack lands (does not dodge/parry/miss) that can proc a seal the of the following things happen independently of each other (see 2 roll system). * 1) A "hidden strike" which uses melee combat mechanics occurs. If it lands it refreshes/stacks SoV DoT. Only white swings can trigger a refresh or stack. (This hidden strike mechanic can also proc things like berserking..) * 2) A weapon damage based proc will occur if you used a special (CS/DS/judge) or if you have a 5 stack (from auto attacks). This attack can not be avoided. * Holy Vengeance is the "hidden strike" it has an apply aura effect and damage class melee. - Fixed Blood Tap interaction with Death Runes (btw, don't know what was going on with those MiscValueB, spell 45529 doesn't have any MiscValueB in SPELL_EFFECT_ACTIVATE_RUNE) - Ported some AuraEffect checks from old Unit.cpp function. added new AuraScript hook to check procs of an specific effect - Allow only AuraEffects that passed the check to proc, this won't block whole aura from proccing (and lose charges) if at least one of the effects procs, though - Changes in spell mod system (for SPELLMOD_CASTING_TIME). fixes #17558. - Added an exception for SPELLMOD_CRITICAL_CHANCE too, fixes #15193
2016-09-13Follow-up to 6f1e823.SnapperRy
Forgot to update base characters database. Sorry.
2016-09-13Core/Fishing: implement retail-like fishing skill-up functionality (#17528)SnapperRy
2016-07-02Core/Misc: Clarify the use of world_database.sqlAokromes
2016-06-14Core/Commands: Implement .neargraveyard (find nearest graveyard from dbc). ↵xjose93
(#17301)
2016-05-11Merge branch '3.3.5-commandfixes' into 3.3.5 (PR #16335)treeston
2016-05-10Scripts/Commands: Small QoL adjustmentstreeston
- .debug hostil now shows spawn ID (DBGUID) in addition to current GUID (so you can .go creature to it) - .npc temp now takes an additional argument before the creature entry that determines whether the spawned creature instantly despawns upon death. Default is instant despawn (current behavior). - Add .npc evade command. - Add .pet level command. - .server shutdown and .server restart now fail with an error message if time is below a config var (GM.ForceShutdownThreshold, default 30s) as long as another player is connected. - New commands .server shutdown force and .server restart force bypass this limitation.
2016-04-16DB/Auth: Fix incorrect value in base/auth_database.sql.treeston
2016-04-11Update revision_data.h.in.cmake and the `updates` in base SQLsDDuarte
2016-04-11TDB 335.61 - 2016/04/11TDB335.61DDuarte
2016-03-13Core/Players: Split playerBytes fields in characters tableShauren
(cherry picked from commit 2a6f65fddcdbe074ace6cd08ab27ec73a64ffe76)
2016-02-15Update to 62aff401f687b56d720a320778950e82b65fbd8b - correct hash for ↵pete318
2016_02_10_00_characters.sql.
2016-02-10Merge branch '3.3.5-instanceextend' into 3.3.5 (PR #16392)treeston
2016-02-10Maps/Instances: Implement handling of CMSG_SET_SAVED_INSTANCE_EXTENDtreeston
2016-01-13Merge branch '3.3.5-bossboundary' into 3.3.5-base (PR #16089)treeston
2016-01-12Scripts/Instances: Complete rewrite of the boundary system.treeston
- Migrate boundary logic to Maps/AreaBoundary instead of having it sit in InstanceScript (to possibly allow use for other purposes). - Implement the first five boundary types in Maps/AreaBoundary.cpp. - Add boundary checks to Creature's update logic - Add boundary data for all Northrend raids - Add boundary initialization structures and methods to InstanceScript - Modify EnterEvadeMode signature. It now passes a value from the EvadeReason enum as parameter to allow special casing depending on evade reason - Remove previous (weird) boundary code that had them linked to GO spawns
2015-11-07TDB 335.60 - 2015/11/07TDB335.60Carbenium
2015-11-03Core/Ticket improved ticket systemShinDarth
- Safely close ticket before character deletion - Allow to keep trace of delete characters tickets (configurable) - Closes #15655 Closes #15699
2015-10-30Travis fix.Shauren
2015-10-30SQL: syntax fix in characters_database.sqlShauren
2015-10-29Core/Spells: Improved spell category cooldown handlingShauren
* Category cooldown is stored with the spell that started the cooldown (and only resetting cooldown on that spell will clear cooldowns on entire category - this fully mirrors client behavior) * This significantly reduces the amount of data saved to database for cooldowns * Spell casts from items that have a different category specified than on spell will now check for cooldown during the cast (cherry picked from commit 1efb3f08e278530f59d681f676b031a7fc6db3ac) Closes #15766 Closes #15137 Closes #14837
2015-10-28Core/Battleground: implement deserters tracker featureShinDarth
2015-10-12Core/BG fix .character changefaction pvpstats victories amountShinDarth
2015-10-08And final change to include table hash in updatespete318
Not actually needed for this change, but it upset travis
2015-10-08Also update character base create for pet_aura commitpete318
2015-10-06Rename SQL after PR mergeDDuarte
2015-10-06Merge pull request #15654 from ShinDarth/resolvedByDuarte Duarte
Core/Ticket keep always trace of GM who resolves the ticket
2015-10-06Core/Ticket keep always trace of GM who resolves the ticketShinDarth
2015-10-05DB/Auth: Add missing update 2015_08_21_00_auth.sql to the auth base.Naios