12-19-2009, 02:49 AM
Люди, к вам есть кое-какие вопросы и просьба:
1) Очень прошу, дайте правильные настройки для Global GateKeeper (Финалка) для l2jServer. Сам ну просто никак. Всегда выдает ошибки при загрузке .sql файла в ДБ. Плизз вам:
INSERT IGNORE `custom_npc` (`id`,`idTemplate`,`name`,`serverSideName`,`title`,`serverSideTitle`,`class`,`collision_radius`,`collision_height`,`level`,`sex`,`type`,`attackrange`,`hp`,`mp`,`hpreg`,`mpreg`,`str`,`con`,`dex`,`int`,`wit`,`men`,`exp`,`sp`,`patk`,`pdef`,`matk`,`mdef`,`atkspd`,`aggro`,`matkspd`,`rhand`,`lhand`,`armor`,`walkspd`,`runspd`,`faction_id`,`faction_range`,`isUndead`,`absorb_level`,`absorb_type`) VALUES
(50023, 31275, 'Faith', 1, 'Global Gatekeeper', 1, 'NPC.a_teleporter_FHuman', 8.00, 25.00, 70, 'female', 'L2Teleporter', 40, 3862, 1494, NULL, NULL, 40, 43, 30, 21, 20, 10, 5879, 590, 1444, 514, 760, 381, 253, 0, 253, 0, 0, 0, 80, 120, NULL, NULL, 0, 0,'LAST_HIT'),
DELETE FROM `teleport` WHERE `id` >= '50001' AND `id` <= '50174';
INSERT INTO `teleport` VALUES
('Dark Elven Village', 50001, 9745, 15606, -4574, 15000, 0),
('Dwarven Village', 50002, 115113, -178212, -901, 15000, 0),
('Elven Village', 50003, 46934, 51467, -2977, 15000, 0),
('Orc Village', 50004, -44836, -112352, -239, 15000, 0),
('Talking Island', 50005, -84318, 244579, -3730, 15000, 0),
('Town Of Dion', 50006, 15670, 142983, -2705, 15000, 0),
('Floran Village', 50007, 17838, 170274, -3508, 15000, 0),
('Town Of Giran', 50008, 83400, 147943, -3404, 15000, 0),
('Gludin Village', 50009, -80826, 149775, -3043, 15000, 0),
('Town Of Gludio', 50010, -12672, 122776, -3116, 15000, 0),
('Hunters Village', 50011, 117110, 76883, -2695, 15000, 0),
('Town Of Aden [NE]', 50012, 159439, 21104, -3684, 15000, 0),
('Town Of Aden [SW]', 50013, 140434, 26222, -2530, 15000, 0),
('Town Of Aden', 50014, 147450, 26741, -2204, 15000, 0),
('Town Of Oren', 50015, 82956, 53162, -1495, 15000, 0),
('Town Of Heine', 50016, 107092, 219693, -3446, 15000, 0),
('The Garden Of Eva', 50017, 84543, 235022, -3756, 15000, 0),
('Cemetery', 50018, 172136, 20325, -3326, 15000, 0),
('The Giants Cave', 50019, 174528, 52683, -4369, 15000, 0),
('The Forest Of Mirrors', 50020, 150477, 85907, -2753, 15000, 0),
('Anghel Waterfall', 50021, 169026, 85272, -2092, 15000, 0),
('Dragon Valley Cave', 50022, 131355, 114451, -3718, 15000, 0),
('Lair End', 50023, 154623, 121134, -3809, 15000, 0),
('Lair Of Antharas', 50024, 173826, 115333, -7708, 15000, 0),
('Cruma Tower Entrance', 50025, 17192, 114178, -3439, 15000, 0),
('Cruma Tower 1nd Floor', 50026, 17724, 114004, -11672, 15000, 0),
('Cruma Tower 2nd floor', 50027, 17730, 108301, -9057, 15000, 0),
('Cruma Tower 3nd floor', 50028, 17719, 115430, -6582, 15000, 0),
('Cruma Tower Core Room', 50029, 17692, 112284, -6250, 15000, 0),
('Altar Of Rites', 50030, -45563, 73216, -3575, 15000, 0),
('School Of Dark Arts', 50031, -47129, 59678, -3336, 15000, 0),
('South Border', 50032, -61146, 99591, -3744, 15000, 0),
('Swamp', 50033, -14162, 44879, -3592, 15000, 0),
('Temple Of Shillen', 50034, 23965, 10989, -3723, 15000, 0),
('Undine Waterfall', 50035, -10972, 57808, -3717, 15000, 0),
('Waterfall (in)', 50036, -5162, 55702, -3483, 15000, 0),
('Abandoned Coal Mines [East]', 50037, 155535, -173560, 2495, 15000, 0),
('Abandoned Coal Mines [North]', 50038, 152375, -179887, 2495, 15000, 0),
('Abandoned Coal Mines [West]', 50039, 139783, -177260, -1539, 15000, 0),
('Cave Of Trials', 50040, 9954, -112487, -2470, 15000, 0),
('Frozen waterfall', 50041, 9621, -139945, -1353, 15000, 0),
('Mithril Mines', 50042, 179039, -184080, -319, 15000, 0),
('South Coast', 50043, -37955, -100767, -3774, 15000, 0),
('The Northeast Coast', 50044, 169008, -208272, -3504, 15000, 0),
('Antaras Circle', 50045, 40246, 58785, -3634, 15000, 0),
('Elven Fortress', 50046, 29205, 74948, -3775, 15000, 0),
('Iris Lake', 50047, 51746, 71559, -3427, 15000, 0),
('Shadow Of the Mother tree', 50048, 47932, 39729, -3466, 15000, 0),
('Death Path', 50049, 70000, 126636, -3804, 15000, 0),
('Dragon Valley [Entrance]', 50050, 72317, 117736, -3672, 15000, 0),
('Dragon Valley [Inside]', 50051, 84959, 110701, -3209, 15000, 0),
('Execution Grounds', 50052, 51055, 141959, -2869, 15000, 0),
('Giran Harbor', 50053, 47114, 187152, -3485, 15000, 0),
('The Partisan Hideway', 50054, 46897, 111567, -2069, 15000, 0),
('Abandoned Camp', 50055, -56742, 140569, -2625, 15000, 0),
('Gludin Arena', 50056, -88839, 142382, -3646, 15000, 0),
('Cliffside Estate', 50057, -94841, 147430, -2675, 15000, 0),
('Fellmere Lake', 50058, -66931, 120296, -3651, 15000, 0),
('Forgotten Temple', 50059, -53838, 179285, -4640, 15000, 0),
('Gludin Harbor', 50060, -89199, 149962, -3586, 15000, 0),
('Maphri\'s Thumb', 50061, -37689, 193124, -2208, 15000, 0),
('Orc Barracks', 50062, -90562, 108182, -3546, 15000, 0),
('Windy Hill', 50063, -84313, 87057, -3457, 15000, 0),
('Northern Neutral Zone', 50064, -10853, 75689, -3596, 15000, 0),
('Ruins Of Agony', 50065, -56235, 106668, -3773, 15000, 0),
('Ruins Of Despair', 50066, -20043, 137688, -3896, 15000, 0),
('Ivory Tower', 50067, 85332, 16186, -3673, 15000, 0),
('Northern Waterfall', 50068, 70833, 6426, -3639, 15000, 0),
('Enchanted Valley', 50069, 124113, 59232, -4587, 15000, 0),
('Sea Of Spores', 50070, 62425, 30856, -3779, 15000, 0),
('Sea Of Spores [Centre]', 50071, 54216, 23826, -5380, 15000, 0),
('Tower Of Insolence', 50072, 121685, 15749, -3852, 15000, 0),
('Cedric\'s Training Hall', 50073, -73145, 256520, -3126, 15000, 0),
('Einhovant\'s School Of Magic', 50074, -88406, 249168, -3576, 15000, 0),
('Elven Ruins', 50075, 48736, 248463, -6162, 15000, 0),
('Northern Coast', 50076, -101294, 212553, -3093, 15000, 0),
('Obelisk Of Victory', 50077, -99746, 237538, -3572, 15000, 0),
('Talking Island Harbor', 50078, -96041, 261133, -3483, 15000, 0),
('Ant\'s Nest', 50079, -26111, 173692, -4152, 15000, 0),
('South Entrance Of Wastlands', 50080, -17949, 205272, -3670, 15000, 0),
('Wastelands', 50081, -20893, 186060, -4108, 15000, 0),
('Border Outpost', 50082, 109699, -7908, -2902, 15000, 0),
('Blazing Swamp', 50083, 145835, -10995, -4424, 15000, 0),
('The End Thus For', 50084, 125439, -31083, -3862, 15000, 0),
('Aden Castle Cross', 50085, 147967, 4005, 4599, 15000, 0),
('Anghel Waterfall (Top Perch)', 50086, 174354, 90771, 1838, 15000, 0),
('Dwarven Tower', 50087, 106545, -175091, 1300, 15000, 0),
('Partisan Fall', 50088, 49552, 116839, -2131, 15000, 0),
('Devastated Castle', 50089, 178283, -15739, -2262, 15000, 0),
('Bandits Stronghold', 50090, 82662, -15977, -1893, 15000, 0),
('Coliseum', 50091, 150086, 46733, -3412, 15000, 0),
('Innadril Castle', 50092, 116207, 244184, -1084, 15000, 0),
('Alligator Island', 50093, 100887, 172943, -3724, 15000, 0),
('Pirate\'s Tunnel', 50094, 41602, 199340, -4636, 15000, 0),
('Devil\'s Isle', 50095, 42006, 208234, -3756, 15000, 0),
('Field Of Silence', 50096, 84904, 182410, -3670, 15000, 0),
('Field Of Whispers', 50097, 86519, 211911, -3764, 15000, 0),
('Town Of Goddard', 50098, 147591, -56359, -2807, 15000, 0),
('Town Of Rune', 50099, 45843, -47929, -823, 15000, 0),
('Varka Silenos Outpost', 50100, 125893, -40901, -3776, 15000, 0),
('Canyon 2', 50101, 193752, -46075, -2954, 15000, 0),
('Walls Of Argos', 50102, 184380, -62690, -3000, 15000, 0),
('Swamp Of Screams', 50103, 91317, -57174, -2991, 15000, 0),
('Beast Farm', 50104, 52816, -81617, -2751, 15000, 0),
('Valley Of Saints', 50105, 64352, -71206, -3714, 15000, 0),
('Ketra Orc Outpost', 50106, 130512, -72326, -3538, 15000, 0),
('Lakes', 50107, 144621, -105540, -3682, 15000, 0),
('Forge Of The Gods', 50108, 170193, -116256, -2084, 15000, 0),
('Cave 2', 50109, 190403, -108821, -3314, 15000, 0),
('Hot Springs Guild House', 50110, 141213, -122118, -1961, 15000, 0),
('Temple Of Pilgrims', 50111, 168618, -86602, -3021, 15000, 0),
('Imperial Graveyard', 50112, 187120, -75490, -2848, 15000, 0),
('Coliseum Ruins', 50113, -20800, 20906, -3051, 15000, 0),
('Hot Springs Region', 50114, 154482, -126560, -2311, 15000, 0),
('Lair Of Valakas Crystal', 50115, 190188, -106425, -810, 15000, 0),
('Forest Of The Dead', 50116, 63379, -48912, -3164, 15000, 0),
('Rune Harbor', 50117, 38030, -38074, -3668, 15000, 0),
('TOI - 1st Floor', 50118, 115168, 16022, -5100, 15000, 0),
('TOI - 2nd Floor', 50119, 114649, 18587, -3609, 15000, 0),
('TOI - 3rd Floor', 50120, 117918, 16039, -2127, 15000, 0),
('TOI - 4th Floor', 50121, 114622, 12946, -645, 15000, 0),
('TOI - 5th Floor', 50122, 112209, 16078, 928, 15000, 0),
('TOI - 6th Floor', 50123, 112376, 16099, 1947, 15000, 0),
('TOI - 7th Floor', 50124, 115091, 12165, 2957, 15000, 0),
('TOI - 8th Floor', 50125, 111063, 16118, 3967, 15000, 0),
('TOI - 9th Floor', 50126, 117147, 18415, 4977, 15000, 0),
('TOI - 10th Floor', 50127, 118374, 15973, 5987, 15000, 0),
('TOI - 11th Floor', 50128, 112716, 14150, 6997, 15000, 0),
('TOI - 12th Floor', 50129, 114809, 18711, 7996, 15000, 0),
('TOI - 13th Floor', 50130, 115178, 16989, 9007, 15000, 0),
('TOI - 14th Floor Outside Door', 50131, 112714, 14111, 10077, 15000, 0),
('TOI - 14th Floor Inside On RoOf', 50132, 113098, 14532, 10077, 15000, 0),
('The Forbidden Gateway', 50133, 185395, 20359, -3270, 15000, 0),
('Cat Heretics Entrance', 50134, -53187, -250271, -7906, 15000, 0),
('Cat Branded Entrance', 50135, 46529, 170248, -4979, 15000, 0),
('Cat Apostate Entrance', 50136, -20248, -250791, -8163, 15000, 0),
('Cat Witch Entrance', 50137, 140404, 79678, -5431, 15000, 0),
('Cat DarkOmen Entrance', 50138, -19500, 13508, -4905, 15000, 0),
('Cat Forbidden Path Entrance', 50139, 12519, -248498, -9580, 15000, 0),
('Necro Sacrifice Entrance', 50140, -41570, 209785, -5089, 15000, 0),
('Necro Pilgrims Entrance', 50141, 45251, 123890, -5415, 15000, 0),
('Necro Worshippers Entrance', 50142, 111273, 174015, -5417, 15000, 0),
('Necro Patriots Entrance', 50143, -21726, 77385, -5177, 15000, 0),
('Necro Ascetics Entrance', 50144, -52254, 79103, -4743, 15000, 0),
('Necro Martyrs Entrance', 50145, 118308, 132800, -4833, 15000, 0),
('Necro Saints Entrance', 50146, 83000, 209213, -5443, 15000, 0),
('Necro Disciples Entrance', 50147, 172251, -17605, -4903, 15000, 0),
('Town Of Schuttgart', 50148, 87386, -143246, -1293, 15000, 0),
('Schuttgart Castle', 50149, 77394, -147197, -476, 15000, 0),
('Rune Castle', 50150, 21216, -49081, -1301, 15000, 0),
('Monastery Of Silence', 50151, 123743, -75032, -2902, 15000, 0),
('Crypts Of Disgrace', 50152, 56095, -118952, -3290, 15000, 0),
('Den Of Evil', 50153, 76860, -125169, -3414, 15000, 0),
('Frost Lake', 50154, 108090, -120925, -3628, 15000, 0),
('The Ice Queens Castle', 50155, 109060, -128655, -3084, 15000, 0),
('Ice Merchant Cabin', 50156, 113487, -109888, -865, 15000, 0),
('Valley Of The Lords', 50157, 23006, -126115, -870, 15000, 0),
('Pavel Ruins', 50158, 88275, -125690, -3815, 15000, 0),
('Plunderous Plains', 50159, 113900, -154175, -1488, 15000, 0),
('Stakato Nest', 50160, 89880, -44515, -2135, 15000, 0),
('Wild Beast Reserve', 50161, 57849, -93182, -1360, 15000, 0),
('Graverobber Hideout', 50162, 48336, -107734, -1577, 15000, 0),
('Carons Dungeon', 50163, 69762, -111260, -1807, 15000, 0),
('Race Track', 50164, 152610, -126325, -2230, 15000, 0),
('Windtail Waterfall', 50165, 40825, -90317, -3095, 15000, 0),
('Archaic Laboratory', 50166, 87475, -109835, -3330, 15000, 0),
('Fortress Of The Dead', 50167, 58000, -30767, 380, 15000, 0),
('Rainbow Springs Chateau', 50168, 141377, -123793, -1906, 15000, 0),
('Sky Wagon Relic', 50169, 117715, -141750, -2700, 15000, 0),
('Brigand Stronghold', 50170, 124585, -16024, -1180, 15000, 0),
('Lost Nest', 50171, 26174, -17134, -2747, 15000, 0),
('Primeval Plains', 50172, 8264, -14431, -3696, 15000, 0),
('Primeval Isle Wharf', 50173, 10468, -24569, -3650, 15000, 0),
('Research Facility', 50174, 6229, -2924, -2965, 15000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Nornil Cave Entrance', 65544, -86944, 44284, -2631, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Nornil Garden Dunjeon', 65545, -124450, 71670, 2000, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Sacrifice 1', 65546, -122256, 73151, -2871, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Sacrifice 2', 65547, -95449, 52479, -2030, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Sacrifice 3', 65548, -86228, 36988, -2052, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Kamael Temple', 65549, -123854, 38108, 1179, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Little Temple', 65550, -100255, 45125, -2395, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Kamael Waterfall', 65551, -119350, 54484, -1522, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Hellbound Temple Ruins', 65552, -27306, 255648, -1943, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island The Alien Totem', 65553, -24283, 246839, -3136, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island 1st Village', 65554, -23776, 251600, -3371, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island 1st Village underfloo', 65555, -26075, 251910, -3255, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Hellbound desert', 65556, -14921, 253794, -3449, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Hellbound mine', 65557, -6836, 243489, -2099, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Hellbound port', 65558, -11810, 236203, -3270, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Cursed Hellbound entrance', 65559, 246, 235127, -3267, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Hellbound Town', 65560, 19491, 253859, -2025, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Tent village', 65561, 9171, 249588, -1961, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Cave', 65562, 10357, 244676, -2003, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Forge of nightmare', 65563, 28605, 242590, -3533, 5000, 0);
DELETE FROM `custom_spawnlist` WHERE `npc_templateid`='50023';
INSERT INTO `custom_spawnlist` (`location`, `count`, `npc_templateid`, `locx`, `locy`, `locz`, `randomx`, `randomy`, `heading`, `respawn_delay`, `loc_id`) VALUES
('', 1, 50023, 82739, 147829, -3469, 0, 0, 25320, 60, 0),
('', 1, 50023, -81617, 150245, -3129, 0, 0, 16059, 60, 0),
('', 1, 50023, 22075, 160330, -2691, 0, 0, 35808, 60, 0),
('', 1, 50023, 82179, 36979, -2333, 0, 0, 12516, 60, 0),
('', 1, 50023, 116099, 144859, -2606, 0, 0 ,6712, 60, 0),
('', 1, 50023, 119497, 158731, -3776, 0, 0 , 48247, 60, 0),
('', 1, 50023, 115482, -179701, -909, 0, 0 , 19084, 60, 0),
('', 1, 50023, 10550, 17421, -4611, 0, 0, 47475, 60, 0),
('', 1, 50023, 47814, 48638, -3022, 0, 0, 27932, 60, 0),
('', 1, 50023, -45970, -111591, -265, 0, 0, 64792, 60, 0),
('', 1, 50023, -84518, 241674, -3755, 0, 0, 34283, 60, 0),
('', 1, 50023, 18026, 145293, -3075, 0, 0, 6712, 60, 0),
('', 1, 50023, 17245, 169873, -3525, 0, 0, 14326, 60, 0),
('', 1, 50023, -14546, 124463, -3147, 0, 0, 62852, 60, 0),
('', 1, 50023, 115890, 75048, -2625, 0, 0, 23096, 60, 0),
('', 1, 50023, 146532, 28547, -2295, 0, 0, 56795, 60, 0),
('', 1, 50023, 108415, 219272, -3701, 0, 0, 41760, 60, 0),
('', 1, 50023, 82884, 55404, -1551, 0, 0, 15911, 60, 0),
('', 1, 50023, 115871, 249203, -813, 0, 0, 59899, 60, 0),
('', 1, 50023, 147460, -55255, -2734, 0, 0, 56189, 60, 0);
2) Как сделать бесконечными соски для l2jserver (*rev.6767 у меня)? Нужна ваша помощь. Жду советов. Заранее вам благодарен.
1) Очень прошу, дайте правильные настройки для Global GateKeeper (Финалка) для l2jServer. Сам ну просто никак. Всегда выдает ошибки при загрузке .sql файла в ДБ. Плизз вам:
INSERT IGNORE `custom_npc` (`id`,`idTemplate`,`name`,`serverSideName`,`title`,`serverSideTitle`,`class`,`collision_radius`,`collision_height`,`level`,`sex`,`type`,`attackrange`,`hp`,`mp`,`hpreg`,`mpreg`,`str`,`con`,`dex`,`int`,`wit`,`men`,`exp`,`sp`,`patk`,`pdef`,`matk`,`mdef`,`atkspd`,`aggro`,`matkspd`,`rhand`,`lhand`,`armor`,`walkspd`,`runspd`,`faction_id`,`faction_range`,`isUndead`,`absorb_level`,`absorb_type`) VALUES
(50023, 31275, 'Faith', 1, 'Global Gatekeeper', 1, 'NPC.a_teleporter_FHuman', 8.00, 25.00, 70, 'female', 'L2Teleporter', 40, 3862, 1494, NULL, NULL, 40, 43, 30, 21, 20, 10, 5879, 590, 1444, 514, 760, 381, 253, 0, 253, 0, 0, 0, 80, 120, NULL, NULL, 0, 0,'LAST_HIT'),
DELETE FROM `teleport` WHERE `id` >= '50001' AND `id` <= '50174';
INSERT INTO `teleport` VALUES
('Dark Elven Village', 50001, 9745, 15606, -4574, 15000, 0),
('Dwarven Village', 50002, 115113, -178212, -901, 15000, 0),
('Elven Village', 50003, 46934, 51467, -2977, 15000, 0),
('Orc Village', 50004, -44836, -112352, -239, 15000, 0),
('Talking Island', 50005, -84318, 244579, -3730, 15000, 0),
('Town Of Dion', 50006, 15670, 142983, -2705, 15000, 0),
('Floran Village', 50007, 17838, 170274, -3508, 15000, 0),
('Town Of Giran', 50008, 83400, 147943, -3404, 15000, 0),
('Gludin Village', 50009, -80826, 149775, -3043, 15000, 0),
('Town Of Gludio', 50010, -12672, 122776, -3116, 15000, 0),
('Hunters Village', 50011, 117110, 76883, -2695, 15000, 0),
('Town Of Aden [NE]', 50012, 159439, 21104, -3684, 15000, 0),
('Town Of Aden [SW]', 50013, 140434, 26222, -2530, 15000, 0),
('Town Of Aden', 50014, 147450, 26741, -2204, 15000, 0),
('Town Of Oren', 50015, 82956, 53162, -1495, 15000, 0),
('Town Of Heine', 50016, 107092, 219693, -3446, 15000, 0),
('The Garden Of Eva', 50017, 84543, 235022, -3756, 15000, 0),
('Cemetery', 50018, 172136, 20325, -3326, 15000, 0),
('The Giants Cave', 50019, 174528, 52683, -4369, 15000, 0),
('The Forest Of Mirrors', 50020, 150477, 85907, -2753, 15000, 0),
('Anghel Waterfall', 50021, 169026, 85272, -2092, 15000, 0),
('Dragon Valley Cave', 50022, 131355, 114451, -3718, 15000, 0),
('Lair End', 50023, 154623, 121134, -3809, 15000, 0),
('Lair Of Antharas', 50024, 173826, 115333, -7708, 15000, 0),
('Cruma Tower Entrance', 50025, 17192, 114178, -3439, 15000, 0),
('Cruma Tower 1nd Floor', 50026, 17724, 114004, -11672, 15000, 0),
('Cruma Tower 2nd floor', 50027, 17730, 108301, -9057, 15000, 0),
('Cruma Tower 3nd floor', 50028, 17719, 115430, -6582, 15000, 0),
('Cruma Tower Core Room', 50029, 17692, 112284, -6250, 15000, 0),
('Altar Of Rites', 50030, -45563, 73216, -3575, 15000, 0),
('School Of Dark Arts', 50031, -47129, 59678, -3336, 15000, 0),
('South Border', 50032, -61146, 99591, -3744, 15000, 0),
('Swamp', 50033, -14162, 44879, -3592, 15000, 0),
('Temple Of Shillen', 50034, 23965, 10989, -3723, 15000, 0),
('Undine Waterfall', 50035, -10972, 57808, -3717, 15000, 0),
('Waterfall (in)', 50036, -5162, 55702, -3483, 15000, 0),
('Abandoned Coal Mines [East]', 50037, 155535, -173560, 2495, 15000, 0),
('Abandoned Coal Mines [North]', 50038, 152375, -179887, 2495, 15000, 0),
('Abandoned Coal Mines [West]', 50039, 139783, -177260, -1539, 15000, 0),
('Cave Of Trials', 50040, 9954, -112487, -2470, 15000, 0),
('Frozen waterfall', 50041, 9621, -139945, -1353, 15000, 0),
('Mithril Mines', 50042, 179039, -184080, -319, 15000, 0),
('South Coast', 50043, -37955, -100767, -3774, 15000, 0),
('The Northeast Coast', 50044, 169008, -208272, -3504, 15000, 0),
('Antaras Circle', 50045, 40246, 58785, -3634, 15000, 0),
('Elven Fortress', 50046, 29205, 74948, -3775, 15000, 0),
('Iris Lake', 50047, 51746, 71559, -3427, 15000, 0),
('Shadow Of the Mother tree', 50048, 47932, 39729, -3466, 15000, 0),
('Death Path', 50049, 70000, 126636, -3804, 15000, 0),
('Dragon Valley [Entrance]', 50050, 72317, 117736, -3672, 15000, 0),
('Dragon Valley [Inside]', 50051, 84959, 110701, -3209, 15000, 0),
('Execution Grounds', 50052, 51055, 141959, -2869, 15000, 0),
('Giran Harbor', 50053, 47114, 187152, -3485, 15000, 0),
('The Partisan Hideway', 50054, 46897, 111567, -2069, 15000, 0),
('Abandoned Camp', 50055, -56742, 140569, -2625, 15000, 0),
('Gludin Arena', 50056, -88839, 142382, -3646, 15000, 0),
('Cliffside Estate', 50057, -94841, 147430, -2675, 15000, 0),
('Fellmere Lake', 50058, -66931, 120296, -3651, 15000, 0),
('Forgotten Temple', 50059, -53838, 179285, -4640, 15000, 0),
('Gludin Harbor', 50060, -89199, 149962, -3586, 15000, 0),
('Maphri\'s Thumb', 50061, -37689, 193124, -2208, 15000, 0),
('Orc Barracks', 50062, -90562, 108182, -3546, 15000, 0),
('Windy Hill', 50063, -84313, 87057, -3457, 15000, 0),
('Northern Neutral Zone', 50064, -10853, 75689, -3596, 15000, 0),
('Ruins Of Agony', 50065, -56235, 106668, -3773, 15000, 0),
('Ruins Of Despair', 50066, -20043, 137688, -3896, 15000, 0),
('Ivory Tower', 50067, 85332, 16186, -3673, 15000, 0),
('Northern Waterfall', 50068, 70833, 6426, -3639, 15000, 0),
('Enchanted Valley', 50069, 124113, 59232, -4587, 15000, 0),
('Sea Of Spores', 50070, 62425, 30856, -3779, 15000, 0),
('Sea Of Spores [Centre]', 50071, 54216, 23826, -5380, 15000, 0),
('Tower Of Insolence', 50072, 121685, 15749, -3852, 15000, 0),
('Cedric\'s Training Hall', 50073, -73145, 256520, -3126, 15000, 0),
('Einhovant\'s School Of Magic', 50074, -88406, 249168, -3576, 15000, 0),
('Elven Ruins', 50075, 48736, 248463, -6162, 15000, 0),
('Northern Coast', 50076, -101294, 212553, -3093, 15000, 0),
('Obelisk Of Victory', 50077, -99746, 237538, -3572, 15000, 0),
('Talking Island Harbor', 50078, -96041, 261133, -3483, 15000, 0),
('Ant\'s Nest', 50079, -26111, 173692, -4152, 15000, 0),
('South Entrance Of Wastlands', 50080, -17949, 205272, -3670, 15000, 0),
('Wastelands', 50081, -20893, 186060, -4108, 15000, 0),
('Border Outpost', 50082, 109699, -7908, -2902, 15000, 0),
('Blazing Swamp', 50083, 145835, -10995, -4424, 15000, 0),
('The End Thus For', 50084, 125439, -31083, -3862, 15000, 0),
('Aden Castle Cross', 50085, 147967, 4005, 4599, 15000, 0),
('Anghel Waterfall (Top Perch)', 50086, 174354, 90771, 1838, 15000, 0),
('Dwarven Tower', 50087, 106545, -175091, 1300, 15000, 0),
('Partisan Fall', 50088, 49552, 116839, -2131, 15000, 0),
('Devastated Castle', 50089, 178283, -15739, -2262, 15000, 0),
('Bandits Stronghold', 50090, 82662, -15977, -1893, 15000, 0),
('Coliseum', 50091, 150086, 46733, -3412, 15000, 0),
('Innadril Castle', 50092, 116207, 244184, -1084, 15000, 0),
('Alligator Island', 50093, 100887, 172943, -3724, 15000, 0),
('Pirate\'s Tunnel', 50094, 41602, 199340, -4636, 15000, 0),
('Devil\'s Isle', 50095, 42006, 208234, -3756, 15000, 0),
('Field Of Silence', 50096, 84904, 182410, -3670, 15000, 0),
('Field Of Whispers', 50097, 86519, 211911, -3764, 15000, 0),
('Town Of Goddard', 50098, 147591, -56359, -2807, 15000, 0),
('Town Of Rune', 50099, 45843, -47929, -823, 15000, 0),
('Varka Silenos Outpost', 50100, 125893, -40901, -3776, 15000, 0),
('Canyon 2', 50101, 193752, -46075, -2954, 15000, 0),
('Walls Of Argos', 50102, 184380, -62690, -3000, 15000, 0),
('Swamp Of Screams', 50103, 91317, -57174, -2991, 15000, 0),
('Beast Farm', 50104, 52816, -81617, -2751, 15000, 0),
('Valley Of Saints', 50105, 64352, -71206, -3714, 15000, 0),
('Ketra Orc Outpost', 50106, 130512, -72326, -3538, 15000, 0),
('Lakes', 50107, 144621, -105540, -3682, 15000, 0),
('Forge Of The Gods', 50108, 170193, -116256, -2084, 15000, 0),
('Cave 2', 50109, 190403, -108821, -3314, 15000, 0),
('Hot Springs Guild House', 50110, 141213, -122118, -1961, 15000, 0),
('Temple Of Pilgrims', 50111, 168618, -86602, -3021, 15000, 0),
('Imperial Graveyard', 50112, 187120, -75490, -2848, 15000, 0),
('Coliseum Ruins', 50113, -20800, 20906, -3051, 15000, 0),
('Hot Springs Region', 50114, 154482, -126560, -2311, 15000, 0),
('Lair Of Valakas Crystal', 50115, 190188, -106425, -810, 15000, 0),
('Forest Of The Dead', 50116, 63379, -48912, -3164, 15000, 0),
('Rune Harbor', 50117, 38030, -38074, -3668, 15000, 0),
('TOI - 1st Floor', 50118, 115168, 16022, -5100, 15000, 0),
('TOI - 2nd Floor', 50119, 114649, 18587, -3609, 15000, 0),
('TOI - 3rd Floor', 50120, 117918, 16039, -2127, 15000, 0),
('TOI - 4th Floor', 50121, 114622, 12946, -645, 15000, 0),
('TOI - 5th Floor', 50122, 112209, 16078, 928, 15000, 0),
('TOI - 6th Floor', 50123, 112376, 16099, 1947, 15000, 0),
('TOI - 7th Floor', 50124, 115091, 12165, 2957, 15000, 0),
('TOI - 8th Floor', 50125, 111063, 16118, 3967, 15000, 0),
('TOI - 9th Floor', 50126, 117147, 18415, 4977, 15000, 0),
('TOI - 10th Floor', 50127, 118374, 15973, 5987, 15000, 0),
('TOI - 11th Floor', 50128, 112716, 14150, 6997, 15000, 0),
('TOI - 12th Floor', 50129, 114809, 18711, 7996, 15000, 0),
('TOI - 13th Floor', 50130, 115178, 16989, 9007, 15000, 0),
('TOI - 14th Floor Outside Door', 50131, 112714, 14111, 10077, 15000, 0),
('TOI - 14th Floor Inside On RoOf', 50132, 113098, 14532, 10077, 15000, 0),
('The Forbidden Gateway', 50133, 185395, 20359, -3270, 15000, 0),
('Cat Heretics Entrance', 50134, -53187, -250271, -7906, 15000, 0),
('Cat Branded Entrance', 50135, 46529, 170248, -4979, 15000, 0),
('Cat Apostate Entrance', 50136, -20248, -250791, -8163, 15000, 0),
('Cat Witch Entrance', 50137, 140404, 79678, -5431, 15000, 0),
('Cat DarkOmen Entrance', 50138, -19500, 13508, -4905, 15000, 0),
('Cat Forbidden Path Entrance', 50139, 12519, -248498, -9580, 15000, 0),
('Necro Sacrifice Entrance', 50140, -41570, 209785, -5089, 15000, 0),
('Necro Pilgrims Entrance', 50141, 45251, 123890, -5415, 15000, 0),
('Necro Worshippers Entrance', 50142, 111273, 174015, -5417, 15000, 0),
('Necro Patriots Entrance', 50143, -21726, 77385, -5177, 15000, 0),
('Necro Ascetics Entrance', 50144, -52254, 79103, -4743, 15000, 0),
('Necro Martyrs Entrance', 50145, 118308, 132800, -4833, 15000, 0),
('Necro Saints Entrance', 50146, 83000, 209213, -5443, 15000, 0),
('Necro Disciples Entrance', 50147, 172251, -17605, -4903, 15000, 0),
('Town Of Schuttgart', 50148, 87386, -143246, -1293, 15000, 0),
('Schuttgart Castle', 50149, 77394, -147197, -476, 15000, 0),
('Rune Castle', 50150, 21216, -49081, -1301, 15000, 0),
('Monastery Of Silence', 50151, 123743, -75032, -2902, 15000, 0),
('Crypts Of Disgrace', 50152, 56095, -118952, -3290, 15000, 0),
('Den Of Evil', 50153, 76860, -125169, -3414, 15000, 0),
('Frost Lake', 50154, 108090, -120925, -3628, 15000, 0),
('The Ice Queens Castle', 50155, 109060, -128655, -3084, 15000, 0),
('Ice Merchant Cabin', 50156, 113487, -109888, -865, 15000, 0),
('Valley Of The Lords', 50157, 23006, -126115, -870, 15000, 0),
('Pavel Ruins', 50158, 88275, -125690, -3815, 15000, 0),
('Plunderous Plains', 50159, 113900, -154175, -1488, 15000, 0),
('Stakato Nest', 50160, 89880, -44515, -2135, 15000, 0),
('Wild Beast Reserve', 50161, 57849, -93182, -1360, 15000, 0),
('Graverobber Hideout', 50162, 48336, -107734, -1577, 15000, 0),
('Carons Dungeon', 50163, 69762, -111260, -1807, 15000, 0),
('Race Track', 50164, 152610, -126325, -2230, 15000, 0),
('Windtail Waterfall', 50165, 40825, -90317, -3095, 15000, 0),
('Archaic Laboratory', 50166, 87475, -109835, -3330, 15000, 0),
('Fortress Of The Dead', 50167, 58000, -30767, 380, 15000, 0),
('Rainbow Springs Chateau', 50168, 141377, -123793, -1906, 15000, 0),
('Sky Wagon Relic', 50169, 117715, -141750, -2700, 15000, 0),
('Brigand Stronghold', 50170, 124585, -16024, -1180, 15000, 0),
('Lost Nest', 50171, 26174, -17134, -2747, 15000, 0),
('Primeval Plains', 50172, 8264, -14431, -3696, 15000, 0),
('Primeval Isle Wharf', 50173, 10468, -24569, -3650, 15000, 0),
('Research Facility', 50174, 6229, -2924, -2965, 15000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Nornil Cave Entrance', 65544, -86944, 44284, -2631, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Nornil Garden Dunjeon', 65545, -124450, 71670, 2000, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Sacrifice 1', 65546, -122256, 73151, -2871, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Sacrifice 2', 65547, -95449, 52479, -2030, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Sacrifice 3', 65548, -86228, 36988, -2052, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Kamael Temple', 65549, -123854, 38108, 1179, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Little Temple', 65550, -100255, 45125, -2395, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Kamael Waterfall', 65551, -119350, 54484, -1522, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Hellbound Temple Ruins', 65552, -27306, 255648, -1943, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island The Alien Totem', 65553, -24283, 246839, -3136, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island 1st Village', 65554, -23776, 251600, -3371, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island 1st Village underfloo', 65555, -26075, 251910, -3255, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Hellbound desert', 65556, -14921, 253794, -3449, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Hellbound mine', 65557, -6836, 243489, -2099, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Hellbound port', 65558, -11810, 236203, -3270, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Cursed Hellbound entrance', 65559, 246, 235127, -3267, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Hellbound Town', 65560, 19491, 253859, -2025, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Tent village', 65561, 9171, 249588, -1961, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Cave', 65562, 10357, 244676, -2003, 5000, 0);
REPLACE INTO teleport VALUES ('Kamael Island Forge of nightmare', 65563, 28605, 242590, -3533, 5000, 0);
DELETE FROM `custom_spawnlist` WHERE `npc_templateid`='50023';
INSERT INTO `custom_spawnlist` (`location`, `count`, `npc_templateid`, `locx`, `locy`, `locz`, `randomx`, `randomy`, `heading`, `respawn_delay`, `loc_id`) VALUES
('', 1, 50023, 82739, 147829, -3469, 0, 0, 25320, 60, 0),
('', 1, 50023, -81617, 150245, -3129, 0, 0, 16059, 60, 0),
('', 1, 50023, 22075, 160330, -2691, 0, 0, 35808, 60, 0),
('', 1, 50023, 82179, 36979, -2333, 0, 0, 12516, 60, 0),
('', 1, 50023, 116099, 144859, -2606, 0, 0 ,6712, 60, 0),
('', 1, 50023, 119497, 158731, -3776, 0, 0 , 48247, 60, 0),
('', 1, 50023, 115482, -179701, -909, 0, 0 , 19084, 60, 0),
('', 1, 50023, 10550, 17421, -4611, 0, 0, 47475, 60, 0),
('', 1, 50023, 47814, 48638, -3022, 0, 0, 27932, 60, 0),
('', 1, 50023, -45970, -111591, -265, 0, 0, 64792, 60, 0),
('', 1, 50023, -84518, 241674, -3755, 0, 0, 34283, 60, 0),
('', 1, 50023, 18026, 145293, -3075, 0, 0, 6712, 60, 0),
('', 1, 50023, 17245, 169873, -3525, 0, 0, 14326, 60, 0),
('', 1, 50023, -14546, 124463, -3147, 0, 0, 62852, 60, 0),
('', 1, 50023, 115890, 75048, -2625, 0, 0, 23096, 60, 0),
('', 1, 50023, 146532, 28547, -2295, 0, 0, 56795, 60, 0),
('', 1, 50023, 108415, 219272, -3701, 0, 0, 41760, 60, 0),
('', 1, 50023, 82884, 55404, -1551, 0, 0, 15911, 60, 0),
('', 1, 50023, 115871, 249203, -813, 0, 0, 59899, 60, 0),
('', 1, 50023, 147460, -55255, -2734, 0, 0, 56189, 60, 0);
2) Как сделать бесконечными соски для l2jserver (*rev.6767 у меня)? Нужна ваша помощь. Жду советов. Заранее вам благодарен.
