Instructions sent to GJ for Hacks on Wisdom Project Forums
I have a couple more hacks I would like to hire you to do for my forum at http://www.thesearchforwisdom.com

Instructions to GJ

My message board is about problem solving. People will post problems and then people will respond with solutions. Of course people will also respond with comments and questions. I need to know which replies are genuine “solutions” and which replies are just comments.

Then using the ratings system you helped build, I will produce reports with the highest rated “solutions” to the problems.

Here is what I want you to do:

Part 1.
Below the body of the message in the post reply form, above the check box disable smiley’s, I want the following question in bold type:

“Does your post contain a solution to the problem stated in the opening post of this thread? (If you are simply making a comment or posing a question choose no.)” Yes or No
The answer should default to No.

I do not want people to see this question when they start a new thread. Whenever someone starts a thread I want this field to default to No.

This task will involve creating a new field in the XMB_Posts table I think. Please do not delete posts currently in the table. For all current posts simply enter No for this field.

Part 2
Please make sure that the edit a post routine enables administrators to change this field in case people mess up.

Part 3
Statistics
I need the ability to generate a new statistics page. It will calculate and display the top 10 most rated posts and the top 10 highest rated “solutions”. It will also display the top 10 highest rated “comments”. But I want this page to be able to be generated based upon posts only in a specific thread OR a specific forum.

I would like to be able to view this filtered statistics page for any forum or thread. Perhaps you could put a button on link next to the title of every forum and thread that says “View Report Card” or “View Filtered Stats”? If you have a better or easier idea let me know.

Ok. Let me know if all that makes sense and how much work it will take.

Matt

******
Once GJ makes this alteration, I can experiment with exporting the tables to Access and running reports. I need to determine the exact formula I want used to calculate post ratings, and user ratings. Then I need to describe to GJ the way I want a debate report to appear.

Next is the User Report Card.

Debate Report. A statistics page that can be run for an entire forum, subforum, or for a single thread.
Same type of data on statistics page but filtered for a section of the forum.

User Report Card. A statisitics report that can be run for a single user based upon all data, data from a single forum, or data from a single thread.