I have a [url removed, login to view] /mysql website that stores registered users, adverts plus ratings and comments for adverts. The ratings figure is an average, updated each time a rating is left by a user. i.e. no ratings are stored, only the current average and the total number of votes(ratings)
I need a totally separate "ebay type" rating script writing. This will only allow ratings to be left by registered users and will store ALL ratings(pos,neutrl,Neg), along with a date, user id an advert id and a comment (100char max) in the most efficient space saving manner, i.e. in a totally separate array or database if necessary. An anti-spam facility is needed when posting ratings and/or comments e.g. image entrybox etc.
At the time a rating is left, the script will need to delete all individual ratings for that advert older than 6 months but will store a record of the total pos, neg and neutral ratings deleted to date, i.e. since the advert was originally placed. Comments older than six months will be deleted
At the time a rating is left the script will also need to check for, and stop, more than two ratings being left by the same user id for the same advert during the past six months.
The script will then need to store and display all remaining comments plus the current totals of pos neg and neutral ratings received during the past month, three months, six months and total received since advert placed. i.e. a total of 12 variables. I also need an extra variable for the total AVERAGE number of positive ratings since the advert was placed.
Separate scripts then need to be written to display the comments in date order, for each advert, and to list all comments left by each user. during the past six months. I will consider all reasonable bids that can complete in the shortest time possible Payment will only to be released from Escrow if and when all requirements are met. So please do not bid unless you can complete. Any further queries please ask.
I have decided not to include ratings received during the past month as mentioned above. Consequently only nine vriables are required i.e. total positive, neutral and negative ratings received during the past 3 months, six months, and totals received since advert placed.