Delete older post
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=31224
Printed Date: 29 March 2026 at 9:41pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Delete older post
Posted By: Flyman30
Subject: Delete older post
Date Posted: 30 April 2015 at 11:28am
|
I have subjects which have up to several hundreds of pages, is there a script that would allow me to delete the old messages for example: older than a given date? |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 30 April 2015 at 12:03pm
|
Not sure if it is what you are looking for bit there is a tool in the admin area for 'Batch Delete Forum Topics' that will delete older topics from forums.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Flyman30
Date Posted: 30 April 2015 at 12:31pm
|
No Bruce this tools cleared the topic who had not answers since a certain time. I need to delete the old post in a topic whose certain date back to 2008! I want to be able to erase by batch the oldest post (by years) by keeping the recent post without deleting the topic. |
Posted By: Flyman30
Date Posted: 04 May 2015 at 11:47am
No idea ??  |
Posted By: WebWiz-Bruce
Date Posted: 05 May 2015 at 9:49am
|
There is no toll to delete older posts from with in a topic. The only way I can think of doing this would be to write an SQL Query to delete the older posts from the tblThread table in the database. Once you have deleted the older posts you would also need to update the tblTopics table for the topic and update the Start_Thread_ID ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Flyman30
Date Posted: 05 May 2015 at 4:46pm
|
I deleted the old messages with delete FROM dbo.tblThread where Topic_ID =469 and Thread_ID between 29604 and 40523 and then in tbltopics updated the Start_Thread_ID Update DBO.tblTopic set Start_Thread_ID = 40524 where Topic_ID = 469 but I do not understand how to update tbltopics for the topic ?? The number of pages is remains the former and displays 114 when we look at the forum, but if you clicked on the forum there are only 21 pages!? |
Posted By: Flyman30
Date Posted: 05 May 2015 at 7:11pm
|
Everything is back in order by updating: Update DBO.tblTopic set No_of_replies = 200 where Topic_ID = 469 |