Jump to content

Converter - Client > Server - Item_Proto


Recommended Posts

  • Developer

M2 Download Center

This is the hidden content, please
( Internal )

Hi.

 

I wanted to improve my lua skills, so I thought I could create a useful software, something that I would use, and I'm here to post it if someone wants it too.

 

A friend asked me if I could add a sql option, so I added it.

Since it's not a "thing from another world", just run the *.bat file with your item_proto_dump.xml on the same folder. Then wait until the process is finished, and go to output folder and take what you wanted.

 

Download: MEGA.

Source v1.5: Pastebin.

 

Changelog:

Spoiler

13.12.14 - 00:50

- Added new official flags and bonuses (bleeding, anti wolfman, etc);

- Type: lua52 converter.lua help for more relevant information;

- Syserr added.

- v 2.0.

 

07.07.14 - 21:01

- Source published.

 

25.06.14 - 17:33

- Bugfixes (such as big values when they are supposed to be negative);

- v1.4.

 

25.06.14 - 12:29

- Can convert item_proto.xml from Tim's Archiver as well as the one created with Nexus (by Mr. Lucifer);

- Convert it to *.sql or to *.txt depending on what you want;

- v1.3 (v1.2 had only the first update).

 

24.06.14 - 15:31

- Bugfixes;

- v1.1.

 

24.06.14 - 02:05

- v1.0 Released (only in another board);

 

Hope it's useful to anyone.

  • Metin2 Dev 81
  • kekw 1
  • Dislove 3
  • Angry 2
  • Sad 2
  • Think 1
  • Confused 1
  • Scream 1
  • Good 30
  • Love 10
  • Love 103

when you return 0 and server doesn't boot:

unknown.png

Link to comment
Share on other sites

  • 2 weeks later...
  • Developer

Well you can add new types, subtypes, and all that things on ItemData.lua.

When I posted the source, I was thinking on not to make any other update, because since I had done the version 1.4, I didn't touch on it anymore. But, that's not a no at all, if I can and if I have time, I could try to add mob_proto converter on this tool.

And finally, thanks.

when you return 0 and server doesn't boot:

unknown.png

Link to comment
Share on other sites

if you make an update add this to the start of the .sql file it will be helpfull for those how hate work

SET FOREIGN_KEY_CHECKS=0;



DROP TABLE IF EXISTS `item_proto`;
CREATE TABLE `item_proto` (
	`vnum` int(11) unsigned NOT NULL default '0',
	`name` varbinary(200) NOT NULL default 'Noname                  ',
	`locale_name` varbinary(24) NOT NULL default 'Noname                  ',
	`type` tinyint(2) NOT NULL default '0',
	`subtype` tinyint(2) NOT NULL default '0',
	`weight` tinyint(3) default '0',
	`size` tinyint(3) default '0',
	`antiflag` int(11) default '0',
	`flag` int(11) default '0',
	`wearflag` int(11) default '0',
	`immuneflag` set('PARA','CURSE','STUN','SLEEP','SLOW','POISON','TERROR') NOT NULL default '',
	`gold` int(11) default '0',
	`shop_buy_price` int(10) unsigned NOT NULL default '0',
	`refined_vnum` int(10) unsigned NOT NULL default '0',
	`refine_set` smallint(11) unsigned NOT NULL default '0',
	`refine_set2` smallint(5) unsigned NOT NULL default '0',
	`magic_pct` tinyint(4) NOT NULL default '0',
	`limittype0` tinyint(4) default '0',
	`limitvalue0` int(11) default '0',
	`limittype1` tinyint(4) default '0',
	`limitvalue1` int(11) default '0',
	`applytype0` tinyint(4) default '0',
	`applyvalue0` int(11) default '0',
	`applytype1` tinyint(4) default '0',
	`applyvalue1` int(11) default '0',
	`applytype2` tinyint(4) default '0',
	`applyvalue2` int(11) default '0',
	`value0` int(11) default '0',
	`value1` int(11) default '0',
	`value2` int(11) default '0',
	`value3` int(11) default '0',
	`value4` int(11) default '0',
	`value5` int(11) default '0',
	`socket0` tinyint(4) default '-1',
	`socket1` tinyint(4) default '-1',
	`socket2` tinyint(4) default '-1',
	`socket3` tinyint(4) default '-1',
	`socket4` tinyint(4) default '-1',
	`socket5` tinyint(4) default '-1',
	`specular` tinyint(4) NOT NULL default '0',
	`socket_pct` tinyint(4) NOT NULL default '0',
	`addon_type` smallint(6) NOT NULL default '0',
	PRIMARY KEY  (`vnum`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;

ah and on the txt shouldnt all the (word) be betwen "" ?

  • Love 1
Link to comment
Share on other sites

  • 1 month later...
  • 1 month later...
  • 1 month later...

Hey,

i have one problem. When i use this tool i get an error while starting the server:

 

 

SYSERR: Nov 15 02:01:03 :: Set_Proto_Item_Table: ItemProto Reading Failed : Invalid value. (index: 3, col: 3, value: 0)
SYSERR: Nov 15 02:01:03 :: Set_Proto_Item_Table:     0 ~ 3 Values: 100100,0,31,

 

Here you can find my item_proto.txt

 

https://mega.co.nz/#!eYMQBSaY!1v2cN2KgMWgRQfTk9FnYURFWLuyEJcarhiHRhr0zalE

Link to comment
Share on other sites

Hey,

i have one problem. When i use this tool i get an error while starting the server:

 

 

SYSERR: Nov 15 02:01:03 :: Set_Proto_Item_Table: ItemProto Reading Failed : Invalid value. (index: 3, col: 3, value: 0)

SYSERR: Nov 15 02:01:03 :: Set_Proto_Item_Table:     0 ~ 3 Values: 100100,0,31,

 

Here you can find my item_proto.txt

 

https://mega.co.nz/#!eYMQBSaY!1v2cN2KgMWgRQfTk9FnYURFWLuyEJcarhiHRhr0zalE

 

Does no one know a solution for that?

Link to comment
Share on other sites

Announcements



  • Similar Content

  • Activity

    1. 2

      Feeding game source to LLM

    2. 0

      Target Information System

    3. 2

      Feeding game source to LLM

    4. 2

      anti exp explanation pls

    5. 2

      Feeding game source to LLM

    6. 2

      anti exp explanation pls

    7. 0

      [GR2] Positioning an object added with "Attach"

  • Recently Browsing

    • No registered users viewing this page.
×
×
  • 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.