Page 1 of 1

[ANSWERED] WHO voted for which POLL option?

Posted: Mon Nov 26, 2018 10:24 pm
by RiTz21
Hi!

I created a poll with multiple choices and I would like to know which user has chosen which option...
While I suspect this information is not readily available in the control panel, is there a way to check the Data base directly to get these details?

How could this be done? Which tables do I need to check? how can I do this?

THANKS for the help!!

RiTz21

Re: WHO voted for which POLL option?

Posted: Mon Nov 26, 2018 10:56 pm
by warmweer
RiTz21 wrote:
Mon Nov 26, 2018 10:24 pm
Hi!

I created a poll with multiple choices and I would like to know which user has chosen which option...
While I suspect this information is not readily available in the control panel, is there a way to check the Data base directly to get these details?

How could this be done? Which tables do I need to check? how can I do this?

THANKS for the help!!

RiTz21
There are 2 tables with names prefix_poll_ (_options and _votes). It might be a good starting point for a look-see to find out which info is available. ;)

Re: WHO voted for which POLL option?

Posted: Mon Nov 26, 2018 11:15 pm
by janus_zonstraal
Use this extension, works great:
viewtopic.php?t=2460191

Re: WHO voted for which POLL option?

Posted: Tue Nov 27, 2018 12:33 am
by RiTz21
warmweer wrote:
Mon Nov 26, 2018 10:56 pm
There are 2 tables with names prefix_poll_ (_options and _votes). It might be a good starting point for a look-see to find out which info is available. ;)
Sweet!! I extracted the user ids of the users who posted... So where do I see which ID goes with Whom?

Thanks!!
RiTz21

Re: WHO voted for which POLL option?

Posted: Tue Nov 27, 2018 12:47 am
by Brf
Try the users table.

Re: WHO voted for which POLL option?

Posted: Tue Nov 27, 2018 12:48 am
by RiTz21
Ah figured it out - I used a SQL query:

Code: Select all

SELECT username FROM phpbb_users WHERE user_id = 2 LIMIT 1 
For some unknown reasons, in my phpMyAdmin, the phpbb_users is not shown on the left (the last table shown is ranks).....perhaps it is a sub-table or some such!?
Noob me doesn't know :p

RiTz21

Re: [ANSWERED] WHO voted for which POLL option?

Posted: Tue Nov 27, 2018 1:11 am
by 3Di
RiTz21 wrote:
Tue Nov 27, 2018 12:48 am
For some unknown reasons, in my phpMyAdmin, the phpbb_users is not shown on the left (the last table shown is ranks).....perhaps it is a sub-table or some such!?
No it's just another tab for the same row.
phpmyadmin.png
phpmyadmin.png (5.35 KiB) Viewed 176 times