YAFLogo
FILE:mssql/procedures.sqlERROR:Invalid column name 'Birthday'.Invalid column name 'Birthday'.Invalid column name 'Birthday'.STATEMENT:create procedure [dbo].[yaf_User_ListTodaysBirthdays](@BoardId int, @StyledNicks bit = null) asbeginSELECT usr.UserID, [Birthday], usr.DisplayName, m.Username, Style = case(@StyledNicks) when 1 then ISNULL(( SELECT TOP 1 f.Style FROM [dbo].[yaf_UserGroup] e join [dbo].[yaf_Group] f on f.GroupID=e.GroupID WHERE e.UserID=usr.UserID AND LEN(f.Style) > 2 ORDER BY f.SortOrder), rnk.Style) else '' end FROM [dbo].[yaf_prov_Profile] as u JOIN [dbo].[yaf_prov_Membership] m on m.UserID=u.UserID JOIN [dbo].[yaf_User] usr on usr.Name=m.UserName and usr.BoardID = @BoardId join [dbo].[yaf_Rank] rnk on rnk.RankID=usr.RankID where datepart(MONTH,Birthday) = datepart(MONTH,GETUTCDATE()) and datepart(DAY,Birthday) = datepart(DAY,GETUTCDATE())end
Hey, balbes, let's go without curses - the feature can be disabled. It's a sort of test feature in svn beta version there will be a universal solution.
The YAF.NET Support Forum uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close