aboutsummaryrefslogtreecommitdiff
path: root/sql/characters.sql
AgeCommit message (Collapse)Author
2010-04-21* Add some more transactioncontrol to pet database handling + adjust ↵click
character_aura keys to avoid duplicates --HG-- branch : trunk
2010-04-16Reapply the previous "actionbars"-fix/handling db/coresideclick
Fixes issue #1669 Note: This issue has been a pain in the rear, as it was actually messing up clients that ran a vanilla client without addons. The issue only comes in to place when players load a SINGLE actionbar, and not selecting "activate all bars". Extensive testing and debugging done to figure out why this actually happened - I'll fricking shoot the next one messing with it! --HG-- branch : trunk
2010-04-15Changed worldstates.comment field to allow NULL values (by Spp).teacher
Proper naming for recent sql files. Who was the fool to give me push access!? --HG-- branch : trunk
2010-04-15Fixed my typo in characters.sql (thx Kaelima for whacking me)<2teacher
--HG-- branch : trunk
2010-04-15Added worldstates values in characters.sql and re-dumped to prevent any issues.teacher
The first time there was no insert statement in the sql update. --HG-- branch : trunk
2010-04-15Fix bad use of worldstates table in last commitSpp
--HG-- branch : trunk
2010-04-15Another fix quest flags, Implement support weekly quests cooldowns(Original ↵n0n4m3
patch by GriffonHeart), also code cleanups. --HG-- branch : trunk
2010-04-14*fix typo in characters.sql thanks to D3VILRat
--HG-- branch : trunk
2010-04-14Create new table character_stats for external tools(website,etc). This table ↵n0n4m3
use only when player logout. Original code by hunuza. --HG-- branch : trunk
2010-04-14Add index for some tables in characters DB. by AlexDereka.n0n4m3
--HG-- branch : trunk
2010-04-14Drop not needed table 'item_text', add new column 'text' in table ↵n0n4m3
'item_instance'. Original patch by Vladimir. --HG-- branch : trunk
2010-04-13* Fix actionbars-issue with talent-based spells/actions disappearingclick
* Revert previous mess someone(tm) made with the "reinstating" actionBars -field (me!) --HG-- branch : trunk
2010-04-12Restore load/save shown actionbars, missing from 3.3.3 upgradeclick
Original SQL by hunuza/MaNGOS project --HG-- branch : trunk
2010-04-11Add sql for drop mail column 'itemtextid' and add new column 'body'.n0n4m3
--HG-- branch : trunk
2010-04-11Drop characters data blob. Bit thx to hunuza.n0n4m3
--HG-- branch : trunk
2010-03-26* Add support to save and load worldstates.Spp
will be mainly used by outdoorPvP system * Update next arena auto distribute points time to custom worldstate --HG-- branch : trunk
2010-03-19Little sql improvement.teacher
--HG-- branch : trunk
2010-03-18Store alternate currency spent on an item by Item ExtendedCost entry instead ↵Machiavelli
of honorPts/arenaPts/items seperately. Thanks to Opterman for the idea. --HG-- branch : trunk
2010-03-15Change field `crc` in characters.addons to int(32) to support proper values.Machiavelli
--HG-- branch : trunk
2010-03-09Small update to the group/party system.Machiavelli
- Fixes raid assistant privileges, Fixes issue #248 - Proper designation for Main tank and Main assistant roles - Remove 2 redundant columns in DB, namely groups.mainTank and groups.mainAssist. These are now defined by the value of group_member.memberFlags --HG-- branch : trunk
2010-03-02* Add change to characters.sql from last commitBrian
--HG-- branch : trunk
2010-03-02* Move some values out of the data blob in the characters tableBrian
* (honor, kills, title, currencies, watched faction, drunken-status, health and power) * Original Author Hunuza - thank you * Ported to Trinity by RammboNr5 - thank you * Tested by Aokromes - thank you * Closes Issue #911 --HG-- branch : trunk
2010-02-23Missed changes from last commit. Sorry bout that.p0wer
--HG-- branch : trunk
2010-02-14* Core switch to client 3.3.2 (11403)Brian
* Credits (in no particular order) to: * n0n4m3, raczman, manuel, Spp, Malcrom, Teacher, QAston, Tartalo, * thenecromancer, Xanadu, Trazom, Zor, kiper * Additional credits to: * TOM_RUS and NoFantasy from MaNGOS * Thanks for testing Aokromes and XTElite1 * SoTA still needs some work, but is very playable (huge thanks to raczman and * kiper) * To upgrade, you need to apply all SQL from sql/updates/3.2.2a_old from the * last rev you are on * and then apply all SQL from sql/updates/3.3.2_old to char / realmd / world * DBs * Known problem with guild banks. --HG-- branch : trunk
2010-02-01Updated world.sql and characters.sql.teacher
Removed commented code form realm.sql and set account.expansion field default value to 2 (wotlk) (thx Aokromes). Properly set default values for some world DB fields. Properly set some world DB fields to allow Database import in strict mode (by Brian). Updated world_script_full with recent committed npc script. Renamed a couple of files with proper revision number. Note: no DB data will changed nor harmed by this commit. --HG-- branch : trunk
2010-01-20* Add basic AddonMgr.XTZGZoReX
* All this really does at the moment is save addon names + CRCs to DB for use for.. whatever, later. --HG-- branch : trunk
2010-01-10Update aura system:QAston
* Change system logic - unify Auras, AreaAuras and PersistentAreaAuras: * Aura has now its owner - which is the WorldObject, which applies aura (creates AuraApplication object) dependant on aura radius, and effect type * Owner can be Dynobj (DynObjAura class) for PersistentAreaAuras, or Unit (UnitAura class) for Area and nonArea auras * Aura data is shared for all units which have AuraApplication of the Aura * Because of that AuraEffect handlers , and periodic tick functions can't modify AuraEffect object (they are const now) * Remove spell source and AreaAuraEffect classes * Add AuraEffect::UpdatePeriodic function, to allow periodic aura object modification (target independant) * Add AuraEffect::CalculateAmount and AuraEffect::CalculateSpellMod function, to allow non-default amount calculation * AreaAura updates are done in owner _UpdateSpells cycle * Since now you don't need to wait an aura update cycle to get area aura applied on it's correct target list * And you can access area aura target list * Add basic support for aura amount recalculation * Save recalculation state and base amount of auras to db * Add AuraEffect::CalculatePeriodic function to determine if aura is periodic, and to set correct tick number after aura is loaded from db * Add ChangeAmount function in addition to SetAmount function, to allow easy reapplication of AuraEffect handlers on all targets * Sort aura effect handlers in SpellAuras.cpp and .h by their use * Add check for already existing aura of that type to some AuraEffect handlers, to prevent incorrect effect removal * SPELL_AURA_CONVERT_RUNE and MOD_POWER_REGEN and MOD_REGEN hacky handlers are now implemented correctly * Send aura application client update only once per unit update - prevent unnecesary packet spam * Fix ByteBuffer::appendPackGUID function - it added additionall 0s at the end of the packet * Fix memory leak at player creation (not deleted auras) * Updated some naming conventions (too many to mention) * Added Unit::GetAuraOfRankedSpell() function * Remove procflags on aura remove, use Aura::HandleAuraSpecificMods instead * Added functions to maintain owned auras (GetOwnedAuras, GetOwnedAura, RemoveOwnedAura, etc) * Implement AURA_INTERRUPT_FLAG_LANDING * Implement EffectPlayerNotification (thanks to Spp) * Remove wrong aura 304 handler * Add better handler for death runes * Remove unnecesary variables from DynamicObject class, and cleanup related code, link dynobj duration with aura * Add GetAuraEffectTriggerTarget function in CreatureAi for special target selection for periodic trigger auras used in a script * Add many assert() procection from idiots using some functions in wrong way * I am to lazy to write here anything more Thanks to Visagalis for testing this patch PS: Do not make patches like this, please --HG-- branch : trunk
2009-12-18Added missing sql updatesn0n4m3
--HG-- branch : trunk
2009-12-17Added sql updates 3.1.3-3.2.2an0n4m3
--HG-- branch : trunk
2009-12-14Mangos merge: [8874] Extract player skills from data blob. #526Kudlaty
Converted by Azazel. --HG-- branch : trunk
2009-11-01*Cleanup, fix many cases of unoptimized loops, potential crashes, ↵maximius
excessively large data types, unnecessary or wrong casts, non-standardized function calls, and so on.. *Proper Maexxna Web Spray locations (old locations sent players flying into the air) --HG-- branch : trunk
2009-09-02Clean up some sqls to make sure they all have at least one newline at the ↵Chaz Brown
end (part of the coding standard) helps stop errors when sqls are batched together.... Also, add a missing Delete query to one sql. --HG-- branch : trunk
2009-09-01 [8433] Implement proper store and use character specific account data.megamage
* Base at TOM_RUS reseach save/load character specific account data in new table `character_account_data` * Move its in sql update from `account_data` to new table. * For client packets that can be send in loggined state or just after logout but assocualted with recently logout character add new login status STATUS_LOGGEDIN_OR_RECENTLY_LOGGOUT * Store low guid for loggedin player or recently logout into WorldSession. Author: VladimirMangos, TOM_RUS --HG-- branch : trunk
2009-08-24 [8409] Fixed guild creation date loading, and added another guild ↵megamage
loading optimization - last one. Signed-off-by: Triply <triply@getmangos.com> --HG-- branch : trunk
2009-08-24 [8402] Optimalized guild_eventlog and guild_bank_eventlog loading from ↵megamage
database. Added config options to set count of eventlog records stored in DB. Attached SQL files will DROP existing and create new tables. Make sure you create backup (if you need old data). Renamed few variables in Guild class. Signed-off-by: Triply <triply@getmangos.com> *Note: existing guild bank log will be removed. --HG-- branch : trunk
2009-08-24*Some better check of well-fed buff. Source: Mangosmegamage
--HG-- branch : trunk
2009-08-18AHBot - Fix maxstack DB option to correctly set stacks to a random choice ↵Chaz Brown
between 1 and the maxstack setting of the item, instead of 1. - Thanks T`lexii for pointing this out --HG-- branch : trunk
2009-08-17Channel system update:Machiavelli
* Fix bug that player does not have moderator priveliges when ownership was passed on to him after previous owner left the channel. * Comment out code + alter DB field that are responsible for storing ownerGUID in the database, making it no longer possible for an ex-owner to instantly regain ownership by rejoining the channel as this is not blizzlike. The code is commented out in case someone wants to make a configurable option out of it. * Cleanup some other code in affected files. --HG-- branch : trunk
2009-08-14*Add Dual Spec support, original by EnderGT, thanks to Thyros and XTElite1 ↵maximius
for helping me test :) --HG-- branch : trunk
2009-08-12 [8339] Improved storing/restoring BG entry pointmegamage
* Introduced new table character_battleground_data * Entry point is now stored on BG enter event not join event * Entry point for dungeons is now correctly set to nearest graveyard (this prevent well known assert in GetInstance because of porting to already destroyed instance) * Teleporting from BG correctly restore mount state * Teleporting from BG correctly restore taxi flight (in multipath flight you will end up in nearest transition point on the route) Signed-off-by: ApoC <apoc@nymfe.net> --HG-- branch : trunk
2009-08-08Add config options for filters, add some, delete some, change others. Make ↵Chaz Brown
sure you update your trinitycore.conf --HG-- branch : trunk
2009-07-21*Add table channels to characters.sqlAnubisss
--HG-- branch : trunk
2009-07-01[8104] Always (except 2 cases) for tables in characters DB InnoDB and utf8. ↵megamage
Author: VladimirMangos --HG-- branch : trunk
2009-07-01*Backup your DB!megamage
[8098] Support uint32 spell ids in code. Author: VladimirMangos * Propertly work with uint32 spell ids in player action bar * Fix in same time bug with not save equipment set button with id==0 * Merge misc field in character_action and playercreateinfo_action to action field as 3 byte * Propertly load uint32 spell ids from character_spell * Fixed types for some pet/creature related structure for spell id storing. --HG-- branch : trunk
2009-06-27 [8072] First step to get rid of data blob.megamage
Adds new fields gender, level, xp, money, playerBytes, playerBytes2 and playerFlags to characters table. The update will not work if your database contains characters with an old data field (not fitting to the actual client version). It's recommended to backup your character database before applying this patch. --HG-- branch : trunk
2009-06-23[8052] Fixed typo in error log output. Author: The_Game_MasterQAston
[8049] Added energize effect after last heal tick for 33763 and ranks. Author: bobaz [8053] At character talents reset using chat command also reset talents for all character pets. Author: VladimirMangos --HG-- branch : trunk
2009-06-18*Mergemegamage
--HG-- branch : trunk
2009-06-18*Add new line to end of sqls.hunteee
--HG-- branch : trunk
2009-06-18*Second part of previous commit.hunteee
--HG-- branch : trunk
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