| <?php |
| |
| class Informer |
| { |
| private $_db; |
| private $_pun_user; |
| private $_lang; |
| private $_pun_config; |
| |
| |
| /** |
| * Constructor |
| * |
| * @param resource $db |
| * @param array $pun_user |
| * @param array $lang |
| * @param array $pun_config |
| */ |
| public function __construct ($db, $pun_user, $lang, $pun_config) |
| { |
| $this->_db = $db; |
| $this->_pun_user = $pun_user; |
| $this->_lang = $lang; |
| $this->_pun_config = $pun_config; |
| } |
| |
| |
| /** |
| * getConfig |
| * |
| * @return array |
| * @throws Exception |
| */ |
| public function getConfig () |
| { |
| return array( |
| 'timezone' => $this->_pun_user['timezone'], |
| 'username' => $this->_pun_user['username'], |
| 'is_guest' => $this->_pun_user['is_guest'] |
| ); |
| } |
| |
| |
| /** |
| * getForums |
| * |
| * @return array |
| * @throws Exception |
| */ |
| public function getForums () |
| { |
| if (!$this->_pun_user['g_read_board']) { |
| throw new Exception ($this->_lang['No view']); |
| } |
| |
| $r = $this->_db->query(' |
| SELECT f.id AS fid, f.last_post, f.last_post_id, f.last_poster, t.subject |
| |
| FROM ' . $this->_db->prefix . 'categories AS c |
| INNER JOIN ' . $this->_db->prefix . 'forums AS f ON c.id=f.cat_id |
| LEFT JOIN ' . $this->_db->prefix . 'topics AS t ON f.last_post_id=t.last_post_id |
| LEFT JOIN ' . $this->_db->prefix . 'forum_perms AS fp ON ( |
| fp.forum_id=f.id |
| AND fp.group_id=' . $this->_pun_user['g_id'] . ' |
| AND (fp.read_forum IS NULL OR fp.read_forum=1) |
| ) |
| |
| WHERE fp.read_forum IS NULL OR fp.read_forum=1 |
| |
| ORDER BY NULL |
| ', false); |
| if (!$r) { |
| throw new Exception ($this->_db->error()); |
| } |
| if (!$this->_db->num_rows($r)) { |
| throw new Exception ($this->_lang['Bad request']); |
| } |
| |
| $data = array(); |
| while ($forum = $this->_db->fetch_assoc($r)) { |
| $data[$forum['fid']] = array( |
| 'last_post_id' => $forum['last_post_id'], |
| 'subject' => $forum['subject'], |
| 'last_post_time' => $forum['last_post'], |
| 'last_poster' => $forum['last_poster'] |
| ); |
| } |
| return $data; |
| } |
| |
| |
| /** |
| * getMessage |
| * |
| * @param int $id |
| * @return array |
| * @throws Exception |
| */ |
| public function getMessage ($id) |
| { |
| if (!$this->_pun_user['g_read_board']) { |
| throw new Exception ($this->_lang['No view']); |
| } |
| if (!$id || $id < 1 || !is_numeric($id)) { |
| throw new Exception ($this->_lang['Bad request']); |
| } |
| |
| $r = $this->_db->query(' |
| SELECT p.poster, p.message, p.hide_smilies, p.posted |
| FROM ' . $this->_db->prefix . 'posts AS p |
| INNER JOIN ' . $this->_db->prefix . 'topics AS t ON t.id = p.topic_id |
| LEFT JOIN ' . $this->_db->prefix . 'forum_perms AS fp ON ( |
| fp.forum_id = t.forum_id |
| AND fp.group_id = ' . $this->_pun_user['g_id'] . ' |
| AND (fp.read_forum IS NULL OR fp.read_forum = 1) |
| ) |
| WHERE p.id = ' . $id |
| , false); |
| |
| if (!$r) { |
| throw new Exception ($this->_db->error()); |
| } |
| if (!$this->_db->num_rows($r)) { |
| throw new Exception ($this->_lang['Bad request']); |
| } |
| |
| $data = $this->_db->fetch_assoc($r); |
| |
| return array ( |
| 'message' => $this->_parseMessage($data['message'], $data['hide_smilies']), |
| 'poster' => $data['poster'], |
| 'posted' => $data['posted'] |
| ); |
| } |
| |
| |
| /** |
| * getPrivateMessage |
| * |
| * @param int $id |
| * @return array |
| * @throws Exception |
| */ |
| public function getPrivateMessage ($id) |
| { |
| if ($this->_pun_user['is_guest'] || !$this->_pun_user['g_pm'] || !$this->_pun_user['messages_enable'] || !$this->_pun_config['o_pms_enabled']) { |
| throw new Exception ($this->_lang['No view']); |
| } |
| if (!$id || $id < 1 || !is_numeric($id)) { |
| throw new Exception ($this->_lang['Bad request']); |
| } |
| |
| $r = $this->_db->query(' |
| SELECT m.subject, m.message, m.smileys, m.posted, m.sender |
| FROM ' . $this->_db->prefix . 'messages AS m |
| WHERE m.owner = ' . $this->_pun_user['id'] . ' |
| AND m.id = ' . $id |
| , false); |
| |
| if (!$r) { |
| throw new Exception ($this->_db->error()); |
| } |
| if (!$this->_db->num_rows($r)) { |
| throw new Exception ($this->_lang['Bad request']); |
| } |
| |
| $data = $this->_db->fetch_assoc($r); |
| |
| return array ( |
| 'subject' => $data['subject'], |
| 'message' => $this->_parseMessage($data['message'], $data['smileys']), |
| 'poster' => $data['sender'], |
| 'posted' => $data['posted'] |
| ); |
| } |
| |
| |
| |
| /** |
| * getPrivateMessages |
| * |
| * @param int $limit |
| * @return array |
| * @throws Exception |
| */ |
| public function getPrivateMessages ($limit) |
| { |
| if ($this->_pun_user['is_guest'] || !$this->_pun_user['g_pm'] || !$this->_pun_user['messages_enable'] || !$this->_pun_config['o_pms_enabled']) { |
| throw new Exception ($this->_lang['No view']); |
| } |
| if (!$limit || $limit < 1 || !is_numeric($limit)) { |
| throw new Exception ($this->_lang['Bad request']); |
| } |
| |
| $r = $this->_db->query(' |
| SELECT m.id, m.subject, m.message, m.smileys, m.posted, m.sender |
| FROM ' . $this->_db->prefix . 'messages AS m |
| WHERE m.owner = ' . $this->_pun_user['id'] . ' |
| ORDER BY m.id DESC |
| LIMIT ' . $limit |
| , false); |
| |
| if (!$r) { |
| throw new Exception ($this->_db->error()); |
| } |
| if (!$this->_db->num_rows($r)) { |
| return array(); |
| } |
| |
| |
| $out = array(); |
| while ($data = $this->_db->fetch_assoc($r)) { |
| $out[$data['id']] = array ( |
| 'subject' => $data['subject'], |
| 'message' => $this->_parseMessage($data['message'], $data['smileys']), |
| 'poster' => $data['sender'], |
| 'posted' => $data['posted'] |
| ); |
| } |
| return $out; |
| } |
| |
| |
| /** |
| * _parseMessage |
| * |
| * @param string $message |
| * @param bool $hide_smilies |
| * @return string |
| */ |
| private function _parseMessage ($message, $hide_smilies = false) |
| { |
| require_once __DIR__ . '/../parser.php'; |
| return parse_message($message, $hide_smilies); |
| } |
| } |
| ?> |
