CREATE TABLE gforum_IgnoreUser
(
ignore_id int primary key auto_increment,
user_id_fk int(10) unsigned NOT NULL,
user_to_ignore_id int(10) unsigned NOT NULL,
UNIQUE KEY(user_id_fk, user_to_ignore_id)
);

{
'ai' => 'ignore_id',
'cols' => {
'ignore_id' => {
'form_size' => '10',
'form_type' => 'TEXT',
'not_null' => '1',
'pos' => '1',
'protect' => '1',
'type' => 'INT',
'unsigned' => '1'
},
'user_id_fk' => {
'form_size' => '10',
'form_type' => 'TEXT',
'not_null' => '1',
'pos' => '2',
'protect' => '1',
'type' => 'INT',
'unsigned' => '1'
},
'user_to_ignore_id' => {
'form_size' => '10',
'form_type' => 'TEXT',
'not_null' => '1',
'pos' => '2',
'protect' => '1',
'type' => 'INT',
'unsigned' => '1'
},
},
'fk' => {
'gforum_User' => {
'user_to_ignore_id' => 'user_id'
}
},
'fk_tables' => [],
'index' => {
'o_gm' => [
'user_id_fk',
'user_to_ignore_id'
]
},
'pk' => [
'user_id',
'user_to_ignore_id'

],
'subclass' => {},
'unique' => {}
};

package GForum::Ignore;
use strict;
use GForum qw/:user $DB $USER $IN $CFG/;
use GT::Date;

sub add_ignore{
shift;
my ( $do, $func ) = @_;
my $uid = $IN->param('user_id');
$DB->table('IgnoreUser')->insert({ user_id_fk => $USER->{user_id}, user_to_ignore_id => $uid }) if $uid and $USER;
GForum::do_func($IN->param('redo'));
}


sub disable_ignore {
shift;
my ( $do, $func ) = @_;
my $uid = $IN->param('user_id');
$DB->table('IgnoreUser')->delete(GT::SQL::Condition->new(user_id_fk=> '=' => $USER->{user_id}, user_to_ignore_id => '=' => $uid)) if $uid and $USER;
GForum::do_func($IN->param('redo'));
}

sub list_ignored {
shift;
my ($do, $func) = @_;
my $page = $func->{page};

# Retrieve Users From the IgnoreUser table that have been ignored by this particular user.
my $cond = new GT::SQL::Condition;
$cond->add(user_id_fk => '=' => $USER->{user_id});
my $ou = $DB->table('IgnoreUser' => 'User');
my $sth = $ou->select($cond);

my $users = [];

while (my $rec = $sth->fetchrow_hashref) {
push @$users, $rec;
}

return(
$page->{ignore} => {
ignored_users => $users,
has_ignored_users => scalar @$users,
}
);
}

1;

'add_ignore' => {
'action' => 'function',
'customizable' => {
'description' => '1',
'page' => '1'
},
'description' => 'Enable user account ignore',
'function' => 'GForum::Ignore::add_ignore',
},

'disable_ignore' => {
'action' => 'function',
'customizable' => {
'description' => '1',
'page' => '1'
},
'description' => 'Disabling user account ignore',
'function' => 'GForum::Ignore::disable_ignore',
},

'ignore' => {
'action' => 'function',
'customizable' => {
'description' => '1',
'disabled' => '1',
'hidden' => '1',
'min_user_status' => '1',
'page' => '1',
'page-add' => '1',
'page-del' => '1',
'user_groups' => '1',
'user_groups-add' => '1',
'user_groups-del' => '1'
},
'description' => 'Ignore',
'function' => 'GForum::Ignore::list_ignored',
'page' => {
'ignore' => 'ignore.html'
}
},

<%GForum::Utils::new_alternation('ignored_users')%>
<% loop ignored_users%>
<tr bgcolor="<%GForum::Utils::alternation('ignored_users', $odd_color, $even_color)%>">
<td style="border-right:1px solid <%dark_beige%>">
<%body_font%>
<% if user_id%>
<a href="gforum.cgi?username=<%GT::CGI::escape($user_username)%>;<%hidden_query%>"><%nbsp user_username%></a>
<small>(<a href="gforum.cgi?do=disable_ignore;redo=<%this_do%>;user_id=<%user_id%>;<%hidden_query%>">Disable Ignore</a>)</small>

<% else%>
<%nbsp user_username%>
<% endif%>
<%/body_font%>
</td>
<td style="border-right:1px solid <%dark_beige%>">
<%body_font%><%user_title%><%/body_font%>
</td>
</tr>
<% endloop%>