phpbb-extensions / ad-management

	* @param	int		$ad_id	Advertisement ID

	* @return	array	List of template locations for specified ad

	*/

	public function get_ad_locations($ad_id)

	{

		$ad_locations = array();

		$sql = 'SELECT location_id

			FROM ' . $this->ad_locations_table . '

			WHERE ad_id = ' . (int) $ad_id;

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

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

		{

			$ad_locations[] = $row['location_id'];

		}

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

		return $ad_locations;

	}

	/**

	* Insert advertisement locations

	* @param	int		$user_id	User ID to load memberships

	* @return	array	List of group IDs user is member of

	*/

	public function load_memberships($user_id)

	{

		$memberships = array();

		$sql = 'SELECT group_id

			FROM ' . USER_GROUP_TABLE . '

			WHERE user_id = ' . (int) $user_id . '

			AND user_pending = 0';

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

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

		{

			$memberships[] = $row['group_id'];

		}

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

		return $memberships;

	}

	/**

	* Load all board groups