All Chat window to mysql

[xavierek]

Hello some one have idea how to make all chat in game save to mysql

can i take chanal name in function on say ?

 

[chojrak]

Actually onSay has channel id as fourth parameter, but that's bad idea. Instead go handle Chat::talk or ChatChannel::talk in chat.cpp, make some messages map and store them in RAM, then each server save dump them to MySQL.

 

[xavierek]

i need it on real time to make some like chat out of tibia

 

[PhoOwned]

Maybe set 'channel' log="yes" in channels.xml and add globalevent that load channel .log file and add all to mysql (and read from mysql texts written by www users and 'sendToChannel')
If you have fast HDD and no problems with lags

 

[Paxton]

It is very easy to do actually to make it live on a website without any serious latency problems. If someone is just able to write a script for me in c++/lua that will POST the message to my php script every time someone writes something I will do the rest of sending the data straight to the client

 

[xavierek]

yeh i know use auto responder in tomecad if change send to user new messages only

 

[chojrak]

I managed like month ago to integrate my OTS with IRC, you had channel ingame called #Tibia and when you wrote something, data was sent to IRC via previously registered user, it looked like:
<time> <ots name> : <player name> [level]: msg