how to find online friends in my asp.net application

Question

0.00/5 (No votes)

See more:

, +

i have created a website in which we can add friends..
i want user can see his online friends how to do this...

database table of friends..

CREATE TABLE [dbo].[tbl_friendmaster](
	[i_autoid] [int] IDENTITY(1,1) NOT NULL,
	[Friendgroup] [varchar](50) NOT NULL,
	[Message] [varchar](500) NOT NULL,
	[i_Friendid] [int] NOT NULL,
	[i_myid] [int] NOT NULL,
	[approvalstatus] [int] NOT NULL,
	[CreateDate] [datetime] default getdate()  NOT NULL
)

Posted 21-Apr-11 16:44pm

se.nishant

Add a Solution

2 solutions

Solution 2

Your question is not very clear on all the naming conventions used and if any other details are there. Assuming this is the only table to store data and following naming convention means:

i_autoid = just an id  (No idea why you have it... not needed!)
i_Friendid = id of the friend of logged in user
i_myid = id of the logged in person

Try:

SQL

SELECT
  i_Friendid
FROM
  tbl_friendmaster
WHERE
  i_myid = @loggedInUserId

Now, above query gives all the friendid that are related to logged in user. Now, someone being online or offline must be tracked other way (and not through this table). You need to use the tracking online user with the query result to get only online friends.

Try!

Posted 21-Apr-11 18:25pm

Sandeep Mewara

Comments

Sandeep Mewara 22-Apr-11 3:15am

And the downvote was for? Any comments please... I would love to know. :)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Parwej Ahamad · Accepted Answer · 2011-04-21T18:02:00

As per my understanding, you have to maintain Logged-In user information into database. Follow below steps:

1. Whenever any user logged-in then insert info into database. So when user logged-in then mean user is online and when logged-out mean user is offline.
Note: But you have to do analysis on time expire. Suppose user is not logged-out and closed his browser then how you will identify whether user is logged-out (offline).

2. Call periodically to database in 10 or 15 second and based on info set status in your friend list

Thanks