Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - Archive - Forum Topics
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Archive - Forum Topics

 Post Reply Post Reply Page  12>
Author
mbd2 View Drop Down
Groupie
Groupie


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 124
Post Options Post Options   Thanks (0) Thanks(0)   Quote mbd2 Quote  Post ReplyReply Direct Link To This Post Topic: Archive - Forum Topics
    Posted: 19 November 2004 at 9:43am

I did a search and found no real answer so here it goes...

I'm looking for a mod or need help developing a mod that will Archive old topics and convert them into html files. It would be great if in the Topic Admin to check a box that would create a html file with topic name and all data. This file would be save in a Archive Topics Directory which would have a main search able archive page.

Wow, that a lot to ask for... plus, the topic would be automatically closed.  Manual deletion of the topic could be preformed after a check to make sure the file was converted properly.

Right now I manual closing the topic, using the  print topic function to create the html file, saving the file, edit file to add a description, and post this file to a directory.  I'm using a search feature that will search the files.  Anybody have any ideas or have seen any features like this?

This is what I have so far (test area)

http://www.mbd2.com/forum/archieves/Topic/site_search.asp

Dale

 

Balloon Entertainment at it's best! www.mbd2.com -- Trade Show Presenter - video
Back to Top
xeerex View Drop Down
Senior Member
Senior Member


Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601
Post Options Post Options   Thanks (0) Thanks(0)   Quote xeerex Quote  Post ReplyReply Direct Link To This Post Posted: 19 November 2004 at 11:56am
Hmm..That seems like a lot of work.

Personally, I just use the "Batch Close" and "Batch Move" in the admin module. I have a forum setup with admin-only access and hidden from everyone else. When I get ready to "archive", I just batch them over.

Of course, if I want a post to remain in it's original location, I make sure and manually "sticky" or "announce" it. When I batch I simply move all the normal posts.
Back to Top
mbd2 View Drop Down
Groupie
Groupie


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 124
Post Options Post Options   Thanks (0) Thanks(0)   Quote mbd2 Quote  Post ReplyReply Direct Link To This Post Posted: 19 November 2004 at 6:41pm

Xeerex

At present my db is 13.6 mb, I'm looking to reduce its size.  Yes, it has been compacted, but would I not reduce size my archiving files to html files? The reduction in db size should keep forum running faster.  At lease, that is the assumption I going by.

Doing a "Batch Close" and "Batch Move" doesn't reduce db size does it?

Dale

Balloon Entertainment at it's best! www.mbd2.com -- Trade Show Presenter - video
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008
Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 19 November 2004 at 6:52pm
If your database is getting big you really should upgrade to SQL since Access is not a very good database to use on a live website.
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 19 November 2004 at 6:57pm
if you want to archive into a html file so its like the print friendly version why not .

make it so that the content of the friendly version is stored in a veriable

then open (on server) or create an html file with its content the veriable.
Back to Top
mbd2 View Drop Down
Groupie
Groupie


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 124
Post Options Post Options   Thanks (0) Thanks(0)   Quote mbd2 Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2004 at 1:12am

Originally posted by MadDog MadDog wrote:

If your database is getting big you really should upgrade to SQL since Access is not a very good database to use on a live website.

I'm familiar with SQL but not that knowledgeable when it come to using it in a db.  Is there a major conversion or just a change to the database itself.  Plus do mod have to be reconfigure or is just the support files like common.asp?

Dale

Balloon Entertainment at it's best! www.mbd2.com -- Trade Show Presenter - video
Back to Top
mbd2 View Drop Down
Groupie
Groupie


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 124
Post Options Post Options   Thanks (0) Thanks(0)   Quote mbd2 Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2004 at 1:14am

Originally posted by dj air dj air wrote:

if you want to archive into a html file so its like the print friendly version why not .

make it so that the content of the friendly version is stored in a veriable

then open (on server) or create an html file with its content the veriable.

Would not the data still be in the db; and the db would still be the same size?

Dale

Balloon Entertainment at it's best! www.mbd2.com -- Trade Show Presenter - video
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2004 at 5:52am
you could run the method i said and have a delete query to delete the thread/topics from the database.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.