$c->reply("https://nd.ruin.nu/");
}
+sub forum
+ : 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");
+ }
+ }
+}
+
1;
INSERT INTO roles VALUES('irc_getcalc');
INSERT INTO roles VALUES('irc_sendsms');
INSERT INTO roles VALUES('irc_smsstatus');
+INSERT INTO roles VALUES('irc_forum_others');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_p_nick');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_p_intel');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_getcalc');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_sendsms');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_smsstatus');
+INSERT INTO group_roles (gid,role) VALUES(1,'irc_forum_others');
INSERT INTO group_roles (gid,role) VALUES(2,'irc_gs');
INSERT INTO group_roles (gid,role) VALUES(2,'irc_scan');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_getcalc');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_sendsms');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_smsstatus');
+INSERT INTO group_roles (gid,role) VALUES(3,'irc_forum_others');
INSERT INTO group_roles (gid,role) VALUES(4,'irc_points_others');
INSERT INTO group_roles (gid,role) VALUES(4,'irc_a');
INSERT INTO group_roles (gid,role) VALUES(18,'irc_flag');
INSERT INTO group_roles (gid,role) VALUES(18,'irc_laston');
INSERT INTO group_roles (gid,role) VALUES(18,'irc_lastseen');
+INSERT INTO group_roles (gid,role) VALUES(18,'irc_forum_others');
INSERT INTO group_roles (gid,role) VALUES(19,'irc_p_intel');
INSERT INTO group_roles (gid,role) VALUES(19,'irc_h');