View Full Version : Need help ASAP for Police Help!!!!! Are a User IP Addresses Listed Chronologically?
maoz440
02-09-2003, 01:28 PM
A user on my forum has made a very serious threat to shoot another kid at school on Monday. I am helping his local police investigate his identity. Among other things I sent the investigator a list of all IP addys the kid has used to log on. Is there a little hack or piece of code I can run to correllate a list of IP address (from a user's admin panel profile) to a list of dates? Any timely help is greatly appreciated as time is of the essence.
Thanks.
Dean C
02-09-2003, 02:33 PM
Wow it sounds very serious. Someone will help you very shortly i hope :)
- miSt
Xenon
02-09-2003, 03:04 PM
open admin/user.php find this block:
// ############################# douserid() #########################
function douserid($userid,$previpaddress,$depth=2) {
global $DB_site,$session;
$depth--;
$getusername=$DB_site->query_first("SELECT username FROM user WHERE userid=$userid");
echo "<ul>";
$ips=$DB_site->query("SELECT DISTINCT ipaddress FROM post WHERE userid=$userid AND ipaddress<>'' AND ipaddress<>'$previpaddress' ORDER BY ipaddress");
while ($ip=$DB_site->fetch_array($ips)) {
echo "<li>$ip[ipaddress] (".gethostbyaddr($ip[ipaddress]).") ".makelinkcode("find more users for this ip","user.php?s=$session[sessionhash]&action=doips&ipaddress=$ip[ipaddress]")."</li>\n";
if ($depth>0 and $ip[ipaddress]!=$previpaddress) {
doipaddress($ip[ipaddress],$userid,$depth);
}
}
echo "</ul>";
}
and change it into:
// ############################# douserid() #########################
function douserid($userid,$previpaddress,$depth=2) {
global $DB_site,$session;
$depth--;
$getusername=$DB_site->query_first("SELECT username FROM user WHERE userid=$userid");
echo "<ul>";
$ips=$DB_site->query("SELECT DISTINCT ipaddress, dateline FROM post WHERE userid=$userid AND ipaddress<>'' AND ipaddress<>'$previpaddress' ORDER BY ipaddress");
while ($ip=$DB_site->fetch_array($ips)) {
echo "<li>".date("H:i m-d-Y", $ip[dateline]). ": $ip[ipaddress] (".gethostbyaddr($ip[ipaddress]).") ".makelinkcode("find more users for this ip","user.php?s=$session[sessionhash]&action=doips&ipaddress=$ip[ipaddress]")."</li>\n";
if ($depth>0 and $ip[ipaddress]!=$previpaddress) {
doipaddress($ip[ipaddress],$userid,$depth);
}
}
echo "</ul>";
}
think this should do what ya wanted
maoz440
02-09-2003, 03:21 PM
Worked Perfectly Xenon - exactly what the inspector needed! :D Thanks so much! I'll keep you posted on what develops with this sad situation.
maoz
Dean C
02-09-2003, 03:41 PM
Xenon what does that code do btw :)?
- miSt
Xenon
02-09-2003, 03:52 PM
@maoz: glad i could help :)
@Mist: it shows the dateline near the ip when it was used..
Dean C
02-09-2003, 04:32 PM
Ahhh cool :) Thanks bud!
- miSt
Erwin
02-09-2003, 07:50 PM
That serious stuff. Hope they catch the guy.
Logik
02-10-2003, 03:51 AM
/me watches the TV show "Cops".
"A vBulletin killer on the loose!"
Xenon
02-10-2003, 12:49 PM
@Logik: i think this is a theme where you shouldn't make any fun of it...
just calm down a bit, not every thread needs your comments!
Dominick
02-10-2003, 05:41 PM
Originally posted by maoz440
A user on my forum has made a very serious threat to shoot another kid at school on Monday. I am helping his local police investigate his identity.
Thanks.
Im banning anyone under 18 from my forum...
:devious:
maoz440
02-10-2003, 07:42 PM
Xenon - thanks again for your help. :D Thought I would paste some of the inspector's email to me this morning :)
"I wanted to let you know that all your efforts to assist paid off. I put the Regional Police in touch with the family of the youth who posted those messages on your website. The investigators contacted me to let me know they were planning on attending that evening to speak to the boy and his parents.
I do not know what the final results were, however I am sure they attended and took some type of action to evaluate the situation. I will let you know more within a few days as to whether it was actually a threat or not. The matter is no longer a concern though, and we can be more relaxed regarding the kids going to school today.
Thanks again!"
A good ending to a bad situation!
Xenon
02-10-2003, 08:09 PM
yeah, really...
that's how vb admins can help the police :)
Erwin
02-10-2003, 08:30 PM
And another episode of Law and Order ends... ;)
Logik
02-10-2003, 10:14 PM
Wait.. Xenon, i just got jumped at for joking. But yet, Erwin can say a smart comment (being funny). But when i do, i get told every thread dont need my comment..
Xenon
02-11-2003, 11:03 AM
maybe you should compare when Erwin posted his comment and when you did.
Also compare what he posted and what you did.
Logik
02-11-2003, 08:50 PM
Same thing. Basically cops, both are. I mean it was a joke. Xenon just calm down bro.
Dribbles
02-11-2003, 09:19 PM
Internet threats are so common
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.