Создания Sql Запроса Для Телепорта

[werty 1]

Парни подскажите как создать sql запрос для Тп.Хочу зделать чтоб можно было на дино тп делать,зборка l2j-frozen,скиньте образец как ёво писать.

Изменено 10 ноября, 2013 пользователем werty

[rooti 764]

Таблица teleport, смотри примеры там.

или скинь teleport.sql, объясню что к чему

Изменено 10 ноября, 2013 пользователем rooti

[werty 1]

Тебе всю таблицу кидать ?)

[werty 1]

Вот вся таблица

--

-- Table structure for table `teleport`

--

DROP TABLE IF EXISTS teleport;

CREATE TABLE teleport (

Description varchar(75) default NULL,

id decimal(11,0) NOT NULL default '0',

loc_x decimal(9,0) default NULL,

loc_y decimal(9,0) default NULL,

loc_z decimal(9,0) default NULL,

price decimal(6,0) default NULL,

fornoble int(1) NOT NULL default '0',

PRIMARY KEY (id)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

--

-- Dumping data for table `teleport`

--

 

INSERT INTO teleport VALUES

('Dark Elven Town -> Town of Gludio',1,-12672,122776,-3116,10000,0),

('Elven Town -> Town of Gludio',2,-12672,122776,-3116,9200,0),

('Elven Village -> Elven Forest',468,21362,51122,-3688,710,0),

('Elven Village -> Neutral Zone',469,-10674,75550,-3597,740,0),

('Elven Village -> Elven Fortress',470,29294,74968,-3776,820,0),

('Town of Gludio -> Elven village',3,46934,51467,-2977,9200,0),

('Town of Gludio -> Dark Elven village',4,9745,15606,-4574,10000,0),

('Town of Gludio -> Village of Gludin',5,-80826,149775,-3043,7300,0),

('Town of Gludio -> Dion',6,15670,142983,-2705,3400,0),

('Village of Gludin -> Orc village',7,-44836,-112524,-235,26000,0),

('Village of Gludin -> Dwarven village',8,115113,-178212,-901,38000,0),

('Village of Gludin -> TI',9,-84318,244579,-3730,9400,0),

('Village of Gludin -> Elven Village',10,46934,51467,-2977,16000,0),

('Village of Gludin -> Dark Elven Village',11,9745,15606,-4574,16000,0),

('Village of Gludin -> Town of Gludio',12,-12672,122776,-3116,7300,0),

('Village of Gludin -> Southern entrance of wastelands',13,-16730,209417,-3664,3400,0),

('Dark Elven Town -> Southern part of dark elven forest',14,-61095,75104,-3356,1100,0),

('DE Village -> Dark Forest',464,-22224,14168,-3232,890,0),

('DE Village -> Spider Nest',465,-56532,78321,-2960,3600,0),

('DE Village -> Swampland',466,-30777,49750,-3552,1100,0),

('DE Village -> Neutral Zone',467,-23520,68688,-3640,1700,0),

('TI -> Village of Gludin',15,-80826,149775,-3043,18000,0),

('TI -> Obelisk of Victory',1001,-99678,237562,-3567,470,0),

('TI -> Western Territory',1002,-101294,212553,-3093,1000,0),

('TI -> Elven Ruins',1003,-113329,235327,-3653,830,0),

('TI -> Singing Waterfall',1004,-107456,242669,-3493,770,0),

('Dwarf Town -> Town of Gludio',16,-12672,122776,-3116,32000,0),

('Dwarf Town -> The Northeast Coast',17,169008,-208272,-3504,2400,0),

('Dwarven Town -> Abandoned Coal Mines',418,139714,-177456,-1536,690,0),

('Dwarven Town -> Mithril Mines',419,171946,-173352,3448,2200,0),

('Dion Town -> Town of Gludio',18,-12672,122776,-3116,3400,0),

('Dion Town -> Town of Giran',19,83400,147943,-3404,6800,0),

('Dion Town -> Giran Harbor',20,47942,186764,-3485,6500,0),

('Cruma Tower Entrance -> Cruma Tower 1st floor',21,17724,114004,-11672,0,0),

('Cruma Tower 1st floor -> Cruma Tower Entrance',22,17192,114178,-3439,0,0),

('Cruma Tower 1st floor -> Cruma Tower 2nd floor',23,17730,108301,-9057,0,0),

('Cruma Tower 2nd floor -> Cruma Tower 1st floor',24,17714,107923,-11850,0,0),

('Town of Giran -> Dion Town',25,15670,142983,-2705,6800,0),

('Town of Giran -> Oren Town',26,82956,53162,-1495,9400,0),

('Town of Giran -> Hunter Village',27,116819,76994,-2714,4100,0),

('Town of Giran -> Hardin\'s Private Academy',28,105918,109759,-3207,4400,0),

('Talking Island -> Obelisk of Victory',460,-99843,237583,-3568,200,0),

('Talking Island -> Western Territory of Talking Island (Northern Area)',461,-102850,215932,-3424,3000,0),

('Talking Island -> Elven Ruins',462,49315,248452,-5960,2500,0),

('Talking Island -> Singing Waterfall',463,-113686,235723,-3640,2300,0),

('TI Dungeon inside -> outside',29,-113329,235327,-3653,0,0),

('TI Dungeon outside -> inside',30,48736,248463,-6162,0,0),

('Ivory Tower Basement',31,84915,15969,-4294,0,0),

('Ivory Tower Ground Floor',32,85399,16197,-3679,0,0),

('Ivory Tower 1st Floor',33,85399,16197,-2809,0,0),

('Ivory Tower 2nd Floor',34,85399,16197,-2293,0,0),

('Ivory Tower 3th Floor',35,85399,16197,-1776,0,0),

('Ivory Tower Ground Floor -> Oren Castle Town',36,82956,53162,-1495,3700,0),

('Ivory Tower Ground Floor -> Hunter\'s Village',37,116819,76994,-2714,6800,0),

('Ivory Tower Ground Floor -> Aden Castle Town',38,146331,25762,-2018,6200,0),

('Aden Town -> Ivory Tower',39,85348,16142,-3699,12000,0),

('Aden Town -> Oren Town',40,82956,53162,-1495,6900,0),

('Aden Town -> Hunter\'s Village',41,116819,76994,-2714,5900,0),

('Hunter\'s Village -> Giran Town',42,83400,147943,-3404,9400,0),

('Hunter\'s Village -> Oren Town',43,82956,53162,-1495,4100,0),

('Hunter\'s Village -> Ivory Tower',44,85348,16142,-3699,8200,0),

('Hunter\'s Village -> Hardin\'s Private Academy',45,105918,109759,-3207,3400,0),

('Hunter\'s Village -> Aden Town',46,146331,25762,-2018,5900,0),

('Oren Town -> Giran Town',47,83400,147943,-3404,9400,0),

('Oren Town -> Ivory Tower',48,85348,16142,-3699,3700,0),

('Oren Town -> Hunter\'s Village',49,116819,76994,-2714,4100,0),

('Oren Town -> Hardin\'s Private Academy',50,105918,109759,-3207,6100,0),

('Oren Town -> Aden Town',51,146331,25762,-2018,6900,0),

('Hardin\'s Private Academy -> Giran Town',52,83400,147943,-3404,4400,0),

('Hardin\'s Private Academy -> Oren Town',53,82956,53162,-1495,6100,0),

('Hardin\'s Private Academy -> Hunter\'s Village',54,116819,76994,-2714,3400,0),

('Cruma level 2 -> Cruma level 3',55,17719,115590,-6584,0,0),

('Cruma level 3 -> Cruma Core',56,17691,111726,-6583,0,0),

('Cruma core -> Cruma level 3',57,17719,115590,-6584,0,0),

('Cruma Tower 3rd floor -> Cruma Tower 2nd Floor',58,17731,119465,-9067,0,0),

('Heine -> The Town of Giran',59,83400,147943,-3404,7600,0),

('Heine -> Giran Harbor',60,47942,186764,-3485,7100,0),

('Antharas Nest - > Giran castle town',62,83400,147943,-3404,0,0),

('Giran Harbor -> Giran Town',63,83400,147943,-3404,6300,0),

('Giran Harbor -> Dion Town',64,15670,142983,-2705,6500,0),

('Giran Harbor -> Heine',107,111409,219364,-3545,8500,0),

('Heine -> The Town of Dion',65,15670,142983,-2705,12000,0),

('Heine -> Field of Silence',66,82684,183551,-3597,2500,0),

('Heine -> Field of Whispers',67,91186,217104,-3649,2300,0),

('Heine -> Entrance to Alligator Islands',68,126450,174774,-3079,2100,0),

('Giran -> Dragon Valley',69,73024,118485,-3688,1800,0),

('Giran -> Heine',70,111409,219364,-3545,7600,0),

('Monster Derby Track',75,12661,181687,-3560,0,0),

('Aden -> Coliseum',76,146440,46723,-3432,2000,0),

('Aden -> Blazing Swamp',81,155316,-16341,-3312,6800,0),

('Aden -> The Forbidden Gateway',82,185319,20218,-3264,1400,0),

('Aden -> The Front of Anghell Waterfall',83,163341,91374,-3320,2400,0),

('Aden -> Forsaken Plains',84,167285,37109,-4008,1900,0),

('Dion -> Heine',85,111409,219364,-3545,12000,0),

('Dion -> Partisan Hideaway',86,46467,126885,-3720,1700,0),

('Dion -> Bee Hive',87,20505,189036,-3344,2900,0),

('Gludio -> Windawood Manor',88,-23789,169683,-3424,1400,0),

('Gludio -> Southern Pathway to the Wasteland',89,-16730,209417,-3664,2400,0),

('Gludin -> Abandoned Camp',90,-46932,140883,-2936,1200,0),

('Gludin -> Fellmere Harvest Grounds',91,-70387,115501,-3472,1400,0),

('Gludin -> Langk Lizardman Dwelling',92,-45210,202654,-3592,1800,0),

('Orc Village -> Immortal Plateau,Northern Region',93,-8804,-114748,-3088,960,0),

('Orc Village -> Immortal Plateau,Southern Region',94,-17870,-90980,-2528,2000,0),

('Orc Village -> Immortal Plateau,Southeast Region',95,8209,-93524,-2312,750,0),

('Orc Village -> Frozen Waterfall',96,7603,-138871,-920,1600,0),

('Orc Village -> Entrance to the Cave of Trials',471,9340,-112509,-2536,1500,0),

('Oren -> Plains of Lizardmen',97,87252,85514,-3056,1900,0),

('Oren -> Sea of Spores',98,64328,26803,-3768,2500,0),

('Hunters -> Northern Pathway of Enchanted Valley',99,104426,33746,-3800,3600,0),

('Hunters -> Southern Pathway of Enchanted Valley',100,124904,61992,-3920,1300,0),

('Hunters -> Entrance to the Forest of Mirrors',101,142065,81300,-3000,2000,0),

('Hunters -> The Front of Anghel Waterfall',102,163341,91374,-3320,4000,0),

('Goddard -> Aden Castle Town',132,146331,25762,-2018,8100,0),

('Goddard -> Rune Castle Village',108,43799,-47727,-798,10000,0),

('Goddard -> Varka Silenos Stronghold',109,125543,-40953,-3724,4200,0),

('Goddard -> Ketra Orc Outpost',110,146954,-67390,-3660,1800,0),

('Goddard -> Entrance to the Forge of the Gods',111,169178,-116244,-2421,2300,0),

('Rune -> Goddard Castle Village',119,147928,-55273,-2734,10000,0),

('Rune -> The Town of Giran',120,83400,147943,-3404,59000,0),

('Rune -> Aden Castle Town',121,146331,25762,-2018,37000,0),

('Rune -> Rune Castle Town Guild',122,38320,-48092,-1153,150,0),

('Rune -> Rune Castle Town Temple',123,38275,-48065,896,150,0),

('Rune -> Entrance to the Forest of the Dead',124,52112,-53939,-3159,1200,0),

('Rune -> Western Entrance to the Swamp of Screams',125,70006,-49902,-3251,3000,0),

('Rune -> Rune Castle Town Store',131,43799,-47727,-798,150,0),

('Aden -> Rune',134,43799,-47727,-798,37000,0),

('Aden -> Goddard',135,147928,-55273,-2734,8100,0),

('Giran Town -> Giran Harbor',136,47942,186764,-3485,5200,0),

('Rune -> Rune Castle Town Store',126,43849,-47877,-792,150,0),

 

('TOI - 1st Floor',201,115168,16022,-5100,100000,0),

('TOI - 2nd Floor',202,114649,18587,-3609,150000,0),

('TOI - 3rd Floor',203,117918,16039,-2127,200000,0),

('TOI - 4th Floor',204,114622,12946,-645,250000,0),

('TOI - 5th Floor',205,112209,16078,928,300000,0),

('TOI - 6th Floor',206,112376,16099,1947,350000,0),

('TOI - 7th Floor',207,114448,16175,2994,400000,0),

('TOI - 8th Floor',208,111063,16118,3967,450000,0),

('TOI - 9th Floor',209,117147,18415,4977,500000,0),

('TOI - 10th Floor',210,118374,15973,5987,550000,0),

('TOI - 11th Floor',211,112209,16078,7028,600000,0),

('TOI - 12th Floor',212,114809,18711,7996,650000,0),

('TOI - 13th Floor',213,115178,16989,9007,700000,0),

('TOI - 14th Floor Outside Door',214,112714,14111,10077,800000,0),

('TOI - 14th Floor Inside On Roof',215,113098,14532,10077,900000,0),

 

('Cat Heretics Entrance',250,-53174,-250275,-7911,0,0), -- Interlude (undersea)

('Cat Heretics Exit',251,42514,143917,-5385,0,0),

('Cat Branded Entrance',252,46217,170290,-4983,0,0),

('Cat Branded Exit',253,45770,170299,-4985,0,0),

('Cat Apostate Entrance',254,-20230,-250780,-8168,0,0), -- Interlude (undersea)

('Cat Apostate Exit',255,77225,78362,-5119,0,0),

('Cat Witch Entrance',256,140404,79678,-5431,0,0),

('Cat Witch Exit',257,139965,79678,-5433,0,0),

('Cat DarkOmen Entrance',258,-19500,13508,-4905,0,0),

('Cat DarkOmen Exit',259,-19931,13502,-4905,0,0),

('Cat ForbiddenPath Entrance',260,12521,-248481,-9585,0,0), -- Interlude (undersea)

('Cat ForbiddenPath Exit',261,113429,84540,-6545,0,0),

('Necro Sacrifice Entrance',262,-41570,209785,-5089,0,0),

('Necro Sacrifice Exit',263,-41567,209292,-5091,0,0),

('Necro Pilgrims Entrance',264,45251,123890,-5415,0,0),

('Necro Pilgrims Exit',265,45250,124366,-5417,0,0),

('Necro Worshippers Entrance',266,111273,174015,-5417,0,0),

('Necro Worshippers Exit',267,110818,174010,-5443,0,0),

('Necro Patriots Entrance',268,-21726,77385,-5177,0,0),

('Necro Patriots Exit',269,-22197,77369,-5177,0,0),

('Necro Ascetics Entrance',270,-52254,79103,-4743,0,0),

('Necro Ascetics Exit',271,-52716,79106,-4745,0,0),

('Necro Martyrs Entrance',272,118308,132800,-4833,0,0),

('Necro Martyrs Exit',273,117793,132810,-4835,0,0),

('Necro Saints Entrance',274,83000,209213,-5443,0,0),

('Necro Saints Exit',275,82608,209225,-5443,0,0),

('Necro Disciples Entrance',276,172251,-17605,-4903,0,0),

('Necro Disciples Exit',277,171902,-17595,-4905,0,0),

 

('Dion(artifact -> out)',350,22967,157715,-2954,0,0),

('Dion(artifact -> hall)',351,22090,159871,-2711,0,0),

('Dion(artifact -> outofcastle)',352,22448,155798,-2958,0,0),

('Dion(in -> artifact)',353,22592,161530,-2775,0,0),

('Dion(in -> out)',354,22967,157715,-2954,0,0),

('Dion(in -> outofcastle)',355,22448,155798,-2958,0,0),

('Dion(out -> artifact)',356,22592,161530,-2775,0,0),

('Dion(out -> hall)',357,22090,159871,-2711,0,0),

('Dion(out -> outofcastle)',358,22448,155798,-2958,0,0),

('Dion(outofcastle -> artifact)',359,22592,161530,-2775,0,0),

('Dion(outofcastle -> out)',360,22967,157715,-2954,0,0),

('Dion(outofcastle -> hall)',361,22090,159871,-2711,0,0),

('Giran(artifact -> out)',362,113892,144175,-2714,0,0),

('Giran(artifact -> hall)',363,115984,145073,-2584,0,0),

('Giran(artifact -> outofcastle)',364,112016,144682,-2833,0,0),

('Giran(in -> artifact)',365,117619,144564,-2648,0,0),

('Giran(in -> out)',366,113892,144175,-2714,0,0),

('Giran(in -> outofcastle)',367,112016,144682,-2833,0,0),

('Giran(out -> artifact)',368,117619,144564,-2648,0,0),

('Giran(out -> hall)',369,115984,145073,-2584,0,0),

('Giran(out -> outofcastle)',370,112016,144682,-2833,0,0),

('Giran(outofcastle -> artifact)',371,117619,144564,-2648,0,0),

('Giran(outofcastle -> out)',372,113892,144175,-2714,0,0),

('Giran(outofcastle -> hall)',373,115984,145073,-2584,0,0),

('Oren(artifact -> out)',374,79956,36351,-2532,0,0),

('Oren(artifact -> hall)',375,82113,37217,-2311,0,0),

('Oren(artifact -> outofcastle)',376,78079,36809,-2566,0,0),

('Oren(in -> artifact)',377,83710,36713,-2375,0,0),

('Oren(in -> out)',378,79956,36351,-2532,0,0),

('Oren(in -> outofcastle)',379,78079,36809,-2566,0,0),

('Oren(out -> artifact)',380,83710,36713,-2375,0,0),

('Oren(out -> hall)',381,82113,37217,-2311,0,0),

('Oren(out -> outofcastle)',382,78079,36809,-2566,0,0),

('Oren(outofcastle -> artifact)',383,83710,36713,-2375,0,0),

('Oren(outofcastle -> out)',384,79956,36351,-2532,0,0),

('Oren(outofcastle -> hall)',385,82113,37217,-2311,0,0),

('Gludio(artifact -> out)',386,-18941,112085,-2762,0,0),

('Gludio(artifact -> hall)',387,-18129,109898,-2517,0,0),

('Gludio(artifact -> outofcastle)',388,-18484,113897,-2772,0,0),

('Gludio(in -> artifact)',389,-18592,108271,-2581,0,0),

('Gludio(in -> out)',390,-18941,112085,-2762,0,0),

('Gludio(in -> outofcastle)',391,-18484,113897,-2772,0,0),

('Gludio(out -> artifact)',392,-18592,108271,-2581,0,0),

('Gludio(out -> hall)',393,-18129,109898,-2517,0,0),

('Gludio(out -> outofcastle)',394,-18484,113897,-2772,0,0),

('Gludio(outofcastle -> artifact)',395,-18592,108271,-2581,0,0),

('Gludio(outofcastle -> out)',396,-18941,112085,-2762,0,0),

('Gludio(outofcastle -> hall)',397,-18129,109898,-2517,0,0),

('Aden(artifact -> out)',398,147723,7916,-475,0,0),

('Aden(artifact -> in)',399,148580,4578,-408,0,0),

('Aden(artifact -> outofcastle)',400,147582,8753,-496,0,0),

('Aden(artifact -> hall)',401,147520,6107,-409,0,0),

('Aden(in -> artifact)',402,1147499,2544,-473,0,0),

('Aden(in -> out)',403,147723,7916,-475,0,0),

('Aden(in -> outofcastle)',404,147582,8753,-496,0,0),

('Aden(in -> hall)',405,147520,6107,-409,0,0),

('Aden(out -> artifact)',406,147499,2544,-473,0,0),

('Aden(out -> in)',407,148580,4578,-408,0,0),

('Aden(out -> outofcastle)',408,147582,8753,-496,0,0),

('Aden(out -> hall)',409,147520,6107,-409,0,0),

('Aden(outofcastle -> artifact)',410,147499,2544,-473,0,0),

('Aden(outofcastle -> out)',411,147723,7916,-475,0,0),

('Aden(outofcastle -> in)',412,148580,4578,-408,0,0),

('Aden(outofcastle -> hall)',413,147520,6107,-409,0,0),

('Aden(hall) -> artifact)',414,147499,2544,-473,0,0),

('Aden(hall) -> out)',415,147723,7916,-475,0,0),

('Aden(hall) -> in)',416,148580,4578,-408,0,0),

('Aden(hall) -> outofcastle)',417,147582,8753,-496,0,0),

('Lair Of Valakas',420,208884,-113705,-256,0,0),

('Disciples Necropolis -> Anakim/Lilith',450,184397,-11957,-5493,0,0),

('Anakim/Lilith -> Disciples Necropolis',451,183225,-11911,-4897,0,0),

('TI -> Dark Elven Village',1005,9745,15606,-4574,24000,0),

('TI -> Dwarven Village',1006,115113,-178212,-901,46000,0),

('TI -> Elven Village',1007,46934,51467,-2977,23000,0),

('TI -> Orc Village',1008,-44836,-112524,-235,35000,0),

('DE Village -> Dwarven Village',1009,115113,-178212,-901,22000,0),

('DE Village -> TI Village',1010,-84318,244579,-3730,24000,0),

('Gludin -> Windy Hill',1121,-88525,83379,-2864,2600,0),

('DE Village -> Orc Village',1012,-44836,-112524,-235,13000,0),

('Elven Village -> Neutral Zone',1013,-10674,75550,-3597,1700,0),

('Elven Village -> Dwarven Village',1014,115113,-178212,-901,23000,0),

('Elven Village -> TI Village',1015,-84318,244579,-3730,23000,0),

('Elven Village -> Orc Village',1016,-44836,-112524,-235,18000,0),

('Dwarven Village -> DE Village',1017,9745,15606,-4574,22000,0),

('Dwarven Village -> Elven Village',1018,46934,51467,-2977,23000,0),

('Dwarven Village -> TI Village',1019,-84318,244579,-3730,46000,0),

('Dwarven Village -> Schuttgart',1020,87386,-143246,-1293,4400,0),

('Dwarven Village -> Orc Village',1021,-44836,-112524,-235,17000,0),

('Dwarven Village -> Central Shore',1022,136910,-205082,-3664,970,0),

('Orc Village -> Town of Gludio',1023,-12672,122776,-3116,23000,0),

('Orc Village -> Schuttgart',1024,87386,-143246,-1293,13000,0),

('Orc Village -> DE Village',1025,9745,15606,-4574,13000,0),

('Orc Village -> Dwarven Village',1026,115113,-178212,-901,17000,0),

('Orc Village -> TI Village',1027,-84318,244579,-3730,35000,0),

('Orc Village -> Elven Village',1028,46934,51467,-2977,18000,0),

('Gludio -> Orc Village',1033,-44836,-112524,-235,23000,0),

('Gludin Village -> Windmill Hill',1029,-68628,162336,-3592,550,0),

('Gludin Village -> Forgotten Temple',1030,-52841,190730,-3518,2000,0),

('Gludio -> Ant Cave',1031,-9993,176457,-4182,2100,0),

('Gludin Village -> Crimson Boulder Ridge',1032,-42256,198333,-2800,3700,0),

('Gludio -> Dwarven Village',1034,115113,-178212,-901,32000,0),

('Gludio -> Schuttgart',1035,87386,-143246,-1293,85000,0),

('Gludio -> Heine',1036,111409,219364,-3545,47000,0),

('Gludio -> Aden Castle Town',1037,146331,25762,-2018,56000,0),

('Gludio -> Oren Castle Town',1038,82956,53162,-1495,35000,0),

('Gludio -> Goddard Castle Town',1039,147928,-55273,-2734,71000,0),

('Gludio -> Giran Castle Town',1040,83400,147943,-3404,29000,0),

('Gludio -> Rune Castle Town',1041,43799,-47727,-798,53000,0),

('Gludio -> Ruins of Agony',1042,-42504,120046,-3519,790,0),

('Gludio -> Ruins of Despair',1043,-20057,137618,-3897,610,0),

('Gludin -> Turek Orc',1044,-89839,105362,-3580,1800,0),

('Gludio -> Windmill Hill',1045,-68628,162336,-3592,2600,0),

('Dion -> Goddard',1046,147928,-55273,-2734,71000,0),

('Dion -> Rune Castle Town',1047,43799,-47727,-798,57000,0),

('Dion -> Schuttgart',1048,87386,-143246,-1293,88000,0),

('Dion -> Aden',1049,146331,25762,-2018,52000,0),

('Dion -> Oren',1050,82956,53162,-1495,33000,0),

('Dion -> Cruma Marshlands',1051,5106,126916,-3664,760,0),

('Dion -> Cruma Tower',1052,17192,114178,-3439,2300,0),

('Dion -> Dion Pasture',1053,630,179184,-3720,1500,0),

('Dion -> Tanor Canyon',1054,58316,163851,-2816,3800,0),

('Giran -> Gludio',1055,-12672,122776,-3116,29000,0),

('Giran -> Goddard',1056,147928,-55273,-2734,63000,0),

('Giran -> Rune',1057,43799,-47727,-798,59000,0),

('Giran -> Schuttgart',1058,87386,-143246,-1293,87000,0),

('Giran -> Aden',1059,146331,25762,-2018,13000,0),

('Giran -> Antharas Lair',1060,132828,114421,-3725,7000,0),

('Giran -> Devil Isle',1061,43408,206881,-3752,5700,0),

('Giran -> Brekas Stronghold',1062,79798,130624,-3677,1000,0),

('Heine -> Oren',1063,82956,53162,-1495,50000,0),

('Heine -> Aden',1064,146331,25762,-2018,59000,0),

('Heine -> Goddard',1065,147928,-55273,-2734,83000,0),

('Heine -> Rune',1066,43799,-47727,-798,82000,0),

('Heine -> Schuttgart',1067,87386,-143246,-1293,100000,0),

('Heine -> Gludio',1068,-12672,122776,-3116,47000,0),

('Heine -> Garden of Eva',1069,86006,231069,-3600,2400,0),

('Oren -> Rune',1070,43799,-47727,-798,10000,0),

('Oren -> Goddard',1071,147928,-55273,-2734,37000,0),

('Oren -> Heine',1072,111409,219364,-3545,50000,0),

('Oren -> Dion',1073,15670,142983,-2705,33000,0),

('Oren -> Schuttgart',1074,87386,-143246,-1293,59000,0),

('Oren -> Gludio',1075,-12672,122776,-3116,35000,0),

('Oren -> Skyshadow Meadow',1076,82764,61145,-3502,780,0),

('Oren -> Forest Outlaw',1077,85995,-2433,-3528,5200,0),

('Aden -> Giran',1078,83400,147943,-3404,13000,0),

('Aden -> Heine',1079,111409,219364,-3545,59000,0),

('Aden -> Schuttgart',1080,87386,-143246,-1293,53000,0),

('Aden -> Dion',1081,15670,142983,-2705,52000,0),

('Aden -> Gludio',1082,-12672,122776,-3116,56000,0),

('Aden -> Seal of Shilen',1083,184787,19744,-3168,3300,0),

('Aden -> Forest of Mirrors',1084,142065,81300,-3000,4400,0),

('Aden -> Fields of Massacre',1085,183543,-14974,-2776,6500,0),

('Aden -> Ancient Battleground',1086,106517,-2871,-3416,5900,0),

('Aden -> Silent Valley',1087,170838,55776,-5280,6100,0),

('Aden -> ToI',1088,114649,11115,-5120,4200,0),

('Goddard -> Gludio',1089,-12672,122776,-3116,71000,0),

('Goddard -> Giran',1090,83400,147943,-3404,63000,0),

('Goddard -> Dion',1091,15670,142983,-2705,71000,0),

('Goddard -> Heine',1092,111409,219364,-3545,83000,0),

('Goddard -> Schuttgart',1093,87386,-143246,-1293,10000,0),

('Goddard -> Oren',1094,82956,53162,-1495,37000,0),

('Goddard -> Hot Springs',1095,144880,-113468,-2560,9300,0),

('Goddard -> Wall of Argos',1096,165054,-47861,-3560,2200,0),

('Goddard -> Monastery of silence',1097,106414,-87799,-2920,10000,0),

('Rune -> Dion',1098,15670,142983,-2705,57000,0),

('Rune -> Gludio',1099,-12672,122776,-3116,53000,0),

('Rune -> Heine',1100,111409,219364,-3545,82000,0),

('Rune -> Schuttgart',1101,87386,-143246,-1293,10000,0),

('Rune -> Oren',1102,82956,53162,-1495,10000,0),

('Rune -> Beast Farm',1103,57059,-82976,-2847,4800,0),

('Rune -> Valley of Saints',1104,67992,-72012,-3748,3800,0),

('Rune -> Monastery of Silence',1105,123743,-75032,-2902,14000,0),

('Schuttgart -> Rune',1106,43799,-47727,-798,10000,0),

('Schuttgart -> Goddard',1107,147928,-55273,-2734,10000,0),

('Schuttgart -> Aden',1108,146331,25762,-2018,53000,0),

('Schuttgart -> Oren',1109,82956,53162,-1495,59000,0),

('Schuttgart -> Heine',1110,111409,219364,-3545,100000,0),

('Schuttgart -> Giran',1111,83400,147943,-3404,87000,0),

('Schuttgart -> Dion',1112,15670,142983,-2705,88000,0),

('Schuttgart -> Gludio',1113,-12672,122776,-3116,85000,0),

('Schuttgart -> Orc Village',1114,-44836,-112524,-235,13000,0),

('Schuttgart -> Dwarven Village',1115,115113,-178212,-901,4400,0),

('Schuttgart -> Nest of Evil Spirit',1116,76860,-125169,-3414,3000,0),

('Schuttgart -> Wasteland of plunder',1117,109024,-159223,-1778,1600,0),

('Schuttgart -> Labyrinth of winter',1118,113903,-108752,-848,3500,0),

('Schuttgart -> Graveyard of disgrace',1119,56095,-118952,-3290,1900,0),

('Schuttgart -> Farbel Ruins',1120,88288,-125692,-3816,2100,0),

 

('Pagan Temple - > exit', 11999, -16307, -36591, -10725, 0, 0),

('Pagan Chapel - > exit', 11998, -16359, -43803, -10725, 0, 0);

 

INSERT INTO teleport VALUES

('Clan Hall -> Execution Grounds',502,51055,141959,-2869,500,0),

-- ('Clan Hall -> Fortress of Resistance',503,51055,141959,-2869,500,0), -- dunno coords !

('Clan Hall -> Cruma Marshlands',504,5106,126916,-3664,500,0),

('Clan Hall -> Cruma Tower Entrance',505,17192,114178,-3439,500,0),

-- ('Clan Hall -> Mandragora Farm',506,17192,114178,-3439,500,0), -- dunno coords !

('Clan Hall -> Town of Dion',507,15670,142983,-2705,500,0),

('Clan Hall -> Floran Village',508,17838,170274,-3508,500,0),

-- 509

('Clan Hall -> Tanor Canyon',510,58316,163851,-2816,500,0),

('Clan Hall -> Bee Hive',511,20505,189036,-3344,500,0),

-- ('Clan Hall -> Dion Hills',512,20505,189036,-3344,500,0), -- dunno coords !

('Clan Hall -> Floran Agricultural Area',513,26810,172787,-3376,500,0), -- needs confirming

('Clan Hall -> Plains of Dion',514,9980,173167,-3734,500,0), -- needs confirming

-- 515

-- 516

('Clan Hall -> Hardin\'s Academy',517,105918,109759,-3207,500,0),

('Clan Hall -> Dragon Valley',518,122824,110836,-3720,500,0),

-- 519

-- 520

('Clan Hall -> Death Pass',521,70000,126636,-3804,500,0),

('Clan Hall -> Pirate Tunnel',522,41298,200350,-4583,500,0),

-- 523

('Clan Hall -> Giran Harbor',524,47942,186764,-3485,500,0),

('Clan Hall -> Giran Castle Town',525,83400,147943,-3404,500,0),

('Clan Hall -> Giran Arena',526,73890,142656,-3778,500,0),

-- 527

('Clan Hall -> Breka\'s Stronghold',528,79798,130624,-3677,500,0),

('Clan Hall -> Gorgon Flower Garden',529,113553,134813,-3640,500,0), -- needs confirming

-- -----------------

('Clan Hall -> Ivory Tower',581,85348,16142,-3699,500,0),

('Clan Hall -> Town of Oren',582,82956,53162,-1495,500,0),

-- 583

('Clan Hall -> Plains of Lizardmen',584,87252,85514,-3056,500,0),

('Clan Hall -> Skyshadow Meadow',585,82764,61145,-3502,500,0),

-- ('Clan Hall -> Shilen\'s Garden',586,82764,61145,-3502,500,0), -- dunno coords !

-- ('Clan Hall -> Black Rock Hill',587,82764,61145,-3502,500,0), -- dunno coords !

('Clan Hall -> Spider Nest',588,-56532,78321,-2960,500,0),

('Clan Hall -> Timak Outpost',589,67097,68815,-3648,500,0), -- needs confirming

-- ('Clan Hall -> Ivory Tower Crater',590,-56532,78321,-2960,500,0), -- dunno coords !

('Clan Hall -> Forest of Evil',591,93218,16969,-3904,500,0), -- needs confirming

('Clan Hall -> Outlaw Forest',592,85995,-2433,-3528,500,0),

-- ('Clan Hall -> Misty Mountains',593,85995,-2433,-3528,500,0), -- dunno coords !

-- ('Clan Hall -> Starlight Waterfall',594,85995,-2433,-3528,500,0), -- dunno coords !

-- ('Clan Hall -> Undine Waterfall',595,85995,-2433,-3528,500,0), -- dunno coords !

-- ('Clan Hall -> The Gods\' Falls',596,85995,-2433,-3528,500,0), -- dunno coords !

-- 597

('Clan Hall -> Tower of Insolence',598,121685,15749,-3852,500,0),

('Clan Hall -> The Blazing Swamp',599,146828,-12859,-4455,500,0),

-- 600

('Clan Hall -> The Forbidden Gateway',601,185395,20359,-3270,500,0),

('Clan Hall -> The Giants Cave',602,174528,52683,-4369,500,0),

('Clan Hall -> Northern Pathway of Enchanted Valley',603,104426,33746,-3800,500,0), -- need also southern?

('Clan Hall -> The Cemetery',604,172136,20325,-3326,500,0),

('Clan Hall -> The Forest of Mirrors',605,150477,85907,-2753,500,0),

('Clan Hall -> Anghel Waterfall',606,165584,85997,-2338,500,0),

('Clan Hall -> Aden Castle Town',607,146331,25762,-2018,500,0),

('Clan Hall -> Hunters Village',608,117110,76883,-2695,500,0),

('Clan Hall -> Border Outpost(Aden Side)',609,109699,-7908,-2902,500,0),

('Clan Hall -> Coliseum',610,150086,46733,-3412,500,0),

-- ('Clan Hall -> Narsell Lake',611,150086,46733,-3412,500,0), -- dunno coords !

-- 612

('Clan Hall -> Ancient Battleground',613,127739,-6998,-3869,500,0),

('Clan Hall -> Forsaken Plains',614,167285,37109,-4008,500,0),

('Clan Hall -> Silent Valley',615,177318,48447,-3835,500,0),

('Clan Hall -> Hunters Valley',616,114306,86573,-3112,500,0), -- needs confirming

('Clan Hall -> Plains of Glory',617,135756,19557,-3424,500,0), -- needs confirming

('Clan Hall -> Fields of Massacre',618,179718,-7843,-3517,500,0), -- needs confirming

('Clan Hall -> War-Torn Plains',619,156898,11217,-4032,500,0), -- needs confirming

('Clan Hall -> Border Outpost(Unknown Side)',620,114172,-18034,-1875,500,0),

('Clan Hall -> Rune Castle Town - Shopping Area',621,43835,-47749,-796,0,0),

('Clan Hall -> Rune Castle Town - Temple',622,38303,-48044,897,0,0),

('Clan Hall -> Rune Castle Town - North Gate',623,38956,-53648,-1343,0,0),

('Clan Hall -> Rune Castle Town - Harbor',624,38025,-38359,-3608,0,0),

('Clan Hall -> Beast Farm',625,42598,-88832,-3124,500,0),

('Clan Hall -> Forest of the Dead - East Entrance',626,61868,-48890,-3128,500,0),

('Clan Hall -> Forest of the Dead - West Entrance',627,45555,-56081,-3667,500,0),

('Clan Hall -> Swamp of Screams - East Entrance',628,94152,-58694,-2832,500,0),

('Clan Hall -> Swamp of Screams - West Entrance',629,69999,-49929,-3253,500,0),

('Clan Hall -> Valley of the Saints',630,65800,-71526,-3747,500,0),

('Clan Hall -> Village Square',631,147728,-56331,-2776,0,0),

('Clan Hall -> North Gate Entrance',632,147731,-58930,-2976,0,0),

('Clan Hall -> East Gate Entrance',633,150561,-57489,-2976,0,0),

('Clan Hall -> West Gate Entrance',634,144866,-57464,-2976,0,0),

('Clan Hall -> Forge of the Gods',635,168902,-116703,-2417,0,0),

('Clan Hall -> Garden of Beasts',636,129138,-60864,-3576,500,0),

('Clan Hall -> Swamp of Screams',637,70006,-49902,-3251,500,0),

('Clan Hall -> Valley of Saints',638,67992,-72012,-3748,500,0),

('Clan Hall -> Monastery of Silence',639,123743,-75032,-2902,500,0),

('Clan Hall -> Wall of Argos',640,164564,-48145,-3536,500,0),

('Clan Hall -> Hot Springs',641,144880,-113468,-2560,500,0),

('Clan Hall -> Ketra Orc Outpost',642,146990,-67128,-3640,500,0),

('Clan Hall -> Goddard Border Checkpoint',643,157560,-33269,-3320,500,0),

('Clan Hall -> Aden Border Checkpoint',644,125381,-33536,-3848,500,0),

('Clan Hall -> Garden of Beasts',645,129138,-60864,-3576,500,0),

('Clan Hall -> Devil\'s Pass',646,106849,-62061,-2968,500,0),

('Clan Hall -> Varka Silenos Outpost',647,125740,-40864,-3736,500,0),

('Clan Hall -> Village Square',648,-82445,150788,-3129,0,0),

('Clan Hall -> North Gate Entrance',649,-83331,148563,-3148,0,0),

('Clan Hall -> East Gate Entrance',650,-78405,152723,-3181,0,0),

('Clan Hall -> Nanmen Entrance',651,-77460,155995,-3194,0,0),

('Clan Hall -> West Gate Entrance',652,-85138,152749,-3160,0,0),

('Clan Hall -> Neutral Zone',653,-10612,75881,-3592,500,0),

('Clan Hall -> Langk Lizardmen Dwellings',654,-36961,201895,-2760,500,0),

('Clan Hall -> Windy Hill',655,-93453,89814,-3240,500,0),

('Clan Hall -> Orc Barracks',656,-85329,106369,-3603,500,0),

('Clan Hall -> Fellmere Harvesting Ground',657,-68668,115407,-3600,500,0),

('Clan Hall -> Ruins of Agony',658,-41055,122647,-2889,500,0),

('Clan Hall -> Abandoned Camp',659,-49756,146951,-2828,500,0),

('Clan Hall -> Forgotten Temple',660,-52369,191259,-3610,500,0),

('Clan Hall -> The Ant Nest',661,-14913,170017,-2893,500,0),

('Clan Hall -> Wasteland',662,-47506,179572,-3669,500,0),

('Clan Hall -> Ol Mahum Checkpoint',663,-17279,208954,-3664,500,0),

('Clan Hall -> Ant Cave South Entrance',664,-16019,193365,-4488,500,0),

('Clan Hall -> Ant Cave East Entrance',665,-10875,175962,-4152,500,0),

('Clan Hall -> Ant Cave West Entrance',666,-25899,172857,-4186,500,0),

('Clan Hall -> Altar of Rites',667,-44311,78617,-3744,500,0),

('Clan Hall -> Dion Castle Town',75003,19025,145245,-3107,500,0),

('Clan Hall -> Goddard',75001,147928,-55273,-2734,500,0),

('Clan Hall -> Hot Springs',75002,144880,-113468,-2560,0,0);

 

-- Noblesse Teleport

INSERT INTO teleport VALUES

-- 1000 adena

('Gludin Arena - 1000 adena',9000,-87328,142266,-3640,1000,0),

('Coliseum - 1000 adena',9001,146440,46723,-3432,1000,0),

('Giran Arena - 1000 adena',9002,73579,142709,-3768,1000,0),

('Forgotten Temple - 1000 adena',9010,-54026,179504,-4640,1000,0),

('Wasteland - 1000 adena',9011,-47506,179572,-3632,1000,0),

('Silent Valley - 1000 adena',9020,181737,46469,-4352,1000,0),

('Plains of Glory - 1000 adena',9021,135756,19557,-3424,1000,0),

('War-Torn Plains - 1000 adena',9022,156898,11217,-4032,1000,0),

('Tower of Insolence, 3rd Floor - 1000 adena',9023,110848,16154,-2120,1000,0),

('Tower of Insolence, 5th Floor - 1000 adena',9024,118404,15988,832,1000,0),

('Tower of Insolence, 7th Floor - 1000 adena',9025,115064,12181,2960,1000,0),

('Tower of Insolence, 10th Floor - 1000 adena',9026,118525,16455,5984,1000,0),

('Tower of Insolence, 13th Floor - 1000 adena',9027,115384,16820,9000,1000,0),

('Hunters Valley - 1000 adena',9028,114306,86573,-3112,1000,0),

('Angel Waterfall - 1000 adena',9029,166182,91560,-3168,1000,0),

('Forest of Mirrors - 1000 adena',9030,166080,75574,-2992,1000,0),

('Enchanted Valley - 1000 adena',9031,114674,44150,-3376,1000,0),

('Hunters Valley - 1000 adena',9032,114306,86573,-3112,1000,0),

('Gorgon Flower Garden - 1000 adena',9040,113553,134813,-3640,1000,0),

('Antharas Lair 1 - 1000 adena',9041,147071,120156,-4520,1000,0),

('Antharas Lair 2 - 1000 adena',9042,151689,112615,-5520,1000,0),

('Dragon Valley - 1000 adena',9043,116425,109898,-3424,1000,0),

('Antharas Lair, Heart of Warding - 1000 adena',9044,154396,121235,-3808,1000,0),

('Dragon Valley, Traders Post - 1000 adena',9045,122824,110836,-3720,1000,0),

('Private Hardin\'s Academy - 1000 adena',9046,105918,109759,-3192,1000,0),

('Forest of the Dead - 1000 adena',9050,54425,-41692,-3072,1000,0),

('Valley of Saints - 1000 adena',9051,84092,-80084,-3504,1000,0),

('Cursed Village - 1000 adena',9052,57670,-41672,-3144,1000,0),

('Stakato Nest - 1000 adena',9053,88969,-45307,-2104,1000,0),

('Monastery of Silence - 1000 adena',9054,106414,-87799,-2920,1000,0),

('Varka Silenos Village - 1000 adena',9060,107929,-52248,-2408,1000,0),

('Ketra Orc Village - 1000 adena',9061,149817,-80053,-5576,1000,0),

('Devil\'s Pass - 1000 adena',9062,106349,-61870,-2904,1000,0),

('Garden of Beasts - 1000 adena',9063,132997,-60608,-2960,1000,0),

('Hot Springs - 1000 adena',9064,144625,-101291,-3384,1000,0),

('Wall of Argos - 1000 adena',9065,183140,-53307,-1896,1000,0),

('Wall of Argos - 1000 adena',9066,183140,-53307,-1896,1000,0),

('Four Sepulchers - 1000 adena',9067,178127,-84435,-7216,1000,0),

('Imperial Tomb - 1000 adena',9068,186699,-75915,-2824,1000,0),

('Forge of the Gods, entrance - 1000 adena',9069,169018,-116303,-2432,1000,0),

('Forge of the Gods, entrance - 1000 adena',9070,169018,-116303,-2432,1000,0),

('Forge of the Gods, lower level - 1000 adena',9071,179887,-111241,-5824,1000,0),

('Execution Grounds - 1000 adena',9080,50568,152408,-2656,1000,0),

('Floran Agricultural Area - 1000 adena',9081,26810,172787,-3376,1000,0),

('Cruma Marshlands - 1000 adena',9082,5941,125455,-3640,1000,0),

('Cruma Tower, 1st Floor - 1000 adena',9083,17718,117315,-12064,1000,0),

('Cruma Tower, 2nd Floor - 1000 adena',9084,17728,110325,-9312,1000,0),

('Frost Lake - 1000 adena',9090,107577,-122392,-3632,1000,0),

('Crypts of Disgrace - 1000 adena',9091,44221,-114232,-2784,1000,0),

('Sky Wagon Relic - 1000 adena',9092,121618,-141554,-1496,1000,0),

('Evil Hunting Grounds - 1000 adena',9100,-6989,109503,-3040,1000,0),

('Neutral Zone - 1000 adena',9101,-18415,85624,-3680,1000,0),

('Dark Forest - 1000 adena',9102,-14129,27094,-3680,1000,0),

('School of Dark Arts - 1000 adena',9103,-49185,49441,-5912,1000,0),

('Elven Ruins - 1000 adena',9104,49315,248452,-5960,1000,0),

('Immortal Plateau - 1000 adena',9105,-25309,-131569,-680,1000,0),

('Mithril Mines - 1000 adena',9106,175499,-181586,-904,1000,0),

('Abandoned Coal Mines - 1000 adena',9107,144706,-173223,-1520,1000,0),

('Forest of Evil - 1000 adena',9110,93218,16969,-3904,1000,0),

('Timak Outpost - 1000 adena',9111,67097,68815,-3648,1000,0),

('Altar of Rites - 1000 adena',9112,-44566,77508,-3736,1000,0),

('Fields of Silence - 1000 adena',9120,69748,186111,-2872,1000,0),

('Field of Whispers - 1000 adena',9121,97786,209303,-3040,1000,0),

('Alligator Island - 1000 adena',9122,113708,178387,-3232,1000,0),

('Garden of Eva, entrance - 1000 adena',9123,82693,242220,-6712,1000,0),

('Garden of Eva, 2nd level - 1000 adena',9124,79248,247390,-8816,1000,0),

('Garden of Eva, 3rd level - 1000 adena',9125,77868,250400,-9328,1000,0),

('Garden of Eva, 4th level - 1000 adena',9126,78721,253309,-9840,1000,0),

('Garden of Eva, 5th level - 1000 adena',9127,82951,252354,-10592,1000,0),

-- Noble Gate Pass

('Gludin Arena - 1 Noble Gate Pass',9900,-87328,142266,-3640,1,1),

('Coliseum - 1 Noble Gate Pass',9901,146440,46723,-3432,1,1),

('Giran Arena - 1 Noble Gate Pass',9902,73579,142709,-3768,1,1),

('Forgotten Temple - 1 Noble Gate Pass',9910,-54026,179504,-4640,1,1),

('Wasteland - 1 Noble Gate Pass',9911,-47506,179572,-3632,1,1),

('Silent Valley - 1 Noble Gate Pass',9920,181737,46469,-4352,1,1),

('Plains of Glory - 1 Noble Gate Pass',9921,135756,19557,-3424,1,1),

('War-Torn Plains - 1 Noble Gate Pass',9922,156898,11217,-4032,1,1),

('Tower of Insolence, 3rd Floor - 1 Noble Gate Pass',9923,110848,16154,-2120,1,1),

('Tower of Insolence, 5th Floor - 1 Noble Gate Pass',9924,118404,15988,832,1,1),

('Tower of Insolence, 7th Floor - 1 Noble Gate Pass',9925,115064,12181,2960,1,1),

('Tower of Insolence, 10th Floor - 1 Noble Gate Pass',9926,118525,16455,5984,1,1),

('Tower of Insolence, 13th Floor - 1 Noble Gate Pass',9927,115384,16820,9000,1,1),

('Hunters Valley - 1 Noble Gate Pass',9928,114306,86573,-3112,1,1),

('Angel Waterfall - 1 Noble Gate Pass',9929,166182,91560,-3168,1,1),

('Forest of Mirrors - 1 Noble Gate Pass',9930,166080,75574,-2992,1,1),

('Enchanted Valley - 1 Noble Gate Pass',9931,114674,44150,-3376,1,1),

('Hunters Valley - 1 Noble Gate Pass',9932,114306,86573,-3112,1,1),

('Gorgon Flower Garden - 1 Noble Gate Pass',9940,113553,134813,-3640,1,1),

('Antharas Lair 1 - 1 Noble Gate Pass',9941,147071,120156,-4520,1,1),

('Antharas Lair 2 - 1 Noble Gate Pass',9942,151689,112615,-5520,1,1),

('Dragon Valley - 1 Noble Gate Pass',9943,116425,109898,-3424,1,1),

('Antharas Lair, Heart of Warding - 1 Noble Gate Pass',9944,154396,121235,-3808,1,1),

('Dragon Valley, Traders Post - 1 Noble Gate Pass',9945,122824,110836,-3720,1,1),

('Private Hardin\'s Academy - 1 Noble Gate Pass',9946,105918,109759,-3192,1,1),

('Forest of the Dead - 1 Noble Gate Pass',9950,54425,-41692,-3072,1,1),

('Valley of Saints - 1 Noble Gate Pass',9951,84092,-80084,-3504,1,1),

('Cursed Village - 1 Noble Gate Pass',9952,57670,-41672,-3144,1,1),

('Stakato Nest - 1 Noble Gate Pass',9953,88969,-45307,-2104,1,1),

('Monastery of Silence - 1 Noble Gate Pass',9954,106414,-87799,-2920,1,1),

('Varka Silenos Village - 1 Noble Gate Pass',9960,107929,-52248,-2408,1,1),

('Ketra Orc Village - 1 Noble Gate Pass',9961,149817,-80053,-5576,1,1),

('Devil\'s Pass - 1 Noble Gate Pass',9962,106349,-61870,-2904,1,1),

('Garden of Beasts - 1 Noble Gate Pass',9963,132997,-60608,-2960,1,1),

('Hot Springs - 1 Noble Gate Pass',9964,144625,-101291,-3384,1,1),

('Wall of Argos - 1 Noble Gate Pass',9965,183140,-53307,-1896,1,1),

('Four Sepulchers - 1 Noble Gate Pass',9967,178127,-84435,-7216,1,1),

('Imperial Tomb - 1 Noble Gate Pass',9968,186699,-75915,-2824,1,1),

('Forge of the Gods, entrance - 1 Noble Gate Pass',9970,169018,-116303,-2432,1,1),

('Forge of the Gods, lower level - 1 Noble Gate Pass',9971,179887,-111241,-5824,1,1),

('Execution Grounds - 1 Noble Gate Pass',9980,50568,152408,-2656,1,1),

('Floran Agricultural Area - 1 Noble Gate Pass',9981,26810,172787,-3376,1,1),

('Cruma Marshlands - 1 Noble Gate Pass',9982,5941,125455,-3640,1,1),

('Cruma Tower, 1st Floor - 1 Noble Gate Pass',9983,17718,117315,-12064,1,1),

('Cruma Tower, 2nd Floor - 1 Noble Gate Pass',9984,17728,110325,-9312,1,1),

('Frost Lake - 1 Noble Gate Pass',9990,107577,-122392,-3632,1,1),

('Crypts of Disgrace - 1 Noble Gate Pass',9991,44221,-114232,-2784,1,1),

('Sky Wagon Relic - 1 Noble Gate Pass',9992,121618,-141554,-1496,1,1),

('Evil Hunting Grounds - 1 Noble Gate Pass',10000,-6989,109503,-3040,1,1),

('Neutral Zone - 1 Noble Gate Pass',10001,-18415,85624,-3680,1,1),

('Dark Forest - 1 Noble Gate Pass',10002,-14129,27094,-3680,1,1),

('School of Dark Arts - 1 Noble Gate Pass',10003,-49185,49441,-5912,1,1),

('Elven Ruins - 1 Noble Gate Pass',10004,49315,248452,-5960,1,1),

('Immortal Plateau - 1 Noble Gate Pass',10005,-25309,-131569,-680,1,1),

('Mithril Mines - 1 Noble Gate Pass',10006,175499,-181586,-904,1,1),

('Abandoned Coal Mines - 1 Noble Gate Pass',10007,144706,-173223,-1520,1,1),

('Forest of Evil - 1 Noble Gate Pass',10010,93218,16969,-3904,1,1),

('Timak Outpost - 1 Noble Gate Pass',10011,67097,68815,-3648,1,1),

('Altar of Rites - 1 Noble Gate Pass',10012,-44566,77508,-3736,1,1),

('Field of Silence - 1 Noble Gate Pass',10020,69748,186111,-2872,1,1),

('Field of Whispers - 1 Noble Gate Pass',10021,97786,209303,-3040,1,1),

('Alligator Island - 1 Noble Gate Pass',10022,113708,178387,-3232,1,1),

('Garden of Eva, entrance - 1 Noble Gate Pass',10023,82693,242220,-6712,1,1),

('Garden of Eva, 2nd ring - 1 Noble Gate Pass',10024,79248,247390,-8816,1,1),

('Garden of Eva, 3rd ring - 1 Noble Gate Pass',10025,77868,250400,-9328,1,1),

('Garden of Eva, 4th ring - 1 Noble Gate Pass',10026,78721,253309,-9840,1,1),

('Garden of Eva, 5th level - 1 Noble Gate Pass',10027,82951,252354,-10592,1,1),

('Ketra teleport - Goddard Castle Town',10028,147978,-55408,-2728,4900,0),

('Ketra teleport - Rune Castle Town',10029,43849,-47877,-792,22000,0),

('Ketra teleport - Aden Castle Town',10030,146705,25840,-2000,21000,0),

('Ketra teleport - Wall of Argos',10031,164564,-48145,-3536,7000,0),

('Ketra teleport - Hot Springs',10032,144880,-113468,-2560,6700,0),

('Varka teleport - Goddard Castle Town',10033,147978,-55408,-2728,8000,0),

('Varka teleport - Rune Castle Town',10034,43849,-47877,-792,12000,0),

('Varka teleport - Aden Castle Town',10035,146705,25840,-2000,17000,0),

('Varka teleport - Wall of Argos',10036,164564,-48145,-3536,11000,0),

('Varka teleport - Hot Springs',10037,144880,-113468,-2560,14000,0);

 

INSERT INTO teleport VALUES

('Clan Hall -> Center Town of Aden',12000,147450,28081,-2294,0,0),

('Clan Hall -> North Town of Aden',12001,151950,25094,-2172,0,0),

('Clan Hall -> East Town of Aden',12002,142593,26344,-2425,0,0),

('Clan Hall -> South Town of Aden',12003,147503,32299,-2501,0,0),

('Clan Hall -> West Town of Aden',12004,147465,20737,-2130,0,0),

('Clan Hall -> Southern Pathway of Enchanted Valley',12005,124904,61992,-3973,500,0),

('Clan Hall -> East of Blazing Swamp',12006,159676,-13544,-2832,500,0),

('Clan Hall -> Plains of Glory',12007,133164,14036,-3888,500,0),

('Clan Hall -> Plains of Fierce Battle',12008,153757,8905,-4024,500,0),

('Clan Hall -> Path to Forest of Wirrors',12009,134310,71976,-3298,500,0),

('Clan Hall -> The Front of Anghel Waterfall',12010,163341,91374,-3320,500,0),

('Clan Hall -> Disciples Necropolis',12011,168779,-18790,-3184,500,0),

('Clan Hall -> North Path to The Cementery',12012,175191,4082,-2863,500,0),

('Clan Hall ->South Path to The Cementery',12013,175432,30299,-3773,500,0),

('Clan Hall -> West Path to The Cementery',12014,166502,20284,-3328,500,0),

('Clan Hall -> Center of Giran Castle Town',12015,81749,149171,-3464,0,0),

('Clan Hall -> North of Giran Castle Town',12016,81525,143821,-3528,0,0),

('Clan Hall -> East of Giran Castle Town',12017,88342,147329,-3400,0,0),

('Clan Hall -> South of Giran Castle Town',12018,81548,152633,-3528,0,0),

('Clan Hall -> West of Giran Castle Town',12019,77305,148636,-3592,0,0),

('Clan Hall -> Devils Isle',12020,43408,206881,-3752,500,0),

('Clan Hall -> Center of Gludin Village',12021,-82445,150788,-3129,0,0),

('Clan Hall -> North of Gludin Village',12022,-83331,148563,-3148,0,0),

('Clan Hall -> East of Gludin Village',12023,-78405,152723,-3181,0,0),

('Clan Hall -> South of Gludin Village',12024,-77460,155995,-3194,0,0),

('Clan Hall -> West of Gludin Village',12025,-85138,152749,-3160,0,0),

('Clan Hall -> Necropolis of Sacrifice',12026,-36961,201895,-2760,500,0),

('Clan Hall -> Oracle Dusk',12027,-93453,89814,-3240,500,0),

('Clan Hall -> Oracle of Dawn',12028,-85329,106369,-3603,500,0),

('Clan Hall -> South Pathway to the Wasterland',12029,-17279,208954,-3664,500,0),

('Clan Hall -> Wasterland',12030,-16019,193365,-4488,500,0),

('Clan Hall -> North of Dion Castle Town',12041,21511,145866,-3153,0,0),

('Clan Hall -> Center of Dion Castle Town',12040,19025,145245,-3107,0,0),

('Clan Hall -> Center of Gludio Castle Town',12033,-14393,123671,-3144,0,0),

('Clan Hall -> North of Gludio Castle Town',12035,-11817,123652,-3079,0,0),

('Clan Hall -> East of Gludio Castle Town',12034,-16796,124108,-3127,0,0),

('Clan Hall -> West of Gludio Castle Town',13037,-14591,121024,-2990,0,0),

('Clan Hall -> Ruins of Despair',12038,-20767,136437,-3923,500,0),

('Clan Hall -> The Ruins Bend',12039,-32664,148626,-3956,500,0),

('Clan Hall -> East of Dion Castle Town',12042,18891,142365,-3051,0,0),

('Clan Hall -> South of Dion Castle Town',12043,17394,147593,-3129,0,0),

('Clan Hall -> West of Dion Castle Town',12044,16582,144130,-2960,0,0),

('Clan Hall -> Plains of Dion',12031,9980,173167,-3734,500,0),

('Clan Hall -> Piligrims Necropolis',12032,46428,127157,-3745,500,0),

('Clan Hall -> Giran Territory',12045,69373,155208,-3746,500,0),

('Clan Hall -> Center of Goddard Castle Town',12046,147728,-56331,-2776,0,0),

('Clan Hall -> North of Goddard Castle Town',12047,147731,-58930,-2976,0,0),

('Clan Hall -> East of Goddard Castle Town',12048,150561,-57489,-2976,0,0),

('Clan Hall -> West of Goddard Castle Town',12049,144866,-57464,-2976,0,0),

('Clan Hall -> Town of Aden',75015,147450,28081,-2294,500,0),

('Clan Hall -> Fields of Massacre',75016,179718,-7843,-3517,0,0),

('Clan Hall -> Town of Oren',75008,80847,54661,-1519,500,0),

('Clan Hall -> Ivory Tower',75009,85341,16151,-3673,500,0),

('Clan Hall -> Sea of Spores',75010,65085,22925,-3761,500,0),

('Clan Hall -> Forest of Evil',75011,104404,-151,-3421,500,0),

('Clan Hall -> Outlaw Forest',75012,86034,-2434,-3529,500,0),

('Clan Hall -> Border Outpost',75013,110647,-10087,-2017,500,0),

('Clan Hall -> Bandit Stronghold',75014,86825,-20028,-2009,0,0);

--

-- shut tele

--

INSERT INTO teleport VALUES

('Clan Hall -> Village Square',12061,87379,-142322,-1336,0,0),

('Clan Hall -> West Gate Entrance',12062,84753,-141051,-1536,0,0),

('Clan Hall -> South Gate Entrance',12063,87343,-139802,-1536,0,0),

('Clan Hall -> East Gate Entrance',12064,89959,-141034,-1536,0,0),

('Clan Hall -> Crypt of Disgrace',12065,47692,-115745,-3744,500,0),

('Clan Hall -> Plunderous Plains',12066,111965,-154172,-1528,500,0),

('Clan Hall -> Den of Evil',12067,68693,-110438,-1904,500,0),

('Clan Hall -> Frozen Labyrinth',12068,113903,-108752,-848,500,0),

-- Add castle TP

('Innadril(artifact -> out)',15000,116046,247094,-930,0,0),

('Innadril(artifact -> hall)',15001,116028,249163,-787,0,0),

('Innadril(artifact -> outofcastle)',15002,116373,244729,-1059,0,0),

('Innadril(hall -> out)',15004,116046,247094,-930,0,0),

('Innadril(hall -> outofcastle)',15005,116373,244729,-1059,0,0),

('Innadril(out -> artifact)',15006,116028,250136,-867,0,0),

('Innadril(out -> hall)',15007,116028,249163,-787,0,0),

('Innadril(out -> outofcastle)',15008,116373,244729,-1059,0,0),

('Innadril(outofcastle -> artifact)',15009,116028,250136,-867,0,0),

('Innadril(outofcastle -> out)',15010,116046,247094,-930,0,0),

('Innadril(outofcastle -> hall)',15011,116028,249163,-787,0,0),

('Goddard(artifact -> out)',15012,147466,-48514,-2085,0,0),

('Goddard(artifact -> hall)',15013,147463,-48504,-2277,0,0),

('Goddard(artifact -> outofcastle)',15014,147265,-44908,-2085,0,0),

('Goddard(hall -> artifact)',15015,146165,-50478,-1604,0,0),

('Goddard(hall -> out)',15016,147466,-48514,-2085,0,0),

('Goddard(hall -> outofcastle)',15017,147265,-44908,-2085,0,0),

('Goddard(out -> artifact)',15018,146165,-50478,-1604,0,0),

('Goddard(out -> hall)',15019,147463,-48504,-2277,0,0),

('Goddard(out -> outofcastle)',15020,147265,-44908,-2085,0,0),

('Goddard(outofcastle -> artifact)',15021,146165,-50478,-1604,0,0),

('Goddard(outofcastle -> out)',15022,147466,-48514,-2085,0,0),

('Goddard(outofcastle -> hall)',15023,147463,-48504,-2277,0,0),

('Rune(artifact -> outofcastle)',15025,19049,-49141,-1258,0,0),

('Rune(artifact -> out)',15026,16981,-49170,-1098,0,0),

('Rune(artifact -> hall)',15027,11729,-49154,-537,0,0),

('Rune(hall -> out)',15029,16981,-49170,-1098,0,0),

('Rune(hall -> outofcastle)',15030,19049,-49141,-1258,0,0),

('Rune(out -> hall)',15032,11732,-49154,-537,0,0),

('Rune(out -> outofcastle)',15033,19049,-49141,-1258,0,0),

('Rune(outofcastle -> hall)',15035,11729,-49154,-537,0,0),

('Rune(outofcastle -> out)',15036,16981,-49170,-1098,0,0),

('Schuttgart(hall -> outofcastle)',15037,77562,-149119,-353,0,0),

('Schuttgart(hall -> out)',15038,77501,-149943,-353,0,0),

('Schuttgart(hall -> artifact)',15039,77557,-154975,387,0,0),

('Schuttgart(out -> artifact)',15040,77557,-154975,387,0,0),

('Schuttgart(out -> outofcastle)',15041,77562,-149119,-353,0,0),

('Schuttgart(out -> hall)',15042,77547,-152461,-545,0,0),

('Schuttgart(outofcastle -> artifact)',15043,77557,-154975,387,0,0),

('Schuttgart(outofcastle -> out)',15044,77501,-149943,-353,0,0),

('Schuttgart(outofcastle -> hall)',15045,77547,-152461,-545,0,0),

('Schuttgart(artifact -> out)',15046,77501,-149943,-353,0,0),

('Schuttgart(artifact -> hall)',15047,77547,-152461,-545,0,0),

('Schuttgart(artifact -> outofcastle)',15048,77562,-149119,-353,0,0);

--

-- castle mass gk

--

INSERT INTO teleport VALUES

('Gludio Throne',60000,-18112,109413,-2496,0,0),

('Gludio Inside',60001,-18171,111572,-2649,0,0),

('Gludio Artefacts Room',60002,-18115,108365,-2590,0,0),

('Gludio Out of the Castle',60003,-18361,113887,-2767,0,0),

('Giran Throne',60004,116507,145095,-2563,0,0),

('Giran Inside',60005,114174,145058,-2751,0,0),

('Giran Artefacts Room',60006,117557,145092,-2644,0,0),

('Giran Out of the Castle',60007,112122,144855,-2751,0,0),

('Oren Throne',60008,82576,37189,-2290,0,0),

('Oren Inside',60009,80318,37174,-2561,0,0),

('Oren Artefacts Room',60010,83638,37180,-2371,0,0),

('Oren Out of the Castle',60011,78116,36961,-2458,0,0),

('Aden Throne',60012,147446,4652,-340,0,0),

('Aden Balcony',60013,147439,1120,218,0,0),

('Aden Inside',60014,147470,7902,-470,0,0),

('Aden Hall',60015,146372,4649,-403,0,0),

('Aden Artefacts Room',60016,147499,2544,-473,0,0),

('Aden Out of the Castle',60017,116025,10843,-736,0,0),

('Innadril Throne',60018,116025,249097,-787,0,0),

('Innadril Inside',60019,116026,246975,-967,0,0),

('Innadril Artefacts Room',60020,116033,250158,-867,0,0),

('Innadril Out of the Castle',60021,116265,244631,-1057,0,0),

('Goddard Throne',60022,147460,-48274,-2276,0,0),

('Goddard Inside',60023,145671,-46510,-1743,0,0),

('Goddard Artefacts Room',60024,148899,-50461,-1603,0,0),

('Goddard Out of the Castle',60025,147482,-45026,-2084,0,0),

('Dion Throne',60026,22074,160352,-2690,0,0),

('Dion Inside',60027,22150,158042,-2873,0,0),

('Dion Artefacts Room',60028,22078,161387,-2771,0,0),

('Dion Out of the Castle',60029,22306,156027,-2953,0,0),

('Rune Throne',60030,11780,-49153,-530,0,0),

('Rune Inside',60031,17252,-49160,-1125,0,0),

('Rune Artefacts Room',60032,10133,-49152,997,0,0),

('Rune Out of the Castle',60033,19118,-49136,-1266,0,0);

 

-- powerpack

 

INSERT INTO `teleport` VALUES ('ForbiddenPath', '2022', '112893', '84529', '-6541', '0', '0');

INSERT INTO `teleport` VALUES ('DarkOmen', '2021', '-20706', '13484', '-4901', '0', '0');

INSERT INTO `teleport` VALUES ('Witch', '2020', '139339', '79682', '-5429', '0', '0');

INSERT INTO `teleport` VALUES ('Apostate', '2019', '76549', '78429', '-5124', '0', '0');

INSERT INTO `teleport` VALUES ('Branded', '2018', '44953', '170285', '-4981', '0', '0');

INSERT INTO `teleport` VALUES ('Heretics', '2017', '41763', '143930', '-5407', '0', '0');

INSERT INTO `teleport` VALUES ('Dark Elven', '6012', '12090', '16698', '-4585', '0', '0');

INSERT INTO `teleport` VALUES ('Dwarven', '2501', '115332', '-178232', '-929', '0', '0');

INSERT INTO `teleport` VALUES ('Orc', '2503', '-44856', '-112381', '-240', '0', '0');

INSERT INTO `teleport` VALUES ('Elven', '2502', '47012', '50700', '-2996', '0', '0');

INSERT INTO `teleport` VALUES ('Talkong Island', '2504', '-83862', '243471', '-3730', '0', '0');

INSERT INTO `teleport` VALUES ('Rune', '2521', '43833', '-48346', '-797', '0', '0');

INSERT INTO `teleport` VALUES ('Oren', '2815', '82755', '53583', '-1522', '0', '0');

INSERT INTO `teleport` VALUES ('Goddard', '2520', '147728', '-55395', '-2759', '0', '0');

INSERT INTO `teleport` VALUES ('Aden', '2814', '147447', '25748', '-2013', '0', '0');

INSERT INTO `teleport` VALUES ('Innadril', '2816', '111396', '218917', '-3569', '0', '0');

INSERT INTO `teleport` VALUES ('Gludio', '7556', '-12683', '122716', '-3143', '0', '0');

INSERT INTO `teleport` VALUES ('Giran', '2808', '83026', '148631', '-3469', '0', '0');

INSERT INTO `teleport` VALUES ('Dion', '2505', '15641', '142961', '-2732', '0', '0');

INSERT INTO `teleport` VALUES ('Pavel Ruins', '5002', '88275', '-125690', '-3815', '0', '0');

INSERT INTO `teleport` VALUES ('Monastery of Silence', '5008', '106467', '-87805', '-2950', '0', '0');

INSERT INTO `teleport` VALUES ('Ice Queens Castle', '5000', '102492', '-124255', '-2771', '0', '0');

INSERT INTO `teleport` VALUES ('Town of Schuttgar', '5001', '87363', '-143348', '-1293', '0', '0');

INSERT INTO `teleport` VALUES ('Carons Dungeon', '5003', '69762', '-111260', '-1807', '0', '0');

INSERT INTO `teleport` VALUES ('Crypts of Disgrace', '5004', '56095', '-118952', '-3290', '0', '0');

INSERT INTO `teleport` VALUES ('Ice Merchant Cabin', '5005', '113453', '-109965', '-866', '0', '0');

INSERT INTO `teleport` VALUES ('Stakatonest', '5007', '89689', '-44691', '-2142', '0', '0');

INSERT INTO `teleport` VALUES ('Core', '5015', '17622', '111042', '-6655', '0', '0');

INSERT INTO `teleport` VALUES ('Quent Ant', '5017', '-21547', '180058', '-5834', '0', '0');

INSERT INTO `teleport` VALUES ('Orfen', '5016', '55467', '17289', '-5541', '0', '0');

INSERT INTO `teleport` VALUES ('Zaken', '1000006', '55553', '219381', '-3225', '0', '0');

INSERT INTO `teleport` VALUES ('Baium', '5013', '114034', '15437', '10077', '0', '0');

INSERT INTO `teleport` VALUES ('Antharas', '5012', '180981', '114858', '-7703', '0', '0');

INSERT INTO `teleport` VALUES ('Valakas', '5011', '210476', '-113600', '-138', '0', '0');

INSERT INTO `teleport` VALUES ('swamp', '2933', '-30742', '49730', '-3568', '0', '0');

INSERT INTO `teleport` VALUES ('Temple', '2934', '10845', '14502', '-4242', '0', '0');

INSERT INTO `teleport` VALUES ('school', '2931', '-49180', '49426', '-5916', '0', '0');

INSERT INTO `teleport` VALUES ('elvenFortess', '2946', '45873', '49288', '-3064', '0', '0');

INSERT INTO `teleport` VALUES ('irisLake', '2947', '48118', '72491', '-3481', '0', '0');

INSERT INTO `teleport` VALUES ('obtliVictory', '2877', '-99666', '237569', '-3562', '0', '0');

INSERT INTO `teleport` VALUES ('elvenruins', '2875', '-113342', '235325', '-3648', '0', '0');

INSERT INTO `teleport` VALUES ('talkinharbor', '2878', '-96804', '258705', '-3613', '0', '0');

INSERT INTO `teleport` VALUES ('savetrials', '2940', '9349', '-112499', '-2531', '0', '0');

INSERT INTO `teleport` VALUES ('frozen', '2941', '7615', '-138852', '-915', '0', '0');

INSERT INTO `teleport` VALUES ('mithril', '2942', '171963', '-173368', '3453', '0', '0');

INSERT INTO `teleport` VALUES ('abondoned', '2937', '139734', '-177458', '-1531', '0', '0');

INSERT INTO `teleport` VALUES ('floran', '2506', '16763', '170007', '-3493', '0', '0');

INSERT INTO `teleport` VALUES ('cruma', '2825', '17176', '114201', '-3440', '0', '0');

INSERT INTO `teleport` VALUES ('cruma1', '2826', '17737', '114119', '-11673', '0', '0');

INSERT INTO `teleport` VALUES ('cruma2', '2827', '17725', '108327', '-9058', '0', '0');

INSERT INTO `teleport` VALUES ('AtharasLair', '2822', '131426', '114452', '-3721', '0', '0');

INSERT INTO `teleport` VALUES ('DEvilIsle', '2954', '43403', '206864', '-3747', '0', '0');

INSERT INTO `teleport` VALUES ('giranharbor', '2953', '47921', '186665', '-3486', '0', '0');

INSERT INTO `teleport` VALUES ('hardins', '2952', '105891', '109761', '-3207', '0', '0');

INSERT INTO `teleport` VALUES ('breaka', '2949', '79794', '130617', '-3672', '0', '0');

INSERT INTO `teleport` VALUES ('ruinsArgony', '2965', '-42485', '120050', '-3514', '0', '0');

INSERT INTO `teleport` VALUES ('ruinsDespair', '2966', '-20047', '137622', '-33892', '0', '0');

INSERT INTO `teleport` VALUES ('AntNest', '2879', '-9983', '176472', '-4177', '0', '0');

INSERT INTO `teleport` VALUES ('Aligators', '2993', '126460', '174784', '-3074', '0', '0');

INSERT INTO `teleport` VALUES ('Filesolence', '2996', '82664', '183571', '-3592', '0', '0');

INSERT INTO `teleport` VALUES ('FileWhispers', '2997', '91203', '217092', '-3644', '0', '0');

INSERT INTO `teleport` VALUES ('GardenEva', '2817', '86008', '231050', '-3595', '0', '0');

INSERT INTO `teleport` VALUES ('Blazing', '2983', '159458', '-12933', '-2867', '0', '0');

INSERT INTO `teleport` VALUES ('Hunters', '2982', '116451', '76069', '-2730', '0', '0');

INSERT INTO `teleport` VALUES ('Coliseum', '2991', '146499', '46735', '-3435', '0', '0');

INSERT INTO `teleport` VALUES ('TOI', '2819', '120189', '16114', '-5135', '0', '0');

INSERT INTO `teleport` VALUES ('wallAgros', '2524', '165056', '-47846', '-3555', '0', '0');

INSERT INTO `teleport` VALUES ('varka', '2522', '125517', '-41246', '-3688', '0', '0');

INSERT INTO `teleport` VALUES ('HotSpring', '2532', '149063', '-112408', '-2076', '0', '0');

INSERT INTO `teleport` VALUES ('ketra', '2528', '147005', '-67119', '-3650', '0', '0');

INSERT INTO `teleport` VALUES ('forgenGods', '2530', '168995', '-116279', '-2449', '0', '0');

INSERT INTO `teleport` VALUES ('ivory', '2867', '85332', '16153', '-3694', '0', '0');

INSERT INTO `teleport` VALUES ('seaSpores', '2870', '64320', '26795', '-3763', '0', '0');

INSERT INTO `teleport` VALUES ('ValeySaints', '2527', '67985', '-72039', '-3748', '0', '0');

INSERT INTO `teleport` VALUES ('Forest', '2000', '52107', '-53940', '-3154', '0', '0');

INSERT INTO `teleport` VALUES ('SwampScreams', '2525', '69988', '-49910', '-3246', '0', '0');

INSERT INTO `teleport` VALUES ('RuneHarbor', '2001', '38014', '-38309', '-3609', '0', '0');

[werty 1]

Слухай я вроде сам уже понял пимер

('Rune -> Monastery of Silence',1105,123743,-75032,-2902,14000,0)

вместо моса я пишу DIon с координатами ?

Правельно?

[werty 1]

INSERT INTO `teleport` VALUES ('RuneHarbor', '2001', '38014', '-38309', '-3609', '0', '0');

И делаю такой запрос.

[rooti 764]

Слухай я вроде сам уже понял пимер

('Rune -> Monastery of Silence',1105,123743,-75032,-2902,14000,0)

вместо моса я пишу DIon с координатами ?

Правельно?

Все что угодно

('Rune -> Monastery of Silence',1105,123743,-75032,-2902,14000,0)

('название',IDномер,положение X, положение Y, положение Z,стоимость аден,для нублесов или нет (0,1))

 

как-то так

 

можешь даже руками, не делая sql запрос, вводить в naviсat'e

Изменено 10 ноября, 2013 пользователем rooti