Welcome to WebmasterWorld Guest from 54.166.46.226

Forum Moderators: rogerd

Message Too Old, No Replies

ASP Community Software

asp community software

   
10:55 pm on Jun 4, 2007 (gmt 0)

5+ Year Member



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!

12:14 am on Jun 5, 2007 (gmt 0)

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



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.

1:09 am on Jun 5, 2007 (gmt 0)

5+ Year Member



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!

9:31 pm on Jun 14, 2007 (gmt 0)

10+ Year Member



I am also looking for a solution and thought community server will be of help but it is very expensive.
5:08 am on Jun 15, 2007 (gmt 0)

5+ Year Member



Snitz forums?
Its in classic asp. .net version is pending.
5:05 pm on May 10, 2008 (gmt 0)

5+ Year Member



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