[Share]GK for Epilogue

[EvE]

Ok guys i saw some GK's for epilogue without being complete ,so i did one complete :

 

 

Download : http://www.mediafire.com/?nqld5jnm5nm

[killer666]

Thanks dude! I was searching for a GK for epilogue. :)

[Matim]

Good share, but next time add Prefix in topic title.

[007florin]

thx for share and good work

[achillies]

just what i have been looking for,thankyou for the share eve.

 

[ČυяŞŀŅğ]

wow nice thanx dude !

[Skimy]

Being the massive noob I am. I tried installing this onto my server and when I was doing the SQL I was getting an error. What am I doing wrong?

 

[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
--------------------------------------------------

[rujanbarni]

yea me too, how can i insert into my sql data base cuz manual is too hard.. take a long time.... and when i execute bath file gives a lot of error... pls explaine or show me a tutorial cuz i didn't find. ty

[Matim]

Ehh guys, it was already explained XXXXXX times.

 

Also can you read? Check error log!

 

Delete these values from this SQL:

 

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'

 

And insert them manualy or correct your sql structure.

[rujanbarni]

ok ty man

[EvE]

Download Site edited !

[nemancati]

10x dude :)

[totila]

nice one dude. keep it up

[Lelouch]

nice try man but it needs more work.

Btw GL if you try to create more. :)

[Nox*Shine]

Good share keep working!