vb.org Archive - Add-On Releases - [AJAX] Helpful Answers - Post Rating System (plus many sub-features)

Page 83 of 181

Show 40 post(s) from this thread on one page

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)

tpearl5

07-15-2009 10:16 PM

Quote:

Originally Posted by Quantnet.org (Post 1849452)

Interestingly enough, the Answer Forum mod is released today
https://vborg.vbsupport.ru/showthread.php?t=218653

This has been released for a while, the developer just made a 3.8 thread for it. Also, this style looks a lot more like how community server handles best answers but without the per thread "is this a question" option.

tpearl5

07-15-2009 10:19 PM

Quote:

Originally Posted by Ted S (Post 1849564)

Shouldn't be a problem.

Ok with entering a username and date range and getting a result?

If it was the same as the existing posts rated report, that would probably be more useful - that way you can see in a list who is on top for a given period of time. Could you make it so you can also see the post that is rated? (like in the other report)

Ted S

07-15-2009 10:20 PM

Let me look at the data structure a bit and see what I can do.

Ted S

07-16-2009 12:51 AM

Quote:

Originally Posted by cooltechie (Post 1849315)

Can I leave the mod running along with "thanks" mod and then run the import at a later time or does the import need to run immediately after the install? Hope to see a working import soon so I can get it combined. Thanks for creating this mod and for your support.

Yes you can. You could run them both forever... there's no damage.

Ted S

07-16-2009 02:19 AM

After more testing and some changes I have updated 1.9. This file remains in beta until additional sites start using it but at this time it is working in live environments without problem.

Overview of changes:
- Rating a post now adds a notification to the user whose post it is
- The top rated post can be automatically linked to after the first post
- Specific threads can be excluded or included via the admin

Installing will take a few minutes as all voting records are updated in the database.

NLP-er

07-16-2009 05:05 AM

Quote:

Originally Posted by Ted S (Post 1849434)

The feature list is a few page back... somewhere. :D

We're not a whole lot closer as no one has picked up the beta and commented on it which makes it difficult for me to release as a stable. I will be doing more of my own tests to try and move things along.

Just release it as not beta and you will have plenty of installs ;)
Microsoft never cares :D LOL

Noctavia

07-16-2009 05:28 AM

Quote:

Originally Posted by Ted S (Post 1847273)

Looks like I gave you bad guidance... You need to leave 2="$post[totalrank]"

Cool, thanks, got it working now. :up:

Another question. When I try to find all ratings given to a single thread, I get the following error:

Code:

Database error in vBulletin 3.8.2:



Invalid SQL:



                SELECT COUNT(helpfulanswerid) AS count

                FROM helpfulanswer AS helpfulanswer

                INNER JOIN user AS user ON(helpfulanswer.userid = user.userid)

                WHERE helpfulanswer.helpfulanswerid <> 0

                         AND helpfulanswer.postid =  

                         AND helpfulanswer.dateline >= 1245047100 AND helpfulanswer.dateline <= 1247725500

                GROUP BY helpfulanswer.userid;



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 'AND helpfulanswer.dateline >= 1245047100 AND helpfulanswer.dateline <= 124772550' at line 6

Error Number  : 1064

Request Date  : Thursday, July 16th 2009 @ 02:26:25 AM

Error Date    : Thursday, July 16th 2009 @ 02:26:25 AM

Script        : http://xxxxxx/forums/admincp/helpfulanswers.php?do=show_helpfulanswers

Referrer      : http://xxxxxxx/forums/admincp/helpfulanswers.php

IP Address    : xxxxxxxxx

Username      : xxxxxxx

Classname     : vB_Database

MySQL Version : 5.0.81-community

Any idea on how to fix that? I can use all the other reporting features fine. This only happens when I use the Post ID section.

Saviour

07-16-2009 12:51 PM

Ted S...

I really don't have a test forum, otherwise I'd volunteer to test the beta version. Sorry...

Until then, I'll just have to wait to update the mod until your latest release does become stable.

All my best...

Ted S

07-16-2009 02:24 PM

Quote:

Originally Posted by NLP-er (Post 1849707)

Just release it as not beta and you will have plenty of installs ;)
Microsoft never cares :D LOL

After another week of my sites using it I probably will. While MS does release betas as finals it's not worth the support headache for me to do so. :D

Ted S

07-16-2009 02:24 PM

Quote:

Originally Posted by Noctavia (Post 1849714)

Cool, thanks, got it working now. :up:

Another question. When I try to find all ratings given to a single thread, I get the following error:

Code:

Database error in vBulletin 3.8.2:

 

Invalid SQL:

 

        SELECT COUNT(helpfulanswerid) AS count

        FROM helpfulanswer AS helpfulanswer

        INNER JOIN user AS user ON(helpfulanswer.userid = user.userid)

        WHERE helpfulanswer.helpfulanswerid <> 0

             AND helpfulanswer.postid =  

             AND helpfulanswer.dateline >= 1245047100 AND helpfulanswer.dateline <= 1247725500

        GROUP BY helpfulanswer.userid;

 

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 'AND helpfulanswer.dateline >= 1245047100 AND helpfulanswer.dateline <= 124772550' at line 6

Error Number  : 1064

Request Date  : Thursday, July 16th 2009 @ 02:26:25 AM

Error Date    : Thursday, July 16th 2009 @ 02:26:25 AM

Script        : http://xxxxxx/forums/admincp/helpfulanswers.php?do=show_helpfulanswers

Referrer      : http://xxxxxxx/forums/admincp/helpfulanswers.php

IP Address    : xxxxxxxxx

Username      : xxxxxxx

Classname     : vB_Database

MySQL Version : 5.0.81-community

Any idea on how to fix that? I can use all the other reporting features fine. This only happens when I use the Post ID section.

Looks like a little bug. I will get a release out tonight with a fix.

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

Page 83 of 181

« First

133

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04376 seconds Memory Usage 1,757KB 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 (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
Messages: