aboutsummaryrefslogtreecommitdiff
path: root/sql/characters.sql
AgeCommit message (Collapse)Author
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
2009-02-17Newline added to bottom of all files.KingPin
--HG-- branch : trunk
2009-02-13[7267] Drop `auctionhouse`.`location`. Author: VladimirMangosmegamage
Add a missing file. --HG-- branch : trunk
2009-02-12Fix characters.sql thanx paradoxKingPin
--HG-- branch : trunk
2009-02-10 [7255] Allows saving characters in Battle Grounds.megamage
* Now player can join to BG after logout during 5 minutes, if BG in progress. * All players after server crash or restart should appear at the battlemaster Author: GriffonHeart --HG-- branch : trunk
2009-02-10*add .debug bg to allow starting a battleground with just one player it's ↵megamage
implemented like .debug arena - so you toggle debug bg on or off By balrok --HG-- branch : trunk
2009-01-20AuctionHouseBot patch added. thanx to everyone who worked on it especially ↵KingPin
Paradox. Only apply 930_characters.sql if you dont already have AHBot installed. AHBot requires an account ID and a character ID to work with, set them in trinitycore.conf and also login atleast once to this character. --HG-- branch : trunk
2009-01-31*Update to Mangos 7208. Implement phase system.megamage
--HG-- branch : trunk
2009-01-29*Merge.megamage
--HG-- branch : trunk
2009-01-29*Update to Mangos 7200.megamage
--HG-- branch : trunk
2009-01-28Unneeded line removed from clean install .sqlpanaut0lordv
--HG-- branch : trunk