A former Premier League striker turned out for a Sunday league side after what was described as "a joke down the local pub".