Ratings system

This is really just a post to scope out how do-able this might be using DA, even with a bit of custom paid support.

The background is a site which features holiday properties, and we are at the point where we would like to add a ratings system allowing people to vote.

There is currently a back end database built for this.

So we are thinking about moving the site to WordPress and using an off the shelf ratings system. Pros - might be more painless, Con - not sure about how to tie it in to the existing database.

Or adding the functionality into the existing database.

In which case I'd be really grateful for any pointers as to how difficult / complicated it might get.

Off the top of my head, I'm thinking along the lines of....

We already have a table - Lodges. So in theory this just needs three new fields, 'Number_of_Votes', 'Average Score' and 'Total Score'.


The bit I'd be less sure about would be how to calculate the average score and total score, and get those values into the 'Average Score' and 'Total Score' fields.

Hopefully that makes sense, and might not actually be too complicated.

Thanks.