livogro Posted January 18, 2009 Share Posted January 18, 2009 very nice gk, Thx man Keep up creating other coll npc's like this :} Link to comment Share on other sites More sharing options...
mrjukic Posted February 6, 2009 Share Posted February 6, 2009 I also have error... Im with gracia part 2 [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 [Err] 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'; [Msg] Finished - Unsuccessfully -------------------------------------------------- tell me how to fix it please? Any Fix for this problem? Link to comment Share on other sites More sharing options...
R3spawn Posted February 6, 2009 Share Posted February 6, 2009 Awesom, thx. Link to comment Share on other sites More sharing options...
BlueTooth Posted February 9, 2009 Share Posted February 9, 2009 Very nice job. Thanks i will use it. Link to comment Share on other sites More sharing options...
ChaotikoS Posted February 11, 2009 Share Posted February 11, 2009 nice one :) Link to comment Share on other sites More sharing options...
daemoneyre Posted February 16, 2009 Share Posted February 16, 2009 super just what i was looking for, the menu looks random but damn so good diferent is good :D:D Link to comment Share on other sites More sharing options...
mandachumbo Posted February 17, 2009 Share Posted February 17, 2009 Any Fix for this problem? Delete this first lines 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'), Link to comment Share on other sites More sharing options...
ReXoN Posted February 17, 2009 Share Posted February 17, 2009 thx for share :) Link to comment Share on other sites More sharing options...
johnatanasoff Posted February 20, 2009 Share Posted February 20, 2009 very tnx Link to comment Share on other sites More sharing options...
M4nu75 Posted February 27, 2009 Share Posted February 27, 2009 Any Fix for this problem? Delete this first lines 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'), Don't delete the first lines , because if you delete them you cannot create the npc in the custom_npc table. It is only a syntax error. You must put a semicolon ( ; ) instead the comma ( , ) at the end of second row. Link to comment Share on other sites More sharing options...
ZumbuL Posted February 27, 2009 Share Posted February 27, 2009 I've used this 1, some of the links are not working and are broken. Needs an update. Link to comment Share on other sites More sharing options...
DāЯқŜiĐє Posted February 27, 2009 Share Posted February 27, 2009 Thats a F@CKING cool share Grisom...Added in favorites :P ------Edited------ xmmm i think i found the error...Dont add it in custom npc but in simple npc table...Check the tables names if they match with your DB... Link to comment Share on other sites More sharing options...
Masterd3v1l Posted February 28, 2009 Share Posted February 28, 2009 sweet nice share. Link to comment Share on other sites More sharing options...
~!M@R@SL@K0SsS!~ Posted March 22, 2009 Share Posted March 22, 2009 nice but dont work it says error and i look the table.... all is right but again say me error Link to comment Share on other sites More sharing options...
maxicroma Posted March 23, 2009 Share Posted March 23, 2009 nice man very thx i put it in my server :D Link to comment Share on other sites More sharing options...
Recommended Posts