Item DB Converter Problem

[GM.PiXeL]

Hi hercules,

I used this: http://haru.ws/hercules/itemdbconverter/

I have this problem when converting my old item db to the new overhauled item db conf.

Here's the error:

******************************************************************************/// Error parsing: 30250,Costume_Beer_Hat,Costume_Beer_Hat,5, 100000,,10, ,10,,1,0xFFFFFFFF,7,2,1024,,0,1,418,{},{},{}// Error parsing: 30251,Costume_Bell_Ribbon,Costume_Bell_Ribbon,5, 100000,,10, ,10,,1,0xFFFFFFFF,7,2,1024,,0,1,388,{},{},{}// Error parsing: 30252,Costume_Black_Tea_Kochakaden_Hat,Costume_Black_Tea_Kochakaden_Hat,5, 100000,,10, ,10,,1,0xFFFFFFFF,7,2,1024,,0,1,428,{},{},{}// Error parsing: 30253,Costume_Bunny_Top_Hat,Costume_Bunny_Top_Hat,5, 100000,,10, ,10,,1,0xFFFFFFFF,7,2,1024,,0,1,384,{},{},{}// Error parsing: 30254,Costume_Chick_Hat,Costume_Chick_Hat,5, 100000,,10, ,10,,1,0xFFFFFFFF,7,2,1024,,0,1,311,{},{},{}// Error parsing: 30255,Costume_Chicken_Hat,Costume_Chicken_Hat,5, 100000,,10, ,10,,1,0xFFFFFFFF,7,2,1024,,0,1,432,{},{},{})

 

[Haru]

The issue was because of the extra spaces you had in your lines. I added support for that situation, since the server used to load those correctly even if the spaces weren't supposed to be there.

Thanks for the report. It's fixed in https://github.com/HerculesWS/Hercules/commit/d1a635a06f5152b51d0879176f011b5c6e45431c (and if you use the online version, it was updated as well)

 

[Dastgir]

Still cannot use itemdbconverter, Some error like 

