Stargate SG-1 S02 E05 Need

"Saving the world... one episode at a time"

Jackson becomes addicted to the effects of a Goa'uld sarcophagus, and falls for the planet's manipulative princess.