YAF.NET Support Forum

          if (!isCrawler)
          {
              userLink.ID = "UserLink" + this.InstantId + userLink.UserID;
          }
          else
          {
            userLink.ID += userLink.ReplaceName;
          }

    private void ForumStatistics_Load([NotNull] object sender, [NotNull] EventArgs e)
    {
...

      // "Active Users" Count and Most Users Count
      DataRow activeStats = LegacyDb.active_stats(this.PageContext.PageBoardID);
      this.ActiveUserCount.Text = this.FormatActiveUsers(activeStats);

      //Tommy
      {
        DataTable activeUsers1Day = this.Get<IDataCache>().GetOrSet(
          "VisitorsInTheLast24Hours",
          () => this.Get<IDBBroker>().GetRecentUsers(60 * 24),
          TimeSpan.FromMinutes(this.Get<YafBoardSettings>().ForumStatisticsCacheTimeout));
        this.activeUsersOneDay.ActiveUserTable = activeUsers1Day;

        DataTable activeUsers30Day = this.Get<IDataCache>().GetOrSet(
          "VisitorsInTheLast30Days",
          () => this.Get<IDBBroker>().GetRecentUsers(60 * 24 * 30),
          TimeSpan.FromMinutes(this.Get<YafBoardSettings>().ForumStatisticsCacheTimeout));

        ltrRecentUsers.Text =
          string.Format("Members online within the last 24 hours is {0}, within the last 30 days is {1}.",
          activeUsers1Day.Rows.Count,
          activeUsers30Day.Rows.Count);
      }

    /// <summary>
    /// Get the list of recently logged in users.
    /// </summary>
    /// <param name="timeSinceLastLogin">Time since last login in minutes.</param>
    /// <returns>The DataTable of the users.</returns>
    DataTable GetRecentUsers(int timeSinceLastLogin);

    /// <summary>
    /// Get the list of recently logged in users.
    /// </summary>
    /// <param name="timeSinceLastLogin">The time since last login in minutes.</param>
    /// <returns>The list of users in Datatable format.</returns>
    public DataTable GetRecentUsers(int timeSinceLastLogin)
    {
      return
        this.StyleTransformDataTable(
          LegacyDb.recent_users(
            YafContext.Current.PageBoardID, timeSinceLastLogin,
            this.Get<YAF.Classes.YafBoardSettings>().UseStyledNicks));
    }

    public static DataTable recent_users(object boardID, int timeSinceLastLogin, object styledNicks)
    {
      using (var cmd = MsSqlDbAccess.GetCommand("recent_users"))
      {
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("BoardID", boardID);
        cmd.Parameters.AddWithValue("TimeSinceLastLogin", timeSinceLastLogin);
        cmd.Parameters.AddWithValue("StyledNicks", styledNicks);
        return MsSqlDbAccess.Current.GetData(cmd);
      }
    }

USE [YafForum]
GO
/****** Object:  StoredProcedure [dbo].[yaf_recent_users]    Script Date: 03/12/2011 03:45:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[yaf_recent_users](@BoardID int,@TimeSinceLastLogin int,@StyledNicks bit=0) as
begin	
	SELECT U.UserId,
	IsCrawler = 0,
	UserCount = 1,
	IsHidden = (IsActiveExcluded),
	Style = CASE(@StyledNicks)
				WHEN 1 THEN
						ISNULL ((SELECT TOP 1 G.Style
						 FROM [dbo].[yaf_UserGroup] AS UG
							  JOIN [dbo].[yaf_Group] G on G.GroupID=UG.GroupID
							  WHERE UG.UserID=U.UserID AND LEN(G.Style) > 2 
							  ORDER BY G.SortOrder), '')
				ELSE ''
			END
	FROM [dbo].[yaf_User] AS U
				JOIN [dbo].[yaf_Rank] R on R.RankID=U.RankID
	WHERE (U.IsApproved = '1') AND
	 U.BoardID = @BoardID AND
	 (DATEADD(mi, 0 - @TimeSinceLastLogin, GETDATE()) < U.LastVisit) AND
				--Excluding guests
				NOT EXISTS(				
					SELECT 1 
						FROM [dbo].[yaf_UserGroup] x
							inner join [dbo].[yaf_Group] y ON y.GroupID=x.GroupID 
						WHERE x.UserID=U.UserID and (y.Flags & 2)<>0
					)
	ORDER BY U.LastVisit
end

userLink.ID = "UserLink" + this.InstantId + userLink.UserID;

    /// <summary>
    /// The Instant ID for this control.
    /// </summary>
    /// <remarks>
    /// Multiple instants of this control can exist in the same page but
    /// each must have a different instant ID. Not specifying an Instant ID
    /// default to the ID being string.Empty.
    /// </remarks>
    public string InstantId
    {
      get
      {
        //return string.empty for null.
        return (this.ViewState["InstantId"] as string) + "";
      }
      set
      {
        this.ViewState["InstantId"] = value;
      }
    }

<YAF:ActiveUsers ID="ActiveUsers1" runat="server"></YAF:ActiveUsers>

<YAF:ActiveUsers ID="activeUsersOneDay" runat="server" InstantId="ActiveUsersOneDay" />