chamilo / chamilo-lms

	$online_time = time() - $time_limit * 60;

	$current_date = api_get_utc_datetime($online_time);

	if ($friends) {

		// 	who friends from social network is online

		$query = "SELECT DISTINCT count(login_user_id) as count

				  FROM $track_online_table INNER JOIN $friend_user_table

                  ON (friend_user_id = login_user_id)

				  WHERE

				        login_date >= '$current_date' AND

				        friend_user_id <> '".api_get_user_id()."' AND

				        relation_type='".USER_RELATION_TYPE_FRIEND."' AND

				        user_id = '".api_get_user_id()."' ";

	} else {

		// All users online

		$query = "SELECT count(login_id) as count

                  FROM $track_online_table track INNER JOIN $table_user u

                  ON (u.id=track.login_user_id)

                  WHERE u.status != ".ANONYMOUS." AND login_date >= '$current_date'  ";

	}

	if (api_get_multiple_access_url()) {

		$access_url_id = api_get_current_access_url_id();

	if (api_get_multiple_access_url()) {

		$access_url_id = api_get_current_access_url_id();

		if ($access_url_id != -1) {

			if ($friends) {

				// 	friends from social network is online

				$query = "SELECT DISTINCT count(login_user_id) as count

							FROM $track_online_table track

							INNER JOIN $friend_user_table ON (friend_user_id = login_user_id)

							WHERE

							    track.access_url_id = $access_url_id AND

							    login_date >= '".$current_date."' AND

							    friend_user_id <> '".api_get_user_id()."' AND

							    relation_type='".USER_RELATION_TYPE_FRIEND."'  ";

			} else {

				// all users online

				$query = "SELECT count(login_id) as count FROM $track_online_table  track

                          INNER JOIN $table_user u ON (u.id=track.login_user_id)

						  WHERE

						    u.status != ".ANONYMOUS." AND

						    track.access_url_id =  $access_url_id AND

						    login_date >= '$current_date' ";

			}

		}

	}