Stored Procedure Nop_CustomerUpdateCounts updates the table Nop_Customer with the number of Posts the customer has (Nop_Customer.TotalForumPosts) based on the count of their userID in table Nop_Forums_Post.
SP Nop_CustomerUpdateCounts is executed from SP Nop_Forums_PostInsert.
SP Nop_Forums_PostInsert is executed by SQLForumProvider.InsertPost() (Libraries\Nop.DataAccess.SqlServer\Content\Forums\SQLForumProvider.cs).
Were you guys researching this as part of moving the ForumProvider to another database? I'm interested in doing that and it looks like I would lose the customer post count functionality if I did. It looks pretty straightforward otherwise since the customerID is not a FK in any of the Nop_Forum* tables.
Has anyone tried breaking out the forum into its own database?
Many thanks!
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.