Heyas
Basically, I want to replace every mention of a phrase in my XF forum posts, profile comments, PCs, and so on to something else. Specifically, I want to change every occurrence of:
"http://fs1.mydomain.net/public/style_emoticons/<#EMO_DIR#>/*"
To:
"http://smileys.mydomain.net/*"
With * being a wildcard of whatever smiley image comes after.
For what it's worth: pretty much all occurrences of this are wrapped in tags.
Basically, help me out here, which queries would I need to run on MySQL 5.1.52 to do this?
Cheers
Basically, I want to replace every mention of a phrase in my XF forum posts, profile comments, PCs, and so on to something else. Specifically, I want to change every occurrence of:
"http://fs1.mydomain.net/public/style_emoticons/<#EMO_DIR#>/*"
To:
"http://smileys.mydomain.net/*"
With * being a wildcard of whatever smiley image comes after.
For what it's worth: pretty much all occurrences of this are wrapped in tags.
Basically, help me out here, which queries would I need to run on MySQL 5.1.52 to do this?
Cheers