SCREENSHOT: http://www.hawkee.com/profile/img/1014731/

This is a module for MySQL Bot Core system.
You'll need http://www.hawkee.com/snippet/8882/ in case for this to work.

PHP Side for this script: http://www.hawkee.com/snippet/8963/

MySQL Database Structure:

CREATE TABLE `chanstatus` (
  `channel` varchar(50) NOT NULL,
  `nickname` varchar(50) NOT NULL,
  `status` tinyint(6) unsigned NOT NULL,
  `idle` smallint(5) unsigned NOT NULL,
  `address` varchar(100) NOT NULL,
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7687 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

; MySQL Bot Core
; Module: Live Status
; Version: 1.00 STABLE
; Author: Nils Putnins (Neisen@Neisen.lv)

; - aliases
alias -l m.activity.status return $replace($left($nick($1,$2).pnick,1),~,5,&,4,@,3,$chr(37),2,+,1)
alias -l m.activity {
  if ($prop == sync) {
    var %sql = DELETE FROM `chanstatus` | noop $mysql_query(%m.sql, %sql)
    var %sql = INSERT INTO `chanstatus` (`channel`,`nickname`,`status`,`idle`,`address`) VALUES (?, ?, ?, ?, ?)
    var %channels = $chan(0)
    while %channels {
      var %channel = $chan(%channels), %users = $nick(%channel,0)
      while %users {
        var %user = $nick(%channel,%users)
        noop $mysql_query(%m.sql, %sql, %channel, %user, $m.activity.status(%channel,%user), $nick(%channel,%user).idle, $remove($address(%user,0),*!))
        dec %users
      }
      dec %channels
    }
  }
}

; - communicating with core
on *:SIGNAL:m.modules:{
  m.modules $+(Live Status,$chr(124),$chr(124),0)
  noop $m.activity().sync
}