How to realize ip check?

General PHP Help
#1

Hello,
Can someone help me realize this little trick?
I would like accounts using more than 3 different ips to get a warning and/or disabled for 24hrs.
I know the mysql part to do but i cant figure out the ‘if’ for php part

#2

Each login log their IP address and the time.

#3

I dont understand. I have $ip variable and $row[‘ip’]

#4

then store it in a database and make any check you want with SQL.

#5

What don’t you understand?

User attempts to log in:
    is the account locked? 
        No -> 
            - log IP and date
            - allow user to proceed
        Yes ->
            - Is the lock timestamp more than 24 hours ago? 
                Yes ->
                    - Unlock account
                    - Allow user to proceed
                No ->
                    - Do not allow user access
                    - Display user message
1 Like
#6

What i dont understand and know is how to begin with the code

#7

I would have it call the methods from the login code.

#8

If i cant see some little snippet i wouldn’t be able to figure it out… Im not that expert for this

#9

Are you interested in investing quite a a lot time learning how to program or are you only after a quick fix for this script? If it’s the latter then I’d suggest to pay someone to fix it for you.

3 Likes
#10

Well i want to learn while fixing it.

#11

I told you the flow, and what steps there would be for the decision structures. So, code something that meets them.

#12
  1. Im on mobile in another country
  2. If I would’ve know how i wouldn’t post in the beginner’s topic
  3. I understand the flow, but dont understand how to do it, even how to start.
#13

Do you have a login process now? Or does everything need to be written?

#14

Yes i have, and yes it stores current ip used by acct

#15

Then that is where you want to add the additional functionality.

I think you are over thinking things and that is making them more complicated than they really are.

#16

Well I’ve tried but cant figure out what to use so that the check will see last 3 ips used by acct and at the 4th one to get flagged/disabled

#17

A SQL query. I will warn you though, that the idea that only three lP’s would create an issue for several users. ISP’s switch user IPs regularly, and if I were to access your site from home, work, and my phone, there are no telling how many IP’s would be generated in a weeks period.

1 Like
#18

Well… I know that. But i cant do anything about it… I need to prevent this somehow… Ppl keep giving accounts to others and I don’t like this

#19

Do multiple people use the same account at the same time? If so I’d consider doing something like spotify and only allowing connections from one device at a time. This would annoy the real account owner and put them off sharing accounts.

2 Likes
#20

I had thought at this query and wrote it down in my mobile notepad…
https://pastebin.com/T1pi373j
Now i cant figure out how to do the IF clause to check for x number ips and to execute another query…
Maybe should be like…?
If $rowd[‘ipd’] >= 3 {
Another query here to update users table and to punish the user in question
}

Sponsor our Newsletter | Privacy Policy | Terms of Service