XF 2.3 A way to search for all posts containing <text string> posted by Anonymous?

[haqzore]

We migrated from phpBB to XF 2 months ago.

Before the migration, an Admin pruned some inactive users. One of those pruned users came back, and we'd like to tie their posts to their newly registered account. The posts migrated & show as Anonymous (no linked username, etc... Just a black text username).

Since this user had the habit of "signing" most of their posts (as part of the post text) with their username -- is it possible to search for all posts containing that text string + posted by Anonymous? (I can't do perform a standard search, as Anonymous isn't a valid username in the search criteria), and then merge them into the newly registered account?

Appreciate any help / ideas.

 

[AndyB]

You might like this add-on:

https://xenforo.com/community/resources/update-guest.9053/

 

[haqzore]

With @AndyB's help, I've located 4,489 posts we'd like to re-associate with the users new account:



The addon above will not work, though, as we don't want to re-associate EVERY Anonymous post - only those who match both of the criteria (Anonymous + contains text).

 

[Mr Lucky]

The addon above will not work, though, as we don't want to re-associate EVERY Anonymous post - only those who match both of the criteria (Anonymous + contains text)

It should work once anonymous becomes an actual user account as you can search for text by that user.

 

[tajhay]

With @AndyB's help, I've located 4,489 posts we'd like to re-associate with the users new account:

View attachment 331804

The addon above will not work, though, as we don't want to re-associate EVERY Anonymous post - only those who match both of the criteria (Anonymous + contains text).

Modify the sql to update the user_id to the newly registered account. Rebuild. Boom.