TBLs - Encoding / Decoding Algorithms

[MarcoNecroX]

Hello all,

I am currently working on implementing a database system using MySQL and the txt/tbl files from the game. The main idea here is to be able via PHP to create scripts to modify txt files or just create scripts to create dynamic content for the players. Full details can be seen here.

Anyways - I successfully created a PHP script to convert txt files into databases (if anyone is interested, I can post it). My problem now is the tbl files. I am wondering if it's possible to upload a tbl file and have PHP decode the contents of it so that it can be inserted into a database. I'd like to know if the algorithm is public, like the one "d2tbl edit" uses to convert tbl files into txt and vice-versa.

[kingpin]

what you could do is convert it to excel file (or text file) then convert it back to tbl format after or check the source of any tbl editor (pretty sure it's around)

[MarcoNecroX]

Yeah, I know I can manually create the txts with Joel's tool, but I am looking a way to automate it so I can remove that extra step everytime I want to do some importing/exporting.

So far no luck with finding a source published here. I've come across this topic, but links seem to be down.

[Necrolis]

Take your pick, convert away:

QTblSource: https://github.com/kambala-decapitator/QTblEditor
AFJ Tbl Editor Source: https://d2mods.info/filecenter/dload.ph ... le_id=1502
Purge (with Source): https://d2mods.info/filecenter/dload.ph ... le_id=1438

I'd recommend purge as its the simplest of the tools

[MarcoNecroX]

Was checking purge, according to readme it edits .txt, not tbls (well it does not specifically state it). Anyways will look into it.

Thanks for the links!

[Necrolis]

Was checking purge, according to readme it edits .txt, not tbls (well it does not specifically state it). Anyways will look into it.

You are correct =| Nef wrote something for parsing tbl files, remembered it as being purge but it seems not... QTblEditor would be your best bet then.

[MarcoNecroX]

Ok don't worry - I'll check QTbl. Thanks again

[Cai_Miao-BTH]

Any advantages to translator?