create table Views (
id int(11),
UserId int(11),
IPAddress varchar(15),
DateAdded timestamp default current_timestamp
)

##</code><code>##

if ($session_data->{'LoggedIn'}) {
	$existing_view = $db->selectall_arrayref(qq|Select DateAdded from Views where Id = ? and (IPAddress = ? or UserId = ?)|,undef,($id,$r->connection->remote_ip,$userid));
} else {
	$existing_view = $db->selectall_arrayref(qq|Select DateAdded from Views where Id = ? and IPAddress = ?|,undef,($id,$r->connection->remote_ip));
}

##</code><code>##

unless (@$existing_view) {
 # get our cookie of id's
 if ($cookie) {
  unless ( grep { $_ == $id } @cookieids ) {
   if ($user_session_data->{'LoggedIn'} == 1) {
	$db->do(qq|Insert into Views (thread_id,IPAddress,UserId) values (?,?,?)|,undef,($id,$r->connection->remote_ip,$userid));
   } else {
	$db->do(qq|Insert into Views (thread_id,IPAddress) values (?,?)|,undef,($id,$r->connection->remote_ip));
   }
   $cookie = $existing_cookie . $new_cookie;
} else {
 $cookie = $id;
}
# set the new cookie