The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
This has come up a number of times over the years and, as far as I know, nobody has done it. I'd be happy to code it but I'm hitting a mental block as to the best way. Anyone have any suggestions?
Postet den
Not sure I understand what you want suggestions about. How it should work for users? How to keep the data related to it? How to actually code it?
Postet den
More on the database integration. Considering how best to record all the users' thanks * thousands of posts. Maybe adding a memo field to the topic table and comma-separating the member_id numbers.....
Postet den
Definitely not adding stuff to the topics table. It's already way too big. Also, adding "unlimited" size text fields is not good, performance wise, in SQL Server databases. To me, I would say it's pretty clear:
Thanks table, with topic_ID, member_ID, date thanked. Thanks count, different topics count, added to the member's table (which is very "wide" too, anyway, but two integer fields are not a big source of trouble).
Thanks table, with topic_ID, member_ID, date thanked. Thanks count, different topics count, added to the member's table (which is very "wide" too, anyway, but two integer fields are not a big source of trouble).
Postet den
Have you had a look at the Invision Power Service forum software. In the latest versions a member can Vote a post up if they think it is worth of a point, a bit like thanking the poster, and alongside the post there is a count to show if it has been voted up, the default being '0'
A member can be limited to a number of votes per day therefore only allowing them to vote on a predetermined number of times in a set period and only once per post to prevent abuse
It might be worth a look as a starting point
A member can be limited to a number of votes per day therefore only allowing them to vote on a predetermined number of times in a set period and only once per post to prevent abuse
It might be worth a look as a starting point
Postet den
Originally posted by ruiribThat's the way I would go too.
Thanks table, with topic_ID, member_ID, date thanked. Thanks count, different topics count, added to the member's table (which is very big too, anyway, but two integer fields are not a big source of trouble.