mob_proto xml to sql (K)

[AngelOfGod]

Sziasztok. Lenne egy olyan problémám hogy nem tudok normális xml to sql convertert találni mert amiket eddig metaláltam azok vagy nem működtek vagy rosszul csinálták.

Ezt írja a navicat:

Kód Kijelölés Kibont

1136 - Column count doesn't match value count at row 1

itt van a converter:


Ebből szeretnék szerver részt csinálni:

Kód Kijelölés Kibont

<Mob vnum="3001" name="ł¶ŔÎş´" gb2312name="Gnoll harcos" type="0" rank="0" battle_type="0" level="95" event_type="0" mob_color="0" />
<Mob vnum="3002" name="ł¶Ŕαûç" gb2312name="Gnoll íjász" type="0" rank="1" battle_type="0" level="96" event_type="0" mob_color="0" />
<Mob vnum="3003" name="ł¶ŔÎĂ´ČÄş´" gb2312name="Gnoll védelmező" type="0" rank="1" battle_type="1" level="97" event_type="0" mob_color="0" />
<Mob vnum="3004" name="ł¶Ŕδëąý»ç" gb2312name="Gnoll mágus" type="0" rank="2" battle_type="0" level="98" event_type="0" mob_color="0" />
<Mob vnum="3005" name="ł¶Ŕλó±ŢŔ屺" gb2312name="Gnoll tábornok" type="0" rank="3" battle_type="0" level="99" event_type="0" mob_color="0" />
<Mob vnum="3090" name="ł¶ŔÎÁ· şÎÁ·Ŕĺ" gb2312name="Gnoll Nagyúr" type="0" rank="4" battle_type="0" level="103" event_type="0" mob_color="0" />
<Mob vnum="3091" name="ł¶ŔÎÁ·Ŕĺ" gb2312name="Legfőbb Gnoll-őr" type="0" rank="5" battle_type="0" level="105" event_type="0" mob_color="0" />
<Mob vnum="3101" name="żÜľČĹő±Íş´" gb2312name="Egyszemű harcos" type="0" rank="0" battle_type="0" level="98" event_type="0" mob_color="0" />
<Mob vnum="3102" name="żÜľČĹő±ÍĂ´ČÄş´" gb2312name="Küklopsz katona" type="0" rank="1" battle_type="0" level="99" event_type="0" mob_color="0" />
<Mob vnum="3103" name="żÜľČĹő±Íąý»ç" gb2312name="Küklopsz mágus" type="0" rank="1" battle_type="1" level="100" event_type="0" mob_color="0" />
<Mob vnum="3104" name="żÜľČĹő±ÍŔ屺" gb2312name="Küklopsz hóhér" type="0" rank="2" battle_type="0" level="101" event_type="0" mob_color="0" />
<Mob vnum="3105" name="żÜľČĹő±Í»ó±ŢŔ屺" gb2312name="Outis tábornok" type="0" rank="3" battle_type="0" level="102" event_type="0" mob_color="0" />
<Mob vnum="3190" name="żÜľČĹő±ÍÁ· şÎÁ·Ŕĺ" gb2312name="Argosz" type="0" rank="4" battle_type="0" level="104" event_type="0" mob_color="0" />
<Mob vnum="3191" name="żÜľČĹő±ÍÁ·Ŕĺ" gb2312name="Polyphemos" type="0" rank="5" battle_type="0" level="106" event_type="0" mob_color="0" />
<Mob vnum="3201" name="ąüŔÍş´" gb2312name="Mantikór harcos" type="0" rank="0" battle_type="0" level="96" event_type="0" mob_color="0" />
<Mob vnum="3202" name="ąüŔÍĂ´ČÄş´" gb2312name="Mantikór katona" type="0" rank="1" battle_type="0" level="97" event_type="0" mob_color="0" />
<Mob vnum="3203" name="ąüŔÍąý»ç" gb2312name="Mantikór mágus" type="0" rank="1" battle_type="1" level="98" event_type="0" mob_color="0" />
<Mob vnum="3204" name="ąüŔÍŔ屺" gb2312name="Mantikór hóhér" type="0" rank="2" battle_type="0" level="99" event_type="0" mob_color="0" />
<Mob vnum="3205" name="ąüŔÍ»ó±ŢŔ屺" gb2312name="Kór tábornok" type="0" rank="3" battle_type="0" level="101" event_type="0" mob_color="0" />
<Mob vnum="3290" name="ąüŔÍÁ· şÎÁ·Ŕĺ" gb2312name="Rakshasa" type="0" rank="4" battle_type="0" level="103" event_type="0" mob_color="0" />
<Mob vnum="3291" name="ąüŔÍÁ·Ŕĺ" gb2312name="Martyaxwar" type="0" rank="5" battle_type="0" level="105" event_type="0" mob_color="0" />
<Mob vnum="3301" name="¸Á·®ş´" gb2312name="Lemur harcos" type="0" rank="0" battle_type="0" level="97" event_type="0" mob_color="0" />
<Mob vnum="3302" name="¸Á·®Ă´ČÄş´" gb2312name="Lemur katona" type="0" rank="1" battle_type="0" level="98" event_type="0" mob_color="0" />
<Mob vnum="3303" name="¸Á·®ąý»ç" gb2312name="Lemur mágus" type="0" rank="1" battle_type="1" level="99" event_type="0" mob_color="0" />
<Mob vnum="3304" name="¸Á·®Ŕ屺" gb2312name="Lemur hóhér" type="0" rank="2" battle_type="0" level="100" event_type="0" mob_color="0" />
<Mob vnum="3305" name="¸Á·®»ó±ŢŔ屺" gb2312name="Lemur tábornok" type="0" rank="3" battle_type="0" level="101" event_type="0" mob_color="0" />
<Mob vnum="3390" name="¸Á·®Á· şÎÁ·Ŕĺ" gb2312name="Lemur herceg" type="0" rank="4" battle_type="0" level="103" event_type="0" mob_color="0" />
<Mob vnum="3391" name="¸Á·®Á·Ŕĺ" gb2312name="Lemur testőr" type="0" rank="5" battle_type="0" level="105" event_type="0" mob_color="0" />
<Mob vnum="3401" name="ľîŔÎş´" gb2312name="Tritoni muréna" type="0" rank="0" battle_type="0" level="96" event_type="0" mob_color="0" />
<Mob vnum="3402" name="ľîŔÎĂ´ČÄş´" gb2312name="Cápa katona" type="0" rank="1" battle_type="0" level="97" event_type="0" mob_color="0" />
<Mob vnum="3403" name="ľîŔÎąý»ç" gb2312name="Tritoni mágus" type="0" rank="1" battle_type="1" level="98" event_type="0" mob_color="0" />
<Mob vnum="3404" name="ľîŔÎŔ屺" gb2312name="Tritoni vadász" type="0" rank="2" battle_type="0" level="99" event_type="0" mob_color="0" />
<Mob vnum="3405" name="ľîŔλó±ŢŔ屺" gb2312name="Tritoni hasító" type="0" rank="3" battle_type="0" level="101" event_type="0" mob_color="0" />
<Mob vnum="3490" name="ľîŔÎÁ· şÎÁ·Ŕĺ" gb2312name="Kappa tábornok" type="0" rank="4" battle_type="0" level="103" event_type="0" mob_color="0" />
<Mob vnum="3491" name="ľîŔÎÁ·Ŕĺ" gb2312name="Triton" type="0" rank="5" battle_type="1" level="105" event_type="0" mob_color="0" />
<Mob vnum="3501" name="şÓŔşµµŔű´Üżř" gb2312name="Vörös tolvaj amazon" type="0" rank="0" battle_type="1" level="95" event_type="0" mob_color="0" />
<Mob vnum="3502" name="şÓŔşµµŔű´Ü»ó±Ţ´Üżř" gb2312name="Vörös tolvaj orgyilkos" type="0" rank="1" battle_type="0" level="96" event_type="0" mob_color="0" />
<Mob vnum="3503" name="şÓŔşµµŔű´Üąý»ç" gb2312name="Vörös tolvaj mágus" type="0" rank="1" battle_type="1" level="97" event_type="0" mob_color="0" />
<Mob vnum="3504" name="şÓŔşµµŔű´ÜŔĺĽö" gb2312name="Vörös tolvaj hóhér" type="0" rank="2" battle_type="0" level="98" event_type="0" mob_color="0" />
<Mob vnum="3505" name="şÓŔşµµŔű´Ü»ó±ŢŔ屺" gb2312name="Fekete tábornok" type="0" rank="3" battle_type="0" level="99" event_type="0" mob_color="0" />
<Mob vnum="3551" name="ÁřşÓŔşµµŔű´Üżř" gb2312name="Brut.vörös tolvaj amazon" type="0" rank="0" battle_type="1" level="97" event_type="0" mob_color="0" />
<Mob vnum="3552" name="ÁřşÓŔşµµŔű´Ü»ó±Ţ´Üżř" gb2312name="Brut.v.tolvaj orgyilkos" type="0" rank="1" battle_type="0" level="98" event_type="0" mob_color="0" />
<Mob vnum="3553" name="ÁřşÓŔşµµŔű´Üąý»ç" gb2312name="Brut. vörös tolvaj mágus" type="0" rank="1" battle_type="1" level="99" event_type="0" mob_color="0" />
<Mob vnum="3554" name="ÁřşÓŔşµµŔű´ÜŔĺĽö" gb2312name="Brut. vörös tolvaj hóhér" type="0" rank="2" battle_type="0" level="100" event_type="0" mob_color="0" />
<Mob vnum="3555" name="ÁřşÓŔşµµŔű´Ü»ó±ŢŔ屺" gb2312name="Fehér tábornok" type="0" rank="3" battle_type="0" level="101" event_type="0" mob_color="0" />
<Mob vnum="3590" name="şÓŔşµµŔű´ÜşÎ´ÜŔĺ" gb2312name="Arccsont" type="0" rank="4" battle_type="1" level="103" event_type="0" mob_color="0" />
<Mob vnum="3591" name="şÓŔşµµŔű´Ü´ÜŔĺ" gb2312name="Vörös főnök" type="0" rank="5" battle_type="1" level="105" event_type="0" mob_color="0" />
<Mob vnum="3595" name="ÁřşÓŔşµµŔű´ÜşÎ´ÜŔĺ" gb2312name="Brutális Arccsont" type="0" rank="4" battle_type="1" level="105" event_type="0" mob_color="0" />
<Mob vnum="3596" name="ÁřşÓŔşµµŔű´Ü´ÜŔĺ" gb2312name="Brutális Vörös főnök" type="0" rank="5" battle_type="1" level="107" event_type="0" mob_color="0" />
<Mob vnum="3601" name="°©°˘Ăć" gb2312name="Tarisznyarák harcos" type="0" rank="0" battle_type="0" level="96" event_type="0" mob_color="0" />
<Mob vnum="3602" name="°©°˘ĹőĂć" gb2312name="Skorpió lövész" type="0" rank="1" battle_type="1" level="97" event_type="0" mob_color="0" />
<Mob vnum="3603" name="°©°˘±¸Ăć" gb2312name="Garnélarák katona" type="0" rank="1" battle_type="0" level="98" event_type="0" mob_color="0" />
<Mob vnum="3604" name="°©°˘ąćĂć" gb2312name="Ördögi remete" type="0" rank="2" battle_type="0" level="99" event_type="0" mob_color="0" />
<Mob vnum="3605" name="°©°˘˝ĹĂć" gb2312name="Páncélozott tarisznyarák" type="0" rank="3" battle_type="0" level="101" event_type="0" mob_color="0" />
<Mob vnum="3690" name="°Ĺ´ë°©°˘Ĺő˝ĹĂć" gb2312name="Homár tábornok" type="0" rank="4" battle_type="0" level="103" event_type="0" mob_color="0" />
<Mob vnum="3691" name="´ëżŐĹő±ÍĂć" gb2312name="Tarisznyarák király" type="0" rank="5" battle_type="0" level="105" event_type="0" mob_color="0" />
<Mob vnum="3701" name="°ĹŔÎş´" gb2312name="Gigantikus harapó" type="0" rank="0" battle_type="0" level="100" event_type="0" mob_color="0" />
<Mob vnum="3702" name="°ĹŔÎĂ´ČÄş´" gb2312name="Gigantikus mészáros" type="0" rank="1" battle_type="0" level="101" event_type="0" mob_color="0" />
<Mob vnum="3703" name="°ĹŔÎąý»ç" gb2312name="Gigantikus mágus" type="0" rank="1" battle_type="1" level="103" event_type="0" mob_color="0" />
<Mob vnum="3704" name="°ĹŔÎŔ屺" gb2312name="Duplantikus" type="0" rank="2" battle_type="0" level="104" event_type="0" mob_color="0" />
<Mob vnum="3705" name="°ĹŔλó±ŢŔ屺" gb2312name="Kampós kapitány" type="0" rank="3" battle_type="0" level="105" event_type="0" mob_color="0" />
<Mob vnum="3790" name="°ĹŔÎÁ· şÎÁ·Ŕĺ" gb2312name="Gargoyle" type="0" rank="4" battle_type="0" level="106" event_type="0" mob_color="0" />
<Mob vnum="3791" name="°ĹŔÎÁ·Ŕĺ" gb2312name="Wubba király" type="0" rank="5" battle_type="0" level="107" event_type="0" mob_color="0" />
<Mob vnum="3801" name="ŔúŔÎş´" gb2312name="Hangork" type="0" rank="0" battle_type="0" level="99" event_type="0" mob_color="0" />
<Mob vnum="3802" name="ŔúŔαûç" gb2312name="Íjász ogre" type="0" rank="1" battle_type="1" level="100" event_type="0" mob_color="0" />
<Mob vnum="3803" name="ŔúŔÎĂ´ČÄş´" gb2312name="Fegyveres ogre" type="0" rank="1" battle_type="0" level="101" event_type="0" mob_color="0" />
<Mob vnum="3804" name="ŔúŔÎąý»ç" gb2312name="Ogre mágus" type="0" rank="2" battle_type="1" level="102" event_type="0" mob_color="0" />
<Mob vnum="3805" name="ŔúŔλó±ŢŔ屺" gb2312name="Ogg tábornok" type="0" rank="3" battle_type="0" level="103" event_type="0" mob_color="0" />
<Mob vnum="3890" name="ŔúŔÎÁ· şÎÁ·Ŕĺ" gb2312name="Shruk kapitány" type="0" rank="4" battle_type="0" level="105" event_type="0" mob_color="0" />
<Mob vnum="3891" name="ŔúŔÎÁ·Ŕĺ" gb2312name="A Nagy Ogre" type="0" rank="5" battle_type="0" level="107" event_type="0" mob_color="0" />
<Mob vnum="3901" name="±Í¸ń ş¸˝ş" gb2312name="Fűz-ember" type="0" rank="5" battle_type="1" level="110" event_type="0" mob_color="0" />
<Mob vnum="3902" name="±Í¸ń ş¸˝ş" gb2312name="Eoten" type="0" rank="5" battle_type="1" level="110" event_type="0" mob_color="0" />
<Mob vnum="3903" name="±Í¸ń ş¸˝ş" gb2312name="Skouman" type="0" rank="5" battle_type="1" level="110" event_type="0" mob_color="0" />
<Mob vnum="3904" name="Áöą«˝ĹżŐ" gb2312name="Kampós kapitány" type="0" rank="2" battle_type="0" level="101" event_type="0" mob_color="0" />
<Mob vnum="3905" name="õą«˝Ĺłŕ" gb2312name="Se-Rang" type="0" rank="5" battle_type="0" level="110" event_type="0" mob_color="0" />
<Mob vnum="3906" name="Ářõą«˝Ĺłŕ" gb2312name="Jin-Hee" type="0" rank="5" battle_type="0" level="110" event_type="0" mob_color="0" />
<Mob vnum="3907" name="Čć»ç´ëąý»ç" gb2312name="Vörös tolvaj mágus" type="0" rank="1" battle_type="1" level="99" event_type="0" mob_color="0" />
<Mob vnum="3908" name="Čć»ç´ëŔĺĽö" gb2312name="Brut. vörös tolvaj hóhér" type="0" rank="2" battle_type="0" level="100" event_type="0" mob_color="0" />
<Mob vnum="3909" name="Čć»ç´ë »ó±ŢŔ屺" gb2312name="Fehér tábornok" type="0" rank="3" battle_type="0" level="101" event_type="0" mob_color="0" />
<Mob vnum="3910" name="Čć»ç´ÜŔĺ" gb2312name="Arccsont" type="0" rank="4" battle_type="1" level="103" event_type="0" mob_color="0" />
<Mob vnum="3911" name="±ć ŔŇŔş °Ĺ´ë±Í¸ń" gb2312name="Aku-Boku" type="0" rank="4" battle_type="0" level="105" event_type="0" mob_color="0" />
<Mob vnum="3912" name="żÜ·Îżî °Ĺ´ë±Í¸ń" gb2312name="Arboretum" type="0" rank="4" battle_type="0" level="105" event_type="0" mob_color="0" />
<Mob vnum="3913" name="ČĄ¶őÇŃ °Ĺ´ë±Í¸ń" gb2312name="Sycomore" type="0" rank="4" battle_type="0" level="105" event_type="0" mob_color="0" />


[Morpheus]

Talán mert hiányzik oszlop belőle.

[AngelOfGod]

Milyen oszlop?

[Signe]

szia ezeket a mobokat honnan lehet beszerzni?
ha tudnál letöltő linket azt megköszönném.

[Morpheus]

ezek béta mobok vanda

[whiteworld]

Tessék.

   http://data.hu/get/6559094/mob_proto.rar

Röviden leírom én hogy oldottam meg a Convertálást és remélem hasznát veszitek 

Kód Kijelölés Kibont

Eredeti kliens rész :

<Mob vnum="3002" name="ł¶Ŕαûç" gb2312name="Gnoll íjász" type="0" rank="1" battle_type="0" level="96" event_type="0" mob_color="0" />

Convertált : 63 oszlopból áll

INSERT INTO `mob_proto` VALUES ('3002', 'Gnoll ?j?sz', 'Gnoll ?j?sz', '1', '0', '0', '96', '', '', '0', 'ANIMAL', '', '0', 'stray_dog', '0', '3', '6', '5', '2', '20', '24', '126', '6', '7', '1800', '2700', '150', '4', '100', '100', '0', '2000', '175', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '70104', '0', '0', '0', '0', '0', '0', '0', '0', '0');

SF mob_proto.sql : 69 oszlopból áll , vagyis 6 oszlop nem stimmel , a vége így néz ki a szerver mob_protonak

null, null, null, null, null, null, '0', '0', '0', '0', '0', '0');

vagyis amit convertáltam mob_proto.xml ből ahhoz hozzá raktam notepad++ ban a 6 db    null, null, null, null, null, null,
oszlopot , úgy hogy a convertált végéről vissza számoltam a 6 db   0  -át és azok elé raktam be a 6 db
null, null, null, null, null, null, és így meg kaptam a rendes mob_proto.sql rész , és hibátlanul fogadta a szerver
remélem érthetően írtam le