Previous Thread
Next Thread
Print Thread
Rate Thread
#148133 10/29/2001 9:29 AM
Joined: Feb 2001
Posts: 23
Junior Member
Junior Member
Offline
Joined: Feb 2001
Posts: 23
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 ]

Sponsored Links
Joined: Feb 2001
Posts: 23
Junior Member
Junior Member
Offline
Joined: Feb 2001
Posts: 23
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

Joined: Apr 2001
Posts: 31
Junior Member
Junior Member
Offline
Joined: Apr 2001
Posts: 31
Hey, I use ASP smile

This will be cool on the frontpage of the site, thanks.

Joined: Feb 2001
Posts: 23
Junior Member
Junior Member
Offline
Joined: Feb 2001
Posts: 23
Alright! We have a taker.

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

http://www.wbur.org/forums

Enjoy!

Joined: Feb 2001
Posts: 40
Member
Member
Offline
Joined: Feb 2001
Posts: 40
Impressive. I'll have to get this up on my page sometime. On my site, ASP is used. cool

Quote
quote:

Sponsored Links
Joined: Jan 2002
Posts: 2
ARC Offline
Junior Member
Junior Member
Offline
Joined: Jan 2002
Posts: 2
ive been looking for a long time for this.
but where i put this file in order to view the script?


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Pilgrim
Pilgrim
NH, USA
Posts: 190
Joined: June 2000
Forum Statistics
Forums63
Topics37,570
Posts293,915
Members13,848
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,829
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 81
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2022 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221129)