[ANSWERED] WHO voted for which POLL option?

[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

[warmweer]

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.

[janus_zonstraal]

Use this extension, works great:
viewtopic.php?t=2460191

[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.

Sweet!! I extracted the user ids of the users who posted... So where do I see which ID goes with Whom?

Thanks!!
RiTz21

[Brf]

Try the users table.

[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

[3Di]

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 (5.35 KiB) Viewed 171 times