Kamyar
  • Posts: 321
  • Joined: 22/07/2009
It's very exciting to see Thanks Mod in action here. Thanks to all you guys for guiding me to implement.
BTW, Anyone noticed Thanks Statistics is not shown in Userbox? ("Thanks: ... Times" and "Was Thanks ... Times in .. Posts")
Wasn't sure where to put this post. So sorry if this is not the place.
If at first you don’t succeed, call it version 1.0
herman_herman
  • Posts: 535
  • Joined:: 19/05/2007
Thank YOU Kamyar for your wonderful contribution.
This is probably because of the fact that performance enhancement by you is not applied yet I guess :wink: :cheesy:
TheNerd
  • Posts: 28
  • Joined: 18/07/2009
Hello, we have the beta version up and running in our prod environment after going through and fixing some bugs that you guys already noted here. One thing that is troubling us - we migrated from an old DNN forums, and we moved the post counts with us (yaf_user.numposts). One user had 11,000 posts. Somehow, his post count, and several others and getting reset down to like 1,207 or other smaller numbers. When did the migration, we lost several posts because of bad data, but that should not have affected the post count.

Can you tell me, is there some automated process that updates the NumPosts field on a daily basis with the actual count from the database, and if so, where can I find that?
Jaben
  • Posts: 2544
  • Joined: 09/10/2004
TheNerd wrote:

Hello, we have the beta version up and running in our prod environment after going through and fixing some bugs that you guys already noted here. One thing that is troubling us - we migrated from an old DNN forums, and we moved the post counts with us (yaf_user.numposts). One user had 11,000 posts. Somehow, his post count, and several others and getting reset down to like 1,207 or other smaller numbers. When did the migration, we lost several posts because of bad data, but that should not have affected the post count.

Can you tell me, is there some automated process that updates the NumPosts field on a daily basis with the actual count from the database, and if so, where can I find that?


When a user posts, it automatically recounts their posts. I guess that could be bad if you do a lot of post archiving.

Hmm... never thought about it.

Any one else have thoughts on this topic?
TheNerd
  • Posts: 28
  • Joined: 18/07/2009
Jaben wrote:

TheNerd wrote:

Hello, we have the beta version up and running in our prod environment after going through and fixing some bugs that you guys already noted here. One thing that is troubling us - we migrated from an old DNN forums, and we moved the post counts with us (yaf_user.numposts). One user had 11,000 posts. Somehow, his post count, and several others and getting reset down to like 1,207 or other smaller numbers. When did the migration, we lost several posts because of bad data, but that should not have affected the post count.

Can you tell me, is there some automated process that updates the NumPosts field on a daily basis with the actual count from the database, and if so, where can I find that?


When a user posts, it automatically recounts their posts. I guess that could be bad if you do a lot of post archiving.

Hmm... never thought about it.

Any one else have thoughts on this topic?



I looked at the yaf_message_approve proc but all I see is this:

update [dbo].[yaf_User] set NumPosts = NumPosts + 1 where UserID = @UserID

Which if numPosts started at 11,000 then after this is run should be 11,001. Something else seems to be killing the post count...

We do a lot of post pruning and archiving to keep our DB managable, but we do not want our users to lose post counts and thusly never gain ranks. But I'll be damned if I can find the code that updates the post count for user in any place other than yaf_message_approve.
Jaben
  • Posts: 2544
  • Joined: 09/10/2004
in yaf_message_delete:


UPDATE [{databaseOwner}].[{objectQualifier}User] SET NumPosts = (SELECT count(MessageID) FROM [{databaseOwner}].[{objectQualifier}Message] WHERE UserID = @UserID AND IsDeleted = 0 AND IsApproved = 1) WHERE UserID = @UserID


Could be changed back to:


UPDATE [{databaseOwner}].[{objectQualifier}User] SET NumPosts = NumPosts - 1 WHERE UserID = @UserID


any thoughts?
TheNerd
  • Posts: 28
  • Joined: 18/07/2009
Jaben wrote:

in yaf_message_delete:


UPDATE [{databaseOwner}].[{objectQualifier}User] SET NumPosts = (SELECT count(MessageID) FROM [{databaseOwner}].[{objectQualifier}Message] WHERE UserID = @UserID AND IsDeleted = 0 AND IsApproved = 1) WHERE UserID = @UserID


Could be changed back to:


UPDATE [{databaseOwner}].[{objectQualifier}User] SET NumPosts = NumPosts - 1 WHERE UserID = @UserID


any thoughts?



Ah yes, the delete and undelete try to recalculate based on the current counts. We commented these out entirely with the idea that once you make a post, its counted forever, even if it gets deleted. We count attempts to post as positive karma, unless they are spamming, in which case they get banned.

Another feature I'd like to add that i am working on - allowing/disallowing images in signatures. Our forum loves sigs, hates pics in them. I put in code that permanently disallows it, but I think it would be good to turn this in to a switch for YAF. Just a thought.
Jeffdesu
  • Posts: 1
  • Joined: 23/11/2009
Would anyone answer about the suggestion 1? ,please..

I need to deploy a version of customized yaf with some integrated works next month.

It would help me a lot if someone could tell me which version should I take as a baseline to modify.

1.9.3 or 1.9.4 beta..4?


thanks for all of you!



triangle wrote:

i've two suggestions:

1. What's the plan for the first RC and Final Release?
2. please make the LDAP/SSO Integration working fine :)


lawrencevt
  • Posts: 1
  • Joined: 07/12/2009
mmmmm
danova
  • Posts: 10
  • Joined: 20/12/2009
Now you're just doing it on purpose. :cheesy:
victorantos
  • Posts: 57
  • Joined: 29/10/2008
Jeffdesu wrote:

Would anyone answer about the suggestion 1? ,please..

I need to deploy a version of customized yaf with some integrated works next month.

It would help me a lot if someone could tell me which version should I take as a baseline to modify.

1.9.3 or 1.9.4 beta..4?


thanks for all of you!



triangle wrote:

i've two suggestions:

1. What's the plan for the first RC and Final Release?
2. please make the LDAP/SSO Integration working fine :)





are you sure you want this?
coldapoy
  • Posts: 6
  • Joined: 16/12/2009
Hi guys, kudos to all of you.... i have a question and i'm not pretty sure where to post? where can i find the step by step procedure for installing and the intergration to my site resources for YAF? hope you guys are kind enough to help me out... thanks and happy holidays!
AsULikeIt
  • Posts: 38
  • Joined: 20/05/2009
When would be the final release of YAF 1.9.4 is expected ???
Users browsing this topic
    Forum Jump  
    • You cannot post new topics in this forum.
    • You cannot reply to topics in this forum.
    • You cannot delete your posts in this forum.
    • You cannot edit your posts in this forum.
    • You cannot create polls in this forum.
    • You cannot vote in polls in this forum.

    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