1 reply to this topic

[ismadman]

Heya people , Anyone know an easy way to either rename the post maker or delete all the posts from deleted accounts ?
ie :- Guest_Johnny._*

 guest.jpg   12.89K   6 downloads

The posts are all still there and the users name ( johnny ) but johnny doesnt have an account anymore as one of staff deleted 3300 members

So im using johnny as an example as we now have A LOT of posts with the Guest_ tag :(

I need a way to keep all the posts and maybe allocate them to One Account like POSTBOT or something
Dont really want to lose the posts but if I have to thats cool

So anyone know an EASY way to do this ?

Edited by ismadman, 12 December 2010 - 10:13 PM.

[Michael]

The easiest way would be to use the multi select to delete the posts. I'm always hesitant when dealing with the database manually, especially with IPB where most things have a relationship. But if you really need to keep the posts, you could modify the tables to point the posts to a new author. I haven't got IPB2.3 installed right now but you'd need to cover the topics, posts, polls and topic_ratings database tables. Here is an example sql statement. You'd need to do this for the starter id, starter name, last post info etc...

UPDATE topics SET starter_name = 'POSTBOT' WHERE starter_name='{current value}'

You then should be able to rebuild your forums. But would definitely backup before starting anything.