I need a php MySql programmer to create a report that analyzes tables in an XMB message board (version 1.8) I am running on my web site. [url removed, login to view] I have one custom “hack” installed on this message board which enables individual post ratings. These ratings are stored in a new table called “xmb_ratings.” Users also label posts as either a “solution” or as a “comment”. The “solution” or “comment” field is located in the post table (xmb_post). I need a script that will display a report page that shows a study of post ratings in a variety of different ways. It will basically extract data from the two tables mentioned (xmb_ratings and xmb_posts). Individual posts are identified by 3 fields fid,tid,pid (i believe that stands for forum id, thread id, and post id). These three fields combine to be a unique identifier for each post-and they are contained in both tables. I believe these fields are also used to create the unique url to refer to each post in the message board. Basically, the report I want needs to list posts in order of their average rating, but with each of the following possible variations: It needs to be able to produce this report for an entire Forum or for only a specific thread. It also needs to be able to produce this report for only posts by a specific author. It needs to be able to do both of the above for all posts, “only solutions” and “only comments”. Finally, I would like to be able to be able to filter the report to only list posts with at least “X” number of user ratings. For example I might want to say only list posts that have been rated by at least 3 people. The interface to this report might look like this: What forum or thread would you like to run this report for? What authors shall be included? All or a specific. Shall this be for Comments or solutions? Only show posts with at least how many ratings: How would you like the list sorted? By # of ratings or by average rating? The report picture might look like this for headers: Forum-Thread-Post Title-Comment or Solution-Average Rating-# of Ratings (followed by the list of posts. I would like the posts to be clickable hyperlinks directly to the actual post/thread) Sorting I would really like to be able to just click on any of the headers and have the report sort by that header. One last caveat: I would like the report to use the first line of the post as the “title” for the post. (Unless the post actually has a title.) Usually only the Opening post has a title and all that follow are just body statements. But I would like the report to list the first 15 words of the post (or 50 characters or whatever) as the title for the report list. I would like you to copy my forum to your server, test and install this new hack on your server, and demo it to me before delivery. Payment Method I can pay via paypal or escrow. Please state in your bid whether you have ever worked with an XMB message board or other type of message board before. Thank you :) Ok. That is it. I now have the money set aside for this project and once bidding is done, I will be ready to proceed. This project replaces the previous project I created called XMB post rating statistics. This project more accurately describes what I need.