72428 Flexible PHP/MySQL Report

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.

Taidot: kaikki käy, PHP

Näytä lisää: what is sorting data, what is my paypal payment id, what is my paypal id, what is data sorting, use paypal as escrow, title web solutions, sorting method, sorted data set, rating statistics, programmer php mysql, php refer url, php programmer on line, php mysql create, order programmer php, opening of escrow, look php id, how to do a report, how can i run my new created web site, forum php programmer, escrow statements

Tietoa työnantajasta:
( 10 arvostelua ) Port Townsend, United States

Projektin tunnus: #1820246

Myönnetty käyttäjälle:


It's quite simple task for me. I created such reports script before and worked with XMB. Look in my reviews. Thanks, Vincento.

$40 USD 3 päivässä
(0 Arvostelua)