[ANSWERED] WHO voted for which POLL option?

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
User avatar
RiTz21
Registered User
Posts: 208
Joined: Tue May 31, 2005 5:20 pm

[ANSWERED] WHO voted for which POLL option?

Post 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
Last edited by RiTz21 on Tue Nov 27, 2018 12:49 am, edited 3 times in total.
User avatar
warmweer
Jr. Extension Validator
Posts: 5828
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: WHO voted for which POLL option?

Post 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. ;)
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
User avatar
janus_zonstraal
Registered User
Posts: 4894
Joined: Sat Aug 30, 2014 1:30 pm

Re: WHO voted for which POLL option?

Post by janus_zonstraal »

Use this extension, works great:
viewtopic.php?t=2460191
Sorry! My English is bat ;) !!!
User avatar
RiTz21
Registered User
Posts: 208
Joined: Tue May 31, 2005 5:20 pm

Re: WHO voted for which POLL option?

Post 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
Image
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52169
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: WHO voted for which POLL option?

Post by Brf »

Try the users table.
User avatar
RiTz21
Registered User
Posts: 208
Joined: Tue May 31, 2005 5:20 pm

Re: WHO voted for which POLL option?

Post 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
Image
User avatar
3Di
Former Team Member
Posts: 16052
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano 🇮🇹 - Frankfurt 🇩🇪
Name: Marco
Contact:

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

Post 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 341 times
To request support for our extensions you can also contact me here: phpBB Studio

Please PM me only to request paid works. Thx. Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
🚀 Looking for a specific feature or alternative option? We will rock you! 🚀
Post Reply

Return to “[3.2.x] Support Forum”