From da52c8d54ec341cc55f963fe0397fcc5e98b06e9 Mon Sep 17 00:00:00 2001 From: Intel Date: Wed, 12 Nov 2014 03:58:17 +0200 Subject: Core/Talents: Fixed SMSG_TALENTS_INFO packet Fixed talents saving to DB Renamed 'talent spec' to 'talent group' since this name was shadowing character specializations (and new name is correct according to JAM) Enabled loading of MinorTalent.dbc (will be used later) Added additional specialization check in LearnTalent --- sql/base/characters_database.sql | 12 ++++++------ sql/updates/characters/2014_11_12_00_characters.sql | 4 ++++ 2 files changed, 10 insertions(+), 6 deletions(-) create mode 100644 sql/updates/characters/2014_11_12_00_characters.sql (limited to 'sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 30934a4a81f..29f14fa7b39 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -763,7 +763,7 @@ DROP TABLE IF EXISTS `character_glyphs`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_glyphs` ( `guid` bigint(20) unsigned NOT NULL, - `spec` tinyint(3) unsigned NOT NULL DEFAULT '0', + `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', `glyph1` smallint(5) unsigned DEFAULT '0', `glyph2` smallint(5) unsigned DEFAULT '0', `glyph3` smallint(5) unsigned DEFAULT '0', @@ -773,7 +773,7 @@ CREATE TABLE `character_glyphs` ( `glyph7` smallint(5) unsigned DEFAULT '0', `glyph8` smallint(5) unsigned DEFAULT '0', `glyph9` smallint(5) unsigned DEFAULT '0', - PRIMARY KEY (`guid`,`spec`) + PRIMARY KEY (`guid`,`talentGroup`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1276,8 +1276,8 @@ DROP TABLE IF EXISTS `character_talent`; CREATE TABLE `character_talent` ( `guid` bigint(20) unsigned NOT NULL, `spell` mediumint(8) unsigned NOT NULL, - `spec` tinyint(3) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`guid`,`spell`,`spec`) + `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`,`spell`,`talentGroup`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1383,8 +1383,8 @@ CREATE TABLE `characters` ( `power4` int(10) unsigned NOT NULL DEFAULT '0', `power5` int(10) unsigned NOT NULL DEFAULT '0', `latency` mediumint(8) unsigned NOT NULL DEFAULT '0', - `speccount` tinyint(3) unsigned NOT NULL DEFAULT '1', - `activespec` tinyint(3) unsigned NOT NULL DEFAULT '0', + `talentGroupsCount` tinyint(3) unsigned NOT NULL DEFAULT '1', + `activeTalentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', `exploredZones` longtext, `equipmentCache` longtext, `knownTitles` longtext, diff --git a/sql/updates/characters/2014_11_12_00_characters.sql b/sql/updates/characters/2014_11_12_00_characters.sql new file mode 100644 index 00000000000..68aaf99d5d0 --- /dev/null +++ b/sql/updates/characters/2014_11_12_00_characters.sql @@ -0,0 +1,4 @@ +ALTER TABLE `character_glyphs` CHANGE `spec` `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `character_talent` CHANGE `spec` `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `characters` CHANGE `speccount` `talentGroupsCount` tinyint(3) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `characters` CHANGE `activespec` `activeTalentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0'; -- cgit v1.2.3