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