Chosen Solution

I have tried to solder it back together but I am not sure if I have done it right can solder arc between it self as there is a small gap in the solder I did manage to turn it back on for a few seconds then it died then when I tried again there was a spark from the power jack

It looks like these are “cold” solder joints, which means the connection between the pad and the pins are not good, which would explain the sparking. Try to touch your soldering iron to the pin and the pad and the same time to heat up both and then apply solder so it covers the pin and the pad for a flawless connection.