![]() |
Quote:
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. |
Quote:
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. |
Quote:
|
Quote:
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 |
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.
|
Quote:
I think theres an issue with the xml file... |
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 |
nevermind. found it. helpfulanswers.php was in the wrong dir. works now.
|
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 |
Quote:
|
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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|