Looking into requirements for the User Session table for a social site. Currently I am designing it to store: • UserID - links to user's who owns the session • Session ID - unique to the user • Session start – Time, Day, Date, Time zone • Session end – Time, Day, Date, Time zone • Session length • MAC address • Computer name • IP addr...
What is the most secure implementation of OpenID technology? Is there someone out there who knows enough about security, cryptography and OpenID specifications? No rumors, just facts. I would like to know all about insecurities of network communication process between OpenID provider and OpenID-enabled site during: logging in is user...
If I want to start my own social networking site, are there any templates available to start my design from, or should I start from scratch? ...
I'm working on a website with a major social networking component. I want the short username display (1 icon (maybe 2) + a styled username) to indicate: presence (active, idle, away, offline) - font weight avatar (autogen or uploaded) - 16x16px prefixed icon explicit relationship to current user (followee, follower, mutual friend, FO...
Hey :) I'm currently setting up a new users data model. Are the ids from facebook, twitter and openid all numerical? What is the length? This is what i have so far: Thanks for any collection. Oliver ...
i have a contact_relationship table that stores the reported strength of a relationship between one contact and another at a given point in time. mysql> desc contact_relationship; +------------------+-----------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default ...
How do I go about this: For a social site I need to allow users to find people they may know on the website. 1) Find friends on our site - Done. 2) Find friends from their email (hotmail, gmail, etc.) 3) Find friends from chat (AIM, ICQ, etc.) 4) Upload CSV files - Done. For 2 & 3, there is a huge list of email and chat services. I gu...
Is there a method that can post a status to Facebook or Twitter. Twitter has this: http://www.twitter.com/?status=This+is+the+status+that+will+be+grabbed+by+Twitter What about Facebook? Thanks. I know about doing it by cURL, but I'm not asking about that :p ...
I want to develop a social networking web site in java. I want to use Spring, Hibernate, Jasper as well as sms apis. At fresher level, I want to know if I am on right path to use these technologies ? Suggest something more if I should follow. What database I should use ? (PostgreSQL, MySQL etc.) And, at last, what architecture I shoul...
how can i show new friend request in home page using php ...
Designing a user content website (kind of similar to yelp but for a different market and with photo sharing) and had few databse questions: Does each user get their own set of tables or are we storing multiple user data into common tables? Since this even a social network, when user sizes grows for scalability databases are usually par...
Hi, I have a web app, where I ask for a user's: Email address (required) First/Last name (optional) Twitter handle (optional) I'd like to allow them to find friends also using my service - if I understand correctly, I can offer the following methods: Given their email address, try to find their contacts. This may be based on their...
I would like any advice on how to create and visualize a link map between blogs so to reflect the "social network" between them. Here is how I am thinking of doing it: Start with one (or more) blog home page and collect all the links on that page Remove all the links that are internal links (that is, If I start from www.website.com. ...
Hello, I was wondering if there was a way to see who is or isn't using your application on Facebook. For example, sets say I have an application X that a user Y has just connected to. I want to find out if Y's friend Z has allowed X or not. Then, if friend Z has not allowed/used X with Facebook before -- I want to invite that friend t...
Say you have a table schema such as this: friends(friendship_id, uid1, uid2, are_friends). When one friend un-friends another person, is it best practice to delete that row from the database (and reset auto-incrementing)? Or should you simply change the are_friends status to 'N'? I'd love to know what you think and why. EDIT: My prima...
I have a table like friends(friendship_id, fid1, fid2, ENUM('pending', 'accepted', 'ignored'). When a user ignores someone's friend request, I want to make sure that they don't get a message saying, "You've been ignored!", but I also want that data logged. Any suggestions on how to approach this? ...
What are the Tables that would be present in a social networking site (ex:twitter).... I have a users table as of now... How to keep tracker of followers and people i follow... Should i maintain separate table for followers and people i follow... What are the columns which would be there in those tables? Please don't think this as Su...
Hi, I want to make an other sign up page which is linked to the social engine database, but when i MD5 the password and store it in the se_users table, the user can't login, i believe that social engine have another encryption method, Can someone please give me a function to encrypt passwords the social engine way? This is their functi...
I've asked this question on the facebook and ping.fm developer forums, but they don't seem to be very busy at the moment. So lets see what you lot can do... I have included meta tags for title, description and image_src on my site so facebook can pick this information up and display it on users's posts on facebook. I am using ping.fm to...
Hi, I'm not quite sure how to go about framing this question, but I am building a social network from the ground up using rails; one feature is twitter style messages. I am trying to create an option that when the user submits their message, the have a checkbox that says "private". If the checkbox is checked, only the users friends can ...