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}

	* @param	int		$ad_id	Advertisement ID

	* @return	mixed	Array with advertisement data, false if ad doesn't exist

	*/

	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;

	}

	/**

	* Get one ad per every location

	 *

	 * @return	array	List of all ads

	 */

	public function get_all_ads()

	{

		$sql = 'SELECT ad_id, 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 . '

			ORDER BY group_name ASC';

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

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

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

		return $groups;

	}

	/**

	* Make sure only necessary data make their way to SQL query