Discussion Save Chat Log To Mysql

[ubereizen]

Hi, I'm trying to put chat log to mysql database without success.

Discuss, please.

edit: with autoupdate.

Edited July 19, 2017 by ubereizen

[etherian]

O_o

you have chat log in server folder why you want to load mysql  for chat ?
btw we use SQL server,  mysql is for l2j

Edited July 19, 2017 by etherian

[ubereizen]

O_o

 

you have chat log in server folder why you want to load mysql  for chat ?

btw we use SQL server,  mysql is for l2j

MySql or SQL. It's possible to do this? I'm trying to develop php guild chat module.

[etherian]

l2server.exe output logs, errors, chat, etc

 

i have no idea how you can make such thing

maybe someonelse know

[eressea]

You can write something that would periodically monitor server/log/chat folder (for example each second), when new file appears, open it and monitor it too - and process it until another new file appears (then just read the "old" file to the end and close it and conitnue with the new file). By "processing it" I mean reading it line-by-line, parsing that line (to get datetime, chat type, character name, recipient name (if it's PM) and insert it all to some database).

 

I would recommend using different database than the one l2cached uses - not necessarily different database server, but at least different database...

 

Of course there are other ways, for example getting logd from Master Toma - if I got it correctly, that would make it log everything to database.

 

Other way is changing chat log function in l2server (with extender of course) to log it somewhere else. In that case make sure it's nonblocking (asynchronous), otherwise it will cause lags.

Edited July 20, 2017 by eressea

[Xeonc]

http://www.maxcheaters.com/topic/211592-antispam-security-system/

 

Pay attention on our system. storing all chat logs, and not only chat but Private Store Sells/Buys/Mails and so on - too, and detecting the spam

[mwn]

http://www.maxcheaters.com/topic/211592-antispam-security-system/

 

Pay attention on our system. storing all chat logs, and not only chat but Private Store Sells/Buys/Mails and so on - too, and detecting the spam

just money making...

[eressea]

just money making...

 

Stupid bias... this really seems like a nice piece of technology. I don't like the idea of making money through l2 but this is their hard work and seems to be good product (haven't tested so it's just my personal feeling from what I've read about it)

[Xeonc]

just money making...

Right now - its almost money spending from our side, because its a big technology stack used there. We solve different real problems , and for sure I don't see any reason to make it for free