[vbboarder]

Originally Posted by jl255

ok my db got quite screwed up at the end of the week when my 1st nominations close. tried fixing the db but need some urgent help:

1. what happens to posts that have been nominated in previous week but didn't win? what shld their db entries be for the following fields under vb_post:
nominate_topic_amount , nominate_topic_award & nominate_topic_award_rank

2. what happened at the end of the week, all these 3 fields above were set to 0 for all nominated posts. As a result, when members try to search for nominated posts of a member, it returns a nil result. Is that supposed to be the way? I would think that it shld list all past posts that have been nominated and not just the current week's nomination right?

3. does it cater for poll results with equal number of votes? What happens then?

Really hope to get some support, even if you cannot solve it, hope you can at least help to clarify the structure so I can try to fix it myself. Tks!!!

Here's the answers to your Q's:

1. For non-awarded posts, nominate_topic_amount , nominate_topic_award & nominate_topic_award_rank should all be 0.
For awarded posts, those values vary with when & what award they got.

2. It only shows nominated posts for the current contest or that have past awards. It does not show past nominations that did not win.

3. It will award a maximum of 3 awards per contest period - this is can not be changed, it's hard-coded. Less than 3 awards are given if there's < 3 posts nominated.