<% @ Language=VBScript %> <% Option Explicit %> <% 'Set the response buffer to true Response.Buffer = True 'Initalise the strSQL variable with an SQL statement to get the all the forum id's strSQL = "SELECT " & strDbTable & "Forum.Forum_ID FROM " & strDbTable & "Forum;" 'Query the database rsCommon.Open strSQL, adoCon 'Loop through all the forums to re-sync them Do While NOT rsCommon.Eof 'Update topic and post count updateTopicPostCount(CInt(rsCommon("Forum_ID"))) 'Move to the next record rsCommon.MoveNext Loop 'Reset server objects rsCommon.Close Set rsCommon = Nothing adoCon.Close Set adoCon = Nothing %> RE-SYNC THE TOPICS AND POST COUNT

The Topic and Post Count for all Forums have been re-synchronised.