The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
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!<
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!<
Posted
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!<
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!<
Posted
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?<
Anybody?<
Posted
I suppose you can always just ask them to vote publicly.<
Posted
Originally posted by TonyB7I may be missing something, but can you explain what you mean?
I suppose you can always just ask them to vote publicly.
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? <
Posted
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<
search for his sn on the member list here and e-mail him through there<