Is there any way to clean the ip history of an admin? I have about 1000 ip's showing over the past two years becasue of a dial up connection and am trying to do some house cleaning. Thanks in advance.
Announcement
Collapse
No announcement yet.
Clear IP History
Collapse
X
-
Originally posted by nhlratIs there any way to clean the ip history of an admin? I have about 1000 ip's showing over the past two years becasue of a dial up connection and am trying to do some house cleaning. Thanks in advance.
but would be interested to know
-
Originally posted by nhlratRight, I was think maybe some query that could be run, but wasn't sure either.
I think running these queries will sort all those IPs:-
UPDATE adminlog SET ipaddress = {your ip address} WHERE userid = {your userid}
UPDATE post SET ipaddress = {your ip address} WHERE userid = {your userid}
UPDATE search SET ipaddress = {your ip address} WHERE userid = {your userid}
UPDATE user SET ipaddress = {your ip address} WHERE userid = {your userid}
The usual rule: Backup your db first!
Comment
-
In the admin log or in posts...?"63,000 bugs in the code, 63,000 bugs, you get 1 whacked with a service pack, now there's 63,005 bugs in the code."
"Before you critisize someone, walk a mile in their shoes. That way, when you critisize them, you're a mile away and you have their shoes."
Utopia Software - Current Software: Utopia News Pro (news management system)
Comment
-
Originally posted by CeleronXTIn the admin log or in posts...?
Comment
-
Originally posted by nhlratI guess I meant in the Admin log, but understand that will effect the ip's in the posts i've made as well, which is no big deal I just wasn't sure how do go about it. I haven't tried the suggestion in the post above yet though.
Thank you.
Originally posted by vBRUPDATE adminlog SET ipaddress = {your ip address} WHERE userid = {your userid}
UPDATE post SET ipaddress = {your ip address} WHERE userid = {your userid}
UPDATE search SET ipaddress = {your ip address} WHERE userid = {your userid}
UPDATE user SET ipaddress = {your ip address} WHERE userid = {your userid}
Comment
-
Anyone else try this? Here's what I get when trying any of them.
Database error in vBulletin Control Panel 2.2.9:
Invalid SQL: UPDATE search SET ipaddress = 123.456.789 WHERE userid = myadminaccount
mysql error: You have an error in your SQL syntax near '.789 WHERE userid = myadminacount
' at line 1
mysql error number: 1064
Comment
-
Originally posted by nhlratAnyone else try this? Here's what I get when trying any of them.
Database error in vBulletin Control Panel 2.2.9:
Invalid SQL: UPDATE search SET ipaddress = 123.456.789 WHERE userid = myadminaccount
mysql error: You have an error in your SQL syntax near '.789 WHERE userid = myadminacount
' at line 1
mysql error number: 1064
e.g. 123.456.789 = '123.456.789'
Comment
-
The error would have to be a little different. Post the exact error.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Originally posted by Steve MacholThe error would have to be a little different. Post the exact error.
Comment
-
Originally posted by vBRI found another table with an ipaddress column - threadrate.
UPDATE threadrate SET ipaddress = {your ip address} WHERE userid = {your userid}
Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment