Show Thread Enhancements - Answer Forums 1.0.0

Brought To You By
ModernvB - Vbulletin Solutions & Services
http://www.modernvb.com

Premium Modification:
http://www.modernvb.com/vb_products....o&productid=10

Answers Forum
Ever wanted to enable the ability to specify a certain forum as an "answer" forum, where members can post questions and select the best answer given by the community? This is similar to yahoo answers, a very effective website where users can post questions and seek answers from registered users. Answering questions can get to be a mess, keep it organized and save yourself a bit of hassle when dealing with Q&A's. As a webmaster, you already have enough on your hands to have to worry about answering questions sometimes, and need an effective way to do this! Or maybe, you just want to let your community do it for you


Difference Between Answer Forum Light & Answer Forums Premium

* Enable a questions forum Lite/Premium
* Allow users to choose best answer Lite/Premium
* Question Statistics on forumdisplay Premium Only
* Top Helpers on forumdisplay Premium Only
* Recently Answered on forumdisplay Premium Only
* View Answered Topics Premium Only
* View Unanswered Topics Premium Only
* Answered Topics in postbit Premium Only
* Private Message user who's answer was chosen Premium Only
* Private Message answer provider if the answer is reset Premium Only
* Control user's ability to reset their own topic's answer Premium Only
* Allow usergroups to reset any topic's answer Premium Only
* Allow usergroups to select any topic's answer Premium Only *new
* Integrates with vbplaza (reward answer providers) Lite/Premium
* Integrates with vbcredits (reward answer providers) Premium Only

[Gio~Logist]

Updated the zip
- Vbplaza integration is now added.
- Zip was also updated with the fix to only show the "mark as answer" modification to administrators and thread starters.

[Greek76]

Updating now! Thanks Gio by the way this is a great mod exactly what I needed.

[ShiZoPhreN]

Originally Posted by gio~logist

That's a possibility. So closing a thread marks the last post as the answer?

i think first post is better, last post hmm it think any mods write "Closed" or something..

Originally Posted by gio~logist

Updated the zip
- Vbplaza integration is now added.
- Zip was also updated with the fix to only show the "mark as answer" modification to administrators and thread starters.

Thanks Dude, but only vBPlaza integration? No vbCredits?

[reddyink]

Functionality needed:

1) When a user has a question, they should be able to select how many points they are willing to award for the answer.

2) Thoose points should be deducted from the user asking the question and awarded to best answer user.

3) Allow the users to rate replies. Looks like there is already a mod out there Ajax rating for replies as shown in this image.

4) points system adjust the points based on rating on repliesXnumber of ratings.

Willing to pay for custom modification.

[haothiencz]

Still waiting when it come with vbcredits intergation

[rainyleaves]

Thanks for your Mod.

I get this error for Reset Best Answer with V1.0.1.
How do I fix?

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT user.userid
FROM ***_post AS post
LEFT JOIN ***_user AS user ON (user.userid = post.userid)
WHERE post.postid =
LIMIT 1;

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 'LIMIT 1' at line 5
Error Number : 1064
Request Date : Saturday, September 20th 2008 @ 11:59:13 PM
Error Date : Saturday, September 20th 2008 @ 11:59:13 PM
Script : http://***/forums/misc.php?do=g_answ...r_thread=35061
Referrer : http://***/forums/showthread.php?t=35061
IP Address : ***.***.***.***
Username : ***
Classname : vB_Database
MySQL Version : 5.0.41

[Pirat3]

VBPlaza? LOL your forum is gonna get hacked...

Great mod, maybe have a PM reminder for user to mark best answer for their thread after X days?

[peppercola]

What if we wanted to do this for a game thread - can you undo a best answer say...

we have a wheel of fortune type game on our forum where we guess letters and to solve the puzzle (we all know how wheel of fortune works) anyways we just keep updating the same thread every time we change the phrase - we would be able to delete the best answer and mark and new one for each phrase or would we have to start a whole new thread

[inciarco]

Database Error when Choosing Reset Answer, (Great that you added that necessary functionallity but something is not working fine with it):

This is the Followed Link:

http://zzz/misc.php?do=g_answer_forum_reset&answer_thread=63

I Replaced Private Info for zzz.

This is the Database Error message I received:

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT user.userid 
                                                FROM post AS post 
                                                LEFT JOIN user AS user ON (user.userid = post.userid)
                                                WHERE post.postid = 
                                                LIMIT 1;

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 'LIMIT 1' at line 5
Error Number  : 1064
Request Date  : Saturday, September 20th 2008 @ 11:37:41 AM
Error Date    : Saturday, September 20th 2008 @ 11:37:41 AM
Script        : http://zzz/misc.php?do=g_answer_forum_reset&answer_thread=63
Referrer      : http://zzz/showthread.php?t=63
IP Address    : zzz
Username      : zzz
Classname     : vb_database
MySQL Version : 4.1.20-max-log

[FiMeTi]

Originally Posted by gio~logist

Updated the zip
- Zip was also updated with the fix to only show the "mark as answer" modification to administrators and thread starters.

Can you please tell us, how to manually change this feature?
Because I can?t just use again the install file, since I made the hack fit to my
conception and changed a few things.

Best regards
FiMeTi