phpbb / ideas

class m2_initial_data extends \phpbb\db\migration\migration

{

	public function effectively_installed()

	{

		$sql = 'SELECT * FROM ' . $this->table_prefix . 'ideas_statuses';

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

		$row = $this->db->sql_fetchrow($result);

		$this->db->sql_freeresult($result);

		return $row !== false;

	}

	static public function depends_on()

	{

class m4_update_statuses extends \phpbb\db\migration\migration

{

	public function effectively_installed()

	{

		$sql = 'SELECT status_id

			FROM ' . $this->table_prefix . "ideas_statuses

			WHERE status_name='New'";

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

		$row = $this->db->sql_fetchrow($result);

		$this->db->sql_freeresult($result);

		return $row === false;

	}

	static public function depends_on()

	{

	 *

	 * @return array|false The idea row set, or false if not found.

	 */

	public function get_idea($id)

	{

		$sql = 'SELECT *

			FROM ' . $this->table_ideas . '

			WHERE idea_id = ' . (int) $id;

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

		$row = $this->db->sql_fetchrow($result);

		$this->db->sql_freeresult($result);

		return $row;

	}

	/**

	 * Returns an idea specified by its topic ID.

	 *

	 * @return array|false The idea row set, or false if not found.

	 */

	public function get_idea_by_topic_id($id)

	{

		$sql = 'SELECT idea_id

			FROM ' . $this->table_ideas . '

			WHERE topic_id = ' . (int) $id;

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

		$idea_id = (int) $this->db->sql_fetchfield('idea_id');

		$this->db->sql_freeresult($result);

		return $this->get_idea($idea_id);

	}

	/**

	 * Do a live search on idea titles. Return any matches based on a given search query.

	 *

	 * @return string The idea's title

	 */

	public function get_title($id)

	{

		$sql = 'SELECT idea_title

			FROM ' . $this->table_ideas . '

			WHERE idea_id = ' . (int) $id;

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

		$idea_title = $this->db->sql_fetchfield('idea_title');

		$this->db->sql_freeresult($result);

		return $idea_title;

	}

	/**

	 * Submits a vote on an idea.