It's Punky Brewster

The Quartersize Quarterback (1x2)

:

Glomer gives Allen the abilities of a pro football player. Allen wins a spot on the Chicago Bears roster, but that night Glomer tells Punky that Allen's magic has a time limit.