vb.org Archive - Add-On Releases - [AJAX] Helpful Answers - Allow users to rate individual posts

This system works fine with many 4.x sites as noted by other members over past posts. If you provided actual details, I'm sure we could figure out what's not happening for your specific forum but it's pretty hard to do much with "doesn't work good."

Ted S

01-27-2014 08:19 PM

Quote:

Originally Posted by Prince (Post 2476417)

this hack stinks.

I'm not understanding if you don't like the concept or the execution. If the former, by all means, don't use what isn't right for you. If the later, perhaps you'll grace us with some details to help insure it gets improved?

Ted S

01-27-2014 08:21 PM

Quote:

Originally Posted by ozzy47 (Post 2476420)

Hmmm, 555+ installs, I would say you are a bit late.

And the 4,000,000+ votes that have taken place through those installs (anonymous reporting is an admin option). Suppose that means a few people must like it... maybe, sorta?

[Edit: Make that 6.4 million. Guess they didn't get the memo that it stinks yet :D]

asabet

01-29-2014 06:05 PM

I own several photography forums, and I'm looking for a solution that would let members nominate posts for consideration to be featured on the front page/CMS. This looks like it will work really well for that - I would check the stats daily and see which posts receive multiple nominations - but it has a lot more options/features than I need. Does it affect performance much on a big board?

Ted S

01-30-2014 04:42 PM

Quote:

Originally Posted by asabet (Post 2477781)

Everything dynamic impacts performance but this mod is pretty low on the threshold as it's primarily just extending existing queries to call in votes and, on occasion, append them in. It's by no means without it's hit but it was designed thinking about how to avoid new calls (and mark options which require them clearly).

The biggest boards using the mod pull in six figures worth of votes themselves, so you can infer from that what their size is.

tpearl5

01-30-2014 06:06 PM

Quote:

Originally Posted by Ted S (Post 2460015)

There's no import feature at this point... not sure how they work exactly if you can explain?

One like = one helpful answer vote. There are no down votes. There was an importer for this mod for the likes. This was the query:

PHP Code:


		
			
"select p.postid,p.userid,ha.dateline as date,ha.userid as whoadded,hp.threadid,u.username,l.l_contentid ".

"from ".vbseo_tbl_prefix('helpfulanswer')." ha inner join ".vbseo_tbl_prefix('post')." p on (ha.postid = p.postid) ".

"inner join ".vbseo_tbl_prefix('helpfulpost')." hp on (ha.postid = hp.postid) ".

"inner join ".vbseo_tbl_prefix('user')." u on (ha.userid = u.userid) ".

"left join ".vbseo_tbl_prefix('vbseo_likes')." l on l_ctype=1 and l_contentid=p.postid and l_from_userid=ha.userid ".

"where ha.yesno = 1";

Ted S

01-30-2014 06:41 PM

Quote:

Originally Posted by tpearl5 (Post 2478052)

One like = one helpful answer vote. There are no down votes. There was an importer for this mod for the likes. This was the query:

PHP Code:


		
			
"select p.postid,p.userid,ha.dateline as date,ha.userid as whoadded,hp.threadid,u.username,l.l_contentid ".
"from ".vbseo_tbl_prefix('helpfulanswer')." ha inner join ".vbseo_tbl_prefix('post')." p on (ha.postid = p.postid) ".
"inner join ".vbseo_tbl_prefix('helpfulpost')." hp on (ha.postid = hp.postid) ".
"inner join ".vbseo_tbl_prefix('user')." u on (ha.userid = u.userid) ".
"left join ".vbseo_tbl_prefix('vbseo_likes')." l on l_ctype=1 and l_contentid=p.postid and l_from_userid=ha.userid ".
"where ha.yesno = 1";

Very Cool.

Just remember, there's 3 bits of logging involved in votes:

helpfulpost - which stores the post level totals (so we don't have calculate every load)
helpfulanswer - which records the votes (so we know every detail to report / manage)

and then a record on the user level (for profile views)

All times are GMT. The time now is 03:05 AM.

Page 128 of 133

128

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02404 seconds Memory Usage 1,759KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: