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

CREATE TABLE helpfulpost (

`postid` INT(10) NOT NULL DEFAULT '0',

`threadid` INT(10) NULL,

`goodrank` INT(7) UNSIGNED NOT NULL DEFAULT '0',

`totalrank` INT(7) UNSIGNED NOT NULL DEFAULT '0',

`lastvote` INT UNSIGNED NOT NULL DEFAULT '0',

`userid` INT(7) unsigned NULL,

KEY `postid` (`postid`),

KEY `goodrank` (`goodrank`),

KEY `totalrank` (`totalrank`)

);

This worked finally.

relaxiha

07-27-2009 01:44 AM

Code:

Database error in vBulletin 3.8.3:



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 user.userid = '1'  AND helpfulanswer.postid =  

                         AND helpfulanswer.dateline >= 1245984180 AND helpfulanswer.dateline <= 1248662580

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

Error Number  : 1064

Request Date  : Monday, July 27th 2009 @ 02:43:49 AM

Error Date    : Monday, July 27th 2009 @ 02:43:49 AM

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

Referrer      : http://*******.com/forums/admincp/helpfulanswers.php

IP Address    : 87.236.197.182

Username      : Commando

Classname     : *****_Database

MySQL Version : 5.0.81-community

Ted S

07-27-2009 03:37 AM

Thanks, this should be resolved in the next update.

SİMAR

07-27-2009 07:26 AM

Thanks

Saviour

07-27-2009 12:54 PM

Just updated to latest release...WOL is not working for helpfulanswers.php page.

Get the following:

Code:

Unknown Location

/forums/helpfulanswers.php

Running 1.9.2 beta of your mod on a 3.8.3 board.

tpearl5

07-27-2009 09:21 PM

Ted, I found an interesting bug. If a post is rated most helpful, but then the post is removed (not physically removed) the most helpful post link will still exist. Here's an example: http://cellphoneforums.net/rogers/t2...yericsson.html

(in my case it keeps reloading the page because of vbseo)

Also, I don't know if there's another way to link to the most helpful post other then using showpost.php. I completely turned off showpost and vbseo is redirecting. I tired changing the link to the #post1234 format, but this doesn't work if the most helpful post is on another page from the page you're on.

Ted S

07-28-2009 12:34 AM

That's an interesting issue. Fixing the top posts page is simple but the bigger question is how or when to delete the votes. If it on soft delete they would be lost for a restored post. On hard delete and they'd sit around for invisible posts.

Thoughts?

rmd708

07-28-2009 03:38 PM

Is it possible to include this for each user in the postbit, like the total posts, registration date, total helpful answers?

I tried searching but I couldn't find if this was resolved.

tpearl5

07-28-2009 09:21 PM

Quote:

Originally Posted by Ted S (Post 1856838)

This is a rare case, so I would think they should be deleted when the post is soft deleted - or add a conditional to the query that gets the most helpful post to say 'if not soft deleted'.

Quote:

Originally Posted by rmd708 (Post 1857213)

Is it possible to include this for each user in the postbit, like the total posts, registration date, total helpful answers?

I tried searching but I couldn't find if this was resolved.

https://vborg.vbsupport.ru/showthrea...16#post1800216

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

Page 95 of 181

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02767 seconds Memory Usage 1,752KB 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 (3)bbcode_code_printable (3)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: