UBB.Developers Forums UBB.threads 7 Development How Do I? Is there a simple query to clear the displayed email address for all users?

Print Thread

Rate Thread

Is there a simple query to clear the displayed email address for all users? #282145 11/20/2004 5:29 AM
Joined: Mar 2002 Posts: 193 Conrad Member
Conrad Member Joined: Mar 2002 Posts: 193	Obviously the real email addresses must remain untouched, but I'd like to wipe the slate clean with regards to publicly displayed email addresses. Can I run a query which will quickly clear this field for all users? Just want to do this as a one-time step, not worried if people fill these in again...

Sponsored Links

Re: Is there a simple query to clear the displayed email address for all us CHOELIN #282146 11/20/2004 7:38 AM
Joined: Aug 2002 Posts: 1,191 Vienna, Austria dimopoulos Kahuna
dimopoulos Kahuna Joined: Aug 2002 Posts: 1,191 Vienna, Austria	You can use the following query: UPDATE w3t_Users SET Fakeemail = ''; You must change the w3t_ prefix if you have a different one for your installation. Nikos

Re: Is there a simple query to clear the displayed email address for all us Hal_dup2 #282147 11/20/2004 2:14 PM
Joined: May 2001 Posts: 550 Austria Anno Code Monkey
Anno Code Monkey Joined: May 2001 Posts: 550 Austria	That would be Code UPDATE w3t_Users SET U_Fakeemail = '';

Hop To

Link Copied to Clipboard

Donate Today!

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.

Recommended Hosts

We have personally worked with and recommend the following Web Hosts:
• Shock Hosting
• Stable Host
• bluehost
• InterServer

Visit us on Facebook

June
S	M	T	W	T	F	S
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30

Member Spotlight

Gizmo
Portland, OR, USA

Posts: 5,834
Joined: January 2000

Forum Statistics

Forums63

Topics37,583

Posts293,955

Members13,824

Most Online151,614
Nov 14th, 2025

Today's Statistics

Currently Online 1336

Topics Created 0

Posts Made 0

Users Online 0

Birthdays 3