vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Add-On Releases - [AJAX] Helpful Answers - Allow users to rate individual posts (https://vborg.vbsupport.ru/showthread.php?t=233296)

Verionia 02-05-2010 01:40 PM

Quote:

Originally Posted by Ted S (Post 1974384)
Each user? No. The user who is viewing it, yes. Just enabe the 10 point voting scale and add your star images for values 1-5.

Sorry I am running a product review forum. Don't know if you could add some add ons like - only the user who made the post can rate the product with a post once from a scale of 1-5. An option for only the owner of the post to rate with stars. Thx!

Ted S 02-05-2010 03:49 PM

Quote:

Originally Posted by TimberFloorAu (Post 1975231)
Just checking error logs, we are getting hundreds of error messages:

Such as:
Code:

Database error in vBulletin 4.0.1:
 
Invalid SQL:
 
              SELECT post.postid,post.title as posttile,helpfulpost.goodrank,helpfulpost.totalrank,helpfulpost.lastvote,
                      thread.threadid,thread.title as title,thread.postusername as postusername,forum.title as ftitle ,goodrank as avgrank
 
              FROM yobromofhelpfulpost as helpfulpost
              INNER JOIN yobromofpost AS post ON(helpfulpost.postid = post.postid)
              INNER JOIN yobromofthread AS thread ON(post.threadid = thread.threadid)
              INNER JOIN yobromofforum AS forum ON(thread.forumid = forum.forumid)
              WHERE goodrank > 0
 
 
              ORDER BY avgrank desc
              LIMIT 0, 25;
 
MySQL Error  : Column 'goodrank' in field list is ambiguous
Error Number  : 1052
Request Date  : Friday, February 5th 2010 @ 10:04:32 AM
Error Date    : Friday, February 5th 2010 @ 10:04:32 AM
Script        : http://www.yobromofo.com/forum/helpfulanswers.php
Referrer      :
IP Address    : 67.195.112.247
Username      : Unregistered
Classname    : vB_Database
MySQL Version :


Disable this page, I will have this bug resolved this weekend.

Ted S 02-05-2010 03:50 PM

Quote:

Originally Posted by Verionia (Post 1975412)
Sorry I am running a product review forum. Don't know if you could add some add ons like - only the user who made the post can rate the product with a post once from a scale of 1-5. An option for only the owner of the post to rate with stars. Thx!

Sounds like you need a different modification or to extend this for your specific use...

TimberFloorAu 02-05-2010 05:52 PM

Cheers Ted

Ted S 02-06-2010 12:54 AM

Version 2.1.6 has been released which fixes an SQL query error for some users when viewing the most helpful answers page.

TimberFloorAu 02-06-2010 01:11 AM

Cheers TED will try now :yes: and report back

*installed.

All good at the Mo fingers crossed. No errors to report yet :)

Ted S 02-06-2010 02:49 AM

Quote:

Originally Posted by TimberFloorAu (Post 1975749)
Cheers TED will try now :yes: and report back

*installed.

All good at the Mo fingers crossed. No errors to report yet :)

No faith ;)

vivamexico55 02-06-2010 10:35 PM

I'm glad this modification is supported, I'm eagerly awaiting vbulletin 4.02 to install it and test it, keep up the good work =)


Quote:

Originally Posted by tafreeh (Post 1957884)
good hack...

Suggestion:
add a stats in each user info(where username, post counts shows) in post bit or postbil legacy.. and i will replace this with other Thank you hack :)

Cheers

This might be interesting, yes.

TimberFloorAu 02-06-2010 10:56 PM

1 Attachment(s)
Quote:

Originally Posted by Ted S (Post 1975796)
No faith ;)

Mate when a coder, like yourself sorts stuff out, faith plays a big part in our trust.

Yet again , great fix. No issues at all. Love it.

Now question for you please.

Is it at all possible to embed a background Image, and sit the Yes/no images on top ?

Similar to this ... ( Just made this graphic so apologies for quality )

TimberFloorAu 02-06-2010 11:02 PM

Also daft question.

Is there a reverse system.

For example.

Thread starter posts really useful stuff. So the Helpful answer system appears just on the very first post, and then viewers can click helpful yes or no, but the graphic does not appear on subsequent replies.

Ste


All times are GMT. The time now is 11:55 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01493 seconds
  • Memory Usage 1,745KB
  • 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
  • (1)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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