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_PHPBB_ADS_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_priority, ad_name, ad_enabled, ad_end_date, ad_views, ad_clicks, ad_views_limit, ad_clicks_limit

			FROM ' . $this->ads_table;

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

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

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

		return $data;

	}

	/**

	 * Get all owner's ads

	 * @param    int $user_id Ad owner

	 * @return    array    List of owner's ads

	 */

	public function get_ads_by_owner($user_id)

	{

		$sql = 'SELECT ad_name, ad_views, ad_clicks

			FROM ' . $this->ads_table . '

			WHERE ad_owner = ' . (int) $user_id;

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

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

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

		return $data;

	}

	/**

	 * Increment views for specified ads

	 *

	 * @return	array	List of groups

	 */

	public function load_groups()

	{

		$sql = 'SELECT group_id, group_name, group_type

			FROM ' . GROUPS_TABLE . "

			WHERE group_name <> 'BOTS'

			ORDER BY group_name ASC";

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

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

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

		return $groups;

	}

	/**

	 * @param	int	$ad_id	Advertisement ID

	 * @return	array	Array with advertisement data

	 */

	public function get_ad($ad_id)

	{

		$sql = 'SELECT *

			FROM ' . $this->ads_table . '

			WHERE ad_id = ' . (int) $ad_id;

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

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

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

		return $data !== false ? $data : array();

	}

	/**

	 * Get one ad per every location