Back to this post:
Pruning Soft-Deleted Posts
Some forums has thousands of soft-Deleted either Posts or Threads, This Posts or Threads are available in the database and no longer needed,
so to get red out of that data from forum database,
flow the instruction below : Please Take Care,
You can do it from forum interface no need to get in to Forum Control Panel in simple way to get red of that,
1- You Should be a forum Admin
2- check this Codes, change & paste it in your browser:
to prun Soft-Deleted Posts use this code:
to prun Soft-Deleted Threads use this code:
deleted&pp=20 means number of posts or Threads will be viewed in each page,
100&sort=dateline, means how many previous days you would like to check and prune. (If it's for last 3 years change it to be 1000 or more)
Than as normal,
3- do select all, than do normal delete.
Note, Don't prune more than 50 posts in each cycle this may over load you server.
Pruning Soft-Deleted Posts
Some forums has thousands of soft-Deleted either Posts or Threads, This Posts or Threads are available in the database and no longer needed,
so to get red out of that data from forum database,
flow the instruction below : Please Take Care,
You can do it from forum interface no need to get in to Forum Control Panel in simple way to get red of that,
1- You Should be a forum Admin
2- check this Codes, change & paste it in your browser:
to prun Soft-Deleted Posts use this code:
Code:
http://www.xxxxxx/vb/moderation.php?do=viewposts&type=deleted&pp=50&daysprune=100&sort=dateline&order=desc&page=1
to prun Soft-Deleted Threads use this code:
Code:
http://www.xxxxxxx/vb/moderation.php?do=viewthreads&type=deleted&pp=20&daysprune=1000&forumid=0&sort=lastpost&order=desc
100&sort=dateline, means how many previous days you would like to check and prune. (If it's for last 3 years change it to be 1000 or more)
Than as normal,
3- do select all, than do normal delete.
Note, Don't prune more than 50 posts in each cycle this may over load you server.