UBB.Dev
Posted By: Chevy454 Is there a command for this? - 01/24/2004 6:17 PM
For a while I was allowing users to add pictures in their profiles. Well, I turned this feature off, but the pictures are still showing up, I *believe* because they are from other URLs. Well, my question is, is there a MySQL command that would "clear" this field in all the users, versus me having to do it manually for each and every user?
Posted By: Astaran Re: Is there a command for this? - 01/24/2004 7:50 PM
Sure, backup your database and run this query:
UPDATE w3t_Users SET U_Picture = "";
Posted By: Chevy454 Re: Is there a command for this? - 01/27/2004 3:52 AM
SWEEEET!

That did it! Many thanks, Astaran...
Posted By: Chevy454 Re: Is there a command for this? - 02/03/2004 5:47 AM
Ok, what command is needed to check "yes" for all the users in the "be visible on the whos online"??

I know it's gonna be almost identical to the above with the exception of the "U_picture" part, but I've looked and I'm not for sure how to figure out what exactly should go there...any advice?

Thanks.
Posted By: omegatron Re: Is there a command for this? - 02/03/2004 3:47 PM
UPDATE w3t_Users SET U_Visible = 'yes'
© UBB.Developers