vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Change IP addresses (https://vborg.vbsupport.ru/showthread.php?t=181210)

danielc2384 06-01-2008 02:27 PM

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

Thanks

KURTZ 06-01-2008 02:30 PM

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

veenuisthebest 06-01-2008 02:30 PM

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 06-01-2008 02:33 PM

Quote:

Originally Posted by veenuisthebest (Post 1537916)
But, why would you do this ??

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

veenuisthebest 06-01-2008 02:37 PM

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 06-01-2008 02:40 PM

yes, also you can go to

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

veenuisthebest 06-01-2008 02:44 PM

Quote:

Originally Posted by KURTZ (Post 1537928)
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 06-03-2008 11:19 AM

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

Opserty 06-03-2008 11:36 AM

You can execute SQL queries if you are comfortable doing so:
[sql]
UPDATE search SET ipaddress = 0
UPDATE user SET ipaddress = 0
UPDATE post SET ipaddress = 0
[/sql]
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 06-04-2008 09:14 AM

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 06-04-2008 10:18 AM

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.


All times are GMT. The time now is 09:22 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01449 seconds
  • Memory Usage 1,725KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (11)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete