Author Topic: Chat and City AI statistics (Read 10517 times)

Novel · « **on:** January 22, 2011, 12:26:41 pm »

Hello

I have written a small script which count how many Cais one person have done and it count the most spammers in chat.

Should work for AoC also. Have fun with it

use:

info chat
info city

Zweiblum · « **Reply #1 on:** January 22, 2011, 05:37:12 pm »

Hey,

very nice idea!
Orgs loves it already

But how does it work?
Because we have some People counted who never did a raid...

Novel · « **Reply #2 on:** January 22, 2011, 07:37:17 pm »

They did a raid. If a cai started write the !city script a line in sql table. You can see it in log if you type !city. I only count the started cais of a player.Its a simple SQL command.

For the chat i write ever written line in sql DB. (On large chat bots it can be an overheap) And count it again at every !info command.

Zweiblum · « **Reply #3 on:** January 23, 2011, 09:59:22 am »

ok then

might be a long time ago then!

thx for this awesome piece of script

Slacklin · « **Reply #4 on:** January 23, 2011, 12:23:03 pm »

After looking over the code it looks like every chat line is saved in the DB? That will make the database balloon out of control really fast IMO.

Otherwise great work!

Novel · « **Reply #5 on:** January 23, 2011, 12:28:24 pm »

It does. So no script for larg chat bot. I have it in my guild with 100k+ lines and runs fast. If I get some time I will improve it

Slacklin · « **Reply #6 on:** January 24, 2011, 09:24:08 pm »

Would it be possible to change it so that only the last line from each unique person was displayed and stored with an accumulated total?

Might be a good way to alter it without loss of too much info.