Bookmark and Share
About
Features
Blog
Documentation
Support
Welcome Guest Search | Active Topics | Members | Log In | Register

6 Pages«<456
YAF v1.9.403 BETA3 (Dated: 10/22/2009) - SVN Rev. 2796
Options View
Previous Topic Next Topic
Kamyar Offline
#76 Posted : Tuesday, November 10, 2009 2:45:18 AM(UTC)


Rank: YAF Developer

Medals: Mod Developer Medal of Honor: Wrote a kick-ass Mod and contributed back to the community.Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.

Joined: 7/22/2009(UTC)
Posts: 275
Location: Tehran

Thanks: 45 times
Was thanked: 51 time(s) in 41 post(s)
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"Wink
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
Back to top
3 users thanked Kamyar for this useful post.
kuznetsov on 11/10/2009(UTC), herman_herman on 11/10/2009(UTC), Masil on 11/12/2009(UTC)
herman_herman Offline
#77 Posted : Tuesday, November 10, 2009 3:37:51 AM(UTC)


Rank: YAF MVP

Medals: Medal of Honor for the SQL Scout: Medal for kicking ass at SQL and helping with database development.Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for The Eyes of the Community: Given for being a community hawk, always watching and helping fellow users.

Joined: 5/18/2007(UTC)
Posts: 636
Location: Iran - Tehran

Thanks: 57 times
Was thanked: 36 time(s) in 34 post(s)
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 Grin
Half of my life was elapsed in front of monitors, waiting for progress bars to reach their 100%.
Back to top
TheNerd Offline
#78 Posted : Wednesday, November 11, 2009 8:40:12 AM(UTC)
Rank: YAF Camper

Joined: 7/18/2009(UTC)
Posts: 28
Location: Nowhere

Thanks: 1 times
Was thanked: 0 time(s) in 0 post(s)
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?
Back to top
WWW
Jaben Offline
#79 Posted : Wednesday, November 11, 2009 8:58:54 AM(UTC)

Rank: YAF Head Dude

Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 4,152
Location: Raleigh, NC

Thanks: 35 times
Was thanked: 94 time(s) in 49 post(s)
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 have a simple philosophy: Fill what's empty. Empty what's full. Scratch where it itches.”.

Back to top
BLOG
TheNerd Offline
#80 Posted : Wednesday, November 11, 2009 10:15:47 AM(UTC)
Rank: YAF Camper

Joined: 7/18/2009(UTC)
Posts: 28
Location: Nowhere

Thanks: 1 times
Was thanked: 0 time(s) in 0 post(s)
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.
Back to top
WWW
Jaben Offline
#81 Posted : Wednesday, November 11, 2009 12:06:56 PM(UTC)

Rank: YAF Head Dude

Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 4,152
Location: Raleigh, NC

Thanks: 35 times
Was thanked: 94 time(s) in 49 post(s)
in yaf_message_delete:

Code:

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:

Code:

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


any thoughts?
"I have a simple philosophy: Fill what's empty. Empty what's full. Scratch where it itches.”.

Back to top
BLOG
TheNerd Offline
#82 Posted : Thursday, November 12, 2009 4:53:02 AM(UTC)
Rank: YAF Camper

Joined: 7/18/2009(UTC)
Posts: 28
Location: Nowhere

Thanks: 1 times
Was thanked: 0 time(s) in 0 post(s)
Jaben wrote:
in yaf_message_delete:

Code:

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:

Code:

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.
Back to top
WWW
Jeffdesu Offline
#83 Posted : Sunday, November 22, 2009 8:15:02 PM(UTC)
Rank: YAF Forumling

Joined: 11/22/2009(UTC)
Posts: 1
Location: Taiwan

Thanks: 0 times
Was thanked: 0 time(s) in 0 post(s)
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 Smile
Back to top
lawrencevt Offline
#84 Posted : Monday, December 07, 2009 5:03:36 PM(UTC)
Rank: YAF Forumling

Joined: 12/7/2009(UTC)
Posts: 1
Location: Colombo

Thanks: 0 times
Was thanked: 0 time(s) in 0 post(s)
mmmmm
Back to top
danova Offline
#85 Posted : Thursday, December 24, 2009 8:17:50 AM(UTC)
Rank: Member

Joined: 12/20/2009(UTC)
Posts: 10

Thanks: 0 times
Was thanked: 0 time(s) in 0 post(s)
Now you're just doing it on purpose. Cheesy Grin
Back to top
victorantos Offline
#86 Posted : Monday, December 28, 2009 11:49:50 AM(UTC)

Rank: YAF Lover

Joined: 10/29/2008(UTC)
Posts: 52
Location: UK

Thanks: 1 times
Was thanked: 2 time(s) in 2 post(s)
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 Smile




are you sure you want this?
Back to top
WWW BLOG
coldapoy Offline
#87 Posted : Monday, December 28, 2009 1:42:02 PM(UTC)

Rank: YAF Forumling

Joined: 12/16/2009(UTC)
Posts: 6

Thanks: 0 times
Was thanked: 0 time(s) in 0 post(s)
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!
Back to top
AsULikeIt Offline
#88 Posted : Thursday, January 14, 2010 3:16:06 AM(UTC)

Rank: Advanced Member

Joined: 5/19/2009(UTC)
Posts: 38
Location: India

Thanks: 1 times
Was thanked: 0 time(s) in 0 post(s)
When would be the final release of YAF 1.9.4 is expected ???
Back to top
Users browsing this topic
Guest
6 Pages«<456
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.

YAFPro Theme Created by Jaben Cargman (Tiny Gecko)
Powered by YAF 1.9.4 RC4 | YAF © 2003-2010, Yet Another Forum.NET
This page was generated in 0.412 seconds.