Jump to content

[ Dead Download Link ] [HowTo] (un)pack item_proto [ We Need You ]


iwitrag

Recommended Posts

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

 

 

  • Metin2 Dev 1
  • Good 2
  • Love 1
  • Love 20
Link to comment
Share on other sites

  • 3 weeks later...
  • 5 months later...

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

  • 1 month later...
  • 1 month later...
  • 3 months later...
  • 1 month later...
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

  • 2 weeks later...
  • 6 months later...

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

  • 3 months later...
  • 4 months later...
  • 9 months later...
  • 1 year later...
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

  • 3 months later...
  • 1 month later...

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.