Ugghhh...c'mon guys, IM the n00b here.
You shouldn't have any extraneous vp's in your main freespace directory, except for the optional media vp's that make SCP look so great. For every campaign, there should be a file folder with all the downloaded files in it, see examples above. Don't have any spaces in the names, or the word 'mod' in the front of the folder name (not confirmed, but it seemed to give me some weird errors). Since the -mod feature hasn't been around forever, there are probably some older tbls and other mod/campaign files scattered in your main data directory. I would highly suggest doing a sqeaky clean install of Retail fs2, then installing SCP with all the bells and whistles, then taking the campaign/mod files, and placing them each in their own seperate folder within the main fs2 directory. Whenever you want to play one of these campaigns, start up the FSOpen launcher, go to features, click the button that says 'mod', and select the folder that has the desired campaign in it. Then, click run. Within the main menu, go to the campaign screen, and select your mod. If you have done a clean install, and organised your mods, then it's utterly impossible to have any conflicts. Any problems you encounter are of a different nature. Having mods installed in this manner also allows you to install new ones quickly and easily, without worrying if they're going to 'screw everything up'. But please, for the love of God, reinstall. Your main data folder is probably full of custom tbls and other weird things that don't belong any more, and, just like reformatting windows, it solves all your problems.
Please forgive the redundancy, But you guys fighting over this is just silly. Now that I have said EVERYTHING possible, I think our friend Cobra should have his issues solved quite soon.
(short version: reinstall and start over, following the mod instructions everyone has given you. won't take you as long as you think)