+ : Help(syntax: .forum [nick] | not everyone have access to check for others.)
+{
+ my ($self,$c,$msg) = @_;
+ my $dbh = $c->model;
+
+ my $user;
+ if ($msg =~ /(\S+)/ && $c->check_user_roles('irc_forum_others')){
+ $user = $dbh->selectrow_hashref(q{
+SELECT uid,username FROM users WHERE username ILIKE ?
+ }, undef, $1);
+ }else{
+ $user = $dbh->selectrow_hashref(q{
+SELECT uid,username FROM users WHERE hostmask ILIKE ?
+ }, undef, $c->host);
+ }
+ if ($user){
+ my $unread = $dbh->selectrow_hashref(q{SELECT * FROM unread_posts($1)},undef,$user->{uid});
+ if ($unread){
+ $c->reply("$user->{username} has $unread->{new} posts since your last forum visit ($unread->{unread} unread posts in total) https://nd.ruin.nu/forum/allUnread");