Jump to content

Converter - Client > Server - Item_Proto


Recommended Posts

M2 Download Center

Hidden Content

    Give reaction to this post to see the hidden content.
( 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:

Hidden Content

    Give reaction to this post to see the hidden content.
.

Source v1.5:

Hidden Content

    Give reaction to this post to see the hidden content.
.

 

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.

  • Love 28

when you return 0 and server doesn't boot:

unknown.png

Link to comment

I could post the source-code when I finish this project (I have some ideas that I wanted to do). But anyway, it wasn't really hard to do.

  • Love 1

when you return 0 and server doesn't boot:

unknown.png

Link to comment
  • 2 weeks later...

best tool or so i think ^^

question :

will there be more update ?

(if new type are out)

will you make one for mob proto ? or add mob proto converter to this one?

(sence i dont belive that there is one )

last word :

great work

  • Love 1
Link to comment

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

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
  • 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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×
×
  • 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.