Forums » General

Chat data mining

12»
Mar 26, 2012 CrazySpence link
If you are or are not aware, for years I have been recording character names that talk on chat, recording them and when they were last seen to compile some activity data on vo

The results are an @seen and @online command on #vrelay on slashnet that tells you when someone last spoke and who last spoke within a 30minute window and http://spenced.com/~spencep/vo/stats.php

for the last 78 days I have also been recording the chatter, not really sure what I'd do with it other than resolve he said she said disputes on 100.

In any event, I have converted the data into physical form, I mainly created it for the time based activity graph, the additional statistics are just gravy:

http://spenced.com/~spencep/vo/100/

The data auto updates every day at midnight EST, all times are EST as well

--CrazySpence Data mining corp
Mar 26, 2012 Minen link
Likes this , very neat CS

+9999999
Mar 26, 2012 blood.thirsty link
ye sure quote pickin' is random?

highest probability quote fer Esp and FBP should have bin "lulz"
mine should have shown a reference to a space sector : ]
Mar 26, 2012 Touriaus link
Gosh you guys talk too much
Mar 26, 2012 TheRedSpy link
Hahaha. I win!
Mar 26, 2012 RifterBoom link
FAMY pwns 100!!!

nice work ladies and germs!

FAMY!!!
-Rifter...Boom!
Mar 26, 2012 PaKettle link
Conclusive proof of Famy's constant trash talking on 100.....

Stats by guild ?
Mar 26, 2012 Pizzasgood link
Cool.
Mar 26, 2012 CrazySpence link
my bad, the times are GMT. heh
Mar 26, 2012 tarenty link
23 Mecha Touriaus 2 days ago "just keep hovering your mouse over sectors until you find one"

Baekma Goji 4 days ago "especially when it says Entering Interstellar"

lol
Mar 27, 2012 CrazySpence link
That's gold Jerry, GOLD!
Mar 27, 2012 Savet link
Wow, I'm mentioned more often than FBP. That's got to be an achievement of some sort. Spence, could I get a data dump of the lines where I am mentioned?
Mar 27, 2012 pr-orca link
I wonder how many times FBP and TRS are mentioned by acronym instead of name. I think the stats don't include those.
Mar 27, 2012 TheRedSpy link
The same goes for everyone. "CD" "PC" "Esp" "Sav" "CS" "ARF" "FF" etc.. etc..

You'd need to train the bot to look for those specific abbreviations and associate them with the nick.
Mar 28, 2012 Savet link
Shhhh....we're gonna see some Savet luvin'
Mar 30, 2012 Savet link
Spence...you mentioned login creds for the database....but I'm not seeing them.
Mar 30, 2012 CrazySpence link
vo_ro/readonly
Mar 31, 2012 Savet link
got a full url?

404 for everything from the base url up to the path specified above. I'm probably doing it wrong.
Jul 03, 2012 blood.thirsty link
bumped fer big brotha
Jul 03, 2012 Faille Corvelle link
Aww... I just missed out on the top 25... I gotta speak up more...

Faille