Announcement

Collapse
No announcement yet.

moving one member's posts to another..

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • moving one member's posts to another..

    Hi there:

    There's a member of board who used to be signed up under another name and has asked me to "transfer" all of his old posts (under the old username) to his new username.

    Is this possible? And if so, how do I go about it?

    Thanks.

  • #2
    Would it be easier to just change the account's name?

    This query should update all posts but I'm not sure about other details:
    Code:
    UPDATE post SET userid=[i]new userid[/i] WHERE userid=[i]old userid[/i]
    --filburt1, vBulletin.org/vBulletinTemplates.com moderator
    Web Design Forums.net: vB Board of the Month
    vBulletin Mail System (vBMS): webmail for your forum users

    Comment


    • #3
      don't forget to update counters after runing this query
      The price of freedom is eternal vigilance!
      - Thomas Jefferson

      Comment


      • #4
        Originally posted by filburt1
        Would it be easier to just change the account's name?

        This query should update all posts but I'm not sure about other details:
        Code:
        UPDATE post SET userid=[i]new userid[/i] WHERE userid=[i]old userid[/i]
        Thanks for that, but to be honest, I don't know exactly what you mean. I just got the board and don't understand the "tech" side of it. Is there a section called QUERY in which I am to input this line? (and interchange the usernames, etc....)?

        Comment


        • #5
          They're userids not usernames.

          To run queries, you can download and install http://phpmyadmin.sourceforge.net/ but I wouldn't recommend running that query until a developer reads this.
          --filburt1, vBulletin.org/vBulletinTemplates.com moderator
          Web Design Forums.net: vB Board of the Month
          vBulletin Mail System (vBMS): webmail for your forum users

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X