Skuballer
Comes from the word "skubala" meaning trash or shit. A skuballer is someone who thinks they're really good at a sport, and gets super cocky and obnoxious, but in reality he sucks at the fore mentioned sport.
Get the Skuballer mug.