keaizer Posted January 12, 2012 Share Posted January 12, 2012 i got this error..any idea why? [Err] 1062 - Duplicate entry '10002-32237' for key 'PRIMARY' [Err] INSERT INTO `npc` VALUES ('10002', '32237', 'Nicole', '1', 'GM Shop', '1', 'LineageNPC2.k_hero_bowgun', '9.00', '23.00', '70', 'female', 'L2Merchant', '40', '2444.468190000000000', '1345.800000000000000', '7.500000000000000', '2.700000000000000', '40', '43', '30', '21', '20', '20', '0', '0', '688.86373', '295.91597', '470.40463', '216.53847', '253', '4', '0', '333', '9644', '0', '0', '47.00000', '120.00000', '1', '1', '0', '1'); Quote Link to comment Share on other sites More sharing options...
007florin Posted January 12, 2012 Author Share Posted January 12, 2012 i got this error..any idea why? [Err] 1062 - Duplicate entry '10002-32237' for key 'PRIMARY' [Err] INSERT INTO `npc` VALUES ('10002', '32237', 'Nicole', '1', 'GM Shop', '1', 'LineageNPC2.k_hero_bowgun', '9.00', '23.00', '70', 'female', 'L2Merchant', '40', '2444.468190000000000', '1345.800000000000000', '7.500000000000000', '2.700000000000000', '40', '43', '30', '21', '20', '20', '0', '0', '688.86373', '295.91597', '470.40463', '216.53847', '253', '4', '0', '333', '9644', '0', '0', '47.00000', '120.00000', '1', '1', '0', '1'); Because you have already that npc installed. Quote Link to comment Share on other sites More sharing options...
keaizer Posted January 12, 2012 Share Posted January 12, 2012 Because you have already that npc installed. so what should i do now?i log in to server but no NPC at all. this is what i do.. 1.copy all files into game folder 2. then open Navicat and execute My SQL this what i do..i copy all Quote Link to comment Share on other sites More sharing options...
nikolakisgk Posted January 12, 2012 Share Posted January 12, 2012 nice share Quote Link to comment Share on other sites More sharing options...
007florin Posted January 12, 2012 Author Share Posted January 12, 2012 so what should i do now?i log in to server but no NPC at all. this is what i do.. 1.copy all files into game folder 2. then open Navicat and execute My SQL this what i do..i copy all You had installed this npc? or this is first time you install it? Quote Link to comment Share on other sites More sharing options...
keaizer Posted January 13, 2012 Share Posted January 13, 2012 You had installed this npc? or this is first time you install it? this is the 1st time i install it..dont know why i receive this error..i use the latest l2j datapack Quote Link to comment Share on other sites More sharing options...
007florin Posted January 13, 2012 Author Share Posted January 13, 2012 this is the 1st time i install it..dont know why i receive this error..i use the latest l2j datapack Go to NPC table and see what npc you have with this ID [10002] Quote Link to comment Share on other sites More sharing options...
keaizer Posted January 13, 2012 Share Posted January 13, 2012 Go to NPC table and see what npc you have with this ID [10002] nvm bro...all fixed..now manage to spawn the gm shop...very nice gm shop and full of items..thank you very much for your share.. one more..how to change the price of item??and i notice some items is FOC (Armor - Vesper, Eligia, vorpal) can you tell me how to change the price Quote Link to comment Share on other sites More sharing options...
RandomDude Posted January 13, 2012 Share Posted January 13, 2012 Open all the xml's witch hold the multisell you'll need and then you will see the product Id and the payment Id and there you change the prices.. (try to do what you think is the right, because it cant fail) xD Quote Link to comment Share on other sites More sharing options...
007florin Posted January 13, 2012 Author Share Posted January 13, 2012 nvm bro...all fixed..now manage to spawn the gm shop...very nice gm shop and full of items..thank you very much for your share.. one more..how to change the price of item??and i notice some items is FOC (Armor - Vesper, Eligia, vorpal) can you tell me how to change the price Go to multisell folder and find there what you want to change. (.xml files) Example: <!-- Cloak of Freya --> <item id="17"> <ingredient id="57" count="50000000"/> <production id="21717" count="1"/> </item> Instead of 50000000 you put what nr of adena want. Quote Link to comment Share on other sites More sharing options...
keaizer Posted January 14, 2012 Share Posted January 14, 2012 Open all the xml's witch hold the multisell you'll need and then you will see the product Id and the payment Id and there you change the prices.. (try to do what you think is the right, because it cant fail) xD thanks you very much for the info..really appreciate.. :) Go to multisell folder and find there what you want to change. (.xml files) Example: <!-- Cloak of Freya --> <item id="17"> <ingredient id="57" count="50000000"/> <production id="21717" count="1"/> </item> Instead of 50000000 you put what nr of adena want. again bro..thank you very much for ur help..there lot of stuff need to adjust ;) this gm shop rock!!!!! Quote Link to comment Share on other sites More sharing options...
Mr-Anderson Posted January 14, 2012 Share Posted January 14, 2012 Basika akuro, to eftiaska auto pou hthela, fixed. Good share, and the Ty. Later. Quote Link to comment Share on other sites More sharing options...
CloudOddz Posted January 16, 2012 Share Posted January 16, 2012 very nice share thanks Quote Link to comment Share on other sites More sharing options...
MAXIMO-XP Posted February 9, 2012 Share Posted February 9, 2012 thx Quote Link to comment Share on other sites More sharing options...
[AoH]Kratos Posted March 11, 2012 Share Posted March 11, 2012 I was the first to see this NPC on his server , and the last to thank him for sharing it. Too bad you're not working with L2 anymore. Anyway , thank you a lot my friend. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.