YAFLogo

dragonfly
  • dragonfly
  • 63.2% (Friendly)
  • YAF Camper Topic Starter
13 years ago
In the YAF help screens, it is mentioned that the administrator can setup forums to track the read status of postings by member. See below. We would like to setup this feature, as our users would like to have accurate read status information across multiple visits to the site (i.e. not just changes since their last visit). However, we have not been able to find this setting in the Admin or Host settings screens in YAF. Can someone please point us to the location of this setting? Also, what are the performance implications of using this feature?

We are currently using the latest release of the YAF for DNN

Viewing New Posts

If you are not logged in, the 'Active Topics' link in the Header, will show a list of all topics that have been created or updated since your last visit.

If you are logged in, the 'Active Topics' link will change to 'My Topics', which gives you a listing of all topics that have been created or updated since your last visit.

The administrator can also set up the forums so that each thread you read is marked in the database. If this option is set, then new topic (or topics with new posts) will not be marked as read until you have actually read them.

There will be also an Second Tab 'Favorite Topics' which shows all Topics which you have tagged as Favorite Topic.

Thanks

Sponsor
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
13 years ago
You can't find the setting because it didn't exist yet, the help text about that is incorrect and updated in the next release.

I am working on a topic read status but it's currently not available.

dragonfly
  • dragonfly
  • 63.2% (Friendly)
  • YAF Camper Topic Starter
13 years ago

You can't find the setting because it didn't exist yet, the help text about that is incorrect and updated in the next release.

I am working on a topic read status but it's currently not available.

Originally Posted by: tha_watcha 

Do you possibly have an estimate as to when this feature will be available? We are planning on rolling out YAF mid August, and our clients have said this feature is a top priority. If it won't be ready by then, we will probably have to work on our own version using the YAF source.

If you are not planning on releasing it for a while, could you let us know what your approach is for building this feature to help simplify the process for us? We want to make sure that the feature doesn't create a huge performance problem.

Thanks

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
13 years ago

You can't find the setting because it didn't exist yet, the help text about that is incorrect and updated in the next release.

I am working on a topic read status but it's currently not available.

Originally Posted by: dragonfly 

Do you possibly have an estimate as to when this feature will be available? We are planning on rolling out YAF mid August, and our clients have said this feature is a top priority. If it won't be ready by then, we will probably have to work on our own version using the YAF source.

If you are not planning on releasing it for a while, could you let us know what your approach is for building this feature to help simplify the process for us? We want to make sure that the feature doesn't create a huge performance problem.

Thanks

Originally Posted by: tha_watcha 

The Code is almost ready, it should be ready in a few days. After some testing. I thing it will be included in the next yaf release.

dragonfly
  • dragonfly
  • 63.2% (Friendly)
  • YAF Camper Topic Starter
13 years ago

You can't find the setting because it didn't exist yet, the help text about that is incorrect and updated in the next release.

I am working on a topic read status but it's currently not available.

Originally Posted by: tha_watcha 

That is great news. We urgently need this functionality for our project. Do you have an estimate for when the next release of YAF will be available? Also, what are the chances that we could get a beta version of the code that we could work with? Our deadline for completion of the forums is end of July and we are launching mid-August. We need to be able to test the code a few weeks in advance of the rollout.

Thanks

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
13 years ago
Code is now added to the Repository you can grab it from the Repository or download it via CodePlex

http://yafnet.codeplex.com/SourceControl/changeset/changes/867ac9d232f6 

But its Currently only tested by me. Do not use it in Production yet.

bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer
13 years ago
I enabled it and couldn't disable. Don't use it so far. And again...

32 SQL Queries: 0.577 Seconds (68.85% of Total Page Load Time).

[dbo].[yaf_user_lastread]: 0.025

[dbo].[yaf_topic_active]: 0.021

[dbo].[yaf_prov_getuser]: 0.021

[dbo].[yaf_shoutbox_getmessages]: 0.023

[dbo].[yaf_smiley_listunique]: 0.015

[dbo].[yaf_forum_listread]: 0.032

[dbo].[yaf_readtopic_lastread]: 0.012

[dbo].[yaf_readforum_lastread]: 0.021

[dbo].[yaf_readforum_lastread]: 0.015

[dbo].[yaf_readtopic_lastread]: 0.021

[dbo].[yaf_readforum_lastread]: 0.015

[dbo].[yaf_readtopic_lastread]: 0.023

[dbo].[yaf_readforum_lastread]: 0.022

[dbo].[yaf_topic_latest]: 0.017

[dbo].[yaf_readtopic_lastread]: 0.016

[dbo].[yaf_readforum_lastread]: 0.018

[dbo].[yaf_readtopic_lastread]: 0.019

[dbo].[yaf_readforum_lastread]: 0.015

[dbo].[yaf_readtopic_lastread]: 0.018

[dbo].[yaf_readforum_lastread]: 0.013

[dbo].[yaf_readtopic_lastread]: 0.016

[dbo].[yaf_readforum_lastread]: 0.014

[dbo].[yaf_readtopic_lastread]: 0.020

[dbo].[yaf_readforum_lastread]: 0.014

[dbo].[yaf_active_list]: 0.022

[dbo].[yaf_active_stats]: 0.016

[dbo].[yaf_readtopic_lastread]: 0.016

[dbo].[yaf_readforum_lastread]: 0.016

[dbo].[yaf_readtopic_lastread]: 0.013

[dbo].[yaf_readforum_lastread]: 0.012

[dbo].[yaf_readtopic_lastread]: 0.015

[dbo].[yaf_readforum_lastread]: 0.021

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
13 years ago
Ok the issue with the sql queries should be fixed now. Disabling the feature in the host settings works for me.
bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer
13 years ago
This is the fix, didn't merge to not intervene.

@@ -9849,13 +9849,12 @@

{

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("UserID", userID);

-

- using (var tableLastRead = MsSqlDbAccess.Current.GetData(cmd))

- {

- return tableLastRead.Rows.Count > 0

- ? tableLastRead.GetFirstRowColumnAsValue("LastAccessDate", lastVisitDate)

+ var tableLastRead = MsSqlDbAccess.Current.ExecuteScalar(cmd);

+

+ return tableLastRead != null

+ ? (DateTime)tableLastRead

: lastVisitDate;

- }

+

}

}