Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Archiving ALL topics in a forum
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 27 April 2004 :  13:25:28  Show Profile  Visit MarkJH's Homepage
How do I go about archiving ALL of the topics in a selected forum? I'm thinking it's something to do with admin_forums.asp, the whole "for counter = 1 to 6" bit and subarchivestuff but I can't figure it out.

Any help would be great.

Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 28 April 2004 :  11:39:01  Show Profile  Visit MarkJH's Homepage
Anyone?

Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/
Go to Top of Page

miperez
Junior Member

Spain
243 Posts

Posted - 28 April 2004 :  11:50:08  Show Profile
Hi, MarkJH.

I think that the easiest way to do that is going into the Admin section, and clicking on "Archive forum topics", then "Archive topics from a forum", and then selecting the desired forum and clicking on "selected forums".

Best Regards

Mikel Perez

"Hell is the place where everything test perfectly, and nothing works"
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 April 2004 :  11:59:17  Show Profile  Send ruirib a Yahoo! Message
Mark, you can't connect to the SQL Server Db with Query Analizer, can you? If you can, there is a good script to do eaxctly what you want.

Here it is: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=47702&SearchTerms=archive


Snitz 3.4 Readme | Like the support? Support Snitz too

Edited by - ruirib on 28 April 2004 13:05:43
Go to Top of Page

Jeepaholic
Average Member

USA
697 Posts

Posted - 28 April 2004 :  12:39:08  Show Profile  Visit Jeepaholic's Homepage
Regarding the link that Rui posted, make sure you cut/paste from the FIRST POST. It has all the updates. That link points you to the 2nd page of the topic. <smile>

Al Bsharah
Aholics.com

Jeepaholics Anonymous
Broncoholics Anonymous
Network Insight
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 April 2004 :  13:06:08  Show Profile  Send ruirib a Yahoo! Message
quote:
Originally posted by Jeepaholic

That link points you to the 2nd page of the topic. <smile>

It no longer does .


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 28 April 2004 :  14:46:50  Show Profile  Visit MarkJH's Homepage
quote:
Originally posted by miperez

Hi, MarkJH.

I think that the easiest way to do that is going into the Admin section, and clicking on "Archive forum topics", then "Archive topics from a forum", and then selecting the desired forum and clicking on "selected forums".

That only archive topics that are at least a month old. I want to archive EVERYTHING in a forum. Basically, it's part of a mini-modification I'm working on to close a forum forever, archiving everything and leaving the archives intact and accessible from default.asp

Ruirib/Jeepaholic; that script looks like just want I need! So, setting the date to today's would archive the entire forum, right?

Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 April 2004 :  16:09:15  Show Profile  Send ruirib a Yahoo! Message
Yep. You also need to set the FORUM_ID, since it's also a variable in the script.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 28 April 2004 :  16:12:31  Show Profile  Visit MarkJH's Homepage
I've got Query Analyser so I can give it a go. Thanks a lot!

Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 April 2004 :  16:14:17  Show Profile  Send ruirib a Yahoo! Message
You should thank Jeepaholic. He did all the work .


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 28 April 2004 :  18:46:57  Show Profile  Visit MarkJH's Homepage
Well, thanks for pointing me in the right direction. Thanks to Jeepaholic for all the work!

Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 April 2004 :  20:05:42  Show Profile  Send ruirib a Yahoo! Message
Glad to be of help :).


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Jeepaholic
Average Member

USA
697 Posts

Posted - 29 April 2004 :  03:57:22  Show Profile  Visit Jeepaholic's Homepage
Let me know how it works for ya... Glad to see someone getting use out of it other than me!

Al Bsharah
Aholics.com

Jeepaholics Anonymous
Broncoholics Anonymous
Network Insight
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 29 April 2004 :  13:23:30  Show Profile  Visit MarkJH's Homepage
Got this error when attempting to run the script:

Server: Msg 207, Level 16, State 1, Line 51
Invalid column name 'T_ARCHIVE_FLAG'.
Server: Msg 207, Level 16, State 1, Line 51
Invalid column name 'T_EVENT_DATE'.
Server: Msg 207, Level 16, State 1, Line 51
Invalid column name 'T_ISEVENT'.

Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 29 April 2004 :  13:26:19  Show Profile  Visit MarkJH's Homepage
Also, will this archive polls?

Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/
Go to Top of Page

Jeepaholic
Average Member

USA
697 Posts

Posted - 29 April 2004 :  21:53:10  Show Profile  Visit Jeepaholic's Homepage
Ooooooo, didn't consider that I have the Events Mod in place. You'll need to remove all references to T_EVENT_DATE and T_ISEVENT.

As for the T_ARCHIVE_FLAG field, what version of Snitz are you running? I thought that was a standard field?

Doubtful that it will archive polls without modification. Assuming that all the poll database columns are located within the TOPIC and/or REPLY tables, you could make sure they're included in the script - much like you removed the Event fields from mine.

Al Bsharah
Aholics.com

Jeepaholics Anonymous
Broncoholics Anonymous
Network Insight

Edited by - Jeepaholic on 29 April 2004 21:55:49
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.46 seconds. Powered By: Snitz Forums 2000 Version 3.4.07