l2topzone.com
l2topzone.com

Author Topic: [Help] Custom Gatekeeper  (Read 2276 times)

0 Members and 1 Guest are viewing this topic.

OfflineRampage

  • Newbie
  • *
  • Posts: 16
  • L2topzone Votes: 1
  • Servers reviews: 0
  • Country: United Kingdom.
  • Reputation: +100/-0
    [Help] Custom Gatekeeper
    « on: August 20, 2010, 09:27:10 AM »
    l2topzone.com
    ok ive found a custom gatekeeper for epilogue but when i try and add it i get alot of errors. im new to all this custom stuff so unsure what im doing. if sum1 cud tell me what im doing wrong i will be greatfull.

    [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
    '70','female','L2Teleporter','40','1','1','1','1','1','1','1','1','1','1','1','1'' at line 2
    [Err] INSERT INTO `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`,`ss`,`bss`,`ss_rate`,`AI`)
    VALUES
    ('50023','30080','GK','1','Gatekeeper','1','LineageNPC.a_teleporter_FHuman','8','25',','70','female',
    'L2Teleporter','40','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','0',
    '0','1','0','1','1','1','0','LAST_HIT','false'

    DELETE FROM `teleport` WHERE `id` >= '50001' AND `id` <= '50174';

    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),
    ('
    [Msg] Finished - Unsuccessfully

    Linkback: https://l2topzone.com/forum/l2-requests/18/help-custom-gatekeeper/1452/
    « Last Edit: August 20, 2010, 09:30:32 AM by Rampage »

    OfflineDestiny

    • Full Member
    • ***
    • Posts: 218
    • L2topzone Votes: 0
    • Servers reviews: 0
    • Country: Greece.
    • Reputation: +482/-0
    • Gender: Male
      Re: [Help] Custom Gatekeeper
      « Reply #1 on: August 20, 2010, 04:12:28 PM »
      write all the teleports. the problem is on the syntax. if you don't give everything, we can't help you..

      OfflineRampage

      • Newbie
      • *
      • Posts: 16
      • L2topzone Votes: 1
      • Servers reviews: 0
      • Country: United Kingdom.
      • Reputation: +100/-0
        Re: [Help] Custom Gatekeeper
        « Reply #2 on: August 20, 2010, 04:17:23 PM »
        what u mean give everything


        Share via diggShare via facebookShare via linkedinShare via myspaceShare via redditShare via twitter
         


        Sitemap