iwitrag 36 Posted November 17, 2014 Share Posted November 17, 2014 Hello metin2dev community! I'm new here and I'm learning how to mod metin. Yesterday I have been trying to work with item_proto and I must say - it's really difficult to find everything item_proto related (packers, converters, etc...) So I have made 2 converters and now I want to share 'em with this great community. HOW TO UNPACK/CONVERT/PACK ITEM_PROTO (this tutorial is only for people using 40K+ item_proto without TXT files (for example vanilla core) What we are going to do: 1. Unpack item_proto (so we will get XML file) 2. Convert this XML to SQL (for Navicat query) 3. Convert SQL back to XML (so we can pack it again) 4. Pack item_proto (from XML) What we will need: 1. Proto archiver (download) - http://stevecraft.cz/hracky/proto_archiver.rar 2. My XML to SQL converter I have written (no download) - http://www.stevecraft.cz/hracky/xml_to_sql.php 3. My SQL to XML converter I have written (no download) - http://www.stevecraft.cz/hracky/sql_to_xml.php PASSWORD: METIN How to do it: 1. First of all we need to download and extract proto_archiver.rar (use WinRar or 7zip) 2. Then we need to move our item_proto to folder, where we have extracted proto_archiver.rar 3. Run unpack_item_proto.bat and item_proto.xml will appear 4. Open item_proto.xml 5. Open XML to SQL converter 5. Make sure, that lines from item_proto.xml looks like example in XML to SQL converter (for example there must be column LocalizedName) 6. Paste the content of item_proto.xml into textarea in XML to SQL converter. 7. Click Convert and wait for action to be done 8. Fix errors if any and try again (for example you can have , in name column so converter will think that that name are 2 columns separated by ,) 9. After you have your conversion done, you can make query to your item_proto table. 10. Do what you want (changes in DB, additional queries, ...) 11. Now you need to dump SQL file (right click to item_proto table - dump SQL file) 12. Save it somewhere and open it 13. Delete everything on the start so only lines with INSERT INTO will remain 14. Copy everything and paste it into SQL to XML converter and click Convert 15. Everything should be ok now, so copy your XML result and save it into file item_proto.xml 16. Run pack_item_proto.bat and it will make from new item_proto.xml packed item_proto DONE 1 2 1 20 Link to comment Share on other sites More sharing options...
Claws 0 Posted November 20, 2014 Share Posted November 20, 2014 xml to sql it not work for me.. //edit I'm use your item_proto decripter and now it's work xml to sql thanks soo much :* (Sorry for my bad english) Link to comment Share on other sites More sharing options...
metin2elysium 0 Posted December 12, 2014 Share Posted December 12, 2014 GOOOOOOOOOOOOOOOOOOOOOOOOOOOD!!!!!! TWO DAYS LOOKING .... wow very good!!! thank thank thank!!!!! Link to comment Share on other sites More sharing options...
Thanatos 70 Posted May 18, 2015 Share Posted May 18, 2015 thanks verry much i use it now:) Link to comment Share on other sites More sharing options...
Ace 3250 Posted May 21, 2015 Share Posted May 21, 2015 Whats wrong here: INSERT INTO `item_proto` VALUES ('41238', 0xC3AFC2BFC2BDC3A0C2B1C2B8C3AFC2BFC2BDC3AFC2BFC2BD, 0x434652204472616368656E66657565722030372B20287729, '28', '0', '0', '2', '32898', '0', '0', '', '0', '0', '0', '0', '0', '100', '7', '86400', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40080', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('41239', 0xC3AFC2BFC2BDC3A0C2B1C2B8C3AFC2BFC2BDC3AFC2BFC2BD, 0x46432044616579616D692B20286D29, '28', '0', '0', '2', '32897', '0', '0', '', '0', '0', '0', '0', '0', '100', '7', '86400', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40081', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); Spoiler Ymir Entertainment was founded in 1999 in Seoul, Korea and is currently headed by Byoung Gwan Kim as CEO. The company started developing its first 2D online game Metin the same year it was founded. The game was commercially launched in Korea a year later and received a prize from the Korean Ministry of Information and Communication in December of the same year. Following the success of their flagship game Ymir Entertainment immediately started work on the game’s sequel Metin 2, which went into Closed Beta in Korea in May 2004. The game was officially launched in Korea and China in March 2005 before being launched in Asia, Europe and North America in the years that followed. In January 2011 all of the company’s shares were bought by Webzen Inc., a Korean game giant known for their popular MMORPG, MU Online. The company was also awarded Gameforge’s Global Best Partner of the Year in 2011. Source: https://mmos.com/publishers/ymir-entertainment Thank you ymir and F*** you Gameforge, 2011 you ruined it. Link to comment Share on other sites More sharing options...
The picos 0 Posted July 18, 2015 Share Posted July 18, 2015 Arigato Link to comment Share on other sites More sharing options...
Seby. 6 Posted July 18, 2015 Share Posted July 18, 2015 Yes , and if you make a change in item_proto , you can not archive item_proto Link to comment Share on other sites More sharing options...
Honorable Member Distraught 5903 Posted September 11, 2015 Honorable Member Share Posted September 11, 2015 I'm tryna archive the item_proto but there's no item_proto generated :/ Link to comment Share on other sites More sharing options...
Premium WsRoyal 233 Posted December 16, 2015 Premium Share Posted December 16, 2015 Hi guys, for those who after they made a change in item_proto.xml and then they can't crypt it. The problem is because you're using notepad++ for editing, use notepad simple, or found another working editor, for me worked with notepad.(not notepad++). Link to comment Share on other sites More sharing options...
raihan3 20 Posted January 18, 2016 Share Posted January 18, 2016 On 17/11/2014 at 8:14 PM, iwitrag said: Hello metin2dev community! I'm new here and I'm learning how to mod metin. Yesterday I have been trying to work with item_proto and I must say - it's really difficult to find everything item_proto related (packers, converters, etc...) So I have made 2 converters and now I want to share 'em with this great community. HOW TO UNPACK/CONVERT/PACK ITEM_PROTO (this tutorial is only for people using 40K+ item_proto without TXT files (for example vanilla core) What we are going to do: 1. Unpack item_proto (so we will get XML file) 2. Convert this XML to SQL (for Navicat query) 3. Convert SQL back to XML (so we can pack it again) 4. Pack item_proto (from XML) What we will need: 1. Proto archiver (download) - http://stevecraft.cz/hracky/proto_archiver.rar 2. My XML to SQL converter I have written (no download) - http://www.stevecraft.cz/hracky/xml_to_sql.php 3. My SQL to XML converter I have written (no download) - http://www.stevecraft.cz/hracky/sql_to_xml.php How to do it: 1. First of all we need to download and extract proto_archiver.rar (use WinRar or 7zip) 2. Then we need to move our item_proto to folder, where we have extracted proto_archiver.rar 3. Run unpack_item_proto.bat and item_proto.xml will appear 4. Open item_proto.xml 5. Open XML to SQL converter 5. Make sure, that lines from item_proto.xml looks like example in XML to SQL converter (for example there must be column LocalizedName) 6. Paste the content of item_proto.xml into textarea in XML to SQL converter. 7. Click Convert and wait for action to be done 8. Fix errors if any and try again (for example you can have , in name column so converter will think that that name are 2 columns separated by ,) 9. After you have your conversion done, you can make query to your item_proto table. 10. Do what you want (changes in DB, additional queries, ...) 11. Now you need to dump SQL file (right click to item_proto table - dump SQL file) 12. Save it somewhere and open it 13. Delete everything on the start so only lines with INSERT INTO will remain 14. Copy everything and paste it into SQL to XML converter and click Convert 15. Everything should be ok now, so copy your XML result and save it into file item_proto.xml 16. Run pack_item_proto.bat and it will make from new item_proto.xml packed item_proto DONE after xml to sql when i use query game not work so where is problem Link to comment Share on other sites More sharing options...
shishishi 0 Posted January 27, 2016 Share Posted January 27, 2016 On 11/9/2015 at 8:05 AM, Distraught said: I'm tryna archive the item_proto but there's no item_proto generated :/ me too... Link to comment Share on other sites More sharing options...
raihan3 20 Posted August 14, 2016 Share Posted August 14, 2016 hi item name came like that look <ItemDef Vnum="40120" Name="0xC2B5C2B52B30" LocalizedName="0x4576616E74616920496E676865746174" Type="28" SubType="3" Weight="0" Size="1" AntiFlags="28" Flags="1" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="7" LimitValue0="5184000" LimitType1="0" LimitValue1="0" ApplyType0="53" ApplyValue0="25" ApplyType1="15" ApplyValue1="5" ApplyType2="16" ApplyValue2="5" Value0="0" Value1="0" Value2="0" Value3="5" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="100" GainSocketPercent="0" AddonType="0" /> for client does this type name work ? for client Link to comment Share on other sites More sharing options...
PeaceMaker 121 Posted December 9, 2016 Share Posted December 9, 2016 this method is not working anymore Link to comment Share on other sites More sharing options...
iwitrag 36 Posted April 12, 2017 Author Share Posted April 12, 2017 It works, but if you have different item-proto it will not work. You need to check first if it is in correct format. Link to comment Share on other sites More sharing options...
mTw 0 Posted January 23, 2018 Share Posted January 23, 2018 can you remove the refine_set2 column from your converter? that messes up my whole item_proto Link to comment Share on other sites More sharing options...
Adrian1997 5 Posted January 26, 2018 Share Posted January 26, 2018 this converter it's not good, socket1,2,3,4,5 should be -1 and the converter mob_proto don't convert correct the ai_flag For item_proto ai recommend Paci converter Link to comment Share on other sites More sharing options...
zeimpekis9 68 Posted September 3, 2019 Share Posted September 3, 2019 On 11/17/2014 at 9:14 PM, iwitrag said: Hello metin2dev community! I'm new here and I'm learning how to mod metin. Yesterday I have been trying to work with item_proto and I must say - it's really difficult to find everything item_proto related (packers, converters, etc...) So I have made 2 converters and now I want to share 'em with this great community. HOW TO UNPACK/CONVERT/PACK ITEM_PROTO (this tutorial is only for people using 40K+ item_proto without TXT files (for example vanilla core) What we are going to do: 1. Unpack item_proto (so we will get XML file) 2. Convert this XML to SQL (for Navicat query) 3. Convert SQL back to XML (so we can pack it again) 4. Pack item_proto (from XML) What we will need: 1. Proto archiver (download) - http://stevecraft.cz/hracky/proto_archiver.rar 2. My XML to SQL converter I have written (no download) - http://www.stevecraft.cz/hracky/xml_to_sql.php 3. My SQL to XML converter I have written (no download) - http://www.stevecraft.cz/hracky/sql_to_xml.php PASSWORD: METIN How to do it: 1. First of all we need to download and extract proto_archiver.rar (use WinRar or 7zip) 2. Then we need to move our item_proto to folder, where we have extracted proto_archiver.rar 3. Run unpack_item_proto.bat and item_proto.xml will appear 4. Open item_proto.xml 5. Open XML to SQL converter 5. Make sure, that lines from item_proto.xml looks like example in XML to SQL converter (for example there must be column LocalizedName) 6. Paste the content of item_proto.xml into textarea in XML to SQL converter. 7. Click Convert and wait for action to be done 8. Fix errors if any and try again (for example you can have , in name column so converter will think that that name are 2 columns separated by ,) 9. After you have your conversion done, you can make query to your item_proto table. 10. Do what you want (changes in DB, additional queries, ...) 11. Now you need to dump SQL file (right click to item_proto table - dump SQL file) 12. Save it somewhere and open it 13. Delete everything on the start so only lines with INSERT INTO will remain 14. Copy everything and paste it into SQL to XML converter and click Convert 15. Everything should be ok now, so copy your XML result and save it into file item_proto.xml 16. Run pack_item_proto.bat and it will make from new item_proto.xml packed item_proto DONE Can you fix your links please? because we used them a lot... Link to comment Share on other sites More sharing options...
rcdporraz 6 Posted December 21, 2019 Share Posted December 21, 2019 En 3/9/2019 a las 18:08, zeimpekis9 dijo: ¿Puedes arreglar tus enlaces por favor? porque los usamos mucho ... I gree Link to comment Share on other sites More sharing options...
@ndr31 125 Posted February 15, 2020 Share Posted February 15, 2020 can you upload them on another site? Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now