diff options
| author | silinoron <none@none> | 2010-09-05 13:12:24 -0700 |
|---|---|---|
| committer | silinoron <none@none> | 2010-09-05 13:12:24 -0700 |
| commit | be7d94f24e77d3c5e98fd8790c810bb2f95327e9 (patch) | |
| tree | 21916cced4665501c3d2bdcdddeca91c15dbacfe /sql/updates | |
| parent | de59ac3bc36ebdd9cd87f6f12d640f5fc12ded5e (diff) | |
Add support for character race and faction transfers.
Based (loosely) on patch by Ner'zhul, DarkXuan, and darkshines@sakha.net.
Fixes issue #3429.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
5 files changed, 32 insertions, 0 deletions
diff --git a/sql/updates/9784_world_command.sql b/sql/updates/9784_world_command.sql new file mode 100644 index 00000000000..94fee31f4f4 --- /dev/null +++ b/sql/updates/9784_world_command.sql @@ -0,0 +1,4 @@ +DELETE FROM `command` WHERE `name` IN ('character changefaction','character changerace'); +INSERT INTO `command` VALUES +('character changefaction',2,'Syntax: .character changefaction $name\r\n\r\nChange character faction.'), +('character changerace',2,'Syntax: .character changerace $name\r\n\r\nChange character race.'); diff --git a/sql/updates/9784_world_player_factionchange_achievement.sql b/sql/updates/9784_world_player_factionchange_achievement.sql new file mode 100644 index 00000000000..c1cce249b1b --- /dev/null +++ b/sql/updates/9784_world_player_factionchange_achievement.sql @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS `player_factionchange_achievement`; +CREATE TABLE `player_factionchange_achievement` ( + `alliance_id` int(8) NOT NULL, + `horde_id` int(8) NOT NULL, + PRIMARY KEY (`alliance_id`,`horde_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; diff --git a/sql/updates/9784_world_player_factionchange_items.sql b/sql/updates/9784_world_player_factionchange_items.sql new file mode 100644 index 00000000000..8cb815849f2 --- /dev/null +++ b/sql/updates/9784_world_player_factionchange_items.sql @@ -0,0 +1,10 @@ +DROP TABLE IF EXISTS `player_factionchange_items`; +CREATE TABLE `player_factionchange_items` ( + `race_A` int(8) NOT NULL, + `alliance_id` int(8) NOT NULL, + `commentA` text, + `race_H` int(8) NOT NULL, + `horde_id` int(8) NOT NULL, + `commentH` text, +PRIMARY KEY (`alliance_id`,`horde_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; diff --git a/sql/updates/9784_world_player_factionchange_reputations.sql b/sql/updates/9784_world_player_factionchange_reputations.sql new file mode 100644 index 00000000000..2dd02b29727 --- /dev/null +++ b/sql/updates/9784_world_player_factionchange_reputations.sql @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS `player_factionchange_reputations`; +CREATE TABLE `player_factionchange_reputations` ( + `alliance_id` int(8) NOT NULL, + `horde_id` int(8) NOT NULL, + PRIMARY KEY (`alliance_id`,`horde_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; diff --git a/sql/updates/9784_world_player_factionchange_spells.sql b/sql/updates/9784_world_player_factionchange_spells.sql new file mode 100644 index 00000000000..83879ede5ac --- /dev/null +++ b/sql/updates/9784_world_player_factionchange_spells.sql @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS `player_factionchange_spells`; +CREATE TABLE `player_factionchange_spells` ( + `alliance_id` int(8) NOT NULL, + `horde_id` int(8) NOT NULL, + PRIMARY KEY (`alliance_id`,`horde_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; |