I am sorry for the misunderstanding. :o In fact I was referring to the second module in the Adventure Path: Shackled City (i.e., Flood Season, Dungeon #98). I do not want to spoil the module, but the events are very difficult to adapt to a generic setting due to the nature of Cauldron. :(
While I think that the Adventure Path is a great idea, I would like to see a standard D&D setting. In fact, it is difficult to adapt to the Realms or to Greyhawk, just think of the second module in the series, it is almost impossible to adapt. :( My vote goes for a Forgotten Realms Adventure...