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; }