# Add in the message preview
if (@list) {
my @mids;
for (0 .. $#list) {
push @mids, $list[$_]->{msgs_mid};
}
my $msth = $DB->table('msgsearch')->select('msgsearch_mid', 'msgsearch_body', { 'msgsearch_mid' => \@mids });
my %mid2body;
while (my ($msg_id, $msg_body) = $msth->fetchrow_array) {
$mid2body{$msg_id} = substr($msg_body, 0, $USER->{opts}->{display}->{preview} || 100);
}
for (0 .. $#list) {
$list[$_]->{msgs_preview} = $mid2body{$list[$_]->{msgs_mid}};
}
}