aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
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
2015-03-21TDB 335.58 - 2015/03/21TDB335.58Nayd
2015-03-21Core/Updates: Add an automatic database update system. Automatically detects ↵Naios
new and edited sql updates through file lists and hashing. Detects renames, deletes and is able to create and auto import full databases. * cleanups in main.cpp of world & bnetserver * refactoring in DatabaseWorkerPool.h & MySQLConnection.cpp Make sure you re-run cmake, because boost::iostreams was added as dependency. Maybe you need to install libboost-iostreams1.55-dev on unix as well. Import every update manual until (included) those INSERT IGNORE updates for each database. Thanks DDuarte and Shauren for your amazing ideas, help and advises. In hope that nobody gets a "Your database structure is not up to date..." anymore ,-) (cherry picked from commit 352012e53173372ebc82898e1b6854c983b01b25) (cherry picked from commit 1f7f9feafc3f5017d617634ae993d2cdf4430920) For 3.3.5: * Synchronized ConfigureBoost.cmake with 6.x, libboost-filesystem1.55-dev also added as dependency! Signed-off-by: Naios <naios-dev@live.de> Signed-off-by: Nayd <dnpd.dd@gmail.com>
2014-12-21SQL: Sync auth databaseVincent-Michael
2014-12-10Core/RBAC: Allow setting different default security level roles to different ↵Nyeriah
realms
2014-11-11Scripts/Commands: mod xp commandHeihachi
Closes #13476