UBB.Developers Forums Community Development Programming MySQL and Server Configuration Mysql command needed

Hello everyone!

I need help with a mysql command to convert PMs. We are running an older version of threads, 6.1.1 IIRC. I want to change an admin's name in the mysql database, but want him to have his pm's and what not saved. Is there a script out there or series of mysql commands that I can submit manually, to "convert" from the old username to the new username?

The most important one to have available is PMs. That is the bare minimun, but it would be nice to be able to search posts by the new username instead of the old.

Thanks, and if you need further info, don't hesitate to ask, I'm usually on AOL IM as "p74vic".

Thanks!

Jason

Changing a user's name is fairly complicated... as a dozen tables are all matched up by the username.

Manually changing one can make things goofy.

But there's an easy change username hack which worked well for me under 6.1.1

Download it here.

Then you can totally change the user's name... and everything will update.

If you want to do it with queries, you can look at the scripts in that download for all the queries that are used to change a username under those older versions.