Player Joel Collins needed surgery after suffering what police described as a "life-changing injury" to his leg