Previous Thread
Next Thread
Print Thread
Hop To
Using UBB as Comment Manager for Articles #249626 07/06/2012 4:41 PM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
I have a site, BellaOnline, which is an article directory. So for example we have a Wine editor who writes articles on Wine. Associated with BellaOnline are our BellaOnline forums, which are UBB forums. So we have a forum area called "wine" where the wine lovers post.

Each time the Wine editor writes a new article, he creates a matching post in the forum. That way people interested in that article can talk about it. He can link from his article to that thread he created.

What I'd like to do is have the thread text show up UNDER THE ARTICLE, similar to how when you go to CNN or other news sites you see a running tally of comments beneath the article. That way they are right there.

Any ideas on how to make this happen? We have hundreds of thousands of threads. So the idea of exporting flat files of those threads and filling our disks with them boggles my mind. But on the other hand that still might be better than having database calls being made continually to the database, to extract the matching thread details for a given thread.

Is anybody doing this?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Using UBB as Comment Manager for Articles [Re: BellaOnline] #249627 07/06/2012 5:41 PM
Joined: Jan 2008
Posts: 514
Dunny Offline
addict
Offline
addict
Joined: Jan 2008
Posts: 514
I am no expert as seen in another thread..however would RSS feeds do something similar? Not sure as I myself don't use them. (though I am thinking about it).

Dunny

Re: Using UBB as Comment Manager for Articles [Re: BellaOnline] #249634 07/07/2012 4:21 PM
Joined: Dec 2003
Posts: 5,998
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,998
I am not 100% on what you are looking for but rss feeds as stated may work for you or using a post island and placing it external use may work. The issue with that method is you currently only have the ability to create 10 post islands.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Using UBB as Comment Manager for Articles [Re: BellaOnline] #249653 07/09/2012 1:22 AM
Joined: Jun 2004
Posts: 207
cascadeclimbers Offline
enthusiast
Offline
enthusiast
Joined: Jun 2004
Posts: 207
Macworld used to do this when they ran UBB, and they do so now with IPB.

Displaying the posts isn't very hard. If you wanted to allow people to comment in the article it would be harder, maybe something to iterate on. The key to doing this is tying the article to the thread somehow.


Won't you take me to Funkytown?
Re: Using UBB as Comment Manager for Articles [Re: BellaOnline] #249656 07/09/2012 10:46 AM
Joined: Jun 2006
Posts: 15,852
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
Actually, embedding the post form wouldn't be hard at all to allow comments from the page, so long as you disabled the referrer checking in the control panel.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Using UBB as Comment Manager for Articles [Re: BellaOnline] #250571 10/09/2012 4:48 AM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
I'm just getting back to this project again, now that I have all my forums auto-watching properly. That was the first stage in this process.

OK, so adding comment boxes plus existing posts for a given thread to an external site. Here's what I'm looking to do.

BellaOnline has 400 sites. Each site has a forum area in the matching forums.bellaonline.com forum. So for example:

low carb site -
http://lowcarb.bellaonline.com/Site.asp

Low carb forum -
http://forums.bellaonline.com/ubbthreads.php?ubb=postlist&Board=221&page=1

So far so good. Now the low carb forum has lots of threads in it. I try to make a new thread to go with each new article. So article on eggs and salmonella -

http://www.bellaonline.com/articles/art178214.asp

forum thread on eggs and salmonella -

http://forums.bellaonline.com/ubbth...86289/gonew/1/Eggs_and_Salmonella#UNREAD

Nobody is posting in that thread because it's too cumbersome to go from the article over to the forum to post about it.

So I want the thread content from that "eggs and salmonella" article to show up UNDERNEATH the article content on the main BellaOnline site. And then I want a post box so that someone could add their own thoughts to the thread without manually going over to the forum.

If they're not logged in, it would prompt them to log in, but at least logged in members could instantly post.

Here's part of my challenge. My site gets around 15 million pageviews a month. So that's a lot of hammering. I don't necessarily want, every time an article is requested, for it to have to do a lot of queries to the UBB database to drag out the thread content. Especially if most threads aren't changing often. On the other hand, I have hundreds of thousands of threads. I cringe at the idea of having a script write all of these to a file somewhere in a massive directory. Still, clearly the data has to be *somewhere* to be retrieved when the user needs to see it. So I think having static files on a hard drive would be quicker than constant database queries.

