From be7d94f24e77d3c5e98fd8790c810bb2f95327e9 Mon Sep 17 00:00:00 2001 From: silinoron Date: Sun, 5 Sep 2010 13:12:24 -0700 Subject: 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 --- sql/updates/9784_world_command.sql | 4 ++++ sql/updates/9784_world_player_factionchange_achievement.sql | 6 ++++++ sql/updates/9784_world_player_factionchange_items.sql | 10 ++++++++++ sql/updates/9784_world_player_factionchange_reputations.sql | 6 ++++++ sql/updates/9784_world_player_factionchange_spells.sql | 6 ++++++ 5 files changed, 32 insertions(+) create mode 100644 sql/updates/9784_world_command.sql create mode 100644 sql/updates/9784_world_player_factionchange_achievement.sql create mode 100644 sql/updates/9784_world_player_factionchange_items.sql create mode 100644 sql/updates/9784_world_player_factionchange_reputations.sql create mode 100644 sql/updates/9784_world_player_factionchange_spells.sql (limited to 'sql/updates') 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; -- cgit v1.2.3