vb.org Archive - Add-On Releases - [AJAX] Helpful Answers - Post Rating System (plus many sub-features)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Add-On Releases - [AJAX] Helpful Answers - Post Rating System (plus many sub-features) (https://vborg.vbsupport.ru/showthread.php?t=204117)

Thanks WoodiE. I've really never dived deep into AJAX and I was pretty pleased to have it go so fast although for a mod like this it was a pretty simple change.

Also releasing 1.3.1 which moves the helpful_answers template to phrases for better translation support and easier editing.

Thanks for the private feedback; I've added a simple page showing the Most Helpful Answers. This can be disabled through the options and the number of results to show can also be configured.

How does this impact to server load?

Quote:

Originally Posted by buileminh (Post 1733710)

How does this impact to server load?

Fair question and as I'm sure it will be asked later, I'll break down the different areas of potential impact:

1. Viewing a thread

No new queries are made with this addon but there is a change that impacts the existing post query. Basically with this addon 3 additional fields are pulled from the select routine, 2 exist in the post table and one is from a join on the helpful answers table. Joins certainly add to the query length but as both keys are indexed it's minimal.

There are also a few template conditionals called; while conditionals don't do much to load on their own they do add up if you use enough.

While testing this script I used microstats to measure impact and did not identify any noticeable impact to the page rendering or CPU usage.

2. Rating a post

When a post is rated the script goes through a series of checks including 2 queries to read out data and two updates to insert the vote record and change the post table. This is fairly minimal and since it's a specific request option (rather than something passive that happens when viewing a page) it should be expected.

3. Viewing the most helpful answers page

When enabled this page will run one looping query with a single join. This is not a major process at all.

4. Admin functions

The admin functions are mostly simple querying one or two times per page. The exception to this is doing a bulk delete on a user with a lot of rating history; in this case there's two queries per rating which can be intensive. As such this function is marked as being intensive.

Summed up

It's easy to get worried about a function like this where data is read on every post but I have done my best to minimize any impact. For example, rather than querying tables to get vote totals for every post the totals are stored with the post record and calling them up adds minimal load. Other steps are also taken to prevent load like using an array with banned members and a forum option to check if the forum is allowed to use the addon rather than querying the database for a standalone piece of data.

To be crystal clear, this addon has been used for over a year on a decent traffic forum that runs, as most of the users would say, fast. While there are new functions with the public release this is not an untested app and if it was impacting performance on my sites I wouldn't be using it let alone releasing it.

I'm confident this addon will have minimal additional performance impact but like every addon it does introduce more queries on some pages, more joins, more conditionals and more code which does mean more load. For larger sites I always encourage basic load testing (even just watching load times with microstats is often enough).

Hope that answers your question.

Code:

Database error in vBulletin 3.8.0:



Invalid SQL:



                SELECT

                        post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,

                        user.*, userfield.*, usertextfield.*,

                        icon.title as icontitle, icon.iconpath,

                        avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,

                        spamlog.postid AS spamlog_postid,

                        deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,

                        editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,

                        editlog.reason AS edit_reason, editlog.hashistory,

                        postparsed.pagetext_html, postparsed.hasimages,

                        sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,

                        sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,

                        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

                        

                        , IF(SUM(photoplog_fileuploads.moderate) > 0 AND 1 = 0,COUNT(photoplog_fileuploads.moderate) - SUM(photoplog_fileuploads.moderate),COUNT(photoplog_fileuploads.moderate)) AS photoplog_filecount,post.goodrank,post.totalrank,helpfulanswer.helpfulanswerid

                FROM post AS post

                LEFT JOIN user AS user ON(user.userid = post.userid)

                LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)

                LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

                LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)

                LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

                LEFT JOIN spamlog AS spamlog ON(spamlog.postid = post.postid)

                        LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')

                LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)

                LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 2 AND postparsed.languageid = 1)

                LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 2 AND sigparsed.languageid = 1)

                LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

                        LEFT JOIN photoplog_fileuploads AS photoplog_fileuploads ON(photoplog_fileuploads.userid = user.userid)LEFT JOIN helpfulanswer AS helpfulanswer ON(helpfulanswer.postid = post.postid and helpfulanswer.userid = 1)

                WHERE post.postid IN (0,50) GROUP BY post.postid

                ORDER BY post.dateline;



MySQL Error   : Table 'theguy1_AllBoutLife.helpfulanswer' doesn't exist

My error after visiting a thread

The3rdNipple,

It looks like the table used to store records was not able to be created by the installer.

You will need to create this table manually by running the following query from phpMyAdmin or a similar database program.

Code:

CREATE TABLE `helpfulanswer` (

      `helpfulanswerid` int(10) unsigned NOT NULL AUTO_INCREMENT,

      `postid` int(10) unsigned NOT NULL DEFAULT '0',

      `userid` int(10) unsigned NOT NULL DEFAULT '0',

      `yesno` int(10) unsigned NOT NULL DEFAULT '0',

      `dateline` INT UNSIGNED NOT NULL DEFAULT '0',

      KEY `helpfulanswerid` (`helpfulanswerid`),

      KEY `postid` (`postid`),

      KEY `userid` (`userid`)

);

I suggest you disable the addon until this is done, if you have not done so already.

Interesting mod. Watching this closely.
In the update history, the latest should be 1.3.2 instead of 1.3.3

How do you compare this one with Yahoo Answers. Yahoo makes it very easy to find the most useful answer in a long thread.

Quote:

Originally Posted by Quantnet.org (Post 1733754)

Definitely happy to have your feedback whether you install or not.

This mod has a lot of similarities to the Yahoo Answers site in letting users rate responses which they also do. Future visitors can then identify the more popular/ trusted answers out of the overall batch.

The feature you're talking about where the topic starter picks an answer and has that answer moved to the top of the list is not something this mod tries to solve as that's not about group ratings but rather about an individual post selection. I've developed a feature like that for a few sites but have never made it move the post around. It's an interesting discussion as a forum is different than q&a website like Yahoo Answers and moving a post up in order to say the second spot has a lot of implications for discussion flow. That said, I imagine there are sites with areas that could use an easy selection process like that.

I would like to see a in-post feature to rate preset phrases:

Color: [rate]
Speed: [rate]
Design [rate]
...

Unlike the poll function can you put a voting system up.

I'm waiting for a feature where the most useful post in a thread is highlighted using some customizable color palette.
what is your solution when you have 2 equally ranked posts on the level of usefulness? Will they be marked most useful at the same time?

I can see this being very useful for my site and I look forward to installing soon.

P.S Can you post a screenshot of the post in the thread. I like to see how standout it looks currently

X vBulletin 3.8.12 by vBS Debug 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_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02455 seconds Memory Usage 1,762KB 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_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)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: