teleporter

/* Teleporter NPC */DELETE FROM `creature_template` where `entry` = ('90000');insert  into `creature_template`(`entry`,`difficulty_entry_1`,`difficulty_entry_2`,`difficulty_entry_3`,`KillCredit1`,`KillCredit2`,`modelid_A`,`modelid_A2`,`modelid_H`,`modelid_H2`,`name`,`subname`,`IconName`,`gossip_menu_id`,`minlevel`,`maxlevel`,`minhealth`,`maxhealth`,`minmana`,`maxmana`,`armor`,`faction_A`,`faction_H`,`npcflag`,`speed`,`scale`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`dmg_multiplier`,`baseattacktime`,`rangeattacktime`,`unit_class`,`unit_flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`trainer_class`,`trainer_race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`unk16`,`unk17`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`questItem5`,`questItem6`,`movementId`,`RegenHealth`,`equipment_id`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`) values(90000,0,0,0,0,0,22719,22719,22719,22719,'B16 Flying Machine','Gadgetzan Taxi',NULL,0,80,80,25000,25000,0,0,10000,35,35,1,1,1.5,1,2750,2750,0,250,1,1000,0,0,0,0,0,0,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,1,1,0,0,0,0,0,0,0,0,1,0,0,0,'telenpc');/* Spawns */DELETE FROM `creature` where `id` = ('90000');INSERT INTO `creature`(`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`)values(250000,90000,0,1,1,7061,0,-4902.14,-970.169,501.445,2.26234,25,0,0,25000,0,0,0),(250001,90000,530,1,1,7061,0,-1861.74,5441.7,-10.4638,4.61735,25,0,0,25000,0,0,0),(250002,90000,530,1,1,0,0,9356.65,-7280.5,14.2403,2.58004,25,0,0,25000,0,0,0),(250003,90000,0,1,1,7061,0,1813.53,238.539,60.4944,0.102097,25,0,0,25000,0,0,0),(250004,90000,1,1,1,7061,0,-1291.55,136.649,131.106,1.20406,25,0,0,25000,0,0,0),(250005,90000,1,1,1,7061,0,1579.17,-4417.39,7.84218,3.48717,25,0,0,25000,0,0,0),(250006,90000,0,1,1,0,0,-14340.5,599.961,107.723,1.55066,25,0,0,25000,0,0,0),(250007,90000,0,1,1,0,0,-14406.8,571.105,146.991,5.74003,25,0,0,25000,0,0,0),(250008,90000,0,1,1,0,0,-8956.44,511.693,96.5971,3.66388,25,0,0,25000,0,0,0),(250009,90000,1,1,1,0,0,9944.91,2495.33,1317.56,4.4375,25,0,0,25000,0,0,0),(250010,90000,530,1,1,7061,0,-3950.83,-11657.8,-138.657,2.43866,25,0,0,25000,0,0,0),(250011,90000,571,1,1,0,0,5818.81,641.09,647.81,3.20,25,0,0,25000,0,0,0),(250012,90000,0,1,1,0,0,-14324.1,600.97,101.6,6.18,25,0,0,25000,0,0,0),(250013,90000,0,1,1,0,0,-14439.5,477.37,15.26,3.8,25,0,0,25000,0,0,0),(250014,90000,1,1,1,0,0,6731.21,-4624.68,721.39,3.06,25,0,0,25000,0,0,0),(250015,90000,1,1,1,0,0,-4575.25,-3178.3,34.29,1.46,25,0,0,25000,0,0,0),(250016,90000,1,1,1,0,0,-7169.4,-3786.68,8.42,2.93,25,0,0,25000,0,0,0);/*Tábla struktúra */DROP TABLE IF EXISTS `telenet`;CREATE TABLE `telenet` (  `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID Number for the entry',  `MapID` int(11) NOT NULL DEFAULT '0' COMMENT 'Map ID number - See MaNGOS DB',  `Region` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name of the region in which this location resides: Kalimdor, Eastern Kingdoms, Outland, Northrend',  `Name` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name of Tele Location',  `Xpos` float NOT NULL DEFAULT '0' COMMENT 'X Position',  `Ypos` float NOT NULL DEFAULT '0' COMMENT 'Y Position',  `Zpos` float NOT NULL DEFAULT '0' COMMENT 'Z Position',  `Rpos` float NOT NULL DEFAULT '0' COMMENT 'Rotation',  `Cost` int(11) NOT NULL DEFAULT '0' COMMENT 'Cost (in COPPER) to teleport here from ANY given location',  `ReqLevel` int(11) NOT NULL DEFAULT '0' COMMENT 'Required level in order to display this location as an option',  `Faction` int(1) NOT NULL DEFAULT '0' COMMENT 'Required faction in order to display this location as an option. 0=Neutral, 1=Alliance, 2=Horde',  `GuildID` int(11) NOT NULL DEFAULT '0' COMMENT 'ID Number of the guild to use this teleport location',  PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=latin1;/* A TeleNet Tábla adatai */insert  into `telenet`(`ID`,`MapID`,`Region`,`Name`,`Xpos`,`Ypos`,`Zpos`,`Rpos`,`Cost`,`ReqLevel`,`Faction`,`GuildID`) values (1,1,'City','Darnassus',9952.01,2272.98,1341.4,1.62,10000,0,1,0),(2,530,'City','The Exodar',-3990.47,-11851.8,0.37,1.15,10000,0,1,0),(3,0,'City','Ironforge',-4905.64,-879.78,501.66,5.05,10000,0,1,0),(4,0,'City','Stormwind',-8967.16,510.7,96.35,0.67,10000,0,1,0),(5,1,'City','Orgrimmar',1478.67,-4413.9,25.58,6.28,10000,0,2,0),(6,530,'City','Silvermoon City',9462.82,-7277.27,14.17,6.2,10000,0,2,0),(7,1,'City','Thunder Bluff',-1296.38,146.48,130,5.48,10000,0,2,0),(8,0,'City','Undercity',1847.98,237.76,62.28,3.14,10000,0,2,0),(9,530,'City','Shattrath City',-1948.2,5178.62,17.06,1.27,55000,55,0,0),(10,0,'City','Booty Bay',-14290.9,431.69,32.72,2.73,40000,40,0,0),(11,1,'City','Gadgetzan',-7093.16,-3798.6,8.4,2.86,40000,40,0,0),(12,1,'City','Everlook',6725.25,-4615.66,721.47,4.75,50000,50,0,0),(13,1,'City','Mudsprocket',-4566.82,-3172.71,33.98,3.19,45000,45,0,0),(14,571,'City','Dalaran',5804.77,616.79,650.83,1.62,65000,65,0,0),(15,1,'Kalimdor','Blackfathom Deeps',4249.99,739.21,-25.81,1.55,13000,13,0,0),(16,1,'Kalimdor','Caverns of Time',-8186.48,-4697.14,17.34,4.96,69000,69,0,0),(17,1,'Kalimdor','Dire Maul',-3971.58,1126.19,161.03,6.27,48000,48,0,0),(18,1,'Kalimdor','Maraudon',-1421.92,2911.93,137.07,1.68,38000,38,0,0),(19,1,'Kalimdor','Onyxia\'s Lair',-4707.89,-3727.79,54.59,3.74,53000,53,0,0),(20,1,'Kalimdor','Ragefire Chasm',1813.51,-4413.83,-18.02,5.18,11000,11,0,0),(21,1,'Kalimdor','Razorfen Downs',-4657.19,-2522.81,81.22,4.21,28000,28,0,0),(22,1,'Kalimdor','Rzaorfen Kraul',-4467.48,-1669.83,81.89,0.91,18000,18,0,0),(23,1,'Kalimdor','Ruins of Ahn\'Qiraj',-8411.11,1499.72,28.37,2.57,63000,63,0,0),(24,1,'Kalimdor','Temple of Ahn\'Qiraj',-8239.92,1990.75,129.08,0.97,63000,63,0,0),(25,1,'Kalimdor','Wailing Caverns',-735.41,-2217.29,16.99,2.83,13000,13,0,0),(26,1,'Kalimdor','Zul\'Farrak',-6797.28,-2890.91,8.88,0.06,38000,38,0,0),(27,0,'Eastern Kingdoms','Blackrock Depths',-7179.03,-922.93,166.27,4.88,43000,43,0,0),(28,0,'Eastern Kingdoms','Blackrock Spire',-7525.72,-1227.68,285.73,5.24,48000,48,0,0),(29,229,'Eastern Kingdoms','Blackwing Lair',173.98,-474.59,116.84,0.03,62000,62,0,0),(30,0,'Eastern Kingdoms','Deadmines',-11208.1,1676.37,24.57,1.56,13000,13,0,0),(31,0,'Eastern Kingdoms','Gnomeregan',-5163.54,925.42,257.18,1.57,18000,18,0,0),(32,530,'Eastern Kingdoms','Isle of Quel\'Danas',12991.9,-6899.54,8.08,3.05,68000,68,0,0),(33,0,'Eastern Kingdoms','Karazhan',-11115.4,-2007.85,48.56,0.66,71000,71,0,0),(34,230,'Eastern Kingdoms','Molten Core',1127.57,-459.66,-102.58,3.39,53000,53,0,0),(35,0,'Eastern Kingdoms','Scarlet Monastery',2870.85,-758.87,160.33,5.07,23000,23,0,0),(36,0,'Eastern Kingdoms','Scholomance',1273.3,-2554.14,91.21,0.52,48000,48,0,0),(37,0,'Eastern Kingdoms','Shadowfang Keep',-234.24,1564.18,76.89,1.21,13000,13,0,0),(38,0,'Eastern Kingdoms','Stratholme',3354.44,-3379.07,144.78,6.26,48000,48,0,0),(39,0,'Eastern Kingdoms','Sunken Temple',-10177.2,-3994.64,-111.56,6.03,38000,38,0,0),(40,0,'Eastern Kingdoms','The Stockade',-8766.08,845.33,88.03,0.72,18000,18,0,0),(41,0,'Eastern Kingdoms','Uldaman',-6071.37,-2955.16,209.85,0.01,33000,33,0,0),(42,530,'Eastern Kingdoms','Zul\'Aman',6852.16,-7979.12,183.23,4.7,71000,71,0,0),(43,0,'Eastern Kingdoms','Zul\'Gurub',-11916,-1217.09,92.29,4.68,53000,53,0,0),(44,530,'Outland','Auchinhoun',-3323.51,4930.57,-100.54,1.91,58000,58,0,0),(45,530,'Outland','Black Temple',-3559.99,648.61,1.88,4.78,73000,73,0,0),(46,530,'Outland','Coilfang Reservoir',719.78,6845.03,-68.99,0.01,58000,58,0,0),(47,530,'Outland','Gruul\'s Lair',3540.32,5096.26,4.24,5.64,68000,68,0,0),(48,530,'Outland','Hellfire Citadel',-272.25,3115.93,31.31,2.16,58000,58,0,0),(49,530,'Outland','Tempest Keep',3100.46,1536.88,190.31,4.65,71000,71,0,0),(50,571,'Northrend','Ahn\'Kahet',3643.21,2036.78,1.79,4.39,71000,71,0,0),(51,571,'Northrend','Azjol-Nerub',3694.09,2147.85,34.89,2.34,70000,70,0,0),(52,571,'Northrend','Drak\'Tharon Keep',4774.22,-2026.64,229.37,1.54,72000,72,0,0),(53,571,'Northrend','Gun\'Drak',6784.42,-4466.53,440.86,5.39,74000,74,0,0),(54,571,'Northrend','Icecrown Citadel',5918.44,2130.66,636.04,3.59,80000,80,0,0),(55,571,'Northrend','Naxxramas',3664.79,-1269.44,243.52,0.67,80000,80,0,0),(56,571,'Northrend','The Nexus',3881.92,6984.98,73.76,0.05,69000,69,0,0),(57,571,'Northrend','The Obsidian Sanctum',3540.02,272.85,45.61,0.06,80000,80,0,0),(58,571,'Northrend','Ulduar',9014.24,-1110.06,1165.28,6.28,68000,68,0,0),(59,571,'Northrend','Utgarde Keep',1222.02,-4864.44,41.25,0.35,78000,78,0,0),(60,571,'Northrend','Utgarde Pinnacle',1243.13,-4857.67,217.65,3.43,80000,80,0,0),(61,571,'Northrend','Violet Hold',5732.18,548.03,652.68,3.96,70000,70,0,0);