It's Punky Brewster S01 E02 The Gold Rush / Phar Out Pharoah

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.