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
Currently, no you cannot. However, this information is stored in the database and a mod could fairly easily be made.
-[Unknown]
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
@ 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 ?
ID_CHOICE in log_polls.
-[Unknown]
But how do I view the SQL database? Is there a viewer? I have never done this.
Thanks,
Jim
Use a program called PHPMyAdmin which is probably installed by default. Running this query should work (Haven't tested it):
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=")
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
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 :)
What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
-[Unknown]