SQL / TXT / XML konvertierung

[vbacoder 1]

Hi comm,

Ich nutzte etwas veraltete Files (Rev41K) mit item_proto / mob_proto als TXT und nicht als SQL in itemproto@player

Nun habe ich die Kori Files ausprobiert, und stellte fest, dass diese die Datenbanktabellen nicht als TXT sondern wieder SQL-Format verwenden.

Nun zu meiner Frage ...

Wie kann ich die alten item_proto.TXT nun zu SQL (Query) konvertieren?

oder Umstellen, dass wieder TXT angesprochen wird,

Oder zur Not auch die XML vom Client zu SQL kobvertieren.





Ich freue mich auf eure Hilfe

LG,

Edited August 24, 2022 by Metin2 Dev
Core X - External 2 Internal

[Socialized 57]

You could use the reverse dump_proto tool which was released by Alpha a few months ago.

It'll convert given item_proto and mob_proto files to *.txt files.

 

(I attached the archive because the download isn't working anymore!)

This is the hidden content, please

• Sign In
• or
• Sign Up

[vbacoder 1]

i already have the TXT file. I want to convert it ti SQL :S

[Socialized 57]

Why the hell would you want to do this?

As far as I know there should be a config option that allows you to control the prefered Proto format.

 

You could use an older standard database (34-40k+) for your conversion issues.

The standard dbcache should mirror the proto files into the database when loading the *.txt files.

[vbacoder 1]

I cant find such an config option in Kori Files 1.3.

I tried using old DB Core and item_proto TXT and started the Servers Database Core.. There are no changes at item_proto@player in the MySQL Database :S

 

 

[Socialized 57]

That's almost impossible. Every dbcache with a revision higher than 34k executes MirrorItemTableIntoDB() and MirrorMobTableIntoDB()

These two functions execute an async. REPLACE query.

Is it possible that you've commented out those two functions?

[Sonitex 1676]

Just now, vbacoder said:

I cant find such an config option in Kori Files 1.3.

I tried using old DB Core and item_proto TXT and started the Servers Database Core.. There are no changes at item_proto@player in the MySQL Database :S

 

 

Go to /usr/home/game2/Channels/db and there is a txt file called conf. Edit the line NO_TXT

1 hour ago, Socialized said:

You could use the reverse dump_proto tool which was released by Alpha a few months ago.

It'll convert given item_proto and mob_proto files to *.txt files.

 

(I attached the archive because the download isn't working anymore!)

ProtoReaderRelease.rar

Does anyone have this tool, I really need it? I can't download it 

[vbacoder 1]

@Sonitex

THX, working but Server dont start anymore.

ps says: core1 - ch1 crashed

Syserr of Database (4 lines because everything would be to much ):

SYSERR: Mar 13 15:55:18 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, 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, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34038, "¾Æ±â Àü°©¹é»çÀÚ", "Kugel", 1, 5, 0, 1,
SYSERR: Mar 13 15:55:18 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, 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, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34039, "¾Æ±â Àü°©¹é»çÀÚ", "Yeti", 1, 5, 0, 1, 
SYSERR: Mar 13 15:55:18 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, 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, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34040, "¾Æ±â Àü°©¹é»çÀÚ", "Fox", 1, 5, 0, 1, 0
SYSERR: Mar 13 15:55:18 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, 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, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34041, "¾Æ±â Àü°©¹é»çÀÚ", "Turtle", 1, 5, 0, 1

[Sonitex 1676]

Tables have more columns than the TXT files I think

[vbacoder 1]

Any solving idea for this ?