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)

Saviour 08-29-2009 07:06 PM

Apparently, the links on the helpfulanswers.php pages for that particular topic...link to the same post.

Page 1 link: http://glitchpc.com/forums/showthrea...=2919#post2919

Page 2 link: http://glitchpc.com/forums/showthrea...=2919#post2919

Megatr0n 08-31-2009 05:34 PM

Quote:

Originally Posted by Ted S (Post 1876092)
This weekend.

Weekend has past. :P

Saviour 08-31-2009 06:43 PM

<a href="https://vborg.vbsupport.ru/showpost.php?p=1876515&postcount=1092" target="_blank">https://vborg.vbsupport.ru/showp...postcount=1092</a>

Anyone?

Ted S 08-31-2009 07:35 PM

Quote:

Originally Posted by Megatr0n (Post 1877286)
Weekend has past. :P

And I have completed this in 2.0.0 beta which I was not able to post last night. I will get it up this evening after doing a few more tests.

Ted S 08-31-2009 07:44 PM

Quote:

Originally Posted by Saviour (Post 1877315)

It's on the list for tonight...

Ted S 09-01-2009 01:26 AM

Hello Helpful Answers users. Today I am please to announce 2.0.0b which is a big number that includes a big feature long asked for (although the actual changes are rather small).

2.0 introduces user level stats on good votes, totalvotes and bad votes which you can put right into the postbit template using $post[hagoodrank] $post[hatotalrank] and $post[habadrank]

These stats combine a user's entire post history (votes on their posts) into simple numbers for your use.

Updating to 2.0 may take a few minutes as old votes are converted into the user profile. To reduce queries the user table is extended to offer both a good and total rank field.

2.0 requires uploading all .php files as well as updating the XML plugin and to use the new variables you will need to edit your postbit template as you see fit.

digicom 09-01-2009 01:51 AM

Thanks For Update Ted Aprrciated :up:

Ted S 09-01-2009 02:04 AM

1 Attachment(s)
Quote:

Originally Posted by Ted S (Post 1876478)
The top answers page will show each post as a different item. Are you sure this is a duplication of posts or could it just be two posts in the same thread?

Please use this file which will print out the query on both pages and then revert to the stable version.

Let me know the queries and I should be able to figure out why this is happening on your site.

Chief Corn 09-01-2009 03:58 AM

Quote:

Originally Posted by Ted S (Post 1876475)
For your next step please try the attached helpfulanswers.php file which will tell you if a new record is being created or if there is an update. If there are already votes on a post you should ONLY get an update.

It's showing as updated. I also upgraded to the latest 2.0 and it still double posts. Don't worry about it though, it works as long as I don't clear votes, it's most likely a conflict with another mod.

Saviour 09-01-2009 10:04 AM

Quote:

Originally Posted by Ted S (Post 1877548)
Please use this file which will print out the query on both pages and then revert to the stable version.

Let me know the queries and I should be able to figure out why this is happening on your site.


Uploaded that file...overwriting the current file. Using 1.9.5 of your mod and got the following error on the first page:

Code:

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 vb_helpfulpost as helpfulpost
INNER JOIN vb_post AS post ON(helpfulpost.postid = post.postid)
INNER JOIN vb_thread AS thread ON(post.threadid = thread.threadid)
INNER JOIN vb_forum AS forum ON(thread.forumid = forum.forumid)
WHERE goodrank > 0


ORDER BY avgrank desc
LIMIT 0, 10

This was printed on the second page:

Code:

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 vb_helpfulpost as helpfulpost
INNER JOIN vb_post AS post ON(helpfulpost.postid = post.postid)
INNER JOIN vb_thread AS thread ON(post.threadid = thread.threadid)
INNER JOIN vb_forum AS forum ON(thread.forumid = forum.forumid)
WHERE goodrank > 0


ORDER BY avgrank desc
LIMIT 10, 10

Reverting to my previous file...

Should I update to 2.0? Has it been fixed?


All times are GMT. The time now is 08:46 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.02767 seconds
  • Memory Usage 1,747KB
  • 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
  • (6)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