How to attribute all posts of a deleted user to another ?

Arachnos

Hi everyone,
I have imported an old " homemade " forum in Vanilla and I have to delete some users that don't work anymore for my company.

So, I need to re-attribute all posts of these users to another user (me).

Is there a functionnality to do that like Wordpress can do (see attached picture) ?

It would be very helpful !!

Thanks

Arachnos

x00

This is something you could do as a plugin. or just an sql query.

Arachnos

Ok, but it will be easier if a plugin already exists

hgtonight

UPDATE GDN_Discussion SET `InsertUserID` = {YOUR_ID} WHERE `InsertUserID` = {HIS_ID};

I could write a plugin wrapper around this, but a) I am lazy and b) how often is this done in a forum context?

I could see integrating something like this into the Articles application though @Shadowdare.

Arachnos

You're right : this is a non frequently used functionnality.

Thanks for the SQL query, but It seems better to execute the same query on the old forum database, so my Vanilla "custom" Porter will reimport it correctly.

hgtonight

@Arachnos said:
You're right : this is a non frequently used functionnality.

Thanks for the SQL query, but It seems better to execute the same query on the old forum database, so my Vanilla "custom" Porter will reimport it correctly.

Sounds good, good luck!