paul999 / ajax-shoutbox-ext

	 *

	 * @return \Symfony\Component\HttpFoundation\JsonResponse

	 */

	public function getAfter($id)

	{

		if (!$this->auth->acl_get('u_shoutbox_view'))

		{

			return $this->error('AJAX_SHOUTBOX_ERROR', 'AJAX_SHOUTBOX_NO_PERMISSION', 403);

		}

		$sql    = 'SELECT c.*, u.username, u.user_colour FROM

				' . $this->table . ' c,

				' . $this->usertable . ' u

				WHERE post_time >= (

						SELECT post_time FROM ' . $this->table . '

						WHERE shout_id = ' . (int) $id . '

					)

					AND c.shout_id != ' . (int) $id . '

					AND u.user_id = c.user_id

				ORDER BY post_time DESC, shout_id DESC';

		$result = $this->db->sql_query($sql);

		return $this->returnPosts($result);

	}

	/**

	 * Get 10 shouts before the current shout ID.

	 *

	 * @return \Symfony\Component\HttpFoundation\JsonResponse

	 */

	public function getBefore($id)

	{

		if (!$this->auth->acl_get('u_shoutbox_view'))

		{

			return $this->error('AJAX_SHOUTBOX_ERROR', 'AJAX_SHOUTBOX_NO_PERMISSION', 403);

		}

		$sql    = 'SELECT c.*, u.username, u.user_colour FROM

				' . $this->table . ' c,

				' . $this->usertable . ' u

				WHERE post_time <= (

						SELECT post_time FROM ' . $this->table . '

						WHERE shout_id = ' . (int) $id . '

					)

					AND c.shout_id != ' . (int) $id . '

					AND u.user_id = c.user_id

				ORDER BY post_time DESC, shout_id ASC';

		$result = $this->db->sql_query_limit($sql, 10);

		return $this->returnPosts($result, false);

	}

	/**

	 * Loop over a SQL result set, and generate a JSON array based on the post data.