function OnPageInit()
{
$this->o_review_item = new ReviewItem($this->GetSettings());
$this->o_review_item->SetId($_GET['item']);
$this->o_review_item->SetType($_GET['type']);
if (isset($_GET['title'])) {
$this->o_review_item->SetTitle($_GET['title']);
}
// data already sanitised in OnSiteInit
if (isset($_GET['page'])) {
$this->o_review_item->SetNavigateUrl($_GET['page']);
} elseif (isset($_SERVER['HTTP_REFERER'])) {
$this->o_review_item->SetNavigateUrl($_SERVER['HTTP_REFERER']);
}
parent::OnPageInit();
}
/**
* Reads the latest few messages posted by a specific user
* @param int $user_id
* @return ForumMessage[]
*/
public function ReadMessagesByUser($user_id)
{
$s_sql = 'SELECT nsa_forum_message.id AS message_id, nsa_forum_message.date_added AS message_date, ' . "nsa_match.short_url, nsa_match.match_title " . 'FROM nsa_forum_message INNER JOIN nsa_match ON nsa_forum_message.item_id = nsa_match.match_id AND nsa_forum_message.item_type = ' . ContentType::STOOLBALL_MATCH . ' ' . 'WHERE nsa_forum_message.user_id = ' . Sql::ProtectNumeric($user_id, false) . ' ' . 'ORDER BY nsa_forum_message.date_added DESC ' . 'LIMIT 0,11';
$result = $this->GetDataConnection()->query($s_sql);
$messages = array();
while ($o_row = $result->fetch()) {
$o_message = new ForumMessage($this->GetSettings(), AuthenticationManager::GetUser());
$o_message->SetId($o_row->message_id);
$o_message->SetDate($o_row->message_date);
$review_item = new ReviewItem($this->GetSettings());
$review_item->SetTitle($o_row->match_title);
$review_item->SetNavigateUrl($this->o_settings->GetClientRoot() . $o_row->short_url);
$o_message->SetReviewItem($review_item);
$messages[] = $o_message;
}
$result->closeCursor();
return $messages;
}
