Convert din SQL in TXT

HyPerPowa95 · 02 Noi 2022, 01:40

Buna!
Caut si eu un converter din SQL in TXT
item_proto.sql --->>> item_proto.txt si item_names.txt
mob_proto.sql --->>> mob_proto.txt si mob_names.txt

HyPerPowa95 · 04 Noi 2022, 01:07

Rezolvat

04 Noi 2022, 10:17

Lasă și link sau resursa dar era postat pe forum de Ionuț

HyPerPowa95 · 04 Noi 2022, 14:30

SQL -> TXT
To convert item_proto sql to txt files, you need this script in python

http://pastebin.com/K5EDE4b6

Configuration:

You need MySQLdb on your freebsd

If you haven't it, just install it - it's a mysql library to python

Cod: Selectaţi tot

cd /usr/ports/databases/py-MySQLdb/ && make install clean

You need also change the connection properties in script

default it's:

Cod: Selectaţi tot

host_mysql = 'localhost'
user_mysql = 'mt2'
passwd_mysql = 'mt2!@#'

And if you want convert also mob_proto in this way, you need onlu change from

Cod: Selectaţi tot

#print mob_proto()

to

Cod: Selectaţi tot

print mob_proto()

in the end of file.

Scriptul python trebuie adaptat pentru propriul server, merge testat.

ABBC3_SPOILER_SHOW

Convert din SQL in TXT

Convert .xml to .txt

Convert TXT to SQL

Convert .txt -> .sql

Convert SQL TO TXT

Cine este conectat