Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
4 registered (Dj Aero, capnbob, Morgan, id242), 46 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 04/12/04
Posts: 154
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 18
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#181879 - 04/01/07 09:09 PM Change all email addresses by SQL query?
ThreadsUser Offline
member
Registered: 11/22/06
Posts: 163
Is it possible to perform an SQL query to change all member email addresses to the same email address to save me doing this individually? I would like to change all publicly displayed and real email addresses to samename@company.com

Thankyou.
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#181883 - 04/01/07 09:37 PM Re: Change all email addresses by SQL query? [Re: ThreadsUser]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
I don't really see why you'd want to do this, but a simple mysql query:
 Code:
UPDATE `ubbt_USER_PROFILE` SET `USER_DISPLAY_EMAIL` = 'user@domain.com';


Just execute via the sql command section of your control panel.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#181886 - 04/01/07 09:44 PM Re: Change all email addresses by SQL query? [Re: Gizmo]
ThreadsUser Offline
member
Registered: 11/22/06
Posts: 163
Great thanks.
Top
#182091 - 04/05/07 05:38 AM Re: Change all email addresses by SQL query? [Re: ThreadsUser]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Lol it's getting to me, so I have to ask...

Why would you want to change the public email of every user to be the same email address?
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181698 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image