|
|
|
|
Joined: Mar 2000
Posts: 180
Member
|
|
Member
Joined: Mar 2000
Posts: 180 |
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?
|
|
|
|
|
Joined: Dec 2000
Posts: 1,471
Addict
|
|
Addict
Joined: Dec 2000
Posts: 1,471 |
Sure, backup your database and run this query:
UPDATE w3t_Users SET U_Picture = "";
|
|
|
|
|
Joined: Mar 2000
Posts: 180
Member
|
|
Member
Joined: Mar 2000
Posts: 180 |
SWEEEET!
That did it! Many thanks, Astaran...
|
|
|
|
|
Joined: Mar 2000
Posts: 180
Member
|
|
Member
Joined: Mar 2000
Posts: 180 |
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.
|
|
|
|
|
Joined: Apr 2001
Posts: 3,266
Member
|
|
Member
Joined: Apr 2001
Posts: 3,266 |
UPDATE w3t_Users SET U_Visible = 'yes'
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 21,079
Joined: March 2000
|
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
| |
Most Online5,166
Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
