Thanks Mod Revisited - نوشته شده در (5430 Views)
Advanced Member
Carefree
مطلب: 4224
4224
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?
 پیش‌فرض مرتب‌سازی برای تاریخ DESC به معنی جدیدترین است  
 تعداد در صفحه 
نوشته شده در
Snitz Forums Admin
ruirib
مطلب: 26364
26364
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?
نوشته شده در
Advanced Member
Carefree
مطلب: 4224
4224
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.....
نوشته شده در
Snitz Forums Admin
ruirib
مطلب: 26364
26364
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).
نوشته شده در
Average Member
Webbo
مطلب: 982
982
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 smile
نوشته شده در
Development Team Member
Davio
مطلب: 12217
12217
Originally posted by ruirib
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.
That's the way I would go too.
نوشته شده در
Senior Member
bobby131313
مطلب: 1163
1163
I think this would be a nice addition to my forum. Been thinking about it for a while. I've seen 2 different versions on other forums. One where each member's name that thanked is under the post in a smaller font, and one where is says something like "This poster has been thanked XX times."
نوشته شده در
Snitz Forums Admin
ruirib
مطلب: 26364
26364
VBulletin offers both, Bobby, and I really like the way VBulletin does it.
نوشته شده در
Advanced Member
Carefree
مطلب: 4224
4224
Originally posted by ruirib Thanks table, with topic_ID, member_ID, date thanked. Thanks count, different topics count....
What would you use the two member table fields for? Wouldn't a query against the thanks/topic/member table give you any of the values or totals?
Also, what purpose for the date thanked? I've yet to see a thanks mod which reflects a date and not sure why someone would care.
نوشته شده در
Snitz Forums Admin
ruirib
مطلب: 26364
26364
My proposal is based on VBulletin. I do like the date, which is shown near the thanks, which is itself shown near the post. This will allow you to know when the thanks was given.

The two fields will simply make it easy to obtain the value without excessive querying. VBulletin shows the number of thanks near each post, and if you don't have the values already calculated, you will have a lot of querying. Makes no sense to me. After, it's the same reason why we keep the post count for each user, instead of totalling it over a user's posts.
نوشته شده در
Advanced Member
Carefree
مطلب: 4224
4224
OK. I'll take a look at their features, see what else I may incorporate into this project.
شما باید یک متن وارد کنید