L2J Server

Code: Select all

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE FROM `teleport` WHERE `id` >= '50001' AND `id` <= '50174'' at line 7[Msg] Finished - Unsuccessfully

Code: Select all

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);