1 Topic by Vanslyde (edited by Vanslyde 2008-06-09 23:29)

  • From: Montreal
  • Registered: 2006-10-02
  • Posts: 144

Topic: [Solved] Moving a post in another thread using a mysql command

so this new guy created a thread about "Cars"

but we already have a topic on cars many pages below.

Is there a command line I could use directly into mysql to move his post at the end of our existing "cars" topic?

btw I know there's a mod for it, I tried it and I don't find it user friendly at all.
and it doesnt happen often so might as well perform this task directly into the db.

Thanks!

Vanslyde's Website

2 Reply by Lurker.boi (edited by Lurker.boi 2008-06-09 20:59)

  • Registered: 2007-10-06
  • Posts: 33

Re: [Solved] Moving a post in another thread using a mysql command

update posts set topic_id=<your_car_topic_id> where id=<post_to_move_post_id>

Edit: you'll also want to edit the last_post,posted,last_poster columns on the topic record to match the post and increaset the num_replies by 1

  • From: Montreal
  • Registered: 2006-10-02
  • Posts: 144

Re: [Solved] Moving a post in another thread using a mysql command

Lurker.boi wrote:

Edit: you'll also want to edit the last_post,posted,last_poster columns on the topic record to match the post and increaset the num_replies by 1

I used
update topics set poster="name" where id=topic_id
Bumped it and rebuiled the index

Seems all good

Thanks a lot!

Vanslyde's Website