phpbb-extensions / ad-management

	/**

	* {@inheritDoc}

	*/

	public function effectively_installed()

	{

		$sql = 'SELECT module_id

			FROM ' . $this->table_prefix . "modules

			WHERE module_class = 'acp'

				AND module_langname = 'ACP_ADMANAGEMENT_TITLE'";

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

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

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

		return $module_id;

	}

	/**

	* {@inheritDoc}

	*

	* @return	array	List of all ads

	*/

	public function get_all_ads()

	{

		$sql = 'SELECT ad_id, ad_name, ad_enabled, ad_end_date

			FROM ' . $this->ads_table;

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

		$data = $this->db->sql_fetchrowset($result);

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

		return $data;

	}

	/**

	* Insert new advertisement to the database