Finding IP adresses

[Xyphon]

To IP ban people, how would I go about finding their IP? Thanks.

[mfindlay]

$ip = $_SERVER['REMOTE_ADDR'];

 

cheers...

[VirusDoctor]

Ofcourse the above is pretty useless if the user is using proxies, all he would have to do is change the proxy and they will no longer be banned.

[Xyphon]

No, no! I dont want to know how to do IP ban, I already know that. I want a way to track my users IPs, so I CAN ban them!

[VirusDoctor]

lol ok...

 

Here's how I do it, in my login page, I have it update a users ip each time they login.

 

Create a new column in your users table called user_ip

 

then just do something like this in your login page

 

$User_IP = $_SERVER['REMOTE_ADDR'];

 

$IP = mysql_query (UPDATE users SET user_ip='$User_IP' WHERE username = '$username'")

 

Hope that helps

[Xyphon]

If I do that I'll lose all of my members. Thats not good.

 

 

I tihnk I should create a brand new table called IP, so I dont have to reset all fo my mems.

[adam291086]

why would you lose all of your member? you are only update one column in your table.

[trq]

If I do that I'll lose all of my members.

 

How?

[VirusDoctor]

lol Adam, thats what I was just about to ask.

[Xyphon]

O.O I mean. You have to drop a table to recreate it, how can I add a table?

[trq]

You dont have to drop any tables. Use ALTER TABLE.

[Xyphon]

Oh, thanks.

[Xyphon]

So like

 

ALTER TABLE users ADD user_ip VARCHAR(225);

[VirusDoctor]

The simple way to do it would be to go into phpmyadmin and add the column to the table manually.

 

Then just use the code I provided above.

 

You dont even need to use ALTER then.

[trq]

Yeah, exactly like that except you'll want to use INT UNSIGNED. See here for a simple tutorial on storing ip addresses.