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()

	{

	/**

	 * {@inheritdoc}

	 */

	public function get_max_id()

	{

		$sql = 'SELECT MAX(idea_id) AS max_id FROM ' . $this->ideas_table;

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

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

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

		return $max_id;

	}

	/**

	 * {@inheritdoc}

	 *

	 * @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);

	}

	/**

	 * Returns the status name from the status ID specified.