XF 1.2 Poll Results for Admins...

[LuvMeSumZen]

I'm running a poll that I have set for no public view of the results, but I cannot see the results either and need to do so. I checked my perms as admin and they all look correct, is this is feature of xf that if the poll is set as non-public admins cannot see the results either? If so I need a work around or something.

 

[Paul B]

The public setting applies to all users.

 

[LuvMeSumZen]

That's quite inconvenient to put it mildly. A poll is often used as a tool and this is the case in this instance. This is a poll where a member is trying to anonymously give away a very expensive piece of equipment, and we're using the poll to narrow down the parameters of who qualifies according to the donor's criteria. The members don't know there's a tool worth hundreds of dollars to be given away but will once the poll is over so they cannot be allowed to see who answered which question and how, but it's imperative that I be able to see the votes.

I cannot even see that there's an edit function to select public view just long enough for me to see the votes - is this also the case?

 

[Paul B]

It requires editing a field in the database.

 

[LuvMeSumZen]

Does that mean you will tell me how if I ask pretty please?

 

[Paul B]

You need to look up the entry in the xf_poll table and set public_votes to 1.

 

[LuvMeSumZen]

Ok thanks. Does that mean that the 1 is me (user #1) and I will only be able to see them?

 

[Paul B]

No, the 1 means the votes are public and everyone can see them.

 

[LuvMeSumZen]

Can't have that, as already said. But I guess you me so that I can see it and then remove the 1. I suppose I will move the thread to the admin section, look, undo, move back. It'll work for now but I guess I need to request an addon for this for future. Thanks for the work around it will get me by for now.

 

[Paul B]

It wouldn't be difficult to write an add-on which would allow administrators and/or moderators see the selections for non-public polls.

I'm a bit busy right now but when I get a chance I'll knock something up quickly.

 

[LuvMeSumZen]

Awesome. Thanks!

 

[LuvMeSumZen]

Not finding a xf_poll table in templates. Have a poll.css, poll_bock, poll_block_result, & poll_block_vote, couldn't find a xf_poll table in any of those templates' tabs either .

 

[Paul B]

The table is in the database.

 

[LuvMeSumZen]

I cannot find it. Could you please tell me where in the database to find it?

 

[LuvMeSumZen]

Used the search function also but no joy . . .

 

[Paul B]

You need to use phpMyAdmin, click on the xf_poll table, look up the entry and set public_votes to 1.

 

[LuvMeSumZen]

Is this it, and if so is the correct place to put the 1 to the left of my arrow?

 

[Paul B]

Yes.

 

[LuvMeSumZen]

Also I do not see a "Save" function after I set the value to 1 . . . does it save automatically?

 

[LuvMeSumZen]

"Go" button is save. Thanks again for your help. How will I know when you make the addon should I add you to Follow is that the best way?