asdf0rakos Posted April 10, 2011 Share Posted April 10, 2011 hey nice share! npc's are great but i have a problem when i am trying to execute the sql file: [Err] INSERT INTO `npc` VALUES ('36600', '20845', 'Augument Manager', '1', '[server Name]', '1', 'Npc.a_smith_MDwarf', '22.00', '26.00', '80', 'male', 'L2Trainer', '40', '540452.000000000000000', '5243.000000000000000', null, null, '40', '43', '30', '21', '20', '20', '0', '0', '453.00000', '638.00000', '838.00000', '8383.00000', '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'); Link to comment Share on other sites More sharing options...
Rzeszut Posted April 11, 2011 Share Posted April 11, 2011 Super npc , thank's for share , nice design npc !!! Link to comment Share on other sites More sharing options...
`NeverMore Posted April 11, 2011 Author Share Posted April 11, 2011 Thanks all of you guys...! Soon UPDATE with more...! ^^ I am working ..! hey nice share! npc's are great but i have a problem when i am trying to execute the sql file: I will see what causes this to you...! I will edit later ...! maybe wrong colums but i will check it..! Link to comment Share on other sites More sharing options...
Wunderkind Posted April 11, 2011 Share Posted April 11, 2011 Just a suggestion, I was crashing when I opened some of the pages due to some seriously long .htm files Where I found : <html> <head> <title> GM Shop</title> </head> <body> <center><img src="L2UI_CH3.herotower_deco" width=256 height=32> <center><br1> <table cellspacing=-1> <tr> <td><img src="L2UI.SquareBlank" width=40 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=40 height=20></td> </tr> </table> <center><img src="L2UI.SquareWhite" width=200 height=1></center> <table bgcolor=FF00FF width=204> <tr> <td><center><font color="FFFF00">Shop</font></center></td> </tr> </table> <center><img src="L2UI.SquareWhite" width=200 height=1></center> <table cellspacing=-1> <tr> <td><img src="L2UI.SquareBlank" width=40 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=40 height=20></td> </tr> </table> I replaced it with : <html> <head> <title>GM Shop</title> </head> <body> <center><img src="L2UI_CH3.herotower_deco" width=256 height=32> <br> <img src="L2UI.SquareWhite" width=200 height=1> <table bgcolor=FF00FF width=204> <tr> <td align=center><font color="FFFF00">Shop</font></td> </tr> </table> <img src="L2UI.SquareWhite" width=200 height=1> <br> <br> <br> It has the same exact appearance but it uses much less space. Link to comment Share on other sites More sharing options...
asdf0rakos Posted April 13, 2011 Share Posted April 13, 2011 any solution to my problem? i have version 4521 Link to comment Share on other sites More sharing options...
`NeverMore Posted April 13, 2011 Author Share Posted April 13, 2011 Just a suggestion, I was crashing when I opened some of the pages due to some seriously long .htm files Where I found : <html> <head> <title> GM Shop</title> </head> <body> <center><img src="L2UI_CH3.herotower_deco" width=256 height=32> <center><br1> <table cellspacing=-1> <tr> <td><img src="L2UI.SquareBlank" width=40 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=40 height=20></td> </tr> </table> <center><img src="L2UI.SquareWhite" width=200 height=1></center> <table bgcolor=FF00FF width=204> <tr> <td><center><font color="FFFF00">Shop</font></center></td> </tr> </table> <center><img src="L2UI.SquareWhite" width=200 height=1></center> <table cellspacing=-1> <tr> <td><img src="L2UI.SquareBlank" width=40 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=32 height=20></td> <td><img src="L2UI.SquareBlank" width=40 height=20></td> </tr> </table> I replaced it with : <html> <head> <title>GM Shop</title> </head> <body> <center><img src="L2UI_CH3.herotower_deco" width=256 height=32> <br> <img src="L2UI.SquareWhite" width=200 height=1> <table bgcolor=FF00FF width=204> <tr> <td align=center><font color="FFFF00">Shop</font></td> </tr> </table> <img src="L2UI.SquareWhite" width=200 height=1> <br> <br> <br> It has the same exact appearance but it uses much less space. Thanks Btw Man...! ;) any solution to my problem? i have version 4521 Ok i am checking right now ... w8 ... ! I will edit in some minutes ^^ EDIT: Test this man http://www.4shared.com/document/fSecsAsC/npcs_sql.html Link to comment Share on other sites More sharing options...
asdf0rakos Posted April 13, 2011 Share Posted April 13, 2011 1st of all, i would like to say a big THANK YOU ! You deserve it cuz you replied so early :) 2nd, i am sorry i have to say this but it's not working :( [Err] 1264 - Out of range value for column 'mp' at row 3 [Err] INSERT INTO `npc` VALUES ('36600', '20845', 'Augument Manager', '1', '[server Name]', '1', 'Npc.a_smith_MDwarf', '22.00', '26.00', '80', 'male', 'L2Trainer', '40', '540452.000000000000000', '5243.000000000000000', null, null, '40', '43', '30', '21', '20', '20', '0', '0', '453.00000', '638.00000', '838.00000', '8383.00000', '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'), ('36601', '13087', 'PvP-Pk Manager', '1', '[server Name]', '1', 'LineageMonster4.Divine_Rogue', '8.00', '30.00', '80', 'male', 'L2Npc', '40', '523.000000000000000', '87238.000000000000000', '378378.000000000000000', '378.000000000000000', '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'), ('36602', '25542', 'Pk Protector', '1', '[server Name]', '1', 'LineageNPC.a_guard_MHuman', '8.00', '30.00', '85', 'male', 'L2Guard', '1500', '500000000.000000000000000', '50000000000.000000000000000', '5000000000.000000000000000', '50000000000.000000000000000', '40', '40', '40', '40', '40', '40', '0', '0', '9999999.00000', '9999999.00000', '9999999.00000', '9999999.00000', '1200', '2', '2000', '333', '0', '0', '0', '60.00000', '220.00000', '1', '1', '0', '0'), ('36603', '25286', 'Gm Shop', '1', '[server Name]', '1', 'LineageMonster4.Divine_Rogue', '8.00', '23.00', '80', 'male', 'L2Merchant', '40', null, null, null, null, '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'), ('36604', '10', 'Gatekeeper', '1', '[server Name]', '1', 'LineageNpc2.br_aga_ball_kick', '8.00', '26.00', '80', 'male', 'L2Teleporter', '40', null, null, null, null, '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'), ('36605', '13116', 'WareHouse Manager', '1', '[server Name]', '1', 'LineageNPC.a_warehouse_keeper_MDwarf', '8.00', '25.00', '80', 'male', 'L2Warehouse', '40', null, null, null, null, '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'), ('36606', '31651', 'Npc Server Informer', '1', '[server Name]', '1', 'LineageNpcEV.Advance_quarters', '8.00', '23.00', '45', 'male', 'L2Npc', null, null, null, null, null, '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'); [Msg] Finished - Unsuccessfully -------------------------------------------------- Link to comment Share on other sites More sharing options...
`NeverMore Posted April 13, 2011 Author Share Posted April 13, 2011 1st of all, i would like to say a big THANK YOU ! You deserve it cuz you replied so early :) 2nd, i am sorry i have to say this but it's not working :( well now i am sure that we have deferent revisios ^^ .... ( that is the main prob ) For me it works perfect ...! Check this 1 again http://www.4shared.com/document/Bv04b_pO/npcs_sql_2.html If problem remains send me PM so i can Help you Private :p ! Link to comment Share on other sites More sharing options...
asdf0rakos Posted April 13, 2011 Share Posted April 13, 2011 YOU are awsome!!!!!!!!!!!!!!!!! +1 karma :D you deserve it again :) It's working now and i finally can spawn the npc's ingame and they are working properly! 100000000 thanks ;) Link to comment Share on other sites More sharing options...
`NeverMore Posted April 24, 2011 Author Share Posted April 24, 2011 __________UPDATE_________ *Added 1 More Npc Tested and Have Fun... More Updates In some Days... (More Npc's Are Coming) Link to comment Share on other sites More sharing options...
TheVoR Posted April 25, 2011 Share Posted April 25, 2011 very nice and useful gl ;) Link to comment Share on other sites More sharing options...
marwan Posted April 25, 2011 Share Posted April 25, 2011 you forget to add script.cfg for the new npc oO Link to comment Share on other sites More sharing options...
`NeverMore Posted April 25, 2011 Author Share Posted April 25, 2011 you forget to add script.cfg for the new npc oO Yes I am Sory U are Right ...! Here U are custom/36607_TitlecolorNvM/__init__.py Link to comment Share on other sites More sharing options...
Gootzy Posted May 2, 2011 Share Posted May 2, 2011 Great share, downloading Link to comment Share on other sites More sharing options...
marwan Posted May 2, 2011 Share Posted May 2, 2011 you forget to add the download link for the new npc Link to comment Share on other sites More sharing options...
Recommended Posts