LCKB
strClient Lod to Query Tool - Printable Version

+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Release Zone (https://lckb.dev/forum/forumdisplay.php?fid=190)
+---- Forum: Episode 4 Releases (https://lckb.dev/forum/forumdisplay.php?fid=156)
+----- Forum: Tools (https://lckb.dev/forum/forumdisplay.php?fid=175)
+----- Thread: strClient Lod to Query Tool (/showthread.php?tid=4992)

Pages: 1 2


- nicolasg - 12-12-2022


Simple tool for convert strClient_*.lod to SQL Query



2

2

P.S: Probably bugged like all my shit.




- nicolasg - 12-12-2022


*Fix: Crash if have more IDS than strings

 

2

2




- rondo157 - 12-12-2022



1 hour ago, nicolasg said:




*Fix: Crash if have more IDS than strings



 



2



2




non support win-1251 ?




- nicolasg - 12-12-2022


Do not use it until further notice. It does not support some encodes and also removes spaces/line breaks, instead of escaping them.




- nicolasg - 12-12-2022


Well finally my idea of mixing c# and lua didn't work Big Grin. So I did all the same shit but only in c#, the dump.sql will be created in the same location where the .lod file is (Just because I like to annoy)

Added Support for Cyrillic Encode (Windows-1251)

Strings manipulations:

' TO \\'

\n TO \\n

\r TO \\R

2

2




- nicolasg - 12-12-2022


Another Update

I Change input for set column name by a selector, now based on nation selected it gonna set Encode automatically (I'm not sure about every Encode so, here have a pic about it, if u found a error please tell me)



2

2




- Desarija - 12-12-2022



56 minutes ago, nicolasg said:




Another Update



I Change input for set column name by a selector, now based on nation selected it gonna set Encode automatically (I'm not sure about every Encode so, here have a pic about it, if u found a error please tell me)



2



2



2




_ita works for me with ISO-8859-1 encoding, with utf-8 it has bugs



Same for _brz




- nicolasg - 12-12-2022


Update 6

Changed Ita & brz To ISO-8859-1 Encode

Added another character manipulation

\u0092 TO \'

To correct some characters of French strings.

2

2




- rondo157 - 12-13-2022



15 hours ago, nicolasg said:




Update 6



Changed Ita & brz To ISO-8859-1 Encode



Added another character manipulation



\u0092 TO \'



To correct some characters of French strings.



2



2




As I know PL is  utf8_unicode_ci or utf8_polish_ci




- nicolasg - 12-13-2022


Update 7

Changed pol to Windows-1250 Encode

2

2