[shadowxaero]

Make a the following folders media>audio>ringtones>notifications>alarms and make the the folders are all inside one another and put your media files in the alarms folder and you will be able to select them for all three.

As far as text message tones, what ever notification tone you have selected will be used to your texting tone as well. If you wanted you could use ringo to assign your ringtones for things like text messaging and what not.