Core/BG: When starting a battleground teleport the player to start location if it goes outside of the allowed "waiting" area (for example, getting out of the "bubble" in EotS)

Allowed waiting area is calculated as the distance specified in database (battleground_template.StartMaxDist) and the battleground start point for each team
A distance of 0 is ignored (not used in SotA nor arenas)

The values in DB might need some tweaks, open a pull request if you calculate better ones

Closes #180

Initial patch and idea by Rat

Also added validation (DBError log) to some fields in battleground_template table

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/world/2012_04_13_02_world_bg_template.sql b/sql/updates/world/2012_04_13_02_world_bg_template.sql
new file mode 100644
index 00000000000..a426d7c6831
--- /dev/null
+++ b/sql/updates/world/2012_04_13_02_world_bg_template.sql
@@ -0,0 +1,7 @@
+ALTER TABLE `battleground_template` ADD `StartMaxDist` float NOT NULL DEFAULT 0 AFTER `HordeStartO`;
+
+UPDATE `battleground_template` SET `StartMaxDist`=200 WHERE `id`=30; -- IC
+UPDATE `battleground_template` SET `StartMaxDist`=100 WHERE `id`=1; -- AV
+UPDATE `battleground_template` SET `StartMaxDist`=75 WHERE `id` IN (2,3,7); -- WSG, AB, EotS
+
+UPDATE `battleground_template` SET `MinLvl`=1 WHERE `id`=32;