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.
Vous avez encore des questions ou avez besoin d'aide?