Here is an excellent video by The King of Random showing you how to make black powder from charcoal, flowers of sulphur, potassium nitrate and yes stale urine.
The video also shows you how to make one of the ingredients charcoal, which can be used for many things. If you attempt this please remember to use caution when handling black powder and do so at your own risk; it is explosive and very dangerous.