dragonfly
  •  dragonfly
  • 63.2% (Friendly)
  • YAF Camper Topic Starter
2011-07-10T18:03:59Z
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
2011-07-11T00:22:47Z
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.
UserPostedImage
dragonfly
  •  dragonfly
  • 63.2% (Friendly)
  • YAF Camper Topic Starter
2011-07-11T01:36:32Z
Originally Posted by: tha_watcha 

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.



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
2011-07-11T14:35:36Z
Originally Posted by: dragonfly 

Originally Posted by: tha_watcha 

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.



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



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.

UserPostedImage
dragonfly
  •  dragonfly
  • 63.2% (Friendly)
  • YAF Camper Topic Starter
2011-07-11T14:52:18Z
Originally Posted by: tha_watcha 

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.




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
2011-07-14T12:29:56Z
Code is now added to the Repository you can grab it from the Repository or download it via CodePlex

http://yafnet.codeplex.c...set/changes/867ac9d232f6 

But its Currently only tested by me. Do not use it in Production yet.
UserPostedImage
bbobb
  •  bbobb
  • 100% (Exalted)
  • YAF Developer
2011-07-15T05:18:54Z
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
2011-07-15T15:38:04Z
Ok the issue with the sql queries should be fixed now. Disabling the feature in the host settings works for me.
UserPostedImage
bbobb
  •  bbobb
  • 100% (Exalted)
  • YAF Developer
2011-07-16T00:18:50Z
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;
- }
+
}
}
Users browsing this topic

    About Us

    The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

    Powered by Resharper Donate with PayPal button

    Project Twitter Updates

    Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved