IP

[Blisk]

Your phpBB Version: 2.0.
Your phpBB Type: Standard phpBB (also called Vanilla)
MODs: No
Your knowledge: Beginner
Boardlink: [url]http://[/url]

PHP Version:
MySQL Version:


What have you done before the problem was there?



What have you already tryed to solve the problem?




Description and Message

How to delete IP from certain user out from MYSQL database.
I don't want to some other administrators to see IP.

[oxpus]

The IP is needed to make the session managemant working.
Where shall the IP not be displayed?
And why you will hide IP's for other Admins? An Admin should be do anything, not only less as you (expect accessing directly the database)

[Blisk]

I will one forum give away to others and don't want them to see my and some one more IP's, because I don't want them to use that IP against me, most likely that will not happend, but anyway I don't know them.
So I don't want to erase all my post, just delete IPs.

[oxpus]

To hide you on the inet, it's not enough to delete your IP from your forum tables.
If an Admin will attack you, he can catch the IP from several points. The forum is one from many...

[Blisk]

I know that I just want to delete IP from posts I already post on forum, before i give it away.
After that I will not post anymore on that forum.

[oxpus]

Hm, then just look on posts table for this field and delete the content:

Code: Alles auswählen

UPDATE phpbb_posts SET poster_id = '' WHERE poster_id = X;

"X" will be your user_id. If you will be the main admin it is "2".

[Blisk]

TNX, I did that, but all posts are now gone, I didn't want that.
but now it is like it is.
Maybe there is a way to change IP to some xxx numbers and leave the posts.

[oxpus]

Change them to "7F000001". This means the IP 127.0.0.1 (localhost).

[Blisk]

[quote="oxpus - Tue 07.Jun, 2005 12:46";p="34687"]Change them to "7F000001". This means the IP 127.0.0.1 (localhost).[/quote]

where, I was looking for that to change IP but didn't find it.
Can I do with all post in once.

[oxpus]

Look on my post #6

[Blisk]

didn't worked it deleted all my posts.

Code: Alles auswählen

UPDATE phpbb_posts SET poster_id = '7F000001' WHERE poster_id = 2;

[oxpus]

Oh, sorry!
This will be right:

Code: Alles auswählen

UPDATE phpbb_posts SET poster_ip = '7F000001' WHERE poster_id = 2;

Regard the first is poster_ip!

[Blisk]

ok, now I laready did what I did, there are no more posts from me.