homepage Welcome to WebmasterWorld Guest from 54.227.171.163
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / WebmasterWorld / Community Building and User Generated Content
Forum Library, Charter, Moderators: rogerd

Community Building and User Generated Content Forum

    
ASP Community Software
asp community software
ethan77

5+ Year Member



 
Msg#: 3358498 posted 10:55 pm on Jun 4, 2007 (gmt 0)

Hi, has anyone integrated a "myspace" type community in ASP with features such as friends, modifiable user profiles, ecards, etc?

I've been searching for about 2 weeks and most seem to be written in PHP and use MySql. I want to use ASP or ASP.NET and SQL Server.

The good ones in php seem to be phpfox and handshakes. I even emailed these companies asking if it's possible to port it to ASP/sql server but they said it's "impossible". I also want to keep my windows server simple so I prefer not to install php.

Drupal looks good but it has limited support for sql server.
Community Server looks ok but it's pricy and lacks many of the "friends" features.

I already have a forum running so I'm not interested in that... only a "community/friends" program.

I was shocked that there wasn't more out there for ASP and started wondering if I'd have to code it myself - which I really don't want to do.

Any links and/or advice is appreciated.

Thanks!

 

rogerd

WebmasterWorld Administrator rogerd us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 3358498 posted 12:14 am on Jun 5, 2007 (gmt 0)

MySpace clones have been scarce, and seem to be mostly geared to LAMP servers. I did a Google search on '"social networking software" asp' and got a variety of hits, but I didn't explore them in any detail.

If you strike out on an existing ASP app that meets your needs, you might also consider employing a partially hosted solution and integrating that with your site. These seem to be springing up, and offer the advantage of introducing other people to your site. You give up some control, of course, and risk losing some branding.

ethan77

5+ Year Member



 
Msg#: 3358498 posted 1:09 am on Jun 5, 2007 (gmt 0)

Thanks rogerd, I think I explored them all...

They either don't have all of the features or they're very expensive (5k - 25k to get started - I called a couple of the companies).

I thought of the hosted solution too but the main hurdle is once you get above 75-100 concurrent users, people complain about the speed of the software/database. I don't want to get locked into a host and have to pay exorbitant fees down the road or face an expensive migration.

Hopefully others can point to some software later, but in the meantime can someone help define exactly what a "friend" is on a social networking site (beyond the obvious)? Maybe this will help other windows admins too.

Since this seems to be "the core" of the software, maybe if I build this myself, I can add on the other features by purchasing asp scripts.

I get the concept that you can add another user as a friend and you're linked together.

How about the viral concept: do you also automatically become a friend of all their friends?

What is the main user benefit (on the site) for having someone as a friend?

As a basic schema for a table called "friends", how about:

user_id varchar (the person who is adding another user)
friend_addee varchar (the person "being added")
date_linked datetime
confirmed char(1) (addee has confirmed friendship)

To get a list of the 1st level friends for a user called 'ethan77', you could use:


select * from friends where user_id = 'ethan77'
/* gives us all the users ethan77 added as friends */
OR friend_addee = 'ethan77'
/* gives us users that added ethan77 as a friend */
and confirmed = 'Y'

What would be an example sql to retrieve 2nd, 3rd... x level friends for a user?

Thanks again for contributing to my non-rhetorical post :)
I can't be the only windows user having a hard time finding a solution!

raja4

10+ Year Member



 
Msg#: 3358498 posted 9:31 pm on Jun 14, 2007 (gmt 0)

I am also looking for a solution and thought community server will be of help but it is very expensive.

ImperialCommand

5+ Year Member



 
Msg#: 3358498 posted 5:08 am on Jun 15, 2007 (gmt 0)

Snitz forums?
Its in classic asp. .net version is pending.

rupes

5+ Year Member



 
Msg#: 3358498 posted 5:05 pm on May 10, 2008 (gmt 0)

Hi ethan,
Did you ever find a solution to your social networking in asp problem? I find myself in that situation now and would be very grateful for any advice,
Thanks, Rupes

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Community Building and User Generated Content
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved