/**
  * @access public
  * @return void
  * @param int[] $a_ids
  * @desc Read from the db the comments for the supplied review item
  */
 public function ReadCommentsForReviewItem(ReviewItem $review_item)
 {
     $s_person = $this->GetSettings()->GetTable('User');
     $s_message = $this->GetSettings()->GetTable('ForumMessage');
     # prepare command
     $s_sql = 'SELECT ' . $s_person . '.user_id, ' . $s_person . '.known_as, ' . 'location, ' . $s_person . ".date_added AS sign_up_date, " . $s_person . '.total_messages, ' . $s_message . '.id, ' . $s_message . '.message, ' . $s_message . ".date_added AS message_date " . 'FROM ' . $s_message . ' INNER JOIN ' . $s_person . ' ON ' . $s_message . '.user_id = ' . $s_person . '.user_id ' . 'WHERE ' . $s_message . '.item_id = ' . Sql::ProtectNumeric($review_item->GetId(), false, false) . ' AND item_type = ' . Sql::ProtectNumeric($review_item->GetType(), false, false);
     if ($this->GetReverseOrder()) {
         $s_sql .= ' ORDER BY sort_override DESC, ' . $s_message . '.date_added DESC';
     } else {
         $s_sql .= ' ORDER BY sort_override, ' . $s_message . '.date_added ASC';
     }
     # get data
     $result = $this->GetDataConnection()->query($s_sql);
     $this->Clear();
     $o_topic = new ForumTopic($this->GetSettings());
     while ($o_row = $result->fetch()) {
         $o_person = new User();
         $o_person->SetId($o_row->user_id);
         $o_person->SetName($o_row->known_as);
         $o_person->SetSignUpdate($o_row->sign_up_date);
         $o_person->SetLocation($o_row->location);
         $o_person->SetTotalMessages($o_row->total_messages);
         $o_message = new ForumMessage($this->GetSettings(), AuthenticationManager::GetUser());
         $o_message->SetId($o_row->id);
         $o_message->SetDate($o_row->message_date);
         $o_message->SetBody($o_row->message);
         $o_message->SetUser($o_person);
         $o_message->SetReviewItem($review_item);
         $o_topic->Add($o_message);
     }
     $this->Add($o_topic);
     $result->closeCursor();
 }