Yes, he pulled his thigh muscle taking the penalty and he'll most likely miss the rest of the season now.
Napoli could use him, but as I said he'd be nothing more than a bench player and I'm not sure that'll be good enough for his huge ego.
If he wants to play regularly then the MLS is probably the best choice. If not, then maybe Serie B...