aboutsummaryrefslogtreecommitdiff
path: root/sql/characters.sql
AgeCommit message (Collapse)Author
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
2009-06-11 [7994] Include in mangos.sql/characters.sql changes from ↵megamage
sql/updates/7988_*.sql Author: VladimirMangos Also fix old typos in item_template data in mangos.sql --HG-- branch : trunk
2009-06-11Forgotten changes in characters.sqlChaz Brown
--HG-- branch : trunk
2009-06-11Forgotten changes in characters.sqlChaz Brown
--HG-- branch : trunk
2009-06-11*Switch to support client version 3.1.3megamage
*I strongly recommend you not to use this until you get the 313 db. Now all destructible buildings cause client crash. Source: Mangos Thanks to TOM_RUS for most work to make this switch possible ;) --HG-- branch : trunk
2009-06-05Add forgotten sql changes for 3791Chaz Brown
--HG-- branch : trunk
2009-06-05Fix AHBot to calculate the deposit for auctions so it can be used to check ↵Chaz Brown
the code for figuring deposit amount on a wide range of items. Fix ahbotoptions command so it works from the server console again. change commented out lines in GetAuctionDeposit so they display in debug loglevel. Min/Max Time settings replaced with a function that selects 12 24 and 48 randomly as the auction times. Backport from TC2 --HG-- branch : trunk
2009-06-01[7932] Store in DB only spell part of pet action bar, set other to default ↵megamage
state (reaction saved). Author: VladimirMangos --HG-- branch : trunk
2009-05-28 [7903] Load and save for pets only talents. Not store unused (in fact) ↵megamage
free talent point amount. Author: VladimirMangos * Other pet spell types auto-learned at level setup/load. * Code will cleanup pet_spell table from non-talents spell if detect any at load. * Free talents points recalculated at loading and levelup so store its in DB useless. Note: bug with not highlighting learned pet talents (except first line) until learn one more talent not fixed. --HG-- branch : trunk
2009-05-25Update characters.sqlKudlaty
--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-11Add forgotten column in characters.sqlChaz Brown
--HG-- branch : trunk
2009-05-08[7802] Use more appropriate field types in `character_achievement*` tables. ↵megamage
Better check data at loading. Author: VladimirMangos --HG-- branch : trunk
2009-05-04fix more forgotten changes in full characters.sqlChaz Brown
--HG-- branch : trunk
2009-05-04fix more typos in full characters.sqlChaz Brown
--HG-- branch : trunk
2009-05-04fix typo in full characters.sqlChaz Brown
--HG-- branch : trunk
2009-04-21Fix characters.sql bad merge leftoversChaz Brown
--HG-- branch : trunk
2009-04-10 [7644] Fixed pet slot values using in pet save. Author: VladimirMangosmegamage
Problem exist from client version switch when stable slot amount changed. In result this has been source problems with stable use (3-4 slots) and possible pet lost in some cases or "not save state" for summoned pets. Use enums to avoid repeating problem, use more safe value for not-in-slot save (for summoned pets) Fixed data preparing for MSG_LIST_STABLED_PETS. --HG-- branch : trunk
2009-04-10Fix typo in characters.sql - Spotted by TuxChaz Brown
--HG-- branch : trunk
2009-04-08*Merge.megamage
--HG-- branch : trunk
2009-04-07Fix several errors in characters.sql world.sql realmd.sql and ↵Chaz Brown
world_scripts_structure.sql --HG-- branch : trunk
2009-04-07Fix typo in characters.sqlChaz Brown
--HG-- branch : trunk
2009-04-06Add missing column stackcount to full characters.sqlChaz Brown
--HG-- branch : trunk
2009-04-06Add missing column personal_rating to full characters.sqlChaz Brown
--HG-- branch : trunk
2009-03-06New AHBot plus AuctionHouse changesParadox
--HG-- branch : trunk
2009-02-28AHBot/AH changesParadox iamparadox@netscape.net
--HG-- branch : trunk
2009-02-22* Trinity sql coding style for latest filesDrahy
* Updated characters.sql up to this revision --HG-- branch : trunk
2009-02-21[7314] Not set GR_RIGHT_WITHDRAW_GOLD_LOCK flag for guild masters, remove in ↵megamage
DB. Author: Zerg2000 --HG-- branch : trunk
2009-02-21*Update characters.sql - by XlybriemBlaymoira
--HG-- branch : trunk
2009-02-20[7307] Add primary key for table `arena_team_member`. Author: VladimirMangosmegamage
--HG-- branch : trunk
2009-02-18*Merge.megamage
--HG-- branch : trunk