HELP NPC

[olibiarkos]

Hi se olous exw ena prov....otan pernao ta sql pada leei error..???exw l2jserver.... ayto leei                                                              /....[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';

 

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

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

 

[xMrPwN]

auto simenei oti ta columns tou table sou den teriazoun me to file p pas na peraseis

perna xeirokinita to npc (vlepe values apo to file kai vaze ta xeirokinita sto npc table)

kai peiramatisou gia ta teleports, psa3e vres pia column eine diaforetika

 

[Xanderॐ]

H apla alakse thn domh toy pinaka na teriazei me to file.