This tutorial is based on a tutorial by KungFuSquirrel (www.snarkpit.net), made by him in 2004:
http://www.snarkpit.net/snarkpower/articles/game/cat/pn/tp/71/Texture_alignment_on_curves
For me it was hard to understand the first time, so I made a short video tutorial to help other people. In my opinion, its the best (maybe not the fastest) method to texturize a cylindric brush or a curved corner.