UBB.Developers Forums UBB.threads 7 Development How Do I? Moved users files folder need to update db

I moved the folder "files" that contain the uploads. Also users avatars folder too now images and avatars are not showing up...

old path to avatars
/home/domain/public_html/threads/files/images

old path to files
/home/domain/public_html/threads/files/

New paths
/home/domain/public_html/files/
/home/domain/public_html/files/avatars

is there a way to change this via a sql statement?

for posts:
update w3t_Posts SET B_Body = REPLACE(B_Body, '/old/path/','/new/path/');

for avatars:
update w3t_Users SET U_Picture = REPLACE(U_Picture, '/old/path/','/new/path/');

for signatures:
update w3t_Users SET U_Signature = REPLACE (U_Signature , '/old/path/','/new/path/');

Now do I use the "path" or the URL?

I would assume the path. but in posts doesn't use the url?

Ok I looked at some source and I need to specify the URL... "http://path/to/file/"


Thank you it worked