Stargate Atlantis S03 E03 Irresistible

"A new gate will open. A lost city will rise again."

Sheppard's team meets an obnoxious man who is adored by all thanks to a secret that he carries -- and who has an unexpected effect on them.