[8339] Improved storing/restoring BG entry point

    * 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

1 files changed, 23 insertions, 0 deletions

diff --git a/sql/updates/4945_mangos_8339_characters.sql b/sql/updates/4945_mangos_8339_characters.sql
new file mode 100644
index 00000000000..e21c6d3771c
--- /dev/null
+++ b/sql/updates/4945_mangos_8339_characters.sql
@@ -0,0 +1,23 @@
+ALTER TABLE characters DROP COLUMN bgid;
+ALTER TABLE characters DROP COLUMN bgteam;
+ALTER TABLE characters DROP COLUMN bgmap;
+ALTER TABLE characters DROP COLUMN bgx;
+ALTER TABLE characters DROP COLUMN bgy;
+ALTER TABLE characters DROP COLUMN bgz;
+ALTER TABLE characters DROP COLUMN bgo;
+
+DROP TABLE IF EXISTS `character_battleground_data`;
+CREATE TABLE `character_battleground_data` (
+  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+  `instance_id` int(11) unsigned NOT NULL default '0',
+  `team` int(11) unsigned NOT NULL default '0',
+  `join_x` float NOT NULL default '0',
+  `join_y` float NOT NULL default '0',
+  `join_z` float NOT NULL default '0',
+  `join_o` float NOT NULL default '0',
+  `join_map` int(11) NOT NULL default '0',
+  `taxi_start` int(11) NOT NULL default '0',
+  `taxi_end` int(11) NOT NULL default '0',
+  `mount_spell` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';