Jump to content

Save Chat Log To Mysql


Recommended Posts

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 by etherian
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 by eressea
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • Welcome to my store :  https://topestore.mysellix.io/fr/ 2015-2022 Aged Discord Account 2015 Discord Account : 50.99 $ 2016 Discord Account : 10$ 2017 Discord Account :3.99 $ 2018 Discord Account : 3.50$ 2019 Discord Account : 2.70 $ 2020 Discord Account :1.50$ 2021 Discord Account :0.99$ 2022 Discord Account :0.70$ Warranty :Lifetime Payment Methods : Crypto/ PayPal Contact Me On Discord Or Telegram Discord : @ultrasstore11 Telegram : https://t.me/ultrastore1 Welcome to my store :  https://topestore.mysellix.io/fr/ 2015-2022 Aged Discord Account 2015 Discord Account : 50.99 $ 2016 Discord Account : 10$ 2017 Discord Account :3.99 $ 2018 Discord Account : 3.50$ 2019 Discord Account : 2.70 $ 2020 Discord Account :1.50$ 2021 Discord Account :0.99$ 2022 Discord Account :0.70$ Warranty :Lifetime Payment Methods : Crypto/ PayPal Contact Me On Discord Or Telegram Discord : @ultrasstore11
    • L2 ArenaWar: Low Rate PvP Server with Free Buffs & Autofarm [PVP]⚔️ [Free]🆓 Classic Interlude with  3x XP rates! Free starter pack(no grade) to kickstart your adventure! Autofarm for convenient grinding! Free buffs to keep you fighting fit! (2 job buffs) No experience loss on death! (Except with Karma) Clear Karma system to keep things fair! ⚖️ Active community of 800-1k players! Join our Discord to learn more! >> Discord <<     Server website: https://l2arenawar.com/en/    
    • This is dedication! 2 years working on a problem. Congratulations!
    • You indeed have to save player position over Enterworld to properly clean it up later (if you don't, even trying to delete packet content would eventually keep it up), that's what we do with debug packet (which is a reusable Map of ExServerPrimitive packets) on aCis.   It doesn't solve the FPS stuttering - more you draw/delete lines, more your client becomes laggy. It's like if client wasn't deleting drawn points/lines properly, but instead simply hide them and redrawn content above.   If you got a solution, I would happy to integrate it.   You should check aCis#Player _debug packet integration, it allows very big amount of lines/points to be drawn, it is also reusable.   https://gitlab.com/Tryskell/acis_public/-/blob/master/aCis_gameserver/java/net/sf/l2j/gameserver/model/actor/Player.java?ref_type=heads https://gitlab.com/Tryskell/acis_public/-/blob/master/aCis_gameserver/java/net/sf/l2j/gameserver/network/clientpackets/EnterWorld.java?ref_type=heads  
    • we sell website templates, make websites to order. Great selection at very good prices. My contacts discord : advert1231 telegram : https://t.me/ggwpins  
  • Topics

×
×
  • Create New...