Making sure when I start to make maps they WILL be better than best. Want to get everything correct and perfect now. Im very close to getting the perfect water transparency, this is very close, hard to see but ingame its there definitly looks good. Anyone making maps just do this.

In the common.SHADER:
Look for the texture you made for water

// Pastel Material
textures/common/transwater2
{
Add this in here :qer_trans 0.3
surfaceparm nonsolid
qer_editorimage "textures/common/water.tga"
}
Remember that it sets the things to transparent so I tried to add it into the water and then use the useopacity script in the xml and the water came out great. The lower you make the number the more transparent.