Change IP addresses

[danielc2384]

Just wondering if it was at all possible to change the IP address of forum members.
(Just on the forum of course).

Thanks

[KURTZ]

have you tried to change it onto the 'user management'? what happens?

[veenuisthebest]

yes, you can change the IP with which they registered from the user profile in admincp.

go to Users->search->IP Address->change it and save.

But, why would you do this ??

[KURTZ]

But, why would you do this ??

i'm also interested in this ... :p

[veenuisthebest]

okkk...

just found it to be quite easy if you'd like to do in bulk

1. open your database through phpmyadmin OR sqlyog.
2. simply edit the values in ipaddress column in user table

or you may run query as well.

[KURTZ]

yes, also you can go to

acp --> users ---> search for user ---> then edit the IP

[veenuisthebest]

yes, also you can go to

acp --> users ---> search for user ---> then edit the IP

oh yes that works. post 3 says the same.

[geevest.com]

this is automaticaly can change all ip address post/thread for users?

[Opserty]

You can execute SQL queries if you are comfortable doing so:

UPDATE search SET ipaddress = 0
UPDATE user SET ipaddress = 0
UPDATE post SET ipaddress = 0

Though, you do so at your own risk, remember to edit in the table prefix if you have one. Also to turn off IP logging:

AdminCP > vBulletin Options > Message Posting and Editing Options > Log IP Addresses

[geevest.com]

so for replace all ip post/thread username.before we work in sql queries.we must turn off log ip address,and then after sql query done.we need reactive log ip address again?

[Opserty]

Turn off "log ip address" to stop the IP address from being logged when someone makes a new Post. It should remain off if you do not want it to log ip address it will not affect the SQL queries.