Lone Wolf
Well-known member
You could use Post Content Find / Replace to find and replace the old username with the new one.
How do I used that to replace like this...
Find
[quote="Old Name, post:
Replace
[quote="New Name, post:
You could use Post Content Find / Replace to find and replace the old username with the new one.
I'm sorry. You may need to ask in the other add-on thread... I personally haven't used that add-on though.How do I used that to replace like this...
Find
[quote="Old Name, post:
Replace
[quote="New Name, post:
I'm sorry. You may need to ask in the other add-on thread... I personally haven't used that add-on though.
Possible, but please backup before doing that. Try to search for [USER=1]old username[/USER] and replace with [USER=1]new username[/USER]Is it possible to do it via a find and replace query on the database?
Possible, but please backup before doing that. Try to search for [USER=1]old username[/USER] and replace with [USER=1]new username[/USER]
Yes. And please be careful.In xf_post?
Looks good.So it should look like this....
Code:UPDATE xf_post SET message = REPLACE(message, ‘Hello’, ‘Oh Hai!’)
Looks good.
UPDATE xf_post
SET message =
REPLACE(message, ‘[USER=1]old username[/USER]’, ‘[USER=1]new username[/USER]’
Err, you did replace the user id and name with your data right? I can't help you further with this. This is a very risky situation and it is not recommended to be done without proper preparation.Ok I ran this query twice, it says loading but then nothing happens and nothing is changed...
Code:UPDATE xf_post SET message = REPLACE(message, ‘[USER=1]old username[/USER]’, ‘[USER=1]new username[/USER]’
Err, you did replace the user id and name with your data right? I can't help you further with this. This is a very risky situation and it is not recommended to be done without proper preparation.
Err, you did replace the user id and name with your data right? I can't help you further with this. This is a very risky situation and it is not recommended to be done without proper preparation.
Likes info are cached in PHP format for posts. It will not work with just database queries. But you should ask KAM.Any way to do the same thing for likes?
Surely there's no need to do this. You simply want to replace the Old Name with the New Name, so no need for all the extras around it.How do I used that to replace like this...
Find
[quote="Old Name, post:
Replace
[quote="New Name, post:
Surely there's no need to do this. You simply want to replace the Old Name with the New Name, so no need for all the extras around it.
I assumed that the usernames would be fairly unique as they are on my site and here on Xenforo (well, most are). If they aren't then of course you'll have to be more specific with regex replacement.But wont doing that replace every instance where that name is used? For example if I wanted to change Tom into John then it will change every instance of Tom into John.
If some posts/threads have an article about someone called Tom then the query will change it to an article about John. For example if there is an article saying Tom Cruise made a new film, the article will now say John Cruise made a new film.
That's why I added the
File does not exist: /home/**/domains/**.nl/public_html/xf/js/sedo/tinyquattro/tinymce/plugins/bdtagme, referer: http://**.nl/xf/index.php?media/papapapapaapapap.2/xf/js/sedo/tinyquattro/tinymce/plugins/bdtagme, referer: http://**/xf/index.php?media/papapapapaapapap.2/
We use essential cookies to make this site work, and optional cookies to enhance your experience.