Audit_Chat

[tagban]

I think it'd be a good idea to edit this a bit, and allow auditing set for specific types of chat, for instance, in config file
audit_shout = yes/no
audit_say = yes/no
audit_system = yes/no

Would be a good start.

That way if you wanted to say, display chat messages on a website via php, it would work fine. Obviously I'm worried about ballooning the db, so things like "Shout" and "Yell" would be the best since they aren't so chatty.. and things like tells/say could be turned off so as to avoid massive spam/pings/etc.

Does the audit_chat clear out every so often?

[whasf]

Good idea, that should be easy to add.

no, it doesn't clear out, you'll have to do the housekeeping yourself for now.

[tagban]

I figured out when the php page is accessed, to have it check times/dates if I want, OR just number the newest entries, then have it delete all but the last 10 from SQL, that will make it nice. Live system in place:

bnet.cc/ffxi/chat.php

Granted, not pretty at all, I'm more trying to get all of the site's mechanics down first, then I'll move onto the fun stuff.

[whasf]

You can also have the SQL server do the work for you, like returning the last 10 chat lines:

Code: Select all

select *  from audit_chat order by lineid desc limit 10

[demolish]

Scroll down to end of map_darkstar.conf and change it so it looks like this

Code: Select all

#Audit[logging] settings
audit_chat: 0
audit_say: 0
audit_shout: 0
audit_tell: 0
audit_yell: 0
audit_linkshell: 0
audit_party: 0

You have to set audit_chat to 1 before auditing the other chats.

Once you've done that, apply the patch in this post and rebuild DSGameServer.exe.

[tagban]

Cool thanks! This should totally be committed. It'd be awesome, and with the source I posted (under Custom Apps), anyone could basically create a chat page to begin with, obviously needs quite a bit of prettiness... But for what its worth, could be nice. I will make it organized shortly.

[demolish]

Haha good luck with that!

[tagban]

Haha good luck with that!

Lol its just a matter of putting the time in on a day off. I could probably do it today, but promised a friend I'd get on and actually play some games today. But will definately edit it a bit later.

Whasf, part of my thought process is to actually clear out the older ones so the SQL Database doesn't balloon up too large, but I guess even a few thousand lines of chat wouldn't really be that bad right?

[whasf]

Haha good luck with that!

Lol its just a matter of putting the time in on a day off. I could probably do it today, but promised a friend I'd get on and actually play some games today. But will definately edit it a bit later.

Whasf, part of my thought process is to actually clear out the older ones so the SQL Database doesn't balloon up too large, but I guess even a few thousand lines of chat wouldn't really be that bad right?

It all depends on what the server operator wants. Do they want to keep a lot of history or a certain number of days, lines, etc..

[whasf]

(Attached .patch file)

Why not put both checks on the same line?

In packet_system.cpp:

Code: Select all

if (map_config.audit_chat == 1 && map_config.audit_shout==1)