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

Page 4 of 181

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

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)

mad@Max

02-04-2009 01:36 PM

Why don't create a table... I think this character is not necessary:

Code:

CREATE TABLE IF NOT EXISTS`". TABLE_PREFIX ."`helpfulanswer` (

Second error (when i click Yes or No):
in javascript window

Code:

                        SELECT post.goodrank,post.totalrank



                        FROM vb_post



                        WHERE postid = 4914;



MySQL Error     : Unknown column 'post.goodrank' in 'field list'

---------------
So, you should change your query in file helpfulanswers.php on this code:

PHP Code:


		
			
        $helpfulanswer = $db->query_first_slave("
            SELECT post.goodrank, post.totalrank
            FROM " . TABLE_PREFIX . "post AS post
            WHERE post.postid = $postinfo[postid]
        ");

---------------
Third error:D
In file helpfulanswers.php missed prefix:

Code:

        $helpfulanswers = $db->query_read_slave("

                SELECT postid,post.title as posttile,post.goodrank,post.totalrank,thread.threadid,thread.title as title

                FROM " . TABLE_PREFIX . "post as post                

                INNER JOIN " . TABLE_PREFIX . "thread AS thread ON(post.threadid = thread.threadid)                

                WHERE goodrank > 0

                ORDER BY goodrank DESC

                LIMIT 0,$helpans_limit

        ");

Ted S

02-04-2009 06:30 PM

Quote:

Originally Posted by redlabour (Post 1733922)

Is there a Option to exclude Users with less then X Postings from Voting?

Any why did you not use the Hooks at Postbit and Postbit Legacy?

There is not any such option although it's a great idea and something I will include in my next release at the end of the week.

As for your hooks question, I prefer to give users flexibility in how they make the code show up and where but I may change this and auto include the bits down the road if the template change proves to be an issue.

Ted S

02-04-2009 06:32 PM

Quote:

Originally Posted by Mihalis (Post 1734079)

Thank you for your answer. I must say I feel uncomfortable with the use of phpMyAdmin. Why this mod is unable to create the appropriate tables?

It's possible there is an issue with your configured users mysql rights although a bug has been suggested and I am issuing a new release which you may want to try.

Ted S

02-04-2009 06:34 PM

Quote:

Originally Posted by WoodiE (Post 1734050)

Upgraded to the newest version, but how do I view the new Top 10 page?

Wonderful question... The page can be found at www.yoursite.com/helpfulanswer.php?do= topanswers

Ted S

02-04-2009 06:36 PM

Quote:

Originally Posted by Rene Kriest (Post 1734210)

So my suggestion then would be no modification to your existing great addon.

I am looking for a away to rate individual aspects of a product/picture/point of view etc. not the posting itself. Maybe sort of "poll in poll" feature with a star rating system.

Your systems let people rate other people's comments while I want a feature to let people rate their individual experience (feat. 1 = 3/5 stars; feat. 2 = 5/5) and share it with others.

Got it... You need a new addon.

I'd suggest you post to the free modification request forum to get the idea going as many coders like myself use it to find new and popular suggestions.

Ted S

02-04-2009 06:37 PM

Quote:

Originally Posted by tei727 (Post 1734183)

when i go to the helpfulanswers.php page i get this

It appears you have not selected a post. Please go back and try the link again.

If you feel you have reached this page in error, please contact us for assistance.

Loading the page directly will not work yet, in 1.3.3 this will be changed to show the top answers page.

Ted S

02-04-2009 06:40 PM

mad@Max,

Thank you for finding those issues. I will be issuing a release in a few minutes to address the problems.

Ted S

02-04-2009 06:52 PM

Note: Version 1.3.3 has been released which fixes several small issues related to creating the mySQL table for this addon and with two queries. With this update the current mysql query errors will go away and the table will be properly created.

All users are advised to upgrade while those who have experienced database errors should uninstall and then upgrade.

To upgrade simply upload the new version of helpfulanswer.php and install the new plugin file.

Ted S

02-04-2009 07:06 PM

Quote:

Originally Posted by Mihalis (Post 1734079)

Thank you for your answer. I must say I feel uncomfortable with the use of phpMyAdmin. Why this mod is unable to create the appropriate tables?

To clarify on my earlier comment, this was a result of a bug in the script. If you download the latest version (1.3.3) and install it the table should be created. You may need to uninstall the addon before trying to reinstall.

mad@Max

02-04-2009 07:50 PM

One more suggestion:)
Replace in template helpful_answers_top_bit

HTML Code:

Post $helpfulanswer[postid] in thread:

with like this

HTML Code:

<phrase 1="$helpfulanswer[postid]">$vbphrase[helpfulanswer_top]</phrase>

and add same phrase, as I did for myself:)
And one more. Please add flowing in plugin Helpful Answers -- Cache Template

PHP Code:


		
			
                if (THIS_SCRIPT == 'helpfulanswer'){
                    $globaltemplates = array_merge($globaltemplates, array(
                        'helpful_answers_top',
                        'helpful_answers_top_bit'
                    ));                    
                }

All times are GMT. The time now is 04:50 PM.

Page 4 of 181

« First

104

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02221 seconds Memory Usage 1,760KB 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 (3)bbcode_code_printable (2)bbcode_html_printable (2)bbcode_php_printable (6)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: