| Author |
 Topic  |
|
|
kolucoms6
Average Member
845 Posts |
 Posted - 06 April 2007 : 07:21:49
|
How to limit one sign up per unique IP ? |
|
|
PPSSWeb
Junior Member
312 Posts |
Posted - 06 April 2007 : 09:04:53
|
If you do this, you may end up excluding potential members.
If you chose to continue, in register.asp you would have to capture the users IP and compare it to the results for M_IP in the members database. The following should give you a start.
strSql = "SELECT M_IP FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_IP = '" & Request.ServerVariables("REMOTE_ADDR") &"'"
set rs = my_Conn.Execute(TopSQL(strSql,1))
if rs.BOF and rs.EOF then
'## Do Nothing
else
Err_Msg = Err_Msg & "<li>IP Address already in use</li>"
end if
set rs = nothing
|
 |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 April 2007 : 09:14:14
|
Like PPSSWeb hinted at, this may not be the best idea.... and for several reasons:
- There are still a lot of homes that only have one computer, but multiple users (not just families, but dorms too).
- There are still a lot of poor souls on dial-up - at which point their IP address will likely not be the same every time. And while it is statistically unlikely, a potential member could get the IP of an existing member.
- Even broadband IPs change...
- Some companies are stupid (*ahem* AOL) and put a large number of their subscribers behind a proxy - which means that by your scheme, only one person behind the proxy could become a member.
And these are just the ones I can come up with off the top of my head.... and on the 2nd cup of coffee!
What exactly is your end-goal? I ask because there may be a different/less risky way to go about it.
(Edited to correct a stupid but contextually important typo...) |
Edited by - AnonJr on 06 April 2007 09:15:39 |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 06 April 2007 : 09:39:53
|
quote:
Originally posted by AnonJr
(Edited to correct a stupid but contextually important typo...)
Did you have to remove the 'RSEH' and 'ES', by any chance? ;-) |
|
|
|
PPSSWeb
Junior Member
312 Posts |
Posted - 06 April 2007 : 09:41:02
|
quote:
Originally posted by AnonJr
Like PPSSWeb hinted at, this may not be the best idea....
Yeah, what he said. I hadn't had my coffee yet, so listing the reasons was not a top priority.  |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 April 2007 : 09:47:32
|
quote:
Originally posted by pdrg
quote:
Originally posted by AnonJr
(Edited to correct a stupid but contextually important typo...)
Did you have to remove the 'RSEH' and 'ES', by any chance? ;-)
... lost me on that one ... sounds like its time for the third cup.  |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 06 April 2007 : 10:23:19
|
| It'll take some working at, so do important stuff first and let this one pass... :-) |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 06 April 2007 : 11:27:56
|
As I have found multiple users signed up , but same IP.
Later when I checked the database, I found same user signed with 2-3 emailids. |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 April 2007 : 11:43:52
|
How do you know its the same user? It could be 3 people in a dorm/apartment that share the same computer...
Don't get me wrong, red flags are going up and I'm starting to think of spammers and/or trouble-makers... but with e-mail validation, requiring extra fields and/or a super-secret hidden field, and a few other things will keep the spammers at bay. The "Pending Member Profile" MOD up on www.snitzbitz.com has helped me weed these folks out as they tend to be blatantly obvious (Gender of "1"?!?).
As for the trouble-makers, that's a thornier issue as, once again, how do you prove its really the same person as opposed to two or more people sharing a computer or a block of users behind the same proxy? See if they cause trouble and lock 'em out the second they do. =/ Not ideal, but if you bring the hammer down swiftly and get the help of some good Moderators, it tends to cut down on that sort of thing.  |
|
|
|
PPSSWeb
Junior Member
312 Posts |
Posted - 06 April 2007 : 12:21:56
|
| I agree, I think this type of restriction could only work well in a closed environment with static IP assignment. I would consider other options as this one may backfire on you in the long run. |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 06 April 2007 : 12:31:23
|
| Like annon was explaining but everyone at my work is on the same IP address. So basically if someone signed up from here not one other of the other 150 emplyees could sign up. |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 06 April 2007 : 15:21:13
|
:-)
Thanks a lot for your guidance.
I noticed that from same IP, same person signed up but with three different emailids (though We do not PAY for sign up ;) )
|
|
|
| |
Topic |
|
Topic Locked