Of course I say that and the BellaOnline article database is all done with live queries, so every time someone requests and article it's going into a SQL database for that content. So that is already working that way and the site loads fairly quickly. So maybe my database concerns aren't overly important.

ASP doesn't play well with RSS so I don't want to be writing things out into RSS and then having ASP have to re-translate it again to put onto the page. It makes more sense to write it out in HTML so ASP can simply include that HTML file and plunk it up without any further work.

So I suppose what I really need, and I cringe again at thinking this, is something that, every time a post is changed, it re-writes that thread out to a flat file. Directories choke if they get too big so it'd have to be organized somehow so a given directory didn't grow too huge. And then I'd need for my article database to know what thread ID to grab for a given article, so that when article 12345 was drawing, it knew to go find thread 98765 to show the matching content for.

You can see why I keep putting this off. But I think it's critical to build up discussion momentum again. People just don't seem to go into standalone forums as much as they used to. They now expect to comment and interact right where they're reading the article.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Using UBB as Comment Manager for Articles [Re: BellaOnline] #250574 10/09/2012 10:01 AM
Joined: Jun 2006
Posts: 15,852
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
If your pages where using PHP I'd suggest using the User Authentication Class over @ UBBDev, it'd allow you to see if a user is logged in or not and then you could do a little form manipulation to allow posting from an outside page... Unfortunately though, you're using ASP which I know absolutely zilch about...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Using UBB as Comment Manager for Articles [Re: BellaOnline] #250582 10/09/2012 2:33 PM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
Yes, I know, you guys aren't too fond of ASP smile. I'll take it piece by piece and see what I can do. The first step is to show the existing parts of the thread so they know what they're responding to. So I have to figure out how to write a thread in a nice HTML fashion when it's updated. I need to have it write into directories in an organized way. Probably a directory per forum, but also I need to organize within that directory. Some forums get huge traffic and if I just dumped one file per thread into a directory it might exceed the directory's ability to work properly. So then maybe subdivide by increments of 10,000?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Using UBB as Comment Manager for Articles [Re: BellaOnline] #250587 10/09/2012 7:16 PM
Joined: Jun 2006
Posts: 15,852
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
:snicker: maybe a slightly smaller number really...

You must utilize the crap out of Sitemaps...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Using UBB as Comment Manager for Articles [Re: BellaOnline] #250588 10/09/2012 7:28 PM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
Gizmo -

Do you mean less than 10,000 files in a given directory? I've had mail queue directories that get over 300,000 files in them and they only seem to crawl when they get up over 100,000 files in them. The directory structures seem fine with 80,000 files. Have you seen issues with directories that have only 10,000 files in them? To me that's a fairly small number of files ...?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Using UBB as Comment Manager for Articles [Re: BellaOnline] #250589 10/09/2012 7:31 PM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
Yes I looked it up and here are the actual maximums -

FAT32:
Maximum number of files: 268,435,437
Maximum file size: 4GB
maximum number of files per directory: up to 65535, or less depending on file names

NTFS:
Maximum number of files: 4,294,967,295
Maximum file size: 16TB currently (16EB theoretically)

Ext2:
Maximum number of files: 10¹⁸
Maximum file size: 2TB
theoretical file per directory limit: 1.3 × 10²⁰ files

Ext3:
Maximum number of files: number of bytes in volume/2¹³.
Maximum file size: 16GB (1KB block) to 2TB (4KB block)

so 10k is really small ... smile Unless someone's still using FAT32.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Using UBB as Comment Manager for Articles [Re: BellaOnline] #250592 10/09/2012 9:31 PM
Joined: Jun 2006
Posts: 15,852
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
I'm just super anal retentive with space; I'm working on a script to use Facebook to host photos and videos versus retaining them on site for a client and myself... Quite the task lol.

But a good rule of thumb is to try to keep things well under the filesystem maximums, I've seen some quite insane amounts of files in directories, makes it a pain to work with.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Mobile app?
by Baldeagle - 12/06/2019 9:32 PM
How do you change Text Line spacing?
by jorb - 11/23/2019 12:14 AM
What happened to FAQ or Forum Help
by Ruben - 11/20/2019 11:58 AM
Search feature encountering an Error message
by jorb - 11/20/2019 12:06 AM
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
Who's Online Now
1 registered members (JAISP), 61 guests, and 428 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)