Item/mob proto from xml to sql

[Denny2399 8]

Hello there. I need a little help, do you know about any item_proto and mob_proto convertor?
I have 2014-2015 protos and 40k game core. Thanks for any suggestions.

mob proto example.txt

[Woytman 107]

Try this : 

Item proto:

http://www.stevecraft.cz/hracky/ip_xml_to_sql.php

Mob proto:

http://www.stevecraft.cz/hracky/mp_xml_to_sql.php

[Denny2399 8]

53 minutes ago, Woytman said:

Try this : 

Item proto:

http://www.stevecraft.cz/hracky/ip_xml_to_sql.php

Mob proto:

http://www.stevecraft.cz/hracky/mp_xml_to_sql.php

It works, but it writes always example before the one I want

[Woytman 107]

For example? Send one line from convert and one line, how do you want to have it. //sorry bad english

[Denny2399 8]

11 minutes ago, Woytman said:

For example? Send one line from convert and one line, how do you want to have it. //sorry bad english

The one I want to convert: <Mob vnum="155" name="Li-An" locale_name="Li-An" type="0" rank="3" battle_type="4" level="24" size="0" gold_min="0" gold_max="0" exp="250" max_hp="1200" regen_cycle="15" regen_percent="20" def="29" ai_flag="1" setRaceFlag="1" setImmuneFlag="0" st="25" dx="17" ht="45" iq="9" damage_min="59" damage_max="72" attack_speed="100" move_speed="130" aggressive_hp_pct="50" aggressive_sight="2000" attack_range="175" enchant_curse="0" enchant_slow="0" enchant_poison="0" enchant_stun="0" enchant_critical="20" enchant_penetrate="20" resist_sword="0" resist_twohand="0" resist_dagger="0" resist_bell="0" resist_fan="0" resist_bow="0" resist_fire="0" resist_elect="0" resist_magic="0" resist_wind="0" resist_poison="0" resurrection_vnum="0" drop_item="0" on_click="0" empire="0" folder="tiger" dam_multiply="2.000000" summon="0" drain_sp="0" mob_color="13434828" polymorph_item="0" skill_vnum0="0" skill_level0="0" skill_vnum1="0" skill_level1="0" skill_vnum2="0" skill_level2="0" skill_vnum3="0" skill_level3="0" skill_vnum4="0" skill_level4="0" sp_berserk="0" sp_stoneskin="0" sp_godspeed="0" sp_deathblow="0" sp_revive="0" />

What I get when I click on convert: INSERT INTO `mob_proto` (`vnum`, `name`, `locale_name`, `rank`, `type`, `battle_type`, `level`, `size`, `ai_flag`, `mount_capacity`, `setRaceFlag`, `setImmuneFlag`, `empire`, `folder`, `on_click`, `st`, `dx`, `ht`, `iq`, `damage_min`, `damage_max`, `max_hp`, `regen_cycle`, `regen_percent`, `gold_min`, `gold_max`, `exp`, `def`, `attack_speed`, `move_speed`, `aggressive_hp_pct`, `aggressive_sight`, `attack_range`, `drop_item`, `resurrection_vnum`, `enchant_curse`, `enchant_slow`, `enchant_poison`, `enchant_stun`, `enchant_critical`, `enchant_penetrate`, `resist_sword`, `resist_twohand`, `resist_dagger`, `resist_bell`, `resist_fan`, `resist_bow`, `resist_fire`, `resist_elect`, `resist_magic`, `resist_wind`, `resist_poison`, `dam_multiply`, `summon`, `drain_sp`, `mob_color`, `polymorph_item`, `skill_level0`, `skill_vnum0`, `skill_level1`, `skill_vnum1`, `skill_level2`, `skill_vnum2`, `skill_level3`, `skill_vnum3`, `skill_level4`, `skill_vnum4`, `sp_berserk`, `sp_stoneskin`, `sp_godspeed`, `sp_deathblow`, `sp_revive`) VALUES (155, 'Li-An', 'Li-An', 3, 0, 4, 24, '0', 'AGGR', 0, 'ANIMAL', '0', 0, 'tiger', 0, 25, 17, 45, 9, 59, 72, 1200, 15, 20, 0, 0, 250, 29, 100, 130, 50, 2000, 175, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.000000, 0, 0, 13434828, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

The one how it has to be: INSERT INTO `mob_proto` VALUES ('155', '?? ??', 0x4C692D416E, '3', '0', '4', '24', '', 'AGGR', '0', 'ANIMAL', '', '0', 'tiger', '0', '25', '17', '45', '9', '59', '72', '1200', '15', '20', '1950', '2860', '5000', '29', '100', '130', '50', '2000', '175', '0', '0', '0', '0', '0', '0', '20', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

English:
As you can see it writes out the example before the right output. I think something is wrong with php script.
Czech:
Vypisuje to nějaký vzorový výsledek před tím který potřebuji. Myslím, že je něco špatně v php scriptu.

[Woytman 107]

Czech:

Nu podle toho co koukám tak je to správně, ta vzorová část je pro Navicat (nebo jiný sql manager), aby veděl kam ty údaje doplnit, počítá s tím, že mob_proto.sql ještě neexistuje, ten vzor slouží pro vytvoření tabulky s příslušnými sloupci, nebo pro kontrolu zda staré sloupce souhlasí s novými query.

English:

So, what I look to make it right, the sample part is for Navicat.

[Denny2399 8]

English:
Oh, now I understand. Thank you  
It would be nice to make application form from it.

Czech: 
Už rozumím. Děkuju moc  
Bylo by hezké z toho zkompilovat aplikaci/exe soubor  
Pokud se znáš s autorem, nebo jsi jím sám, tak bych tohle uvítal.