Updating Your Community Membership Points

Community Server supports two ways to update a new or existing community’s membership points.

Sites with fewer than 25,000 posts

1. Navigate to Control Panel Dashboard > System Administration > Site Administration > Manage Member Points System.
2. Select the Calculate tab.
3. Click Calculate.

Sites with more than 25,000 posts

For sites with more than 25,000 posts, you should run the initial calculation offline so you will not timeout.

1. Open Query Analyzer.
2. Select your Community Server database.
3. Execute the script with the following filter values:

FilterType = 1

FilterValue = 0

ForumRatingType = 0 for Thread-Level Rating or = 1 for Post-Level Rating

EXECUTE cs_Points_CalculateForPost_Set @SettingsID, @FilterType, @FilterValue, @PostFactor ,@ReplyFactor, @ReplierFactor, @RatingFactor, @DownloadFactor, @DownloaderFactor, @FavoritePostFactor, @ForumRatingType

EXECUTE cs_Points_CalculateForUser_Set @SettingsID, @FilterType, @FilterValue, @FavoriteUserFactor, @RaterFactor, @ForumRatingType

Once enabled, the MPS triggers point calculation whenever a point-collecting activity occurs. If you notice that points are not continuing to increase after the activity, ensure that the PointsModule has not been removed from the communityserver.config file.

<add name = "PointsModule" type = "CommunityServer.Points.PointsModule, CommunityServer.Points" />