Topic: Mass ID Changer

[ccbtimewiz]

This script, which can be uploaded like repair_settings.php into root directory (where Settings.php is located), will give you an interface to batch-change all the ID's of the members of your forums.

Doing this will execute queries that will re-attribute their posts, post count, linked avatar, and stats as well so nothing is lost. The only difference is the new ID.

I strongly recommend making a backup of your DB before using this.

Please note this is made only for SMF 2.0.

[Link]

Works good, BUT...uploaded avatar ID's aren't changed, so it breaks uploaded avatars. :S

[ccbtimewiz]

:

// It's near impossible to update their avatar properly if encrypted attachments are enabled.
// So.. just delete the avatars. Both the new ID and the old ID (if an avatar exists for that ID).
require_once($sourcedir . '/ManageAttachments.php');
removeAttachments(array('id_member' => (integer) $_REQUEST['new_id_' . $id]));
removeAttachments(array('id_member' => $data['id']));
Uploaded avatars that are in the attachments directory are close-to-impossible to fix as it would take a lot of code to do. So I just coded it to delete 'em.