vb.org Archive

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)

vbuser99 05-15-2009 06:12 PM

Quote:

Originally Posted by Ted S (Post 1810946)
There is not. However you could use a simple conditional to do this manually.

Yep, you are right. it is working great.

Strike3ForumsMH 05-16-2009 04:40 PM

Ted, this is probably a conflict on my forum but I was wondering if you could help. I can give positive reputation fine but negative reputation results in a db error:

Code:

Database error in vBulletin 3.8.2:

Invalid SQL:



                                                INSERT IGNORE INTO reputation (postid, reputation, userid, whoadded, reason, dateline)

                                                VALUES (159963, -111, 307, 4, 'They totally didn't like this.' ,'1242494793');

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't like this.' ,'1242494793')' at line 2
Error Number  : 1064
Request Date  : Saturday, May 16th 2009 @ 01:26:33 PM
Error Date    : Saturday, May 16th 2009 @ 01:26:33 PM
Script        : /forums/helpfulanswers.php

Any ideas?

Also, another suggestion: allow users to change their vote on the postbit, in case they clicked the wrong button or misunderstood the post.

Strike3ForumsMH 05-16-2009 05:15 PM

Ok, I played around to the point that I don't know what solved it. BUT, I installed the new version of Display Unread Posts and Reputation Comments by Paul M and the error did go away. However, for me anyway, negative reputation given by myself is not showing up under that mod but positive reputation is. Obviously not a big deal and you can't ensure compatibility with all mods, but in case there is anything to that (that it isn't just a problem for me), I wanted to let you know Ted.

Raptor 05-16-2009 05:49 PM

1 Attachment(s)
I made some nicer thumbs (you will need to change the helpful_answers_roll template to:

Code:

               
                        <if condition="$show['helpfulanswer']">               
                        <div id="helpfulanswers_box_$post[postid]">               
                                <br /><hr size="1" style="color:$stylevar[tborder_bgcolor]" />                                       
                                <if condition="$vboptions[helpans_neg]">
                                                       
                                        <if condition="$post['totalrank']">
                                                <phrase 1="$post[goodrank]" 2="$post[totalrank]">$vbphrase[helpfulanswer_x_out_of_y]</phrase>
                                        </if>
                               
                                        <if condition="$show['rate_helpfulanswer']">
                                       
                                                <strong>$vbphrase[helpfulanswer_didyoufind]</strong>
                                                <a href="./helpfulanswers.php?do=rate&postid=$post[postid]&rank=1" <if condition="$vboptions[disable_ajax] != 2"> onclick="return helpfulanswers_rate($post[postid], 1);" </if> rel="nofollow" onmouseover="document.post_$post[postid]_up.src='images/buttons/ha_thumbsup.gif';" onmouseout="document.post_$post[postid]_up.src='images/buttons/ha_thumbsup_gray.gif';"><img name="post_$post[postid]_up" src="images/buttons/ha_thumbsup_gray.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_yes]" /></a> |
                                                <a href="./helpfulanswers.php?do=rate&postid=$post[postid]&rank=0" <if condition="$vboptions[disable_ajax] != 2"> onclick="return helpfulanswers_rate($post[postid], 0);" </if> rel="nofollow" onmouseover="document.post_$post[postid]_dn.src='images/buttons/ha_thumbsdn.gif';" onmouseout="document.post_$post[postid]_dn.src='images/buttons/ha_thumbsdn_gray.gif';"><img name="post_$post[postid]_dn" src="images/buttons/ha_thumbsdn_gray.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_no]" /></a>
                                       
                                        <else />
                                                <if condition="$post[helpfulanswerid] AND !$show[guest]">
                                               
                                                <if condition="$post[yesno]">
                                                        <img src="images/buttons/ha_thumbsup.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_yes]" />
                                                        <img src="images/buttons/ha_thumbsdn_gray.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_no]" />
                                                <else />
                                                        <img src="images/buttons/ha_thumbsup_gray.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_yes]" />
                                                        <img src="images/buttons/ha_thumbsdn.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_no]" />
                                                </if>
                                       
                                        </if>
                                        </if>
                                       
                                        <if condition="$show['guest'] AND $vboptions['helpans_guestshow']">
                                                <strong>$vbphrase[helpfulanswer_didyoufind]</strong>
                                                <a href="./helpfulanswers.php?do=guestrate" rel="nofollow">$helpfulanswer_yes</a> |
                                                <a href="./helpfulanswers.php?do=guestrate" rel="nofollow">$helpfulanswer_no</a>
                                        </if>
                                       
                                <else />
                               
                                        <if condition="$post['totalrank']">
                                                <phrase 1="$post[goodrank]">$vbphrase[helpfulanswer_x_found]</phrase>
                                        </if>
                               
                                        <if condition="$show['rate_helpfulanswer']">
                                                <strong>$vbphrase[helpfulanswer_didyoufind] <a href="./helpfulanswers.php?do=rate&postid=$post[postid]&rank=1">$vbphrase[helpfulanswer_yesidid]</a></strong>
                                        </if>
                                       
                                </if>
                               
                        </div>                       
                        </if>


Raptor 05-16-2009 05:50 PM

I need the option to vote to only show on the first post - how do I do that ?

Ted S 05-16-2009 11:39 PM

Quote:

Originally Posted by Raptor (Post 1811995)
I need the option to vote to only show on the first post - how do I do that ?

Use a template conditional for firstpostid and the current postid.

Ted S 05-16-2009 11:40 PM

Quote:

Originally Posted by Strike3ForumsMH (Post 1811957)
Ted, this is probably a conflict on my forum but I was wondering if you could help. I can give positive reputation fine but negative reputation results in a db error:

You modified the phrase to include a single quote (don't). Try adding a \ before the '.

Quote:

Also, another suggestion: allow users to change their vote on the postbit, in case they clicked the wrong button or misunderstood the post.
Thanks for the idea.

Ted S 05-16-2009 11:40 PM

Quote:

Originally Posted by Raptor (Post 1811994)
I made some nicer thumbs (you will need to change the helpful_answers_roll template to:

Thanks for providing these. As an alternative to template changes they can simply be renamed to match the existing thumb icons.

Ted S 05-16-2009 11:41 PM

Quote:

Originally Posted by Strike3ForumsMH (Post 1811976)
Ok, I played around to the point that I don't know what solved it. BUT, I installed the new version of Display Unread Posts and Reputation Comments by Paul M and the error did go away. However, for me anyway, negative reputation given by myself is not showing up under that mod but positive reputation is. Obviously not a big deal and you can't ensure compatibility with all mods, but in case there is anything to that (that it isn't just a problem for me), I wanted to let you know Ted.

Thanks. I don't have experience with those addons but will take a look.

Raptor 05-17-2009 02:18 PM

Quote:

Originally Posted by Ted S (Post 1812152)
Use a template conditional for firstpostid and the current postid.

could you please let me know what that conditional code is exactley? thanks


All times are GMT. The time now is 08:59 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.02492 seconds
  • Memory Usage 1,773KB
  • 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
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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