Jump to content

lyes.2k

Members
  • Posts

    9
  • Joined

  • Last visited

Profile Information

  • Gender
    Male
  • Location
    /home/firefox/

lyes.2k's Achievements

  1. Update: So I've made a test and the code you mentionned wasn't enough because it's not restoring the topics the users created and the responses made to their topics are also hidden by Invision. I've investigated more and found out that I had to do these additional steps to restore the topics created by the user and the responses : Find all the posts created by the user inside the "forums_topics" table (starter_id = user ID) and update the "approved" from "-1" to "1" ; Update all the responses inside the table "forums_posts" from "queued" = "2" to "0" where "topic_id" = "TOPIC_IDS_FOUND_IN_STEP_1". I had to create a small PHP script to update them correctly, as the number is huge and was too lazy to update them one by one. For those searching the SQL queries : As mentionned by @Jim M don't forget to create a backup of your database before trying any modification and if you don't know what you're doing, don't do it 🙂 ! UPDATE forums_posts SET queued = 0 WHERE queued = 2 AND author_id = XXX; UPDATE forums_posts SET queued = 0 WHERE queued = -1 AND author_id = XXX; afterwards : UPDATE forums_topics SET approved = 1 WHERE approved = -1 AND starter_id = XXX; and finally : UPDATE forums_posts SET queued = 0 WHERE queued = 2 AND topic_id = XXX; Thanks again for your help, you can now tag this topic as fixed.
  2. Thank YOU ! Will try this soon and let you know. There shouldn't be a problem. No worries, backups are made daily 🙂
  3. Hello, A moderator flagged a few accounts as SPAMMERS making all their posts hidden. The problem is that some of the users have >1000 posts and they're not spammer, they probably had access to their accounts because of passwords leaks on the internet. Now I'm searching for a way to restore all the hidden posts/responses for these users, even if its through an SQL code, that would help us a lot. I don't even understand that such an option doesn't exist yet. Thanks in advance.
  4. Thank you for your work.
  5. Hello, Is this template compatible with > 4.5 versions ?
×
×
  • Create New...