Admin View Results Of Poll

[jereece]

As the admin, can I see more details about poll results?  For example, is there a way that I can see who voted and what they voted for?

Thanks,
Jim

[[Unknown]]

Currently, no you cannot.  However, this information is stored in the database and a mod could fairly easily be made.

-[Unknown]

[jereece]

1.  Is there a way I can just read the database directly to see who voted for what choice?  If so, how?

2.  If not, how can I implement a mod to do this so that only the administrator can see all the results and who voted for what?  I have never done a mod before.

Thanks for your help.

Jim

[Bullcat Webhosting]

@ Unknown, the only thing you can see is, the member ho have vote but not the voting he has made ! ther is noting like "member_id voting_id" !

Or am i wrong ?

[[Unknown]]

ID_CHOICE in log_polls.

-[Unknown]

[jereece]

But how do I view the SQL database?  Is there a viewer?  I have never done this.

Thanks,
Jim

[Grudge]

Use a program called PHPMyAdmin which is probably installed by default. Running this query should work (Haven't tested it):

Koodi [Valitse] Laajenna


SELECT mem.realName
FROM smf_log_polls AS lp, smf_members AS mem, smf_polls AS p, smf_topics AS t
WHERE t.ID_TOPIC = 999
  AND p.ID_POLL = t.ID_POLL
  AND lp.ID_POLL = p.ID_POLL
  AND mem.ID_MEMBER = lp.ID_MEMBER


Where 999 is the topic ID that the poll is attached to (The ID appears in the URL of the topic after "topic=")

[jereece]

You said "Use a program called PHPMyAdmin which is probably installed by default."  If this is somethign my web host installed on the web server, how do I launch the program?  Do I go to www.mywebsite.com/phpmyadmin.php or something like that?

Sorry for being so elementary, but I have never done this before.

Thanks,
Jim

[sportman3333333]

go to your control panel and you should see a phpmyadmin link. Click on it and go to your database. You can find your imformation there

[[Unknown]]

What is phpMyAdmin?

-[Unknown]