UBB.Dev
Posted By: ospensky [6.1x] Active Topics for ASP - 10/29/2001 5:29 PM
Ok, don't get mad at me, but Im posting ASP functions to retrieve "Todays Active Topics". This is definitely a Beta release. It is configured to work with the latest version 6.1.0 or later. Furthermore, it was written for UBBs that have the following file architecture:

w/in the forum director, /ubb for non-cgi, /bin for cgi.

Its written in VBScript.
Basically, there are groups of functions to do generic tasks and a few functions that actually form the HTML, etc.

If you know ASP to any degree, you should be able to figure out how to modify the functions to fit a UBB w/ different file architecture.

Essentially, it works in the following manner:

1. Determines the latest Cache Folder
2. Determines the latest search index file
3. Scrapes out that Active Topics info.
4. Loops through that and retrieves the post for each Active Topic
5. Armed w/ the forum #, thread # and UBB Dir, a function loops through all Active Topics and gets the last post and related info. from that thread file.
6. Finally, a function to write the posts and write the Forum Name if its passed a Forum#

There are other functions as well, such as trimmers, a julian date converter, etc.

It should be pretty simple to modify the syntax and make this a .vbs file to be run by your task scheduler if your are concerned about performance.

Let me appologize in advance for all you Gnerds that might be offended by M$-related postings wink

here\'s the code.

Here's the URL cuz this style sheet pretty much makes HREFs invisible:

http://www24.brinkster.com/ospensky/activetopics.asp.txt

Email me at [email protected] if you have questions. I reserve the right to not respond tipsy

[ 10-29-2001: Message edited by: ospensky ]
Posted By: ospensky Re: [6.1x] Active Topics for ASP - 10/29/2001 11:38 PM
Ah well, it looks like no one here uses ASP...
If you by chance are, I have amended the above asp script to run as a .vbs

The script is pretty much self explanatory for those familiar with vbscript. It assumes that you have a directory in which sits a /bin folder (cgi) and a /ubb folder (non-cgi). SQL server is required as it scrapes posts and puts them in a db. The ability to run .vbs scripts is also obviously required.

The SQL table specs are as follows:

DBname = Forums
Tables:

msgID
msgLink
ForumName
MsgTopic
Msg
MsgAlias
UBBName

Hopefully there is some poor soul out there who is using UBB and could use this.


http://www24.brinkster.com/ospensky/activetopics.vbs.txt


ospensky
Posted By: Dome Re: [6.1x] Active Topics for ASP - 10/29/2001 11:44 PM
Hey, I use ASP smile

This will be cool on the frontpage of the site, thanks.
Posted By: ospensky Re: [6.1x] Active Topics for ASP - 10/30/2001 1:16 AM
Alright! We have a taker.

You can see how im using this fine piece of M$ scripting at:

http://www.wbur.org/forums

Enjoy!
Posted By: gameoverDude Re: [6.1x] Active Topics for ASP - 11/03/2001 12:17 AM
Impressive. I'll have to get this up on my page sometime. On my site, ASP is used. cool

Quote
quote:
Posted By: ARC Re: [6.1x] Active Topics for ASP - 01/13/2002 11:36 PM
ive been looking for a long time for this.
but where i put this file in order to view the script?
© UBB.Developers