The 4 square pads are for the metal frame tabs.
Solder-pad pins 2, 3, 5, and 7 look ripped in photo, but that could just be solder not reflecting light.
Maybe you could try this:
Line up USB socket until all 10 pins align perfectly.
2 wooden clothes pegs or similar could temporarily clamp the socket to PCB.
Solder the outer pads to secure the socket in place.
Solder all ten pins where possible.
Where (if) pin-pads are broken, use single strand of clean copper wire to bridge, then nip stray ends after repair.
If you don't have flat-profile cutters (one side flat), a sturdy nail-clipper can trim loose ends of wires.