Announcement

Collapse
No announcement yet.

User thread queries

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

  • User thread queries

    Hello !

    I recently notice that their are thousands of threads of different users who are doing spam on my forum about 5000 posts, is their any query to delete the user along with their posts and threads?

    and also if their is query if user has more then 1000 posts delete that user along with its posts and threads

    because from admincp prune option takes ages

    I would be very great full to you all thanks

  • #2
    The Admin CP prune -is- the query. I don't believe there is a quicker way to do it.

    Comment


    • #3
      prune take ages to delete thousand posts of user,

      Comment


      • #4
        Do you want to delete all posts of an user? First make a backup of your post table and then run the following query:

        Code:
        DELETE FROM post WHERE userid=x AND parentid !=0;
        Replace x with the id of the user whose posts you want to delete. And if you use a custom prefix for your db tables, append it to the table name in the query above.

        Then as last step, update counters at Maintenance -> General Update Tools.

        Comment

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