Announcement

Collapse
No announcement yet.

Restore deleted post via query

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

  • Restore deleted post via query

    Hello, I would like to ask if I can restore a user's deleted posts (c.a 700) via SQL query, using the AdminCp. They are't physical deleted. I would like to avoid the manual process of restoring them all one by one.
    *I'm italian, so my english is bad*

  • #2
    You can do that, but it's not ideal. A number of counters will not be updated, including the users post count and the post counts in threads.

    To simply restore the posts, run this query:
    UPDATE post SET visible = 1 WHERE userid = X;

    Replace X with the user in questions userid number.
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      Then to update the counters I can run the script via the Maintenance page, right?
      *I'm italian, so my english is bad*

      Comment


      • #4
        Yes, though I'm not sure if all the necessary counters will be updated.
        Best Regards
        Colin Frei

        Please don't contact me per PM.

        Comment

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