Jaben has posted a fix for the Most users ever online being 1 issue. However for GoDaddy users, this is a bit elusive. They are using an older version of YAF, so you need to run the SQL below in your SQL DB Manager.
EDITED FOR CLARITY: This fix WILL work for GoDaddy accounts.
1. Connect to
www.godaddy.com2. Log in with your credentials.
3. Click the "My Account" link that appears where your login fields were.
4. Click the Hosting & Email icon, 2nd from the left, just below the green menu bar.
5. From the list of Hosting Accounts (or just your one) click the "Open" link that corresponds to your web site.
6. When the Control Panel opens, click on the grey "Databases" bar.
7. Click the SQL Server Icon.
8. Select and copy (Ctrl-C) the Database Name.
9. Click the "Open Manager" link.
10. Enter the Database Name as the User Name and your Password as the Password. (If you don't know your password, you can reset it by clicking the Pencil icon on the previous screen. That screen is the window immediately beneath your current active window.)
11. Click the Connect button.
12. Click the "Tables" link.
13. Double Click "yaf_Active" (2nd in the list)
14. Scroll all the way to the bottom.
15. Double Click "yaf_Active_insert"
16. Select and copy (Ctrl-C) the code below.
Code:
ALTER TRIGGER [dbo].[yaf_Active_insert] ON [dbo].[yaf_Active] FOR INSERT
AS
BEGIN
DECLARE @BoardID int, @count int, @max int, @maxStr nvarchar(255), @countStr nvarchar(255), @dtStr nvarchar(255)
SET @BoardID = (SELECT BoardID FROM inserted)
SET @count = ISNULL((SELECT COUNT(DISTINCT IP) FROM [dbo].[yaf_Active] WITH (NOLOCK) WHERE BoardID = @BoardID),0)
SET @maxStr = ISNULL((SELECT CAST([Value] AS nvarchar) FROM [dbo].[yaf_Registry] WHERE BoardID = @BoardID AND [Name] = N'maxusers'),'1')
SET @max = CAST(@maxStr AS int)
SET @countStr = CAST(@count AS nvarchar)
SET @dtStr = CONVERT(nvarchar,GETDATE(),126)
IF NOT EXISTS ( SELECT 1 FROM [dbo].[yaf_Registry] WHERE BoardID = @BoardID and [Name] = N'maxusers' )
BEGIN
INSERT INTO [dbo].[yaf_Registry](BoardID,[Name],[Value]) VALUES (@BoardID,N'maxusers',CAST(@countStr AS ntext))
INSERT INTO [dbo].[yaf_Registry](BoardID,[Name],[Value]) VALUES (@BoardID,N'maxuserswhen',CAST(@dtStr AS ntext))
END
ELSE IF (@count > @max)
BEGIN
UPDATE [dbo].[yaf_Registry] SET [Value] = CAST(@countStr AS ntext) WHERE BoardID = @BoardID AND [Name] = N'maxusers'
UPDATE [dbo].[yaf_Registry] SET [Value] = CAST(@dtStr AS ntext) WHERE BoardID = @BoardID AND [Name] = N'maxuserswhen'
END
END
17. Locate the code in the edit field that begins "ALTER TRIGGER"
18. Highlight everything from there to the end of the code.
19. Paste Jaben's code in place (Ctrl-V) of the highlighted code.
20. Click the Apply button.
21. Close all your open windows.
Your "most users" tally will now increment.