Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...DNN, Forum, and Database RelationsthipsDNN, Forum, and Database Relationsthips
Previous
 
Next
New Post
1/8/2008 10:22 PM
 
StarryNightDave

Joined: 12/30/2007
Posts: 7

Greetings,

I'm planning on launching a social networking type website in the near future and I would like to know if anyone has experience with the Forums module.  Specifically, what I want to do is segregate people by State and have separate Forums for State users. 

For example, if you register and enter your State as being PA, you would automatically get the Pennsylvania home page.  What I would like is for all Pennsylvanians to then go directly to the PA Forum from the Forum link on that page.  I also don't want Pennsylvania users to be able to post in other State Forums, but they can browse.

What I don't know is how the database works in the background for the Forum.  Would this amount to 50 separate Forums with 50 separate SQL databases?  Or, would they all be part of a single Forum/Database?

The main reason I ask is that I'm also planning on using PowerDNN.com as my host.  I want to start with the Personal plan at $20/month, but it only allows 1 SQL 2005 database.  ( http://www.powerdnn.com/Services/DotNetNukeSharedHosting.aspx )  Would I be able to set up this kind of site with just one SQL database?

 
 
New Post
1/8/2008 11:28 PM
 
ROB AX

Joined: 9/3/2004
Posts: 2185

Create a role in DNN for each state. Consider using  an addon like Datasprings Dynamic Registration to assign the role upon registration, or simply let people choose it manually afterwards from either their Manage Services profile page, or from a role-assignment tool such as Seamless Opt-in. Get Active Forums if you want your site to work. Install it once, then create forum groups for each state. Set view and author permissions in the relevant forum groups to match the roles/states. Create your State homepages and use a redirect-by-role-on-login type of module to handle the redirection aspect (I forget which exact module does it but there are one or two on Snowcovered). Use the Active Forum forum viewer module to place the relevant forum group on each of the state pages.

That's just off the top of my head, not from experience doing the exact same thing, so you'll have to do some more research and testing beforehand.

Rob
 
New Post
1/8/2008 11:40 PM
 
ROB AX

Joined: 9/3/2004
Posts: 2185

oh, and one database is all you need to run it, however it seriously restricts your ability to carry out modifications and maintainence if you have not got the room and tools to create new or duplicate portals for testing. Try and plan ahead.. where is this site going to be in one year from now... and target that with your choices early on.

Rob
 
New Post
1/9/2008 7:57 AM
 
StarryNightDave

Joined: 12/30/2007
Posts: 7

Hey - thanks for the info.  I will be upgrading the service as more people register to handle the load.  I really appreciate your suggestions.

 

Dave
 
 Page 1 of 1
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...DNN, Forum, and Database RelationsthipsDNN, Forum, and Database Relationsthips


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out