Sequence (?<p...) not recognized in regex; marked by <-- HERE in m/^                        (?<p <-- HERE refix>(?://[^0-9]*)?)                        (?<ID>[0-9]+)[^,]*,                        (?<AegisName>[^,]+),                        (?<Name>[^,]+),[st]*                        (?<Type>[0-9]+)[^,]*,[st]*                        (?<Buy>[0-9]*)[^,]*,[st]*                        (?<Sell>[0-9]*)[^,]*,[st]*                        (?<Weight>[0-9]*)[^,]*,[st]*                        (?<ATK>[0-9-]*)[^,:]*(?<hasmatk>:[st]*(?<MATK>[0-9-]*))?[^,]*,[st]*                        (?<DEF>[0-9-]*)[^,]*,[st]*                        (?<Range>[0-9]*)[^,]*,[st]*                        (?<Slots>[0-9]*)[^,]*,[st]*                        (?<Job>[x0-9A-Fa-f]*)[^,] at tools/itemdbconverter.pl line 99.

 

[Haru]

It looks like your perl interpreter doesn't support named captures.

The script uses those, so it requires at least perl version 5.10 (which was released six years ago). You can either upgrade your perl interpreter, or use the online version.

 

[Dastgir]

It looks like your perl interpreter doesn't support named captures.

The script uses those, so it requires at least perl version 5.10 (which was released six years ago). You can either upgrade your perl interpreter, or use the online version.

Mine one is "perl 5.16.3.1"

Which i suppose is newer than 5.10

 

[Haru]

That's weird, I tested it on perl 5.16 and perl 5.12, and it fully works (and the documentation also confirms so http://perldoc.perl.org/perl5100delta.html#Named-Capture-Buffers / http://perldoc.perl.org/perlre.html#%28?%27NAME%27pattern%29 ) o.o

What OS, out of curiosity? Also, what does this output? Any errors?

perl -e 'my $a="it doesnt workn";$a =~ s/(?<a>.*)nt/$+{a}/; print $a;'

 

[GM.PiXeL]

That's weird, I tested it on perl 5.16 and perl 5.12, and it fully works (and the documentation also confirms so http://perldoc.perl.org/perl5100delta.html#Named-Capture-Buffers / http://perldoc.perl.org/perlre.html#%28?%27NAME%27pattern%29 ) o.o

What OS, out of curiosity? Also, what does this output? Any errors?

perl -e 'my $a="it doesnt workn";$a =~ s/(?<a>.*)nt/$+{a}/; print $a;'

Still errors: 

// Error parsing: 28153,Light_STR_Brooch,Light_STR_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bStr,15; bonus bMdef,7; },{},{}// Error parsing: 28154,Light_AGI_Brooch,Light_AGI_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bAgi,15; bonus bMdef,7; },{},{}// Error parsing: 28155,Light_VIT_Brooch,Light_VIT_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bVit,15; bonus bMdef,7; },{},{}// Error parsing: 28156,Light_INT_Brooch,Light_INT_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bInt,15; bonus bMdef,7; },{},{}// Error parsing: 28157,Light_DEX_Brooch,Light_DEX_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bDex,15; bonus bMdef,7; },{},{}// Error parsing: 28158,Light_LUK_Brooch,Light_LUK_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bLuk,15; bonus bMdef,7; },{},{}// Error parsing: 28159,Light_OP_Brooch,Light_OP_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bAllStats,10; bonus bMdef,7; },{},{}// Error parsing: 28160,Dark_STR_Brooch,Dark_STR_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bStr,15; bonus bMdef,7; },{},{}// Error parsing: 28161,Dark_AGI_Brooch,Dark_AGI_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bAgi,15; bonus bMdef,7; },{},{}// Error parsing: 28162,Dark_VIT_Brooch,Dark_VIT_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bVit,15; bonus bMdef,7; },{},{}// Error parsing: 28163,Dark_INT_Brooch,Dark_INT_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bInt,15; bonus bMdef,7; },{},{}// Error parsing: 28164,Dark_DEX_Brooch,Dark_DEX_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bDex,15; bonus bMdef,7; },{},{}// Error parsing: 28165,Dark_LUK_Brooch,Dark_LUK_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bLuk,15; bonus bMdef,7; },{},{}// Error parsing: 28166,Dark_OP_Brooch,Dark_OP_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bAllStats,10; bonus bMdef,7; },{},{}

 

[Mhalicot]

That's weird, I tested it on perl 5.16 and perl 5.12, and it fully works (and the documentation also confirms so http://perldoc.perl.org/perl5100delta.html#Named-Capture-Buffers / http://perldoc.perl.org/perlre.html#%28?%27NAME%27pattern%29 ) o.o

What OS, out of curiosity? Also, what does this output? Any errors?

perl -e 'my $a="it doesnt workn";$a =~ s/(?<a>.*)nt/$+{a}/; print $a;'

Still errors: 

// Error parsing: 28153,Light_STR_Brooch,Light_STR_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bStr,15; bonus bMdef,7; },{},{}// Error parsing: 28154,Light_AGI_Brooch,Light_AGI_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bAgi,15; bonus bMdef,7; },{},{}// Error parsing: 28155,Light_VIT_Brooch,Light_VIT_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bVit,15; bonus bMdef,7; },{},{}// Error parsing: 28156,Light_INT_Brooch,Light_INT_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bInt,15; bonus bMdef,7; },{},{}// Error parsing: 28157,Light_DEX_Brooch,Light_DEX_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bDex,15; bonus bMdef,7; },{},{}// Error parsing: 28158,Light_LUK_Brooch,Light_LUK_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bLuk,15; bonus bMdef,7; },{},{}// Error parsing: 28159,Light_OP_Brooch,Light_OP_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bAllStats,10; bonus bMdef,7; },{},{}// Error parsing: 28160,Dark_STR_Brooch,Dark_STR_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bStr,15; bonus bMdef,7; },{},{}// Error parsing: 28161,Dark_AGI_Brooch,Dark_AGI_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bAgi,15; bonus bMdef,7; },{},{}// Error parsing: 28162,Dark_VIT_Brooch,Dark_VIT_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bVit,15; bonus bMdef,7; },{},{}// Error parsing: 28163,Dark_INT_Brooch,Dark_INT_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bInt,15; bonus bMdef,7; },{},{}// Error parsing: 28164,Dark_DEX_Brooch,Dark_DEX_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bDex,15; bonus bMdef,7; },{},{}// Error parsing: 28165,Dark_LUK_Brooch,Dark_LUK_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bLuk,15; bonus bMdef,7; },{},{}// Error parsing: 28166,Dark_OP_Brooch,Dark_OP_Brooch,30000,,100,,0,,0,0xFFFFFFFF,7,2,136,,20,0,0,{ bonus bAllStats,10; bonus bMdef,7; },{},{}

something wrong with your custom script,

Missing type of item

// ID,AegisName,Name,Type,Buy,Sell,Weight,ATK,DEF,Range,Slots,Job,Upper,Gender,Loc,wLV,eLV,Refineable,View,{ Script },{ OnEquip_Script },{ OnUnequip_Script }