Youtube plastic welding. Get a harbor freight soldering gun and go to town.

Unless you have the missing chunk its pretty much totalled

You can build a new adapter from conduit parts. Buy the official one or buy a valve with one built in.

Rain barrels are illegal here blah blah blah