emm cylindrical wrap it and then planar map the ends.... then export the UV map to PS and paint away. Then assign the tif or tga to the shader and then you're done.... should be simple enough