Bass's last seen tcl script does have a trigger for !lastspoke I beleive. It records each individual records, what that person was last seen doing along with the last time they were found doing that and also the last time they were found saying something, "!lastspoke".
I don't beleive it records, what was said on !lastspoke but only when was it said.
http://www.egghelp.org/cgi-bin/tcl_arch ... load&id=37
You can also maybe find !lastspoke in other seen scripts or modules for eggdrops. Not sure about SQL, since bass's script was written 4 years ago, and still alot of people use it. As far as I saw the database logs, they were in plain text I guess, so they really don't need to be in SQL even if they work.
As for banning people if they haven't spoken for a specified amount of time, something like this can come in handy:
Code: Select all
#Set specified idled time in minutes
set idletime "30"
if {[botisop $chan]} {return 0}
foreach user [chanlist $chan] {
if {![isbotnick $nick] && ![isop $user $chan] && ([getchanidle $user $chan] >= $idletime)} {
putserv "MODE $chan +b *!*@[lindex [split $uhost @] 1]"
putserv "KICK $chan $nick :You have been idle alot, out with you now!"
}
}
You can make this loop run at regular intervals with a continued timer and would have to integrate this within the seen script.