Welcome to WebmasterWorld Guest from 184.108.40.206
Forum Moderators: rogerd
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.
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.
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")
confirmed char(1) (addee has confirmed friendship)
To get a list of the 1st level friends for a user called 'ethan77', you could use:
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!