The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
![]()
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? |
#2
|
|||
|
|||
![]()
The table is adminlog
|
#3
|
|||
|
|||
![]()
Or:
[sql] DELETE FROM adminlog WHERE ipaddress = "1.2.3.4"; [/sql] |
#4
|
||||
|
||||
![]()
Bah I prolly wasn't clear enough, I confused myself
![]() |
#5
|
|||
|
|||
![]()
Sounds like an interesting idea TheMayhem, good luck in trying it. You may find it to be more trouble than it's actually worth.
![]() |
#6
|
|||
|
|||
![]()
other user ip's are saved in the post table
![]() |
#7
|
||||
|
||||
![]()
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. ![]() |
![]() |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|