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 02-18-2009 09:54 PM

Quote:

Originally Posted by Ted S (Post 1748470)
The variable $post[totalrank] should have your total ranks if you're using just positive rankings. If it's only showing one double check that there's a higher value in the actual table (you can do this through phpmyadmin or with the query:" select totalrank from post where postid = X; ").

No, its not working that way. It is only showing that post's totalrank. I need user's total rank info.

I guess I couldn't describe what I actually want to do.
I would like to display user's helpful answers statistics in postbit like his reputation or age info.
I would like to have his how may total helpful answers he got in the whole forum, not just on that thread or just on that post.
By having helpful answers stats in postbit, I believe this will encourage users to post more helpful posts.

Ted S 02-18-2009 09:58 PM

Quote:

Originally Posted by vbuser99 (Post 1748491)
No, its not working that way. It is only showing that post's totalrank. I need user's total rank info.

I guess I couldn't describe what I actually want to do.
I would like to display user's helpful answers statistics in postbit like his reputation or age info.
I would like to have his how may total helpful answers he got in the whole forum, not just on that thread or just on that post.
By having helpful answers stats in postbit, I believe this will encourage users to post more helpful posts.

Got it. And you're right, there is no variable for that.

Right now that data is not computed in aggregate for a user which means to pull it up for each post you would need another query (10 posts per page means 10 queries). It is of course possible to keep a tally for the user which would avoid the query it just isn't something people have asked for previously.

Ted S 02-18-2009 09:58 PM

Quote:

Originally Posted by maidos (Post 1748486)
well just have the same feature as digg. yoour mod has functionality that is similar with digg. But yeah some members prefer pictures over texts so i was wondering if you could implement a positive and negative icons instead? let user to see example the votes like +6 diggs +6 / -0

I think pictures are great and much more compelling than words but am not a graphic artist. If someone would like to contribute an icon set for public use I'll make it work.

vbuser99 02-18-2009 10:08 PM

Quote:

Originally Posted by Ted S (Post 1748499)
Got it. And you're right, there is no variable for that.

Right now that data is not computed in aggregate for a user which means to pull it up for each post you would need another query (10 posts per page means 10 queries). It is of course possible to keep a tally for the user which would avoid the query it just isn't something people have asked for previously.

I figured so, actually it may be a little bit costy too with current mod design, as you are not updating that info in a field in user table (that would be afficient).

I needed this info:

SELECT b.userid, count( * )
FROM `helpfulanswer` a, post b
WHERE yesno >0 and a.postid = b.postid
GROUP BY b.userid
HAVING count( * ) >0

OR with usernames

SELECT c.username, count( * )
FROM `helpfulanswer` a, post b, user c
WHERE yesno >0 and a.postid = b.postid and b.userid=c.userid
GROUP BY b.userid
HAVING count( * ) >0

Ted S 02-18-2009 10:33 PM

I'd suggest just adding a little hook to update the counts to the user's profile as threads get rated. There's already plugins included in the script so you don't have to worry about future upgrading... helpfulanswers_dorate would be a good place to start with.

lazyseller 02-18-2009 11:06 PM

Quote:

Originally Posted by Ted S (Post 1748463)
That's not something covered but a great idea...

Try this version of the addon which offers this as an option.

Thanks for the update

I think theres an issue with the xml file...

gmerin 02-19-2009 12:03 AM

I get "XML Error: Empty document at Line 1" when I try to import the newest product file

you have an extra gravetick at the beginning of line 1

imports ok if you remove the gravetick

gmerin 02-19-2009 12:08 AM

nevermind. found it. helpfulanswers.php was in the wrong dir. works now.

maidos 02-19-2009 12:21 AM

cool, but dont have photoshop but i do like the picture from a mod, has the same feature as digg but the mod is declared dead

https://vborg.vbsupport.ru/showthrea...light=postrate

maybe you could use those thumbs icons

Ted S 02-19-2009 12:59 AM

Quote:

Originally Posted by maidos (Post 1748602)
cool, but dont have photoshop but i do like the picture from a mod, has the same feature as digg but the mod is declared dead

https://vborg.vbsupport.ru/showthrea...light=postrate

maybe you could use those thumbs icons

Unfortunately I can't use icons unless the author specifically grants me the right to distribute them.


All times are GMT. The time now is 10:02 PM.

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.02187 seconds
  • Memory Usage 1,746KB
  • 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
  • (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