UBB.threads PHP Forum Software Community Forums Resources and Customizing How Do I? Can a user's Registration Email be changed?

Hi,

We've got a user who for one reason or another wishes to change the registration email address associated with his account. I notice that this field isn't editable in the control panel. Is this possible to do at all? With a SQL query perhaps?

Thanks.

Generally there isn't much reason to change said field as it's just an indication of who they where when they registered (hence why it isn't editable); it's only really listed in the CP for the admin. If you are dead set on changing it you'll need to do so with a MySQL editing tool such as PHPMyAdmin.

Yeah, he's concerned about it being used to identify him in the unlikely event of a lawsuit or something. I'm not entirely sure what it's all about.

I just thought it seemed like something that *might* be doable so I was looking into it for him.

Unfortunately I don't have access to the PHPMyAdmin, only the CP. So I was hoping it would be something I could do from the SQL command page, maybe something like this totally made up example:


But I gather it's not that easy?

You could do:

Thanks.

Upon reflection I'm thinking perhaps I shouldn't be poking around there with my near total lack of knowledge, I'll pass the user's concerns and the above SQL command on to our owner and he can send it on to the sysadmin if he thinks it worthwhile.

Thank you for the information.

It's just a trivial piece of data that really has no meaning; I'd advise against just running queries just for the sake of aesthetics that only people with admin access will ever see... but, at the same time I realize these things matter to some people, and it's not my site...

Re register under new name and new email address.
Merge users.

I think that's how i have done it in the past. its been a while. But its not as scary as sql.
Try a test run on 2 accounts keeping an eye on what account keeps what. (Email Addresses).

Ha, that's great. I've never needed that before, so I totally forgot about that option, but it works perfectly. Talk about missing the forest for the trees.

Thanks.