|
Joined: Mar 2000
Posts: 180
Member
|
Member
Joined: Mar 2000
Posts: 180 |
We've had the unfortunate experience of having a bad user show up on our board, that we are currently taking legal actions against regarding some Ebay auctions and some trademark/copyright infringements. Anyway, this user has been posting some stuff on our board, using multiple usernames of course, and I'm trying to get as many of his "names" as possible.
He's on a cable modem in Canada, so his IP is static, which I managed to notice just from following the threads, and then running the IP. But, he's also using his AOL account (cheap anonymizer?!), so searching the IP is gonna be a little trickier.
Now, to my question: I tried searching his static IP from the Admin area under the registration IP but it won't pull anything up, even though I know there are some present. Also, I've noticed problems when trying to search email addresses and such. The search/edit thing doesn't seem to always work correctly or smoothly...is there a way to do these searches directly through mySQL? Will it net the same results? Also, any tips/ideas on hunting this guy down on our site?
Anyone know anything about business law...
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
You can do queries like this: SELECT * FROM w3t_Users WHERE U_RegIP='1.2.3.4' SELECT * FROM w3t_Users WHERE U_RegIP LIKE '1.2.%' (% matches any string) Recent versions of phpMyAdmin have a global search function, which can easily search multiple columns across multiple tables for a specified string. It's probably rather I/O-intensive, but it can be handy if you're looking for something and don't want to spend the time to construct precise queries.
|
|
|
|
Joined: Mar 2000
Posts: 180
Member
|
Member
Joined: Mar 2000
Posts: 180 |
Thanks for the reply! Now, is there a way to find posts made from a certian IP address?
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Also....Lisa P's mod here. Has a nifty function... you can see all the IP addresses that a user has used.
|
|
|
|
Joined: Oct 2002
Posts: 18
Newbie
|
Newbie
Joined: Oct 2002
Posts: 18 |
Try this MySql search: SELECT * FROM w3t_Posts WHERE B_IP LIKE '1.2%' KLB www.sbhonline.com
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 417
Joined: November 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|