To change all IP numbers of a single user

[ged]

How can I do that? Can you write a query for this?

Thanks a lot...

[borbole]

Originally Posted by ged

How can I do that? Can you write a query for this?

Thanks a lot...

To change it in posts? First make a backup of your post table, then run the following query at phpmyadmin:

UPDATE post
        SET ipaddress = 'xxxxxxx'
        WHERE userid = x;

Replace x with the uid of the user whose ip you want to change and xxxxxxx with the new IP address that you want that user to have instead of his/her real ip. And if your db tables have a prefix you should apend it next to the table name at the query above. Hope it helps.

[ged]

Thank you very much...

[borbole]

Originally Posted by ged

Thank you very much...

You are welcome

[keyness]

In which tables Ip addresses are being saved?

1) "User" table - I think this was the Ip address of registration
2) "Post" table - For every post's Ip address

But what more? For example, I do login and then logoff without an action. Or I just give a like, thanks etc.

[kh99]

Originally Posted by keyness

For example, I do login and then logoff without an action. Or I just give a like, thanks etc.

I believe ip addresses are only saved on registration and when you post, so those other actions would not log the ip (although in an emergency you might be able to figure it out from the web server logs).

[keyness]

Hmm so, we can not detect a clone which used different registration Ip unless he/she posts.

I used to think every login's Ip is being stored.

Thank you very much.

[kh99]

Well, the ip address for the current session is saved in the session table so you could compare that to other ip addresses, but you'd have to do it while the session was active.

[Bob_R]

Since PHP and MySQL have been updated in the last 2 years post #2 in this thread doesn't work.

It asked me to select at least 1 column/row (or something like that)

What is the way to do it now?

Thanks!

[Lynne]

That query is still correct. Make sure if you use a table prefix that you add that to the beginning of the table name.