Developer PACI 921 Posted June 25, 2014 Developer Share Posted June 25, 2014 M2 Download Center This is the hidden content, please Sign In or Sign Up ( 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. 81 1 1 3 2 2 1 1 1 30 10 105 when you return 0 and server doesn't boot: Link to comment Share on other sites More sharing options...
Premium Galet 510 Posted June 25, 2014 Premium Share Posted June 25, 2014 Thanks ! 1 1 1 Link to comment Share on other sites More sharing options...
Zardon 4 Posted June 25, 2014 Share Posted June 25, 2014 It doesn't work for me. It ignores all lines in my item_proto Link to comment Share on other sites More sharing options...
Developer PACI 921 Posted June 25, 2014 Author Developer Share Posted June 25, 2014 Send me your item_proto_dump.xml via PM to take a look. when you return 0 and server doesn't boot: Link to comment Share on other sites More sharing options...
Phantom 3 Posted June 25, 2014 Share Posted June 25, 2014 nice 1 Link to comment Share on other sites More sharing options...
Developer PACI 921 Posted June 25, 2014 Author Developer Share Posted June 25, 2014 Post edited with the newer version of the software. when you return 0 and server doesn't boot: Link to comment Share on other sites More sharing options...
Risan 115 Posted June 25, 2014 Share Posted June 25, 2014 SourceCode is in Lua? Nice can i see how you compile this? 1 Link to comment Share on other sites More sharing options...
Developer PACI 921 Posted June 25, 2014 Author Developer Share Posted June 25, 2014 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. 1 when you return 0 and server doesn't boot: Link to comment Share on other sites More sharing options...
Zardon 4 Posted June 25, 2014 Share Posted June 25, 2014 Now it works for me thanks 1 Link to comment Share on other sites More sharing options...
Developer PACI 921 Posted July 7, 2014 Author Developer Share Posted July 7, 2014 07.07.14 - 21:01 - Source posted. when you return 0 and server doesn't boot: Link to comment Share on other sites More sharing options...
Night 366 Posted July 7, 2014 Share Posted July 7, 2014 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 1 Link to comment Share on other sites More sharing options...
Developer PACI 921 Posted July 7, 2014 Author Developer Share Posted July 7, 2014 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: Link to comment Share on other sites More sharing options...
Night 366 Posted July 7, 2014 Share Posted July 7, 2014 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 "" ? 1 Link to comment Share on other sites More sharing options...
Developer PACI 921 Posted July 7, 2014 Author Developer Share Posted July 7, 2014 Nope, that's not really necessary. Thanks for the suggestion. when you return 0 and server doesn't boot: Link to comment Share on other sites More sharing options...
Fenikss 0 Posted August 19, 2014 Share Posted August 19, 2014 please reupload Link to comment Share on other sites More sharing options...
Silfro 11 Posted August 19, 2014 Share Posted August 19, 2014 reupload please Link to comment Share on other sites More sharing options...
Developer PACI 921 Posted August 19, 2014 Author Developer Share Posted August 19, 2014 I know, I know. New link already available, check out the first post. 2 when you return 0 and server doesn't boot: Link to comment Share on other sites More sharing options...
Timasu 30 Posted August 19, 2014 Share Posted August 19, 2014 Thanks! I love this tool, beacuse is open source 1 Link to comment Share on other sites More sharing options...
Zeta 11 Posted October 8, 2014 Share Posted October 8, 2014 Best Converter, how can i add WEAPON_CLAW becuse this weapon have subtype -1? Link to comment Share on other sites More sharing options...
Adrian1428 31 Posted November 14, 2014 Share Posted November 14, 2014 Many thanks man , best converter Link to comment Share on other sites More sharing options...
Maxmi 11 Posted November 14, 2014 Share Posted November 14, 2014 Best Converter, how can i add WEAPON_CLAW becuse this weapon have subtype -1? No. WEAPON_CLAW = Subtype 8 Link to comment Share on other sites More sharing options...
Zardon 4 Posted November 15, 2014 Share Posted November 15, 2014 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 More sharing options...
Zardon 4 Posted November 19, 2014 Share Posted November 19, 2014 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 More sharing options...
Premium Galet 510 Posted November 19, 2014 Premium Share Posted November 19, 2014 Send us our lines Link to comment Share on other sites More sharing options...
Zardon 4 Posted November 19, 2014 Share Posted November 19, 2014 the item_proto is in the post before that today https://mega.co.nz/#!eYMQBSaY!1v2cN2KgMWgRQfTk9FnYURFWLuyEJcarhiHRhr0zalE Link to comment Share on other sites More sharing options...
Recommended Posts