SQL Item Database to TXT

[rans]

Hello,

is there any way to convert SQL item_db2 into TXT item_db?

Thanks!

Edited September 17, 2017 by Secrets

[rans]

Just now, Kaze said:

http://nn.ai4rei.net/dev/eatoys/item-db.htm

Uhm this is txt to sql. Im looking for sql to txt

[rans]

Just now, Kaze said:

Lazy

I wouldnt post here if i ddnt search on google  
even the link you gave me give the wrong result.

Im looking for SQL to TXT not TXT to SQL. try to read sometimes it helps.

[Secrets]

Export your database as a SQL file then remove all occurences of NULL, do some regex magic to remove quotes and add braces to item scripts.

That's how I did it back then.

Bingo, you have your TXT database

REPLACE INTO `item_db_re` VALUES (501,'Red_Potion','Red Potion',0,50,NULL,70,NULL,NULL,NULL,NULL,0xFFFFFFFF,63,2,NULL,NULL,NULL,NULL,NULL,'itemheal rand(45,65),0;',NULL,NULL);

501,Red_Potion,Red Potion,0,50,,70,,,,,0xFFFFFFFF,63,2,,,,,,{ itemheal rand(45,65),0; },{},{}

 

[rans]

3 hours ago, Secrets said:

Export your database as a SQL file then remove all occurences of NULL, do some regex magic to remove quotes and add braces to item scripts.

That's how I did it back then.

Bingo, you have your TXT database

REPLACE INTO `item_db_re` VALUES (501,'Red_Potion','Red Potion',0,50,NULL,70,NULL,NULL,NULL,NULL,0xFFFFFFFF,63,2,NULL,NULL,NULL,NULL,NULL,'itemheal rand(45,65),0;',NULL,NULL);

501,Red_Potion,Red Potion,0,50,,70,,,,,0xFFFFFFFF,63,2,,,,,,{ itemheal rand(45,65),0; },{},{}

 

Hi thanks for answering!
now i have idea

[Deleted User]

6 minutes ago, Thaddeus said:

Hello,

is there any way to convert SQL item_db2 into TXT item_db?

Thanks!

http://nn.ai4rei.net/dev/eatoys/item-db.htm

[Deleted User]

Just now, Thaddeus said:

Uhm this is txt to sql. Im looking for sql to txt

Lazy