aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
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
2015-09-28DB/Characters: Updated character create for update hashr00ty
Updated hash for 2015_08_26_00_characters_335.sql for map local guids commit Closes https://github.com/TrinityCore/TrinityCore/issues/15601
2015-09-28Auction house changes:pete318
- Stop storing guid for auctioneer. - Store instead house ID - No separate ID for various houses. Only Horde, Alliance and Neutral. - Removed non-needed faction checks. - Use enum for auction house IDs NOTE: This will expire all current auctions and return item to player (or award to high bidder) in order to prepare database for the changes.
2015-09-22Map local guids 6.x -> 3.3.35:pete318
Implemented: https://github.com/TrinityCore/TrinityCore/commit/ca83e14f8b141fab0a13e08f48fca6c1ace0c4c7 https://github.com/TrinityCore/TrinityCore/commit/ee1c1b97be4492ecabe8b15ea6323fc37e4eaa8c https://github.com/TrinityCore/TrinityCore/commit/18e4ab6911468b829b0fc768e532a770263c3717 https://github.com/TrinityCore/TrinityCore/commit/bf37446b3c2ed73b4d3aa9e227d3eff5c53b378b https://github.com/TrinityCore/TrinityCore/commit/cb854a2b7bb7bd96cf9c4d1daf3789f797bf4db8 * This adds separate (per map) guid sequences depending on object type * Ported map object container from cmangos/mangos-wotlk@a2d396e * Added type container visitor for TypeUnorderedMapContainer * Implemented helper function to erase unique pairs from multimap containers * Moved object storage of all objects except players and transports to map level * Added containers linking database spawn id with creature/gameobject in world * Renamed DBTableGuid to spawnId * Added a separate spawn id sequence generator for creatures and gameobjects - this will be used in db tables * Moved building SMSG_UPDATE_OBJECT - updatefields changes broadcast to map update * Added new function to return but not increment guid * Adjusted .debug loadcells to show low guid in map before/after load * Added debug messages for creature spawn/destroy, for map guid debugging * Store all Gameobjects and Creatures added to OutdoorPvP, so the callback script can be removed when OutdoorPvP instance is destroyed.
2015-08-21Script/Commands: Add new "debug loadcells" commandjackpoz
Closes #15292
2015-07-14TDB 335.59 - 2015/07/14TDB335.59DDuarte
2015-06-29DB/Characters fix auto updaterShinDarth
2015-06-26DB/Characters: Backport schema changes from 6.x branch (renames)ShinDarth
Closes #14951
2015-03-22Update world_database.sqlNayd