phpbb-extensions / ad-management

	* @param	array	$data	New ad data

	* @return	int		New advertisement ID

	*/

	public function insert_ad($data)

	{

		$data = $this->intersect_ad_data($data);

		$sql = 'INSERT INTO ' . $this->ads_table . ' ' . $this->db->sql_build_array('INSERT', $data);

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

		return $this->db->sql_nextid();

	}

	/**

	* Update advertisement

	* @param	array	$data	List of data to update in the database

	* @return	int		Number of affected rows. Can be used to determine if any ad has been updated.

	*/

	public function update_ad($ad_id, $data)

	{

		$data = $this->intersect_ad_data($data);

		$sql = 'UPDATE ' . $this->ads_table . '

			SET ' . $this->db->sql_build_array('UPDATE', $data) . '

			WHERE ad_id = ' . (int) $ad_id;

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

		return $this->db->sql_affectedrows();

	}

	/**

	* Delete advertisement