Wasn't sure if it was this forum or General Hacking Discussion or what and seeing how I'm full of weird little questions for the day, heh. I took a gamble and posted it in here so if it's wrong forum my apologies to mod who has to move it.
I wanted to remove a few ip's logged into the admin cp of a certain user. So in PHPMyAdmin what would the code be for you to search through the listed members and find him in the user table which is where I believe the ip logs are listed?
Bah I prolly wasn't clear enough, I confused myself , what I'm talking about is when you use user.php and search for a user. You find and click and view his IP's then click the link to find other users that have identical IP addresses. Well I have one user that I want to remove several IP's from that way when other admins search and view the IP's of that user or try finding people that match him, because his IP's will no longer be in the database, it won't match.
UPDATE post SET ipaddress='000.00.000.00' WHERE userid='XX' AND ipaddress='123.456.789.01';
I would think something like that should work... I'm pretty sure you would want to set something as the new IP address as well since the search would probably return a bunch of blank IP addresses otherwise.
03-10-2003, 01:21 AM
Question about PHPMyAdmin
, what I'm talking about is when you use user.php and search for a user. You find and click and view his IP's then click the link to find other users that have identical IP addresses. Well I have one user that I want to remove several IP's from that way when other admins search and view the IP's of that user or try finding people that match him, because his IP's will no longer be in the database, it won't match.
Linear Mode
