florinp / phpbb-messenger

	}

	public function check_friend($data)

	{

		$sql = "

			SELECT COUNT(*) AS `count`

			FROM " . $this->user_friends_table."

			WHERE `user_id` = " . (int)$data['user_id']."

			 		AND `friend_id` = " . (int)$data['friend_id']."

		";

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

		$count = $this->db->sql_fetchfield('count');

		if ($count > 0) {

			return true;

		} else {

			return false;

		}

	}

	public function check_request($data)

	{

		$sql = "

			SELECT COUNT(*) AS `count`

			FROM " . $this->friends_request_table."

		}

	}

	public function check_request($data)

	{

		$sql = "

			SELECT COUNT(*) AS `count`

			FROM " . $this->friends_request_table."

			WHERE `user_id` = " . (int)$data['user_id']."

					AND `sender_id` = " . (int)$data['sender_id']."

					AND `status` = 0

			LIMIT 1

		";

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

		$count = $this->db->sql_fetchfield('count');

		if ($count > 0) {

			return true;

		} else {

			return false;

		}

	}

	public function remove_friend($user_id)

	{

		$sql = "DELETE FROM ".$this->user_friends_table." WHERE `user_id` = ".(int)$user_id."";

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