| Author |
 Topic  |
|
|
cspelts
Starting Member
9 Posts |
 Posted - 22 April 2006 : 06:47:41
|
I have the Poll Mod installed - it's great! I'm currently using Access, and am planning to upgrade to SQL later this month, but I was hoping to solve this first!
I'd like to add a field to the FORUM_POLL_VOTES table and record not only the MEMBER_ID, but also record the choice they voted for.
My members are going to be voting on the outcome of a performance TV show, so my thinking is that if I can record their votes, then after each episode airs I can give members who correctly predict the outcome a certain number of points, and over the course of the season keep a running total. I think I've got it all worked out in my head - if I can just get the specific vote recorded.
Any ideas? Thanks for your help!< |
|
|
cspelts
Starting Member
9 Posts |
Posted - 26 April 2006 : 18:25:55
|
Any ideas? I'm still working on this, and haven't been able to figure anything out.
This thread on the wishlist for Poll Mod version 3 shows that it would solve both issues I'm working on - recording a member's speciific vote AND allowing multiple votes, but it hasn't been released yet, so I'm hoping someone can give me a few ideas to pursue it on my own.
Thanks for your help!< |
Edited by - cspelts on 26 April 2006 18:26:13 |
 |
|
|
cspelts
Starting Member
9 Posts |
Posted - 03 May 2006 : 20:21:12
|
I've decided I don't really need to allow multiple votes afterall - so the only thing I need to complete this project is to find a way to record member's specific vote.
Anybody?< |
|
|
|
TonyB7
Junior Member
USA
267 Posts |
Posted - 04 May 2006 : 23:05:30
|
| I suppose you can always just ask them to vote publicly.< |
|
|
|
cspelts
Starting Member
9 Posts |
Posted - 12 May 2006 : 01:29:46
|
quote:
Originally posted by TonyB7
I suppose you can always just ask them to vote publicly.
I may be missing something, but can you explain what you mean?
If you're suggesting that members make a post and name their choice and I count them manually, that’s not a good solution in this case, since I'm expecting thousands of votes over a twenty-four hour period, and it'll happen weekly all summer. It really does need to be automated, and I don’t think it sounds that complicated.
I've added an extra field to the FORUM_POLL_VOTES table for the specific vote and I’ve written queries that tabulate the results and assign points based on the answer. The whole database portion is finished - the only part I'm having trouble with is the forum code - I want to be able to record the specific vote in the FORUM_POLL_VOTES table.
In other words, when UserName1 votes, I need to not only record his MEMBER_ID, but also that he voted for Singer3. It's just adding one field to the database - but I can't figure how to record the vote – any ideas?
< |
Edited by - cspelts on 12 May 2006 01:30:39 |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 12 May 2006 : 02:25:56
|
I suggest you e-mail a user by the name of Altisdesign as I know for a fact he has done such modifications to the current poll mod that will do what you want  search for his sn on the member list here and e-mail him through there< |
coaster crazy |
|
|
|
cspelts
Starting Member
9 Posts |
Posted - 09 June 2006 : 07:25:51
|
| Thanks weeweeslap - I'll try contacting him!< |
|
|
| |
Topic |
|
How can I record member's specific vote in a Poll?
