News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

How to reset members user names

Started by UndergroundChic, May 03, 2009, 05:27:47 PM

Previous topic - Next topic

UndergroundChic

I allowed the users in my forum to change their names freely but it turned out to be a bad idea because several changed to variations of another posters name to mess with that other poster. Is there a way I can set everyone back to the name they registered with (their original screen name)? I've searched the forum but haven't been able to find this anywhere.

CapadY

I think it should be possible with an oneline SQL script in phpMyAdmin
Please, don't PM me for support unless invited.
If you don't understand this, you will be blacklisted.

Kermit

You should just run this SQL query via phpMyAdmin

UPDATE `smf_members` SET `real_name` = `member_name`;

What is phpMyAdmin?
My Mods
Please don't PM/mail me for support,unless i invite you
Formerly known as Duncan85
Quote
"Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe."

A. Einstein


Advertisement: