Mass-merging user accounts - how?

[tobias_t]

Hi everybody,

For reasons that are too complex to describe here, we have a large number of forum accounts that share e-mail addresses (mostly in pairs of two). We need to resolve this for a planned forum upgrade that requires every account to have a unique email address.

We now want to batch-merge these "twin accounts" according to certain criteria, so that for example the account with the higher post count (or the more recent "last activity" date) absorbs the posts of the other account, which then gets deleted.

The existing merge function obviously doesn't help here. Any hint on how to solve this would be very appreciated!

Best, Tobias

[Dismounted]

The only way you can get this automated is by coding a script yourself, or having someone code it for you. This may have a large impact on the server though during the process. You would have to query the fetch who needs to be merged, and replicate the merge function.

[tobias_t]

Thanks! I will pass that on to our database experts.

--------------- Added 1207753901 at 1207753901 ---------------

Any hint on in which vbulletin script to look for the original merge function?

--------------- Added 1207754158 at 1207754158 ---------------

Never mind, I found it.