use strict;
use vars qw/@EXPORT_OK/;
use GForum qw/$DB $USER $CFG/;

sub getUserNewAnnouncements {
if ($USER) {

my $cutoff = shift;
if(!$cutoff) {
$cutoff = time() - (3600*24*30);
}

my $user_id = $USER->{user_id};
my $forum_id = 11; #this is the id of the announcements forum
my $last_in_forum = $DB->table('UserNew')->select('usernew_last' => { user_id_fk => $user_id, forum_id_fk => $forum_id})->fetchrow_hashref->{usernew_last};

if(!$last_in_forum || $last_in_forum < $cutoff) {
my $cond = GT::SQL::Condition->new(
forum_id_fk => '=' => $forum_id,
post_root_id => '=' => 0,
post_time => '>' => $cutoff
);

return $DB->table('Post')->count($cond);

} else {
my $cond = GT::SQL::Condition->new(
forum_id_fk => '=' => $forum_id,
post_root_id => '=' => 0,
post_time => '>' => $last_in_forum
);

return $DB->table('Post')->count($cond);
}

} else {

return 0;
}
}

1;