Since I have upgraded to VB4 RC2 I am having problems with the smilies. When you go to post a new thread/pms or reply smilies are showing up as BB Code to the right. Shown in images below:
Attachment 107469
Attachment 107470
I have hundreds of smilies and was trying to do this so as not to have to change the path for each one.
Where do I put:
Code:
UPDATE smilie set smiliepath=replace(smiliepath, 'http://www.yoursite.com/forums/images/', 'images/')
And how do I do this? I tried putting the code above in admincp in the Execute SQL Query section in the Manuel Query box but that didn't work.