(2013-09-03, 10:37 AM)marcus123 Wrote: [ -> ]To remove all the replies and threads of any given user do this:
1. Go to their profile and click on (Find All Threads) and delete them all, then click on ( Find All Posts) and delete them all. This is an effective and safe method.
2. Find that user thread or a reply and click on "FIND" button this will return all the threads and replies check them all and delete. 
Doesn't work for me... when I click "Select all threads and posts" and press DELETE it just removes the first page and there are too many pages
^ Edit: this post may be ignored (I've seen the original post after posting this reply)
admin panel has a option to delete all posts & threads of a user
admin panel >> users & groups >> users >> find the user (you can search using search bar at the top)
select the user by ticking the check box and at the bottom see Inline User Moderation options
prune/delete user's posts option is available there
Any official answer with SQL command??
How do you let a user get tens of thousands of posts before deciding to ban them and delete their posts and threads?
We should look at the tables involved and see if there are any indexes we should create to speed up look-ups and deletes.
(2013-10-18, 05:27 PM)laie_techie Wrote: [ -> ]How do you let a user get tens of thousands of posts before deciding to ban them and delete their posts and threads?
We should look at the tables involved and see if there are any indexes we should create to speed up look-ups and deletes.
this works and is quite fast
delete from <tableprefix>users where uid = <useridnumber>
however you may need to run a similar query on the 'threads' table
(2013-10-18, 05:27 PM)laie_techie Wrote: [ -> ]How do you let a user get tens of thousands of posts before deciding to ban them and delete their posts and threads?
We should look at the tables involved and see if there are any indexes we should create to speed up look-ups and deletes.
I'm making some changes on a forum and I need to remove all posts of some users who posted in separate forum (I have list of them already).
@JimR: That only removes the user but leaves the posts??
No one knows how to do it?
(2013-10-22, 10:49 PM)Zer0 Key Wrote: [ -> ]No one knows how to do it?
Go to the users profile, assuming you haven't deleted their account. Click on Find All Threads, and Find All Posts.
When on those pages, just tick the box on the top so it selects all the posts shown and delete them like that.
If you did delete the accounts, this won't really work. And unfortunately I don't know enough about SQL stuff to really help there.
Hope this at least helps a bit.
EDIT: Now, first of all I'm not sure how this will effect your forum so remember that before you do it and do it at your own risk.
Since you have so many posts, if you want to do this method, you might want to increase the number of threads per page in the Admin CP -> Board Settings -> Forum Display Options -> Threads Per Page to a higher number it'll make deleting the posts much faster.
I say do it at your own risk because I'm not sure what effect increasing this number, to say, 1000 will have on the forum. I don't feel like finding out the hard way (by trying) but if anybody does know if it will cause problems for the forum please reply lol...
(2013-10-22, 11:14 PM)HNAdmin Wrote: [ -> ] (2013-10-22, 10:49 PM)Zer0 Key Wrote: [ -> ]No one knows how to do it?
Go to the users profile, assuming you haven't deleted their account. Click on Find All Threads, and Find All Posts.
When on those pages, just tick the box on the top so it selects all the posts shown and delete them like that.
If you did delete the accounts, this won't really work. And unfortunately I don't know enough about SQL stuff to really help there.
Hope this at least helps a bit.
Yea, already stated above and when I select more than 1 page of posts, it doesn't work for some reason. It doesn't delete anything.