This has all of the stuff you
need to know, but without the screenshots (sometimes there is a need for
screenshots) and mumbo jumbo. Just so if you
read the walkthroughs and need to go back and get a quick look, go here.

Here is where you will do most of your learning. This has step by step
tutorials on how to do make your Quake 3 maps looking great. These even
have screenshots so you don't get lost during confusing parts.

TUT02 - Shows you how to use
CSG Subtract, make an outside area, and use custom textures.

Modeling and
Skinning

Most of these tutorials are not done by me, since I am a mapping guy and
not that much of a modeling guy. Also, these will probably not have that
much on modeling players, more on modeling weapons and items due to the
lack of animation you have to do on them.

Modeling
Weapons - Shows you how to create your own weapons in 3D Studio
Max R2, then use other utilities to make them work in Q3. (I
copied this page)