Textures are loaded from the /ufoai/base/textures folder. If you have a bunch of
.pk3 files in your /base/ folder, you can unpack those to see the textures (they can be unpacked with any unzipping utility, like
7zip).
To apply a texture to a brush in your map, select the brush and then select the texture from the textures tab.