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

iwitrag · 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

Claws · 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)

metin2elysium · December 12, 2014

GOOOOOOOOOOOOOOOOOOOOOOOOOOOD!!!!!!

TWO DAYS LOOKING .... wow very good!!! thank thank thank!!!!!

Thanatos · May 18, 2015

thanks verry much i use it now:)

Ace · 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');

The picos · July 18, 2015

Arigato

Seby. · July 18, 2015

Yes , and if you make a change in item_proto , you can not archive item_proto

Distraught · September 11, 2015

I'm tryna archive the item_proto but there's no item_proto generated :/

WsRoyal · 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++).

raihan3 · 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

shishishi · 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...

raihan3 · August 14, 2016

hi item name came like that look

for client does this type name work ? for client

PeaceMaker · December 9, 2016

this method is not working anymore

iwitrag · 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.

mTw · January 23, 2018

can you remove the refine_set2 column from your converter? that messes up my whole item_proto

Adrian1997 · 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

zeimpekis9 · 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...

rcdporraz · 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

Elysium · February 15, 2020

can you upload them on another site?

Sign In

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

Recommended Posts

iwitrag 37

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

iwitrag

Claws 0

Link to comment

Share on other sites

metin2elysium 0

Link to comment

Share on other sites

Thanatos 77

Link to comment

Share on other sites

Ace 4611

Link to comment

Share on other sites

The picos 0

Link to comment

Share on other sites

Seby. 6

Link to comment

Share on other sites

Distraught 9974

Link to comment

Share on other sites

WsRoyal 336

Link to comment

Share on other sites

raihan3 23

Link to comment

Share on other sites

shishishi 0

Link to comment

Share on other sites

raihan3 23

Link to comment

Share on other sites

PeaceMaker 143

Link to comment

Share on other sites

iwitrag 37

Link to comment

Share on other sites

mTw 0

Link to comment

Share on other sites

Adrian1997 5

Link to comment

Share on other sites

zeimpekis9 93

Link to comment

Share on other sites

rcdporraz 14

Link to comment

Share on other sites

Elysium 170

Link to comment

Share on other sites

Please sign in to comment

Current Donation Goals

Similar Content

Important Information