Jump to content

  • twitter
  • youtube
  • googleplus
  • facebook
  • rss
  • newsletter


Removing posts or renaming them


  • Please log in to reply
1 reply to this topic

#1 ismadman

ismadman

    Elite Member

  • Members
  • PipPipPipPip
  • 110 posts
  • Gender:Male
  • Location:Gold Coast Australia
  • IP.Board Version:IPB 2.3.x
  • First Name:Kev

Posted 12 December 2010 - 10:12 PM

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

Attached File  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.


#2 Michael

Michael

    Management

  • Management
  • 3,137 posts
  • Gender:Male
  • Location:Australia
  • IP.Board Version:IPB 3.1.x
  • First Name:Michael
Donator

Posted 14 December 2010 - 01:47 AM

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.

Keep up to date with DevFuse mod development and releases.

Posted Image Posted Image Posted Image Posted Image Posted Image





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users