How can I record member's specific vote in a Poll?

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/61682?pagenum=1
05 November 2025, 09:07

Topic


cspelts
How can I record member's specific vote in a Poll?
22 April 2006, 06:47


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!<

 

Replies ...


cspelts
26 April 2006, 18:25


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!<
cspelts
03 May 2006, 20:21


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
04 May 2006, 23:05


I suppose you can always just ask them to vote publicly.<
cspelts
12 May 2006, 01:29


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? <
weeweeslap
12 May 2006, 02:25


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 smile search for his sn on the member list here and e-mail him through there<
cspelts
09 June 2006, 07:25


Thanks weeweeslap - I'll try contacting him!<
© 2000-2021 Snitz™ Communications