Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Store IPv4 and IPv6 address along with user votes #18

Open
mice-sk opened this issue Jun 20, 2012 · 1 comment
Open

Store IPv4 and IPv6 address along with user votes #18

mice-sk opened this issue Jun 20, 2012 · 1 comment
Milestone

Comments

@mice-sk
Copy link
Contributor

mice-sk commented Jun 20, 2012

We need to store IP addresses of users who vote in the poll (regardless if anonymous or authenticated users) in order to provide means to detect automated voting bots.

On top of storing IPv4 addresses, propose that we implement IPv6 support right from the start.

@teo-sk
Copy link
Contributor

teo-sk commented Jul 18, 2012

This still needs to be enhanced by storing IP addresses as int/long data types, and by storing either both IPv4 and IPv6 as separate columns (need to fill the correct column after input validation) or by converting IPv4 to IPv6

References:
http://php.net/manual/en/function.inet-pton.php
http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_inet-aton
https://groups.google.com/forum/?fromgroups#!topic/doctrine-user/07mBafTJtTM

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants