[Re opend] Who placed the vote in the poll?

[Juppertje]

Your phpBB Version: 2.0.
phpBB Type: Integramod 141
MODs: No
Your knowledge: Beginner
Board URL: [url]http://[/url]

PHP Version:
MySQL Version:


What was done before the problem appeared?
none


What was done to try to solve the problem?
none



De.scription and Message

Hello we have a joker on our forum

I want to know if it is possible to see who voted in a poll either on ip adres either on forum name

[ZacFields]

Jupper, I would be more specific but my server is currently going through some maintenance, but here is what I remember from what I can recall.

Firstly, you will need to get into your phpmyadmin to view your raw SQL tables.

Within your tables, the specific one you should be looking for is called vote_ip or something along those lines. From there, you can view the poll number (if this is the most recent poll then it will be the highest poll number) and then I believe the IP addresses themselves are actually md5 hashed, but the great thing about md5 is that if there are multiple IP's that have voted on the same poll, then you should easily be able to tell because the md5 hash will be the same. So look for the same hashed IP addresses.

With a little more sleuthing you should be able to find out who the culprit is and how many votes you need to remove from the poll (which by the way can also be done from your raw SQL tables with I think "phpbb_vote_results" or something like that.)

When my server is back up and running I'll try to correct those table names.

Zac

[Juppertje]

I hope you can explain it to me becaurse i only can find the following 3 files in mysqltable with the name vote within

phpbb_vote_desc 29 MyISAM latin1_swedish_ci 5,0 KB -
phpbb_vote_results 116 MyISAM latin1_swedish_ci 9,0 KB -
phpbb_vote_voters 409 MyISAM latin1_swedish_ci 35,0 KB -

in phpbb-Vote_voters when i go to the highest number is see:

vote_id vote_user_id vote_user_ip
35 387 5591c65f


So that must be the guy how made the last vote but i can not see the ip number but i think the tick is user id 387 must be the joker?
correct me if i am wrong


vote id of the last poll is 35


35 253 503d352a
35 2 3ec25958
35 18 5355c930
35 25 d47fa88f
35 13 559290ba
35 387 5591c65f
in bold are the users id 2 must be me he will be shocked i got him wheheheheh *Evil Grin*

txs for the help

[ZacFields]

no problem. Yes that is correct, what you have in bold is the user ID number of the user you're talking about.

Looks like I was pretty close on the tables at least. Glad to see you found what you're looking for <img>

Zac

[Juppertje]

Re opend have a new quistion abouth this item

I know now how to find the user but how do i know wich poll is wich?

How can i find the vote id number from a older poll ?

So how i know wich vote id number is conected to wwich poll everything is in numers low

Example i have a poll in topic number /viewtopic.php?t=1912 when i go to myadmin in mysql is find in topic_id 1912 but can not do anything with it i can not look for the vote id

[Juppertje]

nobody?

[sanji]

I don't really get the question... You want to know how to find which poll's results you are watching but linking them to the thread id, correct?

In the vote_desc table, you will find the following info :
vote_id - the id of the poll, which allows you to link it with the votes in the other 2 tables
topic_id - the topic_id where the poll is taking place

This should give you all needed information...

sanji

[Juppertje]

yes i have several polls on my board but some people are making a mess of it so i want to know wich user made the negative choiche


for example i have a poll


do you like thos board?

1) yes very much
2) it's okay
3) i never have seen a terrible board like this


So i want to know wich user took option 3 in this poll

So how can i find the user of this poll i can't find it i have manny poll's and have to find out wich id number is conected to wich poll
How do i know the id of each poll ??

[sanji]

As I said above, in the vote_desc table, you will find on each row the id of the poll AND the id of the topic.

You can either search the topic table to find information on the corresponding topic_id.

Or you can just check the question of the poll, which is also mentioned in the vote_desc table.

sanji

[Juppertje]

okay txs wil try it

[Juppertje]

Okay found topic_id 1912 and that is related to vote_id 39


now th hardest part from who is the 1 negative vote in topic_id 39 <img>

So now i have to find outh who choose vote_option_id 3 in Vote_id 39


and here i am stuck