Installation instructions: Broodwar is necessary for the mod to work patched to 1.10 version (It probably works with later versions, tested with 1.07). Unzip the "prophecy files" (inside the Prophecy.zip) to the main directory of Starcraft in your hard drive. Create a folder named "Prophecy" inside the "maps" folder of Starcraft and unzip the "missions" file into there. Start the game by clicking the Vision 3.exe in the root directory of Starcraft, select the Broodwar campaign, choose a profile, load custom maps, go to the Prophecy folder and start with the first mission. The option "map settings" must be selected. The files "fortress" and "rebellion" contain extra maps while the "v3multi.zip" contains maps for multiplayer.
is this an standalone mod?
Not sure what you mean. You can have this in its own folder along with other SC campaigns/mods.