One of our editors, Astenon, has written up an introduction to the Neverwinter Nights' scripting language. He has given a rundown on what you'll be able to do, what you won't be able to do, the script's limitations, and more. You can find it all right here.