Death Gate Fix

[Ziddy1337]

I havnt seen this posted yet, but with ArcEmu the Death knight portal 'Death Gate' teleports you under the map and you fall to death's breach and die.

So here is a fixed teleport_coords. Just execute it into your database. Be sure to back up first if you have any custom teleports.

Download;

RapidShare Download

Query;

Run this query into your world database if you dont want to replace the whole table:

REPLACE INTO `teleport_coords` VALUES ('53822', 'Death Gate', '609', '2355.7', '-5662.71', '426.027', '0');

Full SQL (if you dont want to download anything):

/*
MySQL Data Transfer
Source Host: localhost
Source Database: test
Target Host: localhost
Target Database: test
Date: 1/13/2009 7:51:48 PM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for teleport_coords
-- ----------------------------
DROP TABLE IF EXISTS `teleport_coords`;
CREATE TABLE `teleport_coords` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `name` char(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mapId` int(10) unsigned NOT NULL DEFAULT '0',
  `position_x` float NOT NULL DEFAULT '0',
  `position_y` float NOT NULL DEFAULT '0',
  `position_z` float NOT NULL DEFAULT '0',
  `totrigger` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='World System';

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `teleport_coords` VALUES ('31', 'Teleport: Goldshire', '0', '-9458.81', '64.826', '55.957', '0');
INSERT INTO `teleport_coords` VALUES ('33', 'Teleport: Westfall', '530', '13005.5', '-6910.9', '9.58423', '0');
INSERT INTO `teleport_coords` VALUES ('34', 'Teleport: Duskwood', '0', '-9973.92', '-1633.17', '26.94', '0');
INSERT INTO `teleport_coords` VALUES ('35', 'Teleport: Elwynn', '0', '-9760.26', '678.23', '27.021', '0');
INSERT INTO `teleport_coords` VALUES ('427', 'Teleport: Scarlet Monastery', '0', '2889.91', '-811.148', '160.332', '0');
INSERT INTO `teleport_coords` VALUES ('428', 'Teleport: Moonbrook', '0', '-11025.2', '1497.86', '43.1953', '0');
INSERT INTO `teleport_coords` VALUES ('442', 'Teleport: Northshire Abbey', '0', '-8914.38', '-135.35', '80.45', '0');
INSERT INTO `teleport_coords` VALUES ('444', 'Teleport: Westfall Lighthouse', '0', '-11409.9', '1968.42', '10.4271', '0');
INSERT INTO `teleport_coords` VALUES ('445', 'Teleport: Darkshire', '0', '-10413.9', '-1136.88', '24.1288', '0');
INSERT INTO `teleport_coords` VALUES ('446', 'Teleport: Raven Hill Cemetary', '0', '-10531.2', '296.656', '30.9649', '0');
INSERT INTO `teleport_coords` VALUES ('1936', 'Teleport: Anvilmar', '0', '-6133.84', '383.79', '395.54', '0');
INSERT INTO `teleport_coords` VALUES ('3561', 'Teleport: Stormwind', '0', '-8913.23', '554.633', '93.7944', '0');
INSERT INTO `teleport_coords` VALUES ('3562', 'Teleport: Ironforge', '0', '-4981.25', '-881.542', '501.66', '0');
INSERT INTO `teleport_coords` VALUES ('3563', 'Teleport: Undercity', '0', '1586.48', '239.562', '-52.149', '0');
INSERT INTO `teleport_coords` VALUES ('3565', 'Teleport: Darnassus', '1', '9951.52', '2280.32', '1341.39', '0');
INSERT INTO `teleport_coords` VALUES ('3566', 'Teleport: Thunder Bluff', '1', '-1196.22', '29.0941', '176.949', '0');
INSERT INTO `teleport_coords` VALUES ('3567', 'Teleport: Orgrimmar', '1', '1676.21', '-4315.29', '61.5293', '0');
INSERT INTO `teleport_coords` VALUES ('4996', '[PH] Teleport to Orgrimmar', '1', '1676.21', '-4315.29', '61.5293', '0');
INSERT INTO `teleport_coords` VALUES ('4997', '[PH] Teleport to Booty Bay', '0', '-14284.9', '557.354', '8.841', '0');
INSERT INTO `teleport_coords` VALUES ('4998', '[PH] Teleport to Grom\'Gol', '0', '-12437.4', '212.47', '31.29', '0');
INSERT INTO `teleport_coords` VALUES ('4999', '[PH] Teleport to Ratchet', '1', '-994.248', '-3830.1', '7', '0');
INSERT INTO `teleport_coords` VALUES ('5000', '[PH] Teleport to Undercity', '0', '1586.48', '239.562', '-52.149', '0');
INSERT INTO `teleport_coords` VALUES ('6348', '[PH] Teleport to Menethil Harbor', '0', '-3774.99', '-742.22', '8.037', '0');
INSERT INTO `teleport_coords` VALUES ('6349', '[PH] Teleport to Auberdine', '1', '6498.78', '794.2', '7.89', '0');
INSERT INTO `teleport_coords` VALUES ('6483', '[PH] Teleport to Felwood', '1', '6200', '-1035', '387', '0');
INSERT INTO `teleport_coords` VALUES ('6484', '[PH] Teleport to Balthule', '1', '7245', '-652', '35', '0');
INSERT INTO `teleport_coords` VALUES ('6719', '[PH] Teleport to Theramore', '1', '-3984.52', '-4708.26', '4.367', '0');
INSERT INTO `teleport_coords` VALUES ('8735', '[PH] Teleport to Blackfathom Deeps', '1', '4127.5', '867.8', '9.69', '0');
INSERT INTO `teleport_coords` VALUES ('9268', 'Teleport to Darnassus - Event', '1', '9951.52', '2280.32', '1341.39', '0');
INSERT INTO `teleport_coords` VALUES ('11362', 'Teleport to Gnomeregan', '0', '-5183.1', '602.77', '409.11', '0');
INSERT INTO `teleport_coords` VALUES ('11409', 'Teleport to Booty Bay', '0', '-14319.3', '442.7', '22.94', '0');
INSERT INTO `teleport_coords` VALUES ('12510', 'Teleport to Azshara Tower', '1', '3778.6', '-4612.2', '227.254', '0');
INSERT INTO `teleport_coords` VALUES ('12520', 'Teleport from Azshara Tower', '1', '3648', '-4702', '122', '0');
INSERT INTO `teleport_coords` VALUES ('12885', 'Teleport to Razelikh', '0', '-11235', '-2834', '158', '0');
INSERT INTO `teleport_coords` VALUES ('13044', 'Teleport to Ground', '0', '-11072', '-2859', '11', '0');
INSERT INTO `teleport_coords` VALUES ('13142', 'Teleport to Razelikh', '0', '-11235', '-2834', '158', '0');
INSERT INTO `teleport_coords` VALUES ('17334', 'Portal Effect: Stormwind', '0', '-8913.23', '554.633', '93.7944', '0');
INSERT INTO `teleport_coords` VALUES ('17607', 'Portal Effect: Ironforge', '0', '-4981.25', '-881.542', '501.66', '0');
INSERT INTO `teleport_coords` VALUES ('17608', 'Portal Effect: Darnassus', '1', '9951.52', '2280.32', '1341.39', '0');
INSERT INTO `teleport_coords` VALUES ('17609', 'Portal Effect: Orgrimmar', '1', '1676.21', '-4315.29', '61.5293', '0');
INSERT INTO `teleport_coords` VALUES ('17610', 'Portal Effect: Thunder Bluff', '1', '-1196.22', '29.0941', '176.949', '0');
INSERT INTO `teleport_coords` VALUES ('17611', 'Portal Effect: Undercity', '0', '1586.48', '239.562', '-52.149', '0');
INSERT INTO `teleport_coords` VALUES ('18960', 'Teleport: Moonglade', '1', '7979', '-2500', '489', '0');
INSERT INTO `teleport_coords` VALUES ('21128', 'Portal Effect: Maraudon', '349', '428', '15', '-112', '0');
INSERT INTO `teleport_coords` VALUES ('23442', 'teleport trinket everlook', '1', '6721.44', '-4659.09', '720.893', '0');
INSERT INTO `teleport_coords` VALUES ('23453', 'teleport trinket Gadgetzan', '1', '-7124.13', '-3818.93', '8.4107', '0');
INSERT INTO `teleport_coords` VALUES ('25649', 'duskwitherspiretop', '530', '9338.34', '-7809.24', '136.568', '0');
INSERT INTO `teleport_coords` VALUES ('26566', 'duskwitherspirebottom', '530', '9334.35', '-7880.74', '74.91', '0');
INSERT INTO `teleport_coords` VALUES ('26572', 'FirewingUp', '530', '-2263.21', '3112.64', '136.349', '0');
INSERT INTO `teleport_coords` VALUES ('28147', 'AtieshPorttoKara', '0', '-11112.9', '-2005.89', '49.3307', '0');
INSERT INTO `teleport_coords` VALUES ('30141', 'FirewingUp2', '530', '-2260.33', '3211.06', '14.1116', '0');
INSERT INTO `teleport_coords` VALUES ('32268', 'Exodar', '530', '-3987.29', '-11846.6', '-2.01903', '0');
INSERT INTO `teleport_coords` VALUES ('32270', 'Silvermoon', '530', '9473.03', '-7279.67', '14.2285', '0');
INSERT INTO `teleport_coords` VALUES ('32271', 'Exodar', '530', '-3987.29', '-11846.6', '-2.01903', '0');
INSERT INTO `teleport_coords` VALUES ('32272', 'Silvermoon', '530', '9473.03', '-7279.67', '14.2285', '0');
INSERT INTO `teleport_coords` VALUES ('32568', 'FirewingDown', '530', '-2259.65', '3114.53', '25.017', '0');
INSERT INTO `teleport_coords` VALUES ('32569', 'FalconTowerUpper', '530', '-588.9', '4070.8', '93.8', '0');
INSERT INTO `teleport_coords` VALUES ('32571', 'FalconTowerLower', '530', '-592.2', '4070.2', '143.3', '0');
INSERT INTO `teleport_coords` VALUES ('32572', 'OrbOfTransLocSILVM', '0', '1805.82', '334.01', '70.3975', '0');
INSERT INTO `teleport_coords` VALUES ('33690', 'Teleport to Shattarah', '530', '-1863.03', '4998.05', '-21.1847', '0');
INSERT INTO `teleport_coords` VALUES ('33691', 'Portal Effect: Shattarah', '530', '-1863.03', '4998.05', '-21.1847', '0');
INSERT INTO `teleport_coords` VALUES ('33728', 'Shattrath', '530', '-1863.03', '4998.05', '-21.1847', '0');
INSERT INTO `teleport_coords` VALUES ('35715', 'Shattrath', '530', '-1863.03', '4998.05', '-21.1847', '0');
INSERT INTO `teleport_coords` VALUES ('35717', 'Portal Effect: Shattarah', '530', '-1863.03', '4998.05', '-21.1847', '0');
INSERT INTO `teleport_coords` VALUES ('35718', 'Shattrath', '530', '-1863.03', '4998.05', '-21.1847', '0');
INSERT INTO `teleport_coords` VALUES ('35730', 'OrbOfTransLocUC', '530', '10021.3', '-7014.89', '49.7177', '0');
INSERT INTO `teleport_coords` VALUES ('36890', 'teleport trinket area 52', '530', '3049.15', '3686.12', '142.387', '0');
INSERT INTO `teleport_coords` VALUES ('36941', 'teleport trinket Toshley\'s Station', '530', '1907.43', '5562.55', '262.439', '0');
INSERT INTO `teleport_coords` VALUES ('37778', 'Quest - Teleport: Caverns of Time', '1', '-8169.37', '-4763.09', '33.6819', '0');
INSERT INTO `teleport_coords` VALUES ('44089', 'Portal Effect: Ironforge', '0', '-4981.25', '-881.542', '501.66', '0');
INSERT INTO `teleport_coords` VALUES ('44870', 'Portal Effect: Sunwell Isle', '530', '13005.5', '-6910.9', '9.58423', '0');
INSERT INTO `teleport_coords` VALUES ('45038', 'Legion Teleporter', '530', '894.396', '2557.13', '298.968', '0');
INSERT INTO `teleport_coords` VALUES ('45368', 'SunsReachUp', '530', '12791.6', '-6891.95', '31.1053', '0');
INSERT INTO `teleport_coords` VALUES ('45371', 'SunsReachDown', '530', '12782.5', '-6879.06', '23.0944', '0');
INSERT INTO `teleport_coords` VALUES ('49358', 'Teleport: Stonard', '0', '-10435.9', '-3260.51', '20.1786', '0');
INSERT INTO `teleport_coords` VALUES ('49363', 'Portal Effect: Stonard', '0', '-10435.9', '-3260.51', '20.1786', '0');
INSERT INTO `teleport_coords` VALUES ('49359', 'Teleport: Theramore', '1', '-3678.44', '-4522.46', '10.2432', '0');
INSERT INTO `teleport_coords` VALUES ('49362', 'Portal Effect: Theramore', '1', '-3678.44', '-4522.46', '10.2432', '0');
INSERT INTO `teleport_coords` VALUES ('53822', 'Death Gate', '609', '2355.7', '-5662.71', '426.027', '0');

(Please don't flame if your database doesnt have this problem. Most of the ones i have tried, including the latest repacks have this problem)

[keazain]

this looks very nice, +rep for that one

[bigjohnson4]

You shouldn't just dump the whole table and release it. People who have edited their teleport_coords table for custom teleports will lose their edits and will have to start over again, if they don't look at the query first.

[Ziddy1337]

You shouldn't just dump the whole table and release it. People who have edited their teleport_coords table for custom teleports will lose their edits and will have to start over again, if they don't look at the query first.

Be sure to back up first if you have any custom teleports.

I hate to quote myself, btw.

[Zolar1]

just run this to fix death gate only

REPLACE INTO teleport_coords values (53822, 'Death Gate', 0, 2359.64, -5662.41, 383.017, 0)

and
=rep Ziddy for the contribution

[Ziddy1337]

just run this to fix death gate only

REPLACE INTO teleport_coords values (53822, 'Death Gate', 0, 2359.64, -5662.41, 383.017, 0)

and
=rep Ziddy for the contribution

That isnt right. The map id is 609 and some of the other numbers are incorrect too. In fact, i think that is the exact gps that creates you to spawn under the map.

I will add the single sql to my post though for those who dont want to replace the whole thing.

[Zolar1]

sorry bout that Im using ncdb47 and this fix works the numbers are from the table in the database the only change made is coords to put you above floor instead of below it

[slate1337]

This works, thanks

[Ziddy1337]

This works, thanks

You're very welcome.

[Appled]

Great fix for people who don't got yet this as fixed +Rep

[volitle]

ahh nice fix ziddy +rep if i can

[svedin]

Nice work.

+Rep when i can.