Chaosiums The Magic Book has most effects for spells your players will probably ever need.
http://www.chaosium.com/the-magic-book/
Also, for more of a fantasy setting I'd recommend Classic Fantasy which also has a good deal of old school spells. There is no one book with ALL of the BRP spells and sadly, because they are from dozens of authors, they likely never will be in one book. Everyone wants their piece.