SMF Support > SMF 2.0.x Support

Viewing Who voted in polls

(1/4) > >>

mattchewone:
Hi,

Is there a way to view who voted what in a poll?

Many Thanks

Matt

N3RVE:
Run this query in phpMyAdmin (What is phpMyAdmin?)


--- Code: (Run) ---SELECT smf_members.realName, smf_poll_choices.label
FROM smf_log_polls
INNER JOIN smf_members ON smf_log_polls.ID_MEMBER = smf_members.ID_MEMBER
INNER JOIN smf_poll_choices ON smf_log_polls.ID_CHOICE = smf_poll_choices.ID_CHOICE
AND smf_log_polls.ID_POLL = smf_poll_choices.ID_POLL
WHERE smf_log_polls.ID_POLL = 42

--- End code ---

Replace ID_POLL = 42 with the ID of the poll you want to check.

-[n3rve]

Nao 尚:
Or use the search engine ;)

Who voted what?

mattchewone:

--- Quote from: Nao 尚 on June 30, 2009, 12:47:14 PM ---Or use the search engine ;)

Who voted what?

--- End quote ---

not compatible with 2.0

Thanks

Nao 尚:
Hmm I'm using it on Noisen... Which runs the latest SMF2...
Of course if you don't feel like fixing the mod here and there, I can't help much.

Navigation

[0] Message Index

[#] Next page