define('RATING_PATH', $phpbb_root_path.'mods/rating/');
include (RATING_PATH.'functions_rating.'.$phpEx);
$rating_config = get_rating_config('1');
if ( $rating_config[1] == 1 )
{
   // Rated posts by this user
   $sql = 'SELECT p.post_id FROM '.POSTS_TABLE.' p, '.RATING_TABLE.' r WHERE p.poster_id = '.$profiledata['user_id'].' AND p.post_id = r.post_id LIMIT 1';
   if ( !($result = $db->sql_query($sql)) )
   {
      message_die(GENERAL_ERROR, 'Could not obtain rating information', '', __LINE__, __FILE__, $sql);
   }
   if ( $row = $db->sql_fetchrow($result) )
   {
      $u_link = append_sid('ratings.'.$phpEx.'?type=p&postedby='.$profiledata['user_id']);
      $l_link = sprintf($lang['Rated_posts_by'], $profiledata['username']);
      $template->assign_block_vars('rating', array(
         "L_LINK" => $l_link,
         "U_LINK" => $u_link
         )
      );
   }

   // If not anonymous
   if ( $profiledata['rating_status'] != 1 )
   {
      // Ratings by this user
      $sql = 'SELECT user_id FROM '.RATING_TABLE.' WHERE user_id = '.$profiledata['user_id'].' LIMIT 1';
      if ( !($result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, 'Could not obtain rating information', '', __LINE__, __FILE__, $sql);
      }
      if ( $row = $db->sql_fetchrow($result) )
      {
         $u_link = append_sid('ratings.'.$phpEx.'?type=p&ratedby='.$profiledata['user_id']);
         $l_link = sprintf($lang['Ratings_by'], $profiledata['username']);
         $template->assign_block_vars('rating', array(
            "L_LINK" => $l_link,
            "U_LINK" => $u_link
            )
         );
      }
   }
}